private SqlParameter[] GetParameters(M_Question m_Question) { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@QuestionID", SqlDbType.Int,4), new SqlParameter("@SurveryID", SqlDbType.Int,4), new SqlParameter("@TypeID", SqlDbType.Int,4), new SqlParameter("@QuestionTitle", SqlDbType.NVarChar,255), new SqlParameter("@QuestionContent", SqlDbType.Text), new SqlParameter("@QuestionCreateTime", SqlDbType.DateTime,8), new SqlParameter("@ManagerID", SqlDbType.Int,4) }; parameter[0].Value = m_Question.QuestionID; parameter[1].Value = m_Question.SurveryID; parameter[2].Value = m_Question.TypeID; parameter[3].Value = m_Question.QuestionTitle; parameter[4].Value = m_Question.QuestionContent; parameter[5].Value = m_Question.QuestionCreateTime; parameter[6].Value = m_Question.ManagerID; return parameter; }
public bool UpdateQuestion(M_Question m_Question) { return dal.UpdateQuestion(m_Question); }
public bool AddQuestiony(M_Question m_Question) { return dal.AddQuestiony(m_Question); }
private M_Question GetQuestionInfoFromReader(SqlDataReader reader) { M_Question info = new M_Question(); info.QuestionID = DataConverter.CLng(reader["QuestionID"].ToString()); info.SurveryID = DataConverter.CLng(reader["SurveryID"].ToString()); info.TypeID = DataConverter.CLng(reader["TypeID"].ToString()); info.QuestionTitle = reader["QuestionTitle"].ToString(); info.QuestionContent =reader["QuestionContent"].ToString(); info.QuestionCreateTime = DataConverter.CDate(reader["QuestionCreateTime"]); info.ManagerID = DataConverter.CLng(reader["ManagerID"]); return info; }
public bool UpdateQuestion(M_Question m_Question) { SqlParameter[] cmdParams = GetParameters(m_Question); ; return SqlHelper.ExecuteProc("PR_Questiony_Update", cmdParams); }
public bool AddQuestiony(M_Question m_Question) { string strSql = "PR_Questiony_Add"; SqlParameter[] parameter = GetParameters(m_Question); return SqlHelper.ExecuteProc(strSql, parameter); }