/// <summary>
/// 查询采购单审核数和未审核数
/// </summary>
/// <returns></returns>
public ActionResult GetStockInDepotStateCount()
{
List <int> list = new List <int>();
list.Add(StockInDepotDAL.FindStateCount(0));
list.Add(StockInDepotDAL.FindStateCount(1));
return(Json(list));
}
/// <summary>
/// 查询近12个月的已审核采购入库单个数
/// </summary>
/// <returns></returns>
public ActionResult GetStockInDepotCountByMtoth1()
{
List <int> dts = new List <int>();
DateTime dt = DateTime.Now.AddYears(-1);
for (int i = 1; i <= 12; i++)
{
DateTime d = dt.AddMonths(i);
dts.Add(StockInDepotDAL.FindByYCount(d, 1));
}
return(Json(dts));
}
/// <summary>
/// 查询所有的入库数据
/// </summary>
/// <returns></returns>
public ActionResult StockIn()
{
List <int> dts = new List <int>();
DateTime dt = DateTime.Now.AddYears(-1);
for (int i = 1; i <= 12; i++)
{
DateTime d = dt.AddMonths(i);
int cr = StockInDepotDAL.FindByYCount(d, 0) + StockInDepotDAL.FindByYCount(d, 1); //采购入库数
int sr = ProduceInDepotDAL.FindByYCount(d, 0) + ProduceInDepotDAL.FindByYCount(d, 1); //生产入库
int qr = OtherInDepotDAL.FindByYCount(d); //其它入库
int st = SaleReturnDAL.FindByYCount(d, 0) + SaleReturnDAL.FindByYCount(d, 1); //销售退货
dts.Add(cr + sr + qr + st);
}
return(Json(dts));
}
public static int CKStockIn(string id, int userid)
{
return(StockInDepotDAL.CKStockIn(id, userid));
}
/// <summary>
/// 条件查询
/// </summary>
/// <param name="SIDID"></param>
/// <param name="UsersName"></param>
/// <param name="PPName"></param>
/// <param name="StockID"></param>
/// <param name="SIDDate"></param>
/// <param name="SIDDeliver"></param>
/// <param name="SIDData"></param>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <param name="count"></param>
/// <returns></returns>
public static List <StockInDepot> Find(string SIDID, string UsersName, string PPID, string DepotID, string SIDDate, int SIDData, int PageIndex, int PageSize, out int count)
{
return(StockInDepotDAL.Find(SIDID, UsersName, PPID, DepotID, SIDDate, SIDData, PageIndex, PageSize, out count));
}
internal static StockInDepot GetByID(string id)
{
return(StockInDepotDAL.GetByID(id));
}
/// <summary>
/// 审核采购订单
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int CKStocks(string id)
{
return(StockInDepotDAL.CKStocks(id));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="dp"></param>
/// <returns></returns>
public static int EdiStocks(StockInDepot dp, List <StockInDepotDetail> list)
{
return(StockInDepotDAL.EdiStocks(dp, list));
}
/// <summary>
/// 添加
/// </summary>
/// <param name="dep"></param>
/// <returns></returns>
public static int AddStocks(StockInDepot dep, List <StockInDepotDetail> list)
{
return(StockInDepotDAL.AddStocks(dep, list));
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <returns></returns>
public static List <StockInDepot> GetAllPage(int PageIndex, int PageSize)
{
return(StockInDepotDAL.GetAllPage(PageIndex, PageSize));
}
/// <summary>
/// 查询所有
/// </summary>
/// <returns></returns>
public static List <StockInDepot> GetAll()
{
return(StockInDepotDAL.GetAll());
}
