/// <summary>
/// 查询日结列表所需数据
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageCount"></param>
/// <param name="orderBy"></param>
/// <param name="TotalCount"></param>
/// <param name="day"></param>
/// <returns></returns>
public static DataTable SelectDayInfo(int pageIndex, int pageCount, string orderBy, ref int TotalCount, string day, string DeptID)
{
try
{
return(SubDayEndDBHelper.SelectDayInfo(pageIndex, pageCount, orderBy, ref TotalCount, day, DeptID));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 从分店销售订单表中分离出当天某发货模式下的信息
/// </summary>
/// <param name="ProductID"></param>
/// <param name="BatchNo"></param>
/// <param name="StorageID"></param>
/// <param name="DailyDate"></param>
/// <param name="CompanyCD"></param>
/// <returns></returns>
public static DataTable GetSaleInfo(string ProductID, string BatchNo, string DeptID, string DailyDate, string CompanyCD, int SendModle)
{
return(SubDayEndDBHelper.GetSaleInfo(ProductID, BatchNo, DeptID, DailyDate, CompanyCD, SendModle));
}
/// <summary>
/// 获得库存流水账表中取得当天的某个物品的各种单据金额信息
/// </summary>
/// <param name="ProductID"></param>
/// <param name="BatchNo"></param>
/// <param name="StorageID"></param>
/// <param name="DailyDate"></param>
/// <param name="CompanyCD"></param>
/// <param name="ItemsType"></param>
/// <returns></returns>
public static decimal GetDayItemsPrice(string ProductID, string BatchNo, string StorageID, string DailyDate, string CompanyCD, int ItemsType)
{
return(SubDayEndDBHelper.GetDayItemsPrice(ProductID, BatchNo, StorageID, DailyDate, CompanyCD, ItemsType));
}
/// <summary>
/// 获得库存流水账表中取得当天的某个物品的各种单据数量信息
/// </summary>
/// <param name="ProductID"></param>
/// <param name="BatchNo"></param>
/// <param name="StorageID"></param>
/// <param name="DailyDate"></param>
/// <param name="CompanyCD"></param>
/// <param name="ItemsType"></param>
/// <returns></returns>
public static decimal GetDayItemsCount(string ProductID, string BatchNo, string DeptID, string DailyDate, string CompanyCD, int ItemsType)
{
return(SubDayEndDBHelper.GetDayItemsCount(ProductID, BatchNo, DeptID, DailyDate, CompanyCD, ItemsType));
}
/// <summary>
/// 获得第一天的某个物品的结存量
/// </summary>
/// <param name="ProductID"></param>
/// <param name="BatchNo"></param>
/// <param name="StorageID"></param>
/// <param name="DailyDate"></param>
/// <param name="CompanyCD"></param>
/// <returns></returns>
public static decimal GetFirstDayCount(string ProductID, string BatchNo, string CompanyCD, string DeptID)
{
return(SubDayEndDBHelper.GetFirstDayCount(ProductID, BatchNo, CompanyCD, DeptID));
}
/// <summary>
/// 从分仓存量表中获取改公司分店下的所有产品信息
/// </summary>
/// <param name="CompanyCD"></param>
/// <returns></returns>
public static DataTable GetCompanyProductList(string CompanyCD, string DeptID)
{
return(SubDayEndDBHelper.GetCompanyProductList(CompanyCD, DeptID));
}
/// <summary>
/// 返回第一次日结的日期(FirstDailyDate)和最后一次做日结的日期(LastDailyDate)
/// </summary>
/// <param name="CompanyCD"></param>
/// <returns></returns>
public static DataTable GetOperateDateInfo(string CompanyCD, string deptid)
{
return(SubDayEndDBHelper.GetOperateDateInfo(CompanyCD, deptid));
}
/// <summary>
/// 判断流水账表是否有当天的业务
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="day"></param>
/// <returns></returns>
public static bool isHaveData(string CompanyCD, string deptID, string day)
{
return(SubDayEndDBHelper.isHaveData(CompanyCD, deptID, day));
}
/// <summary>
/// 判断前一天是否做日结(false 是第一次日结)
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="day"></param>
/// <returns></returns>
public static bool CheckFirstOperate(string CompanyCD, string deptID)
{
return(SubDayEndDBHelper.CheckFirstOperate(CompanyCD, deptID));
}
/// <summary>
/// 判断前一天是否做日结
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="day"></param>
/// <returns></returns>
public static bool CheckDay(string CompanyCD, string day, string DeptID)
{
return(SubDayEndDBHelper.CheckDay(CompanyCD, day, DeptID));
}
/// <summary>
/// 获取日结明细信息
/// </summary>
/// <param name="ProductID"></param>
/// <param name="BatchNo"></param>
/// <param name="DeptID"></param>
/// <param name="DailyDate"></param>
/// <param name="CompanyCD"></param>
/// <returns></returns>
public static DataTable GetSubStorageDailyInfo(string ProductID, string BatchNo, string DeptID, string DailyDate, string CompanyCD)
{
return(SubDayEndDBHelper.GetSubStorageDailyInfo(ProductID, BatchNo, DeptID, DailyDate, CompanyCD));
}
