public ActionResult DownLoad()
{
object con = new SystemCache().GetCache("stockout_query");
if (con == null)
{
return(new EmptyResult());
}
var dataList = _sto_StockOutBusiness.GetStockOutList(
$"{con.GetPropertyValue("StoreId")}",
$"{con.GetPropertyValue("OutNo")}",
$"{con.GetPropertyValue("B_OutDate")}",
$"{con.GetPropertyValue("E_OutDate")}",
new Pagination()
{
PageRows = Int32.MaxValue
});
string outputFileName = $"出库-{DateTime.Now.ToString("yyyyMMddHHmmss")}";
DataTable dataTable = new DataTable();
dataTable.Columns.Add(new DataColumn("仓库"));
dataTable.Columns.Add(new DataColumn("出库单号"));
dataTable.Columns.Add(new DataColumn("出库时间"));
dataTable.Columns.Add(new DataColumn("出库操作员"));
dataTable.Columns.Add(new DataColumn("材料编码"));
dataTable.Columns.Add(new DataColumn("材料名称"));
dataTable.Columns.Add(new DataColumn("规格"));
dataTable.Columns.Add(new DataColumn("单位"));
dataTable.Columns.Add(new DataColumn("数量"));
dataTable.Columns.Add(new DataColumn("出库类型"));
dataTable.Columns.Add(new DataColumn("申请编号"));
dataTable.Columns.Add(new DataColumn("备注"));
foreach (StockOutListItem item in dataList)
{
DataRow newRow = dataTable.NewRow();
newRow[0] = item.StoreName;
newRow[1] = item.OutNo;
newRow[2] = item.OutDate;
newRow[3] = item.OutOperID;
newRow[4] = item.MatNo;
newRow[5] = item.MatName;
newRow[6] = item.GuiGe;
newRow[7] = item.UnitName;
newRow[8] = item.Quantity;
newRow[9] = item.OutType == 0? "工程领料" : "普通领料";
newRow[10] = item.ApplyNo;
newRow[11] = item.Context;
dataTable.Rows.Add(newRow);
}
OperateExcel.ExportToExcel(System.Web.HttpContext.Current, dataTable, outputFileName);
return(new EmptyResult());
}
//导出Excel
public ExportExcelModel ExportExcel(UserParams userInfo)
{
ExportExcelModel exportExcelModel = new ExportExcelModel();
DataTable dtUerInfo = userInfoDAL.SearchInfo(userInfo);
exportExcelModel.filename = OperateExcel.ExportToExcel(dtUerInfo, DateTime.Now.ToString("yyyyMMddHHmmss"));
return(exportExcelModel);
}
/// <summary>
/// 下载当前查询的库存列表
/// </summary>
/// <param name="key"></param>
/// <returns></returns>
public ActionResult DownLoad(string key)
{
string param = $"{new SystemCache().GetCache("stock_query")}";
var dataList = _sto_StockBusiness.GetDataList(param, new Pagination()
{
PageRows = int.MaxValue
});
string outputFileName = $"库存-{DateTime.Now.ToString("yyyyMMddHHmmss")}";
DataTable dataTable = new DataTable();
dataTable.Columns.Add(new DataColumn("仓库"));
dataTable.Columns.Add(new DataColumn("编码"));
dataTable.Columns.Add(new DataColumn("名称"));
dataTable.Columns.Add(new DataColumn("分类"));
dataTable.Columns.Add(new DataColumn("规格"));
dataTable.Columns.Add(new DataColumn("单位"));
dataTable.Columns.Add(new DataColumn("数量"));
dataTable.Columns.Add(new DataColumn("单价"));
dataTable.Columns.Add(new DataColumn("上限"));
dataTable.Columns.Add(new DataColumn("下限"));
foreach (Sto_StockBusiness.Stock stock in dataList)
{
DataRow newRow = dataTable.NewRow();
newRow[0] = stock.StoreName;
newRow[1] = stock.MatNo;
newRow[2] = stock.MatName;
newRow[3] = stock.BigClassName;
newRow[4] = stock.GuiGe;
newRow[5] = stock.UnitName;
newRow[6] = stock.Quantity;
newRow[7] = stock.Price;
newRow[8] = stock.MaxStoreQuantity;
newRow[9] = stock.WarnStoreQuantity;
dataTable.Rows.Add(newRow);
}
OperateExcel.ExportToExcel(System.Web.HttpContext.Current, dataTable, outputFileName);
return(new EmptyResult());
}
