/// <summary> /// 新增通话录音信息 /// </summary> /// <param name="callRecordInfo">通话录音信息</param> public void Add(CallRecordInfo callRecordInfo) { try { callRecord.Add(callRecordInfo); } catch (Exception ex) { BusinessExceptionHandler.HandlerException("新增通话录音信息失败!", ex); } }
/// <summary> /// 新增通话录音信息 /// </summary> /// <param name="callRecordInfo">通话录音信息对象</param> public void Add(CallRecordInfo callRecordInfo) { string commandText = "INSERT INTO CallRecord(Id,CustomerId,CarId,SolicitId," + "CustomerName,CarNumber,Tel,Title,Feedback,Result,RecordPath,RecordMD5," + "OperatorCode,OperatorName,CreateDate)VALUES(@Id,@CustomerId,@CarId," + "@SolicitId,@CustomerName,@CarNumber,@Tel,@Title,@Feedback,@Result," + "@RecordPath,@RecordMD5,@OperatorCode,@OperatorName,@CreateDate)"; try { base.Execute(commandText, connectionString: CarManageConfig.Instance.ConnectionString, param: callRecordInfo); } catch (Exception ex) { DataAccessExceptionHandler.HandlerException("新增通话录音信息失败!", ex); } }
/// <summary> /// 更新通话录音信息 /// </summary> /// <param name="callRecordInfo">通话录音信息对象</param> public void Update(CallRecordInfo callRecordInfo) { string commandText = "UPDATE CallRecord SET " + "CustomerId=@CustomerId,CarId=@CarId,SolicitId=@SolicitId,CustomerName=@CustomerName," + "CarNumber=@CarNumber,Tel=@Tel,Title=@Title,Feedback=@Feedback,Result=@Result," + "RecordPath=@RecordPath,RecordMD5=@RecordMD5,OperatorCode=@OperatorCode," + "OperatorName=@OperatorName,CreateDate=@CreateDate WHERE Id=@Id"; try { base.Execute(commandText, connectionString: CarManageConfig.Instance.ConnectionString, param: callRecordInfo); } catch (Exception ex) { DataAccessExceptionHandler.HandlerException("更新通话录音信息失败!", ex); } }
/// <summary> /// 获得所有通话录音信息集合 /// </summary> /// <returns>通话录音信息集合</returns> public List<CallRecordInfo> Search(CallRecordInfo queryInfo) { IDbConnection connection = null; List<CallRecordInfo> callrecordList = new List<CallRecordInfo>(); try { string field = "*"; string table = "CallRecord"; 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 CallRecord {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 callrecordList; 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); callrecordList = base.Query<CallRecordInfo>(commandText, connection, param: queryInfo).ToList(); } catch (Exception ex) { DataAccessExceptionHandler.HandlerException( "查询通话录音信息失败!", ex); } finally { CloseConnection(connection); } return callrecordList; }
/// <summary> /// 更新通话录音信息 /// </summary> /// <param name="callRecordInfo">通话录音信息信息对象</param> public void Update(CallRecordInfo callRecordInfo) { try { callRecord.Update(callRecordInfo); } catch (Exception ex) { BusinessExceptionHandler.HandlerException("更新通话录音信息失败!", ex); } }
/// <summary> /// 查询通话录音信息 /// </summary> /// <returns>通话录音信息集合</returns> public List<CallRecordInfo> Search(CallRecordInfo queryInfo) { List<CallRecordInfo> callRecordList = new List<CallRecordInfo>(); try { callRecordList = callRecord.Search(queryInfo); } catch (Exception ex) { BusinessExceptionHandler.HandlerException("查询通话录音信息失败!", ex); } return callRecordList; }