public JsonResult GetDateCustomer()
{
List <string> label = new List <string>();
List <int> data = new List <int>();
CustomerService os = new CustomerService();
CustomerDateListViewModel result = os.GetDateCustomer();
foreach (var item in result.Item)
{
label.Add(item.Month.ToString() + "月");
data.Add(item.Quantity);
}
var datas = new { label, data };
return(Json(datas, JsonRequestBehavior.AllowGet));
}
public CustomerDateListViewModel GetDateCustomer()
{
CustomerDateListViewModel result = new CustomerDateListViewModel();
result.Item = new List <CustomerDateViewModelcs>();
DBModel context = new DBModel();
var tmp = context.Database.SqlQuery <CustomerDateViewModelcs>(@"select MONTH( Customer_Date)Month, COUNT(*)Quantity
FROM[dbo].[Customer]
Group By MONTH(Customer_Date);"
);
foreach (var i in tmp)
{
CustomerDateViewModelcs sqv = new CustomerDateViewModelcs()
{
Month = i.Month,
Quantity = i.Quantity
};
result.Item.Add(sqv);
}
return(result);
}
