public ActionResult Export()
{
int count = 0;
object footer = null;
var dt = TakeStockService.FindPageList(Request.Params, out count, ref footer, false);
if (dt == null || dt.Rows.Count <= 0)
{
return(RedirectAlert("Index", "暂无数据!"));
}
dt.Columns.Add("盘点员工号");
dt.Columns.Add("序号");
//string[] fields = { "StoreTitle", "CheckBatch", "Barcode", "Title", "BrandTitle", "SubUnit", "ActualNumber"};
//string[] names = { "盘点门店", "盘点批次", "条码", "品名", "品牌", "单位", "实盘数量" };
string[] fields = { "序号", "CategoryTitle", "Barcode", "Title", "BrandTitle", "SubUnit", "ActualNumber", "盘点员工号" };
string[] names = { "序号", "品类", "条码", "品名", "品牌", "单位", "实盘数量", "盘点员工号" };
var title = "";
var i = 1;
foreach (DataRow dr in dt.Rows)
{
dr["ActualNumber"] = DBNull.Value;
dr["序号"] = i++;
}
int[] merger = { };
new ExportExcel()
{
IsBufferOutput = true, HeaderText = title
}.ToExcel(dt.Rows[0]["StoreTitle"] + "_盘点_" + dt.Rows[0]["CheckBatch"], dt, fields, names, merger, formatFileName: false);
return(new EmptyResult());
}
public ActionResult FindPageList()
{
int count = 0;
var footer = new object();
var list = TakeStockService.FindPageList(Request.Params, out count, ref footer);
//var l = list.FirstOrDefault(o => o.CheckBatch == "2_0722_1");
return(ToDataGrid(list, count, footer));
}
public ActionResult FindApprovalList(string storeId, string checkBatch)
{
int count = 0;
object list = null, footer = null;
if (!storeId.IsNullOrEmpty() && !checkBatch.IsNullOrEmpty())
{
list = TakeStockService.FindPageList(Request.Params, out count, ref footer);
}
return(ToDataGrid(list, count, footer));
}
