public virtual int FillBy(lclsupset.selectlocaldetDataTable dataTable, global::System.Nullable<int> Param1) {
this.Adapter.SelectCommand = this.CommandCollection[1];
if ((Param1.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[0].Value = ((int)(Param1.Value));
}
else {
this.Adapter.SelectCommand.Parameters[0].Value = global::System.DBNull.Value;
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int FillByLocalBillId(lclsupset.selectlocalbillDataTable dataTable, global::System.Nullable<int> billid) {
this.Adapter.SelectCommand = this.CommandCollection[9];
if ((billid.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(billid.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 FillBylclPaymentRecieved(lclsupset.selectlocalbillDataTable dataTable, global::System.Nullable<int> billno, global::System.Nullable<int> chequeno, global::System.Nullable<global::System.DateTime> billrcdate, global::System.Nullable<global::System.DateTime> chequedate, global::System.Nullable<bool> paid) {
this.Adapter.SelectCommand = this.CommandCollection[7];
if ((billno.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(billno.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((chequeno.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[2].Value = ((int)(chequeno.Value));
}
else {
this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
}
if ((billrcdate.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[3].Value = ((System.DateTime)(billrcdate.Value));
}
else {
this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
}
if ((chequedate.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[4].Value = ((System.DateTime)(chequedate.Value));
}
else {
this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value;
}
if ((paid.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[5].Value = ((bool)(paid.Value));
}
else {
this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value;
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int FillBylclSelectall(lclsupset.selectlocalbillDataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[8];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
public virtual int FillBylclNameAndDate(lclsupset.selectlocalbillDataTable dataTable, string name, global::System.Nullable<global::System.DateTime> billdate) {
this.Adapter.SelectCommand = this.CommandCollection[6];
if ((name == null)) {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = ((string)(name));
}
if ((billdate.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[2].Value = ((System.DateTime)(billdate.Value));
}
else {
this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}