private SqlParameter[] GetParameters(M_Survey m_Survey) { SqlParameter[] parameter = new SqlParameter[] { new SqlParameter("@SurveyID", SqlDbType.Int), new SqlParameter("@SurveyName", SqlDbType.NVarChar,50), new SqlParameter("@Description", SqlDbType.NText), new SqlParameter("@IPRepeat", SqlDbType.Int,4), new SqlParameter("@CreateDate", SqlDbType.DateTime,8), new SqlParameter("@EndTime", SqlDbType.DateTime,8), new SqlParameter("@IsOpen", SqlDbType.Int,4), new SqlParameter("@NeedLogin", SqlDbType.Int,4), new SqlParameter("@Template", SqlDbType.NVarChar,255) }; parameter[0].Value = m_Survey.SurveyID; parameter[1].Value = m_Survey.SurveyName; parameter[2].Value = m_Survey.Description; parameter[3].Value = m_Survey.IPRepeat; parameter[4].Value = m_Survey.CreateDate; parameter[5].Value = m_Survey.EndTime; parameter[6].Value = m_Survey.IsOpen; parameter[7].Value = m_Survey.NeedLogin; parameter[8].Value = m_Survey.Template; return parameter; }
public bool UpdateSurvey(M_Survey m_Survey) { return dal.UpdateSurvey(m_Survey); }
public bool AddSurvey(M_Survey m_Survey) { return dal.AddSurvey(m_Survey); }
private M_Survey GetSurveyInfoFromReader(SqlDataReader reader) { M_Survey info = new M_Survey(); info.SurveyID = DataConverter.CLng(reader["SurveyID"].ToString()); info.SurveyName = reader["SurveyName"].ToString(); info.Description = reader["Description"].ToString(); info.IPRepeat = DataConverter.CLng(reader["IPRepeat"].ToString()); info.CreateDate = DataConverter.CDate(reader["CreateDate"].ToString()); info.EndTime = DataConverter.CDate(reader["EndTime"]); info.IsOpen = DataConverter.CLng(reader["IsOpen"]); info.NeedLogin = DataConverter.CLng(reader["NeedLogin"]); info.Template = reader["Template"].ToString(); return info; }
public bool UpdateSurvey(M_Survey m_Survey) { SqlParameter[] cmdParams = GetParameters(m_Survey); ; return SqlHelper.ExecuteProc("PR_Survey_Update", cmdParams); }
public bool AddSurvey(M_Survey m_Survey) { string strSql = "PR_Survey_Add"; SqlParameter[] parameter = GetParameters(m_Survey); return SqlHelper.ExecuteProc(strSql, parameter); }