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 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); } }