コード例 #1
0
        protected void storeSystemLog_Refresh(object sender, StoreRefreshDataEventArgs e)
        {
            PageQueryParams pageQueryParams = WebUIHelper.GetPageQueryParamFromStoreRefreshDataEventArgs(e, this.PagingToolBar1);

            RecordSortor recordSortor = WebUIHelper.GetRecordSortorFromStoreRefreshDataEventArgs(e);

            List <QueryFilter> filters = new List <QueryFilter>();

            filters.Add(new QueryFilter(SystemLogWrapper.PROPERTY_NAME_LOGTYPE, LogType, FilterFunction.EqualTo));
            filters.Add(new QueryFilter(SystemLogWrapper.PROPERTY_NAME_PARENTDATAID, ParentID, FilterFunction.EqualTo));

            if (!string.IsNullOrEmpty(ParentType))
            {
                filters.Add(new QueryFilter(SystemLogWrapper.PROPERTY_NAME_PARENTDATATYPE, ParentType, FilterFunction.EqualTo));
            }


            if (dfStart.SelectedValue != null)
            {
                filters.Add(new QueryFilter(SystemLogWrapper.PROPERTY_NAME_LOGDATE, Convert.ToDateTime(dfStart.SelectedDate).ToString("yyyy-MM-dd"), FilterFunction.GreaterThanOrEqualTo));
            }
            if (dfEnd.SelectedValue != null)
            {
                filters.Add(new QueryFilter(SystemLogWrapper.PROPERTY_NAME_LOGDATE, Convert.ToDateTime(dfEnd.SelectedDate).AddDays(1).ToString("yyyy-MM-dd"), FilterFunction.LessThanOrEqualTo));
            }

            storeSystemLog.DataSource = SystemLogWrapper.FindAllByOrderByAndFilter(filters, recordSortor.OrderByColumnName, recordSortor.IsDesc, pageQueryParams);
            e.Total = pageQueryParams.RecordCount;

            storeSystemLog.DataBind();
        }
コード例 #2
0
        protected void storeSPChannel_Refresh(object sender, StoreRefreshDataEventArgs e)
        {
            string sortFieldName = "";

            if (e.Sort != null)
            {
                sortFieldName = e.Sort;
            }

            if (sortFieldName == "ChannelTypeName")
            {
                sortFieldName = "ChannelType";
            }

            bool isDesc = (e.Dir == Ext.Net.SortDirection.DESC);

            PageQueryParams pageQueryParams = WebUIHelper.GetPageQueryParamFromStoreRefreshDataEventArgs(e, this.PagingToolBar1.PageSize);

            if (string.IsNullOrEmpty(sortFieldName))
            {
                sortFieldName = "Id";
                isDesc        = true;
            }

            storeSPChannel.DataSource = SPChannelWrapper.FindAllByOrderBy(sortFieldName, isDesc, pageQueryParams);
            e.Total = pageQueryParams.RecordCount;

            storeSPChannel.DataBind();
        }
コード例 #3
0
        protected void storeData_Refresh(object sender, StoreRefreshDataEventArgs e)
        {
            PageQueryParams pageQueryParams = WebUIHelper.GetPageQueryParamFromStoreRefreshDataEventArgs(e, this.PagingToolBar1);
            RecordSortor    recordSortor    = WebUIHelper.GetRecordSortorFromStoreRefreshDataEventArgs(e);

            storeData.DataSource = SPRecordWrapper.QueryRecordByPage(this.ChannelID, this.CodeID, this.ClientID, this.DataType, this.StartDate.Value, this.EndDate.Value, new List <QueryFilter>(), recordSortor.OrderByColumnName, recordSortor.IsDesc, pageQueryParams);
            e.Total = pageQueryParams.RecordCount;
            storeData.DataBind();
        }
