public virtual CriminalDetailDomain CreateCriminalDetailDomain() { CriminalDetailEntity entity = new CriminalDetailEntity(); entity.CriminalDetailId = Guid.NewGuid().ToString(); return new CriminalDetailDomain(entity); }
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."); } }
public virtual void UpdateCriminalDetailEntity(CriminalDetailEntity entity, DataAccessBroker broker) { DataAccess.Update(entity, broker); }
public virtual void InsertCriminalDetailEntity(CriminalDetailEntity entity, DataAccessBroker broker) { DataAccess.Insert(entity, broker); }
public virtual bool IsCriminalDetailExist(string actionNo) { WhereBuilder wb = WhereBuilder.SelectAll(CriminalDetailTable.Current.TableName); CriminalDetailEntity criminalDetailEntity = new CriminalDetailEntity(); if (!string.IsNullOrEmpty(actionNo)) { criminalDetailEntity.ActionNo = actionNo; } EntityCollection<CriminalDetailEntity> criminalDetailEntityList = DataAccess.Select<CriminalDetailEntity>(criminalDetailEntity); if (criminalDetailEntityList != null && criminalDetailEntityList.Count > 0) { return true; } return false; }
public bool InsertCriminalRaid(CriminalDetailEntity criminalEntity, string agency,string agencyID, bool isInsert,string userName,string userID) { Suzsoft.Smart.EntityCore.DataAccessParameterCollection dpc1 = new Suzsoft.Smart.EntityCore.DataAccessParameterCollection(); dpc1.AddWithValue("@actionNO", criminalEntity.ActionNo); dpc1.AddWithValue("@agency", agency); dpc1.AddWithValue("@AgencyID", agencyID); dpc1.AddWithValue("@User_ID", userID); dpc1.AddWithValue("@User_Name", userName); string strOtherSql = @" INSERT INTO Criminal (Action_NO,Agency,Conviction_Report_Upload_Date,Agency_ID,User_ID,User_Name) values (@actionNO,@agency,'" + DateTime.Now + "',@AgencyID,@User_ID,@User_Name)"; using (DataAccessBroker objBroker = DataAccessFactory.Instance()) { try { objBroker.BeginTransaction(); WhereBuilder wb = WhereBuilder.SelectAll(CriminalTable.Current.TableName); wb.AddAndCondition(CriminalTable.C_Action_NO, criminalEntity.ActionNo); //wb.AddAndCondition(CriminalTable.C_Agency, agency); //原系统逻辑 bool flag = DataAccess.Select<CriminalEntity>(wb).Count > 0; if (!flag) { objBroker.ExecuteSQL(strOtherSql, dpc1); } if (isInsert) { DataAccess.Insert(criminalEntity, objBroker); //Insert(criminalEntity, objBroker); } else { DataAccess.Update(criminalEntity, objBroker); } objBroker.Commit(); return true; } catch (Exception ex) { //WhereBuilder wb = WhereBuilder.SelectAll(CriminalTable.Current.TableName); //wb.AddAndCondition(CriminalTable.C_Action_NO, criminalEntity.ActionNO); //wb.AddAndCondition(CriminalTable.C_Agency, agency); //bool flag = DataAccess.Select<CriminalEntity>(wb).Count > 0; //if (flag) //{ // CriminalEntity criminalDelEntity = new CriminalEntity(); // criminalDelEntity.ActionNO = criminalEntity.ActionNO; // DataAccess.Delete(criminalDelEntity); //} objBroker.RollBack(); return false; } } }
public CriminalDetailDomain(CriminalDetailEntity entity) : base(entity) { masterEntity = entity; }