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 btnSave_Click(object sender, EventArgs e)
{
if (!this.fudCriminal.HasFile)
{
base.AlertMessage("Please select file.");
this.fudCriminal.Focus();
return;
}
BPSC.Common.ExcelTemplate excelTemplate = new BPSC.Common.ExcelTemplate("Criminal_Template.xls");
bool isValid = true;
DataTable dt = excelTemplate.GetDataFromExcel(fudCriminal, out isValid);
if (!isValid)
{
AlertMessage("The format of criminal file is error. Please check it, try again later.");
return;
}
#region 验证所有数据的格式正确性
for (int j = 0; j < dt.Rows.Count; j++)
{
if (dt.Rows[j][1].ToString().Trim() == "")
{
AlertMessage("Data empty, 'Action NO.'.");
this.fudCriminal.Focus();
return;
}
if (!CheckActionNOIsExist(dt.Rows[j][1].ToString().Trim()))
{
AlertMessage("'Action NO.' doesn't exist ");
this.fudCriminal.Focus();
return;
}
try
{
Convert.ToDateTime(dt.Rows[j][8]);
}
catch (Exception ex)
{
AlertMessage("Data format is error, 'Raid Date'.");
this.fudCriminal.Focus();
return;
}
#region 模板更新
//模板更新，取消Length Of Sentence probation、Length Of Sentence imprisonment、Punished with Criminal Fine、Confiscate illegal gains，新增Result
//try
//{
// Convert.ToInt32(dt.Rows[j][17]);
//}
//catch
//{
// AlertMessage("Data format is error, 'Length Of Sentence probation'.");
// this.fudCriminal.Focus();
// return;
//}
//try
//{
// Convert.ToInt32(dt.Rows[j][18]);
//}
//catch
//{
// AlertMessage("Data format is error, 'Length Of Sentence imprisonment'.");
// this.fudCriminal.Focus();
// return;
//}
//try
//{
// Convert.ToDouble(dt.Rows[j][19]);
//}
//catch
//{
// AlertMessage("Data format is error, 'Punished with Criminal Fine'.");
// this.fudCriminal.Focus();
// return;
//}
//try
//{
// Convert.ToDouble(dt.Rows[j][20]);
//}
//catch
//{
// AlertMessage("Data format is error, 'Confiscate illegal gains'.");
// this.fudCriminal.Focus();
// return;
//}
#endregion
try
{
Convert.ToDateTime(dt.Rows[j][18]);
}
catch (Exception ex)
{
AlertMessage("Data format is error, 'Conviction Date'.");
this.fudCriminal.Focus();
return;
}
try
{
Convert.ToDateTime(dt.Rows[j][22]);
}
catch (Exception ex)
{
AlertMessage("Data format is error, 'Criminal Date'.");
this.fudCriminal.Focus();
return;
}
try
{
Convert.ToDateTime(dt.Rows[j][23]);
}
catch (Exception ex)
{
AlertMessage("Data format is error, 'Report Received Date'.");
this.fudCriminal.Focus();
return;
}
}
#endregion
CriminalDetailEntity criminalDetailEntity = null;
List<CriminalDetailEntity> lstCriminalDetailEntity = new List<CriminalDetailEntity>();
#region Insert Data
for (int i = 0; i < dt.Rows.Count; i++)
{
criminalDetailEntity = new CriminalDetailEntity();
criminalDetailEntity.CriminalDetailId = Guid.NewGuid().ToString();
criminalDetailEntity.ActionNo = dt.Rows[i][1].ToString();
criminalDetailEntity.Sequence = dt.Rows[i][0].ToString();
criminalDetailEntity.Province = dt.Rows[i][2].ToString();
criminalDetailEntity.City = dt.Rows[i][3].ToString();
criminalDetailEntity.WholesalerManufacturer = dt.Rows[i][4].ToString();
criminalDetailEntity.PngBrand = dt.Rows[i][5].ToString();
criminalDetailEntity.OtherBrand = dt.Rows[i][6].ToString();
criminalDetailEntity.Defendant = dt.Rows[i][7].ToString();
criminalDetailEntity.RaidDate = Convert.ToDateTime(dt.Rows[i][8]);
criminalDetailEntity.Seizure = dt.Rows[i][9].ToString();
criminalDetailEntity.EstimatedValueUsd = dt.Rows[i][10].ToString();
criminalDetailEntity.PsbUnit = dt.Rows[i][11].ToString();
criminalDetailEntity.PpUnit = dt.Rows[i][12].ToString();
criminalDetailEntity.CourtUnit = dt.Rows[i][13].ToString();
criminalDetailEntity.BasisOfConviction = dt.Rows[i][14].ToString();
criminalDetailEntity.LawFirm = dt.Rows[i][15].ToString();
criminalDetailEntity.FirmNameAndDate = dt.Rows[i][16].ToString();
#region 模板更新， 一下index重排
//模板更新，取消Length Of Sentence probation、Length Of Sentence imprisonment、Punished with Criminal Fine、Confiscate illegal gains，新增Result
//criminalDetailEntity.Lengthofsentenceprobation = Convert.ToInt32(dt.Rows[i][17]);
//criminalDetailEntity.Lengthofsentenceofimprisonment = Convert.ToInt32(dt.Rows[i][18]);
//criminalDetailEntity.Punishedwidthcriminalfine = Convert.ToDecimal(dt.Rows[i][19]);
//criminalDetailEntity.ConfiscateIllegalGains = Convert.ToDecimal(dt.Rows[i][20]);
#endregion
criminalDetailEntity.Result = dt.Rows[i][17].ToString();
criminalDetailEntity.ConvictionDate = Convert.ToDateTime(dt.Rows[i][18]);
criminalDetailEntity.AllAssistingUnits = dt.Rows[i][19].ToString();
criminalDetailEntity.KeyPoints = dt.Rows[i][20].ToString();
criminalDetailEntity.Document = dt.Rows[i][21].ToString();
criminalDetailEntity.CreateDate = DateTime.Now;
criminalDetailEntity.CreateUser = base.CurrentUser.SecUserEntity.UserId;
//新增Criminal Date列
criminalDetailEntity.CriminalDate = Convert.ToDateTime(dt.Rows[i][22]);
//新增Report Received Date列
criminalDetailEntity.Reportreceivedday = Convert.ToDateTime(dt.Rows[i][23]);
lstCriminalDetailEntity.Add(criminalDetailEntity);
}
#endregion
int total_success_import = 0;
int total_valid_product = lstCriminalDetailEntity.Count;
foreach (CriminalDetailEntity entity in lstCriminalDetailEntity)
{
if (MainService.CriminalDetailBLLService.InsertCriminalRaid(entity, ddlAgency.SelectedItem.Text, ddlAgency.SelectedValue.Trim(), true,ddlUser.SelectedItem.Text,ddlUser.SelectedValue.Trim()))
total_success_import += 1;
}
if (total_success_import > 0)
{
base.AlertMessage(total_success_import.ToString() + " criminals is valid, and import successfully!");
}
else
{
base.AlertMessage("All criminals is invalid. Please check, try it later.");
}
}
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 btnSave_Click(object sender, EventArgs e)
{
//更新或新增数据
int total_valid_product = 0;
int total_success_import = 0;
if (upLoadFile.FileName.Length == 0)
{
base.AlertMessage("Please choose store file.");
return;
}
BPSC.Common.ExcelTemplate excelTemplate = new BPSC.Common.ExcelTemplate("Store_Import_Template.xls");
bool isValid = true;
DataTable dt_product = excelTemplate.GetDataFromExcel(upLoadFile, out isValid);
if (!isValid)
{
base.AlertMessage("The format of store file is error. Please check it, try again later.");
return;
}
//DMS_ID,DMS_STORE_ID,STORE_NAME 不能为空
#region 验证所有数据的格式正确性
for (int j = 0; j < dt_product.Rows.Count; j++)
{
//if (dt_product.Rows[j][6].ToString().Trim() == "" || dt_product.Rows[j][8].ToString().Trim() == "" || dt_product.Rows[j][9].ToString().Trim() == "")
//{
// base.AlertMessage("'DMS_ID'、'DMS_STORE_ID' and 'STORE_NAME' can not be empty.");
// this.upLoadFile.Focus();
// return;
//}
if (dt_product.Rows[j][7].ToString().Trim() == "" && dt_product.Rows[j][8].ToString().Trim() == "")
{
base.AlertMessage("If 'Store SEQ' is null, 'BP Store SEQ' must be enter.");
this.upLoadFile.Focus();
return;
}
if (dt_product.Rows[j][10].ToString().Trim() == "")
{
base.AlertMessage("Store Name can not be empty.");
this.upLoadFile.Focus();
return;
}
}
#endregion
total_valid_product = dt_product.Rows.Count;
if (cbxOverwriteAll.Checked) //全量更新
{
//1.将所有StoreType=Import 且 IS_DELETED！=N 的记录都删除（将IS_DELETED=Y）
//2 将Excel中所有记录新增的table
total_success_import = MainService.StoreBLLService.StoreOverwriteAll(dt_product, base.CurrentUser.SecUserEntity.UserId);
}
else
{
total_success_import = MainService.StoreBLLService.StoreUpdateOrInsert(dt_product, base.CurrentUser.SecUserEntity.UserId);
}
if (total_success_import > 0)
{
base.AlertMessage(total_success_import.ToString() + " stores are valid, and import successfully!");
}
else
{
base.AlertMessage("All stores are invalid. Please check, try it later.");
}
}
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 btnSave_Click(object sender, EventArgs e)
{
if (!this.fudCriminal.HasFile)
{
base.AlertMessage("Please select file.");
this.fudCriminal.Focus();
return;
}
#region Sub-Distributor
if (OtherRaidType == "SubRaid")
{
}
BPSC.Common.ExcelTemplate excelTemplate = new BPSC.Common.ExcelTemplate("Market_Sweep_SubDistributor_Template.xls");
bool isValid = true;
DataTable dt = excelTemplate.GetDataFromExcel(fudCriminal, out isValid);
if (!isValid)
{
AlertMessage("The format of raid file is error. Please check it, try again later.");
return;
}
StoreEntity storeEntity = null;
AreaEntity areaEntity = null;
DataSet dsTemp = null;
List<NormalRaidEntity> listNormalRaidEntity = new List<NormalRaidEntity>();
NormalRaidEntity normalRaidEntity = null;
int colIndex = 0;
string actionNo, actionDate, storeSeq, I_Or_Raid;
for (int j = 0; j < dt.Rows.Count; j++)
{
normalRaidEntity = new NormalRaidEntity();
colIndex = 0;
I_Or_Raid = dt.Rows[j][0].ToString().Trim();
if(I_Or_Raid != "Investigation" && I_Or_Raid != "Raid")
{
AlertMessage(string.Format("IOrRaid value is not 'Investigation' or 'Raid'! {0} is wrong!",I_Or_Raid));
this.fudCriminal.Focus();
return;
}
actionNo = dt.Rows[j][4].ToString().Trim();
if (CheckActionNOIsExist(actionNo))
{
AlertMessage("Investigation NO is exist, please try another again! ");
this.fudCriminal.Focus();
return;
}
try
{
actionDate = dt.Rows[j][5].ToString().Trim();
normalRaidEntity.ActionDate = Convert.ToDateTime(actionDate);
}
catch (Exception ex)
{
AlertMessage("ActionDate format error.");
this.fudCriminal.Focus();
return;
}
//Subject SEQ
storeSeq = dt.Rows[j][8].ToString().Trim();
storeEntity = MainService.StoreBLLService.GetStoreEntityByIdStoreSeq(storeSeq);
if (storeEntity == null)
{
AlertMessage("Store not exist");
this.fudCriminal.Focus();
return;
}
else
{
normalRaidEntity.StoreName = storeEntity.StoreName;
normalRaidEntity.StoreId = storeEntity.StoreId;
normalRaidEntity.Province = storeEntity.Province;
normalRaidEntity.City = storeEntity.City;
normalRaidEntity.SubCity = storeEntity.Village;
areaEntity = null;
areaEntity = MainService.AreaBLLService.GetAreaEntityByLevelCHName(1, storeEntity.Province.Trim());
if (areaEntity != null && areaEntity.AreaId != null)
{
normalRaidEntity.ProvinceId = areaEntity.AreaId;
}
else
{
normalRaidEntity.ProvinceId = -1;
}
areaEntity = null;
areaEntity = MainService.AreaBLLService.GetAreaEntityByLevelCHNamePID(2, storeEntity.City.Trim(), normalRaidEntity.ProvinceId);
if (areaEntity != null && areaEntity.AreaId != null)
{
normalRaidEntity.CityId = areaEntity.AreaId;
}
else
{
normalRaidEntity.CityId = -1;
}
areaEntity = null;
areaEntity = MainService.AreaBLLService.GetAreaEntityByLevelCHNamePID(3, storeEntity.Village.Trim(), normalRaidEntity.CityId);
if (areaEntity != null && areaEntity.AreaId != null)
{
normalRaidEntity.SubCityId = areaEntity.AreaId;
}
else
{
normalRaidEntity.SubCityId = -1;
}
}
normalRaidEntity.Type = OtherRaidType;
//normalRaidEntity.IOrRaid = "Investigation"; // 1是Investigation
normalRaidEntity.IOrRaid = dt.Rows[j][colIndex++].ToString().Trim();
normalRaidEntity.SourceType = dt.Rows[j][colIndex++].ToString().Trim();
normalRaidEntity.SourceId = dt.Rows[j][colIndex++].ToString().Trim();
normalRaidEntity.Project = dt.Rows[j][colIndex++].ToString().Trim();
normalRaidEntity.No = dt.Rows[j][colIndex++].ToString().Trim();
colIndex++;
//normalRaidEntity.ActionDate = Convert.ToDateTime(dt.Rows[j][4].ToString().Trim()); //前面已赋值
normalRaidEntity.Region = dt.Rows[j][colIndex++].ToString().Trim(); //"GC";
normalRaidEntity.Country = dt.Rows[j][colIndex++].ToString().Trim(); //"China";
normalRaidEntity.SubjectSeq = dt.Rows[j][colIndex++].ToString().Trim();
normalRaidEntity.Enforcementunit = dt.Rows[j][colIndex++].ToString().Trim();
dsTemp = null;
dsTemp = MainService.NormalRaidBLLService.QueryByCondition<SysParameterEntity>(
BPSC.Common.Utils.QueryCondition.Create()
.Equals(SysParameterTable.C_PARAMETER_TYPE, "EnforcementUnit")
.Equals(SysParameterTable.C_PARAMETER_NAME, normalRaidEntity.Enforcementunit));
if (dsTemp != null && dsTemp.Tables.Count > 0 && dsTemp.Tables[0].Rows.Count > 0)
{
normalRaidEntity.EnforcementunitId = dsTemp.Tables[0].Rows[0][SysParameterTable.C_PARAMETER_VALUE].ToString().Trim();
}
normalRaidEntity.ExecutionArea = dt.Rows[j][colIndex++].ToString().Trim();
normalRaidEntity.ExecutionUnit = dt.Rows[j][colIndex++].ToString().Trim();
normalRaidEntity.SubjectType = dt.Rows[j][colIndex++].ToString().Trim();
dsTemp = null;
dsTemp = MainService.NormalRaidBLLService.QueryByCondition<SysParameterEntity>(
BPSC.Common.Utils.QueryCondition.Create()
.Equals(SysParameterTable.C_PARAMETER_TYPE, "SubjectType")
.Equals(SysParameterTable.C_PARAMETER_NAME, normalRaidEntity.SubjectType));
if (dsTemp != null && dsTemp.Tables.Count > 0 && dsTemp.Tables[0].Rows.Count > 0)
{
normalRaidEntity.SubjectTypeId = dsTemp.Tables[0].Rows[0][SysParameterTable.C_PARAMETER_VALUE].ToString().Trim();
}
normalRaidEntity.SubSubjectType = dt.Rows[j][colIndex++].ToString().Trim();
dsTemp = null;
dsTemp = MainService.NormalRaidBLLService.QueryByCondition<SysParameterEntity>(
BPSC.Common.Utils.QueryCondition.Create()
.Equals(SysParameterTable.C_PARAMETER_TYPE, normalRaidEntity.SubjectType)
.Equals(SysParameterTable.C_PARAMETER_NAME, normalRaidEntity.SubSubjectType));
if (dsTemp != null && dsTemp.Tables.Count > 0 && dsTemp.Tables[0].Rows.Count > 0)
{
normalRaidEntity.SubSubjectTypeId = dsTemp.Tables[0].Rows[0][SysParameterTable.C_PARAMETER_VALUE].ToString().Trim();
}
normalRaidEntity.WholeSaleMarket = dt.Rows[j][colIndex++].ToString().Trim();
normalRaidEntity.InvestigationResult = dt.Rows[j][colIndex++].ToString().Trim();
normalRaidEntity.SubjectNote = dt.Rows[j][colIndex++].ToString().Trim();
normalRaidEntity.ExecutionResult = dt.Rows[j][colIndex++].ToString().Trim();
normalRaidEntity.AgencyId = this.ddlAgency.SelectedValue;
normalRaidEntity.Agency = this.ddlAgency.SelectedItem.Text;
normalRaidEntity.StatusReportCfjds = 0;
normalRaidEntity.StatusReportJdbg = 0;
normalRaidEntity.StatusReportKyqd = 0;
normalRaidEntity.StatusReportXdbg = 0;
normalRaidEntity.StatusReportXhzm = 0;
normalRaidEntity.StatusReportXrzl = 0;
normalRaidEntity.CreateDate = DateTime.Now;
normalRaidEntity.CreateUser = base.CurrentUser.SecUserEntity.UserId;
normalRaidEntity.UserId = ddlUser.SelectedValue;
normalRaidEntity.UserName = ddlUser.SelectedItem.Text;
listNormalRaidEntity.Add(normalRaidEntity);
}
int total_success_import = 0;
int total_valid_product = listNormalRaidEntity.Count;
foreach (NormalRaidEntity entity in listNormalRaidEntity)
{
if (MainService.NormalRaidBLLService.InsertNormalRaid(entity, null, null, null, null, true))
total_success_import += 1;
}
if (total_success_import > 0)
{
base.AlertMessage(total_success_import.ToString() + " raids are valid, and import successfully!");
}
else
{
base.AlertMessage("All raids are invalid. Please check, try it later.");
}
#endregion
}
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");
}
