Пример #1
0
        public override SqlParameter[] GetParameters()
        {
            M_Answer model = this;

            if (SubmitDate <= DateTime.MinValue)
            {
                SubmitDate = DateTime.Now;
            }
            if (string.IsNullOrEmpty(model.AnswerContent))
            {
                model.AnswerContent = "";
            }
            SqlParameter[] sp = GetSP();
            sp[0].Value = model.AnswerID;
            sp[1].Value = model.SurveyID;
            sp[2].Value = model.QuestionID;
            sp[3].Value = model.AnswerContent;
            sp[4].Value = model.UserID;
            sp[5].Value = model.SubmitDate;
            sp[6].Value = model.SubmitIP;
            sp[7].Value = model.AnswerScore;
            //sp[5].Value = model.SubmitIP;
            //sp[7].Value = model.IsNull;
            return(sp);
        }
Пример #2
0
 private M_Answer GetAnswerInfoFromReader(SqlDataReader reader)
 {
     M_Answer info = new M_Answer();
     info.AnswerID = DataConverter.CLng(reader["AnswerID"].ToString());
     info.SurveryID = DataConverter.CLng(reader["SurveryID"].ToString());
     info.QuestionID = DataConverter.CLng(reader["QuestionID"].ToString());
     info.OptionID = DataConverter.CLng(reader["OptionID"].ToString());
     info.AnswerContent = reader["AnswerContent"].ToString();
     info.UserID = DataConverter.CLng(reader["UserID"]);
     return info;
 }
Пример #3
0
        public M_Answer GetModelFromReader(DbDataReader rdr)
        {
            M_Answer model = new M_Answer();

            model.AnswerID      = Convert.ToInt32(rdr["Aid"]);
            model.SurveyID      = ConvertToInt(rdr["SurveyID"]);
            model.QuestionID    = ConvertToInt(rdr["Qid"]);
            model.AnswerContent = ConverToStr(rdr["AnswerContent"]);
            model.UserID        = ConvertToInt(rdr["UserID"]);
            model.SubmitIP      = ConverToStr(rdr["SubmitIP"]);
            model.SubmitDate    = ConvertToDate(rdr["SubmitDate"]);
            model.AnswerScore   = ConvertToInt(rdr["AnswerScore"]);
            rdr.Close();
            rdr.Dispose();
            return(model);
        }
Пример #4
0
        private SqlParameter[] GetParameters(M_Answer m_Answer)
        {
            SqlParameter[] parameter = new SqlParameter[] {
                new SqlParameter("@AnswerID", SqlDbType.BigInt),
                new SqlParameter("@SurveryID", SqlDbType.Int,4),
                new SqlParameter("@QuestionID", SqlDbType.Int,4),
                new SqlParameter("@OptionID", SqlDbType.Int,4),
                new SqlParameter("@AnswerContent", SqlDbType.Text),
                new SqlParameter("@UserID", SqlDbType.Int,4)

            };
            parameter[0].Value = m_Answer.AnswerID;
            parameter[1].Value = m_Answer.SurveryID;
            parameter[2].Value = m_Answer.QuestionID;
            parameter[3].Value = m_Answer.OptionID;
            parameter[4].Value = m_Answer.AnswerContent;
            parameter[5].Value = m_Answer.UserID;
            return parameter;
        }
Пример #5
0
 public bool UpdateAnswer(M_Answer m_Answer)
 {
     return dal.UpdateAnswer(m_Answer);
 }
Пример #6
0
 public bool AddAnswer(M_Answer m_Answer)
 {
     return dal.AddAnswer(m_Answer);
 }
Пример #7
0
 public bool UpdateAnswer(M_Answer m_Answer)
 {
     SqlParameter[] cmdParams = GetParameters(m_Answer); ;
     return SqlHelper.ExecuteProc("PR_Answer_Update", cmdParams);
 }
Пример #8
0
 public bool AddAnswer(M_Answer m_Answer)
 {
     string strSql = "PR_Answer_Add";
     SqlParameter[] parameter = GetParameters(m_Answer);
     return SqlHelper.ExecuteProc(strSql, parameter);
 }