public virtual int Fill(zmaindataset.insertintopartpaymentDataTable dataTable, global::System.Nullable<int> mnbillid, string chequeno, global::System.Nullable<global::System.DateTime> chequedate, global::System.Nullable<decimal> chequeamount, global::System.Nullable<decimal> tds, global::System.Nullable<decimal> otherexpense, global::System.Nullable<decimal> total) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((mnbillid.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((int)(mnbillid.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
     }
     if ((chequeno == null)) {
         this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[2].Value = ((string)(chequeno));
     }
     if ((chequedate.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[3].Value = ((System.DateTime)(chequedate.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
     }
     if ((chequeamount.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[4].Value = ((decimal)(chequeamount.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value;
     }
     if ((tds.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[5].Value = ((decimal)(tds.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value;
     }
     if ((otherexpense.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[6].Value = ((decimal)(otherexpense.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[6].Value = global::System.DBNull.Value;
     }
     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 ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int FillBySearchPartPayment(zmaindataset.billRcvDataTable dataTable, global::System.Nullable<int> debitbillno) {
     this.Adapter.SelectCommand = this.CommandCollection[3];
     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 ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int Fill(zmaindataset.billrcvPaymentDetDataTable dataTable, global::System.Nullable<int> mnbillid) {
     this.Adapter.SelectCommand = this.CommandCollection[0];
     if ((mnbillid.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((int)(mnbillid.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 FillMainSearchByBillDate(zmaindataset.zmainbillDataTable dataTable, 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;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int FillByBillRcvAll(zmaindataset.billRcvDataTable dataTable) {
     this.Adapter.SelectCommand = this.CommandCollection[2];
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int FillByMainSearchStation(zmaindataset.zmainbillDataTable dataTable, 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));
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int FillByPaymentRecieved(zmaindataset.zmainbillDataTable dataTable, 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;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int FillByMainSearchPartyStationAndDbno(zmaindataset.zmainbillDataTable dataTable, 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;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int FillByMainSearchDebitBillNo(zmaindataset.zmainbillDataTable dataTable, 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;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int FillBy(
             zmaindataset.zmainbillDataTable dataTable, 
             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;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int FillByBill(zmaindataset.zbillDataTable dataTable, global::System.Nullable<int> billid, global::System.Nullable<int> userid, global::System.Nullable<int> mnbillId, global::System.Nullable<global::System.DateTime> billdate, string gcnumber, string chalannumber, string trucknumber, string goods, string bags, string tone, global::System.Nullable<decimal> rate, global::System.Nullable<decimal> amount, global::System.Nullable<global::System.DateTime> unloading, global::System.Nullable<decimal> expense) {
     this.Adapter.SelectCommand = this.CommandCollection[2];
     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 ((userid.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[2].Value = ((int)(userid.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
     }
     if ((mnbillId.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[3].Value = ((int)(mnbillId.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 ((gcnumber == null)) {
         this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[5].Value = ((string)(gcnumber));
     }
     if ((chalannumber == null)) {
         this.Adapter.SelectCommand.Parameters[6].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[6].Value = ((string)(chalannumber));
     }
     if ((trucknumber == null)) {
         this.Adapter.SelectCommand.Parameters[7].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[7].Value = ((string)(trucknumber));
     }
     if ((goods == null)) {
         this.Adapter.SelectCommand.Parameters[8].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[8].Value = ((string)(goods));
     }
     if ((bags == null)) {
         this.Adapter.SelectCommand.Parameters[9].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[9].Value = ((string)(bags));
     }
     if ((tone == null)) {
         this.Adapter.SelectCommand.Parameters[10].Value = global::System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[10].Value = ((string)(tone));
     }
     if ((rate.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[11].Value = ((decimal)(rate.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[11].Value = global::System.DBNull.Value;
     }
     if ((amount.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[12].Value = ((decimal)(amount.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[12].Value = global::System.DBNull.Value;
     }
     if ((unloading.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[13].Value = ((System.DateTime)(unloading.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[13].Value = global::System.DBNull.Value;
     }
     if ((expense.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[14].Value = ((decimal)(expense.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[14].Value = global::System.DBNull.Value;
     }
     if ((this.ClearBeforeFill == true)) {
         dataTable.Clear();
     }
     int returnValue = this.Adapter.Fill(dataTable);
     return returnValue;
 }
 public virtual int FillBy(zmaindataset.zbillDataTable 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;
 }