Esempio n. 1
0
    ///<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>";
    }
Esempio n. 2
0
    ///<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>";
    }