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