/// <summary> /// 新增保险信息 /// </summary> /// <param name="insuranceInfo">保险信息对象</param> public void Add(InsuranceInfo insuranceInfo) { IDbTransaction transaction = null; string commandText = @"INSERT INTO Insurance(Id,CarNumber,FrameNumber,EngineNumber,ItemSummary,Insurant," + "InsurantPhone,InsurantId,InsuranceCompany,Amount,Local,InsuranceDate,NextInsuranceDate," + "RemindDate,CreateDate,UpdateDate,Creator,Operator,Valid)VALUES(@Id,@CarNumber,@FrameNumber," + "@EngineNumber,@ItemSummary,@Insurant,@InsurantPhone,@InsurantId,@InsuranceCompany,@Amount,@Local," + "@InsuranceDate,@NextInsuranceDate,@RemindDate,@CreateDate,@UpdateDate,@Creator,@Operator,@Valid)"; try { transaction = base.BeginTransaction(CarManageConfig.Instance.ConnectionString); base.Execute(commandText, transaction:transaction, param: insuranceInfo); commandText = "INSERT INTO InsuranceItem(Id,InsuranceId,CarId,ItemName,ItemCode,Amount)" + "VALUES(@Id,@InsuranceId,@CarId,@ItemName,@ItemCode,@Amount)"; base.Execute(commandText, transaction: transaction, param: insuranceInfo.Items); base.Commit(transaction); } catch (Exception ex) { base.Rollback(transaction); DataAccessExceptionHandler.HandlerException("新增保险信息失败!", ex); } finally { CloseConnection(transaction.Connection); } }
/// <summary> /// 新增保险信息 /// </summary> /// <param name="insuranceInfo">保险信息</param> public void Add(InsuranceInfo insuranceInfo) { try { insuranceInfo.ItemSummary = GetItemSummary(insuranceInfo.Items); insurance.Add(insuranceInfo); } catch (Exception ex) { BusinessExceptionHandler.HandlerException("新增保险信息失败!", ex); } }
/// <summary> /// 查询保险信息 /// </summary> /// <returns>保险信息集合</returns> public List<InsuranceInfo> Search(InsuranceInfo queryInfo) { List<InsuranceInfo> insuranceList = new List<InsuranceInfo>(); try { insuranceList = insurance.Search(queryInfo); } catch (Exception ex) { BusinessExceptionHandler.HandlerException("查询保险信息失败!", ex); } return insuranceList; }
public void Save() { try { InsuranceInfo insuranceInfo = new InsuranceInfo(); if (string.IsNullOrEmpty(InsuranceId)) { insuranceInfo.Id = Guid.NewGuid().ToString(); insuranceInfo.CreateDate = DateTime.Now; insuranceInfo.Creator = CarManageConfig.Instance.UserData.UserName; } else { insuranceInfo = insurance.Load(InsuranceId); } insuranceInfo.FrameNumber = CommonUtil.FilterInput(txtFrameNumber.Text); insuranceInfo.EngineNumber = CommonUtil.FilterInput(txtEngineNumber.Text); insuranceInfo.Insurant = CommonUtil.FilterInput(txtInsurant.Text); insuranceInfo.InsurantPhone = CommonUtil.FilterInput(txtInsurantPhone.Text); insuranceInfo.InsuranceCompanyCode = cbxInsuranceCompany.SelectedValue.ToString(); insuranceInfo.Local = chkLocal.Checked; foreach (ListControlItem item in chklstItems.SelectedItem) { insuranceInfo.Items.Add(new InsuranceItemInfo() { Id = Guid.NewGuid().ToString(), InsuranceId = insuranceInfo.Id, CarId = this.CarId, ItemName = item.Text, ItemCode = item.Value, }); } insuranceInfo.Amount = ConvertUtil.ToDecimal(CommonUtil.FilterInput(txtAmount.Text)); insuranceInfo.NextInsuranceDate = ConvertUtil.ToNullableDateTime(dtpNextInsuranceDate.Text); insuranceInfo.Operator = CarManageConfig.Instance.UserData.UserName; insuranceInfo.UpdateDate = DateTime.Now; insuranceInfo.Valid = true; if (string.IsNullOrEmpty(InsuranceId)) { insurance.Add(insuranceInfo); } else { insurance.Update(insuranceInfo); } } catch (Exception ex) { UserInterfaceExceptionHandler.HandlerException("保存保险信息失败!", ref ex); } }
/// <summary> /// 更新保险信息 /// </summary> /// <param name="insuranceInfo">保险信息对象</param> public void Update(InsuranceInfo insuranceInfo) { IDbTransaction transaction = base.BeginTransaction(CarManageConfig.Instance.ConnectionString); string commandText = "UPDATE Insurance SET " + "CarNumber=@CarNumber,FrameNumber=@FrameNumber,EngineNumber=@EngineNumber,ItemSummary=@ItemSummary," + "Insurant=@Insurant,InsurantPhone=@InsurantPhone,InsurantId=@InsurantId,InsuranceCompany=@InsuranceCompany," + "Amount=@Amount,Local=@Local,InsuranceDate=@InsuranceDate,NextInsuranceDate=@NextInsuranceDate," + "RemindDate=@RemindDate,CreateDate=@CreateDate,UpdateDate=@UpdateDate,Creator=@Creator," + "Operator=@Operator,Valid=@Valid WHERE Id=@Id"; try { base.Execute(commandText, transaction: transaction, param: insuranceInfo); commandText = "DELETE FROM InsuranceItem WHERE InsuranceId=@InsuranceId"; base.Execute(commandText, transaction: transaction, param: new { InsuranceId = insuranceInfo.Id }); commandText = "INSERT INTO InsuranceItem(Id,InsuranceId,CarId,ItemNameItemCode,Amount)" + "VALUES(@Id,@InsuranceId,@CarId,@ItemName,@ItemCode,@Amount)"; base.Execute(commandText, transaction: transaction, param: insuranceInfo.Items); base.Commit(transaction); } catch (Exception ex) { base.Rollback(transaction); DataAccessExceptionHandler.HandlerException("更新保险信息失败!", ex); } finally { CloseConnection(transaction.Connection); } }
/// <summary> /// 获得所有保险信息集合 /// </summary> /// <returns>保险信息集合</returns> public List<InsuranceInfo> Search(InsuranceInfo queryInfo) { IDbConnection connection = null; List<InsuranceInfo> insuranceList = new List<InsuranceInfo>(); try { string field = "*"; string table = "Insurance"; string order = "ORDER BY Id"; StringBuilder filter = new StringBuilder(); #region 查询条件 #endregion string filterText = string.Empty; if (filter.Length > 0) { filterText = filter.ToString().TrimStart(' ').Remove(0, 3).Insert(0, " WHERE "); } string commandText = string.Format("SELECT COUNT(*) FROM Insurance {0}", filterText); connection = base.CreateConnection(CarManageConfig.Instance.ConnectionString); queryInfo.TotalCount = base.ExecuteObject<int>(commandText: commandText, connection: connection, param: queryInfo); if (queryInfo.TotalCount.Equals(0)) return insuranceList; int pageCount = queryInfo.TotalCount / queryInfo.PageSize + 1; if (queryInfo.TotalCount % queryInfo.PageSize != 0) pageCount++; int startIndex = queryInfo.PageIndex * queryInfo.PageSize; commandText = string.Format("SELECT {0} FROM {1} WHERE {2} ORDER BY {3} LIMIT {4},{5}", field, table, filterText, order, startIndex, queryInfo.PageSize); insuranceList = base.Query<InsuranceInfo>(commandText, connection, param: queryInfo).ToList(); } catch (Exception ex) { DataAccessExceptionHandler.HandlerException( "查询保险信息失败!", ex); } finally { CloseConnection(connection); } return insuranceList; }