// GET: Order
public ActionResult Index()
{
OrderDAC dac = new OrderDAC();
DataTable dt = dac.GetOrderSalesByMonth();
string data1 = default; //제품1 y축 데이터
List <string> prodNM = new List <string>(); // 제품명
string labels = "1월,2월,3월,4월,5월,6월,7월,8월,9월,10월,11월,12월";
DataView dv = new DataView(dt);
List <int> qtys = new List <int>();
for (int i = 0; i < dv.ToTable().Columns.Count - 1; i++)
{
qtys.Add(Convert.ToInt32(dv.ToTable().Rows[0][i]));
}
data1 = "[" + string.Join(",", qtys.ToArray()) + "]";
qtys.Clear();
ViewBag.Labels = labels;
ViewBag.Label1 = dv.ToTable().Rows[0][12];
ViewBag.data1 = data1;
OrderDAC dac1 = new OrderDAC();
var list = dac1.GetTotalPrieByCom();
ViewBag.C1 = list[0].TotalPrice;
ViewBag.C2 = list[1].TotalPrice;
ViewBag.C3 = list[2].TotalPrice;
ViewBag.C4 = list[3].TotalPrice;
ViewBag.C5 = list[4].TotalPrice;
ViewBag.C6 = list[5].TotalPrice;
ViewBag.C7 = list[6].TotalPrice;
ViewBag.C8 = list[7].TotalPrice;
ViewBag.C9 = list[8].TotalPrice;
ViewBag.B1 = list[0].COMNAME;
ViewBag.B2 = list[1].COMNAME;
ViewBag.B3 = list[2].COMNAME;
ViewBag.B4 = list[3].COMNAME;
ViewBag.B5 = list[4].COMNAME;
ViewBag.B6 = list[5].COMNAME;
ViewBag.B7 = list[6].COMNAME;
ViewBag.B8 = list[7].COMNAME;
ViewBag.B9 = list[8].COMNAME;
Order orders = new Order()
{
Orders = list
};
OrderDAC dac2 = new OrderDAC();
ViewBag.OrderList = dac2.GetOrderList();
return(View(orders));
}
