protected void button1_onclick(object sender, EventArgs e) { ZWL.BLL.ERPOperations MyModel1 = new ZWL.BLL.ERPOperations(); MyModel1.OrderNo = this.OrderNo.Text.Trim(); MyModel1.DelayPeople = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyModel1.Delayreason = this.delayreason.SelectedValue.Trim(); ZWL.BLL.ERPUser model = new ZWL.BLL.ERPUser(); model.UserName = this.headpeople.Text.Trim() + "','" + this.AssistPeople1.Text.Trim() + "','" + this.AssistPeople2.Text.Trim(); try { MyModel1.Update_Delay(); model.Update_zt(0); //写系统日志 ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi(); MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyRiZhi.DoSomething = "运维延迟,工单号(" + this.OrderNo.Text.Trim() + ")"; MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString(); MyRiZhi.Add(); ZWL.Common.MessageBox.ShowAndRedirect(this, "运维延迟成功!", "Operations_registration_result.aspx"); } catch { Response.Write("<script>alert('运维结果登记失败!');history.back(-1);</script>"); Response.End(); } }
protected void button1_onclick(object sender, EventArgs e) { String Headnamestr = ""; String Assist1str = ""; String Assist2str = ""; ZWL.BLL.ERPOperations MyModel1 = new ZWL.BLL.ERPOperations(); try { if (!this.HeadPeople.SelectedValue.Equals("")) { Headnamestr = this.HeadPeople.SelectedItem.ToString().Trim(); } if (!this.AssistPeople1.SelectedValue.Equals("")) { Assist1str = this.AssistPeople1.SelectedItem.ToString().Trim(); } if (!this.AssistPeople2.SelectedValue.Equals("")) { Assist2str = this.AssistPeople2.SelectedItem.ToString().Trim(); } } catch { } ZWL.BLL.ERPUser MyModel2 = new ZWL.BLL.ERPUser(); MyModel2.UserName = this.HeadPeople.SelectedValue.Trim() + ":" + Headnamestr; //this.HeadPeople.SelectedIndex.ToString(); ZWL.BLL.ERPUser MyModel3 = new ZWL.BLL.ERPUser(); MyModel3.UserName = this.AssistPeople1.SelectedValue.Trim() + ":" + Assist1str + "','" + this.AssistPeople2.SelectedValue.Trim() + ":" + Assist2str; MyModel1.OrderNo = this.OrderNo.Text.Trim(); MyModel1.DispatchingPeople = ZWL.Common.PublicMethod.GetSessionValue("username"); MyModel1.HeadPeople = this.HeadPeople.SelectedValue.Trim() + ":" + Headnamestr; MyModel1.AssistPeople1 = this.AssistPeople1.SelectedValue.Trim() + ":" + Assist1str; MyModel1.AssistPeople2 = this.AssistPeople2.SelectedValue.Trim() + ":" + Assist2str; try { MyModel1.Update_Technician(); MyModel2.Update_zt(1); MyModel3.Update_zt(2); //写系统日志 ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi(); MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("username"); MyRiZhi.DoSomething = "运维派工,工单号(" + this.OrderNo.Text.Trim() + ";" + MyModel2.UserName + ")"; MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString(); MyRiZhi.Add(); ZWL.Common.MessageBox.ShowAndRedirect(this, "运维派工成功!", "Operations_dispatching.aspx"); //跳转回保修界面 Response.Redirect("registration.aspx"); //this.Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script>history.go(-2);</script>"); } catch { Response.Write("<script>alert('运维派工失败!');history.back(-1);</script>"); Response.End(); } }
protected void button1_onclick(object sender, EventArgs e) { ZWL.BLL.ERPOperations MyModel1 = new ZWL.BLL.ERPOperations(); MyModel1.OrderNo = this.OrderNo.Text.Trim(); MyModel1.ReturnPeople = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyModel1.ReturnReason = this.returnreason.SelectedValue.Trim(); ZWL.BLL.ERPUser model = new ZWL.BLL.ERPUser(); model.UserName = this.headpeople.Text.Trim() + "','" + this.AssistPeople1.Text.Trim() + "','" + this.AssistPeople2.Text.Trim(); try { MyModel1.Update_Return(); model.Update_zt(0); string NewOrderNo = KNetOddNumbers(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["SQLConnectionString"].ToString())) { SqlCommand cmd = new SqlCommand("insert into ERPOperations(OrderNo,FauleEquipment,Phenomenon,RepairDepartment,RepairPeople,FauleDate,RepairDate,State,EquipmentType,EquipmentName,XingHao,CunFangAddr) select " + NewOrderNo + ",FauleEquipment,Phenomenon,RepairDepartment,RepairPeople,FauleDate,RepairDate,0,EquipmentType,EquipmentName,XingHao,CunFangAddr from ERPOperations where orderno='" + MyModel1.OrderNo + "'", conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); } //写系统日志 ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi(); MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyRiZhi.DoSomething = "运维转单,工单号(" + this.OrderNo.Text.Trim() + ")"; MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString(); MyRiZhi.Add(); ZWL.Common.MessageBox.ShowAndRedirect(this, "运维转单成功!", "Operations_registration_result.aspx"); } catch { Response.Write("<script>alert('运维转单失败!');history.back(-1);</script>"); Response.End(); } }
/// <summary> /// 搜索 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SeachKeyTextChanged(object sender, EventArgs e) { string SeachKeyContent = this.SeachKey.Text.ToString(); //string SeachKeyContent = SeachKey.Text.ToString().Substring(2, 4); using (SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["SQLConnectionString"].ToString())) { conn.Open(); string Dostr = "SELECT * FROM ERPUser where department='临床工程信息部' and jiaose like '%维修%' and serils='" + SeachKeyContent + "' "; SqlCommand cmd = new SqlCommand(Dostr, conn); SqlDataReader dr = cmd.ExecuteReader(); //判断是否为维修员 if (dr.Read()) { string SeachKeyContent1 = this.SeachKey.Text.ToString(); String[] SeachKey = SeachKeyContent1.Split(':');//提取工号 Response.AddHeader("Refresh", "0"); using (SqlConnection conn1 = new SqlConnection(ConfigurationManager.AppSettings["SQLConnectionString"].ToString())) { conn1.Open(); string Dostr1 = "select * from ERPOperations where state='2' or state='3' and headpeople like '%" + SeachKey[0] + "%'"; // YU SqlCommand cmd1 = new SqlCommand(Dostr1, conn1); SqlDataReader dr1 = cmd1.ExecuteReader(); if (dr1.Read()) { ZWL.BLL.ERPOperations MyModel = new ZWL.BLL.ERPOperations(); MyModel.OrderNo = dr1["OrderNo"].ToString(); ZWL.BLL.ERPUser MyModel1 = new ZWL.BLL.ERPUser(); MyModel1.UserName = dr1["HeadPeople"].ToString();// ZWL.BLL.ERPUser MyModel2 = new ZWL.BLL.ERPUser(); MyModel2.UserName = dr1["AssistPeople1"].ToString() + "','" + dr1["AssistPeople2"].ToString(); try { MyModel.Update_Order(); MyModel1.Update_zt(3); MyModel2.Update_zt(4); //写系统日志 ZWL.BLL.ERPRiZhi MyRiZhi = new ZWL.BLL.ERPRiZhi(); MyRiZhi.UserName = ZWL.Common.PublicMethod.GetSessionValue("UserName"); MyRiZhi.DoSomething = "运维接单,工单号(" + MyModel.OrderNo + ")"; MyRiZhi.IpStr = System.Web.HttpContext.Current.Request.UserHostAddress.ToString(); MyRiZhi.Add(); ZWL.Common.MessageBox.ShowAndRedirect(this, "运维接单成功!", "Operations_accept.aspx"); } catch { Response.Write("<script>alert('无法写入维修起始时间!');history.back(-1);</script>"); Response.End(); } //Response.Write("<script>window.open('Knet_Procure_OpenBilling_PrinterPage.aspx?orderno=" + dr1["OrderNo"].ToString() + "','_blank')</script>"); Response.Write("<script>window.open('Operations_Print.aspx?ID=" + dr1["ID"].ToString() + "','_blank')</script>"); Response.End(); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "message", "<script language=javascript> window.alert('无新任务或正在维修中!');</script>"); } } } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "message", "<script language=javascript> window.alert('对不起,您不是维修员或录入的卡号有误!');</script>"); } } }