//添加 private void Add() { try { StringBuilder sb = new StringBuilder(); //遍历获取传递过来的字符串 foreach (string s in HttpContext.Current.Request.Form.AllKeys) { sb.AppendFormat("{0}:{1}\n", s, HttpContext.Current.Request.Form[s]); } string ss = sb.ToString(); string[] str = ss.Split('&'); string cygbh = str[1].Split('=')[1]; if (string.IsNullOrEmpty(cygbh)) { HttpContext.Current.Response.Write("1"); return; } DataTable dt = new DataTable(); dt = SqlHelper.GetTable("select * from ygzlb where cygbh='" + cygbh + "'"); if (dt.Rows.Count > 0) { HttpContext.Current.Response.Write("2"); return; } string cygxm = str[2].Split('=')[1]; if (string.IsNullOrEmpty(cygxm)) { HttpContext.Current.Response.Write("3"); return; } string cdlmm = str[3].Split('=')[1]; int ibmid = 0; sys ex = new sys(); if (ex.isNumber(str[4].Split('=')[1]) == true) { ibmid = int.Parse(str[4].Split('=')[1]); } int izwid = 0; if (ex.isNumber(str[5].Split('=')[1]) == true) { izwid = int.Parse(str[5].Split('=')[1]); } string cnl = str[6].Split('=')[1]; string cxb = str[7].Split('=')[1] == "1" ? "男" : "女"; string drzsj = ""; if (ex.isDate(str[8].Split('=')[1]) == true) { drzsj = str[8].Split('=')[1]; } string cbyyx = str[9].Split('=')[1]; string czy = str[10].Split('=')[1]; string csfzh = str[11].Split('=')[1]; string clxdh = str[12].Split('=')[1]; string cjjlxr = str[13].Split('=')[1]; string cjjlxrdh = str[14].Split('=')[1]; string cczyf = str[15].Split('=')[1] == "1" ? "是" : "否"; string cwxh = str[16].Split('=')[1]; if (cwxh.Trim().Length > 0) { //微信号不允许重复 dt = SqlHelper.GetTable("select * from ygzlb where cwxh='" + cwxh + "'"); if (dt.Rows.Count > 0) { HttpContext.Current.Response.Write("4"); return; } } string czt = str[17].Split('=')[1] == "在职" ? "1" : "0"; string cbz = str[18].Split('=')[1]; SqlParameter[] parms = { new SqlParameter("@ygbh", cygbh), new SqlParameter("@ygxm", cygxm), new SqlParameter("@dlmm", cdlmm), new SqlParameter("@bmid", ibmid), new SqlParameter("@zwid", izwid), new SqlParameter("@xb", cxb), new SqlParameter("@nl", cnl), new SqlParameter("@rzsj", drzsj), new SqlParameter("@byyx", cbyyx), new SqlParameter("@zy", czy), new SqlParameter("@sfzh", csfzh), new SqlParameter("@lxdh", clxdh), new SqlParameter("@jjlxr", cjjlxr), new SqlParameter("@jjlxrdh", cjjlxrdh), new SqlParameter("@czyf", cczyf), new SqlParameter("@wxh", cwxh), new SqlParameter("@zt", czt), new SqlParameter("@bz", cbz) }; bool flag = SqlHelper.ExeNonQuery("insert_ygzl", CommandType.StoredProcedure, parms); if (flag) { HttpContext.Current.Response.Write("添加成功!"); } else { HttpContext.Current.Response.Write("添加失败!"); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
private void Edit() { try { StringBuilder sb = new StringBuilder(); //遍历获取传递过来的字符串 foreach (string s in HttpContext.Current.Request.Form.AllKeys) { sb.AppendFormat("{0}:{1}\n", s, HttpContext.Current.Request.Form[s]); } string ss = sb.ToString(); string[] str = ss.Split('~'); string[] strSb = str[0].Split('&'); //设备资料 int id = int.Parse(strSb[0].Split('=')[1]); string cgdh = strSb[1].Split('=')[1]; //工单号 DataTable dt = new DataTable(); dt = SqlHelper.GetTable("select * from zybyb where cgdh='" + cgdh + "' and id<>" + id); if (dt.Rows.Count > 0) { dt = null; HttpContext.Current.Response.Write("1"); return; } dt = null; sys ex = new sys(); string drq = ""; if (ex.isDate((strSb[2].Split('=')[1])) == true) { drq = strSb[2].Split('=')[1]; } string csbbh = strSb[3].Split('=')[1]; //设备编号 if (string.IsNullOrEmpty(csbbh)) { HttpContext.Current.Response.Write("2"); return; } string isbid = ""; dt = SqlHelper.GetTable("select * from sbzlb where deviceid='" + csbbh + "'"); if (dt.Rows.Count == 0) { HttpContext.Current.Response.Write("3"); return; } else { isbid = dt.Rows[0]["id"].ToString(); } string cscx = strSb[5].Split('=')[1]; //生产线 string czy = strSb[6].Split('=')[1]; //专业 string dbysj = ""; if (ex.isDate((strSb[7].Split('=')[1])) == true) { dbysj = strSb[7].Split('=')[1].Replace("+", " "); //保养时间 } string cbylx = strSb[8].Split('=')[1]; //保养类型 string cnrjl = strSb[9].Split('=')[1]; //内容记录 string dxcbysj = ""; //下次保养时间 if (ex.isDate((strSb[10].Split('=')[1])) == true) { dxcbysj = strSb[10].Split('=')[1].Replace("+", " "); } string cbyr = strSb[11].Split('=')[1]; //保养 if (string.IsNullOrEmpty(cbyr) || cbyr.Trim() == "") { HttpContext.Current.Response.Write("9"); return; } string cczy = strSb[12].Split('=')[1]; string cfzry = strSb[13].Split('=')[1]; string cbz = strSb[14].Split('=')[1]; //备注 string strConn = ConfigurationManager.ConnectionStrings["sqlCon"].ConnectionString; SqlConnection con = new SqlConnection(strConn); con.Open(); SqlTransaction sqltra = con.BeginTransaction(); //开始事务 SqlCommand cmd = new SqlCommand(); cmd.Connection = con; //获取数据连接 cmd.Transaction = sqltra; //,在执行SQL时 SqlParameter[] parms = { new SqlParameter("@id", id), new SqlParameter("@gdh", cgdh), new SqlParameter("@sbid", isbid), new SqlParameter("@rq", drq), new SqlParameter("@bysj", dbysj), new SqlParameter("@bylx", cbylx), new SqlParameter("@nrjl", cnrjl), new SqlParameter("@xcbysj", dxcbysj), new SqlParameter("@byr", cbyr), new SqlParameter("@czy", cczy), new SqlParameter("@fzry", cfzry), new SqlParameter("@bz", cbz) }; cmd.CommandText = "update_zyby"; cmd.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in parms) { cmd.Parameters.Add(p); } cmd.ExecuteNonQuery(); SqlParameter[] parm = { new SqlParameter("@byid", id) }; SqlCommand cmds = new SqlCommand(); cmds.Connection = con; //获取数据连接 cmds.Transaction = sqltra; //,在执行SQL时 cmds.CommandText = "update_zyby_mx"; cmds.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in parm) { cmds.Parameters.Add(p); } cmds.ExecuteNonQuery(); //履历表 SqlParameter[] parm_llb = { new SqlParameter("@xmid", id), new SqlParameter("@sbid", isbid), new SqlParameter("@zysj", drq), new SqlParameter("@zyxm", "保养"), new SqlParameter("@zyry", cbyr), new SqlParameter("@czy", cczy), new SqlParameter("@zynr", cnrjl) }; SqlCommand com = new SqlCommand(); com.Connection = con; //获取数据连接 com.Transaction = sqltra; //,在执行SQL时 com.CommandText = "update_llb"; com.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in parm_llb) { com.Parameters.Add(p); } com.ExecuteNonQuery(); //插入新的维修明细 int rCount = int.Parse(str[1].Split('*')[2]); if (rCount > 0) { string[] strBj = str[1].Split('*')[1].Split('@'); string[] value; string bjbh = ""; double sl = 0; string strSql = ""; //备件资料 for (int i = 0; i < rCount; i++) { value = strBj[i].Split('&'); bjbh = value[1]; if (bjbh.Trim() == "") { con.Close(); HttpContext.Current.Response.Write("4&" + (i + 1)); return; } ////判断部件编号是否存在 //strSql = "select * from sbbjb where cbjbh='" + bjbh + "'"; //int row = SqlHelper.ExecuteSql(strSql); //if (row == 0) //{ // con.Close(); // HttpContext.Current.Response.Write("5&" + (i + 1)); // return; //} if (value[2].Trim() == "") { con.Close(); HttpContext.Current.Response.Write("6&" + (i + 1)); return; } if (ex.isNumber(value[2]) == true) { sl = double.Parse(value[2]); } SqlParameter[] parms_mx = { new SqlParameter("@byid", id), new SqlParameter("@bjbh", bjbh), new SqlParameter("@sl", sl) }; SqlCommand cmd_mx = new SqlCommand(); cmd_mx.Connection = con; //获取数据连接 cmd_mx.Transaction = sqltra; //,在执行SQL时 cmd_mx.CommandText = "insert_zyby_mx"; cmd_mx.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in parms_mx) { cmd_mx.Parameters.Add(p); } cmd_mx.ExecuteNonQuery(); } } sqltra.Commit(); //提交事务 if (con.State == ConnectionState.Open) { con.Close(); } con.Dispose(); HttpContext.Current.Response.Write("修改成功!"); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
private void Edit() { try { StringBuilder sb = new StringBuilder(); //遍历获取传递过来的字符串 foreach (string s in HttpContext.Current.Request.Form.AllKeys) { sb.AppendFormat("{0}:{1}\n", s, HttpContext.Current.Request.Form[s]); } string ss = sb.ToString(); string[] str = ss.Split('~'); string[] strT = str[0].Split('&'); //设备资料 int id = int.Parse(strT[0].Split('=')[1]); string clxmc = strT[1].Split('=')[1]; if (string.IsNullOrEmpty(clxmc)) { HttpContext.Current.Response.Write("1"); return; } DataTable dt = new DataTable(); dt = SqlHelper.GetTable("select * from djlxb where cdjlx='" + clxmc + "' and id<>" + id); if (dt.Rows.Count > 0) { HttpContext.Current.Response.Write("2"); return; } sys ex = new sys(); string drq = ""; if (ex.isDate((strT[2].Split('=')[1])) == true) { drq = strT[2].Split('=')[1]; } string csjz = strT[3].Split('=')[1]; //设计者 string strConn = ConfigurationManager.ConnectionStrings["sqlCon"].ConnectionString; SqlConnection con = new SqlConnection(strConn); con.Open(); SqlTransaction sqltra = con.BeginTransaction(); //开始事务 SqlCommand cmd = new SqlCommand(); cmd.Connection = con; //获取数据连接 cmd.Transaction = sqltra; //,在执行SQL时 SqlParameter[] parms = { new SqlParameter("@id", id), new SqlParameter("@djlx", clxmc), new SqlParameter("@rq", drq), new SqlParameter("@sjz", csjz) }; SqlCommand com = new SqlCommand(); com.Connection = con; //获取数据连接 com.Transaction = sqltra; //,在执行SQL时 com.CommandText = "update_djlx"; com.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in parms) { com.Parameters.Add(p); } com.ExecuteNonQuery(); SqlParameter[] parm = { new SqlParameter("@lxid", id) }; SqlCommand comd = new SqlCommand(); comd.Connection = con; //获取数据连接 comd.Transaction = sqltra; //,在执行SQL时 comd.CommandText = "update_djlx_mx"; comd.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in parm) { comd.Parameters.Add(p); } comd.ExecuteNonQuery(); //插入明细 int total = int.Parse(str[1].Split('*')[2]); string[] strSb = str[1].Split('*')[1].Split('@'); string[] strr; string csbbh = ""; Int64 ixh = 0; Int64 isbid = 0; string sql = ""; for (int i = 0; i < total; i++) { strr = strSb[i].Split('&'); if (ex.isNumber(strr[1]) == true) { ixh = Int64.Parse(strr[1]); } isbid = Int64.Parse(strr[2]); csbbh = strr[3]; //不合适的序号 if (ixh != i + 1) { con.Close(); HttpContext.Current.Response.Write("3&" + (i + 1)); return; } if (string.IsNullOrEmpty(csbbh)) { con.Close(); HttpContext.Current.Response.Write("4&" + (i + 1)); return; } ////判断部件编号是否存在 //sql = "select * from sbzlb where DeviceId='" + csbbh + "'"; //dt = SqlHelper.GetTable(sql); //if (dt.Rows.Count == 0) //{ // dt = null; //出错后释放 // con.Close(); // HttpContext.Current.Response.Write("5&" + (i + 1)); // return; //} //dt = null; SqlParameter[] parms_mx = { new SqlParameter("@lxid", id), new SqlParameter("@sbbh", csbbh), new SqlParameter("@xh", ixh) }; SqlCommand coms = new SqlCommand(); coms.Connection = con; //获取数据连接 coms.Transaction = sqltra; //,在执行SQL时 coms.CommandText = "insert_djlx_mx"; coms.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in parms_mx) { coms.Parameters.Add(p); } coms.ExecuteNonQuery(); } sqltra.Commit(); //提交事务 if (con.State == ConnectionState.Open) { con.Close(); } con.Dispose(); HttpContext.Current.Response.Write("修改成功!"); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
private void Edit() { try { StringBuilder sb = new StringBuilder(); //遍历获取传递过来的字符串 foreach (string s in HttpContext.Current.Request.Form.AllKeys) { sb.AppendFormat("{0}:{1}\n", s, HttpContext.Current.Request.Form[s]); } string ss = sb.ToString(); string[] str = ss.Split('~'); string[] strT = str[0].Split('&'); //板信息 int yid = int.Parse(strT[0].Split('=')[1]); int bid = int.Parse(strT[1].Split('=')[1]); string czdz = strT[2].Split('=')[1]; //站地址 if (czdz.Trim().Length == 0) { HttpContext.Current.Response.Write("1"); return; } string cbdz = strT[4].Split('=')[1]; //板地址 if (cbdz.Trim().Length == 0) { HttpContext.Current.Response.Write("2"); return; } string strConn = ConfigurationManager.ConnectionStrings["sqlCon"].ConnectionString; SqlConnection con = new SqlConnection(strConn); con.Open(); SqlTransaction sqltra = con.BeginTransaction(); //开始事务 SqlCommand cmd = new SqlCommand(); cmd.Connection = con; //获取数据连接 cmd.Transaction = sqltra; //,在执行SQL时 SqlParameter[] parms = { new SqlParameter("@bid", yid) }; cmd.Connection = con; //获取数据连接 cmd.Transaction = sqltra; //,在执行SQL时 cmd.CommandText = "update_tdsz"; cmd.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in parms) { cmd.Parameters.Add(p); } cmd.ExecuteNonQuery(); //插入通道信息 int total = int.Parse(str[1].Split('*')[2]); string[] strB = str[1].Split('*')[1].Split('@'); string[] strr; string ctddz = ""; string cblm = ""; string cdw = ""; double ixx = 0; double isx = 0; double idyxx = 0; double idysx = 0; double ipd = 0; string cfz = ""; string sql = ""; for (int i = 0; i < total; i++) { strr = strB[i].Split('&'); ctddz = strr[1]; if (ctddz.Trim().Length == 0) { con.Close(); HttpContext.Current.Response.Write("3&" + (i + 1)); return; } //判断板通道名称是否存在 sql = "select * from tdszb where ctddz='" + ctddz + "' and ibid=" + bid; SqlCommand comm = new SqlCommand(); comm.Connection = con; comm.Transaction = sqltra;//,在执行SQL时 comm.CommandText = sql; comm.CommandType = CommandType.Text; object srows = comm.ExecuteScalar(); //如果采用强制类型转换,如comm.ExecuteScalar().tostring(),容易出现未将对象引用设置到对象的实例 if (srows != null) { comm.Dispose(); con.Close(); con.Dispose(); HttpContext.Current.Response.Write("4&" + (i + 1)); return; } cblm = strr[2]; if (cblm.Trim().Length == 0) { con.Close(); HttpContext.Current.Response.Write("5&" + (i + 1)); return; } //判断变量名是否存在 sql = "select * from tdszb where cblm='" + cblm + "'"; comm.Connection = con; comm.Transaction = sqltra;//,在执行SQL时 comm.CommandText = sql; comm.CommandType = CommandType.Text; srows = comm.ExecuteScalar(); //如果采用强制类型转换,如comm.ExecuteScalar().tostring(),容易出现未将对象引用设置到对象的实例 if (srows != null) { comm.Dispose(); con.Close(); con.Dispose(); HttpContext.Current.Response.Write("6&" + (i + 1)); return; } cdw = strr[3]; sys s = new sys(); if (s.isNumber(strr[4]) == true) { ixx = double.Parse(strr[4]); } if (s.isNumber(strr[5]) == true) { idyxx = double.Parse(strr[5]); } if (s.isNumber(strr[6]) == true) { isx = double.Parse(strr[6]); } if (s.isNumber(strr[7]) == true) { idysx = double.Parse(strr[7]); } if (s.isNumber(strr[8]) == true) { ipd = double.Parse(strr[8]); } cfz = strr[9]; SqlParameter[] parms_mx = { new SqlParameter("@bid", bid), new SqlParameter("@zdz", czdz), new SqlParameter("@bdz", cbdz), new SqlParameter("@tddz", ctddz), new SqlParameter("@blm", cblm), new SqlParameter("@dw", cdw), new SqlParameter("@xx", ixx), new SqlParameter("@dyxx", idyxx), new SqlParameter("@sx", isx), new SqlParameter("@dysx", idysx), new SqlParameter("@pd", ipd), new SqlParameter("@fz", cfz) }; SqlCommand coms = new SqlCommand(); coms.Connection = con; //获取数据连接 coms.Transaction = sqltra; //,在执行SQL时 coms.CommandText = "insert_tdsz"; coms.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in parms_mx) { coms.Parameters.Add(p); } coms.ExecuteNonQuery(); } sqltra.Commit(); //提交事务 if (con.State == ConnectionState.Open) { con.Close(); } con.Dispose(); HttpContext.Current.Response.Write("修改成功!"); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
//添加 private void Add() { try { StringBuilder sb = new StringBuilder(); //遍历获取传递过来的字符串 foreach (string s in HttpContext.Current.Request.Form.AllKeys) { sb.AppendFormat("{0}:{1}\n", s, HttpContext.Current.Request.Form[s]); } string ss = sb.ToString(); string[] str = ss.Split('&'); string cbjbh = str[1].Split('=')[1]; if (string.IsNullOrEmpty(cbjbh)) { HttpContext.Current.Response.Write("1"); return; } DataTable dt = SqlHelper.GetTable("select * from sbbjb where cbjbh='" + cbjbh + "'"); if (dt.Rows.Count > 0) { HttpContext.Current.Response.Write("2"); return; } string cbjmc = str[2].Split('=')[1]; if (string.IsNullOrEmpty(cbjmc)) { HttpContext.Current.Response.Write("3"); return; } string cggxh = str[3].Split('=')[1]; string cjscs = str[4].Split('=')[1]; string csszy = str[5].Split('=')[1]; string cbjdj = str[6].Split('=')[1]; string csccj = str[7].Split('=')[1]; double ibjsl = 0; sys ex = new sys(); if (ex.isNumber(str[8].Split('=')[1]) == true) { ibjsl = double.Parse(str[8].Split('=')[1]); } string csysb = str[9].Split('=')[1]; string cbz = str[10].Split('=')[1]; SqlParameter[] parms = { new SqlParameter("@bjbh", cbjbh), new SqlParameter("@bjmc", cbjmc), new SqlParameter("@ggxh", cggxh), new SqlParameter("@sccj", csccj), new SqlParameter("@bjsl", ibjsl), new SqlParameter("@bz", cbz), new SqlParameter("@jscs", cjscs), new SqlParameter("@sszy", csszy), new SqlParameter("@sysb", csysb), new SqlParameter("@bjdj", cbjdj), }; bool flag = SqlHelper.ExeNonQuery("insert_sbbj", CommandType.StoredProcedure, parms); if (flag) { HttpContext.Current.Response.Write("添加成功!"); } else { HttpContext.Current.Response.Write("添加失败!"); } } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
////转单保存 //private void Add2() //{ // try // { // StringBuilder sb = new StringBuilder(); // //遍历获取传递过来的字符串 // foreach (string s in HttpContext.Current.Request.Form.AllKeys) // { // sb.AppendFormat("{0}:{1}\n", s, HttpContext.Current.Request.Form[s]); // } // string ss = sb.ToString(); // string[] str = ss.Split('~'); // string[] strSb = str[0].Split('&'); //设备资料 // DataTable dt = new DataTable(); // //查找id最大值 // Int64 id = 0; // dt = SqlHelper.GetTable("select max(id) as maxid from ycjlb"); // if (dt.Rows.Count > 0) // { // if (!string.IsNullOrEmpty(dt.Rows[0]["maxid"].ToString())) // { // id = Int64.Parse(dt.Rows[0]["maxid"].ToString()) + 1; // } // else // { // id = 1; // } // } // else // { // id = 1; // } // dt = null; // string cgdh = strSb[1].Split('=')[1]; //工单号 // dt = SqlHelper.GetTable("select * from ycjlb where cgdh='" + cgdh + "'"); // if (dt.Rows.Count > 0) // { // dt = null; // HttpContext.Current.Response.Write("1"); // return; // } // dt = null; // sys ex = new sys(); // string drq = ""; // if (ex.isDate((strSb[2].Split('=')[1])) == true) // { // drq = strSb[2].Split('=')[1]; // } // string csbbh = strSb[3].Split('=')[1]; //设备编号 // if (string.IsNullOrEmpty(csbbh)) // { // HttpContext.Current.Response.Write("2"); // return; // } // string isbid = ""; // dt = SqlHelper.GetTable("select * from sbzlb where deviceid='" + csbbh + "'"); // if (dt.Rows.Count == 0) // { // HttpContext.Current.Response.Write("3"); // return; // } // else // { // isbid = dt.Rows[0]["id"].ToString(); // } // string cscx = strSb[5].Split('=')[1]; //生产线 // string czy = strSb[6].Split('=')[1]; //专业 // string cycms = strSb[7].Split('=')[1]; //异常描述 // string dycsj = ""; // if (ex.isDate((strSb[8].Split('=')[1])) == true) // { // dycsj = strSb[8].Split('=')[1].Replace("+", " "); // } // string ccljl = strSb[9].Split('=')[1]; //处理记录 // string czyr = strSb[10].Split('=')[1]; //作业人 // if (string.IsNullOrEmpty(czyr) || czyr.Trim() == "") // { // HttpContext.Current.Response.Write("9"); // return; // } // string djssj = ""; //结束时间 // if (ex.isDate((strSb[11].Split('=')[1])) == true) // { // djssj = strSb[11].Split('=')[1].Replace("+", " "); // } // string cbz = strSb[12].Split('=')[1]; //备注 // string strConn = ConfigurationManager.ConnectionStrings["sqlCon"].ConnectionString; // SqlConnection con = new SqlConnection(strConn); // con.Open(); // SqlTransaction sqltra = con.BeginTransaction();//开始事务 // SqlCommand cmd = new SqlCommand(); // cmd.Connection = con;//获取数据连接 // cmd.Transaction = sqltra;//,在执行SQL时 // SqlParameter[] parms = { // new SqlParameter("@id",id), // new SqlParameter("@gdh",cgdh), // new SqlParameter("@sbid",isbid), // new SqlParameter("@rq",drq), // new SqlParameter("@ycms",cycms), // new SqlParameter("@ycsj",dycsj), // new SqlParameter("@cljl",ccljl), // new SqlParameter("@jssj",djssj), // new SqlParameter("@zyr",czyr), // new SqlParameter("@bz",cbz) // }; // cmd.CommandText = "insert_ycjl"; // cmd.CommandType = CommandType.StoredProcedure; // foreach (SqlParameter p in parms) // { // cmd.Parameters.Add(p); // } // cmd.ExecuteNonQuery(); // //履历表 // SqlParameter[] parm_llb = { // new SqlParameter("@xmid",id), // new SqlParameter("@sbid",isbid), // new SqlParameter("@zysj",drq), // new SqlParameter("@zyxm","异常"), // new SqlParameter("@zyry",czyr), // new SqlParameter("@zynr",cycms) // }; // SqlCommand com = new SqlCommand(); // com.Connection = con;//获取数据连接 // com.Transaction = sqltra;//,在执行SQL时 // com.CommandText = "insert_llb"; // com.CommandType = CommandType.StoredProcedure; // foreach (SqlParameter p in parm_llb) // { // com.Parameters.Add(p); // } // com.ExecuteNonQuery(); // //待办事项 // SqlParameter[] parms_dbsx = { // new SqlParameter("@wxid",id), // new SqlParameter ("@rq",drq), // new SqlParameter("@sbbh",csbbh), // new SqlParameter("@sxlx","异常"), // new SqlParameter("@sxnr",dycsj +"," + cycms ), // new SqlParameter("@clfs",""), // new SqlParameter("@dbr",""), // new SqlParameter("@zt","持续中") // }; // SqlCommand comd = new SqlCommand(); // comd.Connection = con;//获取数据连接 // comd.Transaction = sqltra;//,在执行SQL时 // comd.CommandText = "insert_dbsx"; // comd.CommandType = CommandType.StoredProcedure; // foreach (SqlParameter p in parms_dbsx) // { // comd.Parameters.Add(p); // } // comd.ExecuteNonQuery(); // //维修明细 // int rCount = int.Parse(str[1].Split('*')[2]); // if (rCount > 0) // { // string[] strBj = str[1].Split('*')[1].Split('@'); // string[] value; // string bjbh = ""; // double sl = 0; // string strSql = ""; // //备件资料 // for (int i = 0; i < rCount; i++) // { // value = strBj[i].Split('&'); // bjbh = value[1]; // if (bjbh.Trim() == "") // { // con.Close(); // HttpContext.Current.Response.Write("4&" + (i + 1)); // return; // } // ////判断部件编号是否存在 // //strSql = "select * from sbbjb where cbjbh='" + bjbh + "'"; // //int row = SqlHelper.ExecuteSql(strSql); // //if (row == 0) // //{ // // con.Close(); // // HttpContext.Current.Response.Write("5&" + (i + 1)); // // return; // //} // if (value[2].Trim() == "") // { // con.Close(); // HttpContext.Current.Response.Write("6&" + (i + 1)); // return; // } // if (ex.isNumber(value[2]) == true) sl = double.Parse(value[2]); // SqlParameter[] parms_mx = { // new SqlParameter("@ycid",id), // new SqlParameter("@bjbh",bjbh), // new SqlParameter("@sl",sl) // }; // SqlCommand cmd_mx = new SqlCommand(); // cmd_mx.Connection = con;//获取数据连接 // cmd_mx.Transaction = sqltra;//,在执行SQL时 // cmd_mx.CommandText = "insert_ycjl_mx"; // cmd_mx.CommandType = CommandType.StoredProcedure; // foreach (SqlParameter p in parms_mx) // { // cmd_mx.Parameters.Add(p); // } // cmd_mx.ExecuteNonQuery(); // } // } // sqltra.Commit(); //提交事务 // if (con.State == ConnectionState.Open) con.Close(); // con.Dispose(); // HttpContext.Current.Response.Write("添加成功!"); // } // catch (Exception ex) // { // sys e = new sys(); // e.GetLog(ex); // } //} private void Edit() { try { StringBuilder sb = new StringBuilder(); //遍历获取传递过来的字符串 foreach (string s in HttpContext.Current.Request.Form.AllKeys) { sb.AppendFormat("{0}:{1}\n", s, HttpContext.Current.Request.Form[s]); } string ss = sb.ToString(); string[] str = ss.Split('~'); string[] strSb = str[0].Split('&'); //设备资料 int id = int.Parse(strSb[0].Split('=')[1]); string cgdh = strSb[1].Split('=')[1]; //工单号 DataTable dt = new DataTable(); dt = SqlHelper.GetTable("select * from ycjlb where cgdh='" + cgdh + "' and id<>" + id); if (dt.Rows.Count > 0) { dt = null; HttpContext.Current.Response.Write("1"); return; } dt = null; sys ex = new sys(); string drq = ""; if (ex.isDate((strSb[2].Split('=')[1])) == true) { drq = strSb[2].Split('=')[1]; } string cczy = strSb[3].Split('=')[1]; //生产线 string csbmc = strSb[4].Split('=')[1]; //设备名称 if (string.IsNullOrEmpty(csbmc)) { HttpContext.Current.Response.Write("2"); return; } string cscx = strSb[5].Split('=')[1]; //生产线 string czy = strSb[6].Split('=')[1]; //专业 string dycsj = ""; if (ex.isDate((strSb[7].Split('=')[1])) == true) { dycsj = strSb[7].Split('=')[1].Replace("+", " "); } string djssj = ""; //结束时间 if (ex.isDate((strSb[8].Split('=')[1])) == true) { djssj = strSb[8].Split('=')[1].Replace("+", " "); } string czyr = strSb[9].Split('=')[1]; //作业人 if (string.IsNullOrEmpty(czyr) || czyr.Trim() == "") { HttpContext.Current.Response.Write("9"); return; } string cfzry = strSb[10].Split('=')[1]; //辅助人员 string cycms = strSb[11].Split('=')[1]; //异常描述 string ccljl = strSb[12].Split('=')[1]; //处理记录 string cbz = strSb[13].Split('=')[1]; //备注 string strConn = ConfigurationManager.ConnectionStrings["sqlCon"].ConnectionString; SqlConnection con = new SqlConnection(strConn); con.Open(); SqlTransaction sqltra = con.BeginTransaction(); //开始事务 SqlCommand cmd = new SqlCommand(); cmd.Connection = con; //获取数据连接 cmd.Transaction = sqltra; //,在执行SQL时 SqlParameter[] parms = { new SqlParameter("@id", id), new SqlParameter("@gdh", cgdh), new SqlParameter("@sbmc", csbmc), new SqlParameter("@scxid", cscx), new SqlParameter("@zyid", czy), new SqlParameter("@rq", drq), new SqlParameter("@ycms", cycms), new SqlParameter("@ycsj", dycsj), new SqlParameter("@cljl", ccljl), new SqlParameter("@jssj", djssj), new SqlParameter("@zyr", czyr), new SqlParameter("@fzry", cfzry), new SqlParameter("@czy", cczy), new SqlParameter("@bz", cbz) }; cmd.CommandText = "update_ycjl"; cmd.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in parms) { cmd.Parameters.Add(p); } cmd.ExecuteNonQuery(); //不进履历表,进值班记录(维修记录),根据设备id是否为0区别,为0标示异常记录 SqlParameter[] parm_wx = { new SqlParameter("@id", id), new SqlParameter("@gdh", cgdh), new SqlParameter("@sbid", ""), new SqlParameter("@sbmc", csbmc), new SqlParameter("@scxid", cscx), new SqlParameter("@zyid", czy), new SqlParameter("@rq", drq), new SqlParameter("@gzsj", drq), new SqlParameter("@gzlx", ""), new SqlParameter("@gzxx", cycms), new SqlParameter("@clfs", ccljl), new SqlParameter("@wxr", czyr), new SqlParameter("@wxnr", ccljl), new SqlParameter("@wxkssj", ""), new SqlParameter("@wcsj", ""), new SqlParameter("@czy", cczy), new SqlParameter("@bz", cbz) }; SqlCommand com = new SqlCommand(); com.Connection = con; //获取数据连接 com.Transaction = sqltra; //,在执行SQL时 com.CommandText = "update_zbjl"; com.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in parm_wx) { com.Parameters.Add(p); } com.ExecuteNonQuery(); //清除原来的异常描述 SqlParameter[] parm = { new SqlParameter("@ycid", id) }; SqlCommand cmds = new SqlCommand(); cmds.Connection = con; //获取数据连接 cmds.Transaction = sqltra; //,在执行SQL时 cmds.CommandText = "update_ycjl_mx"; cmds.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in parm) { cmds.Parameters.Add(p); } cmds.ExecuteNonQuery(); //插入新的维修明细 int rCount = int.Parse(str[1].Split('*')[2]); if (rCount > 0) { string[] strBj = str[1].Split('*')[1].Split('@'); string[] value; string bjbh = ""; double sl = 0; string strSql = ""; //备件资料 for (int i = 0; i < rCount; i++) { value = strBj[i].Split('&'); bjbh = value[1]; if (bjbh.Trim() == "") { con.Close(); HttpContext.Current.Response.Write("4&" + (i + 1)); return; } ////判断部件编号是否存在 //strSql = "select * from sbbjb where cbjbh='" + bjbh + "'"; //int row = SqlHelper.ExecuteSql(strSql); //if (row == 0) //{ // con.Close(); // HttpContext.Current.Response.Write("5&" + (i + 1)); // return; //} if (value[2].Trim() == "") { con.Close(); HttpContext.Current.Response.Write("6&" + (i + 1)); return; } if (ex.isNumber(value[2]) == true) { sl = double.Parse(value[2]); } SqlParameter[] parms_mx = { new SqlParameter("@ycid", id), new SqlParameter("@bjbh", bjbh), new SqlParameter("@sl", sl) }; SqlCommand cmd_mx = new SqlCommand(); cmd_mx.Connection = con; //获取数据连接 cmd_mx.Transaction = sqltra; //,在执行SQL时 cmd_mx.CommandText = "insert_ycjl_mx"; cmd_mx.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in parms_mx) { cmd_mx.Parameters.Add(p); } cmd_mx.ExecuteNonQuery(); } } sqltra.Commit(); //提交事务 if (con.State == ConnectionState.Open) { con.Close(); } con.Dispose(); HttpContext.Current.Response.Write("修改成功!"); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }
//转单保存 private void Add2() { try { StringBuilder sb = new StringBuilder(); //遍历获取传递过来的字符串 foreach (string s in HttpContext.Current.Request.Form.AllKeys) { sb.AppendFormat("{0}:{1}\n", s, HttpContext.Current.Request.Form[s]); } string ss = sb.ToString(); string[] str = ss.Split('~'); string[] strSb = str[0].Split('&'); //设备资料 DataTable dt = new DataTable(); //查找id最大值 Int64 id = 0; dt = SqlHelper.GetTable("select max(id) as maxid from wxjlb"); if (dt.Rows.Count > 0) { if (!string.IsNullOrEmpty(dt.Rows[0]["maxid"].ToString())) { id = Int64.Parse(dt.Rows[0]["maxid"].ToString()) + 1; } else { id = 1; } } else { id = 1; } dt = null; string cgdh = strSb[1].Split('=')[1]; //工单号 dt = SqlHelper.GetTable("select * from wxjlb where cgdh='" + cgdh + "'"); if (dt.Rows.Count > 0) { dt = null; HttpContext.Current.Response.Write("1"); return; } dt = null; sys ex = new sys(); string drq = ""; if (ex.isDate((strSb[2].Split('=')[1])) == true) { drq = strSb[2].Split('=')[1]; } string csbbh = strSb[3].Split('=')[1]; //设备编号 if (string.IsNullOrEmpty(csbbh)) { HttpContext.Current.Response.Write("2"); return; } string isbid = ""; dt = SqlHelper.GetTable("select * from sbzlb where deviceid='" + csbbh + "'"); if (dt.Rows.Count == 0) { HttpContext.Current.Response.Write("3"); return; } else { isbid = dt.Rows[0]["id"].ToString(); } string cscx = strSb[5].Split('=')[1]; //生产线 string czy = strSb[6].Split('=')[1]; //专业 string dgzsj = ""; if (ex.isDate((strSb[7].Split('=')[1])) == true) { dgzsj = strSb[7].Split('=')[1].Replace("+", " ");; } string cgzlx = strSb[8].Split('=')[1]; //故障类型 string cwxr = strSb[9].Split('=')[1]; //维修人 if (string.IsNullOrEmpty(cwxr) || cwxr.Trim() == "") { HttpContext.Current.Response.Write("9"); return; } string dwxkssj = ""; //维修开始时间 if (ex.isDate((strSb[10].Split('=')[1])) == true) { dwxkssj = strSb[10].Split('=')[1].Replace("+", " "); } string dwcsj = ""; //完成时间 if (ex.isDate((strSb[11].Split('=')[1])) == true) { dwcsj = strSb[11].Split('=')[1].Replace("+", " "); } string cczy = strSb[12].Split('=')[1]; //制单人 string cfzry = strSb[13].Split('=')[1]; //辅助人员 string cgzxx = strSb[14].Split('=')[1]; //故障现象 string cclfs = strSb[15].Split('=')[1]; //处理方式 string cwxnr = strSb[16].Split('=')[1]; //维修内容 string cbz = strSb[17].Split('=')[1]; //备注 string strConn = ConfigurationManager.ConnectionStrings["sqlCon"].ConnectionString; SqlConnection con = new SqlConnection(strConn); con.Open(); SqlTransaction sqltra = con.BeginTransaction(); //开始事务 SqlCommand cmd = new SqlCommand(); cmd.Connection = con; //获取数据连接 cmd.Transaction = sqltra; //,在执行SQL时 SqlParameter[] parms = { new SqlParameter("@id", id), new SqlParameter("@gdh", cgdh), new SqlParameter("@sbid", isbid), new SqlParameter("@rq", drq), new SqlParameter("@gzsj", dgzsj), new SqlParameter("@gzlx", cgzlx), new SqlParameter("@gzxx", cgzxx), new SqlParameter("@clfs", cclfs), new SqlParameter("@wxr", cwxr), new SqlParameter("@fzry", cfzry), new SqlParameter("@wxnr", cwxnr), new SqlParameter("@wxkssj", dwxkssj), new SqlParameter("@wcsj", dwcsj), new SqlParameter("@czy", cczy), new SqlParameter("@bz", cbz) }; cmd.CommandText = "insert_wxjl"; cmd.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in parms) { cmd.Parameters.Add(p); } cmd.ExecuteNonQuery(); //履历表 SqlParameter[] parm_llb = { new SqlParameter("@xmid", id), new SqlParameter("@sbid", isbid), new SqlParameter("@zysj", drq), new SqlParameter("@zyxm", "维修"), new SqlParameter("@zyry", cwxr), new SqlParameter("@czy", cczy), new SqlParameter("@zynr", cwxnr) }; SqlCommand com = new SqlCommand(); com.Connection = con; //获取数据连接 com.Transaction = sqltra; //,在执行SQL时 com.CommandText = "insert_llb"; com.CommandType = CommandType.StoredProcedure; foreach (SqlParameter p in parm_llb) { com.Parameters.Add(p); } com.ExecuteNonQuery(); //待办事项 //SqlParameter[] parms_dbsx = { // new SqlParameter("@wxid",id), // new SqlParameter ("@rq",drq), // new SqlParameter("@sbbh",csbbh), // new SqlParameter("@sxlx","维修"), // new SqlParameter("@sxnr",dgzsj +"," + cgzlx + "," + cgzxx ), // new SqlParameter("@clfs",""), // new SqlParameter("@dbr",""), // new SqlParameter("@zt","持续中") // }; //SqlCommand comd = new SqlCommand(); //comd.Connection = con;//获取数据连接 //comd.Transaction = sqltra;//,在执行SQL时 //comd.CommandText = "insert_dbsx"; //comd.CommandType = CommandType.StoredProcedure; //foreach (SqlParameter p in parms_dbsx) //{ // comd.Parameters.Add(p); //} //comd.ExecuteNonQuery(); //维修明细 int rCount = int.Parse(str[1].Split('*')[2]); if (rCount > 0) { string[] strBj = str[1].Split('*')[1].Split('@'); string[] value; string bjbh = ""; double sl = 0; string strSql = ""; //备件资料 for (int i = 0; i < rCount; i++) { value = strBj[i].Split('&'); bjbh = value[1]; if (bjbh.Trim() == "") { con.Close(); HttpContext.Current.Response.Write("4&" + (i + 1)); return; } //判断部件编号是否存在 strSql = "select * from sbbjb where cbjbh='" + bjbh + "'"; SqlCommand comm = new SqlCommand(); comm.Connection = con; comm.Transaction = sqltra;//,在执行SQL时 comm.CommandText = strSql; comm.CommandType = CommandType.Text; int row = comm.ExecuteNonQuery(); if (row == 0) { comm.Dispose(); con.Close(); HttpContext.Current.Response.Write("5&" + (i + 1)); return; } if (value[2].Trim() == "") { con.Close(); HttpContext.Current.Response.Write("6&" + (i + 1)); return; } if (ex.isNumber(value[2]) == true) { sl = double.Parse(value[2]); } SqlParameter[] parms_mx = { new SqlParameter("@wxid", id), new SqlParameter("@bjbh", bjbh), new SqlParameter("@sl", sl) }; SqlCommand cmd_mx = new SqlCommand(); cmd_mx.Connection = con; //获取数据连接 cmd_mx.Transaction = sqltra; //,在执行SQL时 cmd_mx.CommandType = CommandType.StoredProcedure; cmd_mx.CommandText = "insert_wxjl_mx"; foreach (SqlParameter p in parms_mx) { cmd_mx.Parameters.Add(p); } cmd_mx.ExecuteNonQuery(); cmd_mx.Dispose(); } } sqltra.Commit(); //提交事务 if (con.State == ConnectionState.Open) { con.Close(); } con.Dispose(); HttpContext.Current.Response.Write("添加成功!"); } catch (Exception ex) { sys e = new sys(); e.GetLog(ex); } }