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 bool CheckGrantWage(string wgDate, string rowId)
{
WGJG01_Template wt1 = DBSession.IWGJG01_TemplateDAL.Select(s => s.RowID == rowId).FirstOrDefault();
if (wt1 == null)
{
return(false);
}
DateTime?dt = DateTime.ParseExact(wgDate, "yyyy-MM-dd", new System.Globalization.CultureInfo("zh-CN"));
WGJG01 wg = DBSession.IWGJG01DAL.Select(s => s.ModelID == rowId && s.WGJG0103 == wt1.WGJG0103 && s.WGJG0107 == dt).FirstOrDefault();
if (null != wg)
{
return(true);
}
return(false);
}
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));
}
public int EditWGJG01(WGJG01_Template model)
{
return(Modify(model, "WGJG0101", "WGJG0103", "WGJGDAY", "WGJG0104", "WGJG0203"));
}
