public void InsertPoll(PollInfo poll)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[6];
objParams[0] = new SqlParameter("@Title", poll.Title);
objParams[1] = new SqlParameter("@Items", poll.Items);
objParams[2] = new SqlParameter("@voteNum", poll.Num);
objParams[3] = new SqlParameter("@Multiple", poll.IsMultiple);
objParams[4] = new SqlParameter("@canView", poll.CanView);
objParams[5] = new SqlParameter("@inIndex", poll.InIndex);
objSqlHelper.ExecuteNonQuery("je_Poll_InsertPoll", objParams);
}
public int UpdatePoll(PollInfo poll)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[7];
objParams[0] = new SqlParameter("@Title", poll.Title);
objParams[1] = new SqlParameter("@Items", poll.Items);
objParams[2] = new SqlParameter("@voteNum", poll.Num);
objParams[3] = new SqlParameter("@Multiple", poll.IsMultiple);
objParams[4] = new SqlParameter("@canView", poll.CanView);
objParams[5] = new SqlParameter("@inIndex", poll.InIndex);
objParams[6] = new SqlParameter("@PollID", poll.PollID);
return objSqlHelper.ExecuteNonQuery("je_Poll_UpdatePoll", objParams);
}
public PollInfo GetPollByID(int pollID)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[1];
objParams[0] = new SqlParameter("@pollID", SqlDbType.Int, 4);
objParams[0].Value = pollID;
SqlDataReader reader = objSqlHelper.ExecuteReader("je_Poll_GetPollByID", objParams);
PollInfo item = new PollInfo();
while (reader.Read())
{
item.PollID = reader.GetInt32(reader.GetOrdinal("PollID"));
item.Title = reader.GetString(reader.GetOrdinal("Title"));
item.Items = reader.GetString(reader.GetOrdinal("Items"));
item.InIndex = reader.GetBoolean(reader.GetOrdinal("InIndex"));
item.IsMultiple = reader.GetBoolean(reader.GetOrdinal("Multiple"));
item.Num = reader.GetString(reader.GetOrdinal("voteNum"));
item.CanView = reader.GetBoolean(reader.GetOrdinal("canView"));
}
reader.Close();
return item;
}
/// <summary>
/// 更新投票
/// </summary>
/// <param name="link"></param>
/// <returns></returns>
public static int UpdatePollNum(PollInfo poll)
{
return polls.UpdatePollNum(poll);
}
/// <summary>
/// 增加投票
/// </summary>
/// <param name="link"></param>
public static void InsertPoll(PollInfo poll)
{
polls.InsertPoll(poll);
}
public int UpdatePollNum(PollInfo poll)
{
SqlHelper objSqlHelper = new SqlHelper();
SqlParameter[] objParams = new SqlParameter[2];
objParams[0] = new SqlParameter("@voteNum", poll.Num);
objParams[1] = new SqlParameter("@PollID", poll.PollID);
return objSqlHelper.ExecuteNonQuery("je_Poll_UpdatePollNum", objParams);
}
