Example #1
0
        public List <salary_standardModel> fenye(int dqy)
        {
            int rows = 0;
            List <salary_standard>      list  = FenYe <int>(e => e.Id, e => e.Id > 0 && e.change_status <= 0, ref rows, dqy, 2);
            List <salary_standardModel> list2 = new List <salary_standardModel>();

            foreach (salary_standard s in list)
            {
                salary_standardModel s1 = new salary_standardModel()
                {
                    Id            = s.Id,
                    standard_id   = s.standard_id,
                    standard_name = s.standard_name,
                    designer      = s.designer,
                    register      = s.register,
                    regist_time   = Convert.ToDateTime(s.regist_time),
                    salary_sum    = Convert.ToDecimal(s.salary_sum),
                    remark        = s.remark,
                    check_comment = s.check_comment,
                    change_status = s.change_status,
                    check_status  = s.check_status,
                    change_time   = Convert.ToDateTime(s.change_time),
                    check_time    = Convert.ToDateTime(s.check_time),
                    changer       = s.changer,
                    checker       = s.checker
                };
                list2.Add(s1);
            }
            return(list2);
        }
Example #2
0
        public List <salary_standardModel> Fenyecx(int dqy, string bh, string gjz, DateTime sjq, DateTime sjh)
        {
            int rows = 0;
            List <salary_standard>      list  = FenYe <int>(e => e.Id, e => e.Id > 0 && e.standard_id.Contains(bh) && e.designer.Contains(gjz) && e.regist_time >= sjq && e.regist_time <= sjh && e.change_status > 0, ref rows, dqy, 2).ToList();
            List <salary_standardModel> list2 = new List <salary_standardModel>();

            foreach (salary_standard s in list)
            {
                salary_standardModel s1 = new salary_standardModel()
                {
                    Id            = s.Id,
                    standard_id   = s.standard_id,
                    standard_name = s.standard_name,
                    designer      = s.designer,
                    register      = s.register,
                    regist_time   = Convert.ToDateTime(s.regist_time),
                    salary_sum    = Convert.ToDecimal(s.salary_sum),
                    remark        = s.remark,
                    check_comment = s.check_comment,
                    change_status = s.change_status,
                    check_status  = s.check_status,
                    change_time   = Convert.ToDateTime(s.change_time),
                    check_time    = Convert.ToDateTime(s.check_time),
                    changer       = s.changer,
                    checker       = s.checker
                };
                list2.Add(s1);
            }
            return(list2);
        }
Example #3
0
        public ArrayList Listsalary_standard(LikeFenYe l)
        {
            int row = 0;
            List <salary_standardModel> list1 = new List <salary_standardModel>();
            List <salary_standard>      list  = new List <salary_standard>();

            list = FenYe <int>(e => e.ssd_id, e => e.check_status == 2, ref row, l.Dq, l.PageSize);
            foreach (var item in list)
            {
                salary_standardModel e1 = new salary_standardModel()
                {
                    standard_id   = item.standard_id,
                    standard_name = item.standard_name,
                    designer      = item.designer,
                    register      = item.register,
                    regist_time   = item.regist_time,
                    check_time    = item.check_time,
                    change_time   = item.change_time,
                    salary_sum    = item.salary_sum,
                    remark        = item.remark,
                    check_status  = item.check_status,
                };
                list1.Add(e1);
            }
            ArrayList A = new ArrayList();

            A.Add(list1);
            A.Add(row);
            A.Add(l.Dq);
            A.Add(l.PageSize);
            A.Add((row - 1) / l.PageSize + 1);
            return(A);
        }
Example #4
0
        public List <salary_standardModel> Select()
        {
            List <salary_standard>      list  = hr.ss.ToList();
            List <salary_standardModel> list2 = new List <salary_standardModel>();

            //需要把ED->DTO
            foreach (salary_standard item in list)
            {
                salary_standardModel bjm = new salary_standardModel()
                {
                    ssd_id        = item.ssd_id,
                    standard_id   = item.standard_id,
                    standard_name = item.standard_name,
                    designer      = item.designer,
                    register      = item.register,
                    checker       = item.checker,
                    changer       = item.changer,
                    regist_time   = item.regist_time,
                    check_time    = item.check_time,
                    change_time   = item.change_time,
                    check_status  = item.check_status,
                    change_status = item.change_status,
                    check_comment = item.check_comment,
                    salary_sum    = item.salary_sum,
                    remark        = item.remark
                };
                list2.Add(bjm);
            }
            return(list2);
        }
