public virtual maindataset.PendingDataTable GetDataByPenSearchByDebitBillNo(global::System.Nullable<int> dbno) {
this.Adapter.SelectCommand = this.CommandCollection[4];
if ((dbno.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(dbno.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
maindataset.PendingDataTable dataTable = new maindataset.PendingDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual maindataset.PendingDataTable GetDataByPenMainSearchPartyName(string partyname) {
this.Adapter.SelectCommand = this.CommandCollection[2];
if ((partyname == null)) {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = ((string)(partyname));
}
maindataset.PendingDataTable dataTable = new maindataset.PendingDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual maindataset.PendingDataTable GetDataByPenSearchByBillDate(global::System.Nullable<global::System.DateTime> billdate) {
this.Adapter.SelectCommand = this.CommandCollection[3];
if ((billdate.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(billdate.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
maindataset.PendingDataTable dataTable = new maindataset.PendingDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual maindataset.PendingDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
maindataset.PendingDataTable dataTable = new maindataset.PendingDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
