private void getTopJson() { this.enterOrder.Value = ""; this.enterAmount.Value = ""; List <OrderTop> feeList = new List <OrderTop>(); //把dataset转换成list OrderTop model = null; DataSet ds = orderBll.GetOrderTop(10); DataTable dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { model = new OrderTop(); model.Amount = YSWL.Common.Globals.SafeDecimal(dr["TotalAmount"], 0); model.AmountFee = YSWL.Common.Globals.SafeDecimal(dr["TotalFee"], 0); model.EnterOrder = dr["EnterOrder"].ToString(); feeList.Add(model); } this.enterOrder.Value = String.Join(",", feeList.Select(c => c.EnterOrder)); this.enterAmount.Value = String.Join(",", feeList.Select(c => c.Amount)); this.enterFee.Value = String.Join(",", feeList.Select(c => c.AmountFee)); }
public void LoadData() { DateTime today = DateTime.Now.Date; DateTime now = DateTime.Now; List <OrderTop> opdertop = new List <OrderTop>(); var or = OrderController.Report(today.ToString(), now.ToString()); if (or != null) { foreach (var item in or) { List <OrderTop> tam = new List <OrderTop>(); OrderTop order = new OrderTop(); bool check = opdertop.Any(x => x.CusID == item.CustomerID); if (check == true) { for (int i = 0; i < opdertop.Count(); i++) { if (opdertop[i].CusID == item.CustomerID) { var ordetail = OrderDetailController.GetByOrderID(item.ID); if (ordetail != null) { int quantityp = 0; foreach (var temp in ordetail) { quantityp += Convert.ToInt32(temp.Quantity); } opdertop[i].Quantity += quantityp; } tam.Add(opdertop[i]); } else { tam.Add(opdertop[i]); } } opdertop = tam; tam = null; } else { var cus = CustomerController.GetByID(item.CustomerID.Value); if (cus != null) { order.CusID = cus.ID; order.CusName = cus.CustomerName; order.CreateBy = cus.CreatedBy; order.CusZalo = cus.Zalo; order.CusFB = cus.Facebook; order.CusNick = cus.Nick; order.CusAddress = cus.CustomerAddress; } var ordetail = OrderDetailController.GetByOrderID(item.ID); if (ordetail != null) { int quantityp = 0; foreach (var temp in ordetail) { quantityp += Convert.ToInt32(temp.Quantity); } order.Quantity = quantityp; } opdertop.Add(order); } } } if (opdertop.Count() > 0) { pagingall(opdertop.OrderByDescending(x => x.Quantity).Take(10).ToList()); } }