Example #5
0
        public salary_standardFenYe fenye(int dqy, int rl)
        {
            salary_standardFenYe        cs = new salary_standardFenYe();
            List <salary_standardModel> li = new List <salary_standardModel>();
            int rows = 0;
            var data = db.Set <salary_standard>().OrderBy(e => e.Id).Where(e => e.check_status == 0).AsNoTracking();

            rows = data.Count();//获取总行数
            List <salary_standard> list = FenYe <int>(e => e.Id, e => e.check_status == 0, ref rows, dqy, rl);

            foreach (salary_standard item in list)
            {
                salary_standardModel ko = new salary_standardModel();
                ko.id            = item.Id;
                ko.standard_id   = item.standard_id;
                ko.standard_name = item.standard_name;
                ko.designer      = item.designer;
                ko.register      = item.register;
                ko.checker       = item.checker;
                ko.changer       = item.changer;
                ko.regist_time   = item.regist_time;
                ko.check_time    = item.check_time;
                ko.change_time   = item.change_time;
                ko.salary_sum    = item.salary_sum;
                ko.check_status  = item.check_status;
                ko.change_status = item.change_status;
                ko.check_comment = item.check_comment;
                ko.remark        = item.remark;
                li.Add(ko);
            }
            cs.li         = li;
            cs.MyProperty = rows;
            cs.zys        = (rows % rl == 0 ? rows / rl : rows % rl + 1);
            return(cs);
        }
Example #6
0
        public salary_standardModel BJSelectBy2(int id)
        {
            salary_standard bj = SelectBy2(id);
            //把EO->DTO
            salary_standardModel bjm = new salary_standardModel()
            {
                ssd_id        = bj.ssd_id,
                standard_id   = bj.standard_id,
                standard_name = bj.standard_name,
                designer      = bj.designer,
                register      = bj.register,
                checker       = bj.checker,
                changer       = bj.changer,
                regist_time   = bj.regist_time,
                check_time    = bj.check_time,
                change_time   = bj.change_time,
                check_status  = bj.check_status,
                change_status = bj.change_status,
                check_comment = bj.check_comment,
                salary_sum    = bj.salary_sum,
                remark        = bj.remark
            };

            return(bjm);
        }
Example #7
0
        public ArrayList LikeSelect0(LikeFenYe l)
        {
            ArrayList list2 = new ArrayList();
            int       rows  = 0;
            List <salary_standard>      list  = null;
            List <salary_standardModel> list1 = new List <salary_standardModel>();

            list = FenYe <int>(e => e.ssd_id, e => (e.standard_id.Contains(l.major_kind_id) && (e.register.Contains(l.primarKey) || e.designer.Contains(l.primarKey) || e.checker.Contains(l.primarKey)) && e.regist_time > l.startDate && e.regist_time < l.endDate && e.check_status == 1 && e.change_status == 0), ref rows, l.Dq, l.PageSize);
            foreach (var s in list)
            {
                salary_standardModel ss = new salary_standardModel()
                {
                    ssd_id        = s.ssd_id,
                    standard_id   = s.standard_id,
                    standard_name = s.standard_name,
                    designer      = s.designer,
                    register      = s.register,
                    regist_time   = s.regist_time,
                    check_time    = s.check_time,
                    change_time   = s.change_time,
                    salary_sum    = s.salary_sum,
                    remark        = s.remark,
                    check_status  = s.check_status,
                };
                list1.Add(ss);
            }
            list2.Add(list1);
            list2.Add(rows);
            list2.Add(l.Dq);
            list2.Add(l.PageSize);
            list2.Add((rows - 1) / l.PageSize + 1);
            return(list2);
        }
        //查询一个数据
        public ActionResult salarystandard_query(int id)
        {
            List <salary_standardModel> fa = sa.selectupdate(id);
            // List<salary_standard_detailsModel>  li=de.selectupdate(fa[0].standard_id);
            salary_standardModel ko = new salary_standardModel();

            ko.id          = fa[0].id;
            ko.standard_id = fa[0].standard_id;
            //Session["id"] = fa[0].id;
            Session["mid"]   = fa[0].standard_id;
            ko.standard_name = fa[0].standard_name;
            ko.designer      = fa[0].designer;
            ko.register      = fa[0].register;
            ko.checker       = fa[0].checker;
            ko.changer       = fa[0].changer;
            ko.regist_time   = fa[0].regist_time;
            ko.check_time    = fa[0].check_time;
            ko.change_time   = fa[0].change_time;
            ko.salary_sum    = fa[0].salary_sum;
            ko.check_status  = fa[0].check_status;
            ko.change_status = fa[0].change_status;
            ko.check_comment = fa[0].check_comment;
            ko.remark        = fa[0].remark;

            return(View(ko));
        }
