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());
}
