public MssqlCondition PrepareCondition(PrizeRecordSearchInfo recordSearch)
{
MssqlCondition mssqlCondition = new MssqlCondition();
mssqlCondition.Add("[ActivityID]", recordSearch.ActivityID, ConditionType.Equal);
if (recordSearch.UserID > 0)
{
mssqlCondition.Add("[UserID]", recordSearch.UserID, ConditionType.Equal);
}
;
if (recordSearch.IsPrize > 0)
{
mssqlCondition.Add("[IsPrize]", recordSearch.IsPrize, ConditionType.Equal);
}
return(mssqlCondition);
}
public List <PrizeRecordInfo> SearchList(PrizeRecordSearchInfo searchInfo)
{
using (var conn = new SqlConnection(connectString))
{
string sql = "select * from [PrizeRecord]";
string condition = PrepareCondition(searchInfo).ToString();
if (!string.IsNullOrEmpty(condition))
{
sql += " where " + condition;
}
sql += " Order by [RecordId] desc";
return(conn.Query <PrizeRecordInfo>(sql).ToList());
}
}
public List <PrizeRecordInfo> SearchList(int currentPage, int pageSize, PrizeRecordSearchInfo searchInfo, ref int count)
{
using (var conn = new SqlConnection(connectString))
{
ShopMssqlPagerClass pc = new ShopMssqlPagerClass();
pc.TableName = "[PrizeRecord]";
pc.Fields = "*";
pc.CurrentPage = currentPage;
pc.PageSize = pageSize;
pc.OrderField = "[RecordId]";
pc.OrderType = OrderType.Desc;
pc.MssqlCondition = PrepareCondition(searchInfo);
count = pc.Count;
return(conn.Query <PrizeRecordInfo>(pc).ToList());
}
}
public static List <PrizeRecordInfo> SearchList(int currentPage, int pageSize, PrizeRecordSearchInfo searchInfo, ref int count)
{
return(dal.SearchList(currentPage, pageSize, searchInfo, ref count));
}
public static List <PrizeRecordInfo> SearchList(PrizeRecordSearchInfo searchInfo)
{
return(dal.SearchList(searchInfo));
}