Example #9
0
        public ActionResult tjSelect(salary_standardModel s)
        {
            //DateTime.Now.Date.ToString("yyyy/MM/dd");
            //ViewData["rows"] = sa.rows(s.standard_id, s.designer,Convert.ToDateTime(s.regist_time),s.check_time);
            //ViewData["Pagescx"] = sa.Pagescx();
            //return View();
            string salaId     = Request["id"];
            string salaGJZ    = Request["gjz"];
            string endDate    = Request["endDate"];
            string date_start = Request["date_start"];

            ListFenYeModel l = new ListFenYeModel()
            {
                Dq            = int.Parse(Request["rl"]), //当前页
                PageSize      = 2,                        //每页要显示多少条数据
                standard_id   = salaId,                   //根据id模糊查询
                standard_name = salaGJZ,                  //根据关键字来模糊查询,用了concat函数,不管输入的是什么,它都能根据多个字段查
                startDate     = Convert.ToDateTime(date_start),
                endDate       = Convert.ToDateTime(endDate)
            };
            ArrayList list = sa.Salarystandard_query_locateLikeFenYe(l);

            ViewBag.ls = list;
            return(View());
        }
Example #10
0
        public List <salary_standardModel> select()
        {
            List <salary_standard>      list = SelectAll();
            List <salary_standardModel> li   = new List <salary_standardModel>();

            foreach (salary_standard item in list)
            {
                salary_standardModel ko = new salary_standardModel();
                ko.id            = item.Id;
                ko.standard_id   = item.standard_id;
                ko.standard_name = item.standard_name;
                ko.designer      = item.designer;
                ko.register      = item.register;
                ko.checker       = item.checker;
                ko.changer       = item.changer;
                ko.regist_time   = item.regist_time;
                ko.check_time    = item.check_time;
                ko.change_time   = item.change_time;
                ko.salary_sum    = item.salary_sum;
                ko.check_status  = item.check_status;
                ko.change_status = item.change_status;
                ko.check_comment = item.check_comment;
                ko.remark        = item.remark;  li.Add(ko);
            }
            return(li);
        }
Example #11
0
        public ActionResult UPTJ(int id)
        {
            salary_standardModel s3 = sa.SelectBYID(id);

            ViewData.Model = s3;
            return(View());
        }
