//待办处理________________________________________________________________________________________________
public SchoolX_资产报修流程表 获取报修信息(int 待办id)
{
string sql = string.Format("SELECT FlowID FROM AM_待办业务 WHERE ID=" + 待办id);
SqlDataReader read = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
int xx;
SchoolX_资产报修流程表 model = new SchoolX_资产报修流程表();
if (read.Read())
{
xx = Convert.ToInt32(read["FlowID"]);
string str = string.Format("SELECT * FROM X_资产报修流程表 WHERE ID=" + xx);
SqlDataReader readd = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, str.ToString());
if (readd.Read())
{
model.报修人 = readd["报修人"].ToString();
model.报修时间 = readd["报修时间"].ToString();
model.报修单号 = readd["报修单号"].ToString();
model.报修地址 = readd["报修地址"].ToString();
model.维修人员 = readd["维修人员"].ToString();
model.解决时间 = readd["解决时间"].ToString();
model.管理员 = readd["管理员"].ToString();
model.派单时间 = readd["派单时间"].ToString();
model.报修人电话 = readd["报修人电话"].ToString();
model.维修人电话 = readd["维修人电话"].ToString();
model.管理员电话 = readd["管理员电话"].ToString();
model.故障照片 = readd["故障照片"].ToString();
model.故障原因 = readd["故障原因"].ToString();
model.结果反馈 = readd["结果反馈"].ToString();
model.设备ID = readd["设备ID"].ToString();
}
}
read.Close();
return(model);
}
public int 添加资产报修(SchoolX_资产报修流程表 model)
{
int sort = 1;
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO X_资产报修流程表 ");
sb.Append(" (流程状态,报修单号,报修人,报修时间,报修地址,故障描述,设备ID,故障照片,Sort,报修人电话");
sb.Append(" ) VALUES( ");
sb.Append(" @流程状态,@报修单号,@报修人,@报修时间,@报修地址,@故障描述,@设备ID,@故障照片," + 1 + ",@报修人电话");
sb.Append(")");
sb.Append(" SELECT ");
sb.Append(" @@identity ");
SqlParameter[] para =
{
new SqlParameter("@流程状态", model.流程状态),
new SqlParameter("@报修单号", model.报修单号),
new SqlParameter("@报修人", model.报修人),
new SqlParameter("@报修时间", model.报修时间),
new SqlParameter("@报修地址", model.报修地址),
new SqlParameter("@故障描述", model.故障描述),
new SqlParameter("@设备ID", model.设备ID),
new SqlParameter("@故障照片", model.故障照片),
//new SqlParameter("@sort",sort),
new SqlParameter("@报修人电话", model.报修人电话),
};
DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sb.ToString(), para);
return(1);
}
protected void Button8_Click(object sender, EventArgs e)
{
if (完成时间.Text == "")
{
完成时间.Text = 完成时间.EmptyText;
}
if (TextBox1.Text != "" && 完成时间.Text != "" && TextBox3.Text != "")
{
School资产报修BLL bll = new School资产报修BLL();
SchoolX_资产报修流程表 model = new SchoolX_资产报修流程表();
model.维修人电话 = TextBox1.Text;
model.完工时间 = 完成时间.Text;
model.故障原因 = TextBox3.Text;
model.维修人员 = TextBox2.Text;
model.流程状态 = "已完工，待反馈";
object a = Grid1.SelectedRow.DataKeys[0];
int id = Convert.ToInt32(a);
AM_提醒通知 ammodel = new AM_提醒通知();
ammodel.发起时间 = DateTime.Now;
ammodel.是否已读 = "否";
ammodel.通知类型 = "待办事项通知";
ammodel.通知职务 = "发起人";
ammodel.发起人 = Session["姓名"].ToString();
ammodel.消息内容 = "您来自" + ammodel.发起人 + "的资产报修完成申请,请及时处理！";
ammodel.消息事项 = "资产报修";
ammodel.是否已读 = "否";
AM_待办业务 dbmodel = new AM_待办业务();
dbmodel.处理方式 = "个人";
dbmodel.处理人 = bll.ren(id);
dbmodel.流程状态 = model.流程状态;
dbmodel.事项名称 = "资产报修";
dbmodel.发起人 = Session["姓名"].ToString();
dbmodel.通知内容 = "您来自" + dbmodel.发起人 + "的资产报修完成申请,请及时处理！";
dbmodel.FlowName = "资产报修";
dbmodel.Sort = 3;
dbmodel.发起时间 = DateTime.Now.ToLongDateString();
int xx = bll.添加完成信息(id, model, ammodel, dbmodel);
if (xx > 0)
{
grid1_bind();
Alert.ShowInTop("提交成功！");
Window5.Hidden = true;
流程状态待派单.Hidden = true;
}
else
{
Alert.ShowInTop("提交错误！");
}
}
else
{
Alert.ShowInTop("请填写信息完整！");
return;
}
}
public int 报修结算(int id, SchoolX_资产报修流程表 model, AM_提醒通知 ammodel, AM_待办业务 dbmodel)
{
try
{
string sql = string.Format("UPDATE X_资产报修流程表 SET 完工时间='{0}',结果反馈='{1}',流程状态='{2}',Sort=4 where ID=" + id, model.完工时间, model.结果反馈, model.流程状态);
DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
StringBuilder sbtz = new StringBuilder();
sbtz.Append("INSERT INTO AM_提醒通知 ");
sbtz.Append("(消息事项,消息内容,发起人,发起时间,通知类型,是否已读,通知职务,FlowID ");
sbtz.Append(" ) VALUES( ");
sbtz.Append(" @消息事项,@消息内容,@发起人,@发起时间,@通知类型,@是否已读,@通知职务,@FlowID ");
sbtz.Append(")");
SqlParameter[] paratz =
{
new SqlParameter("@消息事项", ammodel.消息事项),
new SqlParameter("@消息内容", ammodel.消息内容),
new SqlParameter("@发起人", ammodel.发起人),
new SqlParameter("@发起时间", ammodel.发起时间),
new SqlParameter("@通知类型", ammodel.通知类型),
new SqlParameter("@是否已读", ammodel.是否已读),
new SqlParameter("@通知职务", ammodel.通知职务),
new SqlParameter("@FlowID", id)
};
DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, sbtz.ToString(), paratz);
StringBuilder dbsb = new StringBuilder();
dbsb.Append("update AM_待办业务 SET ");
dbsb.Append("流程状态=@流程状态,事项名称=@事项名称,通知内容=@通知内容,发起人=@发起人,发起时间=@发起时间,处理方式=@处理方式,处理人=@处理人,FlowName=@FlowName,Sort=@Sort WHERE FlowID= " + id + " AND FlowName=@FlowName");
SqlParameter[] dbpara =
{
new SqlParameter("@流程状态", dbmodel.流程状态),
new SqlParameter("@事项名称", dbmodel.事项名称),
new SqlParameter("@通知内容", dbmodel.通知内容),
new SqlParameter("@发起人", dbmodel.发起人),
new SqlParameter("@处理人", dbmodel.处理人),
new SqlParameter("@发起时间", dbmodel.发起时间),
new SqlParameter("@处理方式", dbmodel.处理方式),
new SqlParameter("@FlowName", dbmodel.FlowName),
new SqlParameter("@Sort", dbmodel.Sort)
};
DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, dbsb.ToString(), dbpara);
return(1);
}
catch
{
return(0);
}
}
public int 添加维修信息(int id, SchoolX_资产报修流程表 model)
{
try
{
string sql = string.Format("UPDATE X_资产报修流程表 SET 管理员电话 = '{0}',维修人员='{1}',派单时间='{2}',管理员='{3}',流程状态='{4}',Sort=2 WHERE ID = " + id, model.管理员电话, model.维修人员, model.派单时间, model.管理员, model.流程状态);
DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
return(1);
}
catch
{
return(0);
}
}
public int 添加完成信息(int id, SchoolX_资产报修流程表 model)
{
try
{
string sql = string.Format("UPDATE X_资产报修流程表 SET 维修人电话='{0}',解决时间='{1}',故障原因='{2}',维修人员='{3}',流程状态='{4}',Sort=3 where ID=" + id, model.维修人电话, model.完工时间, model.故障原因, model.维修人员, model.流程状态);
DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
return(1);
}
catch
{
return(0);
}
}
public int 报修结算(int id, SchoolX_资产报修流程表 model)
{
try
{
string sql = string.Format("UPDATE X_资产报修流程表 SET 完工时间='{0}',结果反馈='{1}',流程状态='{2}',Sort=4 where ID=" + id, model.完工时间, model.结果反馈, model.流程状态);
DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
return(1);
}
catch
{
return(0);
}
}
protected void Button11_Click(object sender, EventArgs e)
{
object a = Grid1.SelectedRow.DataKeys[0];
int id = Convert.ToInt32(a);
SchoolX_资产报修流程表 model = new SchoolX_资产报修流程表();
model.完工时间 = DatePicker2.Text;
model.结果反馈 = 结果反馈.Text;
model.流程状态 = "已完成";
AM_提醒通知 ammodel = new AM_提醒通知();
ammodel.发起时间 = DateTime.Now;
ammodel.是否已读 = "否";
ammodel.通知类型 = "结果反馈通知";
ammodel.通知职务 = "发起人";
ammodel.发起人 = Session["姓名"].ToString();
ammodel.消息事项 = "资产报修";
ammodel.是否已读 = "否";
AM_待办业务 dbmodel = new AM_待办业务();
dbmodel.处理方式 = "个人";
dbmodel.处理人 = bll.ren(id);
dbmodel.流程状态 = model.流程状态;
dbmodel.事项名称 = "资产报修";
dbmodel.FlowName = dbmodel.事项名称;
dbmodel.Sort = 0;
dbmodel.发起人 = Session["姓名"].ToString();
dbmodel.通知内容 = "您来自" + dbmodel.处理人 + "的资产报修申请已完成！";
ammodel.消息内容 = "您来自" + dbmodel.处理人 + "的资产报修申请已完成！";
dbmodel.发起时间 = DateTime.Now.ToLongDateString();
int xx = bll.报修结算(id, model, ammodel, dbmodel);
if (xx > 0)
{
Alert.ShowInTop("提交成功！");
流程状态待派单.Hidden = true;
Window6.Hidden = true;
grid1_bind();
return;
}
else
{
Alert.ShowInTop("提交错误！");
}
}
public SchoolX_资产报修流程表 详情(int id)
{
SchoolX_资产报修流程表 model = new SchoolX_资产报修流程表();
string sql = string.Format("SELECT * FROM X_资产报修流程表 WHERE ID=" + id);
SqlDataReader read = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
if (read.Read())
{
model.管理员 = read["管理员"].ToString();
model.完工时间 = read["完工时间"].ToString();
model.维修人员 = read["维修人员"].ToString();
model.报修人电话 = read["报修人电话"].ToString();
model.故障原因 = read["故障原因"].ToString();
model.派单时间 = read["派单时间"].ToString();
model.管理员电话 = read["管理员电话"].ToString();
model.结果反馈 = read["结果反馈"].ToString();
model.维修人电话 = read["维修人电话"].ToString();
}
return(model);
}
public int 报修结算(int id, SchoolX_资产报修流程表 model, AM_提醒通知 ammodel, AM_待办业务 dbmodel)
{
return(sql.报修结算(id, model, ammodel, dbmodel));
}
public int 报修结算(int id, SchoolX_资产报修流程表 model)
{
return(sql.报修结算(id, model));
}
public int 添加完成信息(int id, SchoolX_资产报修流程表 model)
{
return(sql.添加完成信息(id, model));
}
public int 添加资产报修表(SchoolX_资产报修流程表 model, AM_提醒通知 ammodel, AM_待办业务 dbmodel)
{
return(sql.添加资产报修(model, ammodel, dbmodel));
}
public int 添加资产报修表(SchoolX_资产报修流程表 model)
{
return(sql.添加资产报修(model));
}
//点击查看详情
protected void Grid1_RowCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "Action1")
{
OffSession();
string username = Session["姓名"].ToString();
流程状态待派单.Hidden = false;
object[] keys = Grid1.DataKeys[e.RowIndex];
int ID = Convert.ToInt32(keys[0].ToString());//获取ID
int Sort = Convert.ToInt32(keys[9].ToString());
string 流程状态 = keys[1].ToString();
if (流程状态 == "待派单")
{
Button9.Text = "派单";
}
else if (流程状态 == "已派单，维修中")
{
Button9.Text = "派单并报修";
}
else if (流程状态 == "已完工，待反馈")
{
Button9.Text = "结果反馈";
}
xx.Text = ID.ToString();
查看报修人.Text = keys[3].ToString();
查看报修时间.Text = keys[4].ToString();
查看单号.Text = keys[2].ToString();
查看报修地址.Text = keys[5].ToString();
string zt = keys[1].ToString();
SchoolX_资产报修流程表 model = bll.详情(ID);
if (model.派单时间 != "" && model.派单时间 != null)
{
TextBox9.Text = model.派单时间;
}
else
{
TextBox9.Text = "未完成";
}
TextBox5.Text = "未完成";
TextBox6.Text = "未完成";
TextBox8.Text = "未完成";
TextBox9.Text = "未完成";
TextBox10.Text = "未完成";
TextBox11.Text = "未完成";
TextBox12.Text = "未完成";
查看故障描述.Text = "未完成";
TextBox13.Text = "未完成";
if (model.维修人员 != "" & model.维修人员 != null)
{
TextBox5.Text = model.维修人员;
}
if (model.维修人电话 != "" && model.维修人电话 != null)
{
TextBox11.Text = model.维修人电话;
}
if (model.解决时间 != "" && model.解决时间 != null)
{
TextBox6.Text = model.解决时间;
}
if (model.管理员 != "" && model.管理员 != null)
{
TextBox8.Text = model.管理员;
}
if (model.派单时间 != "" && model.派单时间 != null)
{
TextBox9.Text = model.派单时间;
}
if (model.报修人电话 != "" && model.报修人电话 != null)
{
TextBox10.Text = model.报修人电话;
}
if (model.维修人电话 != "" && model.维修人电话 != null)
{
TextBox11.Text = model.维修人电话;
}
if (model.管理员电话 != "" && model.管理员电话 != null)
{
TextBox12.Text = model.管理员电话;
}
if (model.结果反馈 != "" && model.结果反馈 != null)
{
TextBox13.Text = model.结果反馈;
}
if (model.故障原因 != "" && model.故障原因 != null)
{
查看故障描述.Text = model.故障原因;
}
if (zt == "已完成")
{
Button9.Hidden = true;
Button3.Text = "取消";
}
else if (zt == "待派单")
{
Button9.Hidden = false;
Button3.Text = "拒绝";
}
else
{
Button9.Hidden = false;
Button3.Text = "取消";
}
try
{
string iamgeurl = keys[11].ToString();
Image2.ImageUrl = iamgeurl;
}
catch (Exception)
{
}
List <int> inlist = new List <int>();
string[] sbid = keys[12].ToString().Split(',');
foreach (string item in sbid)
{
if (item == "" || item == null)
{
break;
}
inlist.Add(Convert.ToInt32(item));
}
School资产报修BLL blla = new School资产报修BLL();
List <School办公设备信息表> listdata = blla.资产转移确定设备(inlist);
Grid3.DataSource = listdata;//DataTable
Grid3.DataBind();
}
}
protected void Button6_Click(object sender, EventArgs e)
{
if (DatePicker1.Text == "")
{
DatePicker1.Text = DatePicker1.EmptyText;
}
if (TextBox4.Text != "" && DatePicker1.Text != "")
{
SchoolX_资产报修流程表 model = new SchoolX_资产报修流程表();
model.维修人员 = TextBox4.Text;
model.维修人电话 = TextBox7.Text;
model.派单时间 = DatePicker1.Text;
OffSession();
string username = Session["姓名"].ToString();
string tel = Session["电话号码"].ToString();
model.管理员 = username;
model.管理员电话 = tel;
model.流程状态 = "已派单，维修中";
AM_提醒通知 ammodel = new AM_提醒通知();
ammodel.发起时间 = DateTime.Now;
ammodel.是否已读 = "否";
ammodel.通知类型 = "待办事项通知";
ammodel.通知职务 = "维修人员";
ammodel.发起人 = Session["姓名"].ToString();
ammodel.消息内容 = "您来自" + ammodel.发起人 + "的资产报修维修申请,请及时处理！";
ammodel.消息事项 = "资产报修";
ammodel.是否已读 = "否";
AM_待办业务 dbmodel = new AM_待办业务();
dbmodel.处理方式 = "个人";
dbmodel.处理人 = model.维修人员;
dbmodel.Sort = 2;
dbmodel.流程状态 = model.流程状态;
dbmodel.事项名称 = "资产报修";
dbmodel.FlowName = "资产报修";
dbmodel.发起人 = Session["姓名"].ToString();
dbmodel.通知内容 = "您来自" + dbmodel.发起人 + "的资产报修维修申请,请及时处理！";
dbmodel.发起时间 = DateTime.Now.ToLongDateString();
School资产报修BLL bll = new School资产报修BLL();
object a = Grid1.SelectedRow.DataKeys[0];
int id = Convert.ToInt32(a);
int xx = bll.添加维修信息(id, model, ammodel, dbmodel);
if (xx > 0)
{
grid1_bind();
Window4.Hidden = true;
流程状态待派单.Hidden = true;
Alert.ShowInTop("提交成功！");
}
else
{
grid1_bind();
Alert.ShowInTop("提交错误！");
}
}
else
{
Alert.ShowInTop("请填写信息完整！");
return;
}
}
//protected void bind()
//{
// SqlConnection myConn = new SqlConnection();
// myConn.ConnectionString = "Data Source=114.115.220.70;Initial Catalog=SZ_sbgl4z;User ID=sa;Password=Bitsoft123;Integrated Security=false;Connect Timeout=30";
// myConn.Open();
// string sqlStr = "select * from X_资产报修流程表";
// SqlDataAdapter myDa = new SqlDataAdapter(sqlStr, myConn);
// DataSet myDs = new DataSet();
// myDa.Fill(myDs);
// Grid1.DataSource = myDs;
// Grid1.DataBind();
// myDa.Dispose();
// myDs.Dispose();
// myConn.Close();
//}
protected void Button2_Click(object sender, EventArgs e)
{
SchoolX_资产报修流程表 model = new SchoolX_资产报修流程表();
if (Grid2.Rows.Count == 0)
{
Alert.ShowInTop("请先添加资产！", "提示信息", MessageBoxIcon.Warning);
return;
}
DateTime dtime = DateTime.Now;
string sj = dtime.Year + "-" + dtime.Month + "-" + dtime.Day;
//获取报修时间参数
if (报修时间2.EmptyText != null && 报修时间2.Text == "")
{
报修时间2.Text = 报修时间2.EmptyText;
}
if (报修时间2.Text.ToString() != null && 报修时间2.Text.ToString() != "")
{
DateTime date = DateTime.Parse(报修时间2.Text);
string Y = date.Year.ToString(); //年
string M = date.Month.ToString(); //月
string D = date.Day.ToString(); //日
string h = Y + "-" + M + "-" + D; //拼接年月日
string di = 报修地址.SelectedText; //获取选中的一级地点
string fang = 房间1.SelectedText; //获取选中的二级地点
int[] selections = Grid4.SelectedRowIndexArray;
model.设备ID = "";
foreach (int rowIndex in selections)
{
int ID = Convert.ToInt32(Grid4.DataKeys[rowIndex][0]);
string xxx = Grid4.DataKeys[rowIndex][0].ToString();
string ss = xxx;
model.设备ID += ID.ToString() + ",";
//sb.AppendFormat("行号:{0} 用户名:{1}<br />", rowIndex + 1, Grid1.DataKeys[rowIndex][1]);
}
if (报修人.Text != "" && 联系电话.Text != "" && h != "" && 报修单号.Text != "" && di != "")
{
//判断二级地点是否为空
if (房间1.SelectedText == "" || 房间1.SelectedText == null)
{
model.报修地址 = di;
}
else
{
string F1 = "—" + fang;
model.报修地址 = di + F1;
}
if (报修地址.Text == "全部")
{
Alert.ShowInTop("请选择报修地址！");
return;
}
model.流程状态 = "待派单";
model.报修单号 = 报修单号.Text;
model.报修人 = 报修人.Text;
model.报修时间 = 报修时间2.Text;
model.故障描述 = 故障描述.Text;
string fileName = filePhoto.ShortFileName;
fileName = fileName.Replace(":", "_").Replace(" ", "_").Replace("\\", "_").Replace("/", "_");
fileName = DateTime.Now.Ticks.ToString() + "_" + fileName;
filePhoto.SaveAs(Server.MapPath("~/upload/" + fileName));
imgPhoto.ImageUrl = "~/upload/" + fileName;
model.故障照片 = "~/upload/" + fileName;
model.报修人电话 = 联系电话.Text;
//model.报修单号
AM_提醒通知 ammodel = new AM_提醒通知();
OffSession();
ammodel.发起时间 = DateTime.Now;
ammodel.是否已读 = "否";
ammodel.通知类型 = "待办事项通知";
ammodel.通知职务 = "资产管理员";
ammodel.发起人 = Session["姓名"].ToString();
ammodel.消息内容 = "您来自" + ammodel.发起人 + "的资产报修申请,请及时处理！";
ammodel.消息事项 = "资产报修";
ammodel.是否已读 = "否";
AM_待办业务 dbmodel = new AM_待办业务();
dbmodel.处理职务 = "资产管理员";
dbmodel.处理方式 = "职务";
dbmodel.FlowName = "资产报修";
dbmodel.Sort = 1;
dbmodel.流程状态 = model.流程状态;
dbmodel.事项名称 = "资产报修";
dbmodel.发起人 = Session["姓名"].ToString();
dbmodel.通知内容 = "您来自" + dbmodel.发起人 + "的资产报修申请,请及时处理！";
dbmodel.发起时间 = DateTime.Now.ToLongDateString();
int xx = bll.添加资产报修表(model, ammodel, dbmodel);
if (xx > 0)
{
Alert.ShowInTop("提交成功！", "提示信息", MessageBoxIcon.Information);
Window1.Hidden = true;
DataSet ds = bll.首页_X_资产报修流程表("全部");
DataTable dt = ds.Tables[0].Copy();//复制一份table
DataTable source = dt;
//绑定到Grid
Grid1.DataSource = dt;//DataTable
Grid1.DataBind();
return;
}
else
{
Alert.ShowInTop("添加失败！", "提示信息", MessageBoxIcon.Warning);
return;
}
// string sql="insert into dbo.X_资产报修成表 流程状态,报修单号,报修人,报修时间,报修地址,故障描述,维修人员,完工时间,结果反馈 values(1,'"+报修单号.Text+"','"+报修人.Text+"','"+h+"','"+fang+"','"+故障描述.Text+"')";
}
else
{
Alert.ShowInTop("请填写完整信息！", "提示信息", MessageBoxIcon.Warning);
return;
}
}
else
{
Alert.ShowInTop("请填写完整信息！", "提示信息", MessageBoxIcon.Warning);
return;
}
}
public int 添加资产报修(SchoolX_资产报修流程表 model, AM_提醒通知 ammodel, AM_待办业务 dbmodel)
{
int sort = 1;
try
{
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO X_资产报修流程表 ");
sb.Append(" (流程状态,报修单号,报修人,报修时间,报修地址,故障描述,设备ID,故障照片,Sort,报修人电话");
sb.Append(" ) VALUES( ");
sb.Append(" @流程状态,@报修单号,@报修人,@报修时间,@报修地址,@故障描述,@设备ID,@故障照片,@sort,@报修人电话");
sb.Append(")");
sb.Append(" SELECT ");
sb.Append(" @@identity ");
SqlParameter[] para =
{
new SqlParameter("@流程状态", model.流程状态),
new SqlParameter("@报修单号", model.报修单号),
new SqlParameter("@报修人", model.报修人),
new SqlParameter("@报修时间", model.报修时间),
new SqlParameter("@报修地址", model.报修地址),
new SqlParameter("@故障描述", model.故障描述),
new SqlParameter("@设备ID", model.设备ID),
new SqlParameter("@故障照片", model.故障照片),
new SqlParameter("@sort", sort),
new SqlParameter("@报修人电话", model.报修人电话),
};
int result = Convert.ToInt32(DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, sb.ToString(), para));
if (result > 0)
{
StringBuilder sbtz = new StringBuilder();
sbtz.Append("INSERT INTO AM_提醒通知 ");
sbtz.Append("(消息事项,消息内容,发起人,发起时间,通知类型,是否已读,通知职务,FlowID ");
sbtz.Append(" ) VALUES( ");
sbtz.Append(" @消息事项,@消息内容,@发起人,@发起时间,@通知类型,@是否已读,@通知职务,@FlowID ");
sbtz.Append(")");
SqlParameter[] paratz =
{
new SqlParameter("@消息事项", ammodel.消息事项),
new SqlParameter("@消息内容", ammodel.消息内容),
new SqlParameter("@发起人", ammodel.发起人),
new SqlParameter("@发起时间", ammodel.发起时间),
new SqlParameter("@通知类型", ammodel.通知类型),
new SqlParameter("@是否已读", ammodel.是否已读),
new SqlParameter("@通知职务", ammodel.通知职务),
new SqlParameter("@FlowID", result)
};
DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, sbtz.ToString(), paratz);
//DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, sbtz.ToString(), paratz);
StringBuilder dbsb = new StringBuilder();
dbsb.Append("INSERT INTO AM_待办业务 ");
dbsb.Append("(流程状态,FlowID,事项名称,通知内容,发起人,发起时间,处理职务,处理方式,FlowName,Sort ");
dbsb.Append(" ) VALUES( ");
dbsb.Append(" @流程状态,@FlowID,@事项名称,@通知内容,@发起人,@发起时间,@处理职务,@处理方式,@FlowName,@Sort ");
dbsb.Append(")");
SqlParameter[] dbpara =
{
new SqlParameter("@流程状态", dbmodel.流程状态),
new SqlParameter("@FlowID", result),
new SqlParameter("@事项名称", dbmodel.事项名称),
new SqlParameter("@通知内容", dbmodel.通知内容),
new SqlParameter("@发起人", dbmodel.发起人),
new SqlParameter("@发起时间", dbmodel.发起时间),
new SqlParameter("@处理职务", dbmodel.处理职务),
new SqlParameter("@处理方式", dbmodel.处理方式),
new SqlParameter("@FlowName", dbmodel.FlowName),
new SqlParameter("@Sort", dbmodel.Sort)
};
DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, dbsb.ToString(), dbpara);
return(result);
}
else
{
return(0);
}
}
catch (Exception)
{
return(0);
//throw;
}
}
