//添加
public async Task <IActionResult> register_Add(salary_standardModel1 ssm)
{
if (ModelState.IsValid)
{
string[] item_id = HttpContext.Request.Form["details.itemId"];
string[] item_name = HttpContext.Request.Form["details.itemName"];
string[] salary = HttpContext.Request.Form["details.salary"];
int result = await issb.salary_standardAdd(ssm);
if (result > 0)
{
for (int i = 0; i < item_id.Length; i++)
{
salary_standard_detailsModel ssdm = new salary_standard_detailsModel()
{
item_id = int.Parse(item_id[i].ToString()),
item_name = item_name[i].ToString(),
salary = double.Parse(salary[i].ToString()),
standard_id = ssm.standard_id,
standard_name = ssm.standard_name
};
int result2 = await issdb.salary_standard_detailsAdd(ssdm);
}
}
return(View("register_success"));
}
else
{
return(View(ssm));
}
}
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 async Task <IActionResult> Upd(salary_standardModel1 ssm)
{
string[] sdt_id = HttpContext.Request.Form["sdt_id"];
string[] item_name = HttpContext.Request.Form["item_name"];
string[] salary = HttpContext.Request.Form["salary"];
string ssid = HttpContext.Request.Form["ssid"];
ssm.ssd_id = int.Parse(ssid);
int result = await issb.Upd(ssm);
if (result > 0)
{
for (int i = 0; i < sdt_id.Length; i++)
{
salary_standard_detailsModel ssdm = new salary_standard_detailsModel()
{
standard_id = ssm.standard_id,
standard_name = ssm.standard_name,
sdt_id = int.Parse(sdt_id[i]),
item_name = item_name[i],
salary = double.Parse(salary[i])
};
await issdb.Update(ssdm);
}
return(RedirectToAction("change_success"));
}
else
{
return(RedirectToAction("change_success"));
}
}
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 int update(salary_standard_detailsModel item)
{
salary_standard_details ko = db.salary_standard_details.Where(e => e.Id == (item.id)).FirstOrDefault();
ko.Id = item.id;
ko.salary = item.salary;
return(db.SaveChanges());
}
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 ActionResult Select2()
{
string s = Request["salaid"];
salary_standard_detailsModel sala = new salary_standard_detailsModel()
{
standard_id = s
};
List <salary_standard_detailsModel> list = sd.selectBYid(sala);
return(Content(JsonConvert.SerializeObject(list)));
}
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 Add(salary_standard_detailsModel item)
{
salary_standard_details ko = new salary_standard_details();
ko.Id = item.id;
ko.standard_id = item.standard_id;
ko.standard_name = item.standard_name;
ko.item_id = item.item_id;
ko.item_name = item.item_name;
ko.salary = item.salary; return(Add(ko));
}
public int Addsalary_standard_details(salary_standard_detailsModel ASD)
{
salary_standard_details ssd = new salary_standard_details()
{
standard_id = ASD.standard_id,
standard_name = ASD.standard_name,
item_id = ASD.item_id,
item_name = ASD.item_name,
salary = ASD.salary,
};
return(Add(ssd));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="s"></param
/// <returns></returns>
public int salary_standard_detailsAdd(salary_standard_detailsModel s)
{
salary_standard_details ss = new salary_standard_details()
{
standard_id = s.standard_id,
standard_name = s.standard_name,
item_id = s.item_id,
item_name = s.item_name,
salary = s.salary
};
return(Add(ss));
}
public int BJCreate(salary_standard_detailsModel bjm)
{
salary_standard_details bj = new salary_standard_details()
{
standard_id = bjm.standard_id,
standard_name = bjm.standard_name,
item_id = bjm.item_id,
item_name = bjm.item_name,
salary = bjm.salary
};
return(Add(bj));
}
public int Updatesalary_standard_details(salary_standard_detailsModel ASD)
{
salary_standard_details ssd = new salary_standard_details()
{
standard_id = ASD.standard_id,
standard_name = ASD.standard_name,
item_id = ASD.item_id,
item_name = ASD.item_name,
salary = ASD.salary,
sdt_id = ASD.sdt_id,
};
return(Update(ssd));
}
public int salaUP(salary_standard_detailsModel s)
{
salary_standard_details ss = new salary_standard_details()
{
Id = s.Id,
standard_id = s.standard_id,
standard_name = s.standard_name,
item_id = s.item_id,
item_name = s.item_name,
salary = s.salary
};
return(Update(ss));
}
public int BJEdit(salary_standard_detailsModel bjm)
{
salary_standard_details bj = new salary_standard_details()
{
standard_id = bjm.standard_id,
standard_name = bjm.standard_name,
sdt_id = bjm.sdt_id,
item_id = bjm.item_id,
item_name = bjm.item_name,
salary = bjm.salary
};
return(Edit(bj));
}
//添加
public async Task <int> salary_standard_detailsAdd(salary_standard_detailsModel ssdm)
{
salary_standard_details ssd1 = new salary_standard_details()
{
sdt_id = ssdm.sdt_id,
salary = ssdm.salary,
standard_id = ssdm.standard_id,
standard_name = ssdm.standard_name,
item_id = ssdm.item_id,
item_name = ssdm.item_name
};
tescDbContext.ssd.Add(ssd1);
return(await tescDbContext.SaveChangesAsync());
}
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 List <salary_standard_detailsModel> select()
{
List <salary_standard_details> list = SelectAll();
List <salary_standard_detailsModel> li = new List <salary_standard_detailsModel>();
foreach (salary_standard_details item in list)
{
salary_standard_detailsModel ko = new salary_standard_detailsModel();
ko.id = item.Id;
ko.standard_id = item.standard_id;
ko.standard_name = item.standard_name;
ko.item_id = item.item_id;
ko.item_name = item.item_name;
ko.salary = item.salary; li.Add(ko);
}
return(li);
}
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 List <salary_standard_detailsModel> selectupdate(string id)
{
List <salary_standard_details> list = SeleteBy(e => e.standard_id.Equals(id));
List <salary_standard_detailsModel> li = new List <salary_standard_detailsModel>();
foreach (salary_standard_details item in list)
{
salary_standard_detailsModel ko = new salary_standard_detailsModel();
ko.id = item.Id;
ko.standard_id = item.standard_id;
ko.standard_name = item.standard_name;
ko.item_id = item.item_id;
ko.item_name = item.item_name;
ko.salary = item.salary; li.Add(ko);
}
return(li);
}
//复核修改
public async Task <int> Update(salary_standard_detailsModel s)
{
salary_standard_details ss = new salary_standard_details()
{
sdt_id = s.sdt_id,
item_name = s.item_name,
salary = s.salary,
standard_id = s.standard_id,
standard_name = s.standard_name
};
tescDbContext.ssd.Attach(ss);
//修改指定的列
tescDbContext.Entry(ss).Property(p => p.item_name).IsModified = true;
tescDbContext.Entry(ss).Property(p => p.salary).IsModified = true;
tescDbContext.Entry(ss).Property(p => p.standard_id).IsModified = true;
tescDbContext.Entry(ss).Property(p => p.standard_name).IsModified = true;
return(await tescDbContext.SaveChangesAsync());
}
public List <salary_standard_detailsModel> Selectsalary_standard_details(string id)
{
List <salary_standard_detailsModel> list = new List <salary_standard_detailsModel>();
List <salary_standard_details> list1 = SelectBy(e => e.standard_id.Equals(id));
foreach (var ASD in list1)
{
salary_standard_detailsModel ssd = new salary_standard_detailsModel()
{
standard_id = ASD.standard_id,
standard_name = ASD.standard_name,
item_id = ASD.item_id,
item_name = ASD.item_name,
salary = ASD.salary,
sdt_id = ASD.sdt_id,
};
list.Add(ssd);
}
return(list);
}
public List <salary_standard_detailsModel> Select()
{
List <salary_standard_details> list = SelectAll();
List <salary_standard_detailsModel> list2 = new List <salary_standard_detailsModel>();
foreach (salary_standard_details item in list)
{
salary_standard_detailsModel sm = new salary_standard_detailsModel()
{
Id = item.Id,
standard_id = item.standard_id,
standard_name = item.standard_name,
item_id = item.item_id,
item_name = item.item_name,
salary = item.salary
};
list2.Add(sm);
}
return(list2);
}
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 List <salary_standard_detailsModel> Select()
{
List <salary_standard_details> list = tescDbContext.ssd.ToList();
List <salary_standard_detailsModel> list2 = new List <salary_standard_detailsModel>();
foreach (var item in list)
{
salary_standard_detailsModel ssm = new salary_standard_detailsModel()
{
sdt_id = item.sdt_id,
standard_id = item.standard_id,
standard_name = item.standard_name,
item_id = item.item_id,
item_name = item.item_name,
salary = item.salary
};
list2.Add(ssm);
}
return(list2);
}
public List <salary_standard_detailsModel> BJSelect()
{
List <salary_standard_details> list = Select();
List <salary_standard_detailsModel> list2 = new List <salary_standard_detailsModel>();
//需要把ED->DTO
foreach (salary_standard_details item in list)
{
salary_standard_detailsModel bjm = new salary_standard_detailsModel()
{
standard_id = item.standard_id,
standard_name = item.standard_name,
sdt_id = item.sdt_id,
item_id = item.item_id,
item_name = item.item_name,
salary = item.salary
};
list2.Add(bjm);
}
return(list2);
}
public List <salary_standard_detailsModel> selectBYid(salary_standard_detailsModel id)
{
List <salary_standard_details> s1 = SelectBy(e => e.standard_id.Equals(id.standard_id));
List <salary_standard_detailsModel> list = new List <salary_standard_detailsModel>();
foreach (var s in s1)
{
salary_standard_detailsModel s2 = new salary_standard_detailsModel()
{
Id = s.Id,
standard_id = s.standard_id,
standard_name = s.standard_name,
item_id = s.item_id,
item_name = s.item_name,
salary = s.salary
};
list.Add(s2);
}
return(list);
}
public List <salary_standard_detailsModel> BJSelectBy2(string id)
{
List <salary_standard_details> bj = SelectBy1(id);
List <salary_standard_detailsModel> list = new List <salary_standard_detailsModel>();
//把EO->DTO
foreach (salary_standard_details item in bj)
{
salary_standard_detailsModel bjm = new salary_standard_detailsModel()
{
sdt_id = item.sdt_id,
standard_id = item.standard_id,
standard_name = item.standard_name,
item_id = item.item_id,
item_name = item.item_name,
salary = item.salary
};
list.Add(bjm);
}
return(list);
}
//复核修改
public async Task <IActionResult> Update(salary_standardModel1 ssm)
{
string[] sdt_id = HttpContext.Request.Form["sdt_id"];
string[] item_name = HttpContext.Request.Form["item_name"];
string[] salary = HttpContext.Request.Form["salary"];
string ssid = HttpContext.Request.Form["ssid"];
ssm.ssd_id = int.Parse(ssid);
int result = await issb.Update(ssm);
if (result > 0)
{
for (int i = 0; i < sdt_id.Length; i++)
{
salary_standard_detailsModel ssdm = new salary_standard_detailsModel()
{
standard_id = ssm.standard_id,
standard_name = ssm.standard_name,
sdt_id = int.Parse(sdt_id[i]),
item_name = item_name[i],
salary = double.Parse(salary[i])
};
await issdb.Update(ssdm);
}
return(RedirectToAction("check_success"));
}
else
{
List <salary_standardModel1> list = issb.Select().Where(e => e.standard_id == ssm.standard_id).ToList();
List <salary_standard_detailsModel> list2 = issdb.Select().Where(e => e.standard_id == ssm.standard_id).ToList();
ViewTable vt = new ViewTable()
{
salary_standardModel = list,
salary_standard_detailsModel = list2
};
return(View(vt));
}
}
public int Updatesalary_standard_details(salary_standard_detailsModel ASD)
{
return(DSD.Updatesalary_standard_details(ASD));
}
