public async Task <ActionResult> PagingQuery(string where, string orderBy, int?currentPageNo, int?currentPageSize)
{
if (ModelState.IsValid)
{
int pageNo = currentPageNo ?? 0;
int pageSize = currentPageSize ?? 20;
if (Request["PageNo"] != null)
{
pageNo = Convert.ToInt32(Request["PageNo"]);
}
if (Request["PageSize"] != null)
{
pageSize = Convert.ToInt32(Request["PageSize"]);
}
using (PackageOemQueryServiceClient client = new PackageOemQueryServiceClient())
{
await Task.Run(() =>
{
PagingConfig cfg = new PagingConfig()
{
PageNo = pageNo,
PageSize = pageSize,
Where = where ?? string.Empty,
OrderBy = orderBy ?? string.Empty
};
MethodReturnResult <IList <PackageOemDetail> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
});
}
}
return(PartialView("_ListPartial", new LotOemPackageViewModel()));
}
public ActionResult Query(LotOemPackageQueryViewModel model)
{
string keyList = null;
if (model.Type != null || model.SN != null || model.PNOM != null || model.PackageNo != null)
{
using (PackageOemQueryServiceClient client = new PackageOemQueryServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
IsPaging = false,
Where = GetQueryCondition(model)
};
MethodReturnResult <IList <PackageOemDetail> > result = client.Get(ref cfg);
if (result.Code == 0 && result.Data.Count > 0)
{
StringBuilder strb = new StringBuilder();
foreach (var item in result.Data)
{
strb.Append("'" + item.Key.SN + "',");
}
keyList = strb.ToString().Substring(0, strb.Length - 1);
}
else
{
return(PartialView("_ListPartial", new LotOemPackageViewModel()));
}
}
}
if (keyList != null)
{
using (PackageOemQueryServiceClient client = new PackageOemQueryServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
//IsPaging = false,
Where = string.Format(" Key in ({0})"
, keyList),
OrderBy = "PackageNo",
};
MethodReturnResult <IList <PackageOemDetail> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
}
}
else
{
using (PackageOemQueryServiceClient client = new PackageOemQueryServiceClient())
{
PagingConfig cfg = new PagingConfig()
{
OrderBy = "PackageNo"
};
MethodReturnResult <IList <PackageOemDetail> > result = client.Get(ref cfg);
if (result.Code == 0)
{
ViewBag.PagingConfig = cfg;
ViewBag.List = result.Data;
}
;
}
}
return(PartialView("_ListPartial", new LotOemPackageViewModel()));
}