/// <summary>
/// 获得所有招揽信息集合
/// </summary>
/// <returns>招揽信息集合</returns>
public List<SolicitListInfo> Search(SolicitQueryInfo queryInfo)
{
IDbConnection connection = null;
List<SolicitListInfo> solicitList = new List<SolicitListInfo>();
try
{
string field = "c.Number, c.Model, c.Displacement, b.Owner, a.ActivityCode, a.Content, a.EstimateDate, b.FreeTime, a.Status, "
+ "SolicitID=a.ID, a.CustomerID, a.CarID ";
string table = "Solicit a, Customer b, Car c";
string order = "ORDER BY a.EstimateDate, c.Number";
StringBuilder filter = new StringBuilder();
#region 查询条件
filter.Append("and a.CustomerId=b.ID and a.CarID=c.ID ");
if (!string.IsNullOrWhiteSpace(queryInfo.Number))
filter.Append("and c.Number like '%'+@Number+'%' ");
if (!string.IsNullOrWhiteSpace(queryInfo.Owner))
filter.Append("and b.Owner like '%'+@Owner+'%' ");
if (!string.IsNullOrWhiteSpace(queryInfo.Mobile))
filter.Append("and b.Mobile like '%'+@Mobile+'%' ");
if (!string.IsNullOrWhiteSpace(queryInfo.Solicitor))
filter.Append("and a.Solicitor=@Solicitor ");
if (!string.IsNullOrWhiteSpace(queryInfo.ActivityCode))
filter.Append("and a.ActivityCode=@ActivityCode ");
#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 {0} {1}", table, filterText);
connection = base.CreateConnection(CarManageConfig.Instance.ConnectionString);
queryInfo.TotalCount = base.ExecuteObject<int>(commandText: commandText,
connection: connection, param: queryInfo);
if (queryInfo.TotalCount.Equals(0))
return solicitList;
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);
solicitList = base.Query<SolicitListInfo>(commandText, connection, param: queryInfo).ToList();
}
catch (Exception ex)
{
DataAccessExceptionHandler.HandlerException(
"查询招揽列表信息失败！", ex);
}
finally
{
CloseConnection(connection);
}
return solicitList;
}
/// <summary>
/// 查询招揽信息
/// </summary>
/// <returns>招揽信息集合</returns>
public List<SolicitListInfo> Search(SolicitQueryInfo queryInfo)
{
List<SolicitListInfo> solicitList = new List<SolicitListInfo>();
try
{
solicitList = solicit.Search(queryInfo);
}
catch (Exception ex)
{
BusinessExceptionHandler.HandlerException("查询招揽信息失败！", ex);
}
return solicitList;
}
private void btnSearch_Click(object sender, EventArgs e)
{
SolicitQueryInfo queryInfo = new SolicitQueryInfo();
queryInfo.Number = CommonUtil.FilterInput(txtNumber.Text.Trim());
queryInfo.Owner = CommonUtil.FilterInput(txtOwner.Text.Trim());
queryInfo.Mobile = CommonUtil.FilterInput(txtMobile.Text.Trim());
queryInfo.Solicitor = Solicitor;
queryInfo.ActivityCode = ActivityCode;
List<SolicitListInfo> list = solicit.Search(queryInfo);
dgvList.DataSource = list;
}