//添加
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);
}
}