public ActionResult register_locate() { major_changeModel m = new major_changeModel(); ViewData.Model = m; FillDrop1(); return(View()); }
public IActionResult check(int id) { major_changeModel hfm = mc.SelById(id); ViewBag.User_name = HttpContext.Session.GetString("User_name"); ViewData.Model = hfm; return(View()); }
public ActionResult check(int id) { // FillDrop4(); //FillDrop5(); //FillDrop6(); // FillDrop7(); // FillDrop8(); // FillDrop9(); major_changeModel major = new major_changeModel { Id = id }; List <major_changeModel> list = imb.SelectBy(major); major_changeModel mc = new major_changeModel { Id = list[0].Id, first_kind_id = list[0].first_kind_id, first_kind_name = list[0].first_kind_name, second_kind_id = list[0].second_kind_id, second_kind_name = list[0].second_kind_name, third_kind_id = list[0].third_kind_id, third_kind_name = list[0].third_kind_name, major_kind_id = list[0].major_kind_id, major_kind_name = list[0].major_kind_name, major_id = list[0].major_id, major_name = list[0].major_name, new_first_kind_id = list[0].new_first_kind_id, new_first_kind_name = list[0].new_first_kind_name, new_second_kind_id = list[0].new_second_kind_id, new_second_kind_name = list[0].new_second_kind_name, new_third_kind_id = list[0].new_third_kind_id, new_third_kind_name = list[0].new_third_kind_name, new_major_kind_id = list[0].new_major_kind_id, new_major_kind_name = list[0].new_major_kind_name, new_major_id = list[0].new_major_id, new_major_name = list[0].new_major_name, human_id = list[0].human_id, human_name = list[0].human_name, salary_standard_id = list[0].salary_standard_id, salary_standard_name = list[0].salary_standard_name, salary_sum = list[0].salary_sum, new_salary_standard_id = list[0].new_salary_standard_id, new_salary_standard_name = list[0].new_salary_standard_name, new_salary_sum = list[0].new_salary_sum, change_reason = list[0].change_reason, check_reason = list[0].check_reason, check_status = list[0].check_status, register = list[0].register, checker = list[0].checker, regist_time = System.DateTime.Now, check_time = list[0].check_time }; ViewData.Model = mc; return(View()); }
public ActionResult xxcbzje(string id) { major_changeModel major = new major_changeModel { new_salary_standard_id = id }; List <major_changeModel> list = imb.SelectBy2(major); decimal money = list[0].new_salary_sum; return(Content(JsonConvert.SerializeObject(money))); }
public async Task <int> Up(int id, major_changeModel m) { major_change mc = hr.Set <major_change>().AsNoTracking().Where(e => e.mch_id == id).FirstOrDefault(); mc.check_status = m.check_status; mc.check_reason = m.check_reason; // mc = new major_change() //{ // mch_id = m.mch_id, // first_kind_id = m.first_kind_id, // first_kind_name = m.first_kind_name, // second_kind_id = m.second_kind_id, // second_kind_name = m.second_kind_name, // third_kind_id = m.third_kind_id, // third_kind_name = m.third_kind_name, // major_id = m.major_id, // major_name = m.major_name, // major_kind_id = m.major_kind_id, // major_kind_name = m.major_kind_name, // new_first_kind_id = m.new_first_kind_id, // new_first_kind_name = m.new_first_kind_name, // new_second_kind_id = m.new_second_kind_id, // new_second_kind_name = m.new_second_kind_name, // new_third_kind_id = m.new_third_kind_id, // new_third_kind_name = m.new_third_kind_name, // new_major_id = m.new_major_id, // new_major_name = m.new_major_name, // new_major_kind_id = m.new_major_kind_id, // new_major_kind_name = m.new_major_kind_name, // human_id = m.human_id, // human_name = m.human_name, // salary_standard_id = m.salary_standard_id, // salary_standard_name = m.salary_standard_name, // salary_sum = m.salary_sum, // new_salary_standard_id = m.new_salary_standard_id, // new_salary_standard_name = m.new_salary_standard_name, // new_salary_sum = m.new_salary_sum, // change_reason = m.change_reason, // check_reason = m.check_reason, // check_status = m.check_status, // register = m.register, // checker = m.checker, // regist_time = m.regist_time, // check_time = m.check_time //}; //hr. // hr.Database.ExecuteSqlCommand(); string sql = $@"update major_change set check_status={m.check_status},check_reason='{m.check_reason}' where mch_id={m.mch_id} "; return(hr.Database.ExecuteSqlCommand(sql)); //hr.Entry(mc).State = EntityState.Unchanged; //hr.Entry(mc).State = EntityState.Modified; //return await hr.SaveChangesAsync(); }
public ActionResult check(major_changeModel mcm) { //修改操作 if (imb.Update(mcm) > 0) { return(Content("<script>alert('修改成功');window.location.href='/check_list/check_list'</script>")); } else { return(Content("<script>alert('修改失败');window.location.href='/check_list/check_list'</script>")); } }
public List <major_changeModel> fenye1(int dqy, major_changeModel mm, DateTime time1, DateTime time2) { int rows = 0; List <major_change> list = FenYe <int>(e => e.Id, e => e.first_kind_id.Equals(mm.first_kind_id) && e.second_kind_id.Equals(mm.second_kind_id) && e.third_kind_id.Equals(mm.third_kind_id) && e.regist_time >= time1 && e.regist_time <= time2, ref rows, dqy, 2); List <major_changeModel> list2 = new List <major_changeModel>(); foreach (major_change item in list) { major_changeModel mcm = new major_changeModel() { Id = item.Id, first_kind_id = item.first_kind_id, first_kind_name = item.first_kind_name, second_kind_id = item.second_kind_id, second_kind_name = item.second_kind_name, third_kind_id = item.third_kind_id, third_kind_name = item.third_kind_name, major_kind_id = item.major_kind_id, major_kind_name = item.major_kind_name, major_id = item.major_id, major_name = item.major_name, new_first_kind_id = item.new_first_kind_id, new_first_kind_name = item.new_first_kind_name, new_second_kind_id = item.new_second_kind_id, new_second_kind_name = item.new_second_kind_name, new_third_kind_id = item.new_third_kind_id, new_third_kind_name = item.new_third_kind_name, new_major_kind_id = item.new_major_kind_id, new_major_kind_name = item.new_major_kind_name, new_major_id = item.new_major_id, new_major_name = item.new_major_name, human_id = item.human_id, human_name = item.human_name, salary_standard_id = item.salary_standard_id, salary_standard_name = item.salary_standard_name, salary_sum = item.salary_sum, new_salary_standard_id = item.new_salary_standard_id, new_salary_standard_name = item.new_salary_standard_name, new_salary_sum = item.new_salary_sum, change_reason = item.change_reason, check_reason = item.check_reason, check_status = item.check_status, register = item.register, checker = item.checker, //regist_time = item.regist_time, //check_time = item.check_time regist_time = DateTime.Now, check_time = DateTime.Now }; list2.Add(mcm); } return(list2); }
public List <major_changeModel> fenye2(int dqy) { int rows = 0; List <major_change> list = FenYe <int>(e => e.Id, e => e.Id > 0, ref rows, dqy, 2); List <major_changeModel> list2 = new List <major_changeModel>(); foreach (major_change item in list) { major_changeModel mm = new major_changeModel() { Id = item.Id, first_kind_id = item.first_kind_id, first_kind_name = item.first_kind_name, second_kind_id = item.second_kind_id, second_kind_name = item.second_kind_name, third_kind_id = item.third_kind_id, third_kind_name = item.third_kind_name, major_kind_id = item.major_kind_id, major_kind_name = item.major_kind_name, major_id = item.major_id, major_name = item.major_name, new_first_kind_id = item.new_first_kind_id, new_first_kind_name = item.new_first_kind_name, new_second_kind_id = item.new_second_kind_id, new_second_kind_name = item.new_second_kind_name, new_third_kind_id = item.new_third_kind_id, new_third_kind_name = item.new_third_kind_name, new_major_kind_id = item.new_major_kind_id, new_major_kind_name = item.new_major_kind_name, new_major_id = item.new_major_id, new_major_name = item.new_major_name, human_id = item.human_id, human_name = item.human_name, salary_standard_id = item.salary_standard_id, salary_standard_name = item.salary_standard_name, salary_sum = item.salary_sum, new_salary_standard_id = item.new_salary_standard_id, new_salary_standard_name = item.new_salary_standard_name, new_salary_sum = item.new_salary_sum, change_reason = item.change_reason, check_reason = item.check_reason, check_status = item.check_status, register = item.register, checker = item.checker, regist_time = item.regist_time, check_time = item.check_time }; list2.Add(mm); } return(list2); }
public async Task <IActionResult> register(major_changeModel mcm) { string firstname = HttpContext.Request.Form["configThird.firstKindId"]; string senconname = HttpContext.Request.Form["name2"]; string thirdname = HttpContext.Request.Form["name3"]; string majorkname = HttpContext.Request.Form["sss"]; string majj = HttpContext.Request.Form["sss2"]; string saj = HttpContext.Request.Form["sss3"]; string je = HttpContext.Request.Form["newsum"]; List <config_file_first_kindModel1> list = icf.Selects().Where(e => e.first_kind_id == firstname).ToList(); mcm.new_first_kind_id = list[0].first_kind_id; mcm.new_first_kind_name = list[0].first_kind_name; List <config_file_second_kindModel1> list1 = ics.Loads().Where(e => e.second_kind_id == senconname).ToList(); mcm.new_second_kind_id = list1[0].second_kind_id; mcm.new_second_kind_name = list1[0].second_kind_name; List <config_file_third_kindModel1> list2 = ict.Selectt().Where(e => e.third_kind_id == thirdname).ToList(); mcm.new_third_kind_id = list2[0].third_kind_id; mcm.new_third_kind_name = list2[0].third_kind_name; List <config_majorModel1> list3 = cm.Select().Where(e => e.major_kind_id == majorkname).ToList(); mcm.new_major_kind_id = list3[0].major_kind_id; mcm.new_major_kind_name = list3[0].major_kind_name; List <config_majorModel1> list4 = cm.Select().Where(e => e.major_id == majj).ToList(); mcm.new_major_id = list4[0].major_id; mcm.new_major_name = list4[0].major_name; List <salary_standardModel> list5 = ss.Select().Where(e => e.standard_name == saj).ToList(); mcm.new_salary_standard_id = list5[0].standard_id; mcm.new_salary_standard_name = list5[0].standard_name; mcm.new_salary_sum = Convert.ToDouble(je); mcm.register = ViewBag.User_name; mcm.regist_time = DateTime.Now; if (await mc.Ad(mcm) > 0) { return(Redirect("/Transfer/register_success")); //return RedirectToAction("Index"); } else { //ViewData.Model = mcm; //return RedirectToAction("register"); return(Content("<script>alert('失败')</script>")); } }
//public Dictionary<int, List<major_changeModel>> FenYeMc(int currpage, int pagesize) //{ // Dictionary<int, List<major_change>> dic = FenYeMajor_change(currpage, pagesize); // Dictionary<int, List<major_changeModel>> dic1 = new Dictionary<int, List<major_changeModel>>(); // List<major_changeModel> list = new List<major_changeModel>(); // int row = 0; // foreach (KeyValuePair<int, List<major_change>> items in dic) // { // row = items.Key; // foreach (major_change m in items.Value) // { // major_changeModel um = new major_changeModel() // { // mch_id = m.mch_id, // first_kind_id = m.first_kind_id, // first_kind_name = m.first_kind_name, // second_kind_id = m.second_kind_id, // second_kind_name = m.second_kind_name, // third_kind_id = m.third_kind_id, // third_kind_name = m.third_kind_name, // major_id = m.major_id, // major_name = m.major_name, // major_kind_id = m.major_kind_id, // major_kind_name = m.major_kind_name, // new_first_kind_id = m.new_first_kind_id, // new_first_kind_name = m.new_first_kind_name, // new_second_kind_id = m.new_second_kind_id, // new_second_kind_name = m.new_second_kind_name, // new_third_kind_id = m.new_third_kind_id, // new_third_kind_name = m.new_third_kind_name, // new_major_id = m.new_major_id, // new_major_name = m.new_major_name, // new_major_kind_id = m.new_major_kind_id, // new_major_kind_name = m.new_major_kind_name, // human_id = m.human_id, // human_name = m.human_name, // salary_standard_id = m.salary_standard_id, // salary_standard_name = m.salary_standard_name, // salary_sum = m.new_salary_sum, // new_salary_standard_id = m.new_salary_standard_id, // new_salary_standard_name = m.new_salary_standard_name, // new_salary_sum = m.new_salary_sum, // change_reason = m.change_reason, // check_reason = m.check_reason, // check_status = m.check_status, // register = m.register, // checker = m.checker, // regist_time = m.regist_time, // check_time = m.check_time // }; // list.Add(um); // } // } // dic1.Add(row, list); // return dic1; //} //public Dictionary<int, List<major_changeModel>> FenYeMc(int currpage, int pagesize) //{ // var data = hr.major_Changes.OrderBy(e => e.mch_id).Where(e => e.check_status != 1); // int rows = data.Count();//总行数 // var result = data.Skip((currepage - 1) * pagesize)//忽略多少条 // .Take(pagesize);//取多少条 // List<major_change> list = new List<major_change>(); // list = result.ToList(); // Dictionary<int, List<major_change>> dic = new Dictionary<int, List<major_change>>(); // dic.Add(rows, list); // return dic; //} #endregion public List <major_changeModel> Sel() { List <major_change> list = hr.major_Changes.ToList(); List <major_changeModel> list1 = new List <major_changeModel>(); foreach (major_change m in list) { major_changeModel ms = new major_changeModel() { mch_id = m.mch_id, first_kind_id = m.first_kind_id, first_kind_name = m.first_kind_name, second_kind_id = m.second_kind_id, second_kind_name = m.second_kind_name, third_kind_id = m.third_kind_id, third_kind_name = m.third_kind_name, major_id = m.major_id, major_name = m.major_name, major_kind_id = m.major_kind_id, major_kind_name = m.major_kind_name, new_first_kind_id = m.new_first_kind_id, new_first_kind_name = m.new_first_kind_name, new_second_kind_id = m.new_second_kind_id, new_second_kind_name = m.new_second_kind_name, new_third_kind_id = m.new_third_kind_id, new_third_kind_name = m.new_third_kind_name, new_major_id = m.new_major_id, new_major_name = m.new_major_name, new_major_kind_id = m.new_major_kind_id, new_major_kind_name = m.new_major_kind_name, human_id = m.human_id, human_name = m.human_name, salary_standard_id = m.salary_standard_id, salary_standard_name = m.salary_standard_name, salary_sum = m.salary_sum, new_salary_standard_id = m.new_salary_standard_id, new_salary_standard_name = m.new_salary_standard_name, new_salary_sum = m.new_salary_sum, change_reason = m.change_reason, check_reason = m.check_reason, check_status = m.check_status, register = m.register, checker = m.checker, regist_time = m.regist_time, check_time = m.check_time }; list1.Add(ms); } return(list1); }
public List <major_changeModel> SelectBy2(major_changeModel st) { List <major_change> list = SelectBy(e => e.new_salary_standard_id.Equals(st.new_salary_standard_id)); List <major_changeModel> list2 = new List <major_changeModel>(); foreach (var item in list) { major_changeModel sd = new major_changeModel() { Id = item.Id, first_kind_id = item.first_kind_id, first_kind_name = item.first_kind_name, second_kind_id = item.second_kind_id, second_kind_name = item.second_kind_name, third_kind_id = item.third_kind_id, third_kind_name = item.third_kind_name, major_kind_id = item.major_kind_id, major_kind_name = item.major_kind_name, major_id = item.major_id, major_name = item.major_name, new_first_kind_id = item.new_first_kind_id, new_first_kind_name = item.new_first_kind_name, new_second_kind_id = item.new_second_kind_id, new_second_kind_name = item.new_second_kind_name, new_third_kind_id = item.new_third_kind_id, new_third_kind_name = item.new_third_kind_name, new_major_kind_id = item.new_major_kind_id, new_major_kind_name = item.new_major_kind_name, new_major_id = item.new_major_id, new_major_name = item.new_major_name, human_id = item.human_id, human_name = item.human_name, salary_standard_id = item.salary_standard_id, salary_standard_name = item.salary_standard_name, salary_sum = item.salary_sum, new_salary_standard_id = item.new_salary_standard_id, new_salary_standard_name = item.new_salary_standard_name, new_salary_sum = item.new_salary_sum, change_reason = item.change_reason, check_reason = item.check_reason, check_status = item.check_status, register = item.register, checker = item.checker, regist_time = item.regist_time, check_time = item.check_time }; list2.Add(sd); } return(list2); }
public async Task <int> Ad(major_changeModel m) { major_change mm = new major_change() { mch_id = m.mch_id, first_kind_id = m.first_kind_id, first_kind_name = m.first_kind_name, second_kind_id = m.second_kind_id, second_kind_name = m.second_kind_name, third_kind_id = m.third_kind_id, third_kind_name = m.third_kind_name, major_id = m.major_id, major_name = m.major_name, major_kind_id = m.major_kind_id, major_kind_name = m.major_kind_name, new_first_kind_id = m.new_first_kind_id, new_first_kind_name = m.new_first_kind_name, new_second_kind_id = m.new_second_kind_id, new_second_kind_name = m.new_second_kind_name, new_third_kind_id = m.new_third_kind_id, new_third_kind_name = m.new_third_kind_name, new_major_id = m.new_major_id, new_major_name = m.new_major_name, new_major_kind_id = m.new_major_kind_id, new_major_kind_name = m.new_major_kind_name, human_id = m.human_id, human_name = m.human_name, salary_standard_id = m.salary_standard_id, salary_standard_name = m.salary_standard_name, salary_sum = m.salary_sum, new_salary_standard_id = m.new_salary_standard_id, new_salary_standard_name = m.new_salary_standard_name, new_salary_sum = m.new_salary_sum, change_reason = m.change_reason, check_reason = m.check_reason, check_status = m.check_status, register = m.register, checker = m.checker, regist_time = m.regist_time, check_time = m.regist_time }; //hr.Major_change.Attach(mm); //hr.Entry(mm).State = System.Data.Entity.EntityState.Modified; //return hr.SaveChanges(); hr.major_Changes.Add(mm); return(await hr.SaveChangesAsync()); }
public int Update(major_changeModel st) { major_change est = new major_change() { Id = st.Id, first_kind_id = st.first_kind_id, first_kind_name = st.first_kind_name, second_kind_id = st.second_kind_id, second_kind_name = st.second_kind_name, third_kind_id = st.third_kind_id, third_kind_name = st.third_kind_name, major_kind_id = st.major_kind_id, major_kind_name = st.major_kind_name, major_id = st.major_id, major_name = st.major_name, new_first_kind_id = st.new_first_kind_id, new_first_kind_name = st.new_first_kind_name, new_second_kind_id = st.new_second_kind_id, new_second_kind_name = st.new_second_kind_name, new_third_kind_id = st.new_third_kind_id, new_third_kind_name = st.new_third_kind_name, new_major_kind_id = st.new_major_kind_id, new_major_kind_name = st.new_major_kind_name, new_major_id = st.new_major_id, new_major_name = st.new_major_name, human_id = st.human_id, human_name = st.human_name, salary_standard_id = st.salary_standard_id, salary_standard_name = st.salary_standard_name, salary_sum = st.salary_sum, new_salary_standard_id = st.new_salary_standard_id, new_salary_standard_name = st.new_salary_standard_name, new_salary_sum = st.new_salary_sum, change_reason = st.change_reason, check_reason = st.check_reason, check_status = st.check_status, register = st.register, checker = st.checker, //regist_time = st.regist_time, regist_time = DateTime.Now, //check_time = st.check_time check_time = DateTime.Now }; return(Update(est)); }
public int Add(major_changeModel st) { //把DTO转为EO major_change est = new major_change() { Id = st.Id, first_kind_id = st.first_kind_id, first_kind_name = st.first_kind_name, second_kind_id = st.second_kind_id, second_kind_name = st.second_kind_name, third_kind_id = st.third_kind_id, third_kind_name = st.third_kind_name, major_kind_id = st.major_kind_id, major_kind_name = st.major_kind_name, major_id = st.major_id, major_name = st.major_name, new_first_kind_id = st.new_first_kind_id, new_first_kind_name = st.new_first_kind_name, new_second_kind_id = st.new_second_kind_id, new_second_kind_name = st.new_second_kind_name, new_third_kind_id = st.new_third_kind_id, new_third_kind_name = st.new_third_kind_name, new_major_kind_id = st.new_major_kind_id, new_major_kind_name = st.new_major_kind_name, new_major_id = st.new_major_id, new_major_name = st.new_major_name, human_id = st.human_id, human_name = st.human_name, salary_standard_id = st.salary_standard_id, salary_standard_name = st.salary_standard_name, salary_sum = st.salary_sum, new_salary_standard_id = st.new_salary_standard_id, new_salary_standard_name = st.new_salary_standard_name, new_salary_sum = st.new_salary_sum, change_reason = st.change_reason, check_reason = st.check_reason, check_status = st.check_status, register = st.register, checker = st.checker, regist_time = st.regist_time, check_time = st.check_time }; return(Add(est)); }
public major_changeModel SelById(int id) { major_change m = hr.Set <major_change>().AsNoTracking().Where(e => e.mch_id == id).FirstOrDefault(); major_changeModel mm = new major_changeModel() { mch_id = m.mch_id, first_kind_id = m.first_kind_id, first_kind_name = m.first_kind_name, second_kind_id = m.second_kind_id, second_kind_name = m.second_kind_name, third_kind_id = m.third_kind_id, third_kind_name = m.third_kind_name, major_id = m.major_id, major_name = m.major_name, major_kind_id = m.major_kind_id, major_kind_name = m.major_kind_name, new_first_kind_id = m.new_first_kind_id, new_first_kind_name = m.new_first_kind_name, new_second_kind_id = m.new_second_kind_id, new_second_kind_name = m.new_second_kind_name, new_third_kind_id = m.new_third_kind_id, new_third_kind_name = m.new_third_kind_name, new_major_id = m.new_major_id, new_major_name = m.new_major_name, new_major_kind_id = m.new_major_kind_id, new_major_kind_name = m.new_major_kind_name, human_id = m.human_id, human_name = m.human_name, salary_standard_id = m.salary_standard_id, salary_standard_name = m.salary_standard_name, salary_sum = m.salary_sum, new_salary_standard_id = m.new_salary_standard_id, new_salary_standard_name = m.new_salary_standard_name, new_salary_sum = m.new_salary_sum, change_reason = m.change_reason, check_reason = m.check_reason, check_status = m.check_status, register = m.register, checker = m.checker, regist_time = m.regist_time, check_time = m.regist_time }; return(mm); }
public ActionResult register(major_changeModel mcm) { config_file_second_kindModel csm = new config_file_second_kindModel { second_kind_id = mcm.new_second_kind_id }; config_file_first_kindModel cfm = new config_file_first_kindModel { first_kind_id = mcm.new_first_kind_id }; config_file_third_kindModel css = new config_file_third_kindModel { third_kind_id = mcm.new_third_kind_id }; config_major_kindModel cff = new config_major_kindModel { major_kind_id = mcm.new_major_kind_id }; config_majorModel cmm = new config_majorModel { major_id = mcm.new_major_id, major_kind_id = mcm.new_major_kind_id }; List <config_file_second_kindModel> lists = sb.SelectByName(csm); List <config_file_first_kindModel> listf = ib.SelectByName(cfm); List <config_file_third_kindModel> lis = isb.SelectByName(css); List <config_major_kindModel> liss = ia.SelectByName(cff); List <config_majorModel> litt = iii.SelectByName(cmm); mcm.new_second_kind_name = lists[0].second_kind_name; mcm.new_first_kind_name = listf[0].first_kind_name; mcm.new_third_kind_name = lis[0].third_kind_name; mcm.new_major_kind_name = liss[0].major_kind_name; mcm.new_major_name = litt[0].major_name; //修改操作 if (imb.Update(mcm) > 0) { return(Content("<script>alert('修改成功');window.location.href='/major_change/register_list'</script>")); } else { return(Content("<script>alert('修改失败');window.location.href='/major_change/register_list'</script>")); } }
public ActionResult tjcx() { int dqy = 1; if (Request["ye"] != null) { dqy = int.Parse(Request["ye"]); } //DateTime time2 = DateTime.Parse(Request["time2"].ToString()); major_changeModel mc = new major_changeModel { first_kind_id = Request["firstId"], second_kind_id = Request["secondId"], third_kind_id = Request["thirdId"] }; DateTime time1 = DateTime.Parse(Request["starttime"].ToString()); DateTime time2 = DateTime.Parse(Request["endtime"].ToString()); List <major_changeModel> list = imb.fenye1(dqy, mc, time1, time2); return(Content(JsonConvert.SerializeObject(list))); }
public int Update(major_changeModel st) { return(ist.Update(st)); }
public int Del(major_changeModel st) { return(ist.Del(st)); }
public int Add(major_changeModel st) { return(ist.Add(st)); }
public List <major_changeModel> SelectBy(major_changeModel st) { return(ist.SelectBy(st)); }
public List <major_changeModel> fenye1(int dqy, major_changeModel mm, DateTime time1, DateTime time2) { return(ist.fenye1(dqy, mm, time1, time2)); }
public List <major_changeModel> FenYe(FenYeModel fen) { List <major_changeModel> list = new List <major_changeModel>(); SqlParameter[] ps = { new SqlParameter() { ParameterName = "@pageSize", Value = fen.PageSize }, new SqlParameter() { ParameterName = "@keyName", Value = fen.KeyName }, new SqlParameter() { ParameterName = "@tableName", Value = fen.TableName }, new SqlParameter() { ParameterName = "@where", Value = fen.Where }, new SqlParameter() { ParameterName = "@currentPage", Value = fen.CurrentPage }, new SqlParameter() { ParameterName = "@rows", Direction = ParameterDirection.Output, SqlDbType = SqlDbType.Int }, new SqlParameter() { ParameterName = "@pages", Direction = ParameterDirection.Output, SqlDbType = SqlDbType.Int } }; var sql = hr.major_Changes.FromSqlRaw($@"exec dbo.FenYeWhere @pageSize,@keyName,@tableName,@where,@currentPage,@rows out,@pages out", ps).ToList(); foreach (var ad in sql) { major_changeModel h = new major_changeModel() { mch_id = ad.mch_id, first_kind_id = ad.first_kind_id, first_kind_name = ad.first_kind_name, second_kind_id = ad.second_kind_id, second_kind_name = ad.second_kind_name, third_kind_id = ad.third_kind_id, third_kind_name = ad.third_kind_name, major_id = ad.major_id, major_name = ad.major_name, major_kind_id = ad.major_kind_id, major_kind_name = ad.major_kind_name, new_first_kind_id = ad.new_first_kind_id, new_first_kind_name = ad.new_first_kind_name, new_second_kind_id = ad.new_second_kind_id, new_second_kind_name = ad.new_second_kind_name, new_third_kind_id = ad.new_third_kind_id, new_third_kind_name = ad.new_third_kind_name, new_major_id = ad.new_major_id, new_major_name = ad.new_major_name, new_major_kind_id = ad.new_major_kind_id, new_major_kind_name = ad.new_major_kind_name, human_id = ad.human_id, human_name = ad.human_name, salary_standard_id = ad.salary_standard_id, salary_standard_name = ad.salary_standard_name, salary_sum = ad.new_salary_sum, new_salary_standard_id = ad.new_salary_standard_id, new_salary_standard_name = ad.new_salary_standard_name, new_salary_sum = ad.new_salary_sum, change_reason = ad.change_reason, check_reason = ad.check_reason, check_status = ad.check_status, register = ad.register, checker = ad.checker, regist_time = ad.regist_time, check_time = ad.check_time }; list.Add(h); } fen.Pages = (int)ps[6].Value; fen.Rows = (int)ps[5].Value; return(list); }
public Task <int> Ad(major_changeModel m) { return(mc.Ad(m)); }
public Task <int> Up(int mch_id, major_changeModel m) { return(mc.Up(mch_id, m)); }
public IActionResult register(int id) { human_fileModel hfm = hum.SelByID02(id); ViewBag.User_name = HttpContext.Session.GetString("User_name"); major_changeModel mcm = new major_changeModel() { first_kind_id = hfm.first_kind_id, first_kind_name = hfm.first_kind_name, second_kind_id = hfm.second_kind_id, second_kind_name = hfm.second_kind_name, third_kind_id = hfm.third_kind_id, third_kind_name = hfm.third_kind_name, major_id = hfm.human_major_id, major_name = hfm.hunma_major_name, major_kind_id = hfm.human_major_kind_id, major_kind_name = hfm.human_major_kind_name, human_id = hfm.human_id, human_name = hfm.human_name, salary_standard_id = hfm.salary_standard_id, salary_standard_name = hfm.salary_standard_name, salary_sum = hfm.salary_sum, regist_time = DateTime.Now, register = HttpContext.Session.GetString("User_name") }; //1 List <config_file_first_kindModel1> list = icf.Selects(); List <config_file_first_kindModel1> lis = icf.Selects().Where(e => e.first_kind_name == mcm.first_kind_name).ToList(); for (int i = 0; i < lis.Count; i++) { if (list[i].first_kind_name == lis[0].first_kind_name) { list.Remove(list[i]); break; } } List <config_major_kindModel1> list3 = cmk.Select(); List <config_major_kindModel1> lis4 = cmk.Select().Where(e => e.major_kind_id == mcm.major_kind_id).ToList(); for (int i = 0; i < list3.Count; i++) { if (list3[i].major_kind_id == lis4[0].major_kind_id) { list3.Remove(list3[i]); break; } } List <salary_standardModel> list5 = ss.Select().Where(e => e.check_status == 1).ToList(); SelectList sl = new SelectList(list, "first_kind_name", "first_kind_name", "请选择"); SelectList sl3 = new SelectList(list3, "major_kind_name", "major_kind_name", "请选择"); SelectList sl5 = new SelectList(list5, "standard_name", "standard_name", "请选择"); ViewData["majork"] = sl3; ViewData["standard"] = sl5; ViewData["first"] = sl; ViewData.Model = mcm; return(View()); }