//资产交接 #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); } }