public byte[] OutFileStandingBookList(string strOrgType, string strOwnerId, DateTime dtStart, DateTime dtEnd, string strSortKey, string strFilter, List <object> objArgs)
{
List <V_StandingBook> entStandingBookList = new List <V_StandingBook>();
BudgetCheckDAL dalBudgetCheck = new BudgetCheckDAL();
string strOrderBy = string.Empty;
if (!string.IsNullOrWhiteSpace(strOwnerId))
{
SMT.SaaS.BLLCommonServices.Utility ul = new SaaS.BLLCommonServices.Utility();
ul.SetOrganizationFilter(ref strFilter, ref objArgs, strOwnerId, "StandingBook");
}
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = "SUBJECTID";
}
entStandingBookList = dalBudgetCheck.GetStandingBookByMultSearch(strOrgType, dtStart, dtEnd, strOrderBy, strFilter, objArgs.ToArray());
DataTable dt = MakeTableToExportStandingBook();
DataTable dtExport = GetExportDataForStandingBook(dt, entStandingBookList);
return(Utility.OutFileStream("预算台帐列表", dtExport));
}
/// <summary>
/// 根据部门ID及其组织架构类型返回该部门下的所有科目类型
/// </summary>
/// <param name="strOwnerID"></param>
/// <param name="strOrgId"></param>
/// <param name="strModelCode"></param>
/// <param name="entRes"></param>
private void GetSubjectByDeptment(string strOwnerID, string strOrgId, string strModelCode, ref List <T_FB_SUBJECT> entResList)
{
SubjectDAL dalSubject = new SubjectDAL();
decimal dActived = 1;
var ents = from v in dalSubject.GetObjects <T_FB_SUBJECTDEPTMENT>().Include("T_FB_SUBJECT")
where v.ACTIVED == dActived && v.OWNERDEPARTMENTID == strOrgId
select v;
string filterString = string.Empty;
List <object> objArgs = new List <object>();
SMT.SaaS.BLLCommonServices.Utility ul = new SaaS.BLLCommonServices.Utility();
ul.SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "T_FB_SUBJECTDEPTMENT");
if (ents == null)
{
return;
}
if (ents.Count() == 0)
{
return;
}
var res = ents.Select(t => t.T_FB_SUBJECT);
if (res == null)
{
return;
}
entResList = res.ToList();
}
public byte[] OutFileYearlyBudgetAnalysisList(string strOrgType, string strOwnerId, int iYear, int iMonthStart,
int iMonthEnd, string strSortKey, string strFilter, List <object> objArgs)
{
List <V_YearlyBudgetAnalysis> entYearlyAnalysisList = new List <V_YearlyBudgetAnalysis>();
BudgetCheckDAL dalBudgetCheck = new BudgetCheckDAL();
string strOrderBy = string.Empty;
if (!string.IsNullOrWhiteSpace(strOwnerId))
{
SMT.SaaS.BLLCommonServices.Utility ul = new SaaS.BLLCommonServices.Utility();
ul.SetOrganizationFilter(ref strFilter, ref objArgs, strOwnerId, "YearlyBudgetAnalysis");
}
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = "SUBJECTID";
}
entYearlyAnalysisList = dalBudgetCheck.GetYearlyBudgetAnalysisByMultSearch(strOrgType, iYear, iMonthStart, iMonthEnd, strOrderBy, strFilter, objArgs.ToArray());
DataTable dt = MakeTableToExportYearlyAnalysis();
DataTable dtExport = GetExportDataForYearlyAnalysis(dt, entYearlyAnalysisList);
return(Utility.OutFileStream("年度预算分析列表", dtExport));
}
/// <summary>
/// 预算台帐查询分页
/// </summary>
/// <param name="strOrgType"></param>
/// <param name="strOwnerId"></param>
/// <param name="dtStart"></param>
/// <param name="dtEnd"></param>
/// <param name="strSortKey"></param>
/// <param name="strFilter"></param>
/// <param name="objArgs"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public List <V_StandingBook> GetStandingBookByMultSearch(string strOrgType, string strOwnerId, DateTime dtStart, DateTime dtEnd, string strSortKey,
string strFilter, List <object> objArgs, int pageIndex, int pageSize, ref int pageCount)
{
List <V_StandingBook> entStandingBookList = new List <V_StandingBook>();
BudgetCheckDAL dalBudgetCheck = new BudgetCheckDAL();
string strOrderBy = string.Empty;
if (!string.IsNullOrWhiteSpace(strOwnerId))
{
SMT.SaaS.BLLCommonServices.Utility ul = new SaaS.BLLCommonServices.Utility();
ul.SetOrganizationFilter(ref strFilter, ref objArgs, strOwnerId, "StandingBook");
}
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = "SUBJECTID";
}
entStandingBookList = dalBudgetCheck.GetStandingBookByMultSearch(strOrgType, dtStart, dtEnd, strOrderBy, strFilter, objArgs.ToArray());
return(Utility.PagerList <V_StandingBook>(entStandingBookList, pageIndex, pageSize, ref pageCount));
}
/// <summary>
/// 预算月度预算分析分页
/// </summary>
/// <param name="strOrgType"></param>
/// <param name="strOwnerId"></param>
/// <param name="strOrgID"></param>
/// <param name="iYear"></param>
/// <param name="iMonth"></param>
/// <param name="strSortKey"></param>
/// <param name="strFilter"></param>
/// <param name="objArgs"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public List <V_MonthlyBudgetAnalysis> GetMonthlyBudgetAnalysisByMultSearch(string strOrgType, string strOwnerId, int iYear, int iMonth,
string strSortKey, string strFilter, List <object> objArgs, int pageIndex, int pageSize, ref int pageCount)
{
List <V_MonthlyBudgetAnalysis> entMonthlyAnalysisList = new List <V_MonthlyBudgetAnalysis>();
BudgetCheckDAL dalBudgetCheck = new BudgetCheckDAL();
string strOrderBy = string.Empty;
if (!string.IsNullOrWhiteSpace(strOwnerId))
{
SMT.SaaS.BLLCommonServices.Utility ul = new SaaS.BLLCommonServices.Utility();
ul.SetOrganizationFilter(ref strFilter, ref objArgs, strOwnerId, "MonthlyBudgetAnalysis");
}
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = "SUBJECTID";
}
entMonthlyAnalysisList = dalBudgetCheck.GetMonthlyBudgetAnalysisByMultSearch(strOrgType, iYear, iMonth, strOrderBy, strFilter, objArgs.ToArray());
return(Utility.PagerList <V_MonthlyBudgetAnalysis>(entMonthlyAnalysisList, pageIndex, pageSize, ref pageCount));
}
/// <summary>
/// 根据查询条件，获取还款信息(主要用于查询分页)
/// </summary>
/// <param name="strOwnerID">查询人的员工ID</param>
/// <param name="strDateStart">查询起始时间</param>
/// <param name="strDateEnd">查询截止时间</param>
/// <param name="strCheckState">查询审核状态</param>
/// <param name="strFilter">查询条件</param>
/// <param name="objArgs">查询参数</param>
/// <param name="strOrderBy">strSortKey</param>
/// <returns></returns>
public static IQueryable <T_FB_REPAYAPPLYMASTER> GetAllRepayApplyMasterRdListByMultSearch(string strOwnerID, string strDateStart,
string strDateEnd, string strCheckState, string strFilter, List <object> objArgs, string strSortKey)
{
try
{
RepayApplyMasterDAL dalRepay = new RepayApplyMasterDAL();
string strOrderBy = string.Empty;
if (string.IsNullOrWhiteSpace(strOwnerID) || string.IsNullOrWhiteSpace(strCheckState))
{
return(null);
}
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = " REPAYAPPLYMASTERID ";
}
SMT.SaaS.BLLCommonServices.Utility ulFoo = new SaaS.BLLCommonServices.Utility();
if (strCheckState != Convert.ToInt32(FBAEnums.CheckStates.WaittingApproval).ToString())
{
ulFoo.SetOrganizationFilter(ref strFilter, ref objArgs, strOwnerID, "T_FB_REPAYAPPLYMASTER");
}
else
{
string StrOld = "";
StrOld = strFilter;//将过滤前的字符串付给再比较
ulFoo.SetFilterWithflow("REPAYAPPLYMASTERID", "T_FB_REPAYAPPLYMASTER", strOwnerID, ref strCheckState, ref strFilter, ref objArgs);
if (StrOld.Equals(strFilter))
{
return(null);
}
strCheckState = Convert.ToInt32(FBAEnums.CheckStates.Approving).ToString();
}
if (strCheckState == Convert.ToInt32(FBAEnums.CheckStates.All).ToString())
{
strCheckState = string.Empty;
}
var ents = dalRepay.GetRepayApplyMasterRdListByMultSearch(strCheckState, strDateStart, strDateEnd, strOrderBy, strFilter, objArgs.ToArray());
return(ents);
}
catch (Exception ex)
{
Utility.SaveLog(DateTime.Now.ToString() + "调用函数GetAllRepayApplyMasterRdListByMultSearch出错， 查询人的员工ID为：" + strOwnerID + "，错误信息为：" + ex.ToString());
}
return(null);
}
/// <summary>
/// 获取所有 SUBJECT。
/// </summary>
/// <returns>返回结果列表。</returns>
public IQueryable <T_FB_SUBJECT> GetAllSubject(string strOwnerID)
{
SubjectDAL dalSubject = new SubjectDAL();
string filterString = string.Empty;
List <object> objArgs = new List <object>();
if (!string.IsNullOrEmpty(strOwnerID))
{
SMT.SaaS.BLLCommonServices.Utility ul = new SaaS.BLLCommonServices.Utility();
ul.SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "T_FB_SUBJECT");
}
return(dalSubject.GetAllSubject());
}
/// <summary>
/// 根据部门ID及其组织架构类型返回该部门下的所有科目类型
/// </summary>
/// <param name="strOwnerID"></param>
/// <param name="strOrgId"></param>
/// <param name="strModelCode"></param>
/// <param name="entRes"></param>
private void GetSubjectByDeptment(string strOwnerID, string strOrgId, string strModelCode, ref List<T_FB_SUBJECT> entResList)
{
SubjectDAL dalSubject = new SubjectDAL();
decimal dActived = 1;
var ents = from v in dalSubject.GetObjects<T_FB_SUBJECTDEPTMENT>().Include("T_FB_SUBJECT")
where v.ACTIVED == dActived && v.OWNERDEPARTMENTID == strOrgId
select v;
string filterString = string.Empty;
List<object> objArgs = new List<object>();
SMT.SaaS.BLLCommonServices.Utility ul = new SaaS.BLLCommonServices.Utility();
ul.SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "T_FB_SUBJECTDEPTMENT");
if (ents == null)
{
return;
}
if (ents.Count() == 0)
{
return;
}
var res = ents.Select(t => t.T_FB_SUBJECT);
if (res == null)
{
return;
}
entResList = res.ToList();
}
/// <summary>
/// 获取所有 SUBJECT。
/// </summary>
/// <returns>返回结果列表。</returns>
public IQueryable<T_FB_SUBJECT> GetAllSubject(string strOwnerID)
{
SubjectDAL dalSubject = new SubjectDAL();
string filterString = string.Empty;
List<object> objArgs = new List<object>();
if (!string.IsNullOrEmpty(strOwnerID))
{
SMT.SaaS.BLLCommonServices.Utility ul = new SaaS.BLLCommonServices.Utility();
ul.SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "T_FB_SUBJECT");
}
return dalSubject.GetAllSubject();
}
public byte[] OutFileYearlyBudgetAnalysisList(string strOrgType, string strOwnerId, int iYear, int iMonthStart,
int iMonthEnd, string strSortKey, string strFilter, List<object> objArgs)
{
List<V_YearlyBudgetAnalysis> entYearlyAnalysisList = new List<V_YearlyBudgetAnalysis>();
BudgetCheckDAL dalBudgetCheck = new BudgetCheckDAL();
string strOrderBy = string.Empty;
if (!string.IsNullOrWhiteSpace(strOwnerId))
{
SMT.SaaS.BLLCommonServices.Utility ul = new SaaS.BLLCommonServices.Utility();
ul.SetOrganizationFilter(ref strFilter, ref objArgs, strOwnerId, "YearlyBudgetAnalysis");
}
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = "SUBJECTID";
}
entYearlyAnalysisList = dalBudgetCheck.GetYearlyBudgetAnalysisByMultSearch(strOrgType, iYear, iMonthStart, iMonthEnd, strOrderBy, strFilter, objArgs.ToArray());
DataTable dt = MakeTableToExportYearlyAnalysis();
DataTable dtExport = GetExportDataForYearlyAnalysis(dt, entYearlyAnalysisList);
return Utility.OutFileStream("年度预算分析列表", dtExport);
}
public byte[] OutFileStandingBookList(string strOrgType, string strOwnerId, DateTime dtStart, DateTime dtEnd, string strSortKey, string strFilter, List<object> objArgs)
{
List<V_StandingBook> entStandingBookList = new List<V_StandingBook>();
BudgetCheckDAL dalBudgetCheck = new BudgetCheckDAL();
string strOrderBy = string.Empty;
if (!string.IsNullOrWhiteSpace(strOwnerId))
{
SMT.SaaS.BLLCommonServices.Utility ul = new SaaS.BLLCommonServices.Utility();
ul.SetOrganizationFilter(ref strFilter, ref objArgs, strOwnerId, "StandingBook");
}
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = "SUBJECTID";
}
entStandingBookList = dalBudgetCheck.GetStandingBookByMultSearch(strOrgType, dtStart, dtEnd, strOrderBy, strFilter, objArgs.ToArray());
DataTable dt = MakeTableToExportStandingBook();
DataTable dtExport = GetExportDataForStandingBook(dt, entStandingBookList);
return Utility.OutFileStream("预算台帐列表", dtExport);
}
/// <summary>
/// 预算月度预算分析分页
/// </summary>
/// <param name="strOrgType"></param>
/// <param name="strOwnerId"></param>
/// <param name="strOrgID"></param>
/// <param name="iYear"></param>
/// <param name="iMonth"></param>
/// <param name="strSortKey"></param>
/// <param name="strFilter"></param>
/// <param name="objArgs"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public List<V_MonthlyBudgetAnalysis> GetMonthlyBudgetAnalysisByMultSearch(string strOrgType, string strOwnerId, int iYear, int iMonth,
string strSortKey, string strFilter, List<object> objArgs, int pageIndex, int pageSize, ref int pageCount)
{
List<V_MonthlyBudgetAnalysis> entMonthlyAnalysisList = new List<V_MonthlyBudgetAnalysis>();
BudgetCheckDAL dalBudgetCheck = new BudgetCheckDAL();
string strOrderBy = string.Empty;
if (!string.IsNullOrWhiteSpace(strOwnerId))
{
SMT.SaaS.BLLCommonServices.Utility ul = new SaaS.BLLCommonServices.Utility();
ul.SetOrganizationFilter(ref strFilter, ref objArgs, strOwnerId, "MonthlyBudgetAnalysis");
}
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = "SUBJECTID";
}
entMonthlyAnalysisList = dalBudgetCheck.GetMonthlyBudgetAnalysisByMultSearch(strOrgType, iYear, iMonth, strOrderBy, strFilter, objArgs.ToArray());
return Utility.PagerList<V_MonthlyBudgetAnalysis>(entMonthlyAnalysisList, pageIndex, pageSize, ref pageCount);
}
/// <summary>
/// 预算台帐查询分页
/// </summary>
/// <param name="strOrgType"></param>
/// <param name="strOwnerId"></param>
/// <param name="dtStart"></param>
/// <param name="dtEnd"></param>
/// <param name="strSortKey"></param>
/// <param name="strFilter"></param>
/// <param name="objArgs"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public List<V_StandingBook> GetStandingBookByMultSearch(string strOrgType, string strOwnerId, DateTime dtStart, DateTime dtEnd, string strSortKey,
string strFilter, List<object> objArgs, int pageIndex, int pageSize, ref int pageCount)
{
List<V_StandingBook> entStandingBookList = new List<V_StandingBook>();
BudgetCheckDAL dalBudgetCheck = new BudgetCheckDAL();
string strOrderBy = string.Empty;
if (!string.IsNullOrWhiteSpace(strOwnerId))
{
SMT.SaaS.BLLCommonServices.Utility ul = new SaaS.BLLCommonServices.Utility();
ul.SetOrganizationFilter(ref strFilter, ref objArgs, strOwnerId, "StandingBook");
}
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = "SUBJECTID";
}
entStandingBookList = dalBudgetCheck.GetStandingBookByMultSearch(strOrgType, dtStart, dtEnd, strOrderBy, strFilter, objArgs.ToArray());
return Utility.PagerList<V_StandingBook>(entStandingBookList, pageIndex, pageSize, ref pageCount);
}
