/// <summary>
/// 查询所有的出库数据
/// </summary>
/// <returns></returns>
public ActionResult StockOut()
{
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 = SaleDepotDAL.FindByYCount(d, 0) + SaleDepotDAL.FindByYCount(d, 1); //销售出库数
int sr = ProduceOutDepotDAL.FindByYCount(d, 0) + ProduceOutDepotDAL.FindByYCount(d, 1); //生产领料数
int qr = OtherOutDepotDAL.FindByYCount(d); //其它出库
int st = StockReturnDAL.FindByYCount(d, 0) + StockReturnDAL.FindByYCount(d, 1); //采购退货
dts.Add(cr + sr + qr + st);
}
return(Json(dts));
}
/// <summary>
/// 条件查询
/// </summary>
/// <param name="PIDID"></param>
/// <param name="DepotID"></param>
/// <param name="PIDDate"></param>
/// <param name="UsersName"></param>
/// <param name="PIDState"></param>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <param name="count"></param>
/// <returns></returns>
public static List <OtherOutDepot> Find(string OODID, string DepotID, string OODDate, string UsersName, int OODState, int PageIndex, int PageSize, out int count)
{
return(OtherOutDepotDAL.Find(OODID, DepotID, OODDate, UsersName, OODState, PageIndex, PageSize, out count));
}
/// <summary>
/// 审核采购订单
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int CKInDepot(string id, int userid)
{
return(OtherOutDepotDAL.CKInDepot(id, userid));
}
/// <summary>
/// 根据ID查询采购单信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
internal static OtherOutDepot GetByID(string id)
{
return(OtherOutDepotDAL.GetByID(id));
}
/// <summary>
/// 修改【---事务---】
/// </summary>
/// <param name="dp"></param>
/// <returns></returns>
public static int EdiStocks(OtherOutDepot dep, List <OtherOutDepotDetail> list)
{
return(OtherOutDepotDAL.EdiStocks(dep, list));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int DelStocks(string id)
{
return(OtherOutDepotDAL.DelStocks(id));
}
/// <summary>
/// 查询所有
/// </summary>
/// <returns></returns>
public static List <OtherOutDepot> GetAll()
{
return(OtherOutDepotDAL.GetAll());
}