城杆

      /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(string QT_NO, string PRD_NO)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1)  as gets from   OP_QT_ITM_TempOrderBy  ");
            strSql.Append(" where QT_NO=@QT_NO and PRD_NO=@PRD_NO ");

            SqlParameter[] parameters = {
                    new SqlParameter("@QT_NO", SqlDbType.VarChar,50),
                    new SqlParameter("@PRD_NO", SqlDbType.VarChar,50)};
            parameters[0].Value = QT_NO;
            parameters[1].Value = PRD_NO;

            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);



            if (ds.Tables[0].Rows.Count > 0)
            {

                if (int.Parse(ds.Tables[0].Rows[0]["gets"].ToString()) > 0)
                {
                    return true;
                }

                else
                {

                    return false;
                }
                
                
            }
            else
            {
                return false;

            }
        }

  /// <summary>
    /// 是否存在该记录
    /// </summary>
    public bool Exists(string QT_NO,string PRD_NO)
    {
      StringBuilder strSql=new StringBuilder();
      strSql.Append("select count(1) from OP_QT_ITM_TempOrderBy");
      strSql.Append(" where QT_NO=@QT_NO and PRD_NO=@PRD_NO ");

      SqlParameter[] parameters = {
          new SqlParameter("@QT_NO", SqlDbType.VarChar,50),
          new SqlParameter("@PRD_NO", SqlDbType.VarChar,50)};
      parameters[0].Value = QT_NO;
      parameters[1].Value = PRD_NO;

      return DbHelperSQL.Exists(strSql.ToString(),parameters);
    }

  public DataSet GetPrice(string prdno, DateTime datetime, string shwotop1)
        {


            SqlParameter[] parameter ={
                new SqlParameter("@PrdtNO",SqlDbType.VarChar,7),
                new SqlParameter("@DATETIME",SqlDbType.DateTime,10),
                new SqlParameter("@TOP1",SqlDbType.VarChar,1)
            };
            parameter[0].Value = prdno;
            parameter[1].Value = datetime;
            parameter[2].Value = shwotop1;

            return DbHelperSQL.RunProcedure("sp_OP_Prdt_Alert查產品報價提示", parameter,"sp_alert");
        }

  QST qst = new QST();
    protected void Page_Load(object sender, EventArgs e)
    {
        DateTime dtte = Convert.ToDateTime("2003-04-01");
        this.GridView1.DataSource = qst.GetPrice("2020044", dtte, "");
        this.GridView1.DataBind();
    }

function checkallbox(the_form,inp, do_check) {
    var elts = (typeof(document.forms[the_form].elements[inp]) != 'undefined')
                  ? document.forms[the_form].elements[inp]
                  : (typeof(document.forms[the_form].elements[inp]) != 'undefined')
          ? document.forms[the_form].elements[inp]
          : document.forms[the_form].elements[inp];  

    if (elts) {
    var elts_cnt  = (typeof(elts.length) != 'undefined')
                  ? elts.length
                  : 0;
    if (elts_cnt) {
      for (var i = 0; i < elts_cnt; i++) {
        elts[i].checked = do_check;
      }
    } else {
      elts.checked  = do_check;
    }
  }

  //return true;
}

<a href="javascript:checkallbox('delform','delid','checked')">全选</a> | <a href="javascript:checkallbox('delform','delid','');">取消全选</a>

SELECT
INFORMATION_SCHEMA.COLUMNS.*,
COL_LENGTH('weborder', INFORMATION_SCHEMA.COLUMNS.COLUMN_NAME) AS COLUMN_LENGTH,
COLUMNPROPERTY(OBJECT_ID('weborder'), INFORMATION_SCHEMA.COLUMNS.COLUMN_NAME, 'IsComputed') AS IsComputed,
COLUMNPROPERTY(OBJECT_ID('weborder'), INFORMATION_SCHEMA.COLUMNS.COLUMN_NAME, 'IsIdentity') AS IsIdentity,
COLUMNPROPERTY(OBJECT_ID('weborder'), INFORMATION_SCHEMA.COLUMNS.COLUMN_NAME, 'IsRowGuidCol') AS IsRowGuidCol,
ExtendedProperties.Value AS ProgrammaticAlias
FROM
INFORMATION_SCHEMA.COLUMNS
LEFT JOIN ::fn_listextendedproperty('ProgrammaticAlias', 'user', 'dbo', 'table', 'weborder', 'column', default) AS ExtendedProperties

ON INFORMATION_SCHEMA.COLUMNS.COLUMN_NAME = ExtendedProperties.objName COLLATE Chinese_PRC_CI_AS
WHERE
INFORMATION_SCHEMA.COLUMNS.TABLE_NAME = 'weborder'

window.onload=function(){
var w1=document.getElementById("wrapper");
var w2=document.getElementById("wrapper1");
var w3=document.getElementById("wrapper2");
var w4=document.getElementById("wrapper3");

  
  
  var dl_1=w1.getElementsByTagName("dl");
  //alert(dl_1.length);
  if(dl_1.length<1) return false;
  for(var i=0;i<dl_1.length;i++){
    //初始化，让第一个类为over
    if(dl_1[i].className.indexOf("over")==-1){
      dl_1[0].className="over";
      
    }
    //遍历循环，模拟:hover伪类
    dl_1[i].onmouseover=function(){
      for(var j=0;j<dl_1.length;j++){
        dl_1[j].className="";
      }
      this.className="over";
    }
  }

HTML Tags
<!-->
<!DOCTYPE>
<a>
<abbr>
<acronym>
<address>
<applet>
<area>
<b>
<base>
<basefont>
<bdo>
<big>

.cls6_1,.cls5_1{margin-left:8px;}

<!--[if IE]>
<style type="text/css">
.cls6_1,.cls5_1{margin-left:5px;zoom:1;}
.cls5_2{margin-left:298px;margin-right:254px;zomm:1;}
.cls6_2,.cls5_3{margin-right:5px;zoom:1;}
</style>
<![endif]-->