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