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); }
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); }