private void LoadData()
{
ItemList.ItemList_Service s = new ItemList.ItemList_Service();
s.Url = common.ReBuildUrl(s.Url, "");
s.Credentials = common.CheckCredentials();
List <ItemList.ItemList_Filter> DataFilter = new List <ItemList.ItemList_Filter>();
#region Filter
//Replenishment_System = Purchase
ItemList.ItemList_Filter ReplenishmentSystemFilter = new ItemList.ItemList_Filter();
ReplenishmentSystemFilter.Field = ItemList.ItemList_Fields.Replenishment_System;
ReplenishmentSystemFilter.Criteria = "Purchase";
DataFilter.Add(ReplenishmentSystemFilter);
#endregion
ItemList.ItemList[] Results = s.ReadMultiple(DataFilter.ToArray(), "", 10);
List <ItemList.ItemList> ListResult = new List <ItemList.ItemList>();
while (Results.Length > 0)
{
bookmarkKey = Results.Last().Key;
ListResult.AddRange(Results);
Results = s.ReadMultiple(DataFilter.ToArray(), bookmarkKey, fetchSize);
}
this.storeMain.DataSource = ListResult;
this.storeMain.DataBind();
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
//var username = string.Empty;
//if (!string.IsNullOrEmpty(context.Request["UserName"]))
//{
// username = context.Request["UserName"];
//}
int start = 0;
int limit = 10;
string sort = string.Empty;
string dir = string.Empty;
string query = string.Empty;
string Company = string.Empty;
const int fetchSize = 10;
string bookmarkKey = null;
if (!string.IsNullOrEmpty(context.Request["start"]))
{
start = int.Parse(context.Request["start"]);
}
if (!string.IsNullOrEmpty(context.Request["limit"]))
{
limit = int.Parse(context.Request["limit"]);
}
if (!string.IsNullOrEmpty(context.Request["sort"]))
{
sort = context.Request["sort"];
}
if (!string.IsNullOrEmpty(context.Request["dir"]))
{
dir = context.Request["dir"];
}
if (!string.IsNullOrEmpty(context.Request["query"]))
{
query = context.Request["query"];
}
if (!string.IsNullOrEmpty(context.Request["CurCompany"]))
{
Company = context.Request["CurCompany"];
}
ItemList.ItemList_Service s = new ItemList.ItemList_Service();
s.Url = common.ReBuildUrl(s.Url, Company);
s.Credentials = common.CheckCredentials();
List <ItemList.ItemList_Filter> DataFilter = new List <ItemList.ItemList_Filter>();
#region Filter
//Replenishment_System = Purchase
ItemList.ItemList_Filter ReplenishmentSystemFilter = new ItemList.ItemList_Filter();
ReplenishmentSystemFilter.Field = ItemList.ItemList_Fields.Replenishment_System;
ReplenishmentSystemFilter.Criteria = "Purchase";
DataFilter.Add(ReplenishmentSystemFilter);
ItemList.ItemList_Filter Inventory_Posting_GroupFilter = new ItemList.ItemList_Filter();
Inventory_Posting_GroupFilter.Field = ItemList.ItemList_Fields.Inventory_Posting_Group;
Inventory_Posting_GroupFilter.Criteria = "RAW MT|RESALE|IT-TECH";
DataFilter.Add(Inventory_Posting_GroupFilter);
ItemList.ItemList_Filter BlockedFilter = new ItemList.ItemList_Filter();
BlockedFilter.Field = ItemList.ItemList_Fields.Blocked;
BlockedFilter.Criteria = "false";
DataFilter.Add(BlockedFilter);
//No
ItemList.ItemList_Filter NoFilter = new ItemList.ItemList_Filter();
NoFilter.Field = ItemList.ItemList_Fields.No;
NoFilter.Criteria = "*" + query + "*";
DataFilter.Add(NoFilter);
#endregion
ItemList.ItemList[] Results = s.ReadMultiple(DataFilter.ToArray(), bookmarkKey, fetchSize);
List <ItemList.ItemList> ListResult = new List <ItemList.ItemList>();
while (Results.Length > 0)
{
bookmarkKey = Results.Last().Key;
ListResult.AddRange(Results);
Results = s.ReadMultiple(DataFilter.ToArray(), bookmarkKey, fetchSize);
}
Paging <ItemList.ItemList> list = PlantsPaging(start, limit, sort, dir, query, ListResult);
context.Response.Write(string.Format("{{total:{1},'data':{0}}}", JSON.Serialize(list.Data), list.TotalRecords));
}
