Пример #1
0
        public M_GuestBook GetModelFromReader(DbDataReader rdr)
        {
            M_GuestBook model = new M_GuestBook();

            model.GID      = Convert.ToInt32(rdr["GID"]);
            model.ParentID = ConvertToInt(rdr["ParentID"]);
            model.CateID   = ConvertToInt(rdr["CateID"]);
            model.UserID   = ConvertToInt(rdr["UserID"]);
            model.Title    = ConverToStr(rdr["Title"]);
            model.TContent = ConverToStr(rdr["TContent"]);
            model.GDate    = ConvertToDate(rdr["GDate"]);
            model.IP       = ConverToStr(rdr["IP"]);
            model.Status   = ConvertToInt(rdr["Status"]);
            rdr.Close();
            return(model);
        }
Пример #2
0
        public override SqlParameter[] GetParameters()
        {
            M_GuestBook model = this;

            if (model.GDate <= DateTime.MinValue)
            {
                model.GDate = DateTime.Now;
            }
            SqlParameter[] sp = GetSP();
            sp[0].Value = model.GID;
            sp[1].Value = model.ParentID;
            sp[2].Value = model.CateID;
            sp[3].Value = model.UserID;
            sp[4].Value = HtmlEncode(model.Title);
            sp[5].Value = model.TContent;
            sp[6].Value = model.GDate;
            sp[7].Value = model.IP;
            sp[8].Value = model.Status;
            return(sp);
        }