/// <summary>
/// 薪酬标准登记点击提交的方法
/// </summary>
/// <returns></returns>
public ActionResult xg()
{
SalaryStandardModel sg = new SalaryStandardModel();
sg.Id = Convert.ToInt32(Request["Id"]);
sg.Salarysum = Request["Salarysum"] == null || Request["Salarysum"] == "" ? sg.Salarysum : Convert.ToDecimal(Request["Salarysum"]);
sg.Checker = Request["Checker"];
sg.Checktime = Convert.ToDateTime(Request["Checktime"]);
sg.Checkcomment = Request["Checkcomment"];
int r1 = isb.SalaryStandardUpdate(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)
{
SalaryStandardDetailsModel sm = new SalaryStandardDetailsModel();
sm.Id = int.Parse(item["Id"].ToString());
sm.Salary = item["money"] == null || item["money"] == "" ? sm.Salary : Convert.ToDecimal(item["money"]);
if (isd.SalaryStandardDetailsUpdate(sm) > 0)
{
r2++;
}
}
string flag = "false";
if (r1 > 0 && r2 == sdm.Count)
{
flag = "true";
}
return(Content(flag));
}
public int SalaryStandardDetailsUpdate(SalaryStandardDetailsModel ck)
{
MyDbContext db = CreateContext();
// int list = db.Database.ExecuteSqlCommand(sql);
string sql = string.Format(@"update dbo.SalaryStandardDetails set Salary={0} where Id ={1}", ck.Salary, ck.Id);
int list = db.Database.ExecuteSqlCommand(sql);
return(list);
}
public int SalaryStandardDetailsDelete(SalaryStandardDetailsModel ck)
{
SalaryStandardDetails cmj = new SalaryStandardDetails();
cmj.Standardid = ck.Standardid;
cmj.Standardname = ck.Standardname;
cmj.Itemid = ck.Itemid;
cmj.Itemname = ck.Itemname;
cmj.Salary = ck.Salary;
cmj.Id = ck.Id;
return(Delete(cmj));
}
public List <SalaryStandardDetailsModel> SalaryStandardDetailsSelect()
{
List <SalaryStandardDetails> list = Select();
List <SalaryStandardDetailsModel> list2 = new List <SalaryStandardDetailsModel>();
foreach (SalaryStandardDetails item in list)
{
SalaryStandardDetailsModel ckm = new SalaryStandardDetailsModel()
{
Id = item.Id,
Standardid = item.Standardid,
Standardname = item.Standardname,
Itemid = item.Itemid,
Itemname = item.Itemname,
Salary = item.Salary
};
list2.Add(ckm);
}
return(list2);
}
public List <SalaryStandardDetailsModel> SalaryGrantdetailsSelectGZXQ(string id)
{
// string sql = "select * from dbo.SalaryGrant where Firstkindname!=''";\
string sql = string.Format(@"select * from dbo.SalaryStandardDetails where Standardid='{0}'", id);
DataTable dt = DBHelper.select(sql);
List <SalaryStandardDetailsModel> list2 = new List <SalaryStandardDetailsModel>();
foreach (DataRow item in dt.Rows)
{
SalaryStandardDetailsModel sm = new SalaryStandardDetailsModel();
sm.Id = (int)item["Id"];
//Id, , , , ,
sm.Standardid = item["Standardid"].ToString();
sm.Standardname = item["Standardname"].ToString();
sm.Itemid = (int)item["Itemid"];
sm.Itemname = item["Itemname"].ToString();
sm.Salary = (decimal)item["Salary"];
list2.Add(sm);
}
return(list2);
}
public ActionResult Add()
{
//基本信息
SalaryStandardModel ssm = new SalaryStandardModel();
ssm.Standardid = Request["Standardid"];
ssm.Standardname = Request["Standardname"];
ssm.Salarysum = Request["Salarysum"] == null || Request["Salarysum"] == "" ? ssm.Salarysum : Convert.ToDecimal(Request["Salarysum"]);
ssm.Designer = Request["Designer"];
ssm.Register = Request["Register"];
ssm.Registtime = DateTime.Parse(Request["Registtime"]);
ssm.Remark = Request["Remark"];
int r1 = isb.SalaryStandardAdd(ssm);
//详情信息
string arry = Request["arry"];
List <Dictionary <string, object> > sdm = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(arry);
int r2 = 0;
foreach (var item in sdm)
{
SalaryStandardDetailsModel sd = new SalaryStandardDetailsModel();
sd.Itemid = int.Parse(item["id"].ToString());
sd.Itemname = item["names"].ToString();
sd.Standardid = Request["Standardid"];
sd.Standardname = Request["Standardname"];
sd.Salary = item["money"] == null || item["money"] == "" ? sd.Salary : Convert.ToDecimal(item["money"]);
if (isd.SalaryStandardDetailsAdd(sd) > 0)
{
r2++;
}
}
string flag = "false";
if (r1 > 0 && r2 == sdm.Count)
{
flag = "true";
}
return(Content(flag));
}
public List <SalaryStandardDetailsModel> SalaryGrantdetailsSelectSID(string id)
{
MyDbContext db = CreateContext();
List <SalaryStandardDetails> list = db.SalaryStandardDetails.AsNoTracking()
.Where(e => e.Standardid == id)
.Select(e => e)
.ToList();
List <SalaryStandardDetailsModel> list2 = new List <SalaryStandardDetailsModel>();
foreach (SalaryStandardDetails item in list)
{
SalaryStandardDetailsModel ckm = new SalaryStandardDetailsModel()
{
Id = item.Id,
Standardid = item.Standardid,
Standardname = item.Standardname,
Itemid = item.Itemid,
Itemname = item.Itemname,
Salary = item.Salary
};
list2.Add(ckm);
}
return(list2);
}
public int SalaryStandardDetailsUpdate(SalaryStandardDetailsModel ck)
{
return(icd.SalaryStandardDetailsUpdate(ck));
}
public int SalaryStandardDetailsAdd(SalaryStandardDetailsModel ck)
{
return(icd.SalaryStandardDetailsAdd(ck));
}
