public int GetPurchaseHoldCount()
 {
     var ds = new DsPurchase.PURINVMAINDataTable();
     var ta = new PURINVMAINTableAdapter {Connection = {ConnectionString = _constr}};
     return ta.FillByHold(ds);
 }
 public DsPurchase.PURINVMAINDataTable GetPurchaseInvoiceByHold()
 {
     var ta = new PURINVMAINTableAdapter {Connection = {ConnectionString = _constr}};
     var ds = new DsPurchase.PURINVMAINDataTable();
     ta.FillByHold(ds);
     return ds;
 }