protected void Page_Load(object sender, EventArgs e) { _lotno = Request.QueryString["lotno"].ToString(); _para = Request.QueryString["para"].ToString(); if (Request.QueryString["workshop"] != null) { _workshop = Request.QueryString["workshop"].ToString(); } if (Request.QueryString["needno"] != null) { _needno = Request.QueryString["needno"].ToString(); } if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); _emp = lu.WorkCode + lu.UserName; //_emp = "02432何桂勤"; GetData(_lotno, lu.WorkCode); }
protected void btnStart_Click(object sender, EventArgs e) { MES.Model.MES_SB_WX m = new MES.Model.MES_SB_WX(); string wx_dh = Request["dh"]; //txtHidden.Value = wx_dh; m.wx_dh = wx_dh; m.wx_begin_date = DateTime.Now; m.wx_banbie = ""; //txtBanBie.Value; m.wx_banzhu = ""; //txtBanZu.Value; m.wx_gonghao = WeiXin.GetCookie("workcode"); //dropWXGongHao.SelectedValue; m.wx_name = ((LoginUser)WeiXin.GetJsonCookie()).UserName; m.p_status = "维修中"; MES.DAL.MES_SB_WX dal = new MES.DAL.MES_SB_WX(); try { if (DbHelperSQL.GetSingle("select count(1) from MES.[dbo].[MES_SB_wx] where wx_dh='" + wx_dh + "'").ToString() == "0") { int result = dal.Add(m);//因经常出现资料未插入事件 Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", @"alert('接修成功.');self.location='BXMonitor.aspx'; ", true); } } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", @"layer.alert('失败,请重试.[ex:" + ex.Message + "]'); ", true); } finally { } }
protected void Page_Load(object sender, EventArgs e) { _workshop = Request.QueryString["workshop"].ToString(); if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>layer.alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } _workorder = Request.QueryString["workorder"].ToString(); _workorder_f = Request.QueryString["workorder_f"].ToString(); if (!IsPostBack) { LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); emp_code_name.Text = lu.WorkCode + lu.UserName; domain.Text = lu.Domain; //emp_code_name.Text = "02432何桂勤"; //domain.Text = "200"; workorder.Text = _workorder; workorder_f.Text = _workorder_f; init_data(_workorder, _workorder_f); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["formno"] != null) { _formno = Request.QueryString["formno"].ToString(); } if (Request.QueryString["stepid"] != null) { _stepid = Request.QueryString["stepid"].ToString(); } if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>layer.alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } if (!IsPostBack) { LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); emp_code_name.Text = lu.WorkCode + lu.UserName; //emp_code_name.Text = "02432何桂勤"; formno.Text = _formno; stepid.Text = _stepid; if (_formno != "") { init_data(_formno, _stepid); } } }
public string uri; //url protected void Page_Load(object sender, EventArgs e) { _workshop = Request.QueryString["workshop"].ToString(); if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>layer.alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } if (!IsPostBack) { LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); emp_code_name.Text = lu.WorkCode + lu.UserName; //emp_code_name.Text = "02432何桂勤"; bind_pgino(); bind_source(""); timestamp = DateTime.Now.Ticks.ToString().Substring(0, 10); noncestr = new Random().Next(10000).ToString(); uri = Request.Url.ToString().Replace("#", "").Replace(WeiXin.Port, ""); //本地地址 string entAccessTicket = WeiXin.GetEntAccessToken(); //企业AccessTicket ent_ticket = WeiXin.GetEntJsapi_Ticket(entAccessTicket); ent_signature = WeiXin.GetSignature(ent_ticket, noncestr, timestamp, uri); //企业签名 } }
protected void Page_Load(object sender, EventArgs e) { _workshop = Request.QueryString["workshop"].ToString(); // "四车间"; _dh = Request.QueryString["dh"].ToString(); //"W1497589"; dt_append = new DataTable(); dt_append.Columns.Add("sku"); dt_append.Columns.Add("lot_no"); dt_append.Columns.Add("need_off_qty"); dt_append.Columns.Add("need_no"); dt_append.Columns.Add("idno"); dt_append.Columns.Add("ps_qty_per"); if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } if (!IsPostBack) { ViewState["STEPVALUE"] = ""; LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); txt_emp.Text = lu.WorkCode; txt_dh.Text = _dh; ShowValue(txt_emp.Text); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { wxuserid.Text = WeiXin.GetCookie("userid"); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["workshop"] != null) { _workshop = Request.QueryString["workshop"].ToString(); } if (Request.QueryString["dh"] != null) { _dh = Request.QueryString["dh"].ToString(); } if (Request.QueryString["ck"] != null) { _ck = Request.QueryString["ck"].ToString(); } if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>layer.alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } if (!IsPostBack) { LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); emp_code_name.Text = lu.WorkCode + lu.UserName; //emp_code_name.Text = "02432何桂勤"; } GetData(); }
protected void Page_Load(object sender, EventArgs e) { if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } GetData(); }
protected void Page_Load(object sender, EventArgs e) { /* * string year = DateTime.Now.Year.ToString(); * string month = DateTime.Now.Month.ToString(); * string day = DateTime.Now.Day.ToString(); * * string dn = "白班"; * DateTime t1 = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")); * DateTime t2 = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd") + " 07:00:00"); * DateTime t3 = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd") + " 19:00:00"); * * if (DateTime.Compare(t1, t2) >= 0 && DateTime.Compare(t1, t3) <= 0) * { * dn = "白班"; * } * else * { * dn = "夜班"; * } * * file = Server.MapPath(@"/file/" + year + @"/" + month + @"月/" + month + "-" + day + dn + @"/"); */ file = Server.MapPath(@"/file/"); if (Request.QueryString["id"] != null) { _id = Request.QueryString["id"].ToString(); } if (Request.QueryString["dh"] != null) { _dh = Request.QueryString["dh"].ToString(); } //扫码进来的 if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>layer.alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } if (!IsPostBack) { LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); emp_code_name.Text = lu.WorkCode + lu.UserName; domain.Text = lu.Domain; //emp_code_name.Text = "02432何桂勤"; domain.Text = "200"; txt_dh.Text = _dh; id.Text = _id; if (_id != "" || _dh != "") { init_data(_id, _dh, connString); } } }
protected void Page_Load(object sender, EventArgs e) { if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } TraceByDH(Request.QueryString["dh"].ToString()); }
protected void ResetCookie() { if (WeiXin.GetCookie("cookiedate") != "") { var date = Convert.ToDateTime(WeiXin.GetCookie("cookiedate")); if (date.AddDays(1) < DateTime.Now) { WeiXin.delCookies("userid"); WeiXin.delCookies("workcode"); WeiXin.delCookies("usermodel"); } } }
protected void Page_Load(object sender, EventArgs e) { if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } if (!IsPostBack) { LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); txt_empname.Value = lu.WorkCode + lu.UserName; // txt_empname.Value = "01744孙娟"; bind_sb(); } }
protected void Page_Load(object sender, EventArgs e) { _workshop = Request.QueryString["workshop"].ToString(); if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); GetData(lu.WorkCode); //GetData("02432"); }
protected void Page_Load(object sender, EventArgs e) { _workshop = Request.QueryString["workshop"].ToString(); if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } //if (!IsPostBack) //{ GetData(); //} }
protected void Page_Load(object sender, EventArgs e) { _workshop = Request.QueryString["workshop"].ToString(); if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>layer.alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } if (!IsPostBack) { LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); emp_code_name.Text = lu.WorkCode + lu.UserName; domain.Text = lu.Domain; //登入岗位的域 string strsql_d = "select * from [Mes_App_EmployeeLogin] with(readpast) where emp_code='" + lu.WorkCode + "' and on_date is not null and off_date is null"; var value_login = SQLHelper.reDs(strsql_d).Tables[0]; if (value_login != null && value_login.Rows.Count > 0) { if (domain.Text == "100" || domain.Text == "") { domain.Text = value_login.Rows[0]["domain"].ToString(); } } lbl_emp.Text = lu.Telephone + lu.UserName; if (string.IsNullOrEmpty(lu.Telephone)) //增加手机号的获取,因为cookIE里的手机号有可能会是空值 { string strsql = "select * from [172.16.5.26].[Production].[dbo].[Hrm_Emp] with(nolock) where employeeid = '" + lu.WorkCode + "'"; var value_rout = SQLHelper.reDs(strsql).Tables[0]; if (value_rout != null && value_rout.Rows.Count > 0) { lbl_emp.Text = value_rout.Rows[0]["tel"].ToString() + lu.UserName; } } //emp_code_name.Text = "02432何桂勤"; //domain.Text = "200"; //lbl_emp.Text = "15850349106何桂勤"; //绑定岗位 ShowValue(lu.WorkCode); //ShowValue("02432"); } }
//已完成确认 public void BindWanChengmy(string strWhere = "") { StringBuilder strSql = new StringBuilder(); strSql.Append("select bx_date, bx_banbie, bx_gonghao, bx_name, bx_banzhu, bx_dh, bx_moju_no, bx_moju_type, bx_part, bx_mo_no, bx_gz_type, bx_gz_desc, bx_sbno, bx_sbname, status,level,b.cellphone,moju_repair "); //strSql.Append(" ,cast(datediff(mi,bx_date,getdate())/60 as varchar)+'小时 '+right('00'+cast(datediff(mi,bx_date,getdate())%60 as varchar),2)+' 分' bx_shichang "); strSql.Append(" ,cast(cast(datediff(ss, bx_date, qr_date) / 3600 as int) as varchar)+':'+right('00' + cast(cast(datediff(ss, bx_date, qr_date) % 3600 / 60 as int) as varchar), 2) bx_shichang "); //strSql.Append(" ,(select top 1 product_leibie from form3_Sale_Product_MainTable where pgino =(select left(xmh,5) from [172.16.5.6].report.dbo.MoJu where mojuno= bx_moju_no) ) as pd_type "); strSql.Append(" FROM mes.dbo.MES_SB_BX a join mes.dbo.MES_SB_QR c on a.bx_dh=c.dh join mes.dbo.mes_sb_wx d on a.bx_dh=d.wx_dh join [172.16.5.6].[eHR_DB].dbo.view_hr_emp b on b.employeeid=a.bx_gonghao where dateadd(hh,24,qr_date )>getdate() "); strSql.Append(" and status = '确认完成' and ( bx_gonghao='" + WeiXin.GetCookie("workcode") + "' or wx_gonghao='" + WeiXin.GetCookie("workcode") + "' or c.qr_gh='" + WeiXin.GetCookie("workcode") + "' ) order by a.id asc"); DataSet ds = DbHelperSQL.Query(strSql.ToString()); listWCmy.DataSource = ds; listWCmy.DataBind(); }
//入库完成 private void BindData5() { string sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "二车间", WeiXin.GetCookie("workcode"), 5); DataTable dt_data_end_2 = SQLHelper.Query(sql).Tables[0]; ViewState["dt_data_end_2"] = dt_data_end_2; sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "三车间", WeiXin.GetCookie("workcode"), 5); DataTable dt_data_end_3 = SQLHelper.Query(sql).Tables[0]; ViewState["dt_data_end_3"] = dt_data_end_3; sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "四车间", WeiXin.GetCookie("workcode"), 5); DataTable dt_data_end_4 = SQLHelper.Query(sql).Tables[0]; ViewState["dt_data_end_4"] = dt_data_end_4; }
protected void Page_Load(object sender, EventArgs e) { _workshop = Request.QueryString["workshop"].ToString(); if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } //调整中 BindData1(); //检测中 BindData2(); //检测结果待确认 BindData3(); //换夹完成(30天内) BindData4(); }
protected void Page_Load(object sender, EventArgs e) { if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>layer.alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } if (!IsPostBack) { LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); emp_code_name.Text = lu.WorkCode + lu.UserName; domain.Text = lu.Domain; //emp_code_name.Text = "02432何桂勤"; domain.Text = "200"; } }
public static string ruku_Data() { string go = "0", end = "0", go_bhg = "0", end_bhg = "0"; //待入库 string sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "二车间", WeiXin.GetCookie("workcode"), 4); DataTable dt_data_2 = SQLHelper.Query(sql).Tables[0]; sql = sql = string.Format(@"exec [usp_app_YZ_monitor] '{0}','{1}',{2}", "三车间", WeiXin.GetCookie("workcode"), 4); DataTable dt_data_3 = SQLHelper.Query(sql).Tables[0]; sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "四车间", WeiXin.GetCookie("workcode"), 4); DataTable dt_data_4 = SQLHelper.Query(sql).Tables[0]; go = (dt_data_2.Rows.Count + dt_data_3.Rows.Count + dt_data_4.Rows.Count).ToString(); //入库完成 sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "二车间", WeiXin.GetCookie("workcode"), 5); DataTable dt_data_end_2 = SQLHelper.Query(sql).Tables[0]; sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "三车间", WeiXin.GetCookie("workcode"), 5); DataTable dt_data_end_3 = SQLHelper.Query(sql).Tables[0]; sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "四车间", WeiXin.GetCookie("workcode"), 5); DataTable dt_data_end_4 = SQLHelper.Query(sql).Tables[0]; end = (dt_data_end_2.Rows.Count + dt_data_end_3.Rows.Count + dt_data_end_4.Rows.Count).ToString(); //不合格 sql = @"exec [usp_app_bhgp_Apply_list_dv_V1_New] '','','','ruku'"; DataSet ds = SQLHelper.Query(sql); DataTable dt_98_2 = ds.Tables[0]; DataTable dt_98_3 = ds.Tables[1]; DataTable dt_98_4 = ds.Tables[2]; DataTable dt_99_2 = ds.Tables[3]; DataTable dt_99_3 = ds.Tables[4]; DataTable dt_99_4 = ds.Tables[5]; //不合格待入库 go_bhg = (dt_98_2.Rows.Count + dt_98_3.Rows.Count + dt_98_4.Rows.Count).ToString(); //不合格已入库 end_bhg = (dt_99_2.Rows.Count + dt_99_3.Rows.Count + dt_99_4.Rows.Count).ToString(); string res = "[{\"go\":\"" + go + "\",\"end\":\"" + end + "\",\"go_bhg\":\"" + go_bhg + "\",\"end_bhg\":\"" + end_bhg + "\"}]"; return(res); }
protected void Page_Load(object sender, EventArgs e) { //_workshop = Request.QueryString["workshop"].ToString(); if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } // ---------0:申请中 1:待检中 2:检测中 3:待取用 9:完成(24Hour) //申请中 BindData1(); //1:待检中 BindData2(); //检测中 BindData3(); //3:待取用 BindData4(); //9:完成(24Hour) BindData9(); }
protected void Page_Load(object sender, EventArgs e) { _workshop = Request.QueryString["workshop"].ToString(); if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } //生产中 // BindData1(); //待终检 BindData2(); //待GP12 BindData3(); //待入库 BindData4(); //入库完成24小时 //BindData5(); }
private void setVisibleState(string status, string dh, string level) { string workcode = WeiXin.GetCookie("workcode"); if (status == "报修完成") { enableBtn(true, false, false); VisibleBtn(true, false, false); } else if (status == "维修中") { BindWX(dh); enableBtn(false, true, false); VisibleBtn(false, true, false); string script = "$('#PageWX').removeAttr('hidden'); "; ClientScript.RegisterStartupScript(this.GetType(), "show", script, true); } else if (status == "维修完成") { //DataTable dt = fun.Get_WX_Record(gv.Cells[1].Text); //txtWX_CS.Value = dt.Rows[0]["wx_cs"].ToString(); //dropResult.Text = dt.Rows[0]["wx_result"].ToString(); //txtMo_Down_cs.Value = dt.Rows[0]["mo_down_cs"].ToString(); BindWX(dh); enableBtn(false, false, true); VisibleBtn(false, false, true); string script = "$('#PageWX').removeAttr('hidden');$('#PageQR').removeAttr('hidden');"; ClientScript.RegisterStartupScript(this.GetType(), "show", script, true); } else if (status == "确认完成") { BindWX(dh); BindQR(dh); string script = "$('#PageWX').removeAttr('hidden');$('#PageQR').removeAttr('hidden');"; ClientScript.RegisterStartupScript(this.GetType(), "show", script, true); enableBtn(false, false, false); VisibleBtn(false, false, false); } SetRole(workcode, level); }
protected void Page_Load(object sender, EventArgs e) { _workorder = Request.QueryString["workorder"].ToString(); _ruku_dh = Request.QueryString["ruku_dh"].ToString(); if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>layer.alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } if (!IsPostBack) { LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); emp_code_name.Text = lu.WorkCode + lu.UserName; //emp_code_name.Text = "02432何桂勤"; emp.Text = emp_code_name.Text; time.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); } }
protected void Page_Load(object sender, EventArgs e) { _workshop = Request.QueryString["workshop"].ToString(); _lotno = Request.QueryString["lotno"].ToString(); _needno = Request.QueryString["need_no"].ToString(); if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>layer.alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } if (!IsPostBack) { LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); _emp = lu.WorkCode + lu.UserName; load_data(lu.WorkCode); } }
//待GP12 private void BindData3() { string sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "二车间", WeiXin.GetCookie("workcode"), 3); DataSet ds = SQLHelper.Query(sql); DataTable dt_data = ds.Tables[0]; ViewState["dt_data_gp2"] = dt_data; sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "三车间", WeiXin.GetCookie("workcode"), 3); ds = SQLHelper.Query(sql); dt_data = ds.Tables[0]; ViewState["dt_data_gp3"] = dt_data; sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "四车间", WeiXin.GetCookie("workcode"), 3); ds = SQLHelper.Query(sql); dt_data = ds.Tables[0]; ViewState["dt_data_gp4"] = dt_data; }
protected void Page_Load(object sender, EventArgs e) { _workshop = "四车间"; // Request.QueryString["workshop"].ToString(); // "四车间";// _dh = "G0051234"; // Request.QueryString["dh"].ToString();// "W0000456"; // lotno = "G0000301"; //_dh = "W0000450"; dt_append = new DataTable(); dt_append.Columns.Add("pgino"); dt_append.Columns.Add("workorder"); dt_append.Columns.Add("need_off_qty"); //dt_append.Columns.Add("need_no"); dt_append.Columns.Add("idno"); if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>layer.alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } string strsql = @"select pgino,emp_name,hege_qty,create_date,qc_dh from Mes_App_WorkOrder_QC_History where qc_dh = '{0}' UNION ALL select pgino,emp_name,-1*act_qty,create_date,workorder from Mes_APP_WorkOrder_CKCK_Hege where reason ='成品领用' AND workorder='{0}'" ; strsql = string.Format(strsql, _dh); DataTable re_dt = SQLHelper.Query(strsql).Tables[0]; if (re_dt.Rows.Count > 0) { Repeater_record.DataSource = re_dt; Repeater_record.DataBind(); } if (!IsPostBack) { LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); txt_emp.Text = lu.WorkCode; txt_dh.Text = _dh; ViewState["STEPVALUE"] = ""; } }
protected void list_go_my_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { Repeater detail = (Repeater)e.Item.FindControl("re_go_my"); var item = (string)e.Item.DataItem; var line = item;//item["line"].ToString(); DataTable dt_all = ViewState["dt_all"] as DataTable; //var dt_wk = dt_all.Clone(); //dt_wk.Rows.Add( dt_all.Select("line='" + line + "'")); dt_all.DefaultView.RowFilter = "line='" + line + "' and emp_code='" + WeiXin.GetCookie("workcode") + "'"; dt_all.DefaultView.Sort = "on_date asc"; //string sql = @"exec [usp_app_emp_login_list_dv] '{0}','{1}'"; //sql = string.Format(sql, _workshop, item["line"].ToString()); //dt_wk = SQLHelper.Query(sql).Tables[0]; detail.DataSource = dt_all; detail.DataBind(); } }
protected void btnConfirm_Click(object sender, EventArgs e) { MES.Model.MES_SB_QR m = new MES.Model.MES_SB_QR(); string wx_dh = Request["dh"];// GridView1.SelectedRow.Cells[1].Text.Trim(); m.dh = wx_dh; m.qr_date = DateTime.Now; m.qr_banbie = ""; // txtBanBie.Value; m.qr_banzhu = ""; // txtBanZu.Value; m.qr_gh = WeiXin.GetCookie("workcode"); m.qr_name = ((LoginUser)WeiXin.GetJsonCookie()).UserName; m.qr_remark = this.txtQr_Remark.Value; m.p_status = "确认完成"; MES.DAL.MES_SB_WX dal = new MES.DAL.MES_SB_WX(); if (dal.IsExitsQR(m.dh) == 0)//--确认是否重复确认 { dal.Add(m); } string strSQL = "update MES_SB_BX set [status]='" + m.p_status + "' where bx_dh='" + m.dh + "';"; DbHelperSQL.ExecuteSql(strSQL);//因经常会无法更新到状态,固在此重复更新一次 strSQL = "SELECT wx_result FROM MES_SB_WX WHERE wx_dh='" + wx_dh + "' "; DataTable tbl = DbHelperSQL.Query(strSQL).Tables[0]; if (tbl.Rows[0][0].ToString() == "需下模维修") { string str = "alert('维修结果为:需下模维修,请至电脑端进换模页面进行维护信息.');self.location='BXMonitor.aspx';"; Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", str, true); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('确认成功.');self.location='BXMonitor.aspx';", true); } }