//添加
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 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_details> SelectBy3(string id)
{
List <salary_standard_details> list = new List <salary_standard_details>();
var persons = hrdb.salar1.Where(p => p.standard_id == id).AsNoTracking();
foreach (var item in persons)
{
salary_standard_details bj = new salary_standard_details()
{
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
};
list.Add(bj);
}
return(list);
}
public ActionResult salarystandard_register_success(salary_standard ss, FormCollection fc)
{
//List<config_public_char> lcpc = cpcs.Select();
List <string> ls = new List <string>();
for (int i = 1; i < 7; i++)
{
short o = short.Parse(fc["details[" + i + "].item_id"]);
string d = fc["details[" + i + "].itemName"];
decimal s = decimal.Parse(fc["details[" + i + "].salary"]);
salary_standard_details ssd = new salary_standard_details()
{
standard_id = ss.standard_id,
item_name = d,
item_id = o,
standard_name = ss.standard_name,
salary = s
};
ssds.Add(ssd);
}
sss.Add(ss);
return(View());
}
//变更
public ActionResult salarystandard_change_success(salary_standard ss, FormCollection fc)
{
List <string> ls = new List <string>();
for (int i = 1; i < 7; i++)
{
short id = short.Parse(fc["details[" + i + "].sdtId"]);
short o = short.Parse(fc["details[" + i + "].itemId"]);
string d = fc["details[" + i + "].itemName"];
decimal s = decimal.Parse(fc["details[" + i + "].salary"]);
salary_standard_details ssd = new salary_standard_details()
{
standard_id = ss.standard_id,
item_name = d,
item_id = o,
standard_name = ss.standard_name,
salary = s,
sdt_id = id
};
ssds.Upd(ssd);
}
sss.Upd(ss);
return(View());
}
public int salary_standard_detailsUpdate(salary_standard_details sd)
{
return(dao.salary_standard_detailsUpdate(sd));
}
public int Del(salary_standard_details t)
{
return(dao.Del(t));
}
//薪酬标准单详细信息表
public int salary_standard_detailsInsert(salary_standard_details sd)
{
return(dao.salary_standard_detailsInsert(sd));
}
public int Change(salary_standard_details t)
{
return(dao.Change(t));
}
public int Add(salary_standard_details t)
{
return(dao.Add(t));
}
public salary_standard_details SelectOne(salary_standard_details us)
{
return(ist.SelectBy(e => e.standard_id == us.standard_id)[0]);
}
public bool Upd(salary_standard_details us)
{
return(ist.Upd(us));
}
public bool Del(salary_standard_details us)
{
return(ist.Del(us));
}
