/// <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));
}
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="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>
/// 根据条件，获取T_FB_BUDGETCHECK信息
/// </summary>
/// <param name="strVacName"></param>
/// <param name="strVacYear"></param>
/// <param name="strCountyType"></param>
/// <param name="strSortKey"></param>
/// <returns></returns>
public static IQueryable<T_FB_BUDGETCHECK> GetAllBudgetCheckRdListByMultSearch(string strFilter, List<object> objArgs, string strSortKey)
{
BudgetCheckDAL dalBudgetCheck = new BudgetCheckDAL();
string strOrderBy = string.Empty;
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = " BUDGETCHECKID ";
}
var q = dalBudgetCheck.GetBudgetCheckRdListByMultSearch(strOrderBy, strFilter, objArgs.ToArray());
return q;
}
/// <summary>
/// 根据条件，获取T_FB_BUDGETCHECK信息
/// </summary>
/// <param name="strVacName"></param>
/// <param name="strVacYear"></param>
/// <param name="strCountyType"></param>
/// <param name="strSortKey"></param>
/// <returns></returns>
public static IQueryable <T_FB_BUDGETCHECK> GetAllBudgetCheckRdListByMultSearch(string strFilter, List <object> objArgs, string strSortKey)
{
BudgetCheckDAL dalBudgetCheck = new BudgetCheckDAL();
string strOrderBy = string.Empty;
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = " BUDGETCHECKID ";
}
var q = dalBudgetCheck.GetBudgetCheckRdListByMultSearch(strOrderBy, strFilter, objArgs.ToArray());
return(q);
}
/// <summary>
/// 获取T_FB_BUDGETCHECK信息
/// </summary>
/// <param name="strBudgetCheckId">主键索引</param>
/// <returns></returns>
public T_FB_BUDGETCHECK GetBudgetCheckByID(string strBudgetCheckId)
{
if (string.IsNullOrEmpty(strBudgetCheckId))
{
return null;
}
BudgetCheckDAL dalBudgetCheck = new BudgetCheckDAL();
StringBuilder strFilter = new StringBuilder();
List<string> objArgs = new List<string>();
if (!string.IsNullOrEmpty(strBudgetCheckId))
{
strFilter.Append(" BUDGETCHECKID == @0");
objArgs.Add(strBudgetCheckId);
}
T_FB_BUDGETCHECK entRd = dalBudgetCheck.GetBudgetCheckRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
return entRd;
}
/// <summary>
/// 获取T_FB_BUDGETCHECK信息
/// </summary>
/// <param name="strBudgetCheckId">主键索引</param>
/// <returns></returns>
public T_FB_BUDGETCHECK GetBudgetCheckByID(string strBudgetCheckId)
{
if (string.IsNullOrEmpty(strBudgetCheckId))
{
return(null);
}
BudgetCheckDAL dalBudgetCheck = new BudgetCheckDAL();
StringBuilder strFilter = new StringBuilder();
List <string> objArgs = new List <string>();
if (!string.IsNullOrEmpty(strBudgetCheckId))
{
strFilter.Append(" BUDGETCHECKID == @0");
objArgs.Add(strBudgetCheckId);
}
T_FB_BUDGETCHECK entRd = dalBudgetCheck.GetBudgetCheckRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
return(entRd);
}
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);
}