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 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 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 }