コード例 #1
0
 public virtual int Fill(OperDataSet.GetOperDataTable dataTable, global::System.Nullable<global::System.DateTime> datestart, global::System.Nullable<global::System.DateTime> datestop, global::System.Nullable<int> typeacc, global::System.Nullable<int> employee) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((datestart.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(datestart.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     if ((datestop.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[2].Value = ((System.DateTime)(datestop.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
     }
     if ((typeacc.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[3].Value = ((int)(typeacc.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
     }
     if ((employee.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[4].Value = ((int)(employee.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
コード例 #2
0
 public virtual int Fill(OperDataSet.GetAccountsFromTypeDataTable dataTable, global::System.Nullable<int> typeacc_id) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((typeacc_id.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((int)(typeacc_id.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }