public void BindData()
{
List <PurchaseOrderItem> PurchaseOrderItemList = POItemDAO.findPOItembypoID(poID);
List <POItem> poItemList = new List <POItem>();
decimal total = 0;
string supID = po.Supplier.supplierID;
for (int i = 0; i < PurchaseOrderItemList.Count(); i++)
{
poItemList.Add(new POItem());
poItemList[i].ItemID = PurchaseOrderItemList[i].itemID;
poItemList[i].OrderQty = PurchaseOrderItemList[i].quantity;
poItemList[i].Description = PurchaseOrderItemList[i].Item.description;
poItemList[i].Price = supItemDAO.getPriceByItemIDAndSupplierID(PurchaseOrderItemList[i].itemID, supID);
poItemList[i].TotalAmount = poItemList[i].Price * poItemList[i].OrderQty;
}
for (int i = 0; i < poItemList.Count(); i++)
{
total = poItemList[i].TotalAmount + total;
}
lblTotal.Text = Convert.ToString(total);
GridView_PODetail.DataSource = poItemList;
GridView_PODetail.DataBind();
}
public void BindData()
{
string strTime = txtMonth.Text;
if (strTime != "")
{
DateTime time = Convert.ToDateTime(strTime);
poIDlist = PoDAO.findPOIDbyMonth(time);
List <PurchaseOrderItem> PurchaseOrderItemList = new List <PurchaseOrderItem>();
for (int i = 0; i < poIDlist.Count; i++)
{
PurchaseOrderItemList.AddRange(POItemDAO.findPOItembypoID(poIDlist[i]));
}
List <MonthlyReorderItem> monthlyItemList = new List <MonthlyReorderItem>();
decimal total = 0;
string supID;
for (int i = 0; i < PurchaseOrderItemList.Count(); i++)
{
monthlyItemList.Add(new MonthlyReorderItem());
monthlyItemList[i].PoID = PurchaseOrderItemList[i].poID;
DateTime orderDate = PoDAO.findOrderDatebyPOid(PurchaseOrderItemList[i].poID);
monthlyItemList[i].OrderDate = orderDate.ToShortDateString();
monthlyItemList[i].ItemID = PurchaseOrderItemList[i].itemID;
monthlyItemList[i].OrderQty = PurchaseOrderItemList[i].quantity;
monthlyItemList[i].Description = PurchaseOrderItemList[i].Item.description;
supID = PoDAO.findSupplierIDbyPOid(PurchaseOrderItemList[i].poID);
monthlyItemList[i].Price = supItemDAO.getPriceByItemIDAndSupplierID(PurchaseOrderItemList[i].itemID, supID);
monthlyItemList[i].TotalAmount = monthlyItemList[i].Price * monthlyItemList[i].OrderQty;
}
for (int i = 0; i < monthlyItemList.Count(); i++)
{
total = monthlyItemList[i].TotalAmount + total;
}
//////////////google chart data
string columnChartData = reportDAO.getGoogleColumnChartData(monthlyItemList);
string tableChartData = reportDAO.getGoogleTableChartData(monthlyItemList);
chartData.InnerHtml = "<script>var columnChartData =" + columnChartData + " ; var tableChartData = " + tableChartData + ";</script>";
}
else
{
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>win.alert('Notice', 'Please select the month！');</script>");
}
}