public virtual lclsupset.selectlocalbillDataTable GetDataByLocalBillId(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; } lclsupset.selectlocalbillDataTable dataTable = new lclsupset.selectlocalbillDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual lclsupset.selectlocalbillDataTable GetDataBylclSelectall() { this.Adapter.SelectCommand = this.CommandCollection[8]; lclsupset.selectlocalbillDataTable dataTable = new lclsupset.selectlocalbillDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual lclsupset.selectlocalbillDataTable GetDataBylclPaymentRecieved(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; } lclsupset.selectlocalbillDataTable dataTable = new lclsupset.selectlocalbillDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual lclsupset.selectlocalbillDataTable GetDataBylclNameAndDate(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; } lclsupset.selectlocalbillDataTable dataTable = new lclsupset.selectlocalbillDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual lclsupset.selectlocalbillDataTable GetDataBylclName(string name) { this.Adapter.SelectCommand = this.CommandCollection[5]; if ((name == null)) { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = ((string)(name)); } lclsupset.selectlocalbillDataTable dataTable = new lclsupset.selectlocalbillDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual lclsupset.selectlocalbillDataTable GetDataBylclBillIDAndName(global::System.Nullable<int> billid, string name) { this.Adapter.SelectCommand = this.CommandCollection[3]; 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 ((name == null)) { this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = ((string)(name)); } lclsupset.selectlocalbillDataTable dataTable = new lclsupset.selectlocalbillDataTable(); this.Adapter.Fill(dataTable); return dataTable; }