public static int 插入消息中心(AM_提醒通知 ammodel) { StringBuilder sbtz = new StringBuilder(); sbtz.Append("INSERT INTO AM_提醒通知 "); sbtz.Append("(消息事项,消息内容,发起人,发起时间,通知类型,是否已读,通知职务,FlowID,处理职务,处理方式,处理人,FlowName,流程状态,Sort "); sbtz.Append(" ) VALUES( "); sbtz.Append(" @消息事项,@消息内容,@发起人,@发起时间,@通知类型,@是否已读,@通知职务,@FlowID,@处理职务,@处理方式,@处理人,@FlowName,@流程状态,@Sort "); 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), new SqlParameter("@处理职务", ammodel.处理职务), new SqlParameter("@处理方式", ammodel.处理方式), new SqlParameter("@处理人", ammodel.处理人), new SqlParameter("@FlowName", ammodel.FlowName), new SqlParameter("@流程状态", ammodel.流程状态), new SqlParameter("@Sort", ammodel.Sort), }; return(Convert.ToInt32(DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, sbtz.ToString(), paratz))); }
public int 操作原值变动流程(SchoolX_原值变动流程表 model, AM_提醒通知 ammodel) { string sql = string.Format("UPDATE X_原值变动流程表 SET 是否同意 ='{0}' ,操作时间 = '{1}' , 操作人 = '{2}',Sort=2 ,流程状态='完成' where ID = {3}", model.是否同意, model.操作时间, model.操作人, model.ID); 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); return(DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString())); }
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 strid = model.资产ID; strid = strid.Substring(0, strid.Length - 1);//删除最后一个字符 string[] arr = strid.Split(','); List <string> worklist = new List <string>(); string workstr = ""; foreach (string item in arr) { workstr = string.Format(" UPDATE 办公设备信息表 SET 借用 = {0} where ID = {1}", 1, item); worklist.Add(workstr.ToString()); } DBHelper.ExecuteSqlTran(worklist); } else if (model.Sort == 2)//已归还待确认 { string sql = string.Format("UPDATE AM_资产借还流程表 SET 申请人是否归还 ='{0}' ,申请人归还时间 = '{1}' ,Sort=3 ,流程状态='已归还,待确认' where ID = {2}", model.申请人是否归还, model.申请人归还时间, model.ID); DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString()); } else if (model.Sort == 3) //完成 { string sql = string.Format("UPDATE AM_资产借还流程表 SET 出借人确认归还 ='{0}' ,出借人确认时间 = '{1}' ,Sort=0 ,流程状态='完成' where ID = {2}", model.出借人确认归还, model.出借人确认时间, model.ID); DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString()); } string sqlup = string.Format("UPDATE AM_待办业务 SET 流程状态='{0}',通知内容 ='{1}' ,处理方式='{2}',处理人='{3}',Sort='{4}' where FlowID = {5} and FlowName='{6}'", dbmodel.流程状态, dbmodel.通知内容, dbmodel.处理方式, dbmodel.处理人, dbmodel.Sort, dbmodel.FlowID, dbmodel.FlowName); return(DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sqlup.ToString())); } catch (Exception) { return(0); } }
public int 新增原值变动(SchoolX_原值变动流程表 model, List <School办公设备信息表> workmodel, AM_提醒通知 ammodel, AM_待办业务 dbmodel) { string sql = string.Format("INSERT INTO X_原值变动流程表 (流程状态,单据编号,事项名称,申请人,申请日期,记账人,总数,总价,变动方式,变动原因,记账人意见,备注信息,资产ID,str变动金额,Sort)VALUES('{0}','{1}','{2}','{3}','{4}','{5}',{6},{7},'{8}','{9}','{10}','{11}','{12}','{13}','{14}')SELECT @@identity", model.流程状态, model.单据编号, model.事项名称, model.申请人, model.申请日期, model.记账人, model.总数, model.总价, model.变动方式, model.变动原因, model.记账人意见, model.备注, model.资产ID, model.str变动金额, 1); int result = Convert.ToInt32(DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, sql)); 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); StringBuilder dbsb = new StringBuilder(); dbsb.Append("INSERT INTO AM_待办业务 "); dbsb.Append("(流程状态,FlowID,事项名称,通知内容,发起人,发起时间,处理职务 "); dbsb.Append(" ) VALUES( "); dbsb.Append(" @流程状态,@FlowID,@事项名称,@通知内容,@发起人,@发起时间,@处理职务 "); 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.处理职务) }; DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, dbsb.ToString(), dbpara); List <string> worklist = new List <string>(); string workstr = ""; for (int i = 0; i < workmodel.Count; i++) { workstr = string.Format(" UPDATE 办公设备信息表 SET 变动金额 = {0} where ID = {1}", workmodel[i].变动金额, workmodel[i].ID); worklist.Add(workstr.ToString()); } return(DBHelper.ExecuteSqlTran(worklist)); } else { return(0); } }
protected void Button8_Click(object sender, EventArgs e) { if (完成时间.Text == "") { 完成时间.Text = 完成时间.EmptyText; } if (TextBox1.Text != "" && 完成时间.Text != "" && TextBox3.Text != "") { School资产报修BLL bll = new School资产报修BLL(); SchoolX_资产报修流程表 model = new SchoolX_资产报修流程表(); model.维修人电话 = TextBox1.Text; model.完工时间 = 完成时间.Text; model.故障原因 = TextBox3.Text; model.维修人员 = TextBox2.Text; model.流程状态 = "已完工,待反馈"; object a = Grid1.SelectedRow.DataKeys[0]; int id = Convert.ToInt32(a); AM_提醒通知 ammodel = new AM_提醒通知(); ammodel.发起时间 = DateTime.Now; ammodel.是否已读 = "否"; ammodel.通知类型 = "待办事项通知"; ammodel.通知职务 = "发起人"; ammodel.发起人 = Session["姓名"].ToString(); ammodel.消息内容 = "您来自" + ammodel.发起人 + "的资产报修完成申请,请及时处理!"; ammodel.消息事项 = "资产报修"; ammodel.是否已读 = "否"; AM_待办业务 dbmodel = new AM_待办业务(); dbmodel.处理方式 = "个人"; dbmodel.处理人 = bll.ren(id); dbmodel.流程状态 = model.流程状态; dbmodel.事项名称 = "资产报修"; dbmodel.发起人 = Session["姓名"].ToString(); dbmodel.通知内容 = "您来自" + dbmodel.发起人 + "的资产报修完成申请,请及时处理!"; dbmodel.FlowName = "资产报修"; dbmodel.Sort = 3; dbmodel.发起时间 = DateTime.Now.ToLongDateString(); int xx = bll.添加完成信息(id, model, ammodel, dbmodel); if (xx > 0) { grid1_bind(); Alert.ShowInTop("提交成功!"); Window5.Hidden = true; 流程状态待派单.Hidden = true; } else { Alert.ShowInTop("提交错误!"); } } else { Alert.ShowInTop("请填写信息完整!"); return; } }
public int 报修结算(int id, SchoolX_资产报修流程表 model, AM_提醒通知 ammodel, AM_待办业务 dbmodel) { try { string sql = string.Format("UPDATE X_资产报修流程表 SET 完工时间='{0}',结果反馈='{1}',流程状态='{2}',Sort=4 where ID=" + id, model.完工时间, model.结果反馈, model.流程状态); DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString()); 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", id) }; DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, sbtz.ToString(), paratz); StringBuilder dbsb = new StringBuilder(); dbsb.Append("update AM_待办业务 SET "); dbsb.Append("流程状态=@流程状态,事项名称=@事项名称,通知内容=@通知内容,发起人=@发起人,发起时间=@发起时间,处理方式=@处理方式,处理人=@处理人,FlowName=@FlowName,Sort=@Sort WHERE FlowID= " + id + " AND FlowName=@FlowName"); SqlParameter[] dbpara = { new SqlParameter("@流程状态", dbmodel.流程状态), new SqlParameter("@事项名称", dbmodel.事项名称), new SqlParameter("@通知内容", dbmodel.通知内容), new SqlParameter("@发起人", dbmodel.发起人), new SqlParameter("@处理人", dbmodel.处理人), new SqlParameter("@发起时间", dbmodel.发起时间), new SqlParameter("@处理方式", dbmodel.处理方式), new SqlParameter("@FlowName", dbmodel.FlowName), new SqlParameter("@Sort", dbmodel.Sort) }; DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, dbsb.ToString(), dbpara); return(1); } catch { return(0); } }
protected void Button9_Click(object sender, EventArgs e) { OffSession(); string username = Session["姓名"].ToString(); AM_提醒通知 ammodel = new AM_提醒通知(); ammodel.发起时间 = DateTime.Now; ammodel.是否已读 = "否"; ammodel.通知类型 = "结果反馈通知"; ammodel.通知职务 = "资产管理员"; ammodel.发起人 = username; ammodel.消息内容 = "您来自" + ammodel.发起人 + "的资产转移已完成!"; ammodel.消息事项 = "资产转移"; ammodel.是否已读 = "否"; AM_待办业务 dbmodel = new AM_待办业务(); dbmodel.处理方式 = "职务"; dbmodel.处理职务 = "资产管理员"; dbmodel.流程状态 = "已完成"; dbmodel.发起人 = ammodel.发起人; dbmodel.通知内容 = "您来自" + dbmodel.发起人 + "的资产转移已完成!"; dbmodel.发起时间 = DateTime.Now.ToLongDateString(); dbmodel.Sort = 0; //执行修改 int id = Convert.ToInt16(xx.Text); if (id > 0) { int num = bll.修改数据(id, 查看归属部门变更为.Text, 查看存放地点变更为.Text, 查看负责人变更为.Text, ammodel, dbmodel); if (num > 0) { Alert.ShowInTop("转移成功!", "提示信息", MessageBoxIcon.Information); 新增资产转移查看详情.Hidden = true; DataSet ds = bll.首页_X_资产转移流程表("流程状态-全部"); DataTable dt = ds.Tables[0].Copy();//复制一份table DataTable source = dt; // 3.绑定到Grid Grid1.DataSource = dt;//DataTable Grid1.DataBind(); } } else { Alert.ShowInTop("未获取选择行!", "警告信息", MessageBoxIcon.Error); } // }
protected void Button4_Click(object sender, EventArgs e) { if (Button4.Text == "同意") { string username = Session["姓名"].ToString(); //处理人 string processingtime = DateTime.Now.ToShortDateString(); //处理时间 int FlowID = Convert.ToInt32(flowid.Text); SchoolX_原值变动流程表 model = new SchoolX_原值变动流程表(); model.ID = FlowID; model.操作人 = username; model.操作时间 = processingtime; model.是否同意 = "是"; AM_提醒通知 ammodel = new AM_提醒通知(); ammodel.发起时间 = DateTime.Now; ammodel.是否已读 = "否"; ammodel.通知类型 = "结果反馈通知"; ammodel.通知职务 = "发起人"; ammodel.消息内容 = "原值变动任务已全部完成!"; ammodel.消息事项 = "原值变动"; ammodel.发起人 = username;//处理人 ammodel.FlowID = FlowID; if (bll.操作原值变动流程(model, ammodel) > 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 { //不同意 } }
//处置申报待报废处理流程 public int 处置申报待报废处理流程(SchoolX_资产处置流程表 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 X_资产处置流程表 SET 是否同意 ='{0}' ,分管领导通过时间 = '{1}' , 申请人 = '{2}',Sort=2 ,流程状态='分管领导已通过,待主管部门审核' where ID = {3}", model.是否同意, model.分管领导通过时间, model.申请人, model.ID); //DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString()); } else if (model.Sort == 2)//主管部门审核 { //string sql = string.Format("UPDATE X_资产处置流程表 SET 主管部门确认通过 ='{0}' ,主管部门通过时间 = '{1}' ,Sort=3 ,流程状态='主管部门已审核通过,待财政部门审核' where ID = {2}", model.主管部门确认通过, model.主管部门通过时间, model.ID); //DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString()); } else if (model.Sort == 3) //财政部门审核 { //string sql = string.Format("UPDATE X_资产处置流程表 SET 财务部门确认通过 ='是' ,财政部门通过时间 = '2020/2/4' ,Sort=0 ,流程状态='完成' where ID = {2}", model.财政部门确认通过, model.财政部门通过时间, model.ID); //DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql.ToString()); } string sqlup = string.Format("UPDATE AM_待办业务 SET 流程状态='{0}',通知内容 ='{1}' ,处理职务='{2}' where FlowID = {3} and 事项名称='{4}'", dbmodel.流程状态, dbmodel.通知内容, dbmodel.处理职务, dbmodel.FlowID, dbmodel.事项名称); return(DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sqlup.ToString())); } catch (Exception) { return(0); } }
public List <AM_提醒通知> 判断颜色() { string sql = string.Format("SELECT * FROM AM_提醒通知"); SqlDataReader read = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sql.ToString()); List <AM_提醒通知> list = new List <AM_提醒通知>(); while (read.Read()) { AM_提醒通知 model = new AM_提醒通知(); model.是否已读 = read["是否已读"].ToString(); model.ID = Convert.ToInt32(read["ID"]); list.Add(model); } read.Close(); return(list); }
protected void Button11_Click(object sender, EventArgs e) { object a = Grid1.SelectedRow.DataKeys[0]; int id = Convert.ToInt32(a); SchoolX_资产报修流程表 model = new SchoolX_资产报修流程表(); model.完工时间 = DatePicker2.Text; model.结果反馈 = 结果反馈.Text; model.流程状态 = "已完成"; AM_提醒通知 ammodel = new AM_提醒通知(); ammodel.发起时间 = DateTime.Now; ammodel.是否已读 = "否"; ammodel.通知类型 = "结果反馈通知"; ammodel.通知职务 = "发起人"; ammodel.发起人 = Session["姓名"].ToString(); ammodel.消息事项 = "资产报修"; ammodel.是否已读 = "否"; AM_待办业务 dbmodel = new AM_待办业务(); dbmodel.处理方式 = "个人"; dbmodel.处理人 = bll.ren(id); dbmodel.流程状态 = model.流程状态; dbmodel.事项名称 = "资产报修"; dbmodel.FlowName = dbmodel.事项名称; dbmodel.Sort = 0; dbmodel.发起人 = Session["姓名"].ToString(); dbmodel.通知内容 = "您来自" + dbmodel.处理人 + "的资产报修申请已完成!"; ammodel.消息内容 = "您来自" + dbmodel.处理人 + "的资产报修申请已完成!"; dbmodel.发起时间 = DateTime.Now.ToLongDateString(); int xx = bll.报修结算(id, model, ammodel, dbmodel); if (xx > 0) { Alert.ShowInTop("提交成功!"); 流程状态待派单.Hidden = true; Window6.Hidden = true; grid1_bind(); return; } else { Alert.ShowInTop("提交错误!"); } }
public int 修改数据(int ID, string 归属部门变更为, string 存放地点变更为, string 负责人变更为, AM_提醒通知 ammodel, AM_待办业务 dbmodel) { 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", ID) }; DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, sbtz.ToString(), paratz); StringBuilder dbsb = new StringBuilder(); dbsb.Append("update AM_待办业务 SET "); dbsb.Append("流程状态=@流程状态,通知内容=@通知内容,发起人=@发起人,发起时间=@发起时间,处理方式=@处理方式,处理职务=@处理职务,Sort=@Sort WHERE FlowID= " + 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); string sql = string.Format("SELECT * FROM dbo.X_资产转移流程表 WHERE ID = {0}", ID); SqlDataReader read = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sql.ToString()); string SID = ""; if (read.Read()) { SID = read["S_ID"].ToString(); } read.Close(); string[] condition = { "," }; string[] result = SID.Split(condition, StringSplitOptions.RemoveEmptyEntries); List <int> inlist = new List <int>(); foreach (string item in result) { inlist.Add(Convert.ToInt32(item)); } int upgsbm = 0; int upcfdd = 0; int upfzr = 0; string sqlx = string.Format("SELECT ID FROM dbo.一级部门表 where 名称='{0}'", 归属部门变更为); SqlDataReader readx = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sqlx.ToString()); while (readx.Read()) { upgsbm = Convert.ToInt32(readx["ID"]); } readx.Close(); string sqlup2 = string.Format("SELECT * from dbo.房间信息表 where 名称 = '{0}'", 存放地点变更为); SqlDataReader readup2 = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sqlup2.ToString()); while (readup2.Read()) { upcfdd = Convert.ToInt32(readup2["ID"]); } readup2.Close(); string sqlup3 = string.Format("SELECT * FROM 用户表 where 姓名 = '{0}'", 负责人变更为); SqlDataReader readup3 = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sqlup3.ToString()); while (readup3.Read()) { upfzr = Convert.ToInt32(readup3["ID"]); } readup3.Close(); List <string> cstrlist = new List <string>(); string csqls = ""; for (int i = 0; i < inlist.Count; i++) { csqls = string.Format(" UPDATE 办公设备信息表 SET 归属部门 = {0} ,位置 = {1}, 归属教师ID = {2} where ID = {3}", upgsbm, upcfdd, upfzr, inlist[i]); cstrlist.Add(csqls.ToString()); } string sqlflowstate = string.Format("UPDATE X_资产转移流程表 SET 流程状态='已完成' where ID = {0}", ID); DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sqlflowstate.ToString()); return(DBHelper.ExecuteSqlTran(cstrlist)); }
public int 处置申报待报废处理流程(SchoolX_资产处置流程表 model, AM_提醒通知 ammodel, AM_待办业务 dbmodel) { return(sql.处置申报待报废处理流程(model, ammodel, dbmodel)); }
public int 操作原值变动流程(SchoolX_原值变动流程表 model, AM_提醒通知 ammodel) { return(sql.操作原值变动流程(model, ammodel)); }
public int upzczy(SchoolX_资产转移流程表 model, List <int> listid, List <SchoolX_资产转移改动信息表> listmodel, AM_提醒通知 ammodel, AM_待办业务 dbmodel) { try { StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO X_资产转移流程表 "); sb.Append(" (流程状态,单据编号,事项名称,申请人,申请日期,联系方式,存放地点变更为,归属部门变更为,负责人变更为,备注信息,S_ID,总数,总价,Sort "); sb.Append(" ) VALUES( "); sb.Append(" @流程状态,@单据编号,@事项名称,@申请人,@申请日期,@联系方式,@存放地点变更为,@归属部门变更为,@负责人变更为,@备注信息,@S_ID,@总数,@总价," + 1); 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("@S_ID", model.S_ID), new SqlParameter("@总数", model.总数), new SqlParameter("@总价", 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("@发起时间", ammodel.发起时间), new SqlParameter("@通知类型", ammodel.通知类型), new SqlParameter("@是否已读", ammodel.是否已读), new SqlParameter("@通知职务", ammodel.通知职务), new SqlParameter("@FlowID", num) }; 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", num), 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); List <string> strlist = new List <string>(); string sqlzy = ""; for (int i = 0; i < listmodel.Count; i++) { sqlzy = string.Format("INSERT INTO [X_资产转移改动信息表] ([转移流程表ID],[办公设备信息表ID],[原存放地点],[原归属部门],[原负责人],[现存放地点],[现归属部门],[现负责人]) VALUES ({0},{1},'{2}','{3}','{4}','{5}','{6}','{7}')", num, listid[i], listmodel[i].原存放地点, listmodel[i].原归属部门, listmodel[i].原负责人, model.存放地点变更为, model.归属部门变更为, model.负责人变更为); strlist.Add(sqlzy); } int XX = DBHelper.ExecuteSqlTran(strlist); //int AA = XX; return(XX); //if (num > 0) //{ // int upgsbm = 0; // int upcfdd = 0; // int upfzr = 0; // string sql = string.Format("SELECT ID FROM dbo.一级部门表 where 名称='{0}'", model.归属部门变更为); // SqlDataReader read = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sql.ToString()); // while (read.Read()) // { // upgsbm = Convert.ToInt32(read["ID"]); // } // read.Close(); // string sqlup2 = string.Format("SELECT * from dbo.房间信息表 where 名称 = '{0}'", model.存放地点变更为); // SqlDataReader readup2 = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sqlup2.ToString()); // while (readup2.Read()) // { // upcfdd = Convert.ToInt32(readup2["ID"]); // } // readup2.Close(); // string sqlup3 = string.Format("SELECT * FROM 用户表 where 姓名 = '{0}'", model.负责人变更为); // SqlDataReader readup3 = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sqlup3.ToString()); // while (readup3.Read()) // { // upfzr = Convert.ToInt32(readup3["ID"]); // } // readup3.Close(); // List<string> cstrlist = new List<string>(); // string csqls = ""; // for (int i = 0; i < listid.Count; i++) // { // csqls = string.Format(" UPDATE 办公设备信息表 SET 归属部门 = {0} ,位置 = {1}, 归属教师ID = {2} where ID = {3}", upgsbm, upcfdd, upfzr, listid[i]); // cstrlist.Add(csqls.ToString()); // } // return DBHelper.ExecuteSqlTran(cstrlist); //} //else //{ // return 0; //} } catch (Exception) { return(0); //throw; } //return sql.upzczy(model, listid); }
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.借出人操作时间 = processingtime; model.是否同意 = "是"; model.操作人 = username; model.Sort = 1; AM_提醒通知 ammodel = new AM_提醒通知(); ammodel.发起时间 = DateTime.Now; ammodel.是否已读 = "否"; ammodel.通知类型 = "待办事项通知"; ammodel.通知职务 = "发起人"; ammodel.消息内容 = "资产借还任务已全部完成!"; ammodel.消息事项 = "资产借还"; ammodel.发起人 = username;//处理人 ammodel.FlowID = flowid; AM_待办业务 dbmodel = new AM_待办业务(); dbmodel.处理方式 = "个人"; dbmodel.处理人 = model.借用人; dbmodel.发起人 = username; dbmodel.FlowID = flowid; dbmodel.流程状态 = "已出借,待归还"; dbmodel.事项名称 = "资产借还"; dbmodel.通知内容 = "您来自" + username + "的资产借还已同意,请及时处理!"; dbmodel.Sort = 2; dbmodel.FlowName = "资产借还"; dbmodel.发起时间 = DateTime.Now.ToLongDateString(); School资产借还交接BLL bll = new School资产借还交接BLL(); string sql = string.Format("UPDATE dbo.AM_待办业务 set 流程状态 = '{0}',处理职务='{1}',处理方式='{2}',处理人='{3}' where FlowID = {4} AND FlowName = '{5}'", ammodel.流程状态, ammodel.处理职务, ammodel.处理方式, ammodel.处理人, ammodel.FlowID, ammodel.FlowName); 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 == "确认归还") { School资产借还交接BLL bll = new School资产借还交接BLL(); string processingtime = DateTime.Now.ToShortDateString(); //处理时间 string username = Session["姓名"].ToString(); //处理人 int flowid = Convert.ToInt32(FlowID.Text); string 出借人 = bll.查询出借人(flowid); AM_资产借还流程表 model = new AM_资产借还流程表(); model.ID = flowid; model.申请人是否归还 = "是"; model.申请人归还时间 = processingtime; model.Sort = 2; AM_提醒通知 ammodel = new AM_提醒通知(); ammodel.发起时间 = DateTime.Now; ammodel.是否已读 = "否"; ammodel.通知类型 = "待办事项通知"; ammodel.通知职务 = "出借人"; ammodel.消息内容 = "资产借还流程" + username + "已归还,等待借出人确认。"; ammodel.消息事项 = "资产借还"; ammodel.发起人 = username;//处理人 ammodel.FlowID = flowid; AM_待办业务 dbmodel = new AM_待办业务(); dbmodel.处理方式 = "个人"; dbmodel.处理人 = 出借人; dbmodel.发起人 = username; dbmodel.流程状态 = "已归还,待确认"; dbmodel.事项名称 = "资产借还"; dbmodel.通知内容 = "您来自" + username + "的资产借还归还申请,请及时处理!"; dbmodel.发起时间 = DateTime.Now.ToLongDateString(); dbmodel.FlowID = flowid; dbmodel.FlowName = "资产借还"; dbmodel.Sort = 3; 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 = 3; AM_提醒通知 ammodel = new AM_提醒通知(); ammodel.发起时间 = DateTime.Now; ammodel.是否已读 = "否"; ammodel.通知类型 = "结果反馈通知"; ammodel.通知职务 = "发起人"; ammodel.消息内容 = "您来自" + username + "的资产借还已同意,请及时处理!"; ammodel.消息事项 = "资产借还"; ammodel.发起人 = username;//处理人 ammodel.FlowID = flowid; AM_待办业务 dbmodel = new AM_待办业务(); dbmodel.处理方式 = ""; dbmodel.处理人 = ""; dbmodel.发起人 = username; dbmodel.流程状态 = "完成"; dbmodel.事项名称 = "资产借还"; dbmodel.通知内容 = "您的资产借还流程已全部完成"; dbmodel.发起时间 = DateTime.Now.ToLongDateString(); dbmodel.FlowID = flowid; dbmodel.Sort = 0; dbmodel.FlowName = "资产借还"; 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; } } }
public int 新增原值变动(SchoolX_原值变动流程表 model, List <School办公设备信息表> workmodel, AM_提醒通知 ammodel, AM_待办业务 dbmodel) { return(sql.新增原值变动(model, workmodel, ammodel, dbmodel)); }
public int 插入X_购置验收流程表(SchoolX_购置验收流程表 model, List <School办公设备信息表> listmodel, AM_提醒通知 ammodel) { return(us.插入X_购置验收流程表(model, listmodel, ammodel)); }
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())); }
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 Button1_Click(object sender, EventArgs e) { //获取原存放地 string sid = ""; List <int> inlist = new List <int>(); int 总数 = 0; int 总价 = 0; //获取grid3选中行数据 int[] selections = Grid3.SelectedRowIndexArray; List <SchoolX_资产转移改动信息表> listmodel = new List <SchoolX_资产转移改动信息表>(); foreach (int rowIndex in selections) { SchoolX_资产转移改动信息表 modelx = new SchoolX_资产转移改动信息表(); int ID = Convert.ToInt32(Grid3.DataKeys[rowIndex][0]); modelx.原存放地点 = Grid3.DataKeys[rowIndex][1].ToString(); modelx.原归属部门 = Grid3.DataKeys[rowIndex][2].ToString(); modelx.原负责人 = Grid3.DataKeys[rowIndex][3].ToString(); sid += ID.ToString() + ","; inlist.Add(ID); listmodel.Add(modelx); //sb.AppendFormat("行号:{0} 用户名:{1}<br />", rowIndex + 1, Grid1.DataKeys[rowIndex][1]); } List <School办公设备信息表> listdata = bll.资产转移确定设备(inlist); foreach (School办公设备信息表 itemjj in listdata) { 总数 += itemjj.数量; 总价 += Convert.ToInt32(itemjj.价格); } SchoolX_资产转移流程表 model = new SchoolX_资产转移流程表(); model.流程状态 = 流程状态.Text; model.单据编号 = 单据编号.Text; model.事项名称 = 事项名称.Text; model.申请人 = 申请人.Text; model.申请日期 = 申请日期.Text; model.联系方式 = 联系方式.Text; model.存放地点变更为 = 存放地点变更为.SelectedItem.Text; model.归属部门变更为 = 归属部门变更为.SelectedItem.Text; model.负责人变更为 = 负责人变更为.SelectedItem.Text; model.备注信息 = 备注.Text; model.S_ID = sid; model.总数 = 总数; model.总价 = 总价; AM_提醒通知 ammodel = new AM_提醒通知(); ammodel.发起时间 = DateTime.Now; ammodel.是否已读 = "否"; ammodel.通知类型 = "待办事项通知"; ammodel.通知职务 = "资产管理员"; ammodel.发起人 = model.申请人; ammodel.消息内容 = "您来自" + ammodel.发起人 + "的资产交接申请,请及时处理!"; ammodel.消息事项 = "资产转移"; ammodel.是否已读 = "否"; AM_待办业务 dbmodel = new AM_待办业务(); dbmodel.处理方式 = "职务"; dbmodel.处理职务 = "资产管理员"; dbmodel.流程状态 = 流程状态.Text; dbmodel.事项名称 = model.事项名称; dbmodel.FlowName = "资产转移"; dbmodel.发起人 = model.申请人; dbmodel.通知内容 = "您来自" + dbmodel.发起人 + "的资产交接申请,请及时处理!"; dbmodel.发起时间 = DateTime.Now.ToLongDateString(); dbmodel.Sort = 1; if (model.存放地点变更为 == "" || model.存放地点变更为 == null || model.归属部门变更为 == "" || model.归属部门变更为 == null || model.负责人变更为 == "" || model.负责人变更为 == "请选择") { Alert.ShowInTop("请将信息填写完整!", "提示信息", MessageBoxIcon.Warning); return; } else { int result = bll.upzczy(model, inlist, listmodel, ammodel, dbmodel); if (result > 0) { Alert.ShowInTop("提交成功!", "提示信息", MessageBoxIcon.Information); Window1.Hidden = true; DataSet ds = bll.首页_X_资产转移流程表("流程状态-全部"); DataTable dt = ds.Tables[0].Copy();//复制一份table DataTable source = dt; // 3.绑定到Grid Grid1.DataSource = dt;//DataTable Grid1.DataBind(); return; } } }
public int 操作购置验收流程(SchoolX_购置验收流程表 model, AM_提醒通知 txmodel) { return(us.操作购置验收流程(model, txmodel)); }
public int 创建资产交接(AM_资产交接流程表 model, AM_提醒通知 ammodel, AM_待办业务 dbmodel) { return(sql.创建资产交接(model, ammodel, dbmodel)); }
public int 添加资产报修(SchoolX_资产报修流程表 model, AM_提醒通知 ammodel, AM_待办业务 dbmodel) { int sort = 1; try { StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO X_资产报修流程表 "); sb.Append(" (流程状态,报修单号,报修人,报修时间,报修地址,故障描述,设备ID,故障照片,Sort,报修人电话"); sb.Append(" ) VALUES( "); sb.Append(" @流程状态,@报修单号,@报修人,@报修时间,@报修地址,@故障描述,@设备ID,@故障照片,@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("@设备ID", model.设备ID), new SqlParameter("@故障照片", model.故障照片), new SqlParameter("@sort", sort), new SqlParameter("@报修人电话", model.报修人电话), }; 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("@处理方式", dbmodel.处理方式), new SqlParameter("@FlowName", dbmodel.FlowName), new SqlParameter("@Sort", dbmodel.Sort) }; DBHelper.ExecuteScalar(DBHelper.ConnectionString, CommandType.Text, dbsb.ToString(), dbpara); return(result); } else { return(0); } } catch (Exception) { return(0); //throw; } }
public int 添加资产报修表(SchoolX_资产报修流程表 model, AM_提醒通知 ammodel, AM_待办业务 dbmodel) { return(sql.添加资产报修(model, ammodel, dbmodel)); }
protected void Button2_Click(object sender, EventArgs e) { AM_资产借还流程表 model = new AM_资产借还流程表(); if (Grid2.Rows.Count == 0) { Alert.ShowInTop("请先添加资产!", "提示信息", MessageBoxIcon.Warning); return; } model.Sort = 1; model.流程状态 = 流程状态.Text; model.发起人 = 借用人.Text; model.借出人 = 借出人.Text; model.借用人 = 借用人.Text; model.提交时间 = 提交时间.Text; if (预计归还时间.Text == null || 预计归还时间.Text == "") { Alert.ShowInTop("请输入归还时间!", "提示信息", MessageBoxIcon.Warning); return; } model.预计归还时间 = 预计归还时间.Text; model.单据编号 = 单据编号.Text; model.借出人 = 借出人.Text; model.借用时间 = 借用时间.Text; model.备注信息 = 备注信息.Text; int[] selections = Grid4.SelectedRowIndexArray; int 资产数量 = 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() + ","; 资产数量++; } model.资产数量 = 资产数量.ToString(); School资产借还交接BLL bll = new School资产借还交接BLL(); AM_提醒通知 ammodel = new AM_提醒通知(); ammodel.发起人 = 借用人.Text; ammodel.发起时间 = DateTime.Now; ammodel.是否已读 = "否"; ammodel.通知类型 = "待办事项通知"; ammodel.通知职务 = "财务人员"; ammodel.消息内容 = "您来自" + 借用人.Text + "的资产借还申请通知!"; ammodel.消息事项 = "资产借还"; AM_待办业务 dbmodel = new AM_待办业务(); dbmodel.处理方式 = "个人"; dbmodel.处理人 = model.借出人; dbmodel.Sort = 1; dbmodel.发起人 = 借用人.Text; dbmodel.流程状态 = 流程状态.Text; dbmodel.事项名称 = "资产借还"; dbmodel.通知内容 = "您来自" + 借用人.Text + "的资产借还申请,请及时处理!"; dbmodel.FlowName = "资产借还"; dbmodel.发起时间 = DateTime.Now.ToLongDateString(); if (bll.创建资产借还(model, ammodel, dbmodel) > 0) { Window1.Hidden = true; Alert.ShowInTop("创建成功!"); BindGrid(); } }
public int 报修结算(int id, SchoolX_资产报修流程表 model, AM_提醒通知 ammodel, AM_待办业务 dbmodel) { return(sql.报修结算(id, model, ammodel, dbmodel)); }
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; } }
public int 操作资产交接流程(AM_资产交接流程表 model, AM_提醒通知 ammodel, AM_待办业务 dbmodel) { return(sql.操作资产交接流程(model, ammodel, dbmodel)); }
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(); }