public ActionResult GetSaleDepotStateCount()
{
List <int> list = new List <int>();
list.Add(SaleDepotDAL.FindStateCount(0));
list.Add(SaleDepotDAL.FindStateCount(1));
return(Json(list));
}
public ActionResult GetSaleDepotCountByMtoth1()
{
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(SaleDepotDAL.FindByYCount(d, 1));
}
return(Json(dts));
}
/// <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="id"></param>
/// <returns></returns>
internal static int DelStocks(string id)
{
return(SaleDepotDAL.DelStocks(id));
}
/// <summary>
/// 审核销售出库单
/// </summary>
/// <param name="id"></param>
/// <param name="userid"></param>
/// <returns></returns>
internal static int CKInDepot(string id, int userid)
{
return(SaleDepotDAL.CKInDepot(id, userid));
}
/// <summary>
/// 根据ID查询销售出库单信息
/// </summary>
/// <param name="id"></param>
internal static SaleDepot GetSaleDepotByID(string id)
{
return(SaleDepotDAL.GetSaleDepotByID(id));
}
/// <summary>
/// 修改销售出库单
/// </summary>
/// <param name="qp"></param>
/// <param name="list"></param>
/// <returns></returns>
internal static int EditStocks(SaleDepot qp, List <SaleDepotDetail> list)
{
return(SaleDepotDAL.EditStocks(qp, list));
}
/// <summary>
/// 条件查询
/// </summary>
/// <param name="COID"></param>
/// <param name="CusID"></param>
/// <param name="CODate"></param>
/// <param name="CORefDate"></param>
/// <param name="UsersName"></param>
/// <param name="COState"></param>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <param name="count"></param>
/// <returns></returns>
internal static List <SaleDepot> Find(string SDID, string CusID, string DepotID, string SDDate, string UsersName, int SDState, int PageIndex, int PageSize, out int count)
{
return(SaleDepotDAL.Find(SDID, CusID, DepotID, SDDate, UsersName, SDState, PageIndex, PageSize, out count));
}
/// <summary>
/// 查询所有
/// </summary>
/// <returns></returns>
internal static List <SaleDepot> GetAll()
{
return(SaleDepotDAL.GetAll());
}
