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("zyb"); dt_append.Columns.Add("lot_no"); dt_append.Columns.Add("act_qty"); dt_append.Columns.Add("cl"); dt_append.Columns.Add("yzj_no"); dt_append.Columns.Add("zyb_lot"); dt_append.Columns.Add("idno"); if (!IsPostBack) { 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 (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(); }
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) { _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 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 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); } } }
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) { bind_data(); if (!IsPostBack) { LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); emp_code_name.Text = lu.WorkCode + lu.UserName; } }
protected void Page_Load(object sender, EventArgs e) { _workshop = Request.QueryString["workshop"].ToString(); bind_data(); if (!IsPostBack) { LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); emp_code_name.Text = lu.WorkCode + lu.UserName; } }
protected void Page_Load(object sender, EventArgs e) { if (WeiXin.GetCookie("workcode") == null) { Response.Write("<script>alert('登入信息过期,请退出程序重新进入。');window.history.back();location.reload();</script>"); return; } LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); GetData(lu.WorkCode); }
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>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"); } }
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"; } }
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(); _workcode = lu.WorkCode; GetData(_workcode); //_workcode = "02432"; //GetData("02432"); }
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); } }
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(); // "四车间";// _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 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); } }
protected void Page_Load(object sender, EventArgs e) { _workshop = Request.QueryString["workshop"].ToString(); _workorder = Request.QueryString["workorder"].ToString(); _workorder_f = Request.QueryString["workorder_f"].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(nolock) 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]; string location = ""; if (value_login != null && value_login.Rows.Count > 0) { if (domain.Text == "100" || domain.Text == "") { domain.Text = value_login.Rows[0]["domain"].ToString(); } location = value_login.Rows[0]["location"].ToString(); } //emp_code_name.Text = "02432何桂勤"; //domain.Text = "200"; workorder.Text = _workorder; workorder_f.Text = _workorder_f; init_data(_workorder, _workorder_f, location); } }
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(); txt_emp.Text = lu.WorkCode + lu.UserName; domain.Text = lu.Domain; //txt_emp.Text = "02274李晓根"; //domain.Text = "200"; setButton(); ViewState["emp_login_sb"] = null; } }
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; } _need_no = Request.QueryString["need_no"].ToString(); if (!IsPostBack) { LoginUser lu = (LoginUser)WeiXin.GetJsonCookie(); emp_code_name.Text = lu.WorkCode + lu.UserName; //emp_code_name.Text = "02432何桂勤"; need_no.Text = _need_no; init_data(_need_no); lk_lotno_qad_Click(sender, e); } }
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(); _next = Request.QueryString["next"].ToString();//N表示第一次链接进来,Y表示点击 下一次 进来的 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; init_data(_workorder); bind_reason(domain.Text); bind_dcl_rea(domain.Text); if (_next == "Y") { //绑定数据 string sql = @"select * from [MES_APP_WorkOrder_Ng_Deal_Main_temp] where workorder='{0}'"; sql = string.Format(sql, _workorder); DataTable dt = SQLHelper.Query(sql).Tables[0]; if (dt.Rows[0]["cz_result"].ToString() == "废品") { b_result1.Checked = true; } if (dt.Rows[0]["cz_result"].ToString() == "待处理") { b_result2.Checked = true; hege_qty.Text = dt.Rows[0]["hege_qty"].ToString(); dcl_rea.SelectedValue = dt.Rows[0]["reason_code"].ToString(); dcl_rea.Visible = false; txt_dcl_rea.Text = dt.Rows[0]["reason_code"].ToString() + "-" + dt.Rows[0]["reason"].ToString(); txt_dcl_rea.Visible = true; } //设定只读 b_result1.Disabled = true; b_result2.Disabled = true; hege_qty.ReadOnly = true; GetData(_workorder); } else//若是第一次进来,需要确认 已处置数量不为0的话,需要赋值,且只读 { string sql = @"select * from [Mes_App_WorkOrder_Ng] where workorder='{0}'"; sql = string.Format(sql, _workorder); DataTable dt = SQLHelper.Query(sql).Tables[0]; if (dt.Rows[0]["result"].ToString() == "废品") { b_result1.Checked = true; hege_qty.ReadOnly = true; } if (dt.Rows[0]["result"].ToString() == "待处理") { b_result2.Checked = true; dcl_rea.SelectedValue = dt.Rows[0]["reason_code"].ToString(); dcl_rea.Visible = false; txt_dcl_rea.Text = dt.Rows[0]["reason_code"].ToString() + "-" + dt.Rows[0]["reason"].ToString(); txt_dcl_rea.Visible = true; } if (dt.Rows[0]["result"].ToString() != "") { //设定只读 b_result1.Disabled = true; b_result2.Disabled = true; } } } }