Esempio n. 1
0
 public int 新增原值变动(SchoolX_原值变动流程表 model, List <School办公设备信息表> workmodel, AM_提醒通知 ammodel, AM_待办业务 dbmodel)
 {
     return(sql.新增原值变动(model, workmodel, ammodel, dbmodel));
 }
Esempio n. 2
0
        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();
            }
        }