public List<T_HR_PENSIONDETAIL> ImportClockInRdListFromExcelForShow(UploadFileModel UploadFile, Dictionary<string, string> paras, ref string strMsg)
{
List<T_HR_PENSIONDETAIL> ListResult = new List<T_HR_PENSIONDETAIL>();
try
{
Tracer.Debug("import start" + paras.Count.ToString());
string strPath = string.Empty;
SaveFileReturnFilePath(UploadFile, out strPath);
string strPhysicalPath = HttpContext.Current.Server.MapPath(strPath);
using (PensionDetailBLL bll = new PensionDetailBLL())
{
ListResult = bll.ImportPensionByImportExcelForShow(strPhysicalPath, paras, ref strMsg);
}
Tracer.Debug("import sucess");
}
catch (Exception ex)
{
Tracer.Debug("ImportClockInRdListFromExcelWS:" + ex.Message);
}
return ListResult;
}
public bool BatchAddPensionDetail(List<T_HR_PENSIONDETAIL> listPension, Dictionary<string, string> paras, ref string StrMsg)
{
bool IsResult = false;
try
{
Tracer.Debug("导入社保的数量：" + listPension.Count().ToString());
Tracer.Debug("开始导入社保时间：" + System.DateTime.Now.ToString());
using (PensionDetailBLL bll = new PensionDetailBLL())
{
IsResult = bll.BatchAddPensionDetail(listPension, paras, ref StrMsg);
}
Tracer.Debug("import end");
Tracer.Debug("社保导入结束时间：" + System.DateTime.Now.ToString());
}
catch (Exception ex)
{
Tracer.Debug("ImportClockInRdListFromExcelWS:" + ex.Message);
}
return IsResult;
}
public void ImportClockInRdListFromExcel(UploadFileModel UploadFile, Dictionary<string, string> paras, ref string strMsg)
{
try
{
Tracer.Debug("import start" + paras.Count.ToString());
string strPath = string.Empty;
SaveFileReturnFilePath(UploadFile, out strPath);
string strPhysicalPath = HttpContext.Current.Server.MapPath(strPath);
using (PensionDetailBLL bll = new PensionDetailBLL())
{
bll.ImportPensionByImportExcel(strPhysicalPath, paras, ref strMsg);
}
Tracer.Debug("import sucess");
}
catch (Exception ex)
{
Tracer.Debug("ImportClockInRdListFromExcelWS:" + ex.Message);
}
}
public bool PensionDetailDelete(string[] pensionDetailIDs)
{
using (PensionDetailBLL bll = new PensionDetailBLL())
{
int rslt = bll.PensionDetailDelete(pensionDetailIDs);
return (rslt > 0);
}
}
public byte[] ExportPensionDetailReport(string sort, string filterString, object[] paras, string userID, string CompanyID, string StrYear, string StrMonth)
{
using (PensionDetailBLL bll = new PensionDetailBLL())
{
return bll.ExportPensionDetailReport(sort, filterString, paras, userID, CompanyID, StrYear, StrMonth);
}
}
public List<T_HR_PENSIONDETAIL> PensionDetailPaging(int pageIndex, int pageSize, string sort, string filterString, object[] paras, ref int pageCount, string userID)
{
using (PensionDetailBLL bll = new PensionDetailBLL())
{
IQueryable<T_HR_PENSIONDETAIL> q = bll.PensionDetailPaging(pageIndex, pageSize, sort, filterString, paras, ref pageCount, userID);
return q.Count() > 0 ? q.ToList() : null;
}
}
public byte[] ExportEmployeePensionReports( string sort, string filterString, IList<object> paras, string userID,string CompanyID,DateTime Dt)
{
using (PensionDetailBLL bll = new PensionDetailBLL())
{
return bll.ExportEmployeePensionReports(sort, filterString, paras, userID, CompanyID,Dt);
}
}