コード例 #4
0
        protected void storeSPCode_Refresh(object sender, StoreRefreshDataEventArgs e)
        {
            PageQueryParams pageQueryParams = WebUIHelper.GetPageQueryParamFromStoreRefreshDataEventArgs(e, this.PagingToolBar1);

            RecordSortor recordSortor = WebUIHelper.GetRecordSortorFromStoreRefreshDataEventArgs(e);

            storeSPCode.DataSource = SPCodeWrapper.FindAllByOrderBy(recordSortor.OrderByColumnName, recordSortor.IsDesc, pageQueryParams);
            e.Total = pageQueryParams.RecordCount;

            storeSPCode.DataBind();
        }
        protected void storeSystemApplication_Refresh(object sender, StoreRefreshDataEventArgs e)
        {
            PageQueryParams pageQueryParams = WebUIHelper.GetPageQueryParamFromStoreRefreshDataEventArgs(e, 10);

            RecordSortor recordSortor = WebUIHelper.GetRecordSortorFromStoreRefreshDataEventArgs(e);

            storeSystemApplication.DataSource = SystemApplicationWrapper.FindAllByOrderBy(recordSortor.OrderByColumnName, recordSortor.IsDesc, pageQueryParams);
            e.Total = pageQueryParams.RecordCount;

            storeSystemApplication.DataBind();
        }
コード例 #6
0
        //protected void storeSPChannel_Refresh(object sender, StoreRefreshDataEventArgs e)
        //{
        //    this.storeSPChannel.DataSource = SPChannelWrapper.FindAll();

        //    this.storeSPChannel.DataBind();
        //}


        protected void storeData_Refresh(object sender, StoreRefreshDataEventArgs e)
        {
            PageQueryParams pageQueryParams = WebUIHelper.GetPageQueryParamFromStoreRefreshDataEventArgs(e,
                                                                                                         this.
                                                                                                         PagingToolBar1);

            ReportSearchCondition reportSearchCondition = GetReportSearchCondition(WebUIHelper.GetRecordSortorFromStoreRefreshDataEventArgs(e));

            storeData.DataSource = SPRecordWrapper.QueryRecordByPage(reportSearchCondition.Channel, reportSearchCondition.Code, reportSearchCondition.Client, SPRecordWrapper.DayReportType_AllUp, reportSearchCondition.StartDate, reportSearchCondition.EndDate, reportSearchCondition.QueryFilters, reportSearchCondition.RecordSortor.OrderByColumnName, reportSearchCondition.RecordSortor.IsDesc, pageQueryParams);
            e.Total = pageQueryParams.RecordCount;
            storeData.DataBind();
        }
コード例 #7
0
        protected void storeSPAdPack_Refresh(object sender, StoreRefreshDataEventArgs e)
        {
            PageQueryParams pageQueryParams = WebUIHelper.GetPageQueryParamFromStoreRefreshDataEventArgs(e, this.PagingToolBar1);

            RecordSortor recordSortor = WebUIHelper.GetRecordSortorFromStoreRefreshDataEventArgs(e);


            storeSPAdPack.DataSource = SPAdPackWrapper.FindAllByOrderByAndFilterAndSPAdID(recordSortor.OrderByColumnName, recordSortor.IsDesc, AdvertisementID, pageQueryParams);
            e.Total = pageQueryParams.RecordCount;

            storeSPAdPack.DataBind();
        }
コード例 #8
0
        protected void storeSystemUser_Refresh(object sender, StoreRefreshDataEventArgs e)
        {
            PageQueryParams pageQueryParams = WebUIHelper.GetPageQueryParamFromStoreRefreshDataEventArgs(e, this.PagingToolBar1);

            RecordSortor recordSortor = WebUIHelper.GetRecordSortorFromStoreRefreshDataEventArgs(e);

            List <QueryFilter> queryFilters = new List <QueryFilter>();

            queryFilters.Add(new QueryFilter(SystemUserWrapper.PROPERTY_NAME_USERLOGINID, SystemUserWrapper.DEV_USER_ID, FilterFunction.NotEqualTo));

            if (!string.IsNullOrEmpty(this.txtSearchName.Text.Trim()))
            {
                queryFilters.Add(new QueryFilter(SystemUserWrapper.PROPERTY_NAME_USERLOGINID, this.txtSearchName.Text.Trim(), FilterFunction.Contains));
            }

            storeSystemUser.DataSource = SystemUserWrapper.FindAllByOrderByAndFilter(queryFilters, recordSortor.OrderByColumnName, recordSortor.IsDesc, pageQueryParams);
            e.Total = pageQueryParams.RecordCount;

            storeSystemUser.DataBind();
        }
