protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //CheckAdminPower("ReadFlash", PowerCheckType.Single); string action = RequestHelper.GetQueryString <string>("Action"); type = RequestHelper.GetQueryString <int>("type") <= 0?1:RequestHelper.GetQueryString <int>("type"); if (action == "Delete") { CheckAdminPower("DeleteFlash", PowerCheckType.Single); int id = RequestHelper.GetQueryString <int>("Id"); if (id > 0) { FlashBLL.Delete(id); AdminLogBLL.Add(ShopLanguage.ReadLanguage("DeleteRecord"), ShopLanguage.ReadLanguage("Flash"), id); foreach (var adImage in AdImageBLL.ReadList(id)) { AdminLogBLL.Add(ShopLanguage.ReadLanguage("DeleteRecord"), ShopLanguage.ReadLanguage("FlashPhoto"), adImage.Id); } AdImageBLL.DeleteByAdType(id); //ScriptHelper.Alert(ShopLanguage.ReadLanguage("DeleteOK"), RequestHelper.RawUrl); } } LotteryActivitySearchInfo activitySearch = new LotteryActivitySearchInfo(); activitySearch.ActivityType = (int)LotteryActivityType.Wheel; BindControl(LotteryActivityBLL.SearchList(CurrentPage, PageSize, activitySearch, ref Count), RecordList, MyPager); } }
public MssqlCondition PrepareCondition(LotteryActivitySearchInfo activitySearch) { MssqlCondition mssqlCondition = new MssqlCondition(); mssqlCondition.Add("[ActivityName]", activitySearch.ActivityName, ConditionType.Like); mssqlCondition.Add("[ActivityType]", activitySearch.ActivityType, ConditionType.Equal); mssqlCondition.Add("[ActivityKey]", activitySearch.ActivityKey, ConditionType.Like);; mssqlCondition.Add("[ActivityDesc]", activitySearch.ActivityDesc, ConditionType.Like); mssqlCondition.Add("[StartTime]", activitySearch.StartTime, ConditionType.MoreOrEqual); mssqlCondition.Add("[EndTime]", activitySearch.EndTime, ConditionType.LessOrEqual); mssqlCondition.Add("[IsOpened]", activitySearch.IsOpened, ConditionType.Equal); return(mssqlCondition); }
public List <LotteryActivityInfo> SearchList(LotteryActivitySearchInfo searchInfo) { using (var conn = new SqlConnection(connectString)) { string sql = "select * from [LotteryActivity]"; string condition = PrepareCondition(searchInfo).ToString(); if (!string.IsNullOrEmpty(condition)) { sql += " where " + condition; } sql += " Order by [OrderId] desc,[RealDate] desc,[Id] desc"; return(conn.Query <LotteryActivityInfo>(sql).ToList()); } }
public List <LotteryActivityInfo> SearchList(int currentPage, int pageSize, LotteryActivitySearchInfo searchInfo, ref int count) { using (var conn = new SqlConnection(connectString)) { ShopMssqlPagerClass pc = new ShopMssqlPagerClass(); pc.TableName = "[LotteryActivity]"; pc.Fields = "*"; pc.CurrentPage = currentPage; pc.PageSize = pageSize; pc.OrderField = "[Id]"; pc.OrderType = OrderType.Desc; pc.MssqlCondition = PrepareCondition(searchInfo); count = pc.Count; return(conn.Query <LotteryActivityInfo>(pc).ToList()); } }
public static List <LotteryActivityInfo> SearchList(LotteryActivitySearchInfo searchInfo) { return(dal.SearchList(searchInfo)); }
public static List <LotteryActivityInfo> SearchList(int currentPage, int pageSize, LotteryActivitySearchInfo searchInfo, ref int count) { return(dal.SearchList(currentPage, pageSize, searchInfo, ref count)); }