Example #1
0
 //周报提交控制
 private void Zbtjkz()
 {
     string sqlSelect = " select * from hyc_Tabletjjzr order by hyc_pxh desc ";
     string lsTjjzd = "";
     HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
     DataTable dt = Hyoa_global.GetDataTable(sqlSelect);
     if (dt.Rows.Count > 0)
     {
         lsTjjzd = dt.Rows[0]["hyc_tjjzd"].ToString();
         if (lsTjjzd.Contains("-"))
         {
             lsTjjzd = lsTjjzd.Replace("-", "");
             //更改字段属性
             sqlSelect = " update hyt_flowfield set hy_onclick='WdatePicker({isShowWeek:true,readOnly:true,minDate:''%y-%M-{%d}'',onpicked:function() {$dp.$(''gzzq'').value=$dp.cal.getP(''W'',''WW'');}});hymainajax_getzbjd();' where id='3e062916-45e1-4490-95c5-866a73337991' and hy_tableid='Tablezbgl' ";
         }
         else if (lsTjjzd.Contains("+"))
         {
             lsTjjzd = lsTjjzd.Replace("+", "");
             //更改字段属性
             sqlSelect = " update hyt_flowfield set hy_onclick='WdatePicker({isShowWeek:true,readOnly:true,minDate:''%y-%M-{%d-" + lsTjjzd + "}'',onpicked:function() {$dp.$(''gzzq'').value=$dp.cal.getP(''W'',''WW'');}});hymainajax_getzbjd();' where id='3e062916-45e1-4490-95c5-866a73337991' and hy_tableid='Tablezbgl' ";
         }
         else
         {
             Response.Write("<script>alert('对不起,周报提交截至点填写有误,请联系管理员!');</script>");
         }
         Hyoa_global.ExcuteSQL_BASE(sqlSelect);
     }
     else
     {
         Response.Write("<script>alert('对不起,周报提交截至点未维护,请联系管理员!');</script>");
     }
 }