コード例 #9
0
        protected void storeSystemPost_Refresh(object sender, StoreRefreshDataEventArgs e)
        {
            PageQueryParams pageQueryParams = WebUIHelper.GetPageQueryParamFromStoreRefreshDataEventArgs(e, this.PagingToolBar1);

            RecordSortor recordSortor = WebUIHelper.GetRecordSortorFromStoreRefreshDataEventArgs(e);


            int selectOrgID = 0;

            if (!string.IsNullOrEmpty(e.Parameters["SelectOrgID"]))
            {
                selectOrgID = Convert.ToInt32(e.Parameters["SelectOrgID"]);
            }

            if (selectOrgID == 0)
            {
                storeSystemPost.DataSource = new List <SystemPostWrapper>();
                e.Total = 0;
                storeSystemPost.DataBind();

                return;
            }

            SystemOrganizationWrapper organization = SystemOrganizationWrapper.FindById(selectOrgID);

            if (organization == null)
            {
                storeSystemPost.DataSource = new List <SystemPostWrapper>();
                e.Total = 0;
                storeSystemPost.DataBind();

                return;
            }

            storeSystemPost.DataSource = SystemPostWrapper.FindAllByOrderByAndFilterAndOrganizationID(recordSortor.OrderByColumnName, recordSortor.IsDesc, organization, pageQueryParams);
            e.Total = pageQueryParams.RecordCount;

            storeSystemPost.DataBind();
        }
        protected void storeSystemDictionary_Refresh(object sender, StoreRefreshDataEventArgs e)
        {
            PageQueryParams pageQueryParams = WebUIHelper.GetPageQueryParamFromStoreRefreshDataEventArgs(e, this.PagingToolBar1);

            RecordSortor recordSortor = WebUIHelper.GetRecordSortorFromStoreRefreshDataEventArgs(e);

            List <SystemDictionaryWrapper> datas = null;

            if (DictionaryGroup != null)
            {
                datas = SystemDictionaryWrapper.FindAllByOrderByAndFilterAndSystemDictionaryGroupID(recordSortor.OrderByColumnName, recordSortor.IsDesc, DictionaryGroup, pageQueryParams);
            }
            else
            {
                datas = SystemDictionaryWrapper.FindAllByOrderByAndFilter(new List <QueryFilter>(), recordSortor.OrderByColumnName, recordSortor.IsDesc, pageQueryParams);
            }

            storeSystemDictionary.DataSource = datas;
            e.Total = pageQueryParams.RecordCount;

            storeSystemDictionary.DataBind();
        }
コード例 #11
0
        protected void storeSPSClient_Refresh(object sender, StoreRefreshDataEventArgs e)
        {
            string sortFieldName = "";

            if (e.Sort != null)
            {
                sortFieldName = e.Sort;
            }

            if (string.IsNullOrEmpty(sortFieldName))
            {
                sortFieldName = SPSClientWrapper.PROPERTY_NAME_ID;
            }


            PageQueryParams pageQueryParams = WebUIHelper.GetPageQueryParamFromStoreRefreshDataEventArgs(e, this.PagingToolBar1);

            storeSPSClient.DataSource = SPSClientWrapper.FindAllByOrderBy(sortFieldName, (e.Dir == Ext.Net.SortDirection.DESC), pageQueryParams);
            e.Total = pageQueryParams.RecordCount;

            storeSPSClient.DataBind();
        }
コード例 #12
0
        protected void storeSystemPrivilege_Refresh(object sender, StoreRefreshDataEventArgs e)
        {
            PageQueryParams pageQueryParams = WebUIHelper.GetPageQueryParamFromStoreRefreshDataEventArgs(e, this.PagingToolBar1);

            RecordSortor recordSortor = WebUIHelper.GetRecordSortorFromStoreRefreshDataEventArgs(e);

            int selectResourceID = 0;

            if (e.Parameters["SelectResourceID"] != null)
            {
                selectResourceID = Convert.ToInt32(e.Parameters["SelectResourceID"]);
            }

            if (selectResourceID == 0)
            {
                storeSystemPrivilege.DataSource = new List <SystemPrivilegeWrapper>();
                e.Total = 0;
                storeSystemPrivilege.DataBind();

                return;
            }

            SystemResourcesWrapper resourcesWrapper = SystemResourcesWrapper.FindById(selectResourceID);

            if (resourcesWrapper == null)
            {
                storeSystemPrivilege.DataSource = new List <SystemPrivilegeWrapper>();
                e.Total = 0;
                storeSystemPrivilege.DataBind();

                return;
            }

            storeSystemPrivilege.DataSource = SystemPrivilegeWrapper.FindAllByOrderByAndFilterAndResourcesID(recordSortor.OrderByColumnName, recordSortor.IsDesc, resourcesWrapper, pageQueryParams);
            e.Total = pageQueryParams.RecordCount;

            storeSystemPrivilege.DataBind();
        }
