public bool CreateDataByPsersons(string psersons, string rowid) { if (string.IsNullOrEmpty(psersons)) { return(false); } List <string> liStr = new List <string>(psersons.Split(',')); //1:删除数据 DBSession.IWGJG02_TemplateDAL.DeletePersonsData(liStr, rowid); //2:添加数据 WGJG01_Template wg1 = DBSession.IWGJG01_TemplateDAL.Select(s => s.RowID == rowid).FirstOrDefault(); List <A01> list = DBSession.IA01DAL.GetPeronsBySel(liStr, wg1.UnitID); foreach (A01 item in list) { Add(new WGJG02_Template() { RowID = EncryptHelper.Md5Encryption(OnlyCodeHelper.CreateOnlyCode()), WGJG01RowID = rowid, PersonSalaryID = EncryptHelper.Md5Encryption(OnlyCodeHelper.CreateOnlyCode()), PersonID = item.PersonID, A0101 = item.A0101, A0177 = item.A0177, B0002 = "",//item.B0002, UnitID = item.UnitID, E0386 = item.E0386, WGJG0203 = wg1?.WGJG0203, WGJG0204 = item.A0178, //工资 WGJG0207 = item.A0178, WGJG0208 = item.A0178 }); } return(true); }
/// <summary> /// 导入数据 /// </summary> /// <param name="dt"></param> /// <returns></returns> public bool ImportPersonData(DataTable dt, string UnitID, string RowID) { if (null == dt || dt.Rows.Count <= 0) { return(false); } List <A01> a01 = DBSession.IA01DAL.Select(s => s.UnitID.Equals(UnitID)); if (null == a01 || a01.Count <= 0) { return(false); } //删除之前的模板数据 DBSession.IWGJG02_TemplateDAL.Delete(s => s.WGJG01RowID.Equals(RowID)); WGJG01_Template wg1 = DBSession.IWGJG01_TemplateDAL.Select(s => s.RowID == RowID).FirstOrDefault(); foreach (DataRow item in dt.Rows) { A01 temp = a01.Where(s => s.PersonID.Equals(item["F5"])).FirstOrDefault(); if (null == temp) { continue; } decimal W0178 = 0, //应发 A0178 = 0; //实发 try{ W0178 = Convert.ToDecimal(item["F3"]); A0178 = Convert.ToDecimal(item["F4"]); } catch { W0178 = 0; A0178 = 0; } Add(new WGJG02_Template() { RowID = EncryptHelper.Md5Encryption(OnlyCodeHelper.CreateOnlyCode()), WGJG01RowID = RowID, PersonSalaryID = EncryptHelper.Md5Encryption(OnlyCodeHelper.CreateOnlyCode()), PersonID = temp.PersonID, A0101 = temp.A0101, A0177 = temp.A0177, B0002 = "",//item.B0002, UnitID = temp.UnitID, E0386 = temp.E0386, WGJG0203 = wg1?.WGJG0203, WGJG0204 = temp.A0178, //工资 WGJG0207 = W0178, //应发 WGJG0208 = A0178 //实发 }); } return(true); }
public ActionResult AddOwnPany(HCQ2_Model.WGJG_GRZX model) { if (!ModelState.IsValid) { return(operateContext.RedirectAjax(1, "数据正确性验证失败~", null, null)); } model.RowID = OnlyCodeHelper.CreateOnlyCode(); model.WGJG_GRZX01 = OnlyCodeHelper.CreateIntCode(); model.WGJG_GRZX10 = operateContext.Usr.user_name; model.WGJG_GRZX11 = DateTime.Now; int mark = operateContext.bllSession.WGJG_GRZX.Add(model); if (mark > 0) { return(operateContext.RedirectAjax(0, "添加成功~", null, null)); } return(operateContext.RedirectAjax(1, "添加失败~", null, null)); }
public bool CreateDataByUnit(string rowid) { if (string.IsNullOrEmpty(rowid)) { return(false); } //1:删除数据 Delete(s => s.WGJG01RowID == rowid); //2:重新生成数据 WGJG01_Template wg1 = DBSession.IWGJG01_TemplateDAL.Select(s => s.RowID == rowid).FirstOrDefault(); if (wg1 == null) { return(false); } //3:添加数据 List <A01> list = DBSession.IA01DAL.Select(s => s.UnitID == wg1.UnitID); foreach (A01 item in list) { Add(new WGJG02_Template() { RowID = EncryptHelper.Md5Encryption(OnlyCodeHelper.CreateOnlyCode()), WGJG01RowID = rowid, PersonSalaryID = EncryptHelper.Md5Encryption(OnlyCodeHelper.CreateOnlyCode()), PersonID = item.PersonID, A0101 = item.A0101, A0177 = item.A0177, B0002 = "",//item.B0002, UnitID = item.UnitID, E0386 = item.E0386, WGJG0203 = wg1.WGJG0203, WGJG0204 = item.A0178, //工资 WGJG0207 = item.A0178, WGJG0208 = item.A0178 }); } return(true); }
public int AddWGJG01(WGJG01_Template model) { B01 b01 = DBSession.IB01DAL.Select(s => s.UnitID == model.UnitID).FirstOrDefault(); if (b01 == null) { return(0); } WGJG01_Template wg = new WGJG01_Template() { B0001 = (b01.KeyParent.Equals(".")) ? model.UnitID : b01.KeyParent, B0002 = "",//(model.UnitID.Length == 3) ? "" : model.UnitID, UnitID = model.UnitID, RowID = EncryptHelper.Md5Encryption(OnlyCodeHelper.CreateOnlyCode()), WGJG0101 = model.WGJG0101, WGJG0103 = model.WGJG0103, WGJG0104 = model.WGJG0104, WGJG0106 = model.WGJG0106, WGJG0203 = model.WGJG0203, WGJGDAY = model.WGJGDAY }; return(Add(wg)); }