public void ListTopProductInWH()
{
IList <ProductStock> objs = _bal.ListTopProductInWH(BLLConstants.I_SHOW_NUM);
if (objs != null && objs.Count > 0)
{
for (int i = 0; i < objs.Count; i++)
{
//objs[i].StockHouse = _bal.FindNameBySubCode(objs[i].StockHouse) == null ? objs[i].StockHouse : _bal.FindNameBySubCode(objs[i].StockHouse).SubName;
//objs[i].MANUFACTURE = _bal.FindCustNameByCode(objs[i].MANUFACTURE) == null ? objs[i].MANUFACTURE : _bal.FindCustNameByCode(objs[i].MANUFACTURE).NAME;
objs[i].FromBy = _bal.FindUserNameByCode(objs[i].UpdatedBy) == null ? objs[i].UpdatedBy : _bal.FindUserNameByCode(objs[i].UpdatedBy).UserName;
objs[i].UpdatedBy = _bal.FindUserNameByCode(objs[i].UpdatedBy) == null ? objs[i].UpdatedBy : _bal.FindUserNameByCode(objs[i].UpdatedBy).UserName;
}
}
//StringBuilder sb = new StringBuilder();
//sb.Append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
//sb.Append("<rows>");
//if (objs != null && objs.Count > 0)
//{
// foreach (ProductStock o in objs)
// {
// sb.Append(string.Format("<row id='{0}'>", o.PSN));
// sb.Append(string.Format("<cell>{0}</cell>", o.PSN));
// sb.Append(string.Format("<cell>{0}</cell>", o.WorkOrder));
// sb.Append(string.Format("<cell>{0}</cell>", o.MANUFACTURE));
// sb.Append(string.Format("<cell>{0}</cell>", o.DOCUMENTID));
// sb.Append(string.Format("<cell>{0}</cell>", o.StockHouse));
// sb.Append(string.Format("<cell>{0}</cell>", o.ProductCode));
// sb.Append(string.Format("<cell>{0}</cell>", o.ProductName));
// sb.Append(string.Format("<cell>{0}</cell>", o.UNIT));
// sb.Append(string.Format("<cell>{0}</cell>", o.QUANTITY));
// sb.Append(string.Format("<cell>{0}</cell>", o.BatchNumber));
// sb.Append(string.Format("<cell>{0}</cell>", o.FromBy));
// sb.Append(string.Format("<cell>{0}</cell>", o.UpdatedBy));
// sb.Append(string.Format("<cell>{0}</cell>", o.UpdatedDate));
// //sb.Append(string.Format("<cell>View^javascript:MySite.Runner.showDetail({0})^_self</cell>", log.ID));
// sb.Append("</row>");
// }
//}
//sb.Append("</rows>");
//return sb.ToString();
Dictionary <String, Object> map = new Dictionary <String, Object>();
map.Add("total", BLLConstants.I_SHOW_NUM);
map.Add("rows", objs);
Context.Response.Write(JsonConvert.SerializeObject(map));
}