Example #12
0
        public ActionResult Upd(int id)
        {
            salary_standardModel sa = MyProperty.BJSelectBy2(id);

            salary_standard_detailsModel        da = new salary_standard_detailsModel();
            List <salary_standard_detailsModel> li = MyProperty2.BJSelectBy2(sa.standard_id);

            foreach (salary_standard_detailsModel item in li)
            {
                if (item.item_name == "基本工资")
                {
                    sa.money1 = item.salary;
                }
                if (item.item_name == "岗位工资")
                {
                    sa.money2 = item.salary;
                }
                if (item.item_name == "交通补助")
                {
                    sa.money3 = item.salary;
                }
                if (item.item_name == "午餐补助")
                {
                    sa.money4 = item.salary;
                }
                if (item.item_name == "五险一金")
                {
                    sa.money5 = item.salary;
                }
            }
            ViewData.Model = sa;

            return(View());
        }
        public ActionResult Add(FormCollection f)
        {
            string itemId         = Request["itemId"];
            string attribute_name = Request["attribute_name"];
            string mon            = Request["mon"];

            string[] itemId1         = itemId.Split(',');
            string[] attribute_name1 = attribute_name.Split(',');
            string[] mon1            = mon.Split(',');
            string   standard_id     = Request["standardId"];
            string   standardName    = Request["standardName"];
            double   salarySum       = double.Parse(Request["salarySum"]);
            string   designer        = Request["designer"];
            string   register        = Request["register"];
            DateTime registTime      = DateTime.Parse(Request["registTime"]);
            string   remark          = Request["remark"];

            for (int i = 0; i < mon1.Length; i++)
            {
                double je = double.Parse(mon1[i]);
                if (je != 0.00)
                {
                    salary_standard_detailsModel ssd1 = new salary_standard_detailsModel()
                    {
                        standard_id   = standard_id,
                        standard_name = standardName,
                        item_id       = int.Parse(itemId1[i]),
                        item_name     = attribute_name1[i],
                        salary        = double.Parse(mon1[i]),
                    };
                    if (ssd.Addsalary_standard_details(ssd1) < 0)
                    {
                        return(Content("<script>alert('报错')</script>"));
                    }
                }
            }
            salary_standardModel ssm = new salary_standardModel()
            {
                standard_id   = standard_id,
                standard_name = standardName,
                designer      = designer,
                register      = register,
                regist_time   = registTime,
                check_time    = DateTime.Parse("2000-01-01"),
                change_time   = DateTime.Parse("2000-01-01"),
                salary_sum    = salarySum,
                remark        = remark,
                check_status  = 2,
            };

            if (ss.AddLsalary_standard(ssm) > 0)
            {
                return(Content("<script>alert('新增成功');window.location.href='/salarystandard_register/Index'</script>"));
            }
            else
            {
                return(Content("<script>alert('新增失败');window.location.href='/salarystandard_register/Index'</script>"));
            }
        }
        public ActionResult salarystandard_register()
        {
            salary_standardModel ko = new salary_standardModel();

            ko.standard_id = sa.BianHao();
            ViewData.Model = ko;
            return(View());
        }
Example #15
0
        public int Update(salary_standardModel st)
        {
            salary_standard est = new salary_standard()
            {
                Id = st.Id
            };

            return(Update(est));
        }
Example #16
0
        public ActionResult Upd2(salary_standardModel sa)
        {
            var errors = ModelState.Values.SelectMany(v => v.Errors).ToList();

            if (ModelState.IsValid)
            {
                if (MyProperty.BJEdit(sa) > 0)
                {
                    salary_standard_detailsModel sks = new salary_standard_detailsModel();
                    string id = sa.standard_id;
                    List <salary_standard_detailsModel> list = MyProperty2.BJSelectBy3(id);
                    for (int i = 0; i < list.Count; i++)
                    {
                        sks.sdt_id        = list[i].sdt_id;
                        sks.standard_id   = sa.standard_id;
                        sks.standard_name = sa.standard_name;
                        if (list[i].item_name == "基本工资")
                        {
                            sks.item_id = 1;
                            sks.salary  = sa.money1;
                        }
                        if (list[i].item_name == "岗位工资")
                        {
                            sks.item_id = 2;
                            sks.salary  = sa.money2;
                        }
                        if (list[i].item_name == "交通补助")
                        {
                            sks.item_id = 3;
                            sks.salary  = sa.money3;
                        }
                        if (list[i].item_name == "午餐补助")
                        {
                            sks.item_id = 4;
                            sks.salary  = sa.money4;
                        }
                        if (list[i].item_name == "五险一金")
                        {
                            sks.item_id = 5;
                            sks.salary  = sa.money5;
                        }
                        sks.item_name = list[i].item_name;
                        MyProperty2.BJEdit(sks);
                    }
                    return(Content("<script>alert('修改成功');window.location.href='/Update/Index'</script>"));
                }
                else
                {
                    return(Content("<script>alert('修改失败');window.location.href='/Update/Index'</script>"));
                }
            }

            else
            {
                return(Content("<script>alert('请输入完整再提交');window.location.href='/Update/Upd/" + sa.ssd_id + "'</script>"));
            }
        }
Example #17
0
        public int Add(salary_standardModel st)
        {
            //把DTO转为EO
            salary_standard est = new salary_standard()
            {
                Id = st.Id
            };

            return(Add(est));
        }
