public BetWhiteListInfo_Collection QueryBetWhiteListCollection(string userId, string userDisplayName, string isHm, DateTime startTime, DateTime endTime, int pageIndex, int pageSize)
{
Session.Clear();
BetWhiteListInfo_Collection collection = new BetWhiteListInfo_Collection();
collection.TotalCount = 0;
startTime = startTime.Date;
endTime = endTime.AddDays(1).Date;
StringBuilder strSql = new StringBuilder();
strSql.Append("select WhiteLlistId,UserId,UserDisplayName,isnull(IsEnable,0),RegisterTime,isnull(ExpansionOne,'')as ExpansionOne,isnull(ExpansionTwo,0) as ExpansionTwo,CreateTime,isnull(IsOpenHeMai,0)as IsOpenHeMai,Isnull(IsOpenBDFX,0)IsOpenBDFX,isnull(IsSingleScheme,0) IsSingleScheme from E_Bet_WhiteList where 1=1");
if (!string.IsNullOrEmpty(userId) || !string.IsNullOrEmpty(userDisplayName))
{
if (!string.IsNullOrEmpty(userId) && !BusinessHelper.CheckSQLCondition(userId))
{
strSql.Append(" and UserId='" + userId + "' ");
}
if (!string.IsNullOrEmpty(userDisplayName) && !BusinessHelper.CheckSQLCondition(userDisplayName))
{
strSql.Append(" and UserDisplayName='" + userDisplayName + "' ");
}
}
if (!string.IsNullOrEmpty(isHm) && !BusinessHelper.CheckSQLCondition(isHm))
{
strSql.Append(" and IsOpenHeMai=" + isHm + " ");
}
if (string.IsNullOrEmpty(userId) && string.IsNullOrEmpty(userDisplayName))
{
strSql.Append(" and CreateTime>='" + startTime + "' and CreateTime<'" + endTime + "'");
}
var result = Session.CreateSQLQuery(strSql.ToString()).List();
if (result != null)
{
collection.TotalCount = result.Count;
foreach (var item in result)
{
var array = item as object[];
BetWhiteListInfo info = new BetWhiteListInfo();
info.WhiteLlistId = Convert.ToInt32(array[0]);
info.UserId = array[1].ToString();
info.UserDisplayName = array[2].ToString();
info.IsEnable = Convert.ToBoolean(array[3]);
info.RegisterTime = Convert.ToDateTime(array[4]);
info.ExpansionOne = array[5].ToString();
info.ExpansionTwo = Convert.ToDecimal(array[6]);
info.CreateTime = Convert.ToDateTime(array[7]);
info.IsOpenHeMai = Convert.ToBoolean(array[8]);
info.IsOpenBDFX = Convert.ToBoolean(array[9]);
info.IsSingleScheme = Convert.ToBoolean(array[10]);
collection.BetInfoList.Add(info);
}
}
#region 暂时屏蔽
//if (string.IsNullOrEmpty(isHm))
//{
// var query = from b in Session.Query<BetWhiteList>()
// where (userId == string.Empty || b.UserId == userId) && (userDisplayName == string.Empty || b.UserDisplayName == userDisplayName) && (b.CreateTime >= startTime && b.CreateTime < endTime) && (b.IsOpenHeMai == false || b.IsOpenHeMai == true)
// select new BetWhiteListInfo
// {
// WhiteLlistId = b.WhiteLlistId,
// UserId = b.UserId,
// UserDisplayName = b.UserDisplayName,
// IsEnable = b.IsEnable,
// RegisterTime = b.RegisterTime,
// ExpansionOne = b.ExpansionOne,
// ExpansionTwo = b.ExpansionTwo,
// CreateTime = b.CreateTime,
// IsOpenHeMai = b.IsOpenHeMai == null ? false : b.IsOpenHeMai,
// };
// if (query != null && query.ToList().Count > 0)
// {
// collection.TotalCount = query.Count();
// collection.BetInfoList = query.Skip(pageIndex * pageSize).Take(pageSize).ToList();
// }
//}
//else if (isHm == "1")
//{
// var query = from b in Session.Query<BetWhiteList>()
// where (userId == string.Empty || b.UserId == userId) && (userDisplayName == string.Empty || b.UserDisplayName == userDisplayName) && (b.CreateTime >= startTime && b.CreateTime < endTime) && (b.IsOpenHeMai == true)
// select new BetWhiteListInfo
// {
// WhiteLlistId = b.WhiteLlistId,
// UserId = b.UserId,
// UserDisplayName = b.UserDisplayName,
// IsEnable = b.IsEnable,
// RegisterTime = b.RegisterTime,
// ExpansionOne = b.ExpansionOne,
// ExpansionTwo = b.ExpansionTwo,
// CreateTime = b.CreateTime,
// IsOpenHeMai = b.IsOpenHeMai == null ? false : b.IsOpenHeMai,
// };
// if (query != null && query.ToList().Count > 0)
// {
// collection.TotalCount = query.Count();
// collection.BetInfoList = query.Skip(pageIndex * pageSize).Take(pageSize).ToList();
// }
//}
//else
//{
// var query = from b in Session.Query<BetWhiteList>()
// where (userId == string.Empty || b.UserId == userId) && (userDisplayName == string.Empty || b.UserDisplayName == userDisplayName) && (b.CreateTime >= startTime && b.CreateTime < endTime) && b.IsOpenHeMai == false
// select new BetWhiteListInfo
// {
// WhiteLlistId = b.WhiteLlistId,
// UserId = b.UserId,
// UserDisplayName = b.UserDisplayName,
// IsEnable = b.IsEnable,
// RegisterTime = b.RegisterTime,
// ExpansionOne = b.ExpansionOne,
// ExpansionTwo = b.ExpansionTwo,
// CreateTime = b.CreateTime,
// IsOpenHeMai = b.IsOpenHeMai == null ? false : b.IsOpenHeMai,
// };
// if (query != null && query.ToList().Count > 0)
// {
// collection.TotalCount = query.Count();
// collection.BetInfoList = query.Skip(pageIndex * pageSize).Take(pageSize).ToList();
// }
//}
#endregion
collection.BetInfoList = collection.BetInfoList.Skip(pageIndex * pageSize).Take(pageSize).ToList();
return(collection);
}