//资产交接
#region 资产交接查看详情
public AM_资产交接流程表 资产交接查看详情(int id)
{
AM_资产交接流程表 model = new AM_资产交接流程表();
string sql = string.Format("SELECT * FROM AM_待办业务 WHERE ID=" + id + "AND FlowName='资产交接'");
SqlDataReader read = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
if (read.Read())
{
int 交接ID = Convert.ToInt32(read["FlowID"]);
string srr = string.Format("SELECT * FROM AM_资产交接流程表 WHERE ID=" + 交接ID);
SqlDataReader red = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, srr.ToString());
if (red.Read())
{
model.流程状态 = red["流程状态"].ToString();
model.交付人 = red["交付人"].ToString();
model.提交时间 = red["提交时间"].ToString();
model.完成时间 = red["完成时间"].ToString();
model.单据编号 = red["单据编号"].ToString();
model.接收人 = red["接收人"].ToString();
model.备注信息 = red["备注信息"].ToString();
model.资产ID = red["资产ID"].ToString();
model.ID = Convert.ToInt32(red["ID"]);
model.Sort = Convert.ToInt32(red["Sort"]);
return(model);
}
}
return(model);
}
public int 操作资产交接流程(AM_资产交接流程表 model, AM_提醒通知 ammodel, AM_待办业务 dbmodel)
{
return(sql.操作资产交接流程(model, ammodel, dbmodel));
}
public int 创建资产交接(AM_资产交接流程表 model, AM_提醒通知 ammodel, AM_待办业务 dbmodel)
{
return(sql.创建资产交接(model, ammodel, dbmodel));
}
protected void btnok_Click(object sender, EventArgs e)
{
if (btnok.Text == "确认接收")
{
string processingtime = DateTime.Now.ToShortDateString(); //处理时间
string username = Session["姓名"].ToString(); //处理人
int flowid = Convert.ToInt32(FlowID.Text);
string zcid = 资产ID.Text;
AM_资产交接流程表 model = new AM_资产交接流程表();
model.ID = flowid;
model.资产ID = zcid;
model.Sort = 1;
model.是否接收 = "是";
model.接收人 = username;
model.流程状态 = "已接收,待确认";
model.接收人接收时间 = DateTime.Now.ToLongDateString();
AM_提醒通知 ammodel = new AM_提醒通知();
ammodel.发起时间 = DateTime.Now;
ammodel.是否已读 = "否";
ammodel.通知类型 = "待办事项通知";
ammodel.通知职务 = "管理员";
ammodel.消息内容 = "已接收，待管理员确认！";
ammodel.消息事项 = "资产交接";
ammodel.发起人 = username;//处理人
ammodel.FlowID = flowid;
AM_待办业务 dbmodel = new AM_待办业务();
dbmodel.处理方式 = "职务";
dbmodel.处理职务 = "资产管理员";
dbmodel.发起人 = username;
dbmodel.FlowID = flowid;
dbmodel.流程状态 = "已接收,待确认";
dbmodel.通知内容 = username + "的资产交接已接收,请及时处理！";
dbmodel.发起时间 = DateTime.Now.ToLongDateString();
dbmodel.Sort = 2;
School资产借还交接BLL bll = new School资产借还交接BLL();
if (bll.操作资产交接流程(model, ammodel, dbmodel) > 0)
{
Alert alert = new Alert();
alert.Message = "处理成功";
alert.Title = "提示信息";
alert.MessageBoxIcon = MessageBoxIcon.Success;
alert.Show();
Window3.Hidden = true;
BindGrid();
return;
}
else
{
Alert alert = new Alert();
alert.Message = "处理失败";
alert.Title = "提示信息";
alert.MessageBoxIcon = MessageBoxIcon.Error;
alert.Show();
return;
}
}
else if (btnok.Text == "确认通过")
{
string processingtime = DateTime.Now.ToShortDateString(); //处理时间
string username = Session["姓名"].ToString(); //处理人
int flowid = Convert.ToInt32(FlowID.Text);
AM_资产交接流程表 model = new AM_资产交接流程表();
model.ID = flowid;
model.管理员是否通过 = "是";
model.管理员通过时间 = processingtime;
model.Sort = 2;
model.管理员 = username;
AM_提醒通知 ammodel = new AM_提醒通知();
ammodel.发起时间 = DateTime.Now;
ammodel.是否已读 = "否";
ammodel.通知类型 = "待办事项通知";
ammodel.通知职务 = "交付人";
ammodel.消息内容 = "您的资产交接流程已全部完成";
ammodel.消息事项 = "资产交接";
ammodel.发起人 = username;//处理人
ammodel.FlowID = flowid;
AM_待办业务 dbmodel = new AM_待办业务();
School资产借还交接BLL bll = new School资产借还交接BLL();
dbmodel.处理人 = bll.查询接收人(flowid);
dbmodel.处理职务 = "个人";
dbmodel.发起人 = username;
dbmodel.流程状态 = "已完成";
dbmodel.事项名称 = "资产交接";
dbmodel.通知内容 = "您的资产交接流程已全部完成";
dbmodel.发起时间 = DateTime.Now.ToLongDateString();
dbmodel.Sort = 0;
dbmodel.FlowID = flowid;
if (bll.操作资产交接流程(model, ammodel, dbmodel) > 0)
{
Alert alert = new Alert();
alert.Message = "处理成功";
alert.Title = "提示信息";
alert.MessageBoxIcon = MessageBoxIcon.Success;
alert.Show();
Window3.Hidden = true;
BindGrid();
return;
}
else
{
Alert alert = new Alert();
alert.Message = "处理失败";
alert.Title = "提示信息";
alert.MessageBoxIcon = MessageBoxIcon.Error;
alert.Show();
return;
}
}
}
protected void Button2_Click(object sender, EventArgs e)
{
AM_资产交接流程表 model = new AM_资产交接流程表();
if (Grid2.Rows.Count == 0)
{
Alert.ShowInTop("请先添加资产！", "提示信息", MessageBoxIcon.Warning);
return;
}
if (接收人List.SelectedText == "" || 接收人List.SelectedText == null)
{
Alert.ShowInTop("请先添加接收人！", "提示信息", MessageBoxIcon.Warning);
return;
}
model.Sort = 1;
model.流程状态 = 流程状态.Text;
model.接收人 = 接收人List.SelectedText;
model.备注信息 = 备注信息.Text;
OffSession();
model.交付人 = Session["姓名"].ToString();
model.发起人 = Session["姓名"].ToString();
model.单据编号 = 单据编号.Text;
DateTime dt = Convert.ToDateTime(提交时间.SelectedDate);
string sd = 提交时间.Text;
model.提交时间 = 提交时间.Text;
DateTime dd = Convert.ToDateTime(完成时间.SelectedDate);
model.完成时间 = 完成时间.Text;
model.接收人 = 接收人List.SelectedText;
int[] selections = Grid4.SelectedRowIndexArray;
int i = 0;
foreach (int rowIndex in selections)
{
int ID = Convert.ToInt32(Grid4.DataKeys[rowIndex][0]);
string xxx = Grid4.DataKeys[rowIndex][0].ToString();
model.资产ID += ID.ToString() + ",";
i++;
}
model.资产数量 = i.ToString();;
School资产借还交接BLL bll = new School资产借还交接BLL();
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.流程状态 = 流程状态.Text;
dbmodel.事项名称 = "资产交接";
dbmodel.FlowName = "资产交接";
dbmodel.发起人 = Session["姓名"].ToString();
dbmodel.通知内容 = "您来自" + dbmodel.发起人 + "的资产交接申请,请及时处理！";
dbmodel.发起时间 = DateTime.Now.ToLongDateString();
dbmodel.Sort = 1;
if (bll.创建资产交接(model, ammodel, dbmodel) > 0)
{
Window1.Hidden = true;
Alert.ShowInTop("创建成功！");
}
BindGrid();
}
public int 操作资产交接流程(AM_资产交接流程表 model, AM_提醒通知 ammodel, AM_待办业务 dbmodel)
{
try
{
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", ammodel.FlowID)
};
DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, sbtz.ToString(), paratz);
if (model.Sort == 1)//接收
{
string sql = string.Format("UPDATE AM_资产交接流程表 SET 是否接收 ='{0}' ,接收人接收时间 = '{1}' , 接收人 = '{2}',Sort=2 ,流程状态='已接收,待确认' where ID = {3}", model.是否接收, model.接收人接收时间, model.接收人, model.ID);
DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
string sdd = string.Format("SELECT ID FROM 用户表 WHERE 姓名='{0}'", model.接收人);
SqlDataReader read = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sdd.ToString());
int 用户ID;
if (read.Read())
{
用户ID = Convert.ToInt32(read["ID"]);
string swww = string.Format("SELECT * FROM AM_资产交接流程表 WHERE ID='{0}'", model.ID);
SqlDataReader wwread = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, swww.ToString());
if (wwread.Read())
{
string 资产ID = wwread["资产ID"].ToString();
string[] zcid = 资产ID.Split(',');
for (int i = 0; i < zcid.Length - 1; i++)
{
if (zcid[i] != "" || zcid[i] != null)
{
int xx = Convert.ToInt32(zcid[i]);
string sqd = string.Format("UPDATE 办公设备信息表 SET 归属教师ID=" + 用户ID + " where ID=" + xx);
DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sqd.ToString());
}
}
}
}
}
else if (model.Sort == 2) //管理员确认完成
{
string sql = string.Format("UPDATE AM_资产交接流程表 SET 管理员 ='{0}' ,管理员通过时间 = '{1}',管理员是否通过='{2}' ,Sort=0 ,流程状态='完成' where ID = {3}", model.管理员, model.管理员通过时间, model.管理员是否通过, model.ID);
DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
}
string sqlup = string.Format("UPDATE AM_待办业务 SET 流程状态='{0}',通知内容 ='{1}' ,处理职务='{2}',Sort='{3}',处理方式='{4}' where FlowID = {5} and FlowName='资产交接'", dbmodel.流程状态, dbmodel.通知内容, dbmodel.处理职务, dbmodel.Sort, dbmodel.处理方式, dbmodel.FlowID);
DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sqlup.ToString());
return(1);
}
catch (Exception)
{
return(0);
}
}
public int 创建资产交接(AM_资产交接流程表 model, AM_提醒通知 ammodel, AM_待办业务 dbmodel)
{
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO AM_资产交接流程表 ");
sb.Append(" (流程状态,Sort,发起人,单据编号,资产数量,交付人,接收人,提交时间,备注信息,完成时间,资产ID");
sb.Append(" ) VALUES( ");
sb.Append(" @流程状态,@Sort,@发起人,@单据编号,@资产数量,@交付人,@接收人,@提交时间,@备注信息,@完成时间,@资产ID");
sb.Append(")");
sb.Append(" SELECT ");
sb.Append(" @@identity ");
SqlParameter[] para =
{
new SqlParameter("@流程状态", model.流程状态),
new SqlParameter("@Sort", model.Sort),
new SqlParameter("@发起人", model.发起人),
new SqlParameter("@单据编号", model.单据编号),
new SqlParameter("@资产数量", model.资产数量),
new SqlParameter("@交付人", model.交付人),
new SqlParameter("@接收人", model.接收人),
new SqlParameter("@提交时间", model.提交时间),
new SqlParameter("@备注信息", model.备注信息),
new SqlParameter("@完成时间", model.完成时间),
new SqlParameter("@资产ID", model.资产ID),
};
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("@Sort", dbmodel.Sort),
new SqlParameter("@事项名称", dbmodel.事项名称),
new SqlParameter("@FlowName", dbmodel.FlowName)
};
DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, dbsb.ToString(), dbpara);
return(result);
}
else
{
return(0);
}
}
