public List <V_LandStatistic> GetPersonalLandStatisticListByMultSearch(string strOwnerID, string strOrderBy, string filterString, List <object> objArgs) { List <V_LandStatistic> entList = new List <V_LandStatistic>(); PersonalLandStatisticDAL dalPersonalLandStatistic = new PersonalLandStatisticDAL(); if (!string.IsNullOrEmpty(strOwnerID)) { SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "V_LandStatistic"); } if (string.IsNullOrEmpty(strOrderBy)) { strOrderBy = "p.ownercompanyid"; } bool isCountSub = true; //计算子公司的登录人数 entList = dalPersonalLandStatistic.GetPersonalLandStatisticList(isCountSub, strOrderBy, filterString, objArgs.ToArray()); return(entList); }
/// <summary> /// 获取部门的执行一览的导出数据 /// </summary> /// <param name="strOrgType"></param> /// <param name="strOrgID"></param> /// <param name="strOwnerId"></param> /// <param name="iYear"></param> /// <param name="iMonthStart"></param> /// <param name="iMonthEnd"></param> /// <param name="strFilter"></param> /// <param name="objArgs"></param> /// <param name="strSortKey"></param> /// <returns></returns> public byte[] OutFileLandStatisticList(string strOwnerID, string strOrderBy, string filterString, List <object> objArgs) { List <V_LandStatistic> entList = new List <V_LandStatistic>(); PersonalLandStatisticDAL dalPersonalLandStatistic = new PersonalLandStatisticDAL(); if (!string.IsNullOrEmpty(strOwnerID)) { SetOrganizationFilter(ref filterString, ref objArgs, strOwnerID, "V_LandStatistic"); } if (string.IsNullOrEmpty(strOrderBy)) { strOrderBy = "p.ownercompanyid"; } bool isCountSub = true; //计算子公司的登录人数 entList = dalPersonalLandStatistic.GetPersonalLandStatisticList(isCountSub, strOrderBy, filterString, objArgs.ToArray()); DataTable dt = MakeTableToExportLandStatistic(); DataTable dtExport = GetExportDataForLandStatistic(dt, entList); return(Utility.OutFileStream("员工登录记录统计", dtExport)); }