private string SaleDefToExcel(string BeginDate, string EndDate)
{
DataSet ds = new ZhangWei.BLL.Sale_Detail().GetSaleDefinite(BeginDate, EndDate);
string ToExcel = new LTP.Common.DataToExcel().OutputExcel(ds.Tables[0], "销售明细 " + BeginDate + "—" + EndDate, HttpContext.Current.Server.MapPath("/ExcelFiles/"), "销售明细");
return(ToExcel);
}
private string SaleGatToExcel(string BeginDate, string EndDate, string according)
{
if (according == "1")
{
DataSet ds = new ZhangWei.BLL.Sale_Detail().GetSaleGather(BeginDate, EndDate);
string ToExcel = new LTP.Common.DataToExcel().OutputExcel(ds.Tables[0], "销售汇总（按品种） " + BeginDate + "—" + EndDate, HttpContext.Current.Server.MapPath("/ExcelFiles/"), "销售汇总（按品种）");
return(ToExcel);
}
else
{
DataSet ds = new ZhangWei.BLL.Sale_Detail().GetGatherByList(BeginDate, EndDate);
string ToExcel = new LTP.Common.DataToExcel().OutputExcel(ds.Tables[0], "销售汇总（按单号） " + BeginDate + "—" + EndDate, HttpContext.Current.Server.MapPath("/ExcelFiles/"), "销售汇总（按单号）");
return(ToExcel);
}
}
private string StockToExcel(Int32 StoreHouse_ID)
{
DataSet ds = new ZhangWei.BLL.StockPile().CheckStock(StoreHouse_ID);
string ToExcel = new LTP.Common.DataToExcel().OutputExcel(ds.Tables[0], "库存盘点 " + DateTime.Now.ToString(), HttpContext.Current.Server.MapPath("/ExcelFiles/"), "库存盘点");
ZhangWei.BLL.HasChecked bl_hc = new ZhangWei.BLL.HasChecked();
ZhangWei.Model.HasChecked ml_hc = bl_hc.GetModel(bl_hc.GetMaxId() - 1);
DateTime dt = DateTime.Now;
DateTime LastCheckTime = ml_hc.Month;
if (dt.Month > LastCheckTime.Month)
{
ml_hc.Month = dt;
bl_hc.Add(ml_hc);
}
else
{
ml_hc.Month = dt;
bl_hc.Update(ml_hc);
}
return(ToExcel);
}
