Example #1
0
        public override SqlParameter[] GetParameters()
        {
            M_UserCourse model = this;

            SqlParameter[] sp = GetSP();
            sp[0].Value  = model.ID;
            sp[1].Value  = model.CourseID;
            sp[2].Value  = model.ClassID;
            sp[3].Value  = model.UserID;
            sp[4].Value  = model.CurrCoureHour;
            sp[5].Value  = model.State;
            sp[6].Value  = model.AddTime;
            sp[7].Value  = model.PayMent;
            sp[8].Value  = model.OrderID;
            sp[9].Value  = model.Aunit;
            sp[10].Value = model.Remark;
            return(sp);
        }
Example #2
0
        public M_UserCourse GetModelFromReader(DbDataReader rdr)
        {
            M_UserCourse model = new M_UserCourse();

            model.ID            = Convert.ToInt32(rdr["ID"]);
            model.CourseID      = ConvertToInt(rdr["CourseID"]);
            model.ClassID       = ConvertToInt(rdr["ClassID"]);
            model.UserID        = ConvertToInt(rdr["UserID"]);
            model.CurrCoureHour = Convert.ToInt64(rdr["CurrCoureHour"]);
            model.State         = ConvertToInt(rdr["State"]);
            model.AddTime       = ConvertToDate(rdr["AddTime"]);
            model.PayMent       = ConvertToInt(rdr["PayMent"]);
            model.OrderID       = ConverToStr(rdr["OrderID"]);
            model.Aunit         = ConvertToInt(rdr["Aunit"]);
            model.Remark        = ConverToStr(rdr["Remark"]);
            rdr.Close();
            rdr.Dispose();
            return(model);
        }