Esempio n. 1
0
        public M_Exam_Answer GetModelFromReader(DbDataReader rdr)
        {
            M_Exam_Answer model = new M_Exam_Answer();

            model.ID         = Convert.ToInt32(rdr["ID"]);
            model.UserID     = Convert.ToInt32(rdr["UserID"]);
            model.UserName   = rdr["UserName"].ToString();
            model.QID        = ConvertToInt(rdr["QID"]);
            model.QTitle     = rdr["QTitle"].ToString();
            model.QType      = rdr["QType"].ToString();
            model.Answer     = rdr["Answer"].ToString();
            model.CDate      = ConvertToDate(rdr["CDate"]);
            model.FlowID     = ConverToStr(rdr["FlowID"]);
            model.PaperID    = ConvertToInt(rdr["PaperID"]);
            model.PaperName  = ConverToStr(rdr["PaperName"]);
            model.Score      = ConvertToInt(rdr["Score"]);
            model.TechID     = ConvertToInt(rdr["TechID"]);
            model.TechName   = ConverToStr(rdr["TechName"]);
            model.IsRight    = ConvertToInt(rdr["IsRight"]);
            model.Remark     = ConverToStr(rdr["Remark"]);
            model.RDate      = ConvertToDate(rdr["RDate"]);
            model.Remind     = ConverToStr(rdr["Remind"]);
            model.TotalScore = ConvertToInt(rdr["TotalScore"]);
            model.pid        = ConvertToInt(rdr["pid"]);
            model.StartDate  = ConvertToDate(rdr["StartDate"]);
            model.MySchool   = ConverToStr(rdr["MySchool"]);
            model.MyClass    = ConverToStr(rdr["MyClass"]);
            rdr.Close();
            return(model);
        }
Esempio n. 2
0
        public override SqlParameter[] GetParameters()
        {
            M_Exam_Answer model = this;

            if (CDate <= DateTime.MinValue)
            {
                CDate = DateTime.Now;
            }
            if (RDate <= DateTime.MinValue)
            {
                RDate = DateTime.Now;
            }
            if (StartDate <= DateTime.MinValue)
            {
                StartDate = DateTime.Now;
            }
            SqlParameter[] sp = GetSP();
            sp[0].Value  = model.ID;
            sp[1].Value  = model.UserID;
            sp[2].Value  = model.UserName;
            sp[3].Value  = model.QID;
            sp[4].Value  = model.QTitle;
            sp[5].Value  = model.QType;
            sp[6].Value  = model.Answer;
            sp[7].Value  = model.CDate;
            sp[8].Value  = model.FlowID;
            sp[9].Value  = model.PaperID;
            sp[10].Value = model.PaperName;
            sp[11].Value = model.Score;
            sp[12].Value = model.TechID;
            sp[13].Value = model.TechName;
            sp[14].Value = model.IsRight;
            sp[15].Value = model.Remark;
            sp[16].Value = model.RDate;
            sp[17].Value = model.Remind;
            sp[18].Value = model.TotalScore;
            sp[19].Value = model.pid;
            sp[20].Value = model.StartDate;
            sp[21].Value = model.MySchool;
            sp[22].Value = model.MyClass;
            return(sp);
        }