Example #1
0
 public virtual DS_CreditCards.CCListDataTable GetOrdersCCList(int orderId) {
     this.Adapter.SelectCommand = this.CommandCollection[1];
     this.Adapter.SelectCommand.Parameters[0].Value = ((int)(orderId));
     DS_CreditCards.CCListDataTable dataTable = new DS_CreditCards.CCListDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
Example #2
0
 public virtual DS_CreditCards.CCListDataTable GetCCList(int paymode, global::System.Nullable<global::System.DateTime> orderStartDate, global::System.Nullable<global::System.DateTime> orderEndDate) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     this.Adapter.SelectCommand.Parameters[0].Value = ((int)(paymode));
     if ((orderStartDate.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(orderStartDate.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     if ((orderEndDate.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[2].Value = ((System.DateTime)(orderEndDate.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
     }
     DS_CreditCards.CCListDataTable dataTable = new DS_CreditCards.CCListDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }