public int 处置申报报废处理流程(SchoolX_资产处置流程表 model)
{
try
{
//分管领导通过
if (model.Sort == 1)
{
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE X_资产处置流程表 SET 调入单位分管领导意见 =@调入单位分管领导意见 ,调入单位分管领导处理时间 = @调入单位分管领导处理时间 , 调入单位分管领导 = @调入单位分管领导,");
sb.Append(" Sort=2 ,流程状态='分管领导已通过,待主管部门审核' where ID = @ID");
SqlParameter[] para =
{
new SqlParameter("@调入单位分管领导意见", model.调入单位分管领导意见),
new SqlParameter("@调入单位分管领导处理时间", model.调入单位分管领导处理时间),
new SqlParameter("@调入单位分管领导", model.调入单位分管领导),
//new SqlParameter("@原因说明",model.原因说明),
new SqlParameter("@ID", model.ID),
};
int num = Convert.ToInt32(DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, sb.ToString(), para));
AM_提醒通知 ammodel = new AM_提醒通知();
ammodel.消息事项 = "资产处置";
ammodel.消息内容 = "您来自" + model.调入单位分管领导 + "的资产处置报废申请分管领导已通过！";
ammodel.发起人 = model.调入单位分管领导;
ammodel.发起时间 = DateTime.Now;
ammodel.通知类型 = "待办事项通知";
ammodel.是否已读 = "否";
ammodel.通知职务 = "主管部门";
ammodel.FlowID = model.ID;
ammodel.FlowName = "资产处置-报废";
ammodel.处理职务 = "主管部门";
ammodel.处理方式 = "职务";
ammodel.处理人 = "主管部门";
ammodel.流程状态 = "分管领导已通过,待主管部门审核";
SchoolUtility.插入消息中心(ammodel);
AM_待办业务 upmodel = new AM_待办业务();
upmodel.流程状态 = "分管领导已通过,待主管部门审核";
upmodel.通知内容 = "您来自" + model.调入单位分管领导 + "的资产处置报废申请分管领导已通过,请及时处理！";
upmodel.处理职务 = "主管部门";
upmodel.处理方式 = "职务";
upmodel.发起时间 = DateTime.Now.ToLongDateString();
upmodel.处理人 = "主管部门";
upmodel.Sort = 2;
upmodel.FlowID = model.ID;
upmodel.事项名称 = "资产处置-报废";
upmodel.FlowName = upmodel.事项名称;
SchoolUtility.修改待办中心(upmodel);
}
//主管部门审核
else if (model.Sort == 2)
{
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE X_资产处置流程表 SET 主管部门 =@主管部门 ,主管部门处理时间 = @主管部门处理时间 ,Sort=3 ,");
sb.Append("流程状态='主管部门已审核通过,待财政部门审核',主管部门意见=@主管部门意见 where ID = @ID");
SqlParameter[] para =
{
new SqlParameter("@主管部门", model.主管部门),
new SqlParameter("@主管部门处理时间", model.主管部门处理时间),
new SqlParameter("@主管部门意见", model.主管部门意见),
new SqlParameter("@ID", model.ID),
};
int num = Convert.ToInt32(DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, sb.ToString(), para));
AM_提醒通知 ammodel = new AM_提醒通知();
ammodel.消息事项 = "资产处置";
ammodel.消息内容 = "您来自" + model.主管部门 + "的资产处置报废申请主管部门已通过！";
ammodel.发起人 = model.主管部门;
ammodel.发起时间 = DateTime.Now;
ammodel.通知类型 = "待办事项通知";
ammodel.是否已读 = "否";
ammodel.通知职务 = "财务人员";
ammodel.FlowID = model.ID;
ammodel.FlowName = "资产处置-报废";
ammodel.处理职务 = "财务人员";
ammodel.处理方式 = "职务";
ammodel.处理人 = "财务人员";
ammodel.流程状态 = "主管部门已通过,待财务部门审核";
SchoolUtility.插入消息中心(ammodel);
AM_待办业务 upmodel = new AM_待办业务();
upmodel.处理职务 = "财务人员";
upmodel.处理方式 = "职务";
upmodel.处理人 = "财务人员";
upmodel.流程状态 = "主管部门已通过,待财务部门审核";
upmodel.事项名称 = "资产处置-报废";
upmodel.FlowID = model.ID;
upmodel.Sort = 3;
upmodel.FlowName = upmodel.事项名称;
upmodel.通知内容 = "您来自" + model.主管部门 + "的资产处置报废申请主管部门已通过,请及时处理！";
upmodel.发起时间 = DateTime.Now.ToLongDateString();
SchoolUtility.修改待办中心(upmodel);
}
//财政部门审核
else if (model.Sort == 3)
{
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE X_资产处置流程表 SET 财政部门意见 =@财政部门意见,财政部门处理时间 =@财政部门处理时间 ,财政部门=@财政部门 ,Sort=0 ,");
sb.Append("流程状态='完成' where ID = @ID");
SqlParameter[] para =
{
new SqlParameter("@财政部门意见", model.财政部门意见),
new SqlParameter("@财政部门处理时间", model.财政部门处理时间),
new SqlParameter("@财政部门", model.财政部门),
new SqlParameter("@ID", model.ID),
};
int num = Convert.ToInt32(DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, sb.ToString(), para));
AM_提醒通知 ammodel = new AM_提醒通知();
ammodel.消息事项 = "资产处置";
ammodel.消息内容 = "您来自" + model.财政部门 + "的资产处置报废申请分管领导已通过！";
ammodel.发起人 = model.财政部门;
ammodel.发起时间 = DateTime.Now;
ammodel.通知类型 = "待办事项通知";
ammodel.是否已读 = "否";
ammodel.通知职务 = "财务部门";
ammodel.FlowID = model.ID;
ammodel.FlowName = "资产处置-报废";
ammodel.处理职务 = "财务部门";
ammodel.处理方式 = "财务";
ammodel.处理人 = "财务人员";
ammodel.流程状态 = "您的资产处置流程已全部完成！";
SchoolUtility.插入消息中心(ammodel);
AM_待办业务 upmodel = new AM_待办业务();
upmodel.处理职务 = "财务人员";
upmodel.处理方式 = "职务";
upmodel.处理人 = "财务人员";
upmodel.流程状态 = "完成";
upmodel.事项名称 = "资产处置-报废";
upmodel.FlowID = model.ID;
upmodel.Sort = 0;
upmodel.FlowName = upmodel.事项名称;
upmodel.通知内容 = "您的资产处置流程已全部完成";
upmodel.发起时间 = DateTime.Now.ToLongDateString();
SchoolUtility.修改待办中心(upmodel);
}
//else if (model.Sort == 6)
//{
// string sql = string.Format("UPDATE dbo.X_资产处置流程表 set 财政部门意见 = '{0}' , 财政部门处理时间 = '{1}' ,财政部门='{2}' ,Sort = {3} ,流程状态='{4}' where ID = {5} and FlowName='{6}'", model.财政部门意见, model.财政部门处理时间, model.财政部门, model.Sort, model.流程状态, model.ID, model.FlowName);
// int result = DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
// AM_提醒通知 ammodel = new AM_提醒通知();
// ammodel.发起人 = model.主管部门;
// ammodel.发起时间 = DateTime.Now;
// ammodel.是否已读 = "否";
// ammodel.通知类型 = "待办事项通知";
// ammodel.通知职务 = "资产管理员";
// ammodel.消息内容 = "您来自" + model.主管部门 + "的资产处置-调拨处理通知！";
// ammodel.消息事项 = "资产处置-调拨";
// ammodel.FlowID = model.ID;
// ammodel.处理职务 = "主管部门";
// ammodel.处理方式 = "职务";
// ammodel.处理人 = "主管部门";
// ammodel.FlowName = "资产处置-调拨";
// ammodel.流程状态 = model.流程状态;
// ammodel.Sort = model.Sort;
// SchoolUtility.插入消息中心(ammodel);
// AM_待办业务 dbmodel = new AM_待办业务();
// dbmodel.流程状态 = model.流程状态;
// dbmodel.处理职务 = "主管部门";
// dbmodel.处理方式 = "职务";
// dbmodel.处理人 = "主管部门";
// dbmodel.FlowName = model.FlowName;
// dbmodel.FlowID = model.ID;
// dbmodel.通知内容 = "您来自" + model.主管部门 + "的资产处置-调拨处理,请及时处理！";
// dbmodel.Sort = model.Sort;
// SchoolUtility.修改待办中心(dbmodel);
//}
return(1);
}
catch (Exception)
{
return(0);
}
}
public int 操作购置验收流程(SchoolX_购置验收流程表 model, AM_提醒通知 ammodel)
{
string sql = string.Format("UPDATE X_购置验收流程表 SET 是否同意 ='{0}' ,操作时间 = '{1}' , 操作人 = '{2}',Sort=0 ,流程状态='完成',记账人='{3}' where ID = {4}", model.是否同意, model.操作时间, model.操作人, model.记账人, model.ID);
string sqlzc = string.Format("UPDATE 办公设备信息表 SET 是否通过审批='{0}' where X_ID={1}", model.是否同意, model.ID);
AM_待办业务 dbmodel = new AM_待办业务();
dbmodel.流程状态 = "完成";
dbmodel.通知内容 = "您来自" + model.操作人 + "的购置验收结果通知！";
dbmodel.处理职务 = "财政人员";
dbmodel.处理方式 = "职务";
//dbmodel.发起时间 = DateTime.Now.ToLongDateString();
dbmodel.处理人 = "财政人员";
dbmodel.Sort = 0;
dbmodel.FlowID = model.ID;
dbmodel.事项名称 = "购置验收";
dbmodel.FlowName = dbmodel.事项名称;
SchoolUtility.修改待办中心(dbmodel);
//StringBuilder dbsb = new StringBuilder();
//dbsb.Append("update AM_待办业务 SET ");
//dbsb.Append("流程状态=@流程状态,通知内容=@通知内容,处理人=@处理人,发起时间=@发起时间,处理方式=@处理方式,处理职务=@处理职务,Sort=@Sort WHERE FlowID= " + model.ID + " AND FlowName='资产转移'");
//SqlParameter[] dbpara = {
// new SqlParameter("@流程状态",dbmodel.流程状态),
// new SqlParameter("@通知内容",dbmodel.通知内容),
// new SqlParameter("@处理人",dbmodel.处理人),
// new SqlParameter("@发起时间",dbmodel.发起时间),
// new SqlParameter("@处理方式",dbmodel.处理方式),
// new SqlParameter("@处理职务",dbmodel.处理职务),
// new SqlParameter("@Sort",dbmodel.Sort)
// };
//DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, dbsb.ToString(), dbpara);
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);
DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sqlzc.ToString());
return(DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString()));
}
public int 调拨流程处理(SchoolX_资产处置流程表 model)
{
if (model.Sort == 2)//分管领导处理
{
string sql = string.Format("UPDATE dbo.X_资产处置流程表 set 调出单位分管领导意见 = '{0}' , 调出单位分管领导 = '{1}' ,调出单位分管领导处理时间='{2}' ,Sort = {3} ,流程状态='{4}' where ID = {5} and FlowName='{6}'", model.调出单位分管领导意见, model.调出单位分管领导, model.调出单位分管领导处理时间, model.Sort, model.流程状态, model.ID, model.FlowName);
int result = DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
AM_提醒通知 ammodel = new AM_提醒通知();
ammodel.发起人 = model.调出单位分管领导;
ammodel.发起时间 = DateTime.Now;
ammodel.是否已读 = "否";
ammodel.通知类型 = "待办事项通知";
ammodel.通知职务 = "资产管理员";
ammodel.消息内容 = "您来自" + model.调出单位分管领导 + "的资产处置-调拨处理通知！";
ammodel.消息事项 = "资产处置-调拨";
ammodel.FlowID = model.ID;
ammodel.处理职务 = "资产管理员";
ammodel.处理方式 = "职务";
ammodel.处理人 = "资产管理员";
ammodel.FlowName = "资产处置-调拨";
ammodel.流程状态 = model.流程状态;
ammodel.Sort = model.Sort;
SchoolUtility.插入消息中心(ammodel);
AM_待办业务 dbmodel = new AM_待办业务();
dbmodel.流程状态 = model.流程状态;
dbmodel.通知内容 = "您来自" + model.调出单位分管领导 + "的资产处置-调拨处理,请及时处理！";
dbmodel.处理职务 = "资产管理员";
dbmodel.处理方式 = "职务";
//dbmodel.发起时间 = DateTime.Now.ToLongDateString();
dbmodel.处理人 = "资产管理员";
dbmodel.Sort = model.Sort;
dbmodel.FlowID = model.ID;
dbmodel.事项名称 = "资产处置-调拨";
dbmodel.FlowName = dbmodel.事项名称;
SchoolUtility.修改待办中心(dbmodel);
return(result);
}
else if (model.Sort == 3)
{
string sql = string.Format("UPDATE dbo.X_资产处置流程表 set 调入单位管理员意见 = '{0}' , 调入单位管理员 = '{1}' ,调入单位管理员处理时间='{2}' ,Sort = {3} ,流程状态='{4}' where ID = {5} and FlowName='{6}'", model.调入单位管理员意见, model.调入单位管理员, model.调入单位管理员处理时间, model.Sort, model.流程状态, model.ID, model.FlowName);
int result = DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
AM_提醒通知 ammodel = new AM_提醒通知();
ammodel.发起人 = model.调入单位管理员;
ammodel.发起时间 = DateTime.Now;
ammodel.是否已读 = "否";
ammodel.通知类型 = "待办事项通知";
ammodel.通知职务 = "资产管理员";
ammodel.消息内容 = "您来自" + model.调入单位管理员 + "的资产处置-调拨处理通知！";
ammodel.消息事项 = "资产处置-调拨";
ammodel.FlowID = model.ID;
ammodel.处理职务 = "分管领导";
ammodel.处理方式 = "职务";
ammodel.处理人 = "分管领导";
ammodel.FlowName = "资产处置-调拨";
ammodel.流程状态 = model.流程状态;
ammodel.Sort = model.Sort;
SchoolUtility.插入消息中心(ammodel);
AM_待办业务 dbmodel = new AM_待办业务();
dbmodel.流程状态 = model.流程状态;
dbmodel.通知内容 = "您来自" + model.调入单位管理员 + "的资产处置-调拨处理,请及时处理！";
dbmodel.处理职务 = "分管领导";
dbmodel.处理方式 = "职务";
//dbmodel.发起时间 = DateTime.Now.ToLongDateString();
dbmodel.处理人 = "分管领导";
dbmodel.Sort = model.Sort;
dbmodel.FlowID = model.ID;
dbmodel.事项名称 = "资产处置-调拨";
dbmodel.FlowName = dbmodel.事项名称;
SchoolUtility.修改待办中心(dbmodel);
return(result);
}
else if (model.Sort == 4)
{
string sql = string.Format("UPDATE dbo.X_资产处置流程表 set 调入单位分管领导意见 = '{0}' , 调入单位分管领导 = '{1}' ,调入单位分管领导处理时间='{2}' ,Sort = {3} ,流程状态='{4}' where ID = {5} and FlowName='{6}'", model.调入单位分管领导意见, model.调入单位分管领导, model.调入单位分管领导处理时间, model.Sort, model.流程状态, model.ID, model.FlowName);
int result = DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
AM_提醒通知 ammodel = new AM_提醒通知();
ammodel.发起人 = model.调入单位分管领导;
ammodel.发起时间 = DateTime.Now;
ammodel.是否已读 = "否";
ammodel.通知类型 = "待办事项通知";
ammodel.通知职务 = "资产管理员";
ammodel.消息内容 = "您来自" + model.调入单位分管领导 + "的资产处置-调拨处理通知！";
ammodel.消息事项 = "资产处置-调拨";
ammodel.FlowID = model.ID;
ammodel.处理职务 = "主管部门";
ammodel.处理方式 = "职务";
ammodel.处理人 = "主管部门";
ammodel.FlowName = "资产处置-调拨";
ammodel.流程状态 = model.流程状态;
ammodel.Sort = model.Sort;
SchoolUtility.插入消息中心(ammodel);
AM_待办业务 dbmodel = new AM_待办业务();
dbmodel.流程状态 = model.流程状态;
dbmodel.通知内容 = "您来自" + model.调入单位分管领导 + "的资产处置-调拨处理,请及时处理！";
dbmodel.处理职务 = "主管部门";
dbmodel.处理方式 = "职务";
//dbmodel.发起时间 = DateTime.Now.ToLongDateString();
dbmodel.处理人 = "主管部门";
dbmodel.Sort = model.Sort;
dbmodel.FlowID = model.ID;
dbmodel.事项名称 = "资产处置-调拨";
dbmodel.FlowName = model.FlowName;
SchoolUtility.修改待办中心(dbmodel);
return(result);
}
else if (model.Sort == 5)
{
string sql = string.Format("UPDATE dbo.X_资产处置流程表 set 主管部门意见 = '{0}' , 主管部门处理时间 = '{1}' ,主管部门='{2}' ,Sort = {3} ,流程状态='{4}' where ID = {5} and FlowName='{6}'", model.主管部门意见, model.主管部门处理时间, model.主管部门, model.Sort, model.流程状态, model.ID, model.FlowName);
int result = DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
AM_提醒通知 ammodel = new AM_提醒通知();
ammodel.发起人 = model.主管部门;
ammodel.发起时间 = DateTime.Now;
ammodel.是否已读 = "否";
ammodel.通知类型 = "待办事项通知";
ammodel.通知职务 = "主管部门";
ammodel.消息内容 = "您来自" + model.主管部门 + "的资产处置-调拨处理通知！";
ammodel.消息事项 = "资产处置-调拨";
ammodel.FlowID = model.ID;
ammodel.处理职务 = "财务人员";
ammodel.处理方式 = "职务";
ammodel.处理人 = "财务人员";
ammodel.FlowName = "资产处置-调拨";
ammodel.流程状态 = model.流程状态;
ammodel.Sort = model.Sort;
SchoolUtility.插入消息中心(ammodel);
AM_待办业务 dbmodel = new AM_待办业务();
dbmodel.流程状态 = model.流程状态;
dbmodel.通知内容 = "您来自" + model.主管部门 + "的资产处置-调拨处理,请及时处理！";
dbmodel.处理职务 = "财务人员";
dbmodel.处理方式 = "职务";
dbmodel.发起时间 = DateTime.Now.ToLongDateString();
dbmodel.处理人 = "财务人员";
dbmodel.Sort = model.Sort;
dbmodel.FlowID = model.ID;
dbmodel.事项名称 = "资产处置-调拨";
dbmodel.FlowName = model.FlowName;
SchoolUtility.修改待办中心(dbmodel);
return(result);
}
else if (model.Sort == 6)
{
string sql = string.Format("UPDATE dbo.X_资产处置流程表 set 财政部门意见 = '{0}' , 财政部门处理时间 = '{1}' ,财政部门='{2}' ,Sort = {3} ,流程状态='{4}' where ID = {5} and FlowName='{6}'", model.财政部门意见, model.财政部门处理时间, model.财政部门, model.Sort, model.流程状态, model.ID, model.FlowName);
int result = DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
AM_提醒通知 ammodel = new AM_提醒通知();
ammodel.发起人 = model.财政部门;
ammodel.发起时间 = DateTime.Now;
ammodel.是否已读 = "否";
ammodel.通知类型 = "待办事项通知";
ammodel.通知职务 = "财政部门";
ammodel.消息内容 = "您来自" + model.财政部门 + "的资产处置-调拨处理通知！";
ammodel.消息事项 = "资产处置-调拨";
ammodel.FlowID = model.ID;
ammodel.处理职务 = "资产管理员";
ammodel.处理方式 = "职务";
ammodel.处理人 = "资产管理员";
ammodel.FlowName = "资产处置-调拨";
ammodel.流程状态 = model.流程状态;
ammodel.Sort = model.Sort;
SchoolUtility.插入消息中心(ammodel);
/*
* AM_待办业务 upmodel = new AM_待办业务();
* 1 upmodel.流程状态 = "分管领导已通过,待主管部门审核";
* 1 upmodel.通知内容 = "您来自" + model.调入单位分管领导 + "的资产处置报废申请分管领导已通过,请及时处理！";
* 1 upmodel.处理职务 = "主管部门";
* 1 upmodel.处理方式 = "职务";
* upmodel.发起时间 = DateTime.Now.ToLongDateString();
* 1 upmodel.处理人 = "主管部门";
* 1 upmodel.Sort = 2;
* 1 upmodel.FlowID = model.ID;
* upmodel.事项名称 = "资产处置-报废";
* 1 upmodel.FlowName = upmodel.事项名称;
* SchoolUtility.修改待办中心(upmodel);
*/
AM_待办业务 dbmodel = new AM_待办业务();
dbmodel.流程状态 = model.流程状态;
dbmodel.处理职务 = "资产管理员";
dbmodel.处理方式 = "职务";
dbmodel.处理人 = "资产管理员";
dbmodel.FlowName = model.FlowName;
dbmodel.FlowID = model.ID;
dbmodel.通知内容 = "您来自" + model.财政部门 + "的资产处置-调拨处理,请及时处理！";
dbmodel.Sort = model.Sort;
SchoolUtility.修改待办中心(dbmodel);
return(result);
}
else if (model.Sort == 7)
{
string sql = string.Format("UPDATE dbo.X_资产处置流程表 set 调出单位管理员处理时间 = '{0}' ,调出单位管理员='{1}' ,Sort = {2} ,流程状态='{3}' where ID = {4} and FlowName='{5}'", model.调出单位管理员处理时间, model.调出单位管理员, model.Sort, model.流程状态, model.ID, model.FlowName);
int result = DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
AM_提醒通知 ammodel = new AM_提醒通知();
ammodel.发起人 = model.调出单位管理员;
ammodel.发起时间 = DateTime.Now;
ammodel.是否已读 = "否";
ammodel.通知类型 = "待办事项通知";
ammodel.通知职务 = "资产管理员";
ammodel.消息内容 = "您来自" + model.调出单位管理员 + "的资产处置-调拨处理通知！";
ammodel.消息事项 = "资产处置-调拨";
ammodel.FlowID = model.ID;
ammodel.处理职务 = "资产管理员";
ammodel.处理方式 = "职务";
ammodel.处理人 = "资产管理员";
ammodel.FlowName = "资产处置-调拨";
ammodel.流程状态 = model.流程状态;
ammodel.Sort = model.Sort;
SchoolUtility.插入消息中心(ammodel);
AM_待办业务 dbmodel = new AM_待办业务();
dbmodel.流程状态 = model.流程状态;
dbmodel.处理职务 = "资产管理员";
dbmodel.处理方式 = "职务";
dbmodel.处理人 = "资产管理员";
dbmodel.FlowName = model.FlowName;
dbmodel.FlowID = model.ID;
dbmodel.通知内容 = "您来自" + model.调出单位管理员 + "的资产处置-调拨处理,请及时处理！";
dbmodel.Sort = model.Sort;
SchoolUtility.修改待办中心(dbmodel);
return(result);
}
else if (model.Sort == 0)
{
string sql = string.Format("UPDATE dbo.X_资产处置流程表 set 调入单位管理员确认处理时间 = '{0}' ,调入单位管理员确认='{1}' ,Sort = {2} ,流程状态='{3}' where ID = {4} and FlowName='{5}'", model.调入单位管理员确认处理时间, model.调入单位管理员确认, model.Sort, model.流程状态, model.ID, model.FlowName);
int result = DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString());
AM_提醒通知 ammodel = new AM_提醒通知();
ammodel.发起人 = model.调入单位管理员确认;
ammodel.发起时间 = DateTime.Now;
ammodel.是否已读 = "否";
ammodel.通知类型 = "待办事项通知";
ammodel.通知职务 = "资产管理员";
ammodel.消息内容 = "您来自" + model.调入单位管理员确认 + "的资产处置-调拨处理通知！";
ammodel.消息事项 = "资产处置-调拨";
ammodel.FlowID = model.ID;
ammodel.处理职务 = "调入单位管理员";
ammodel.处理方式 = "职务";
ammodel.处理人 = "调入单位管理员";
ammodel.FlowName = "资产处置-调拨";
ammodel.流程状态 = model.流程状态;
ammodel.Sort = model.Sort;
SchoolUtility.插入消息中心(ammodel);
AM_待办业务 dbmodel = new AM_待办业务();
dbmodel.流程状态 = model.流程状态;
dbmodel.处理职务 = "调入单位管理员";
dbmodel.处理方式 = "职务";
dbmodel.处理人 = "调入单位管理员";
dbmodel.FlowName = model.FlowName;
dbmodel.FlowID = model.ID;
dbmodel.通知内容 = "您来自" + model.调入单位管理员确认 + "的资产处置-调拨处理,请及时处理！";
dbmodel.Sort = model.Sort;
SchoolUtility.修改待办中心(dbmodel);
return(result);
}
else
{
return(0);
}
}