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