public SalaryBiaoZhunModel SalaryBiaoZhunWhere(int Id)
{
MyDbContext md = CreateContext();
List <SalaryBiaoZhun> list = md.SalaryBiaoZhun.AsNoTracking()
.Where(e => e.Id == Id)
.Select(e => e).ToList();
SalaryBiaoZhunModel sbzm = null;
foreach (var p in list)
{
sbzm = new SalaryBiaoZhunModel()
{
Id = p.Id,
SBZBeiZhu = p.SBZBeiZhu,
SBZDengJiTime = p.SBZDengJiTime,
SBZDengJiRen = p.SBZDengJiRen,
SalaryChuCai = p.SalaryChuCai,
SalaryChuCaiID = p.SalaryChuCaiID,
SalaryJiaoTong = p.SalaryJiaoTong,
SalaryJiaoTongID = p.SalaryJiaoTongID,
SBZChuCaiJinE = p.SBZChuCaiJinE,
SBZJiaoTongJinE = p.SBZJiaoTongJinE,
SBZBianHao = p.SBZBianHao,
SBZName = p.SBZName,
SBZZhiDingRen = p.SBZZhiDingRen,
SBZZongE = p.SBZZongE,
SBZFuHeRen = p.SBZFuHeRen,
SBZFuHeTime = p.SBZFuHeTime,
SBZFuHeYiJian = p.SBZFuHeYiJian
};
}
return(sbzm);
}
public ActionResult InsertSalaryBiaoZhunFuHeUpdate(int Id, string SBZBianHao, string SBZName, double SBZZongE, string SBZZhiDingRen, string SBZFuHeRen, string SBZFuHeTime, string SBZFuHeYiJian, string SalaryChuCai, int SalaryChuCaiID, string SalaryJiaoTong, int SalaryJiaoTongID, double SBZChuCaiJinE, double SBZJiaoTongJinE)
{
SalaryBiaoZhunModel list = isbz.SalaryBiaoZhunWhere(Id);
SalaryBiaoZhunModel sbzm = new SalaryBiaoZhunModel()
{
SalaryChuCai = SalaryChuCai,
SalaryChuCaiID = SalaryChuCaiID,
SalaryJiaoTong = SalaryJiaoTong,
SalaryJiaoTongID = SalaryJiaoTongID,
SBZChuCaiJinE = SBZChuCaiJinE,
SBZJiaoTongJinE = SBZJiaoTongJinE,
SBZBeiZhu = list.SBZBeiZhu,
SBZBianHao = list.SBZBianHao,
SBZDengJiRen = list.SBZDengJiRen,
SBZDengJiTime = list.SBZDengJiTime,
SBZName = SBZName,
SBZZhiDingRen = SBZZhiDingRen,
SBZZongE = SBZZongE,
Id = Id,
SBZFuHeRen = SBZFuHeRen,
SBZFuHeTime = SBZFuHeTime,
SBZFuHeYiJian = SBZFuHeYiJian,
SBZBianGengRen = " ",
SBZBianGenTime = " "
};
return(Content(JsonConvert.SerializeObject(isbz.UpdaeSalaryBiaoZhun(sbzm))));
}
public List <SalaryBiaoZhunModel> SelectSalaryBiaoZhun()
{
List <SalaryBiaoZhun> list = Select();
List <SalaryBiaoZhunModel> list2 = new List <SalaryBiaoZhunModel>();
foreach (var p in list)
{
SalaryBiaoZhunModel sbz = new SalaryBiaoZhunModel()
{
Id = p.Id,
SBZBeiZhu = p.SBZBeiZhu,
SBZDengJiTime = p.SBZDengJiTime,
SBZDengJiRen = p.SBZDengJiRen,
SalaryChuCai = p.SalaryChuCai,
SalaryChuCaiID = p.SalaryChuCaiID,
SalaryJiaoTong = p.SalaryJiaoTong,
SalaryJiaoTongID = p.SalaryJiaoTongID,
SBZChuCaiJinE = p.SBZChuCaiJinE,
SBZJiaoTongJinE = p.SBZJiaoTongJinE,
SBZBianHao = p.SBZBianHao,
SBZName = p.SBZName,
SBZZhiDingRen = p.SBZZhiDingRen,
SBZZongE = p.SBZZongE,
SBZFuHeRen = p.SBZFuHeRen,
SBZFuHeTime = p.SBZFuHeTime,
SBZFuHeYiJian = p.SBZFuHeYiJian,
SBZBianGengRen = p.SBZBianGengRen,
SBZBianGenTime = p.SBZBianGenTime
};
list2.Add(sbz);
}
return(list2);
}
public List <SalaryBiaoZhunModel> SalaryBiaoZhunFenYe(int currentPage, int pageSize, out int rows)
{
var list = CreateContext().SalaryBiaoZhun.AsNoTracking().OrderBy(e => e.Id);
rows = list.Count();
var data = list
.Skip((currentPage - 1) * pageSize)
.Take(pageSize)
.ToList();
List <SalaryBiaoZhunModel> list2 = new List <SalaryBiaoZhunModel>();
foreach (var p in data)
{
SalaryBiaoZhunModel e = new SalaryBiaoZhunModel()
{
Id = p.Id,
SBZBeiZhu = p.SBZBeiZhu,
SBZDengJiTime = p.SBZDengJiTime,
SBZDengJiRen = p.SBZDengJiRen,
SalaryChuCai = p.SalaryChuCai,
SalaryChuCaiID = p.SalaryChuCaiID,
SalaryJiaoTong = p.SalaryJiaoTong,
SalaryJiaoTongID = p.SalaryJiaoTongID,
SBZChuCaiJinE = p.SBZChuCaiJinE,
SBZJiaoTongJinE = p.SBZJiaoTongJinE,
SBZBianHao = p.SBZBianHao,
SBZName = p.SBZName,
SBZZhiDingRen = p.SBZZhiDingRen,
SBZZongE = p.SBZZongE
};
list2.Add(e);
}
return(list2);
}
public int UpdaeSalaryBiaoZhun(SalaryBiaoZhunModel p)
{
SalaryBiaoZhun sbz = new SalaryBiaoZhun()
{
Id = p.Id,
SBZBeiZhu = p.SBZBeiZhu,
SBZDengJiTime = p.SBZDengJiTime,
SBZDengJiRen = p.SBZDengJiRen,
SalaryChuCai = p.SalaryChuCai,
SalaryChuCaiID = p.SalaryChuCaiID,
SalaryJiaoTong = p.SalaryJiaoTong,
SalaryJiaoTongID = p.SalaryJiaoTongID,
SBZChuCaiJinE = p.SBZChuCaiJinE,
SBZJiaoTongJinE = p.SBZJiaoTongJinE,
SBZBianHao = p.SBZBianHao,
SBZName = p.SBZName,
SBZZhiDingRen = p.SBZZhiDingRen,
SBZZongE = p.SBZZongE,
SBZFuHeRen = p.SBZFuHeRen,
SBZFuHeTime = p.SBZFuHeTime,
SBZFuHeYiJian = p.SBZFuHeYiJian,
SBZBianGengRen = p.SBZBianGengRen,
SBZBianGenTime = p.SBZBianGenTime
};
return(Update(sbz));
}
public ActionResult InsertSalaryBiaoZhunFuHe(int Id)
{
SalaryBiaoZhunModel list = isbz.SalaryBiaoZhunWhere(Id);
return View(list);
}
public ActionResult UpdateSalaryBiaoZhun(int Id)
{
SalaryBiaoZhunModel list = isbz.SalaryBiaoZhunWhere(Id);
return View(list);
}
public ActionResult InsertSalaryBiaoZhun(string SBZBianHao, string SBZName, double SBZZongE, string SBZZhiDingRen, string SBZDengJiRen, string SBZDengJiTime, string SBZBeiZhu, string SalaryChuCai, int SalaryChuCaiID, string SalaryJiaoTong, int SalaryJiaoTongId, double SBZChuCaiJinE, double SBZJiaoTongJinE)
{
SalaryBiaoZhunModel sbzm = new SalaryBiaoZhunModel()
{
SalaryChuCai = SalaryChuCai,
SalaryChuCaiID = SalaryChuCaiID,
SalaryJiaoTong = SalaryJiaoTong,
SalaryJiaoTongID = SalaryJiaoTongId,
SBZChuCaiJinE = SBZChuCaiJinE,
SBZJiaoTongJinE = SBZJiaoTongJinE,
SBZBeiZhu = SBZBeiZhu,
SBZBianHao = SBZBianHao,
SBZDengJiRen = SBZDengJiRen,
SBZDengJiTime = SBZDengJiTime,
SBZName = SBZName,
SBZZhiDingRen = SBZZhiDingRen,
SBZZongE = SBZZongE
};
return Content(JsonConvert.SerializeObject(isbz.InsertSalaryBiaoZhun(sbzm)));
}
public int InsertSalaryBiaoZhun(SalaryBiaoZhunModel sbzm)
{
SalaryBiaoZhun sbz = new SalaryBiaoZhun()
{
SBZBeiZhu = sbzm.SBZBeiZhu,
SBZDengJiTime = sbzm.SBZDengJiTime,
SBZDengJiRen = sbzm.SBZDengJiRen,
SalaryChuCai = sbzm.SalaryChuCai,
SalaryChuCaiID = sbzm.SalaryChuCaiID,
SalaryJiaoTong = sbzm.SalaryJiaoTong,
SalaryJiaoTongID = sbzm.SalaryJiaoTongID,
SBZChuCaiJinE = sbzm.SBZChuCaiJinE,
SBZJiaoTongJinE = sbzm.SBZJiaoTongJinE,
SBZBianHao = sbzm.SBZBianHao,
SBZName = sbzm.SBZName,
SBZZhiDingRen = sbzm.SBZZhiDingRen,
SBZZongE = sbzm.SBZZongE
};
return(Add(sbz));
}
public int UpdaeSalaryBiaoZhun(SalaryBiaoZhunModel sbzm)
{
return(isbz.UpdaeSalaryBiaoZhun(sbzm));
}
public int InsertSalaryBiaoZhun(SalaryBiaoZhunModel sbzm)
{
return(isbz.InsertSalaryBiaoZhun(sbzm));
}
