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