/// <summary>
/// 组合搜索条件
/// </summary>
/// <param name="mssqlCondition"></param>
/// <param name="search">BargainSearch模型变量</param>
public MssqlCondition PrepareCondition(BargainSearch search)
{
MssqlCondition mssqlCondition = new MssqlCondition();
mssqlCondition.Add("[Name]", search.Name, ConditionType.Like);
//mssqlCondition.Add("[StartDate]",search.StartDate,ConditionType.Like);
//mssqlCondition.Add("[EndDate]",search.EndDate,ConditionType.Like);
mssqlCondition.Add("[LimitCount]", search.LimitCount, ConditionType.Equal);
mssqlCondition.Add("[NumberPeople]", search.NumberPeople, ConditionType.Equal);
mssqlCondition.Add("[ActivityRules]", search.ActivityRules, ConditionType.Like);
mssqlCondition.Add("[SuccessRate]", search.SuccessRate, ConditionType.Equal);
return(mssqlCondition);
}
/// <summary>
/// 搜索砍价数据列表
/// </summary>
/// <param name="search">BargainSearch模型变量</param>
/// <returns>砍价数据列表</returns>
public List <BargainInfo> SearchBargainList(BargainSearch search)
{
using (var conn = new SqlConnection(connectString))
{
string sql = "select * from Bargain";
string condition = PrepareCondition(search).ToString();
if (!string.IsNullOrEmpty(condition))
{
sql += " where " + condition;
}
return(conn.Query <BargainInfo>(sql).ToList());
}
}
/// <summary>
/// 搜索砍价数据列表
/// </summary>
/// <param name="currentPage">当前的页数</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="search">BargainSearch模型变量</param>
/// <param name="count">总数量</param>
/// <returns>砍价数据列表</returns>
public List <BargainInfo> SearchBargainList(int currentPage, int pageSize, BargainSearch search, ref int count)
{
using (var conn = new SqlConnection(connectString))
{
ShopMssqlPagerClass pc = new ShopMssqlPagerClass();
pc.TableName = "Bargain";
pc.Fields = "*";
pc.CurrentPage = currentPage;
pc.PageSize = pageSize;
pc.OrderType = OrderType.Desc;
pc.MssqlCondition = PrepareCondition(search);
count = pc.Count;
return(conn.Query <BargainInfo>(pc).ToList());
}
}
/// <summary>
/// 搜索砍价数据列表
/// </summary>
/// <param name="currentPage">当前的页数</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="model">BargainSearch模型变量</param>
/// <param name="count">总数量</param>
/// <returns>砍价数据列表</returns>
public static List <BargainInfo> SearchBargainList(int currentPage, int pageSize, BargainSearch model, ref int count)
{
return(dal.SearchBargainList(currentPage, pageSize, model, ref count));
}
/// <summary>
/// 搜索砍价数据列表
/// </summary>
/// <param name="model">BargainSearch模型变量</param>
/// <returns>砍价数据列表</returns>
public static List <BargainInfo> SearchBargainList(BargainSearch model)
{
return(dal.SearchBargainList(model));
}
