public int 新增原值变动(SchoolX_原值变动流程表 model, List <School办公设备信息表> workmodel, AM_提醒通知 ammodel, AM_待办业务 dbmodel) { return(sql.新增原值变动(model, workmodel, ammodel, dbmodel)); }
protected void Button1_Click(object sender, EventArgs e) { if (Grid2.GetMergedData().Count == 0) { Alert.ShowInTop("请选择!", "提示信息", MessageBoxIcon.Warning); return; } SchoolX_原值变动流程表 model = new SchoolX_原值变动流程表(); model.流程状态 = 流程状态.Text; model.单据编号 = 单据编号.Text; model.事项名称 = 事项名称.Text; model.申请人 = 申请人.Text; model.申请日期 = 申请日期.Text; model.记账人 = 记账人.Text; model.变动方式 = 变动方式.SelectedText; model.变动原因 = 变动原因.Text; model.记账人意见 = 记账人意见.Text; model.备注 = 备注.Text; double dj = 0; List <School办公设备信息表> listbg = new List <School办公设备信息表>(); string sbid = ""; string bdje = ""; JArray mergedData = Grid2.GetMergedData(); foreach (JObject mergedRow in mergedData) { JObject values = mergedRow.Value <JObject>("values"); School办公设备信息表 bgmo = new School办公设备信息表(); bgmo.ID = (Convert.ToInt32(values.Value <string>("ID"))); sbid += values.Value <string>("ID").ToString() + ","; try { dj += Convert.ToDouble(values.Value <string>("价格")); bgmo.变动金额 = (Convert.ToDouble(values.Value <string>("变动金额"))); if (bgmo.变动金额 < 1) { Alert.ShowInTop("请输入变动金额!", "提示信息", MessageBoxIcon.Warning); return; } bdje += values.Value <string>("变动金额").ToString() + ","; } catch (Exception) { //没填写 Alert.ShowInTop("请填写变动金额!", "提示信息", MessageBoxIcon.Warning); return; } listbg.Add(bgmo); } model.str变动金额 = bdje; model.资产ID = sbid; model.总价 = dj; model.总数 = Grid2.GetMergedData().Count; this.Label4.Text = "数量合计:" + Grid2.GetMergedData().Count + "---金额合计:" + dj + "元"; AM_提醒通知 ammodel = new AM_提醒通知(); ammodel.发起人 = 申请人.Text; ammodel.发起时间 = DateTime.Now; ammodel.是否已读 = "否"; ammodel.通知类型 = "待办事项通知"; ammodel.通知职务 = "财务人员"; ammodel.消息内容 = "您来自" + 申请人.Text + "的原值变动申请通知!"; ammodel.消息事项 = "购置验收"; AM_待办业务 dbmodel = new AM_待办业务(); dbmodel.处理职务 = "财务人员"; dbmodel.发起人 = 申请人.Text; dbmodel.流程状态 = 流程状态.Text; dbmodel.事项名称 = "购置验收"; dbmodel.通知内容 = "您来自" + 申请人.Text + "的原值变动申请,请及时处理!"; dbmodel.发起时间 = DateTime.Now.ToLongDateString(); //插入数据库 if (bll.新增原值变动(model, listbg, ammodel, dbmodel) > 0) { Window1.Hidden = true; Alert.ShowInTop("创建成功!"); //return; BindGrid(); } }