예제 #1
0
 protected override void AddParameters(SendMailModel pModel, IDBManager idbm, bool pAddPKAsINParam)
 {
     if (pAddPKAsINParam)
     {
         idbm.AddInParameter(mPKName, pModel.ID, SqlDbType.TinyInt);
     }
     else
     {
         idbm.AddOutParameter(mPKName, SqlDbType.TinyInt);
     }
     idbm.AddInParameter("CustomerID", pModel.CustomerID, SqlDbType.NChar);
     idbm.AddInParameter("CustomerEmailAddress", pModel.CustomerEmailAddress, SqlDbType.Text);
     idbm.AddInParameter("DepositNumber", pModel.DepositNumber, SqlDbType.NChar);
     idbm.AddInParameter("EmailText", pModel.EmailText, SqlDbType.Text);
     idbm.AddInParameter("EmailType", pModel.EmailType, SqlDbType.Bit);
     idbm.AddInParameter("Subject", pModel.Subject, SqlDbType.NChar);
     idbm.AddInParameter("mailstatus", pModel.Subject, SqlDbType.Bit);
     idbm.AddInParameter("Error", pModel.Subject, SqlDbType.Text);
 }
예제 #2
0
 protected override void AddParameters(MailInboxModel pModel, IDBManager idbm, bool pAddPKAsINParam)
 {
     if (pAddPKAsINParam)
     {
         idbm.AddInParameter(mPKName, pModel.ID, SqlDbType.TinyInt);
     }
     else
     {
         idbm.AddOutParameter(mPKName, SqlDbType.TinyInt);
     }
     idbm.AddInParameter("MessageHeader", pModel.MessageHeader, SqlDbType.NChar);
     idbm.AddInParameter("MessageBody", pModel.MessageBody, SqlDbType.NChar);
     idbm.AddInParameter("MessageUID", pModel.MessageUID, SqlDbType.NChar);
     idbm.AddInParameter("Read", pModel.Read, SqlDbType.Bit);
     idbm.AddInParameter("SenderMail", pModel.SenderMail, SqlDbType.NChar);
     idbm.AddInParameter("receiveDate", pModel.receiveDate, SqlDbType.NChar);
     idbm.AddInParameter("receiveTime", pModel.receiveTime, SqlDbType.NChar);
 }