public V_EmployeeAddsumView GetEmployeeAddSumViewByID(string ID)
{
using (EmployeeAddSumBLL bll = new EmployeeAddSumBLL())
{
return bll.GetEmployeeAddSumViewByID(ID);
}
}
public List<T_HR_EMPLOYEEADDSUM> GetEmployeeAddSumWithPaging(int pageIndex, int pageSize, string sort, string filterString, string[] paras, ref int pageCount, DateTime starttime, DateTime endtime, string userID, string CheckState, int orgtype, string orgid)
{
using (EmployeeAddSumBLL bll = new EmployeeAddSumBLL())
{
IQueryable<T_HR_EMPLOYEEADDSUM> q = bll.QueryWithPaging(pageIndex, pageSize, sort, filterString, paras, ref pageCount, starttime, endtime, userID, CheckState, orgtype, orgid);
if (q != null)
{
return q.Count() > 0 ? q.ToList() : null;
}
else
{
return null;
}
}
}
public int EmployeeAddSumByEmployeeIDDelete(string[] employeeIDs, string year, string month)
{
using (EmployeeAddSumBLL bll = new EmployeeAddSumBLL())
{
return bll.EmployeeAddSumByEmployeeIDDelete(employeeIDs, year, month);
}
}
public T_HR_EMPLOYEEADDSUM GetEmployeeAddSumByID(string ID)
{
using (EmployeeAddSumBLL bll = new EmployeeAddSumBLL())
{
return bll.GetEmployeeAddSumByID(ID);
}
}
public bool EmployeeAddSumDelete(string[] IDs)
{
using (EmployeeAddSumBLL bll = new EmployeeAddSumBLL())
{
int rslt = bll.EmployeeAddSumDelete(IDs);
return (rslt > 0);
}
}
public void EmployeeAddSumUpdate(T_HR_EMPLOYEEADDSUM obj)
{
using (EmployeeAddSumBLL bll = new EmployeeAddSumBLL())
{
bll.EmployeeAddSumUpdate(obj);
}
}
public bool EmployeeAddSumLotsofADD(List<T_HR_EMPLOYEEADDSUM> objs)
{
using (EmployeeAddSumBLL bll = new EmployeeAddSumBLL())
{
return bll.EmployeeAddSumLotsofADD(objs);
}
}
public List<T_HR_EMPLOYEEADDSUM> ImportEmployeeAddSumFromExcelForShow(UploadFileModel UploadFile, Dictionary<string, string> paras, ref string strMsg, bool IsPreview)
{
List<T_HR_EMPLOYEEADDSUM> ListResult = new List<T_HR_EMPLOYEEADDSUM>();
try
{
Tracer.Debug("import start" + paras.Count.ToString());
string strPath = string.Empty;
SaveFile(UploadFile, out strPath);
string strPhysicalPath = HttpContext.Current.Server.MapPath(strPath);
using (EmployeeAddSumBLL bll = new EmployeeAddSumBLL())
{
ListResult = bll.ImportEmployeeAddSumFromExcelForShow(strPhysicalPath, paras, ref strMsg,IsPreview);
}
Tracer.Debug("import sucess");
}
catch (Exception ex)
{
Tracer.Debug("ImportClockInRdListFromExcelWS:" + ex.Message);
}
return ListResult;
}
public List<V_RESIGN> GetResign(int pageIndex, int pageSize, string sort, string filterString, string[] paras, ref int pageCount, DateTime starttime, DateTime endtime, string userID, int orgtype, string orgid)
{
using (EmployeeAddSumBLL bll = new EmployeeAddSumBLL())
{
IQueryable<V_RESIGN> q = bll.GetResign(pageIndex, pageSize, sort, filterString, paras, ref pageCount, starttime, endtime, userID, orgtype, orgid);
return q.Count() > 0 ? q.ToList() : null;
}
}