Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        /// <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));
        }