Example #18
0
        public ActionResult UPBG()
        {
            string salary_standard         = Request["salary_standard"];
            string salary_standard_details = Request["salary_standard_details"];
            string id = Request["said"];
            Dictionary <string, object> di  = JsonConvert.DeserializeObject <Dictionary <string, object> >(salary_standard);
            salary_standardModel        ssm = new salary_standardModel();
            string sj   = di["drsj"].ToString();
            string fhsj = di["fhsj"].ToString().Substring(0, 10);
            string qg   = sj.Substring(0, 10);

            ssm.Id            = int.Parse(id);
            ssm.standard_id   = di["bh"].ToString();
            ssm.standard_name = di["mc"].ToString();
            ssm.designer      = di["zdr"].ToString();
            ssm.register      = di["djr"].ToString();
            ssm.checker       = di["fhr"].ToString();
            ssm.regist_time   = DateTime.Parse(qg);
            ssm.salary_sum    = decimal.Parse(di["ze"].ToString());
            ssm.check_comment = di["fhyj"].ToString();
            ssm.check_time    = Convert.ToDateTime(fhsj);
            ssm.change_status = 0;
            ssm.remark        = di["bz"].ToString();
            ssm.change_time   = DateTime.Parse(di["bgsj"].ToString());


            int res  = sa.UP(ssm);
            int ress = 0;
            List <Dictionary <string, object> > list = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(salary_standard_details);

            foreach (Dictionary <string, object> item in list)
            {
                salary_standard_detailsModel sala = new salary_standard_detailsModel();

                sala.Id            = int.Parse(item["id"].ToString());
                sala.salary        = Convert.ToDecimal(item["je"].ToString());
                sala.standard_name = item["mc"].ToString();
                sala.item_id       = int.Parse(item["xh"].ToString());
                sala.item_name     = item["xcmc"].ToString();
                sala.standard_id   = item["bh"].ToString();
                ress = sd.salaUP(sala);
            }



            if (res > 0 && ress > 0)
            {
                return(Content("OK"));
            }
            else
            {
                return(Content("ON"));
            }
        }
Example #19
0
        public int BianGenupdate(salary_standardModel item)
        {
            salary_standard ko = db.salary_standard.Where(e => e.Id.Equals(item.id)).FirstOrDefault();

            ko.Id            = item.id;
            ko.standard_name = item.standard_name;
            ko.designer      = item.designer;
            ko.changer       = item.changer;
            ko.change_time   = item.change_time;
            ko.salary_sum    = item.salary_sum;
            ko.change_status = item.change_status;
            ko.remark        = item.remark;
            return(db.SaveChanges());
        }
Example #20
0
        public List <Model.salary_standardModel> Select()
        {
            List <salary_standard>      list  = SelectAll();
            List <salary_standardModel> list2 = new List <salary_standardModel>();

            foreach (salary_standard item in list)
            {
                salary_standardModel sm = new salary_standardModel()
                {
                    Id = item.Id,
                };
                list2.Add(sm);
            }
            return(list2);
        }
Example #21
0
        public List <salary_standardModel> SelectBy(salary_standardModel st)
        {
            List <salary_standard>      list  = SelectBy(e => e.Id.Equals(st.Id));
            List <salary_standardModel> list2 = new List <salary_standardModel>();

            foreach (var item in list)
            {
                salary_standardModel sd = new salary_standardModel()
                {
                    Id = item.Id
                };
                list2.Add(sd);
            }
            return(list2);
        }
        public ActionResult Update1()
        {
            string   standardId     = Request["standardId"];
            string   attribute_name = Request["attribute_name"];
            double   salarySum      = double.Parse(Request["salarySum"]);
            string   changer        = Request["changer"];
            DateTime change_time    = DateTime.Parse(Request["change_time"]);

            string [] sdt_id          = Request["sdt_id"].ToString().Split(',');
            string[]  itemId1         = Request["itemId1"].ToString().Split(',');
            string[]  attribute_name1 = Request["attribute_name1"].ToString().Split(',');
            string[]  mon1            = Request["mon"].ToString().Split(',');
            for (int i = 0; i < mon1.Length; i++)
            {
                double je = double.Parse(mon1[i]);
                if (je != 0.00)
                {
                    salary_standard_detailsModel ss = new salary_standard_detailsModel()
                    {
                        standard_id   = standardId,
                        standard_name = attribute_name,
                        item_id       = int.Parse(itemId1[i]),
                        item_name     = attribute_name1[i],
                        salary        = double.Parse(mon1[i]),
                        sdt_id        = int.Parse(sdt_id[i])
                    };
                    if (ssd.Updatesalary_standard_details(ss) < 0)
                    {
                        return(Content("<script>alert('报错')</script>"));
                    }
                }
            }
            salary_standardModel sm = il.SelectID(standardId);

            sm.salary_sum    = salarySum;
            sm.changer       = changer;
            sm.change_time   = change_time;
            sm.change_status = 1;
            if (il.Update(sm) > 0)
            {
                return(Content("<script>alert('更改成功');window.location.href='/salarystandardchangelocate/Index'</script>"));
            }
            else
            {
                return(Content("<script>alert('更改失败');window.location.href='/salarystandardchangelocate/Index'</script>"));
            }
            return(View());
        }
