public override SqlParameter[] GetParameters() { M_Mail_BookRead model = this; if (model.CDate <= DateTime.MinValue) { model.CDate = DateTime.Now; } if (model.EndTime <= DateTime.MinValue) { model.EndTime = DateTime.Now; } SqlParameter[] sp = GetSP(); sp[0].Value = model.ID; sp[1].Value = model.Title; sp[2].Value = model.UserID; sp[3].Value = model.CDate; sp[4].Value = model.EndTime; sp[5].Value = model.IsNotRead; sp[6].Value = model.IsAudit; sp[7].Value = model.Reserve; sp[8].Value = model.Gid; sp[9].Value = model.UserType; sp[10].Value = model.IP; sp[11].Value = model.Source; sp[12].Value = model.Browser; sp[13].Value = model.EMail; sp[14].Value = model.AuthCode; return(sp); }
public M_Mail_BookRead GetModelFromReader(DbDataReader rdr) { M_Mail_BookRead model = new M_Mail_BookRead(); model.ID = Convert.ToInt32(rdr["ID"]); model.Title = rdr["Title"].ToString(); model.UserID = ConvertToInt(rdr["UserId"]); model.CDate = ConvertToDate(rdr["CDate"]); model.EndTime = ConvertToDate(rdr["EndTime"]); model.IsNotRead = ConvertToInt(rdr["IsNotRead"].ToString()); model.IsAudit = ConvertToInt(rdr["IsAudit"]); model.Reserve = rdr["Reserve"].ToString(); model.Gid = ConvertToInt(rdr["Gid"]); model.UserType = ConvertToInt(rdr["UserType"]); model.IP = ConverToStr(rdr["IP"]); model.Source = ConverToStr(rdr["Source"]); model.Browser = ConverToStr(rdr["Browser"]); model.EMail = ConverToStr(rdr["EMail"]); model.AuthCode = ConverToStr(rdr["AuthCode"]); rdr.Close(); return(model); }