protected void btnDownloadTemplate_Click(object sender, EventArgs e) { //根据输入的Storename, 查询StoreType=Import的数据到Excel下载 DataSet dsData = MainService.StoreBLLService.QueryByCondition<StoreEntity>( BPSC.Common.Utils.QueryCondition.Create() .Like(StoreTable.C_STORE_NAME, txtStoreName.Text.Trim()) //.Equals(StoreTable.C_STORE_TYPE, BPSC.Common.StoreType.Import.ToString()) .NotEquals(StoreTable.C_IS_DELETED, "Y")); DataTable dtData = new DataTable(); if (dsData != null && dsData.Tables.Count > 0 && dsData.Tables[0].Rows.Count > 0) { dtData = dsData.Tables[0]; for (int i = dtData.Columns.Count - 1; i > 23; i--) { dtData.Columns.RemoveAt(i); } dtData.Columns.RemoveAt(0); } BPSC.Common.ExcelTemplate excelTemplalte = new BPSC.Common.ExcelTemplate("Store_Import_Template.xls"); //excelTemplalte. excelTemplalte.Export(dtData, "Store_Import_Template" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls"); }
protected void btnDownload_Click(object sender, EventArgs e) { BPSC.Common.ExcelTemplate excelTemplalte = new BPSC.Common.ExcelTemplate("Criminal_Template.xls"); excelTemplalte.Export("Criminal_" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls"); }
protected void lnkEmptyTemplate_Click(object sender, EventArgs e) { //根据输入的Storename, 查询StoreType=Import的数据到Excel下载 DataSet dsData = MainService.StoreBLLService.QueryByCondition<StoreEntity>( BPSC.Common.Utils.QueryCondition.Create() .Equals("1", "0")); DataTable dtData = new DataTable(); if (dsData != null && dsData.Tables.Count > 0) { dtData = dsData.Tables[0]; for (int i = dtData.Columns.Count - 1; i > 23; i--) { dtData.Columns.RemoveAt(i); } dtData.Columns.RemoveAt(0); } BPSC.Common.ExcelTemplate excelTemplalte = new BPSC.Common.ExcelTemplate("Store_Import_Template.xls"); //excelTemplalte. excelTemplalte.Export(dtData, "Store_Import_Template" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls"); }
protected void btnDownload_Click(object sender, EventArgs e) { if (OtherRaidType == "MarketSweep") { BPSC.Common.ExcelTemplate excelTemplalte = new BPSC.Common.ExcelTemplate("Market_Sweep_SubDistributor_Template.xls"); excelTemplalte.Export("Market_Sweep_Investigation_" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls"); } else if (OtherRaidType == "SubRaid") { BPSC.Common.ExcelTemplate excelTemplalte = new BPSC.Common.ExcelTemplate("Market_Sweep_SubDistributor_Template.xls"); excelTemplalte.Export("Sub-Distributor_Investigation_" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls"); } }
protected void btnDownloadPriceRecord_Click(object sender, EventArgs e) { DataTable dt = MainService.ProductPriceRecordBLLService.Query(); #region Wrap DataTable // DataTable dtWrap = new DataTable(); dtWrap.Columns.Add("Product_ID", typeof(string)); dtWrap.Columns.Add("GBU", typeof(string)); dtWrap.Columns.Add("Category", typeof(string)); dtWrap.Columns.Add("Brand", typeof(string)); dtWrap.Columns.Add("BrandTpye", typeof(string)); dtWrap.Columns.Add("Subcategory", typeof(string)); dtWrap.Columns.Add("Product_Code_SAP_Code", typeof(string)); dtWrap.Columns.Add("DESC_CN", typeof(string)); dtWrap.Columns.Add("Product_Type", typeof(string)); dtWrap.Columns.Add("BrandSize", typeof(string)); dtWrap.Columns.Add("CasePackage", typeof(string)); dtWrap.Columns.Add("Reatail_CasePrice", typeof(decimal)); //dtWrap.Columns.Add("Specification", typeof(string)); dtWrap.Columns.Add("DESC_EN", typeof(string)); for (int i = 1; i < 11; i++) { dtWrap.Columns.Add("NewPrice" + i.ToString(), typeof(string)); } DataRow rowWrap = null; foreach (DataRow row in dt.Rows) { rowWrap = dtWrap.NewRow(); rowWrap["Product_ID"] = row[ProductTable.C_Product_ID]; rowWrap["GBU"] = row[ProductTable.C_GBU]; rowWrap["Category"] = row[ProductTable.C_Category]; rowWrap["Brand"] = row[ProductTable.C_Brand]; rowWrap["BrandTpye"] = row[ProductTable.C_BrandType]; rowWrap["Subcategory"] = row[ProductTable.C_SubCategory]; rowWrap["Product_Code_SAP_Code"] = row[ProductTable.C_Product_SAP_Code]; rowWrap["DESC_CN"] = row[ProductTable.C_DESC_CN]; rowWrap["Product_Type"] = row[ProductTable.C_Product_Type]; rowWrap["BrandSize"] = row[ProductTable.C_Product_Size]; rowWrap["CasePackage"] = row[ProductTable.C_Case_Package]; rowWrap["Reatail_CasePrice"] = row[ProductTable.C_Retail_CasePrice]; //rowWrap["Specification"] = row[ProductTable.C_Specification]; rowWrap["DESC_EN"] = row[ProductTable.C_DESC_EN]; for (int i = 1; i < 11; i++) { rowWrap["NewPrice" + i.ToString()] = row["NewPrice" + i.ToString()]; } dtWrap.Rows.Add(rowWrap); } #endregion BPSC.Common.ExcelTemplate excelTemplalte = new BPSC.Common.ExcelTemplate("Product_PriceRecord_Template.xls"); excelTemplalte.Export(dtWrap, "ProductPriceRecord".Replace(' ', '_') + "_" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls"); }
protected void btnDownload_Click(object sender, EventArgs e) { DataTable dt = QueryData(); #region Wrap DataTable DataTable dtWrap = new DataTable(); dtWrap.Columns.Add("Product_ID", typeof(string)); dtWrap.Columns.Add("GBU", typeof(string)); dtWrap.Columns.Add("Category", typeof(string)); dtWrap.Columns.Add("Brand", typeof(string)); dtWrap.Columns.Add("BrandTpye", typeof(string)); dtWrap.Columns.Add("Subcategory", typeof(string)); dtWrap.Columns.Add("Product_Code_SAP_Code", typeof(string)); dtWrap.Columns.Add("DESC_CN", typeof(string)); dtWrap.Columns.Add("Product_Type", typeof(string)); dtWrap.Columns.Add("BrandSize", typeof(string)); dtWrap.Columns.Add("CasePackage", typeof(string)); dtWrap.Columns.Add("Reatail_CasePrice", typeof(decimal)); dtWrap.Columns.Add("DESC_EN", typeof(string)); dtWrap.Columns.Add("Specification", typeof(string)); dtWrap.Columns.Add("Product_StartDate", typeof(string)); dtWrap.Columns.Add("Product_EndDate", typeof(string)); DataRow rowWrap = null; foreach (DataRow row in dt.Rows) { rowWrap = dtWrap.NewRow(); rowWrap["Product_ID"] = row[ProductTable.C_Product_ID]; rowWrap["GBU"] = row[ProductTable.C_GBU]; rowWrap["Category"] = row[ProductTable.C_Category]; rowWrap["Brand"] = row[ProductTable.C_Brand]; rowWrap["BrandTpye"] = row[ProductTable.C_BrandType]; rowWrap["Subcategory"] = row[ProductTable.C_SubCategory]; rowWrap["Product_Code_SAP_Code"] = row[ProductTable.C_Product_SAP_Code]; rowWrap["DESC_CN"] = row[ProductTable.C_DESC_CN]; rowWrap["Product_Type"] = row[ProductTable.C_Product_Type]; rowWrap["BrandSize"] = row[ProductTable.C_Product_Size]; rowWrap["CasePackage"] = row[ProductTable.C_Case_Package]; rowWrap["Reatail_CasePrice"] = row[ProductTable.C_Retail_CasePrice]; rowWrap["DESC_EN"] = row[ProductTable.C_DESC_EN]; rowWrap["Specification"] = row[ProductTable.C_Specification]; rowWrap["Product_StartDate"] = row[ProductTable.C_Product_StartDate]; rowWrap["Product_EndDate"] = row[ProductTable.C_Product_EndDate]; dtWrap.Rows.Add(rowWrap); } #endregion //BPS.Common.ExcelHelper.ExportToCsvFile(this, dt, ActivityName, ActivityName + "_" + DateTime.Now.ToString("yyyy_MM_dd_HH_mm_ss")); BPSC.Common.ExcelTemplate excelTemplalte = new BPSC.Common.ExcelTemplate("Product_Import_Template.xls"); excelTemplalte.Export(dtWrap, "ProductData".Replace(' ', '_') + "_" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls"); }