public GridPage <List <OddMinusSale> > GetOddMinusSale([FromBody] ReqTimeBetween req)
{
var res = new GridPage <List <OddMinusSale> >()
{
code = ResCode.Success
};
try
{
using (var uow = _uowProvider.CreateUnitOfWork())
{
var sdatep = new SqlParameter("@Sdate", req.startTime);
var edatep = new SqlParameter("@Edate", req.endTime);
var repository = uow.GetRepository <OddMinusSale>();
var data = repository.FromProcedure("EXECUTE OddMinusSale_sp @Sdate,@Edate", sdatep, edatep).ToList();
res.data = data;
return(res);
}
}
catch (Exception ex)
{
res.code = ResCode.ServerError;
res.msg = ex.Message;
}
return(res);
}
public ActionResult <DataRes <List <PlateformLevel> > > Index([FromBody] ReqTimeBetween req)
{
DateTime dt = DateTime.Now;
string startTime = req.startTime;
string endTime = req.endTime;
if (string.IsNullOrEmpty(startTime))
{
startTime = dt.AddDays(1 - dt.Day).Date.ToString();
}
if (string.IsNullOrEmpty(endTime))
{
endTime = dt.AddDays(1 - dt.Day).AddMonths(1).Date.ToString();
}
else
{
endTime = DateTime.Parse(endTime).AddDays(1).Date.ToString();
}
if (string.IsNullOrWhiteSpace(req.type))
{
req.type = "发块";
}
var res = new GridPage <List <PlateformLevel> >()
{
code = ResCode.Success
};
try
{
using (var uow = _uowProvider.CreateUnitOfWork())
{
var sdatep = new SqlParameter("@Sdate", req.startTime);
var edatep = new SqlParameter("@Edate", req.endTime);
var type = new SqlParameter("@SaleType", req.type);
var repository = uow.GetRepository <PlateformLevel>();
var data = repository.FromProcedure("EXECUTE PlateformLevel_Sp @Sdate,@Edate,@SaleType", sdatep, edatep, type).ToList();
res.data = data;
return(res);
}
}
catch (Exception ex)
{
res.code = ResCode.ServerError;
res.msg = ex.Message;
}
return(res);
}
public ActionResult <DataRes <List <TotalSale> > > Index([FromBody] ReqTimeBetween req)
{
var res = new DataRes <List <TotalSale> >()
{
code = ResCode.Success
};
using (var uow = _uowProvider.CreateUnitOfWork())
{
var sdatep = new SqlParameter("@Sdate", req.startTime);
var edatep = new SqlParameter("@Edate", req.endTime);
var repository = uow.GetRepository <TotalSale>();
var data = repository.FromProcedure("EXECUTE TotalSale_sp @Sdate,@Edate", sdatep, edatep).ToList();
res.data = data;
return(res);
}
}
public GridPage <List <WaveBlockReportModel> > GetWeavingBlock([FromBody] ReqTimeBetween req)
{
var res = new GridPage <List <WaveBlockReportModel> >()
{
code = ResCode.Success
};
DateTime dt = DateTime.Now;
string startTime = req.startTime;
string endTime = req.endTime;
string type = req.type;
if (string.IsNullOrEmpty(startTime))
{
startTime = dt.AddDays(1 - dt.Day).Date.ToString();
}
if (string.IsNullOrEmpty(endTime))
{
endTime = dt.AddDays(1 - dt.Day).AddMonths(1).Date.ToString();
}
else
{
endTime = DateTime.Parse(endTime).AddDays(1).Date.ToString();
}
try
{
using (var uow = _uowProvider.CreateUnitOfWork())
{
var repository = uow.GetRepository <WavingBlock>();;
var sdatep = new SqlParameter("@startDate", startTime);
var edatep = new SqlParameter("@endDate", endTime);
var sqltype = new SqlParameter("@type", type);
var weaving = repository.FromProcedure("EXECUTE GetWavingBlock_sp @startDate,@endDate,@type", sdatep, edatep, sqltype).ToList();
int total = 0;
List <WaveBlockReportModel> dataList = new List <WaveBlockReportModel>();
foreach (var item in weaving)
{
int tempNum = item.Magento + item.Shopify + item.Aliexpress + item.Amazon + item.Ebay;
total += tempNum;
WaveBlockReportModel model = new WaveBlockReportModel();
model.Size = item.Size;
model.SizeTotal = tempNum;
model.shopifySizeTotal = item.Shopify;
model.shopifySizeTotalRatio = item.ShopifyTotalRatio.ToString() + "%";
model.aliSizeTotal = item.Aliexpress;
model.aliSizeTotalRatio = item.AliexpressTotalRatio.ToString() + "%";
model.ebaySizeTotal = item.Ebay;
model.ebaySizeTotalRatio = item.EbayTotalRatio.ToString() + "%";
model.amazSizeTotal = item.Amazon;
model.amazSizeTotalRatio = item.AmazonTotalRatio.ToString() + "%";
model.magentoSizeTotal = item.Magento;
model.magentoSizeTotalRatio = item.MagentoTotalRatio.ToString() + "%";
dataList.Add(model);
}
foreach (var item in dataList)
{
item.Total = total;
decimal tempDec = (decimal)item.SizeTotal / item.Total * 100;
item.SizeTotalRatio = Math.Round(tempDec, 2, MidpointRounding.AwayFromZero).ToString() + "%";
}
res.data = dataList;
}
}
catch (Exception ex)
{
res.code = ResCode.ServerError;
res.msg = ex.Message;
}
return(res);
}
public GridPage <List <DensityReportModel> > GetDensity([FromBody] ReqTimeBetween req)
{
DateTime dt = DateTime.Now;
string startTime = req.startTime;
string endTime = req.endTime;
if (string.IsNullOrEmpty(startTime))
{
startTime = dt.AddDays(1 - dt.Day).Date.ToString();
}
if (string.IsNullOrEmpty(endTime))
{
endTime = dt.AddDays(1 - dt.Day).AddMonths(1).Date.ToString();
}
else
{
endTime = DateTime.Parse(endTime).AddDays(1).Date.ToString();
}
var res = new GridPage <List <DensityReportModel> >()
{
code = ResCode.Success
};
try
{
using (var uow = _uowProvider.CreateUnitOfWork())
{
var repository = uow.GetRepository <HeadgearDensity>();;
var sdatep = new SqlParameter("@startDate", startTime);
var edatep = new SqlParameter("@endDate", endTime);
var result = repository.FromProcedure("EXECUTE GetHeadgearDensity_sp @startDate,@endDate", sdatep, edatep).ToList();
List <DensityReportModel> list = new List <DensityReportModel>();
foreach (var item in result)
{
DensityReportModel model = new DensityReportModel();
model.Style = item.Style;
model.Total = item.Density134130 + item.Density134150 + item.Density134180
+ item.Density136130 + item.Density136150 + item.Density136180 + item.Density136250
+ item.Density360130 + item.Density360150 + item.Density360180 + item.Density360250
+ item.Density44130 + item.Density44150 + item.Density44180
+ item.DensityHand130 + item.Densityhand150 + item.Densityhand180
+ item.Densitymachine + item.Densitymachine130;
model.Density134130Total = item.Density134130;
model.Density134150Total = item.Density134150;
model.Density134180Total = item.Density134180;
model.Density136130Total = item.Density136130;
model.Density136150Total = item.Density136150;
model.Density136180Total = item.Density136180;
model.Density136250Total = item.Density136250;
model.Density360130Total = item.Density360130;
model.Density360150Total = item.Density360150;
model.Density360180Total = item.Density360180;
model.Density360250Total = item.Density360250;
model.Density44130Total = item.Density44130;
model.Density44150Total = item.Density44150;
model.Density44180Total = item.Density44180;
model.DensityHand130Total = item.DensityHand130;
model.DensityHand150Total = item.Densityhand150;
model.DensityHand180Total = item.Densityhand180;
model.DensityMachine130Total = item.Densitymachine;
model.DensityMachineTotal = item.Densitymachine130;
list.Add(model);
}
res.data = list;
}
}
catch (Exception ex)
{
res.code = ResCode.ServerError;
res.msg = ex.Message;
}
return(res);
}