コード例 #13
0
        protected void storeData_Refresh(object sender, StoreRefreshDataEventArgs e)
        {
            //storeData.DataSource = new List<SPRecordWrapper>();
            //storeData.DataBind();

            PageQueryParams pageQueryParams = WebUIHelper.GetPageQueryParamFromStoreRefreshDataEventArgs(e,
                                                                                                         this.
                                                                                                         PagingToolBar1);

            RecordSortor recordSortor = WebUIHelper.GetRecordSortorFromStoreRefreshDataEventArgs(e);

            SPChannelWrapper channel = null;



            SPSClientWrapper client = this.Client;



            SPCodeWrapper code = null;

            if (this.cmbCode.SelectedItem != null)
            {
                code = SPCodeWrapper.FindById(Convert.ToInt32(this.cmbCode.SelectedItem.Value));
            }

            DateTime?startDate = null;

            if (this.dfStart.SelectedValue != null)
            {
                startDate = this.dfStart.SelectedDate;
            }

            DateTime?endDate = null;

            if (this.dfEnd.SelectedValue != null)
            {
                endDate = this.dfEnd.SelectedDate;
            }

            List <QueryFilter> queryFilters = new List <QueryFilter>();

            if (!string.IsNullOrEmpty(this.txtPhoneNumber.Text.Trim()))
            {
                queryFilters.Add(new QueryFilter(SPRecordWrapper.PROPERTY_NAME_MOBILE, this.txtPhoneNumber.Text.Trim(), FilterFunction.StartsWith));
            }

            if (!string.IsNullOrEmpty(this.txtLinkID.Text.Trim()))
            {
                queryFilters.Add(new QueryFilter(SPRecordWrapper.PROPERTY_NAME_LINKID, this.txtLinkID.Text.Trim(), FilterFunction.StartsWith));
            }

            if (!string.IsNullOrEmpty(this.txtSpNumber.Text.Trim()))
            {
                queryFilters.Add(new QueryFilter(SPRecordWrapper.PROPERTY_NAME_SPNUMBER, this.txtSpNumber.Text.Trim(), FilterFunction.StartsWith));
            }

            if (!string.IsNullOrEmpty(this.txtMo.Text.Trim()))
            {
                queryFilters.Add(new QueryFilter(SPRecordWrapper.PROPERTY_NAME_MO, this.txtMo.Text.Trim(), FilterFunction.StartsWith));
            }


            queryFilters.Add(new QueryFilter(SPRecordWrapper.PROPERTY_NAME_ISINTERCEPT, (false).ToString(), FilterFunction.EqualTo));


            queryFilters.Add(new QueryFilter(SPRecordWrapper.PROPERTY_NAME_ISSTATOK, (true).ToString(), FilterFunction.EqualTo));


            //if (this.cmbSycnStatus.SelectedItem != null && this.cmbSycnStatus.SelectedItem.Value != null)
            //{
            //    queryFilters.Add(new QueryFilter(SPRecordWrapper.PROPERTY_NAME_ISSYCNSUCCESSED, (this.cmbSycnStatus.SelectedItem.Value == "1").ToString(), FilterFunction.EqualTo));
            //}

            if (this.cmbProvince.SelectedItem != null && this.cmbProvince.SelectedItem.Value != null)
            {
                queryFilters.Add(new QueryFilter(SPRecordWrapper.PROPERTY_NAME_PROVINCE, this.cmbProvince.SelectedItem.Value.ToString(), FilterFunction.EqualTo));
            }

            if (this.cmbOperateType.SelectedItem != null && this.cmbOperateType.SelectedItem.Value != null)
            {
                queryFilters.Add(new QueryFilter(SPRecordWrapper.PROPERTY_NAME_OPERATORTYPE, this.cmbOperateType.SelectedItem.Value.ToString(), FilterFunction.EqualTo));
            }

            storeData.DataSource = SPRecordWrapper.QueryRecordByPage(channel, code, client, SPRecordWrapper.DayReportType_AllUp, startDate, endDate, queryFilters, recordSortor.OrderByColumnName, recordSortor.IsDesc, pageQueryParams);
            e.Total = pageQueryParams.RecordCount;
            storeData.DataBind();
        }