public ActionResult ExportSummary(long hotelId = 0, long warehouseId = 0, string sdate = "", string edate = "", string searcValue = "")
{
var tb = new DataTable();
tb.Columns.Add("仓库");
tb.Columns.Add("货品名称");
tb.Columns.Add("库存单位");
tb.Columns.Add("总数量");
tb.Columns.Add("总金额");
tb.Columns.Add("来源");
var apiResult = new APIResult();
var user = UserContext.CurrentUser;
List <StockOrderDetails> list = StockOrderDetailsBll.ExportInstockSummary(hotelId, warehouseId, sdate, edate, searcValue);
foreach (StockOrderDetails item in list)
{
tb.Rows.Add(new string[] {
item.WarehouseName,
item.CommondityName,
item.CommondityUnit,
item.Quantity.ToString(),
item.TotalPrice.ToString(),
item.HotelName,
});
}
ExcelHelper.ExportByWeb(tb, "入库明汇总表", "入库汇总报表.xls");
return(Json(apiResult));
}
public ActionResult ExportDetails(long hotelId = 0, long warehouseId = 0, string sdate = "", string edate = "", string commondityName = "", string creator = "", int dtype = 0)
{
var tb = new DataTable();
tb.Columns.Add("单据号");
tb.Columns.Add("单据类型");
tb.Columns.Add("出库时间");
tb.Columns.Add("仓库");
tb.Columns.Add("货品名称");
tb.Columns.Add("单位");
tb.Columns.Add("单价");
tb.Columns.Add("数量");
tb.Columns.Add("合计金额");
tb.Columns.Add("来源");
tb.Columns.Add("操作人");
var apiResult = new APIResult();
var user = UserContext.CurrentUser;
List <StockOrderDetails> list = StockOrderDetailsBll.ExportInstockDetails(hotelId, warehouseId, sdate, edate, commondityName, creator, dtype);
foreach (StockOrderDetails item in list)
{
tb.Rows.Add(new string[] {
item.OrderNumber,
((DocumentTypeEnum)item.DType).ToString(),
item.CreateTime,
item.WarehouseName,
item.CommondityName,
item.CommondityUnit,
item.UnitPrice.ToString(),
item.Quantity.ToString(),
item.TotalPrice.ToString(),
item.HotelName,
item.Creator
});
}
ExcelHelper.ExportByWeb(tb, "入库明细报表", "入库明细报表.xls");
return(Json(apiResult));
}
/// <summary>
/// index导出excel
/// </summary>
/// <param name="GuestType"></param>
/// <returns></returns>
public JsonResult ToExcel(string reciveSDate = "", string reciveEDate = "", string creator = "", long hotelId = 0, int dType = 0, string CommodityName = "")
{
var tb = new DataTable();
tb.Columns.Add("单据号");
tb.Columns.Add("单据类型");
tb.Columns.Add("出库时间");
tb.Columns.Add("仓库");
tb.Columns.Add("货品名称");
tb.Columns.Add("单位");
tb.Columns.Add("单价");
tb.Columns.Add("数量");
tb.Columns.Add("合计金额");
tb.Columns.Add("来源");
tb.Columns.Add("操作人");
var apiResult = new APIResult();
var user = UserContext.CurrentUser;
List <StockOrderDetails> list = StockOrderDetailsBll.GetOutStockDetailsPagerList(CommodityName, reciveSDate, reciveEDate, creator, hotelId, dType, CommodityName);//
foreach (StockOrderDetails item in list)
{
tb.Rows.Add(new string[] {
item.OrderNumber,
((DocumentTypeEnum)item.DType).ToString(),
item.stockOrder.OperateTime,
item.stockOrder.FromWarehourseName,
item.CommondityName,
item.CommondityUnit,
item.UnitPrice.ToString(),
item.Quantity.ToString(),
item.TotalPrice.ToString(),
item.stockOrder.HotelName,
item.stockOrder.Creator
});
}
ExcelHelper.ExportByWeb(tb, "出库明细报表", "出库明细报表.xls");
return(Json(apiResult));
}
public string GetInStockStats(int page, int rows, long hotelId = 0, long warehouseId = 0, string sdate = "", string edate = "", string searcValue = "")
{
var pager = StockOrderDetailsBll.PagerInStockStats(page, rows, hotelId, warehouseId, sdate, edate, searcValue);
return(JsonConvert.SerializeObject(pager));
}
/// <summary>
/// 出库汇总
/// </summary>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <param name="hotelId"></param>
/// <param name="warehouseId"></param>
/// <param name="reciveSDate"></param>
/// <param name="reciveEDate"></param>
/// <param name="CommodityName"></param>
/// <returns></returns>
public string GetOutStockSummary(int page, int rows, long hotelId = 0, long warehouseId = 0, string reciveSDate = "", string reciveEDate = "", string CommodityName = "")
{
var pager = StockOrderDetailsBll.PagerOutStockSummary(page, rows, hotelId, warehouseId, reciveSDate, reciveEDate, CommodityName);
return(JsonConvert.SerializeObject(pager));
}
/// <summary>
/// 出库明细数据
/// </summary>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <param name="reciveSDate"></param>
/// <param name="reciveEDate"></param>
/// <param name="creator">操作者</param>
/// <param name="hotelId"></param>
/// <param name="dType"></param>
/// <param name="CommodityName"></param>
/// <returns></returns>
public string GetOutStockDetailsPager(int page, int rows, string reciveSDate = "", string reciveEDate = "", string creator = "", long hotelId = 0, int dType = 0, string CommodityName = "")
{
var pager = StockOrderDetailsBll.GetOutStockDetailsPager(page, rows, CommodityName, reciveSDate, reciveEDate, creator, hotelId, dType, CommodityName);//
return(JsonConvert.SerializeObject(pager));
}
/// <summary>
///
/// </summary>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <param name="selectTime"></param>
/// <param name="commodityName"></param>
/// <param name="warehouseId"></param>
/// <param name="orderType"></param>
/// <returns></returns>
public string GetPager(int page, int rows, string selectTime, string commodityName, long warehouseId = 0, int orderType = 0)
{
var pager = StockOrderDetailsBll.GetPager(page, rows, UserContext.CurrentUser.HotelId, selectTime, warehouseId, commodityName, orderType);
return(JsonConvert.SerializeObject(pager));
}
