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