///<summary> ///根据日期范围备份专卖店购货商品明细表 ///</summary> ///<param name="beginDate">开始时间</param> ///<param name="endDate">结束时间</param> private void BackupOrderDetailsByDate(DateTime beginDate, DateTime endDate) { ///清空所有的店铺订货产品明细备份数据 DataBackupBLL.ClearAllBackupOrderDetail(); ///根据日期范围备份店铺订货产品明细信息 DataBackupBLL.AddBackupOrderDetailByDate(beginDate, endDate); ///获取所有的店铺订货产品明细备份数据 DataTable dt = DataBackupBLL.GetALLBackupOrderDetail(); Excel.OutToExcel(dt, GetTran("004143", "专卖店购货商品明细"), new string[] { "StoreOrderID=" + GetTran("000079", "订单号"), "StoreID=" + GetTran("000150", "店铺编号"), "ProductID=" + GetTran("000558", "产品编号"), "ExpectNum=" + GetTran("000045", "期数"), "Quantity=" + GetTran("000505", "数量"), "NeedNumber=" + GetTran("001681", "应补数量"), "DumpQuantity=" + GetTran("004149", "冲红数量"), "Price=" + GetTran("002054", "产品单价"), "Pv=" + GetTran("002057", "产品积分"), "Description=" + GetTran("001680", "描述") }); ///弹出成功提示 msg = "<script language='javascript'>alert('" + GetTran("004141", "备份卖店购货商品明细成功") + "!')</script>"; }
///<summary> ///根据期数备份专卖店购货商品明细表 ///</summary> ///<param name="expectNum">指定的期数</param> private void BackupOrderDetailByExpectNum(int expectNum) { ///删除指定期数店铺订货产品明细记录 DataBackupBLL.DelBackupOrderDetailByExpectNum(expectNum); ///备份指定期数店铺订货产品明细记录 DataBackupBLL.AddBackupOrderDetailByExpectNum(expectNum); ///获取所有的店铺订货产品明细备份数据 DataTable dt = DataBackupBLL.GetALLBackupOrderDetail(); Excel.OutToExcel(dt, GetTran("004143", "专卖店购货商品明细"), new string[] { "StoreOrderID=" + GetTran("000079", "订单号"), "StoreID=" + GetTran("000150", "店铺编号"), "ProductID=" + GetTran("000558", "产品编号"), "ExpectNum=" + GetTran("000045", "期数"), "Quantity=" + GetTran("000505", "数量"), "NeedNumber=" + GetTran("001681", "应补数量"), "DumpQuantity=" + GetTran("004149", "冲红数量"), "Price=" + GetTran("002054", "产品单价"), "Pv=" + GetTran("002057", "产品积分"), "Description=" + GetTran("001680", "描述") }); ///弹出成功提示 msg = "<script language='javascript'>alert('" + GetTran("004122", "备份专卖店购货商品明细成功") + "!')</script>"; }