public DsPurchase.PURCHASEREQUESTDataTable GetPurchaseRequestList(string company=null,bool inpo=false) { var ds = new DsPurchase().PURCHASEREQUEST; var ta = new PURCHASEREQUESTTableAdapter { Connection = { ConnectionString = _constr } }; if (!inpo) { if (company == null) { ta.Fill(ds); } else { ta.FillByComp(ds, company); } } if (inpo) ta.FillByNotInPO(ds); return ds; }
public string DoSave() { string retval = "0"; SqlTransaction tran = null; try { var cn = new SqlConnection(_constr); cn.Open(); tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted); var ds = new DsPurchase(); var dt = ds.PURCHASEREQUEST; var taPurMain = new PURCHASEREQUESTTableAdapter(); taPurMain.Connection.ConnectionString = _constr; taPurMain.Fill(dt); taPurMain.AssignConnection(cn,tran); taPurMain.Update(Purchaserequest); tran.Commit(); retval = "1"; } catch (Exception ex) { if (tran != null) tran.Rollback(); retval = ex.ToString(); } return retval; }