コード例 #1
0
        public object Delete(string id)
        {
            var _ids = new List <string>();

            using (var db = new Jiajusale9Context())
            {
                foreach (string _id in id.Split(','))
                {
                    var did = _id;
                    db.Cg_cgddm.Remove(r => r.Dh == did);
                }
                db.SaveChanges();
            }
            return(true);
        }
コード例 #2
0
        public object Get()
        {
            var sbCondition = new System.Text.StringBuilder();

            if (sbCondition.Length > 4)
            {
                sbCondition.Length -= 4;
            }
            var pageReq = new PageRequest();

            using (var db = new Jiajusale9Context())
            {
                return(pageReq.ToPageList <Cg_cgddmListModel>(db.Database, "a.Dh ,a.Zt ,a.Practice ,a.Ydh ,a.Ck ,a.Gys ,a.Cgy ,a.Lxr ,a.Lxdh ,a.Hb ,a.Ccrq ,a.Dhrq ,a.Jsfs ,a.Fktj ,a.Hl ,a.Taxrate ,a.Dhdz ,a.Cgje ,a.Jjje ,a.Sjje ,a.Yunfei ,a.Yufuje ,a.Yfkye ,a.Yifuje ,a.Bz ,a.Zdrq ,a.Zd ,a.Shrq ,a.Sh ,a.Finishrq ,a.Ifjz ,a.workFlowId ,a.workFlowInsId ,a.WorktaskId ,a.WorktaskInsId ,a.IfSubmit ,a.Ystk ,a.Gbbz ,a.GbDate ,a.Account ,a.Cjfh ,a.Ml ,a.CurrentSPList ,a.NodeID ", "Cg_cgddm a ", sbCondition.ToString(), "Dh", "desc"));
            }
        }
コード例 #3
0
        public ActionResult Edit(string id)
        {
            Cg_cgddm form = null;

            using (var db = new Jiajusale9Context())
            {
                form = db.Cg_cgddm.Find(id);
            }
            ViewBag.RowState = 2;
            if (form == null)
            {
                ViewBag.RowState = 1;
                form             = new Cg_cgddm
                {
                    Dh = id
                };
            }
            return(View(new { form = form, dataSource = new {  } }));
        }
コード例 #4
0
        public object Post(JObject post)
        {
            var form = post["form"].ToObject <Cg_cgddm>();

            using (var db = new Jiajusale9Context())
            {
                var dbForm = db.Cg_cgddm.Find(form.Dh);
                if (dbForm == null)
                {
                    db.Cg_cgddm.Add(form);
                }
                else
                {
                    dbForm.Zt            = form.Zt;
                    dbForm.Practice      = form.Practice;
                    dbForm.Ydh           = form.Ydh;
                    dbForm.Ck            = form.Ck;
                    dbForm.Gys           = form.Gys;
                    dbForm.Cgy           = form.Cgy;
                    dbForm.Lxr           = form.Lxr;
                    dbForm.Lxdh          = form.Lxdh;
                    dbForm.Hb            = form.Hb;
                    dbForm.Ccrq          = form.Ccrq;
                    dbForm.Dhrq          = form.Dhrq;
                    dbForm.Jsfs          = form.Jsfs;
                    dbForm.Fktj          = form.Fktj;
                    dbForm.Hl            = form.Hl;
                    dbForm.Taxrate       = form.Taxrate;
                    dbForm.Dhdz          = form.Dhdz;
                    dbForm.Cgje          = form.Cgje;
                    dbForm.Jjje          = form.Jjje;
                    dbForm.Sjje          = form.Sjje;
                    dbForm.Yunfei        = form.Yunfei;
                    dbForm.Yufuje        = form.Yufuje;
                    dbForm.Yfkye         = form.Yfkye;
                    dbForm.Yifuje        = form.Yifuje;
                    dbForm.Bz            = form.Bz;
                    dbForm.Zdrq          = form.Zdrq;
                    dbForm.Zd            = form.Zd;
                    dbForm.Shrq          = form.Shrq;
                    dbForm.Sh            = form.Sh;
                    dbForm.Finishrq      = form.Finishrq;
                    dbForm.Ifjz          = form.Ifjz;
                    dbForm.workFlowId    = form.workFlowId;
                    dbForm.workFlowInsId = form.workFlowInsId;
                    dbForm.WorktaskId    = form.WorktaskId;
                    dbForm.WorktaskInsId = form.WorktaskInsId;
                    dbForm.IfSubmit      = form.IfSubmit;
                    dbForm.Ystk          = form.Ystk;
                    dbForm.Gbbz          = form.Gbbz;
                    dbForm.GbDate        = form.GbDate;
                    dbForm.Account       = form.Account;
                    dbForm.Cjfh          = form.Cjfh;
                    dbForm.Ml            = form.Ml;
                    dbForm.CurrentSPList = form.CurrentSPList;
                    dbForm.NodeID        = form.NodeID;
                }
                db.SaveChanges();
            }
            return(new { success = true, form = form });
        }