public virtual zmaindataset.zmainbillDataTable GetDataByMainSearchByBillDate(global::System.Nullable<global::System.DateTime> billdate) {
this.Adapter.SelectCommand = this.CommandCollection[11];
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;
}
zmaindataset.zmainbillDataTable dataTable = new zmaindataset.zmainbillDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual zmaindataset.zmainbillDataTable GetDataByPaymentRecieved(global::System.Nullable<int> debitbillno, global::System.Nullable<global::System.DateTime> paymentdate, global::System.Nullable<bool> billrecieved) {
this.Adapter.SelectCommand = this.CommandCollection[9];
if ((debitbillno.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(debitbillno.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((paymentdate.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[2].Value = ((System.DateTime)(paymentdate.Value));
}
else {
this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
}
if ((billrecieved.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[3].Value = ((bool)(billrecieved.Value));
}
else {
this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
}
zmaindataset.zmainbillDataTable dataTable = new zmaindataset.zmainbillDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual zmaindataset.zmainbillDataTable GetDataBySelectAll() {
this.Adapter.SelectCommand = this.CommandCollection[10];
zmaindataset.zmainbillDataTable dataTable = new zmaindataset.zmainbillDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual zmaindataset.zmainbillDataTable GetDataByMainSearchStation(string station) {
this.Adapter.SelectCommand = this.CommandCollection[8];
if ((station == null)) {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = ((string)(station));
}
zmaindataset.zmainbillDataTable dataTable = new zmaindataset.zmainbillDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual zmaindataset.zmainbillDataTable GetDataByMainSearchPartyStationAndDbno(string partyname, string station, global::System.Nullable<int> dbno) {
this.Adapter.SelectCommand = this.CommandCollection[7];
if ((partyname == null)) {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = ((string)(partyname));
}
if ((station == null)) {
this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[2].Value = ((string)(station));
}
if ((dbno.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[3].Value = ((int)(dbno.Value));
}
else {
this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
}
zmaindataset.zmainbillDataTable dataTable = new zmaindataset.zmainbillDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual zmaindataset.zmainbillDataTable GetDataByMainSearchDebitBillNo(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;
}
zmaindataset.zmainbillDataTable dataTable = new zmaindataset.zmainbillDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual zmaindataset.zmainbillDataTable GetDataBydeleteMain(global::System.Nullable<int> mnbillid) {
this.Adapter.SelectCommand = this.CommandCollection[2];
if ((mnbillid.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(mnbillid.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
zmaindataset.zmainbillDataTable dataTable = new zmaindataset.zmainbillDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual zmaindataset.zmainbillDataTable GetDataBy(global::System.Nullable<int> userid, global::System.Nullable<int> billid, global::System.Nullable<int> debitBillNo, global::System.Nullable<global::System.DateTime> billdate, string partyName, string station, global::System.Nullable<decimal> total, global::System.Nullable<decimal> serviceCharge, global::System.Nullable<decimal> surcharge, global::System.Nullable<decimal> hsServiceCharge, global::System.Nullable<decimal> tax, string totalinwords, string totalbags, string totaltones, global::System.Nullable<int> mnbillId) {
this.Adapter.SelectCommand = this.CommandCollection[1];
if ((userid.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(userid.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((billid.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[2].Value = ((int)(billid.Value));
}
else {
this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
}
if ((debitBillNo.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[3].Value = ((int)(debitBillNo.Value));
}
else {
this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
}
if ((billdate.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[4].Value = ((System.DateTime)(billdate.Value));
}
else {
this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value;
}
if ((partyName == null)) {
this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[5].Value = ((string)(partyName));
}
if ((station == null)) {
this.Adapter.SelectCommand.Parameters[6].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[6].Value = ((string)(station));
}
if ((total.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[7].Value = ((decimal)(total.Value));
}
else {
this.Adapter.SelectCommand.Parameters[7].Value = global::System.DBNull.Value;
}
if ((serviceCharge.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[8].Value = ((decimal)(serviceCharge.Value));
}
else {
this.Adapter.SelectCommand.Parameters[8].Value = global::System.DBNull.Value;
}
if ((surcharge.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[9].Value = ((decimal)(surcharge.Value));
}
else {
this.Adapter.SelectCommand.Parameters[9].Value = global::System.DBNull.Value;
}
if ((hsServiceCharge.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[10].Value = ((decimal)(hsServiceCharge.Value));
}
else {
this.Adapter.SelectCommand.Parameters[10].Value = global::System.DBNull.Value;
}
if ((tax.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[11].Value = ((decimal)(tax.Value));
}
else {
this.Adapter.SelectCommand.Parameters[11].Value = global::System.DBNull.Value;
}
if ((totalinwords == null)) {
this.Adapter.SelectCommand.Parameters[12].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[12].Value = ((string)(totalinwords));
}
if ((totalbags == null)) {
this.Adapter.SelectCommand.Parameters[13].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[13].Value = ((string)(totalbags));
}
if ((totaltones == null)) {
this.Adapter.SelectCommand.Parameters[14].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[14].Value = ((string)(totaltones));
}
if ((mnbillId.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[15].Value = ((int)(mnbillId.Value));
}
else {
this.Adapter.SelectCommand.Parameters[15].Value = global::System.DBNull.Value;
}
zmaindataset.zmainbillDataTable dataTable = new zmaindataset.zmainbillDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
