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