/// <summary>
/// 販売データを取得して返却用オブジェクトを生成する
/// </summary>
/// <param name="param">条件パラメーター</param>
/// <param name="result">返却用オブジェクト</param>
/// <param name="months">取得期間(単位は月、省略時は12ヶ月)</param>
/// <returns>処理結果のステータスコード</returns>
public HttpStatusCode GetSalesViews(SalesViewApiParameterModel param, out List <SalesViewApiModel> result, int months = 12)
{
this.logMessage = string.Empty;
result = null;
try
{
// 必須パラメーターのチェック
if (param.GroupId.HasValue == false && param.MakerId.HasValue == false)
{
WriteAppLog(this.ToString() + ".GetSalesViews", ErrorMessage.CKeyError);
return(HttpStatusCode.BadRequest);
}
if (param.Year.HasValue == false)
{
WriteAppLog(this.ToString() + ".GetSalesViews", ErrorMessage.CYearError);
return(HttpStatusCode.BadRequest);
}
this.logMessage += " Year=" + param.Year.ToString();
// 商品一覧の取得
List <ProductApiModel> products = this.GetProductList(param);
List <int> productIds = products.Select(p => p.Id).ToList <int>();
// 事業所リストの取得
ICollection <OfficeModel> office = dbContext.OfficeModels.Where(o => o.Deleted == false).OrderBy(o => o.Code).ToList();
// データ取得準備
string productList = string.Join(",", productIds);
string sql = ContextResources.SelectSalesViews.Replace("@p2", productList);
// 全体の販売実績データ
List <SalesViewsTempModel> salesList;
DateTime startDate = DateTime.Parse((param.Year - 1).ToString() + "/10/1");
DateTime endDate = startDate.AddMonths(months);
salesList = dbContext.Database.SqlQuery <SalesViewsTempModel>(sql, startDate, endDate).ToList <SalesViewsTempModel>();
// 事業所別
List <SalesOfficeTempModel> salesOfficeList;
sql = ContextResources.SelectOfficesSalesViews.Replace("@p2", productList);
salesOfficeList = dbContext.Database.SqlQuery <SalesOfficeTempModel>(
sql, startDate.AddYears(-1), endDate
).ToList <SalesOfficeTempModel>();
// 返却用の準備
result = new List <SalesViewApiModel>();
foreach (var product in products)
{
// 在庫予測計算用に１ヶ月多めに取得（貿易のみ）
DateTime check = startDate.AddMonths(-1);;
SalesViewApiModel addModel = new SalesViewApiModel();
addModel.Product = product;
addModel.SalesList = new List <SalesViewsTempModel>();
addModel.OfficeSales = new List <ICollection <SalesOfficeTempModel> >();
for (; check <= endDate; check = check.AddMonths(1))
{
SalesViewsTempModel work = salesList.Where(x => x.product_id == addModel.Product.Id)
.Where(x => x.detail_date == check).SingleOrDefault();
if (work == null)
{
SalesViewsTempModel tempModel = new SalesViewsTempModel();
tempModel.product_id = addModel.Product.Id;
tempModel.detail_date = check;
addModel.SalesList.Add(tempModel);
}
else
{
addModel.SalesList.Add(work);
}
ICollection <SalesOfficeTempModel> workOffice = new List <SalesOfficeTempModel>();
foreach (var ofs in office)
{
SalesOfficeTempModel ofsData = salesOfficeList.Where(x => x.product_id == addModel.Product.Id)
.Where(x => x.detail_date == check).Where(x => x.office_id == ofs.Id).SingleOrDefault();
if (ofsData == null)
{
SalesOfficeTempModel tempModel = new SalesOfficeTempModel();
tempModel.product_id = product.Id;
tempModel.detail_date = check;
tempModel.office_id = ofs.Id;
tempModel.office_name = ofs.Name;
workOffice.Add(tempModel);
}
else
{
workOffice.Add(ofsData);
}
}
addModel.OfficeSales.Add(workOffice);
}
result.Add(addModel);
}
WriteAppLog(this.ToString() + ".GetSalesViews", ErrorMessage.CCompleteMulti.Replace("@message", this.logMessage));
return(HttpStatusCode.OK);
}
catch (Exception ex)
{
WriteAppLog(this.ToString() + ".GetSalesViews", ErrorMessage.CException + ex.Message);
return(HttpStatusCode.InternalServerError);
}
}
/// <summary>
/// 販売データを取得して返却用オブジェクトを生成する
/// </summary>
/// <param name="param">条件パラメーター</param>
/// <param name="result">返却用オブジェクト</param>
/// <param name="productId">対象商品ＩＤ</param>
/// <param name="months">取得期間(単位は月、省略時は12ヶ月)</param>
/// <returns>処理結果のステータスコード</returns>
public HttpStatusCode GetSalesView(SalesViewApiParameterModel param, out SalesViewApiModel result, int productId = 0, int months = 12)
{
this.logMessage = string.Empty;
result = null;
try
{
// パラメータは必須
if (productId <= 0)
{
WriteAppLog(this.ToString() + ".GetSalesView/" + productId.ToString(), ErrorMessage.CParamError);
return(HttpStatusCode.BadRequest);
}
if (param.Year.HasValue == false)
{
WriteAppLog(this.ToString() + ".GetSalesView/" + productId.ToString(), ErrorMessage.CYearError);
return(HttpStatusCode.BadRequest);
}
ProductApiModel product = dbContext.ProductModels.Where(p => p.Id == productId).ProjectTo <ProductApiModel>().SingleOrDefault();
if (product == null)
{
WriteAppLog(this.ToString() + ".GetSalesView/" + productId.ToString(), ErrorMessage.CProductError);
return(HttpStatusCode.BadRequest);
}
List <SalesViewsTempModel> salesList;
DateTime startDate = DateTime.Parse((param.Year - 1).ToString() + "/10/1");
DateTime endDate = startDate.AddMonths(months);
salesList = dbContext.Database.SqlQuery <SalesViewsTempModel>(
ContextResources.SelectSalesViews, startDate, endDate, product.Id
).ToList <SalesViewsTempModel>();
ICollection <OfficeModel> office = dbContext.OfficeModels.Where(o => o.Deleted == false).OrderBy(o => o.Code).ToList();
List <SalesOfficeTempModel> salesOfficeList;
salesOfficeList = dbContext.Database.SqlQuery <SalesOfficeTempModel>(
ContextResources.SelectOfficesSalesViews, startDate, endDate, product.Id
).ToList <SalesOfficeTempModel>();
// 在庫予測計算用に１ヶ月多めに取得（貿易のみ）
DateTime check = startDate.AddMonths(-1);
result = new SalesViewApiModel();
result.Product = product;
result.SalesList = new List <SalesViewsTempModel>();
result.OfficeSales = new List <ICollection <SalesOfficeTempModel> >();
for (; check <= endDate; check = check.AddMonths(1))
{
SalesViewsTempModel work = salesList.Where(x => x.product_id == product.Id)
.Where(x => x.detail_date == check).SingleOrDefault();
if (work == null)
{
SalesViewsTempModel tempModel = new SalesViewsTempModel();
tempModel.product_id = product.Id;
tempModel.detail_date = check;
result.SalesList.Add(tempModel);
}
else
{
result.SalesList.Add(work);
}
ICollection <SalesOfficeTempModel> workOffice = new List <SalesOfficeTempModel>();
foreach (var value in office)
{
SalesOfficeTempModel wk = salesOfficeList.Where(so => so.detail_date == check).Where(so => so.office_id == value.Id).SingleOrDefault();
if (wk == null)
{
SalesOfficeTempModel tempModel = new SalesOfficeTempModel();
tempModel.product_id = product.Id;
tempModel.detail_date = check;
tempModel.office_id = value.Id;
tempModel.office_name = value.Name;
tempModel.sales_plan = 0;
tempModel.sales_actual = 0;
workOffice.Add(tempModel);
}
else
{
workOffice.Add(wk);
}
}
result.OfficeSales.Add(workOffice);
}
WriteAppLog(this.ToString() + ".GetSalesView/" + productId.ToString(), ErrorMessage.CCompleteSingle.Replace("@year", param.Year.ToString()));
return(HttpStatusCode.OK);
}
catch (Exception ex)
{
WriteAppLog(this.ToString() + ".GetSalesView/" + productId.ToString(), ErrorMessage.CException + ex.Message);
return(HttpStatusCode.InternalServerError);
}
}
