public virtual maindataset.mainbillDataTable GetBillIdTable() { this.Adapter.SelectCommand = this.CommandCollection[15]; maindataset.mainbillDataTable dataTable = new maindataset.mainbillDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual maindataset.mainbillDataTable GetMainForReport(global::System.Nullable<int> mnbillid) { this.Adapter.SelectCommand = this.CommandCollection[13]; if ((mnbillid.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((int)(mnbillid.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } maindataset.mainbillDataTable dataTable = new maindataset.mainbillDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual maindataset.mainbillDataTable GetMainSearchByBillDate(global::System.Nullable<global::System.DateTime> billdate) { this.Adapter.SelectCommand = this.CommandCollection[14]; 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.mainbillDataTable dataTable = new maindataset.mainbillDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual maindataset.mainbillDataTable GetDataByPaymentRecievedDetails(global::System.Nullable<int> debitbillno, global::System.Nullable<int> cheqnumber, global::System.Nullable<global::System.DateTime> cheqdate, global::System.Nullable<global::System.DateTime> paymentdate, global::System.Nullable<bool> billrecieved, global::System.Nullable<decimal> tds, global::System.Nullable<decimal> otherexpense, global::System.Nullable<decimal> ttlrcv) { this.Adapter.SelectCommand = this.CommandCollection[10]; 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 ((cheqnumber.HasValue == true)) { this.Adapter.SelectCommand.Parameters[2].Value = ((int)(cheqnumber.Value)); } else { this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value; } if ((cheqdate.HasValue == true)) { this.Adapter.SelectCommand.Parameters[3].Value = ((System.DateTime)(cheqdate.Value)); } else { this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value; } if ((paymentdate.HasValue == true)) { this.Adapter.SelectCommand.Parameters[4].Value = ((System.DateTime)(paymentdate.Value)); } else { this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value; } if ((billrecieved.HasValue == true)) { this.Adapter.SelectCommand.Parameters[5].Value = ((bool)(billrecieved.Value)); } else { this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value; } if ((tds.HasValue == true)) { this.Adapter.SelectCommand.Parameters[6].Value = ((decimal)(tds.Value)); } else { this.Adapter.SelectCommand.Parameters[6].Value = global::System.DBNull.Value; } if ((otherexpense.HasValue == true)) { this.Adapter.SelectCommand.Parameters[7].Value = ((decimal)(otherexpense.Value)); } else { this.Adapter.SelectCommand.Parameters[7].Value = global::System.DBNull.Value; } if ((ttlrcv.HasValue == true)) { this.Adapter.SelectCommand.Parameters[8].Value = ((decimal)(ttlrcv.Value)); } else { this.Adapter.SelectCommand.Parameters[8].Value = global::System.DBNull.Value; } maindataset.mainbillDataTable dataTable = new maindataset.mainbillDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual maindataset.mainbillDataTable GetDataByMainSearchStation(string station) { this.Adapter.SelectCommand = this.CommandCollection[9]; if ((station == null)) { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = ((string)(station)); } maindataset.mainbillDataTable dataTable = new maindataset.mainbillDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual maindataset.mainbillDataTable GetDataByMainSearchPartyStationAndDbno(string partyname, string station, global::System.Nullable<int> dbno) { this.Adapter.SelectCommand = this.CommandCollection[8]; 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; } maindataset.mainbillDataTable dataTable = new maindataset.mainbillDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual maindataset.mainbillDataTable GetDataByMainSearchDebitBillNo(global::System.Nullable<int> dbno) { this.Adapter.SelectCommand = this.CommandCollection[5]; 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.mainbillDataTable dataTable = new maindataset.mainbillDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual maindataset.mainbillDataTable 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; } maindataset.mainbillDataTable dataTable = new maindataset.mainbillDataTable(); this.Adapter.Fill(dataTable); return dataTable; }