// GET: SalesChart
public ActionResult Chart(int Year = 2020)
{
PriceProductDAC dac = new PriceProductDAC();
List <PriceProductList> SalesList = dac.TotalSales(Year);
List <PriceProductList> ProductList = dac.TotalProducts(Year);
sb.Append("[");
//ProdSB.Append("[");
ProdSBNum.Append("[");
int j = 0;
// 1월부터 12월까지 표시
for (int i = 1; i <= 12; i++)
{
if (SalesList.Find(p => p.Mon == i) == null)
{
sb.Append(0 + ",");
}
else if (SalesList.Find(p => p.Mon == i).Mon.Equals(i))
{
sb.Append(SalesList[j].Total_Price + ",");
j++;
}
}
for (int i = 0; i < ProductList.Count; i++)
{
if (i == ProductList.Count - 1)
{
ProdSB.Append("" + ProductList[i].Product_Name + "");
ProdSBNum.Append(ProductList[i].Product_Count + "]");
break;
}
ProdSB.Append("" + ProductList[i].Product_Name + ",");
ProdSBNum.Append(ProductList[i].Product_Count + ",");
}
int lastindex = sb.ToString().LastIndexOf(',');
string Result = sb.ToString().Substring(0, lastindex) + "]";
ChartModel model = new ChartModel
{
// 그래프 차트
DataString = Result,
MainString = "매출현황",
Year = Year,
// 도넛 차트
DoughnutDataString = ProdSB.ToString(),
Product_Count = ProdSBNum.ToString()
};
// ex) [0,0,0,1,3,4,5,8,9,1,3,7] 방식으로 나옴
return(View(model));
}
// 영업 단가 관리
public ActionResult SellPrice(string Name)
{
PriceProductDAC dac = new PriceProductDAC();
model.SellPrice = (from items in dac.AllSellPriceList()
where items.Product_Name.Contains(Name)
select items).ToList();
return(View(model));
}
// 자재 단가 관리
public ActionResult ProductPrice(string Name, string Category = "전체")
{
PriceProductDAC dac = new PriceProductDAC();
// 몇개 없으니 직접 추가함.
List <string> comboList = new List <string>();
comboList.Add("전체");
comboList.Add("업체명");
comboList.Add("제품명");
model.comboList = comboList;
if (Category == "전체")
{
model.ProductPrice = (from items in dac.AllProductPriceList()
where items.Product_Name.Contains(Name) || items.Company_Name.Contains(Name)
select items).ToList();
}
else if (Category == "업체명")
{
model.ProductPrice = (from items in dac.AllProductPriceList()
where items.Company_Name.Contains(Name)
select items).ToList();
}
else if (Category == "제품명")
{
model.ProductPrice = (from items in dac.AllProductPriceList()
where items.Product_Name.Contains(Name)
select items).ToList();
}
return(View(model));
}
