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); }
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); }
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); }
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); }
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); }
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); }
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)); }
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()); }
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); }
public ActionResult UPTJ(int id) { salary_standardModel s3 = sa.SelectBYID(id); ViewData.Model = s3; return(View()); }
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()); }
public int Update(salary_standardModel st) { salary_standard est = new salary_standard() { Id = st.Id }; return(Update(est)); }
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>")); } }
public int Add(salary_standardModel st) { //把DTO转为EO salary_standard est = new salary_standard() { Id = st.Id }; return(Add(est)); }
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")); } }
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()); }
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); }
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()); }
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>")); }
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)); }
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)); }
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")); } }
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>")); } }
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); }
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)); }