public MssqlCondition PrepareCondition(CouponSearchInfo searchInfo)
{
MssqlCondition mssqlCondition = new MssqlCondition();
mssqlCondition.Add("[Name]", searchInfo.Name, ConditionType.Like);
mssqlCondition.Add("[Id]", string.Join(",", searchInfo.InCouponIds), ConditionType.In);
if (searchInfo.Type > 0)
{
mssqlCondition.Add("[Type]", searchInfo.Type, ConditionType.Equal);
}
if (searchInfo.CanUse == 1)
{
mssqlCondition.Add(" DATEDIFF(day,getdate(),[UseStartDate])<=0 and DATEDIFF(day,getdate(),[UseEndDate])>=0");
}
//未开始
if (searchInfo.TimePeriod == 1)
{
mssqlCondition.Add(" DATEDIFF ( day , getdate(), [UseStartDate] )>0");
}
//进行中
if (searchInfo.TimePeriod == 2)
{
mssqlCondition.Add(" DATEDIFF(day,getdate(),[UseStartDate])<=0 and DATEDIFF(day,getdate(),[UseEndDate])>=0");
}
//已结束
if (searchInfo.TimePeriod == 3)
{
mssqlCondition.Add(" DATEDIFF(day,getdate(),[UseEndDate])<0");
}
return(mssqlCondition);
}
protected override void PageLoad()
{
base.PageLoad();
this.action = RequestHelper.GetQueryString <string>("Action");
int queryString = RequestHelper.GetQueryString <int>("Page");
if (queryString < 1)
{
queryString = 1;
}
int pageSize = 20;
int count = 0;
string action = this.action;
if (action != null)
{
if (!(action == "NotUse") && !(action == "HasUse"))
{
if ((action != "AddCoupon") && (action == "AddUserCoupon"))
{
this.AddUserCoupon();
}
}
else
{
UserCouponSearchInfo userCoupon = new UserCouponSearchInfo();
userCoupon.UserID = base.UserID;
if (this.action == "NotUse")
{
userCoupon.IsUse = 0;
}
else
{
userCoupon.IsUse = 1;
}
this.userCouponList = UserCouponBLL.SearchUserCouponList(queryString, pageSize, userCoupon, ref count);
this.ajaxPagerClass.CurrentPage = queryString;
this.ajaxPagerClass.PageSize = pageSize;
this.ajaxPagerClass.Count = count;
string str = string.Empty;
foreach (UserCouponInfo info2 in this.userCouponList)
{
if (str == string.Empty)
{
str = info2.CouponID.ToString();
}
else
{
str = str + "," + info2.CouponID.ToString();
}
}
if (str != string.Empty)
{
CouponSearchInfo coupon = new CouponSearchInfo();
coupon.InCouponID = str;
this.couponList = CouponBLL.SearchCouponList(coupon);
}
}
}
}
public List <CouponInfo> SearchCouponList(CouponSearchInfo couponSearch)
{
MssqlCondition mssqlCondition = new MssqlCondition();
this.PrepareCondition(mssqlCondition, couponSearch);
List <CouponInfo> couponList = new List <CouponInfo>();
SqlParameter[] pt = new SqlParameter[] { new SqlParameter("@condition", SqlDbType.NVarChar) };
pt[0].Value = mssqlCondition.ToString();
using (SqlDataReader reader = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "SearchCouponList", pt))
{
this.PrepareCouponModel(reader, couponList);
}
return(couponList);
}
public List <CouponInfo> SearchList(int currentPage, int pageSize, CouponSearchInfo searchInfo, ref int count)
{
using (var conn = new SqlConnection(connectString))
{
ShopMssqlPagerClass pc = new ShopMssqlPagerClass();
pc.TableName = "Coupon";
pc.Fields = " * ";
pc.CurrentPage = currentPage;
pc.PageSize = pageSize;
pc.OrderField = "[Id]";
pc.MssqlCondition = PrepareCondition(searchInfo);
count = pc.Count;
return(conn.Query <CouponInfo>(pc).ToList());
}
}
public List <CouponInfo> SearchCouponList(int currentPage, int pageSize, CouponSearchInfo couponSearch, ref int count)
{
List <CouponInfo> couponList = new List <CouponInfo>();
ShopMssqlPagerClass class2 = new ShopMssqlPagerClass();
class2.TableName = ShopMssqlHelper.TablePrefix + "Coupon";
class2.Fields = "[ID],[Name],[Money],[UseMinAmount],[UseStartDate],[UseEndDate]";
class2.CurrentPage = currentPage;
class2.PageSize = pageSize;
class2.OrderField = "[ID]";
class2.OrderType = OrderType.Desc;
this.PrepareCondition(class2.MssqlCondition, couponSearch);
class2.Count = count;
count = class2.Count;
using (SqlDataReader reader = class2.ExecuteReader())
{
this.PrepareCouponModel(reader, couponList);
}
return(couponList);
}
protected override void PageLoad()
{
base.PageLoad();
CheckAdminPower("ReadCoupon", PowerCheckType.Single);
couponKind = RequestHelper.GetQueryString <int>("couponkind");
//开始状态：未开始、进行中、已结束。默认: 进行中
timePeriod = RequestHelper.GetQueryString <int>("timeperiod") > 0? RequestHelper.GetQueryString <int>("timeperiod"):2;
CouponSearchInfo searchInfo = new CouponSearchInfo();
if (couponKind > 0)
{
searchInfo.Type = couponKind;
}
if (timePeriod > 0)
{
searchInfo.TimePeriod = timePeriod;
}
couponList = CouponBLL.SearchList(1, pageSize, searchInfo, ref Count);
}
public List <CouponInfo> SearchList(CouponSearchInfo searchInfo)
{
using (var conn = new SqlConnection(connectString))
{
string sql = "select * from Coupon where 1=1 ";
var para = new DynamicParameters();
if (searchInfo.InCouponIds.Length > 0)
{
sql += " and Id in @ids";
para.Add("ids", searchInfo.InCouponIds);
}
if (!string.IsNullOrEmpty(searchInfo.Name))
{
sql += " and Name like @name";
para.Add("name", "%" + searchInfo.Name + "%");
}
return(conn.Query <CouponInfo>(sql, para).ToList());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CheckAdminPower("ReadCoupon", PowerCheckType.Single);
couponKind = RequestHelper.GetQueryString <int>("couponkind");
//开始状态：未开始、进行中、已结束
timeperiod = RequestHelper.GetQueryString <int>("timeperiod") < 1?2: RequestHelper.GetQueryString <int>("timeperiod");
CouponSearchInfo searchInfo = new CouponSearchInfo();
if (couponKind > 0)
{
searchInfo.Type = couponKind;
}
if (timeperiod > 0)
{
searchInfo.TimePeriod = timeperiod;
}
List <CouponInfo> couponList = CouponBLL.SearchList(CurrentPage, PageSize, searchInfo, ref Count);
BindControl(couponList, RecordList, MyPager);
}
}
protected override void PageLoad()
{
base.PageLoad();
type = RequestHelper.GetQueryString <string>("type");
int currentPage = RequestHelper.GetQueryString <int>("Page");
if (currentPage < 1)
{
currentPage = 1;
}
int pageSize = 10;
int count = 0;
UserCouponSearchInfo userCouponSearch = new UserCouponSearchInfo();
userCouponSearch.UserId = base.UserId;
if (!string.IsNullOrEmpty(type))
{
if (type == "1")//未使用
{
userCouponSearch.IsUse = (int)BoolType.False;
userCouponSearch.IsTimeOut = (int)BoolType.False;
}
else if (type == "2")//已使用
{
userCouponSearch.IsUse = (int)BoolType.True;
userCouponSearch.IsTimeOut = -1;//不限期限有没过期
}
else//已过期
{
userCouponSearch.IsUse = (int)BoolType.False;
userCouponSearch.IsTimeOut = (int)BoolType.True;
}
}
else //所有
{
userCouponSearch.IsTimeOut = -1;
}
userCouponList = UserCouponBLL.SearchList(currentPage, pageSize, userCouponSearch, ref count);
commonPagerClass.Init(currentPage, pageSize, count, !string.IsNullOrEmpty(isMobile));
string idList = string.Empty;
foreach (UserCouponInfo userCoupon in userCouponList)
{
if (idList == string.Empty)
{
idList = userCoupon.CouponId.ToString();
}
else
{
idList += "," + userCoupon.CouponId.ToString();
}
}
if (idList != string.Empty)
{
CouponSearchInfo couponSearch = new CouponSearchInfo();
couponSearch.InCouponIds = Array.ConvertAll <string, int>(idList.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), i => Convert.ToInt32(i));
couponList = CouponBLL.SearchList(couponSearch);
}
}
public void PrepareCondition(MssqlCondition mssqlCondition, CouponSearchInfo couponSearch)
{
mssqlCondition.Add("[Name]", couponSearch.Name, ConditionType.Like);
mssqlCondition.Add("[ID]", couponSearch.InCouponID, ConditionType.In);
}
public static List <CouponInfo> SearchList(int currentPage, int pageSize, CouponSearchInfo searchInfo, ref int count)
{
return(dal.SearchList(currentPage, pageSize, searchInfo, ref count));
}
public static List <CouponInfo> SearchList(CouponSearchInfo searchInfo)
{
return(dal.SearchList(searchInfo));
}
/// <summary>
/// 页面加载
/// </summary>
protected override void PageLoad()
{
base.PageLoad();
action = RequestHelper.GetQueryString <string>("Action");
int currentPage = RequestHelper.GetQueryString <int>("Page");
if (currentPage < 1)
{
currentPage = 1;
}
int pageSize = 20;
int count = 0;
switch (action)
{
case "NotUse":
case "HasUse":
case "TimeOut":
UserCouponSearchInfo userCouponSearch = new UserCouponSearchInfo();
userCouponSearch.UserId = base.UserId;
if (action == "NotUse")
{
userCouponSearch.IsUse = (int)BoolType.False;
userCouponSearch.IsTimeOut = (int)BoolType.False;
}
else if (action == "HasUse")
{
userCouponSearch.IsUse = (int)BoolType.True;
userCouponSearch.IsTimeOut = -1; //不限期限有没过期
}
else
{
userCouponSearch.IsUse = (int)BoolType.False;
userCouponSearch.IsTimeOut = (int)BoolType.True;
}
userCouponList = UserCouponBLL.SearchList(currentPage, pageSize, userCouponSearch, ref count);
ajaxPagerClass.CurrentPage = currentPage;
ajaxPagerClass.PageSize = pageSize;
ajaxPagerClass.Count = count;
ajaxPagerClass.FirstPage = "<<首页";
ajaxPagerClass.PreviewPage = "<<上一页";
ajaxPagerClass.NextPage = "下一页>>";
ajaxPagerClass.LastPage = "末页>>";
ajaxPagerClass.ListType = false;
ajaxPagerClass.DisCount = false;
ajaxPagerClass.PrenextType = true;
string idList = string.Empty;
foreach (UserCouponInfo userCoupon in userCouponList)
{
if (idList == string.Empty)
{
idList = userCoupon.CouponId.ToString();
}
else
{
idList += "," + userCoupon.CouponId.ToString();
}
}
if (idList != string.Empty)
{
CouponSearchInfo couponSearch = new CouponSearchInfo();
couponSearch.InCouponIds = Array.ConvertAll <string, int>(idList.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), i => Convert.ToInt32(i));
couponList = CouponBLL.SearchList(couponSearch);
}
break;
case "AddCoupon":
break;
case "AddUserCoupon":
AddUserCoupon();
break;
default:
break;
}
}
public static List <CouponInfo> SearchCouponList(CouponSearchInfo coupon)
{
return(dal.SearchCouponList(coupon));
}
