Пример #1
0
 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;
 }
Пример #2
0
        public string DoSavePurchaseRequestInRemote(DsPurchase.PURCHASEREQUESTDataTable  dt)
        {
            var dm = new DataManager();
            string retval="0";
            SqlTransaction tran = null;
            var cn = new SqlConnection(_constr);
            try
            {
                cn.Open();
                tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
                var ds = new DsPurchase();
                var dtdetail = ds.PURCHASEREQUEST;


 
                var taPurDetail = new  PURCHASEREQUESTTableAdapter();

                taPurDetail.AssignConnection(cn, tran);

                foreach (DsPurchase.PURCHASEREQUESTRow ditemdetarow in dt)
                {
                    var newdetrow = dtdetail.NewRow();
                    foreach (DataColumn dc in dt.Columns)
                    {
                        if (!dc.ReadOnly)
                        {
                            newdetrow[dc.ColumnName] = ditemdetarow[dc.ColumnName];
                        }
                    }
                    dtdetail.Rows.Add(newdetrow);
                }
                taPurDetail.Update(dtdetail);
                tran.Commit();
                retval = "1";
            }
            catch (Exception ex)
            {
                if (cn != null)
                {
                    if (tran != null)
                        tran.Rollback();
                }
                retval = ex.ToString();
            }
            return retval; 
        }