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");
}