public DataTable QueryFloorMaster(FloorMasterQueryFilter filter, out int totalCount) { PagingInfoEntity pagingEntity = new PagingInfoEntity(); if (filter.PageInfo == null) { pagingEntity = null; } else { pagingEntity.SortField = filter.PageInfo.SortBy; pagingEntity.MaximumRows = filter.PageInfo.PageSize; pagingEntity.StartRowIndex = filter.PageInfo.PageIndex * filter.PageInfo.PageSize; } var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("Floor_QueryFloorMaster"); using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, pagingEntity, "PageCode ASC, Priority ASC")) { sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "PageCode", DbType.String, "@PageCode", QueryConditionOperatorType.Equal, filter.PageCode); sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "PageType", DbType.Int32, "@PageType", QueryConditionOperatorType.Equal, filter.PageType); cmd.CommandText = sqlBuilder.BuildQuerySql(); EnumColumnList enumConfig = new EnumColumnList(); enumConfig.Add("PageType", typeof(PageCodeType)); enumConfig.Add("Status", typeof(ADStatus)); var dt = cmd.ExecuteDataTable(enumConfig); totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount")); return(dt); } }
private void DataGrid_LoadingDataSource(object sender, Newegg.Oversea.Silverlight.Controls.Data.LoadingDataEventArgs e) { FloorMasterQueryFilter filter = new FloorMasterQueryFilter(); filter.PageType = PageCodeType.Promotion; filter.PageCode = cbPageID.SelectedItem == null ? filter.PageCode : ((KeyValuePair <string, string>)cbPageID.SelectedItem).Key; filter.PageInfo = new QueryFilter.Common.PagingInfo { PageIndex = DataGrid.PageIndex, PageSize = DataGrid.PageSize }; facade.QueryFloor(filter, (s, args) => { var model = new List <FloorVM>(); foreach (var row in args.Result.Rows) { var vm = new FloorVM(); vm.FloorLogoSrc = row.FloorLogoSrc; vm.FloorName = row.FloorName; //vm.FloorNo = "#" + i; vm.Remark = row.Remark; vm.Status = row.Status; vm.SysNo = row.SysNo; vm.TemplateName = GetTemplateName(row.TemplateSysNo); vm.Templates = Templates; vm.TemplateSysNo = row.TemplateSysNo; vm.Priority = row.Priority.ToString(); vm.PageType = row.PageType; vm.PageCode = row.PageCode; vm.PageName = row.PageName; model.Add(vm); } var query = from a in model group a by a.PageCode into g select g; foreach (var m in query) { var ls = m.ToList <FloorVM>(); if (ls != null) { for (var i = 0; i < ls.Count(); i++) { ls[i].FloorNo = "#" + (i + 1); } } } DataGrid.ItemsSource = model; DataGrid.TotalCount = args.Result.TotalCount; }); }
public virtual QueryResult QueryFloorMaster(FloorMasterQueryFilter filter) { int totalCount; var dataTable = ObjectFactory <ECCentral.Service.MKT.IDataAccess.IFloorDA> .Instance.QueryFloorMaster(filter, out totalCount); return(new QueryResult() { Data = dataTable, TotalCount = totalCount }); }
public void QueryFloor(FloorMasterQueryFilter filter, EventHandler <RestClientEventArgs <dynamic> > callback) { string relativeUrl = "/MKTService/Floor/QueryFloorMaster"; restClient.QueryDynamicData(relativeUrl, filter, callback); }