//public List<SalaryGrantModel> SalaryGrantSelectEJ() //{ // string sql = "select * from dbo.SalaryGrant where Secondkindname!='' and Checkstatus=1"; // DataTable dt = DBHelper.select(sql); // List<SalaryGrantModel> list2 = new List<SalaryGrantModel>(); // foreach (DataRow item in dt.Rows) // { // SalaryGrantModel sm = new SalaryGrantModel() // { // Id = (int)item["Id"], // Salarygrantid = item["Salarygrantid"].ToString(), // Salarystandardid = item["Salarystandardid"].ToString(), // Firstkindid = item["Firstkindid"].ToString(), // Firstkindname = item["Firstkindname"].ToString(), // Secondkindid = item["Secondkindid"].ToString(), // Secondkindname = item["Secondkindname"].ToString(), // Thirdkindid = item["Thirdkindid"].ToString(), // Thirdkindname = item["Thirdkindname"].ToString(), // Humanamount = (int)item["Humanamount"], // Salarystandardsum = (decimal)item["Salarystandardsum"], // Salarypaidsum = (decimal)item["Salarypaidsum"], // Register = item["Register"].ToString(), // Registtime = (DateTime)item["Registtime"] // }; // list2.Add(sm); // } // return list2; //} public List <SalaryGrantModel> SalaryGrantSelectEJA(string zz) { string sql = string.Format("select * from dbo.SalaryGrant where '{0}'!='' and Checkstatus=1", zz); DataTable dt = DBHelper.select(sql); List <SalaryGrantModel> list2 = new List <SalaryGrantModel>(); foreach (DataRow item in dt.Rows) { SalaryGrantModel sm = new SalaryGrantModel() { Id = (int)item["Id"], Salarygrantid = item["Salarygrantid"].ToString(), Salarystandardid = item["Salarystandardid"].ToString(), Firstkindid = item["Firstkindid"].ToString(), Firstkindname = item["Firstkindname"].ToString(), Secondkindid = item["Secondkindid"].ToString(), Secondkindname = item["Secondkindname"].ToString(), Thirdkindid = item["Thirdkindid"].ToString(), Thirdkindname = item["Thirdkindname"].ToString(), Humanamount = (int)item["Humanamount"], Salarystandardsum = (decimal)item["Salarystandardsum"], Salarypaidsum = (decimal)item["Salarypaidsum"], Register = item["Register"].ToString(), Registtime = (DateTime)item["Registtime"] }; list2.Add(sm); } return(list2); }
/// <summary> /// 薪酬发放登记 /// </summary> /// <param name="id"></param> /// <param name="sid"></param> /// <param name="Humanamount"></param> /// <param name="Salarypaidsum"></param> /// <param name="Salarystandardsum"></param> /// <param name="Firstkindid"></param> /// <param name="Secondkindid"></param> /// <param name="Thirdkindid"></param> /// <param name="Thirdkindname"></param> /// <param name="Firstkindname"></param> /// <param name="Secondkindname"></param> /// <returns></returns> public ActionResult Commit(string id, int sid, int Humanamount, decimal Salarypaidsum, decimal Salarystandardsum, string Firstkindid, string Secondkindid, string Thirdkindid, string Thirdkindname, string Firstkindname, string Secondkindname) { SalaryGrantModel sg = new SalaryGrantModel(); sg.Salarygrantid = id; sg.Firstkindid = Firstkindid; sg.Firstkindname = Firstkindname; sg.Secondkindid = Secondkindid; sg.Secondkindname = Secondkindname; sg.Thirdkindid = Thirdkindid; sg.Thirdkindname = Thirdkindname; sg.Humanamount = Humanamount; sg.Salarypaidsum = Salarystandardsum; sg.Salarystandardsum = Salarypaidsum; int pd = isb.SelectPD(Firstkindid, Secondkindid, Thirdkindid); if (pd > 0) { } else { int i = isb.SalaryGrantAdd(sg); } ViewBag.Humanamount = Humanamount; ViewBag.Firstkindid = Firstkindid; ViewBag.Secondkindid = Secondkindid; ViewBag.Thirdkindid = Thirdkindid; ViewBag.id = id; ViewBag.sid = sid; return(View()); }
public List <SalaryGrantModel> SalaryGrantSelect() { List <SalaryGrant> list = Select(); List <SalaryGrantModel> list2 = new List <SalaryGrantModel>(); foreach (SalaryGrant item in list) { SalaryGrantModel ckm = new SalaryGrantModel() { Id = item.Id, Salarygrantid = item.Salarygrantid, Salarystandardid = item.Salarystandardid, Firstkindid = item.Firstkindid, Firstkindname = item.Firstkindname, Secondkindid = item.Secondkindid, Secondkindname = item.Secondkindname, Thirdkindid = item.Thirdkindid, Thirdkindname = item.Thirdkindname, Humanamount = item.Humanamount, Salarystandardsum = item.Salarystandardsum, Salarypaidsum = item.Salarypaidsum, Register = item.Register, Registtime = item.Registtime, Checker = item.Checker, Checktime = item.Checktime, Checkstatus = item.Checkstatus }; list2.Add(ckm); } return(list2); }
public int SalaryGrantUpdate2(SalaryGrantModel ck) { MyDbContext db = CreateContext(); string sql = string.Format(@"update dbo.SalaryGrant set Salarypaidsum='{0}',Register='{1}',Registtime='{2}',Checker='{3}', Checktime = '{4}',Checkstatus='{5}' where Id='{6}' ", ck.Salarypaidsum, ck.Register, ck.Registtime, ck.Checker, ck.Checktime, ck.Checkstatus, ck.Id); int list = db.Database.ExecuteSqlCommand(sql); return(list); }
public List <SalaryGrantModel> SalaryGrantFYW(int currentPage, int pageSize, out int rows, string xcid, string gjz, string year, string months) { string sql = "select * from dbo.SalaryGrant where 1=1"; if (xcid != null && xcid != "") { sql += string.Format(" and Salarygrantid='{0}'", xcid); } if (gjz != null && gjz != "") { sql += string.Format(" and Register like '%{0}%'", gjz); } if (year != null && year != "" && gjz != months && months != "") { if (year != "全部") { sql += string.Format(" and datepart(YEAR,Registtime)='{0}'", year); } if (months != "全部") { sql += string.Format(" and datepart(MONTH,Registtime)='{0}'", months); } } var list = CreateContext().SalaryGrant.SqlQuery(sql).OrderBy(e => e.Id).ToList(); rows = list.Count(); var data = list.Skip((currentPage - 1) * pageSize).Take(pageSize).ToList(); List <SalaryGrantModel> list2 = new List <SalaryGrantModel>(); foreach (var p in data) { SalaryGrantModel pp = new SalaryGrantModel() { Id = p.Id, Salarygrantid = p.Salarygrantid, Salarystandardid = p.Salarystandardid, Firstkindid = p.Firstkindid, Firstkindname = p.Firstkindname, Secondkindid = p.Secondkindid, Secondkindname = p.Secondkindname, Thirdkindid = p.Thirdkindid, Thirdkindname = p.Thirdkindname, Humanamount = p.Humanamount, Salarystandardsum = p.Salarystandardsum, Salarypaidsum = p.Salarypaidsum, Register = p.Register, Registtime = p.Registtime, Checker = p.Checker, Checktime = p.Checktime, Checkstatus = p.Checkstatus }; list2.Add(pp); } 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 List<SalaryGrantModel> SalaryGrantSelectSJ() //{ // string sql = "select * from dbo.SalaryGrant where Thirdkindname!='' and Checkstatus=1"; // DataTable dt = DBHelper.select(sql); // List<SalaryGrantModel> list2 = new List<SalaryGrantModel>(); // foreach (DataRow item in dt.Rows) // { // SalaryGrantModel sm = new SalaryGrantModel() // { // Id = (int)item["Id"], // Salarygrantid = item["Salarygrantid"].ToString(), // Salarystandardid = item["Salarystandardid"].ToString(), // Firstkindid = item["Firstkindid"].ToString(), // Firstkindname = item["Firstkindname"].ToString(), // Secondkindid = item["Secondkindid"].ToString(), // Secondkindname = item["Secondkindname"].ToString(), // Thirdkindid = item["Thirdkindid"].ToString(), // Thirdkindname = item["Thirdkindname"].ToString(), // Humanamount = (int)item["Humanamount"], // Salarystandardsum = (decimal)item["Salarystandardsum"], // Salarypaidsum = (decimal)item["Salarypaidsum"], // Register = item["Register"].ToString(), // Registtime = (DateTime)item["Registtime"] // }; // list2.Add(sm); // } // return list2; //} //public List<SalaryGrantModel> SalaryGrantSelectYJ() //{ // string sql = "select * from dbo.SalaryGrant where Firstkindname!='' and Checkstatus=1"; // DataTable dt = DBHelper.select(sql); // List<SalaryGrantModel> list2 = new List<SalaryGrantModel>(); // foreach (DataRow item in dt.Rows) // { // SalaryGrantModel sm = new SalaryGrantModel(); // sm.Id = (int)item["Id"]; // sm.Salarygrantid = item["Salarygrantid"].ToString(); // sm.Salarystandardid = item["Salarystandardid"].ToString(); // sm.Firstkindid = item["Firstkindid"].ToString(); // sm.Firstkindname = item["Firstkindname"].ToString(); // sm.Secondkindid = item["Secondkindid"].ToString(); // sm.Secondkindname = item["Secondkindname"].ToString(); // sm.Thirdkindid = item["Thirdkindid"].ToString(); // sm.Thirdkindname = item["Thirdkindname"].ToString(); // sm.Humanamount = (int)item["Humanamount"]; // sm.Salarystandardsum = (decimal)item["Salarystandardsum"]; // sm.Salarypaidsum = (decimal)item["Salarypaidsum"]; // sm.Register = item["Register"].ToString(); // sm.Registtime = (DateTime)item["Registtime"]; // list2.Add(sm); // } // return list2; //} public int SalaryGrantUpdate(SalaryGrantModel ck) { MyDbContext db = CreateContext(); string sql = string.Format(@"update dbo.SalaryGrant set Salarypaidsum='{0}',Register='{1}',Registtime='{2}',Checker='{3}', Checktime = '{4}',Checkstatus='{5}' ", ck.Salarypaidsum, ck.Register, ck.Registtime, ck.Checker, ck.Checktime, ck.Checkstatus); if (ck.Firstkindid != null && ck.Secondkindid == "") { sql += string.Format(" where Firstkindid='{0}'", ck.Firstkindid); } else { sql += string.Format(" where Secondkindid='{0}'", ck.Secondkindid); } int list = db.Database.ExecuteSqlCommand(sql); return(list); }
public int SalaryGrantDelete(SalaryGrantModel ck) { SalaryGrant cmj = new SalaryGrant(); cmj.Salarygrantid = ck.Salarygrantid; cmj.Salarystandardid = ck.Salarystandardid; cmj.Firstkindid = ck.Firstkindid; cmj.Firstkindname = ck.Firstkindname; cmj.Secondkindid = ck.Secondkindid; cmj.Secondkindname = ck.Secondkindname; cmj.Thirdkindid = ck.Thirdkindid; cmj.Thirdkindname = ck.Thirdkindname; cmj.Humanamount = ck.Humanamount; cmj.Salarystandardsum = ck.Salarystandardsum; cmj.Salarypaidsum = ck.Salarypaidsum; cmj.Register = ck.Register; cmj.Registtime = ck.Registtime; cmj.Checker = ck.Checker; cmj.Checktime = ck.Checktime; cmj.Checkstatus = ck.Checkstatus; cmj.Id = ck.Id; return(Delete(cmj)); }
/// <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 List <SalaryGrantModel> SalaryGrantFY(int currentPage, int pageSize, out int rows) { string sql = "select * from dbo.SalaryGrant where Checkstatus=2"; var list = CreateContext().SalaryGrant.SqlQuery(sql).OrderBy(e => e.Id).ToList(); rows = list.Count(); var data = list.Skip((currentPage - 1) * pageSize).Take(pageSize).ToList(); List <SalaryGrantModel> list2 = new List <SalaryGrantModel>(); foreach (var p in data) { SalaryGrantModel pp = new SalaryGrantModel() { Id = p.Id, Salarygrantid = p.Salarygrantid, Salarystandardid = p.Salarystandardid, Firstkindid = p.Firstkindid, Firstkindname = p.Firstkindname, Secondkindid = p.Secondkindid, Secondkindname = p.Secondkindname, Thirdkindid = p.Thirdkindid, Thirdkindname = p.Thirdkindname, Humanamount = p.Humanamount, Salarystandardsum = p.Salarystandardsum, Salarypaidsum = p.Salarypaidsum, Register = p.Register, Registtime = p.Registtime, Checker = p.Checker, Checktime = p.Checktime, Checkstatus = p.Checkstatus }; list2.Add(pp); } return(list2); }
public List <SalaryGrantModel> SalaryGrantSelectBy(int id) { MyDbContext db = CreateContext(); List <SalaryGrant> list = db.SalaryGrant.AsNoTracking() // List<SalaryGrant> list = db.SalaryGrant.SqlQuery().AsNoTracking() .Where(e => e.Id == id) .Select(e => e) .ToList(); List <SalaryGrantModel> list2 = new List <SalaryGrantModel>(); foreach (SalaryGrant item in list) { SalaryGrantModel sm = new SalaryGrantModel() { Id = item.Id, Salarygrantid = item.Salarygrantid, Salarystandardid = item.Salarystandardid, Firstkindid = item.Firstkindid, Firstkindname = item.Firstkindname, Secondkindid = item.Secondkindid, Secondkindname = item.Secondkindname, Thirdkindid = item.Thirdkindid, Thirdkindname = item.Thirdkindname, Humanamount = item.Humanamount, Salarystandardsum = item.Salarystandardsum, Salarypaidsum = item.Salarypaidsum, Register = item.Register, Registtime = item.Registtime, Checker = item.Checker, Checktime = item.Checktime, Checkstatus = item.Checkstatus }; list2.Add(sm); } return(list2); }
public int SalaryGrantUpdate2(SalaryGrantModel ck) { return(icd.SalaryGrantUpdate2(ck)); }
public int SalaryGrantDelete(SalaryGrantModel ck) { return(icd.SalaryGrantDelete(ck)); }
public int SalaryGrantAdd(SalaryGrantModel ck) { return(icd.SalaryGrantAdd(ck)); }