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);
}
