public List <SalaryGrantdetailsModel> SalaryGrantdetailsSelectID(string id)
{
MyDbContext db = CreateContext();
List <SalaryGrantdetails> list = db.SalaryGrantdetails.AsNoTracking()
.Where(e => e.Salarygrantid == id)
.Select(e => e)
.ToList();
List <SalaryGrantdetailsModel> list2 = new List <SalaryGrantdetailsModel>();
foreach (SalaryGrantdetails item in list)
{
SalaryGrantdetailsModel sm = new SalaryGrantdetailsModel()
{
Id = item.Id,
Salarygrantid = item.Salarygrantid,
Humanid = item.Humanid,
Humanname = item.Humanname,
Bounssum = item.Bounssum,
Salesum = item.Salesum,
Deductsum = item.Deductsum,
Salarystandardsum = item.Salarystandardsum,
Salarypaidsum = item.Salarypaidsum
};
list2.Add(sm);
}
return(list2);
}
/// <summary>
/// 薪酬发放登记点击提交的方法
/// </summary>
/// <returns></returns>
public ActionResult xg()
{
SalaryGrantModel sg = new SalaryGrantModel();
sg.Firstkindid = Request["Fid"];
sg.Secondkindid = Request["Seid"];
sg.Thirdkindid = Request["Thid"];
sg.Register = Request["Register"];
sg.Registtime = Convert.ToDateTime(Request["Registtime"]);
sg.Checker = Request["Checker"];
sg.Checktime = DateTime.Now;
sg.Checkstatus = 2;
int r1 = isb.SalaryGrantUpdate(sg);
string arry = Request["arry"];
List <Dictionary <string, object> > sdm = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(arry);
int r2 = 0;
foreach (var item in sdm)
{
SalaryGrantdetailsModel sm = new SalaryGrantdetailsModel();
sm.Id = int.Parse(item["Id"].ToString());
sm.Salarygrantid = item["SalaryId"].ToString();
sm.Humanid = item["HumanId"].ToString();
sm.Humanname = item["HumanName"].ToString();
object ass = item["Bounssum"];
sm.Bounssum = item["Bounssum"] == null || item["Bounssum"] == ""? sm.Bounssum: Convert.ToDecimal(item["Bounssum"]);
sm.Salesum = item["Salesum"] == null || item["Salesum"] == "" ? sm.Salesum : Convert.ToDecimal(item["Salesum"]);
sm.Deductsum = item["Deductsum"] == null || item["Deductsum"] == "" ? sm.Deductsum : Convert.ToDecimal(item["Deductsum"]);
sm.Salarypaidsum = item["Salarypaidsum"] == null || item["Salarypaidsum"] == "" ? sm.Salarypaidsum : Convert.ToDecimal(item["Salarypaidsum"]);
HumanFileModel hf = new HumanFileModel();
hf.Id = Convert.ToInt32(item["Id"]);
ihb.HumanFileUpdate1(hf);
//判断薪酬发放表是否添加过这条数据
if (isb.SelectPDSID(sm.Salarygrantid, sm.Humanid) > 0)
{
r2++;
}
else
{
if (igb.SalaryGrantdetailsAdd(sm) > 0)
{
r2++;
}
}
}
string flag = "false";
if (r1 > 0 && r2 == sdm.Count)
{
flag = "true";
}
return(Content(flag));
}
public int SalaryGrantdetailsDelete(SalaryGrantdetailsModel ck)
{
SalaryGrantdetails cmj = new SalaryGrantdetails();
cmj.Salarygrantid = ck.Salarygrantid;
cmj.Humanid = ck.Humanid;
cmj.Humanname = ck.Humanname;
cmj.Bounssum = ck.Bounssum;
cmj.Salesum = ck.Salesum;
cmj.Deductsum = ck.Deductsum;
cmj.Salarystandardsum = ck.Salarystandardsum;
cmj.Salarypaidsum = ck.Salarypaidsum;
cmj.Id = ck.Id;
return(Delete(cmj));
}
public int SalaryGrantdetailsUpdate(SalaryGrantdetailsModel ck)
{
MyDbContext db = CreateContext();
int list = db.Database.ExecuteSqlCommand(@"update dbo.SalaryGrantdetails set Bounssum={0},Salesum={1},Deductsum={2},Salarypaidsum={3} where Id ={4}", ck.Bounssum, ck.Salesum, ck.Deductsum, ck.Salarypaidsum, ck.Id);
return(list);
//SalaryGrantdetails cmj = new SalaryGrantdetails();
//cmj.Id = ck.Id;
//cmj.Salarygrantid = ck.Salarygrantid;
//cmj.Humanid = ck.Humanid;
//cmj.Humanname = ck.Humanname;
//cmj.Bounssum = ck.Bounssum;
//cmj.Salesum = ck.Salesum;
//cmj.Deductsum = ck.Deductsum;
//cmj.Salarystandardsum = ck.Salarystandardsum;
//cmj.Salarypaidsum = ck.Salarypaidsum;
//return Update(cmj);
}
public List <SalaryGrantdetailsModel> SalaryGrantdetailsSelect()
{
List <SalaryGrantdetails> list = Select();
List <SalaryGrantdetailsModel> list2 = new List <SalaryGrantdetailsModel>();
foreach (SalaryGrantdetails item in list)
{
SalaryGrantdetailsModel ckm = new SalaryGrantdetailsModel()
{
Id = item.Id,
Salarygrantid = item.Salarygrantid,
Humanid = item.Humanid,
Humanname = item.Humanname,
Bounssum = item.Bounssum,
Salesum = item.Salesum,
Deductsum = item.Deductsum,
Salarystandardsum = item.Salarystandardsum,
Salarypaidsum = item.Salarypaidsum
};
list2.Add(ckm);
}
return(list2);
}
/// <summary>
/// 薪酬发放复核点击提交的方法
/// </summary>
/// <returns></returns>
public ActionResult xg2()
{
SalaryGrantModel sg = new SalaryGrantModel();
sg.Id = Convert.ToInt32(Request["Id"]);
sg.Register = Request["Register"];
sg.Registtime = DateTime.Now;
sg.Checker = Request["Checker"];
sg.Checktime = Convert.ToDateTime(Request["Checktime"]);
sg.Checkstatus = 3;
int r1 = isb.SalaryGrantUpdate2(sg);
string arry = Request["arry"];
List <Dictionary <string, object> > sdm = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(arry);
int r2 = 0;
foreach (var item in sdm)
{
SalaryGrantdetailsModel sm = new SalaryGrantdetailsModel();
sm.Id = int.Parse(item["Id"].ToString());
sm.Bounssum = item["Bounssum"] == null || item["Bounssum"] == "" ? sm.Bounssum : Convert.ToDecimal(item["Bounssum"]);
sm.Salesum = item["Salesum"] == null || item["Salesum"] == "" ? sm.Salesum : Convert.ToDecimal(item["Salesum"]);
sm.Deductsum = item["Deductsum"] == null || item["Deductsum"] == "" ? sm.Deductsum : Convert.ToDecimal(item["Deductsum"]);
sm.Salarypaidsum = item["Salarypaidsum"] == null || item["Salarypaidsum"] == "" ? sm.Salarypaidsum : Convert.ToDecimal(item["Salarypaidsum"]);
if (igb.SalaryGrantdetailsUpdate(sm) > 0)
{
r2++;
}
}
string flag = "false";
if (r1 > 0 && r2 == sdm.Count)
{
flag = "true";
}
return(Content(flag));
}
public int SalaryGrantdetailsUpdate(SalaryGrantdetailsModel ck)
{
return(igd.SalaryGrantdetailsUpdate(ck));
}
public int SalaryGrantdetailsAdd(SalaryGrantdetailsModel ck)
{
return(igd.SalaryGrantdetailsAdd(ck));
}
