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)); }