Example #23
0
        public ActionResult Update1()
        {
            salary_standardModel ssm = fb.SelectID(Request["standardId"]);

            ssm.check_status  = 1;
            ssm.check_comment = Request["check_comment"];
            ssm.check_time    = DateTime.Parse(Request["check_time"]);
            ssm.checker       = Request["checker"];
            if (fb.Update(ssm) > 0)
            {
                return(Content("<script>alert('复核成功');window.location.href='/salarystandard_check_list/index'</script>"));
            }
            else
            {
                return(Content("<script>alert('复核失败');window.location.href='/salarystandard_check_list/index?id=" + Request["id"] + "'</script>"));
            }
        }
        public ActionResult fhqr()
        {
            Cache cahe = this.HttpContext.Cache;
            List <salary_standard_detailsModel> hu = cahe["xq"] as List <salary_standard_detailsModel>;
            salary_standardModel sata = new salary_standardModel();
            string bh   = Request["standard_id"];
            string mc   = Request["standard_name"];
            string ze   = Request["salary_sum"];
            string zdr  = Request["designer"];
            string djr  = Request["register"];
            string djsj = Request["regist_time"];
            string bz   = Request["remark"];
            string fhr  = Request["checker"];

            sata.standard_name = mc;
            sata.designer      = zdr;
            sata.register      = djr;
            sata.remark        = bz;
            sata.check_status  = 1;
            sata.salary_sum    = decimal.Parse(ze);
            sata.check_time    = DateTime.Now;
            sata.id            = int.Parse(Session["id"].ToString());
            sata.checker       = fhr;
            int pd = sa.update1(sata);
            int ji = 0;

            if (pd > 0)
            {
                for (int i = 0; i < hu.Count; i++)
                {
                    salary_standard_detailsModel details = new salary_standard_detailsModel();
                    details.id = hu[i].id;
                    string h = Request["details[" + i + "].salary"];
                    details.salary = decimal.Parse(h);
                    int pdeq = de.update1(details);
                    if (pdeq > 0)
                    {
                        ji++;
                    }
                }
                cahe.Remove("xq");
                return(Content("<script>window.location.href='/salary_standard/salarystandard_check_success';</script>"));
            }
            return(Content("<script>alert('修改失败');</script>"));
        }
Example #25
0
        public int AddLsalary_standard(salary_standardModel s)
        {
            salary_standard ss = new salary_standard()
            {
                standard_id   = s.standard_id,
                standard_name = s.standard_name,
                designer      = s.designer,
                register      = s.register,
                regist_time   = s.regist_time,
                check_time    = s.check_time,
                change_time   = s.change_time,
                salary_sum    = s.salary_sum,
                remark        = s.remark,
                check_status  = s.check_status,
            };

            return(Add(ss));
        }
Example #26
0
        public int Add(salary_standardModel item)
        {
            salary_standard ko = new salary_standard();

            ko.Id            = item.id;
            ko.standard_id   = item.standard_id;
            ko.standard_name = item.standard_name;
            ko.designer      = item.designer;
            ko.register      = item.register;
            ko.checker       = item.checker;
            ko.changer       = item.changer;
            ko.regist_time   = item.regist_time;
            ko.check_time    = item.check_time;
            ko.change_time   = item.change_time;
            ko.salary_sum    = item.salary_sum;
            ko.check_status  = item.check_status;
            ko.change_status = item.change_status;
            ko.check_comment = item.check_comment;
            ko.remark        = item.remark; return(Add(ko));
        }
