/// <summary>
/// 获得投票选项数据列表
/// </summary>
/// <param name="currentPage">当前的页数</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="count">总数量</param>
/// <returns>投票选项数据列表</returns>
public List <VoteItemInfo> ReadVoteItemList(int currentPage, int pageSize, VoteItemSearchInfo voteitemSearch, ref int count, string orderType)
{
List <VoteItemInfo> voteItemList = new List <VoteItemInfo>();
ShopMssqlPagerClass pc = new ShopMssqlPagerClass();
pc.TableName = "VoteItem";
pc.Fields = "[ID],[VoteID],[ItemName],[VoteCount],[OrderID],[Image],[Department],[Solution],[Point],[CoverDepartment],[Detail],[Exp1],[Exp2],[Exp3],[Exp4],[Exp5]";
pc.CurrentPage = currentPage;
pc.PageSize = pageSize;
if (string.IsNullOrEmpty(orderType))
{
pc.OrderField = "[OrderID],[ID]";
}
else
{
pc.OrderField = "[" + orderType + "],[OrderID]";
}
pc.OrderType = OrderType.Desc;
PrepareCondition(pc.MssqlCondition, voteitemSearch);
//pc.Count = count;
count = pc.Count;
using (SqlDataReader dr = pc.ExecuteReader())
{
PrepareVoteItemModel(dr, voteItemList);
}
return(voteItemList);
}
public List <VoteItemInfo> ReadVoteItemList(VoteItemSearchInfo voteItemSearch)
{
MssqlCondition mssqlCondition = new MssqlCondition();
PrepareCondition(mssqlCondition, voteItemSearch);
List <VoteItemInfo> VoteItemList = new List <VoteItemInfo>();
SqlParameter[] parameters =
{
new SqlParameter("@condition", SqlDbType.NVarChar)
};
parameters[0].Value = mssqlCondition.ToString() + " ORDER BY [OrderID] desc,[ID] desc";
using (SqlDataReader dr = ShopMssqlHelper.ExecuteReader(ShopMssqlHelper.TablePrefix + "SearchVoteItemList", parameters))
{
PrepareVoteItemModel(dr, VoteItemList);
}
return(VoteItemList);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CheckAdminPower("ReadVoteItem", PowerCheckType.Single);
foreach (VoteInfo voteInfo in VoteBLL.ReadNamedList())
{
VoteID.Items.Add(new ListItem(voteInfo.Title, "|" + voteInfo.ID + "|"));
}
VoteID.Items.Insert(0, new ListItem("所有类别", string.Empty));
Title.Text = RequestHelper.GetQueryString <string>("Title");
VoteID.Text = RequestHelper.GetQueryString <string>("VoteID");
IsShow.Text = RequestHelper.GetQueryString <string>("IsShow");
VoteItemSearchInfo itemSearch = new VoteItemSearchInfo();
itemSearch.ItemName = RequestHelper.GetQueryString <string>("Title");
itemSearch.VoteID = !string.IsNullOrEmpty(RequestHelper.GetQueryString <string>("VoteID")) ? "|" + RequestHelper.GetQueryString <string>("VoteID") + "|" : string.Empty;
itemSearch.Exp2 = RequestHelper.GetQueryString <string>("IsShow");
BindControl(VoteItemBLL.ReadVoteItemList(CurrentPage, PageSize, itemSearch, ref Count, string.Empty), RecordList, MyPager);
}
}
public static List <VoteItemInfo> ReadVoteItemList(VoteItemSearchInfo voteItemSearch)
{
return(dal.ReadVoteItemList(voteItemSearch));
}
/// <summary>
/// 获得投票选项数据列表
/// </summary>
/// <param name="currentPage">当前的页数</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="count">总数量</param>
/// <returns>投票选项数据列表</returns>
public static List <VoteItemInfo> ReadVoteItemList(int currentPage, int pageSize, VoteItemSearchInfo voteitemSearch, ref int count, string orderType)
{
return(dal.ReadVoteItemList(currentPage, pageSize, voteitemSearch, ref count, orderType));
}
/// <summary>
/// 组合搜索条件
/// </summary>
/// <param name="mssqlCondition"></param>
/// <param name="voteItemSearch"></param>
public void PrepareCondition(MssqlCondition mssqlCondition, VoteItemSearchInfo voteItemSearch)
{
mssqlCondition.Add("[ItemName]", voteItemSearch.ItemName, ConditionType.Like);
mssqlCondition.Add("[Exp2]", voteItemSearch.Exp2, ConditionType.Equal);
mssqlCondition.Add("[VoteID]", voteItemSearch.VoteID, ConditionType.Like);;
}
