public override SqlParameter[] GetParameters()
{
M_EMail_Item model = this;
if (model.CDate <= DateTime.MinValue)
{
model.CDate = DateTime.Now;
}
SqlParameter[] sp = GetSP();
sp[0].Value = model.ID;
sp[1].Value = model.Priority;
sp[2].Value = model.FromName;
sp[3].Value = model.FromEmail;
sp[4].Value = model.ReplyTo;
sp[5].Value = model.CCAddress;
sp[6].Value = model.ToAddress;
sp[7].Value = model.BCCAddress;
sp[8].Value = model.Subject;
sp[9].Value = model.MailBody;
sp[10].Value = model.Attachment;
sp[11].Value = model.SaveSendLog;
sp[12].Value = model.CDate;
sp[13].Value = model.Result;
sp[14].Value = model.Error;
return(sp);
}
public M_EMail_Item GetModelFromReader(DbDataReader rdr)
{
M_EMail_Item model = new M_EMail_Item();
model.ID = Convert.ToInt32(rdr["ID"]);
model.Priority = ConvertToInt(rdr["Priority"]);
model.FromName = ConverToStr(rdr["FromName"]);
model.FromEmail = ConverToStr(rdr["FromEmail"]);
model.ReplyTo = ConverToStr(rdr["ReplyTo"]);
model.CCAddress = ConverToStr(rdr["CCAddress"]);
model.ToAddress = ConverToStr(rdr["ToAddress"]);
model.BCCAddress = ConverToStr(rdr["BCCAddress"]);
model.Subject = ConverToStr(rdr["Subject"]);
model.MailBody = ConverToStr(rdr["MailBody"]);
model.Attachment = ConverToStr(rdr["Attachment"]);
model.SaveSendLog = ConvertToInt(rdr["SaveSendLog"]);
model.CDate = ConvertToDate(rdr["CDate"]);
model.Result = ConvertToInt(rdr["Result"]);
model.Error = ConverToStr(rdr["Error"]);
rdr.Close();
return(model);
}