public virtual dispatchDataSet.SelectDispatchReportDataTable GetDataByDisSearchByPNumber(string Pnumber) {
this.Adapter.SelectCommand = this.CommandCollection[6];
if ((Pnumber == null)) {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = ((string)(Pnumber));
}
dispatchDataSet.SelectDispatchReportDataTable dataTable = new dispatchDataSet.SelectDispatchReportDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual dispatchDataSet.SelectDispatchReportDataTable GetDataByDisSearchByGcNumber(global::System.Nullable<int> gcnumber) {
this.Adapter.SelectCommand = this.CommandCollection[4];
if ((gcnumber.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(gcnumber.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
dispatchDataSet.SelectDispatchReportDataTable dataTable = new dispatchDataSet.SelectDispatchReportDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual dispatchDataSet.SelectDispatchReportDataTable GetDataByDispatchBillReceived(global::System.Nullable<int> did, global::System.Nullable<bool> rcv) {
this.Adapter.SelectCommand = this.CommandCollection[1];
if ((did.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(did.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((rcv.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[2].Value = ((bool)(rcv.Value));
}
else {
this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
}
dispatchDataSet.SelectDispatchReportDataTable dataTable = new dispatchDataSet.SelectDispatchReportDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual dispatchDataSet.SelectDispatchReportDataTable GetDataByDisSearchByDate(global::System.Nullable<global::System.DateTime> enterdt) {
this.Adapter.SelectCommand = this.CommandCollection[3];
if ((enterdt.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(enterdt.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
dispatchDataSet.SelectDispatchReportDataTable dataTable = new dispatchDataSet.SelectDispatchReportDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual dispatchDataSet.SelectDispatchReportDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
dispatchDataSet.SelectDispatchReportDataTable dataTable = new dispatchDataSet.SelectDispatchReportDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
