protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// 1.获取数据总数
流程状态.Text = "待审核";
string str = "ZCZY";
单据编号.Text = SchoolUtility.strbumber(str);
OffSession();
申请人.Text = HttpContext.Current.Session["姓名"].ToString();
Button9.Enabled = false;
Button3.Enabled = false;
二级.Enabled = false;
级.Enabled = false;
负责人.Enabled = false;
房间.Enabled = false;
// 2.获取当前分页数据
//DataTable table = GetPagedDataTable(Grid1.PageIndex, Grid1.PageSize);//查询方法
DataSet ds = bll.首页_X_资产转移流程表("流程状态-全部");
DataTable dt = ds.Tables[0].Copy();//复制一份table
DataTable source = dt;
// 3.绑定到Grid
Grid1.DataSource = dt;//DataTable
Grid1.DataBind();
List <School一级部门表> gsbm = bll.byzc();
归属部门变更为.DataTextField = "名称";
归属部门变更为.DataValueField = "ID";
归属部门变更为.DataSource = gsbm;
归属部门变更为.DataBind();
List <School房间信息表> cfdd = bll.cfdd();
存放地点变更为.DataTextField = "名称";
存放地点变更为.DataValueField = "ID";
存放地点变更为.DataSource = cfdd;
存放地点变更为.DataBind();
}
}
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 插入X_购置验收流程表(SchoolX_购置验收流程表 model, List <School办公设备信息表> listmodel, AM_提醒通知 ammodel)
{
try
{
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO X_购置验收流程表 ");
sb.Append(" (流程状态,单据编号,事项名称,备注信息,数量合计,金额合计,申请人,制单日期,供应商,供应商联系方式,合同编号,发票号 ");
sb.Append(",取得方式,购置日期,Sort");
sb.Append(" ) VALUES( ");
sb.Append(" @流程状态,@单据编号,@事项名称,@备注信息,@数量合计,@金额合计,@申请人,@制单日期,@供应商,@供应商联系方式,@合同编号,@发票号 ");
sb.Append(",@取得方式,@购置日期,@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("@申请人", model.申请人),
new SqlParameter("@制单日期", model.制单日期),
new SqlParameter("@供应商", model.供应商),
new SqlParameter("@供应商联系方式", model.供应商联系方式),
new SqlParameter("@合同编号", model.合同编号),
new SqlParameter("@发票号", model.发票号),
new SqlParameter("@取得方式", model.取得方式),
new SqlParameter("@购置日期", model.购置日期),
new SqlParameter("@Sort", 1),
//new SqlParameter("@Sort",model),
};
int num = Convert.ToInt32(DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, sb.ToString(), para));
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("@发起时间", model.购置日期),
new SqlParameter("@通知类型", ammodel.通知类型),
new SqlParameter("@是否已读", ammodel.是否已读),
new SqlParameter("@通知职务", ammodel.通知职务),
new SqlParameter("@FlowID", num)
};
DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, sbtz.ToString(), paratz);
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 = 1;
SchoolUtility.插入待办中心(dbmodel);
List <string> cstrlist = new List <string>();
string csqls = "";
string csssqls = "";
if (num > 0)
{
try
{
for (int i = 0; i < listmodel.Count; i++)
{
string part = listmodel[i].str归属部门;
csssqls = string.Format(" SELECT * FROM dbo.一级部门表 WHERE 名称= '" + part + "'");
SqlDataReader read = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, csssqls.ToString());
List <School办公设备信息表> list = new List <School办公设备信息表>();
int 归属部门_ID = 0;
while (read.Read())
{
School办公设备信息表 model_a = new School办公设备信息表();
model_a.ID = Convert.ToInt32(read["ID"].ToString());
归属部门_ID = model_a.ID;
}
//int 归属部门_ID = model_a.ID;
csqls = string.Format("INSERT INTO 办公设备信息表 (编号,类型,名称,型号,使用方向,数量,价格,归属部门,负责人,存放地点,使用状态,X_ID,是否通过审批,购置日期,二级类别名称,三级类别名称) VALUES('{0}','{1}','{2}','{3}','{4}',{5},{6},{7},'{8}','{9}','{10}',{11},'{12}','{13}','{14}','{15}')", listmodel[i].编号, listmodel[i].一级类别名称, listmodel[i].称, listmodel[i].型号, listmodel[i].使用方向, listmodel[i].数量, listmodel[i].价格, 归属部门_ID, listmodel[i].负责人, listmodel[i].存放地点, listmodel[i].资产状态, num, "否", model.购置日期, listmodel[i].二级类别名称, listmodel[i].级类别名称);
cstrlist.Add(csqls.ToString());
}
int copyunitcount = DBHelper.ExecuteSqlTran(cstrlist);
return(copyunitcount);
}
catch (Exception)
{
return(-1);//转换数字出错
throw;
}
}
else
{
return(0);
}
}
catch (Exception ex)
{
return(0);
//throw;
}
}
//确认申报
protected void Button1_Click(object sender, EventArgs e)
{
if (类别.SelectedValue.ToString() == "待报废")
{
if (类别.SelectedValue.ToString() == "待报废")
{
OffSession();
string 职务 = Session["职务"].ToString();
List <int> intlist = new List <int>();
int[] selections = Grid2.SelectedRowIndexArray;
Console.Write(selections.Length);
if (selections.Length == 0)
{
Alert.Show("请选择");
}
else
{
Window2.Hidden = false;
Console.Write(selections);
foreach (int rowIndex in selections)
{
int ID = Convert.ToInt32(Grid2.DataKeys[rowIndex][0]);
intlist.Add(ID);
}
List <School办公设备信息表> listdata = bll.资产申报确定设备(intlist, 类别.SelectedValue);
string flowstate = 类别.SelectedValue;
//int 总数 = 0;
//int 总价 = 0;
float 总数 = 0.0f;
float 总价 = 0.0f;
if (listdata != null)
{
foreach (School办公设备信息表 itemjj in listdata)
{
总数 += itemjj.数量;
总价 += Convert.ToInt32(itemjj.价格);
}
}
Grid3.DataSource = listdata;//DataTable
Grid3.DataBind();
Grid4.DataSource = listdata;//DataTable
Grid4.DataBind();
JObject summary = new JObject();
//summary.Add("major", "全部合计");
summary.Add("数量", 总数.ToString("F2"));
summary.Add("价格", 总价.ToString("F2"));
Grid3.SummaryData = summary;
Grid4.SummaryData = summary;
//Grid7.SummaryData = summary;
//Grid8.SummaryData = summary;
//待报废Grid3
报废流程状态.Text = "待审核";
报废流程状态.Enabled = false;
报废_申报单位.Text = Session["二级部门名称"].ToString();
报废_申报单位.Enabled = false;
报废_申报日期.Text = DateTime.Now.ToShortDateString();
报废单据编号.Text = SchoolUtility.strbumber("ZCCZBF");;
报废单据编号.Enabled = false;
报废_申请人.Text = HttpContext.Current.Session["姓名"].ToString();
报废_申请人.Enabled = false;
报废_职务.Text = 职务;
报废_职务.Enabled = false;
}
}
}
else if (类别.SelectedValue.ToString() == "待调拨")
{
OffSession();
string 职务 = Session["职务"].ToString();
if (职务 == "资产管理员")
{
School清查盘点BLL pdbll = new School清查盘点BLL();
List <School一级部门表> xxmc = SchoolUtility.查询一级部门不带全部();;
调拨调入单位.DataTextField = "名称";
调拨调入单位.DataValueField = "ID";
调拨调入单位.DataSource = xxmc;
调拨调入单位.DataBind();
List <int> intlist = new List <int>();
int[] selections = Grid2.SelectedRowIndexArray;
if (selections.Length == 0)
{
Alert.Show("请选择");
}
else
{
Window3.Hidden = false;
foreach (int rowIndex in selections)
{
int ID = Convert.ToInt32(Grid2.DataKeys[rowIndex][0]);
intlist.Add(ID);
}
List <School办公设备信息表> listdata = bll.资产申报确定设备(intlist, 类别.SelectedValue);
string flowstate = 类别.SelectedValue;
Grid5.DataSource = listdata;//DataTable
Grid5.DataBind();
Grid6.DataSource = listdata;
Grid6.DataBind();
//当前用户部门是调出单位 调入单位操作人选填
调拨流程状态.Text = "待审核";
调拨流程状态.Enabled = false;
调拨调出单位.Text = Session["二级部门名称"].ToString();
调拨调出单位.Enabled = false;
调拨申报日期.Text = DateTime.Now.ToShortDateString();
调拨验收日期.Text = DateTime.Now.ToShortDateString();
DateTime dt = DateTime.Now;
string y = dt.Year.ToString();
string m = dt.Month.ToString();
string d = dt.Day.ToString();
string h = dt.Hour.ToString();
string mm = dt.Minute.ToString();
调拨单据编号.Text = SchoolUtility.strbumber("ZCCZDB");
调拨单据编号.Enabled = false;
调拨_申请人.Text = HttpContext.Current.Session["姓名"].ToString();
调拨_申请人.Enabled = false;
调拨职务.Enabled = false;
调拨电话.Enabled = false;
调拨职务.Text = HttpContext.Current.Session["职务"].ToString();
try
{
调拨电话.Text = HttpContext.Current.Session["联系电话"].ToString();
}
catch (Exception)
{
调拨电话.Text = "";
}
}
}
else
{
Alert.Show("您没有资产处置-调拨处理的权限，请联系资产管理员", MessageBoxIcon.Warning);
}
}
}
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)
{
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)
{
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);
}
