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