Beispiel #1
0
        public M_User_Temp GetModelFromReader(DbDataReader rdr)
        {
            M_User_Temp model = new M_User_Temp();

            model.ID       = Convert.ToInt32(rdr["ID"]);
            model.UserID   = Convert.ToInt32(rdr["UserID"]);
            model.CDate    = ConvertToDate(rdr["CDate"]);
            model.Describe = ConverToStr(rdr["Describe"]);
            model.Str1     = ConverToStr(rdr["Str1"]);
            model.Str2     = ConverToStr(rdr["Str2"]);
            model.Str3     = ConverToStr(rdr["Str3"]);
            model.Str4     = ConverToStr(rdr["Str4"]);
            model.Str5     = ConverToStr(rdr["Str5"]);
            model.Str6     = ConverToStr(rdr["Str6"]);
            model.UseType  = ConvertToInt(rdr["UseType"]);
            rdr.Close();
            return(model);
        }
Beispiel #2
0
        public override SqlParameter[] GetParameters()
        {
            M_User_Temp model = this;

            if (model.CDate <= DateTime.MinValue)
            {
                model.CDate = DateTime.Now;
            }
            SqlParameter[] sp = GetSP();
            sp[0].Value  = model.ID;
            sp[1].Value  = model.UserID;
            sp[2].Value  = model.CDate;
            sp[3].Value  = model.Describe;
            sp[4].Value  = model.Str1;
            sp[5].Value  = model.Str2;
            sp[6].Value  = model.Str3;
            sp[7].Value  = model.Str4;
            sp[8].Value  = model.Str5;
            sp[9].Value  = model.Str6;
            sp[10].Value = model.UseType;
            return(sp);
        }