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));
}
