public SVM_SalesVolumeBLL(int id, bool bycache)
: base(DALClassName)
{
_dal = (SVM_SalesVolumeDAL)_DAL;
FillModel(id, bycache);
}
public static int BatApprove(string IDs, int StaffID)
{
SVM_SalesVolumeDAL dal = (SVM_SalesVolumeDAL)DataAccess.CreateObject(DALClassName);
return(dal.BatApprove(IDs, StaffID));
}
///<summary>
///SVM_SalesVolumeBLL
///</summary>
public SVM_SalesVolumeBLL()
: base(DALClassName)
{
_dal = (SVM_SalesVolumeDAL)_DAL;
_m = new SVM_SalesVolume();
}
public SVM_SalesVolumeBLL(int id)
: base(DALClassName)
{
_dal = (SVM_SalesVolumeDAL)_DAL;
FillModel(id);
}
public static DataTable GetSummaryTotal2(int organizecity, int accountmonth, int clienttype, int flag, int state, int type, int staff)
{
SVM_SalesVolumeDAL dal = (SVM_SalesVolumeDAL)DataAccess.CreateObject(DALClassName);
return(Tools.ConvertDataReaderToDataTable(dal.GetSummaryTotal2(organizecity, accountmonth, clienttype, flag, state, type, staff)));
}
public static int SubmitByStaff(int Organizecity, int Staff, int accountmonth, int clienttype, int flag, int type)
{
SVM_SalesVolumeDAL dal = (SVM_SalesVolumeDAL)DataAccess.CreateObject(DALClassName);
return(dal.SubmitByStaff(Organizecity, Staff, accountmonth, clienttype, flag, type));
}
/// <summary>
/// 获取客户销量(进货、销量、库存)录入记录数量
/// </summary>
/// <param name="AccountMonth"></param>
/// <param name="Client"></param>
/// <returns></returns>
public static DataTable GetCountByClient(int AccountMonth, int Client)
{
SVM_SalesVolumeDAL dal = (SVM_SalesVolumeDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetCountByClient(AccountMonth, Client));
}
public decimal GetByClassify(int Classify, int AccountMonth, int Client)
{
SVM_SalesVolumeDAL dal = (SVM_SalesVolumeDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetByClassify(Classify, AccountMonth, Client));
}
/// <summary>
///
/// </summary>
/// <param name="SalesVolume"></param>
/// <param name="Product"></param>
/// <param name="LotNumber"></param>
/// <param name="Client"></param>
/// <param name="Quantity"></param>
/// <param name="FactoryPrice"></param>
public static void SVMinsertdetail(int SalesVolume, string Code, string LotNumber, int Client, int Quantity, decimal FactoryPrice)
{
SVM_SalesVolumeDAL dal = new SVM_SalesVolumeDAL();
dal.SVMinsertdetail(SalesVolume, Code, LotNumber, Client, Quantity, FactoryPrice);
}
public static decimal GetTotalSalesPriceByOrganizeCity(int organizecity, int accountmonth, int ClientType, int Type)
{
SVM_SalesVolumeDAL dal = (SVM_SalesVolumeDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetTotalSalesPriceByOrganizeCity(organizecity, accountmonth, ClientType, Type));
}
/// <summary>
///
/// </summary>
/// <param name="SheetCode"></param>
/// <param name="SalesDate"></param>
/// <param name="Client"></param>
/// <returns></returns>
public static int SVMinsert(string SheetCode, DateTime SalesDate, int Client)
{
SVM_SalesVolumeDAL dal = new SVM_SalesVolumeDAL();
return(dal.SVMinsert(SheetCode, SalesDate, Client));
}
public static int CheckSalesVolume(int ClientID, DateTime volumedate, int Type, int Flag)
{
SVM_SalesVolumeDAL dal = (SVM_SalesVolumeDAL)DataAccess.CreateObject(DALClassName);
return(dal.CheckSalesVolume(ClientID, volumedate, Type, Flag));
}
public static DataTable InitProductList(int VolumeID, int ClientID, int Type, int Month, bool IsCXP)
{
SVM_SalesVolumeDAL dal = (SVM_SalesVolumeDAL)DataAccess.CreateObject(DALClassName);
return(Tools.ConvertDataReaderToDataTable(dal.InitProductList(VolumeID, ClientID, Type, Month, IsCXP)));
}
public static DataTable GetSummary_GroupByDate(int OrganizeCity, int Supplier, int ClientID, DateTime begintime, DateTime endtime, int Type, int Flag, int DataSource)
{
SVM_SalesVolumeDAL dal = (SVM_SalesVolumeDAL)DataAccess.CreateObject(DALClassName);
return(Tools.ConvertDataReaderToDataTable(dal.GetSummary_GroupByDate(OrganizeCity, Supplier, ClientID, begintime, endtime, Type, Flag, DataSource)));
}
/// <summary>
/// 获取指定管理片区历史平均实际销量(门店实销)
/// </summary>
/// <param name="OrganizeCity"></param>
/// <param name="MonthCount"></param>
/// <param name="IncludeChildOrganizeCity"></param>
/// <returns></returns>
public static decimal GetAvgVolume(int OrganizeCity, int EndMonth, int MonthCount, bool IncludeChildOrganizeCity)
{
SVM_SalesVolumeDAL dal = (SVM_SalesVolumeDAL)DataAccess.CreateObject(DALClassName);
return(dal.GetAvgVolume(OrganizeCity, EndMonth, MonthCount, IncludeChildOrganizeCity));
}