Example #27
0
        public ActionResult Add( )
        {
            string salary_standard         = Request["salary_standard"];
            string salary_standard_details = Request["salary_standard_details"];

            int ress = 0;
            List <Dictionary <string, object> > list = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(salary_standard_details);

            foreach (Dictionary <string, object> item in list)
            {
                salary_standard_detailsModel sala = new salary_standard_detailsModel();
                sala.standard_name = item["mc"].ToString();
                sala.item_id       = int.Parse(item["xh"].ToString());
                sala.item_name     = item["xcmc"].ToString();
                sala.salary        = Convert.ToDecimal(item["je"].ToString());
                sala.standard_id   = item["bh"].ToString();
                ress = sd.salary_standard_detailsAdd(sala);
            }

            Dictionary <string, object> di  = JsonConvert.DeserializeObject <Dictionary <string, object> >(salary_standard);
            salary_standardModel        ssm = new salary_standardModel()
            {
                standard_id   = di["bh"].ToString(),
                standard_name = di["mc"].ToString(),
                designer      = di["zdr"].ToString(),
                register      = di["djr"].ToString(),
                regist_time   = Convert.ToDateTime(di["djsj"].ToString()),
                salary_sum    = decimal.Parse(di["ze"].ToString()),
                remark        = di["bz"].ToString()
            };
            int res = sa.salary_standardAdd(ssm);

            if (res > 0 && ress > 0)
            {
                return(Content("OK"));
            }
            else
            {
                return(Content("ON"));
            }
        }
Example #28
0
        public ActionResult Fh(salary_standardModel sa)
        {
            var errors = ModelState.Values.SelectMany(v => v.Errors).ToList();

            if (ModelState.IsValid)
            {
                if (MyProperty.BJEdit(sa) > 0)
                {
                    return(Content("<script>alert('修改成功');window.location.href='/CheckList/Index'</script>"));
                }
                else
                {
                    return(Content("<script>alert('修改失败');window.location.href='/CheckList/Index'</script>"));
                }
            }

            else
            {
                return(Content("<script>alert('请输入完整再提交');window.location.href='/CheckList/Fh/" + sa.ssd_id + "'</script>"));
            }
        }
Example #29
0
        public ArrayList Salarystandard_query_locateLikeFenYe(ListFenYeModel l)
        {
            ArrayList list2 = new ArrayList();
            int       rows  = 0;
            List <salary_standard>      list  = null;
            List <salary_standardModel> list1 = new List <salary_standardModel>();

            //string.Concat函数是根据提供的字段进行模糊查询,可以多个字段
            //|| string.Concat(e.designer, e.changer, e.standard_name,e.checker).Contains(l.standard_name) || e.regist_time >l.startDate && e.regist_time<= l.endDate,
            list = FenYe <int>(e => e.Id, e => e.standard_id.Contains(l.standard_id) && string.Concat(e.designer, e.changer, e.standard_name, e.checker).Contains(l.standard_name) && e.regist_time <= l.startDate && e.regist_time >= l.endDate && e.change_status > 0, ref rows, l.Dq, l.PageSize);
            foreach (var item in list)
            {
                salary_standardModel s = new salary_standardModel()
                {
                    Id            = item.Id,
                    standard_id   = item.standard_id,
                    standard_name = item.standard_name,
                    designer      = item.designer,
                    register      = item.register,
                    checker       = item.checker,
                    changer       = item.changer,
                    regist_time   = item.regist_time,
                    //check_time = item.check_time,
                    change_time   = item.change_time,
                    salary_sum    = item.salary_sum,
                    check_status  = item.check_status,
                    change_status = item.change_status,
                    check_comment = item.check_comment,
                    remark        = item.remark
                };
                list1.Add(s);
            }
            list2.Add(list1);
            list2.Add(rows);
            list2.Add(l.Dq);
            list2.Add(l.PageSize);
            list2.Add((rows - 1) / l.PageSize + 1);
            return(list2);
        }
Example #30
0
        public int salary_standardAdd(salary_standardModel s)
        {
            salary_standard ss = new salary_standard()
            {
                standard_id   = s.standard_id,
                standard_name = s.standard_name,
                designer      = s.designer,
                register      = s.register,
                regist_time   = Convert.ToDateTime(s.regist_time),
                salary_sum    = Convert.ToDecimal(s.salary_sum),
                remark        = s.remark,
                check_comment = s.check_comment,
                change_status = s.change_status,
                check_status  = s.check_status,
                change_time   = null,
                check_time    = null,
                changer       = s.changer,
                checker       = s.checker
            };

            return(Add(ss));
        }