public virtual int FillBy單號(DatabaseSet.工作單品號DataTable dataTable, string 單號) { this.Adapter.SelectCommand = this.CommandCollection[1]; if ((單號 == null)) { throw new global::System.ArgumentNullException("單號"); } else { this.Adapter.SelectCommand.Parameters[0].Value = ((string)(單號)); } if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }
public virtual int Fill(DatabaseSet.工作單品號DataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }
public virtual int FillByRange(DatabaseSet.假日DataTable dataTable, global::System.Nullable<global::System.DateTime> 日期, global::System.Nullable<global::System.DateTime> 日期1) { this.Adapter.SelectCommand = this.CommandCollection[1]; if ((日期.HasValue == true)) { this.Adapter.SelectCommand.Parameters[0].Value = ((System.DateTime)(日期.Value)); } else { this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value; } if ((日期1.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(日期1.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; }
public virtual int FillBy系列編號(DatabaseSet.產品品號ViewDataTable dataTable, int 系列編號) { this.Adapter.SelectCommand = this.CommandCollection[0]; this.Adapter.SelectCommand.Parameters[0].Value = ((int)(系列編號)); if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }
public virtual int FillBy產線(DatabaseSet.員工DataTable dataTable, string 產線) { this.Adapter.SelectCommand = this.CommandCollection[1]; if ((產線 == null)) { this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[0].Value = ((string)(產線)); } if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; }
public int FillBy月份(DatabaseSet.假日DataTable table,int 年份, int 月份) { this.Adapter.SelectCommand = SelectByMonthCommand; _selectByMonthCommand.Parameters["年份"].Value = 年份; _selectByMonthCommand.Parameters["月份"].Value = 月份; table.Clear(); return this.Adapter.Fill(table); }