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);
}
}
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)
{
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO X_资产处置流程表 ");
sb.Append(" (Sort,FlowName,单据编号,流程状态,申请人,事项名称,申报日期,申报单位,SID,总数,总价,职务,原因说明,主管部门 ,主管部门处理时间,主管部门意见,电话,调入单位分管领导,调入单位分管领导处理时间,调入单位分管领导意见,财政部门,财政部门处理时间,财政部门意见");
sb.Append(" ) VALUES( ");
sb.Append(" @Sort,@FlowName,@单据编号,@流程状态,@申请人,@事项名称,@申报日期,@申报单位,@SID,@总数,@总价,@职务,@原因说明,@主管部门 ,@主管部门处理时间,@主管部门意见,@电话,@调入单位分管领导,@调入单位分管领导处理时间,@调入单位分管领导意见,@财政部门,@财政部门处理时间,@财政部门意见");
sb.Append(")");
sb.Append(" SELECT ");
sb.Append(" @@identity ");
SqlParameter[] para =
{
new SqlParameter("@Sort", model.Sort),
new SqlParameter("@FlowName", model.FlowName),
new SqlParameter("@单据编号", model.单据编号),
new SqlParameter("@流程状态", model.流程状态),
new SqlParameter("@申请人", model.申请人),
new SqlParameter("事项名称", model.事项名称),
new SqlParameter("@申报日期", model.申报日期),
new SqlParameter("@申报单位", model.申报单位),
new SqlParameter("@SID", model.SID),
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("@调入单位分管领导", model.调入单位分管领导),
new SqlParameter("@调入单位分管领导处理时间", model.调入单位分管领导处理时间),
new SqlParameter("@调入单位分管领导意见", model.调入单位分管领导意见),
new SqlParameter("@财政部门", model.财政部门),
new SqlParameter("@财政部门处理时间", model.财政部门处理时间),
new SqlParameter("@财政部门意见", model.财政部门意见),
};
int num = Convert.ToInt32(DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, sb.ToString(), para));
AM_提醒通知 ammodel = new AM_提醒通知();
ammodel.发起人 = model.申请人;
ammodel.发起时间 = DateTime.Now;
ammodel.是否已读 = "否";
ammodel.通知类型 = "待办事项通知";
ammodel.通知职务 = "分管领导";
ammodel.消息内容 = "您来自" + model.申请人 + "的资产处置-调拨申请通知！";
ammodel.消息事项 = "资产处置-报废";
ammodel.FlowID = num;
ammodel.处理职务 = "分管领导";
ammodel.处理方式 = "职务";
ammodel.处理人 = "分管领导";
ammodel.FlowName = "资产处置";
ammodel.流程状态 = model.流程状态;
SchoolUtility.插入消息中心(ammodel);
AM_待办业务 dbmodel = new AM_待办业务();
dbmodel.处理职务 = "分管领导";
dbmodel.发起人 = model.申请人;
dbmodel.FlowID = num;
dbmodel.流程状态 = model.流程状态;
dbmodel.事项名称 = "资产处置-报废";
dbmodel.通知内容 = "您来自" + model.申请人 + "的资产处置-报废申请,请及时处理！";
dbmodel.发起时间 = DateTime.Now.ToLongDateString();
dbmodel.处理方式 = "职务";
dbmodel.处理人 = "分管领导";
dbmodel.FlowName = "资产处置-报废";
dbmodel.Sort = model.Sort;
SchoolUtility.插入待办中心(dbmodel);
return(num);
}