public int ADDMajor_change(Major_changeModel mm)
{
major_change mc = new major_change()
{
human_name = mm.human_name,
first_kind_name = mm.first_kind_name,
second_kind_name = mm.second_kind_name,
third_kind_name = mm.third_kind_name,
major_kind_name = mm.major_kind_name,
major_name = mm.major_name,
salary_standard_name = mm.salary_standard_name,
salary_sum = mm.salary_sum,
new_first_kind_name = mm.new_first_kind_name,
new_second_kind_name = mm.new_second_kind_name,
new_third_kind_name = mm.new_third_kind_name,
new_major_kind_name = mm.new_major_kind_name,
new_major_name = mm.new_major_name,
new_salary_standard_name = mm.new_salary_standard_name,
new_salary_sum = mm.new_salary_sum,
register = mm.register,
regist_time = mm.regist_time,
change_reason = mm.change_reason
};
return(Add(mc));
}
public int DELETEMajor_change(Major_changeModel mm)
{
major_change mc = new major_change()
{
Id = mm.Id,
};
return(Delete(mc));
}
public List <Major_changeModel> Major_changemanFenYe(int currentPage, int PageSize, out int rows)
{
var list = CreateContext().Major_change.AsNoTracking().OrderBy(e => e.mch_id);
rows = list.Count();
var data = list
.Skip((currentPage - 1) * PageSize)
.Take(PageSize)
.ToList();
List <Major_changeModel> list2 = new List <Major_changeModel>();
foreach (var p in data)
{
Major_changeModel e = new Major_changeModel()
{
change_reason = p.change_reason,
checker = p.checker,
check_reason = p.check_reason,
check_status = p.check_status,
check_time = p.check_time,
first_kind_id = p.first_kind_id,
first_kind_name = p.first_kind_name,
major_kind_id = p.major_kind_id,
major_id = p.major_id,
human_name = p.human_name,
human_id = p.human_id,
major_kind_name = p.major_kind_name,
major_name = p.major_name,
mch_id = p.mch_id,
new_first_kind_id = p.new_first_kind_id,
new_first_kind_name = p.new_first_kind_name,
new_major_id = p.new_major_id,
new_major_kind_id = p.new_major_kind_id,
new_major_kind_name = p.new_major_kind_name,
new_salary_standard_id = p.new_salary_standard_id,
new_major_name = p.new_major_name,
new_third_kind_id = p.new_third_kind_id,
new_salary_standard_name = p.new_salary_standard_name,
new_second_kind_name = p.new_second_kind_name,
new_second_kind_id = p.new_second_kind_id,
new_salary_sum = p.new_salary_sum,
register = p.register,
new_third_kind_name = p.new_third_kind_name,
salary_standard_id = p.salary_standard_id,
salary_standard_name = p.salary_standard_name,
salary_sum = p.salary_sum,
regist_time = p.regist_time,
second_kind_id = p.second_kind_id,
second_kind_name = p.second_kind_name,
third_kind_id = p.third_kind_id,
third_kind_name = p.third_kind_name
};
list2.Add(e);
}
return(list2);
}
public List <Major_changeModel> Major_changeSelectSh(int currentPage, int pageSize, out int rows)
{
var list = CreateContext().Major_change.Where(e => e.check_status == 0).OrderBy(e => e.mch_id).ToList();
rows = list.Count();
var data = list
.Skip((currentPage - 1) * pageSize)
.Take(pageSize)
.ToList();
List <Major_changeModel> list2 = new List <Major_changeModel>();
foreach (var item in data)
{
Major_changeModel er = new Major_changeModel()
{
Check_status = item.check_status,
Mch_id = item.mch_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,
Register = item.register,
Checker = item.checker,
Regist_time = item.regist_time,
Check_time = item.check_time
};
list2.Add(er);
}
return(list2);
}
public List <Major_changeModel> SelectMajor_changeBy(int id)
{
MyDbContext db = CreateContext();
List <Major_change> list = db.Major_change.AsNoTracking()
.Where(e => e.mch_id == id)
.Select(e => e)
.ToList();
List <Major_changeModel> list2 = new List <Major_changeModel>();
foreach (Major_change p in list)
{
Major_changeModel sm = new Major_changeModel()
{
change_reason = p.change_reason,
checker = p.checker,
check_reason = p.check_reason,
check_status = p.check_status,
check_time = p.check_time,
first_kind_id = p.first_kind_id,
first_kind_name = p.first_kind_name,
major_kind_id = p.major_kind_id,
major_id = p.major_id,
human_name = p.human_name,
human_id = p.human_id,
major_kind_name = p.major_kind_name,
major_name = p.major_name,
mch_id = p.mch_id,
new_first_kind_id = p.new_first_kind_id,
new_first_kind_name = p.new_first_kind_name,
new_major_id = p.new_major_id,
new_major_kind_id = p.new_major_kind_id,
new_major_kind_name = p.new_major_kind_name,
new_salary_standard_id = p.new_salary_standard_id,
new_major_name = p.new_major_name,
new_third_kind_id = p.new_third_kind_id,
new_salary_standard_name = p.new_salary_standard_name,
new_second_kind_name = p.new_second_kind_name,
new_second_kind_id = p.new_second_kind_id,
new_salary_sum = p.new_salary_sum,
register = p.register,
new_third_kind_name = p.new_third_kind_name,
salary_standard_id = p.salary_standard_id,
salary_standard_name = p.salary_standard_name,
salary_sum = p.salary_sum,
regist_time = p.regist_time,
second_kind_id = p.second_kind_id,
second_kind_name = p.second_kind_name,
third_kind_id = p.third_kind_id,
third_kind_name = p.third_kind_name
};
list2.Add(sm);
}
return(list2);;
}
public List <Major_changeModel> SelectMajor_changeBy(int id)
{
MyDbContext db = CreateContext();
List <Major_change> list = db.Major_change.AsNoTracking()
.Where(e => e.mch_id == id)
.Select(e => e)
.ToList();
List <Major_changeModel> list2 = new List <Major_changeModel>();
foreach (Major_change item in list)
{
Major_changeModel sm = new Major_changeModel()
{
Check_status = item.check_status,
Mch_id = item.mch_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,
Register = item.register,
Checker = item.checker,
Regist_time = item.regist_time,
Check_time = item.check_time
};
list2.Add(sm);
}
return(list2);
}
public ActionResult Update(Major_changeModel mc)
{
if (imc.Major_changeAdd(mc) > 0)
{
return(View("register_success"));
}
else
{
return(View(mc));
}
}
public List <Major_changeModel> Major_changeSelect()
{
List <Major_change> list = Select();
List <Major_changeModel> list2 = new List <Major_changeModel>();
foreach (Major_change p in list)
{
Major_changeModel sm = new Major_changeModel()
{
change_reason = p.change_reason,
checker = p.checker,
check_reason = p.check_reason,
check_status = p.check_status,
check_time = p.check_time,
first_kind_id = p.first_kind_id,
first_kind_name = p.first_kind_name,
major_kind_id = p.major_kind_id,
major_id = p.major_id,
human_name = p.human_name,
human_id = p.human_id,
major_kind_name = p.major_kind_name,
major_name = p.major_name,
mch_id = p.mch_id,
new_first_kind_id = p.new_first_kind_id,
new_first_kind_name = p.new_first_kind_name,
new_major_id = p.new_major_id,
new_major_kind_id = p.new_major_kind_id,
new_major_kind_name = p.new_major_kind_name,
new_salary_standard_id = p.new_salary_standard_id,
new_major_name = p.new_major_name,
new_third_kind_id = p.new_third_kind_id,
new_salary_standard_name = p.new_salary_standard_name,
new_second_kind_name = p.new_second_kind_name,
new_second_kind_id = p.new_second_kind_id,
new_salary_sum = p.new_salary_sum,
register = p.register,
new_third_kind_name = p.new_third_kind_name,
salary_standard_id = p.salary_standard_id,
salary_standard_name = p.salary_standard_name,
salary_sum = p.salary_sum,
regist_time = p.regist_time,
second_kind_id = p.second_kind_id,
second_kind_name = p.second_kind_name,
third_kind_id = p.third_kind_id,
third_kind_name = p.third_kind_name
};
list2.Add(sm);
}
return(list2);;
}
public List <Major_changeModel> Major_changeSelect()
{
List <Major_change> list = Select();
List <Major_changeModel> list2 = new List <Major_changeModel>();
foreach (Major_change item in list)
{
Major_changeModel sm = new Major_changeModel()
{
Check_status = item.check_status,
Mch_id = item.mch_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,
Register = item.register,
Checker = item.checker,
Regist_time = item.regist_time,
Check_time = item.check_time
};
list2.Add(sm);
}
return(list2);;
}
public ActionResult Update(Major_changeModel mc)
{
Major_changeModel mcm = imc.SelectMajor_changeBy(mc.Mch_id)[0];
mcm.Checker = mc.Checker;
mcm.Check_time = DateTime.Now;
mcm.Check_reason = mc.Check_reason;
mcm.Check_status = mc.Check_status;
if (mcm.Check_status == 1)
{
//审核通过
HumanFileModel hf = ihb.HumanFileByid(mc.Human_id);
hf.FirstMid = mcm.New_first_kind_id;
hf.FirstMName = mcm.New_first_kind_name;
hf.SecondMid = mcm.New_second_kind_id;
hf.SecondMName = mcm.New_second_kind_name;
hf.ThirdMid = mcm.New_third_kind_id;
hf.ThirdMName = mcm.New_third_kind_name;
hf.HumanMajorId = mcm.New_major_id;
hf.HumanMajorName = mcm.New_major_name;
hf.HumanMajorKindId = mcm.New_major_kind_id;
hf.HumanMajorKindName = mcm.New_major_kind_name;
hf.SalaryStandardId = mcm.New_salary_standard_id;
hf.SalaryStandardName = mcm.New_salary_standard_name;
hf.SalarySum = mcm.New_salary_sum;
if (imc.Major_changeUpdate(mcm) > 0 && ihb.HumanFileUp(mc.Human_id) > 0 && ihb.HumanFileUpdate(hf) > 0)
{
return(View("check_success"));
}
else
{
return(View("check?id=" + mcm.Mch_id));
}
}
else
{
//审核不通过
if (imc.Major_changeDelete(mcm) > 0)
{
return(View("check_success"));
}
else
{
return(View("check_list"));
}
}
}
public int Major_changeDelete(Major_changeModel p)
{
Major_change pc = new Major_change()
{
check_status = p.Check_status,
mch_id = p.Mch_id,
first_kind_id = p.First_kind_id,
first_kind_name = p.First_kind_name,
second_kind_id = p.Second_kind_id,
second_kind_name = p.Second_kind_name,
third_kind_id = p.Third_kind_id,
third_kind_name = p.Third_kind_name,
major_kind_id = p.Major_kind_id,
major_kind_name = p.Major_kind_name,
major_id = p.Major_id,
major_name = p.Major_name,
new_first_kind_id = p.New_first_kind_id,
new_first_kind_name = p.New_first_kind_name,
new_second_kind_id = p.New_second_kind_id,
new_second_kind_name = p.New_second_kind_name,
new_third_kind_id = p.New_third_kind_id,
new_third_kind_name = p.New_third_kind_name,
new_major_kind_id = p.New_major_kind_id,
new_major_kind_name = p.New_major_kind_name,
new_major_id = p.New_major_id,
new_major_name = p.New_major_name,
human_id = p.Human_id,
human_name = p.Human_name,
salary_standard_id = p.Salary_standard_id,
salary_standard_name = p.Salary_standard_name,
salary_sum = p.Salary_sum,
new_salary_standard_id = p.New_salary_standard_id,
new_salary_standard_name = p.New_salary_standard_name,
new_salary_sum = p.New_salary_sum,
change_reason = p.Change_reason,
check_reason = p.Check_reason,
register = p.Register,
checker = p.Checker,
regist_time = p.Regist_time,
check_time = p.Check_time
};
return(Delete(pc));
}
public int Major_changeDelete(Major_changeModel p)
{
Major_change st = new Major_change()
{
change_reason = p.change_reason,
checker = p.checker,
check_reason = p.check_reason,
check_status = p.check_status,
check_time = p.check_time,
first_kind_id = p.first_kind_id,
first_kind_name = p.first_kind_name,
major_kind_id = p.major_kind_id,
major_id = p.major_id,
human_name = p.human_name,
human_id = p.human_id,
major_kind_name = p.major_kind_name,
major_name = p.major_name,
mch_id = p.mch_id,
new_first_kind_id = p.new_first_kind_id,
new_first_kind_name = p.new_first_kind_name,
new_major_id = p.new_major_id,
new_major_kind_id = p.new_major_kind_id,
new_major_kind_name = p.new_major_kind_name,
new_salary_standard_id = p.new_salary_standard_id,
new_major_name = p.new_major_name,
new_third_kind_id = p.new_third_kind_id,
new_salary_standard_name = p.new_salary_standard_name,
new_second_kind_name = p.new_second_kind_name,
new_second_kind_id = p.new_second_kind_id,
new_salary_sum = p.new_salary_sum,
register = p.register,
new_third_kind_name = p.new_third_kind_name,
salary_standard_id = p.salary_standard_id,
salary_standard_name = p.salary_standard_name,
salary_sum = p.salary_sum,
regist_time = p.regist_time,
second_kind_id = p.second_kind_id,
second_kind_name = p.second_kind_name,
third_kind_id = p.third_kind_id,
third_kind_name = p.third_kind_name
};
return(Delete(st));
}
public List <Major_changeModel> selectcx(string where)
{
List <major_change> list = SelectBy(e => e.third_kind_id == where);
List <Major_changeModel> list2 = new List <Major_changeModel>();
foreach (major_change item in list)
{
Major_changeModel md = new Major_changeModel()
{
first_kind_name = item.first_kind_name,
second_kind_name = item.second_kind_name,
third_kind_name = item.third_kind_name,
salary_standard_name = item.salary_standard_name,
human_name = item.human_name
};
list2.Add(md);
}
return(list2);
}
public List <Major_changeModel> SELECTMajor_change()
{
List <major_change> list = SelectAll();
List <Major_changeModel> list2 = new List <Major_changeModel>();
foreach (major_change item in list)
{
Major_changeModel md = new Major_changeModel()
{
first_kind_name = item.first_kind_name,
second_kind_name = item.second_kind_name,
third_kind_name = item.third_kind_name,
salary_standard_name = item.salary_standard_name,
human_name = item.human_name,
first_kind_id = item.first_kind_id
};
list2.Add(md);
}
return(list2);
}
public int DELETEMajor_change(Major_changeModel mm)
{
return(ifm.DELETEMajor_change(mm));
}
public List <Major_changeModel> Major_changeSelectDcx(int currentPage, int pageSize, out int rows, string mkid, string mid, string gjz, string zwfl, string zwmc, DateTime?startTime, DateTime?endTime)
{
string sql = "select * from Major_change where 1=1 ";
if (mkid != null && mkid != "" && mkid != "0")
{
sql += string.Format(" and new_first_kind_id={0} ", mkid);
}
if (mid != null && mid != "" && mid != "0")
{
sql += string.Format(" and new_second_kind_id={0}", mid);
}
if (gjz != null && gjz != "" && gjz != "0")
{
sql += string.Format(" and new_third_kind_id={0}", gjz);
}
if (zwfl != null && zwfl != "" && zwfl != "0")
{
sql += string.Format(" and new_major_kind_id={0}", zwfl);
}
if (zwmc != null && zwmc != "" && zwmc != "0")
{
sql += string.Format(" and new_major_id={0}", zwmc);
}
if (startTime != null && endTime != null)
{
sql += (string.Format(" and regist_time>= '{0}' and check_time<='{1}' ", startTime, endTime));
}
var list = CreateContext().Major_change.SqlQuery(sql).Where(e => e.check_status == 1).OrderBy(e => e.mch_id).ToList();
rows = list.Count();
var data = list
.Skip((currentPage - 1) * pageSize)
.Take(pageSize)
.ToList();
List <Major_changeModel> list2 = new List <Major_changeModel>();
foreach (var item in data)
{
Major_changeModel er = new Major_changeModel()
{
Check_status = item.check_status,
Mch_id = item.mch_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,
Register = item.register,
Checker = item.checker,
Regist_time = item.regist_time,
Check_time = item.check_time
};
list2.Add(er);
}
return(list2);
}
public int UPDATEMajor_change(Major_changeModel mm)
{
throw new NotImplementedException();
}
public int Major_changeUpdate(Major_changeModel sm)
{
return(iub.Major_changeUpdate(sm));
}
public int Major_changeAdd(Major_changeModel sm)
{
return(iub.Major_changeAdd(sm));
}
public int Major_changeDelete(Major_changeModel sm)
{
return(ist.Major_changeDelete(sm));
}
public int ADDMajor_change(Major_changeModel mm)
{
return(ifm.ADDMajor_change(mm));
}
