c#总结笔记

笔记一：

StringBuilder 使用方法：

   StringBuilder sqlStr2 = new StringBuilder("insert into SCOREWENANNEWLOG(SCOREID,EMPLOYEEID,SCOREEMPID,YEWUNENGLI,FUWUTAIDU,FUWUXIAOLV,GOUTONGNENGLI,FWZHUDONGXING, YEWUNENGLI_REMARK,FUWUTAIDU_REMARK,FUWUXIAOLV_REMARK,GOUTONGNENGLI_REMARK,FWZHUDONGXING_REMARK,TYPE,SCOREDATE,CONFIGID) values( ");
                        sqlStr2.AppendFormat("'{0}',lpad('{1}',6,'0'),", ScoreId, EmployeeID);
                        sqlStr2.AppendFormat("lpad('{0}',6,'0'),{1},{2},", ScoreEmpID, YeWuNengLi, FuWuTaiDu);
                        sqlStr2.AppendFormat("{0},{1},{2},", FuWuXiaoLv, GouTongNengLi, FuWuZhuDongLi);
                        sqlStr2.AppendFormat("'{0}','{1}','{2}','{3}','{4}',", YeWuNengLiBz, FuWuTaiDuBz, FuWuXiaoLvBz, GouTongNengLiBz, FuWuZhuDongLiBz);
                        sqlStr2.AppendFormat("'{0}',", type);
                        sqlStr2.AppendFormat("to_timestamp('{0}','yyyy-mm-dd hh24:mi:ssxff'),", DateTime.Now);
                        sqlStr2.AppendFormat("{0}", configID);
                        sqlStr2.AppendFormat(")");

备注：
1>如果数据库中的字段是varchar类型时，在StringBuilder 对象AppendFormat（）方法中，占位符是要加‘’ 单引号；

2> lpad用法  lpad(字段名,填充长度,填充的字符)  例如 方法: sqlStr2.AppendFormat("'{0}',lpad('{1}',6,'0'),", ScoreId, EmployeeID);

笔记二：

在BasePage公共访问方法中 ， 提示信息

 protected void MessageBoxJQuery(string message)
  {
       this.ClientScript.RegisterStartupScript(this.GetType(), "message", "<script language='javascript' defer>jQuery().ready(function(){alert('" + message + "') });</script>");
  }

备注：

3>前台方法调用MessageBoxJQuery（“登陆成功！”）;

笔记三：

后台判断时，进行跳转的页面方法,  Response.Redirect(http://cims.jjl.cn/Pages/Evaluation/tishiyemian.aspx?type=1);

笔记四：