public override void BeginTransaction(string connectionString) { System.Data.SqlClient.SqlConnection oSqlConnection = new System.Data.SqlClient.SqlConnection(connectionString); oSqlConnection.Open(); _SqlTransaction = oSqlConnection.BeginTransaction(System.Data.IsolationLevel.ReadUncommitted); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(System.Data.SqlClient.SqlTransaction tran, WTCJ.Model.JD_SF model) { return(dal.Update(tran, model)); }
protected void BeginTran() { US_Object v_us = new US_Object(); m_trans = v_us.BeginTransaction(); }
/// <summary> /// Lets you efficiently bulk insert many entities to the database. /// </summary> /// <param name="transactionManager">The transaction manager.</param> /// <param name="entities">The entities.</param> /// <remarks> /// After inserting into the datasource, the Nettiers.AdventureWorks.Entities.CustomerAddress object will be updated /// to refelect any changes made by the datasource. (ie: identity or computed columns) /// </remarks> public override void BulkInsert(TransactionManager transactionManager, TList <Nettiers.AdventureWorks.Entities.CustomerAddress> entities) { //System.Data.SqlClient.SqlBulkCopy bulkCopy = new System.Data.SqlClient.SqlBulkCopy(this._connectionString, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints); //, null); System.Data.SqlClient.SqlBulkCopy bulkCopy = null; if (transactionManager != null && transactionManager.IsOpen) { System.Data.SqlClient.SqlConnection cnx = transactionManager.TransactionObject.Connection as System.Data.SqlClient.SqlConnection; System.Data.SqlClient.SqlTransaction transaction = transactionManager.TransactionObject as System.Data.SqlClient.SqlTransaction; bulkCopy = new System.Data.SqlClient.SqlBulkCopy(cnx, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints, transaction); //, null); } else { bulkCopy = new System.Data.SqlClient.SqlBulkCopy(this._connectionString, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints); //, null); } bulkCopy.BulkCopyTimeout = 360; bulkCopy.DestinationTableName = "CustomerAddress"; DataTable dataTable = new DataTable(); DataColumn col0 = dataTable.Columns.Add("CustomerID", typeof(System.Int32)); col0.AllowDBNull = false; DataColumn col1 = dataTable.Columns.Add("AddressID", typeof(System.Int32)); col1.AllowDBNull = false; DataColumn col2 = dataTable.Columns.Add("AddressTypeID", typeof(System.Int32)); col2.AllowDBNull = false; DataColumn col3 = dataTable.Columns.Add("rowguid", typeof(System.Guid)); col3.AllowDBNull = false; DataColumn col4 = dataTable.Columns.Add("ModifiedDate", typeof(System.DateTime)); col4.AllowDBNull = false; bulkCopy.ColumnMappings.Add("CustomerID", "CustomerID"); bulkCopy.ColumnMappings.Add("AddressID", "AddressID"); bulkCopy.ColumnMappings.Add("AddressTypeID", "AddressTypeID"); bulkCopy.ColumnMappings.Add("rowguid", "rowguid"); bulkCopy.ColumnMappings.Add("ModifiedDate", "ModifiedDate"); foreach (Nettiers.AdventureWorks.Entities.CustomerAddress entity in entities) { if (entity.EntityState != EntityState.Added) { continue; } DataRow row = dataTable.NewRow(); row["CustomerID"] = entity.CustomerId; row["AddressID"] = entity.AddressId; row["AddressTypeID"] = entity.AddressTypeId; row["rowguid"] = entity.Rowguid; row["ModifiedDate"] = entity.ModifiedDate; dataTable.Rows.Add(row); } // send the data to the server bulkCopy.WriteToServer(dataTable); // update back the state foreach (Nettiers.AdventureWorks.Entities.CustomerAddress entity in entities) { if (entity.EntityState != EntityState.Added) { continue; } entity.AcceptChanges(); } }
/// <summary> /// Lets you efficiently bulk insert many entities to the database. /// </summary> /// <param name="transactionManager">The transaction manager.</param> /// <param name="entities">The entities.</param> /// <remarks> /// After inserting into the datasource, the Nettiers.AdventureWorks.Entities.ProductListPriceHistory object will be updated /// to refelect any changes made by the datasource. (ie: identity or computed columns) /// </remarks> public override void BulkInsert(TransactionManager transactionManager, TList <Nettiers.AdventureWorks.Entities.ProductListPriceHistory> entities) { //System.Data.SqlClient.SqlBulkCopy bulkCopy = new System.Data.SqlClient.SqlBulkCopy(this._connectionString, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints); //, null); System.Data.SqlClient.SqlBulkCopy bulkCopy = null; if (transactionManager != null && transactionManager.IsOpen) { System.Data.SqlClient.SqlConnection cnx = transactionManager.TransactionObject.Connection as System.Data.SqlClient.SqlConnection; System.Data.SqlClient.SqlTransaction transaction = transactionManager.TransactionObject as System.Data.SqlClient.SqlTransaction; bulkCopy = new System.Data.SqlClient.SqlBulkCopy(cnx, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints, transaction); //, null); } else { bulkCopy = new System.Data.SqlClient.SqlBulkCopy(this._connectionString, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints); //, null); } bulkCopy.BulkCopyTimeout = 360; bulkCopy.DestinationTableName = "ProductListPriceHistory"; DataTable dataTable = new DataTable(); DataColumn col0 = dataTable.Columns.Add("ProductID", typeof(System.Int32)); col0.AllowDBNull = false; DataColumn col1 = dataTable.Columns.Add("StartDate", typeof(System.DateTime)); col1.AllowDBNull = false; DataColumn col2 = dataTable.Columns.Add("EndDate", typeof(System.DateTime)); col2.AllowDBNull = true; DataColumn col3 = dataTable.Columns.Add("ListPrice", typeof(System.Decimal)); col3.AllowDBNull = false; DataColumn col4 = dataTable.Columns.Add("ModifiedDate", typeof(System.DateTime)); col4.AllowDBNull = false; bulkCopy.ColumnMappings.Add("ProductID", "ProductID"); bulkCopy.ColumnMappings.Add("StartDate", "StartDate"); bulkCopy.ColumnMappings.Add("EndDate", "EndDate"); bulkCopy.ColumnMappings.Add("ListPrice", "ListPrice"); bulkCopy.ColumnMappings.Add("ModifiedDate", "ModifiedDate"); foreach (Nettiers.AdventureWorks.Entities.ProductListPriceHistory entity in entities) { if (entity.EntityState != EntityState.Added) { continue; } DataRow row = dataTable.NewRow(); row["ProductID"] = entity.ProductId; row["StartDate"] = entity.StartDate; row["EndDate"] = entity.EndDate.HasValue ? (object)entity.EndDate : System.DBNull.Value; row["ListPrice"] = entity.ListPrice; row["ModifiedDate"] = entity.ModifiedDate; dataTable.Rows.Add(row); } // send the data to the server bulkCopy.WriteToServer(dataTable); // update back the state foreach (Nettiers.AdventureWorks.Entities.ProductListPriceHistory entity in entities) { if (entity.EntityState != EntityState.Added) { continue; } entity.AcceptChanges(); } }
/// <summary> /// 删除GoodsLabels /// </summary> /// <returns></returns> public int Delete(int goodsId, int compId, System.Data.SqlClient.SqlTransaction Tran) { return(dal.Delete(goodsId, compId, Tran)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hi.Model.BD_ImageList model, System.Data.SqlClient.SqlTransaction Tran) { return(dal.Add(model, Tran)); }
/// <summary> /// Lets you efficiently bulk insert many entities to the database. /// </summary> /// <param name="transactionManager">The transaction manager.</param> /// <param name="entities">The entities.</param> /// <remarks> /// After inserting into the datasource, the PetShop.Business.Category object will be updated /// to refelect any changes made by the datasource. (ie: identity or computed columns) /// </remarks> public override void BulkInsert(TransactionManager transactionManager, TList <PetShop.Business.Category> entities) { //System.Data.SqlClient.SqlBulkCopy bulkCopy = new System.Data.SqlClient.SqlBulkCopy(this._connectionString, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints); //, null); System.Data.SqlClient.SqlBulkCopy bulkCopy = null; if (transactionManager != null && transactionManager.IsOpen) { System.Data.SqlClient.SqlConnection cnx = transactionManager.TransactionObject.Connection as System.Data.SqlClient.SqlConnection; System.Data.SqlClient.SqlTransaction transaction = transactionManager.TransactionObject as System.Data.SqlClient.SqlTransaction; bulkCopy = new System.Data.SqlClient.SqlBulkCopy(cnx, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints, transaction); //, null); } else { bulkCopy = new System.Data.SqlClient.SqlBulkCopy(this._connectionString, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints); //, null); } bulkCopy.BulkCopyTimeout = 360; bulkCopy.DestinationTableName = "Category"; DataTable dataTable = new DataTable(); DataColumn col0 = dataTable.Columns.Add("CategoryId", typeof(string)); col0.AllowDBNull = false; DataColumn col1 = dataTable.Columns.Add("Name", typeof(string)); col1.AllowDBNull = true; DataColumn col2 = dataTable.Columns.Add("Descn", typeof(string)); col2.AllowDBNull = true; bulkCopy.ColumnMappings.Add("CategoryId", "CategoryId"); bulkCopy.ColumnMappings.Add("Name", "Name"); bulkCopy.ColumnMappings.Add("Descn", "Descn"); foreach (PetShop.Business.Category entity in entities) { if (entity.EntityState != EntityState.Added) { continue; } DataRow row = dataTable.NewRow(); row["CategoryId"] = entity.CategoryId; row["Name"] = entity.Name; row["Descn"] = entity.Descn; dataTable.Rows.Add(row); } // send the data to the server bulkCopy.WriteToServer(dataTable); // update back the state foreach (PetShop.Business.Category entity in entities) { if (entity.EntityState != EntityState.Added) { continue; } entity.AcceptChanges(); } }
/// <summary> /// Lets you efficiently bulk insert many entities to the database. /// </summary> /// <param name="transactionManager">The transaction manager.</param> /// <param name="entities">The entities.</param> /// <remarks> /// After inserting into the datasource, the PetShop.Business.Profile object will be updated /// to refelect any changes made by the datasource. (ie: identity or computed columns) /// </remarks> public override void BulkInsert(TransactionManager transactionManager, TList <PetShop.Business.Profile> entities) { //System.Data.SqlClient.SqlBulkCopy bulkCopy = new System.Data.SqlClient.SqlBulkCopy(this._connectionString, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints); //, null); System.Data.SqlClient.SqlBulkCopy bulkCopy = null; if (transactionManager != null && transactionManager.IsOpen) { System.Data.SqlClient.SqlConnection cnx = transactionManager.TransactionObject.Connection as System.Data.SqlClient.SqlConnection; System.Data.SqlClient.SqlTransaction transaction = transactionManager.TransactionObject as System.Data.SqlClient.SqlTransaction; bulkCopy = new System.Data.SqlClient.SqlBulkCopy(cnx, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints, transaction); //, null); } else { bulkCopy = new System.Data.SqlClient.SqlBulkCopy(this._connectionString, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints); //, null); } bulkCopy.BulkCopyTimeout = 360; bulkCopy.DestinationTableName = "Profiles"; DataTable dataTable = new DataTable(); DataColumn col0 = dataTable.Columns.Add("UniqueID", typeof(int)); col0.AllowDBNull = false; DataColumn col1 = dataTable.Columns.Add("Username", typeof(string)); col1.AllowDBNull = false; DataColumn col2 = dataTable.Columns.Add("ApplicationName", typeof(string)); col2.AllowDBNull = false; DataColumn col3 = dataTable.Columns.Add("IsAnonymous", typeof(System.Boolean?)); col3.AllowDBNull = true; DataColumn col4 = dataTable.Columns.Add("LastActivityDate", typeof(System.DateTime?)); col4.AllowDBNull = true; DataColumn col5 = dataTable.Columns.Add("LastUpdatedDate", typeof(System.DateTime?)); col5.AllowDBNull = true; bulkCopy.ColumnMappings.Add("UniqueID", "UniqueID"); bulkCopy.ColumnMappings.Add("Username", "Username"); bulkCopy.ColumnMappings.Add("ApplicationName", "ApplicationName"); bulkCopy.ColumnMappings.Add("IsAnonymous", "IsAnonymous"); bulkCopy.ColumnMappings.Add("LastActivityDate", "LastActivityDate"); bulkCopy.ColumnMappings.Add("LastUpdatedDate", "LastUpdatedDate"); foreach (PetShop.Business.Profile entity in entities) { if (entity.EntityState != EntityState.Added) { continue; } DataRow row = dataTable.NewRow(); row["UniqueID"] = entity.UniqueId; row["Username"] = entity.Username; row["ApplicationName"] = entity.ApplicationName; row["IsAnonymous"] = entity.IsAnonymous.HasValue ? (object)entity.IsAnonymous : System.DBNull.Value; row["LastActivityDate"] = entity.LastActivityDate.HasValue ? (object)entity.LastActivityDate : System.DBNull.Value; row["LastUpdatedDate"] = entity.LastUpdatedDate.HasValue ? (object)entity.LastUpdatedDate : System.DBNull.Value; dataTable.Rows.Add(row); } // send the data to the server bulkCopy.WriteToServer(dataTable); // update back the state foreach (PetShop.Business.Profile entity in entities) { if (entity.EntityState != EntityState.Added) { continue; } entity.AcceptChanges(); } }
public static int ExecuteSql(this System.Data.SqlClient.SqlConnection con, string sql, System.Data.SqlClient.SqlTransaction trans) { var cmd = con.CreateCommand(); cmd.CommandText = sql; cmd.CommandType = System.Data.CommandType.Text; cmd.Transaction = trans; return(cmd.ExecuteNonQuery()); }
public void BeginTran() { tran = conn.BeginTransaction(); }
public IDataManager CreateDataManager(System.Data.SqlClient.SqlConnection connection, System.Data.SqlClient.SqlTransaction transactionOpt) { var manager = new DataManager(connection, transactionOpt); return(manager); }
public override void RollbackTransaction() { System.Data.SqlClient.SqlConnection oSqlConnection = _SqlTransaction.Connection; _SqlTransaction.Rollback(); oSqlConnection.Close(); _SqlTransaction = null; }
/// <summary> /// Lets you efficiently bulk insert many entities to the database. /// </summary> /// <param name="transactionManager">The transaction manager.</param> /// <param name="entities">The entities.</param> /// <remarks> /// After inserting into the datasource, the LibraryManagement.Domain.Goods object will be updated /// to refelect any changes made by the datasource. (ie: identity or computed columns) /// </remarks> public override void BulkInsert(TransactionManager transactionManager, TList <LibraryManagement.Domain.Goods> entities) { //System.Data.SqlClient.SqlBulkCopy bulkCopy = new System.Data.SqlClient.SqlBulkCopy(this._connectionString, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints); //, null); System.Data.SqlClient.SqlBulkCopy bulkCopy = null; if (transactionManager != null && transactionManager.IsOpen) { System.Data.SqlClient.SqlConnection cnx = transactionManager.TransactionObject.Connection as System.Data.SqlClient.SqlConnection; System.Data.SqlClient.SqlTransaction transaction = transactionManager.TransactionObject as System.Data.SqlClient.SqlTransaction; bulkCopy = new System.Data.SqlClient.SqlBulkCopy(cnx, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints, transaction); //, null); } else { bulkCopy = new System.Data.SqlClient.SqlBulkCopy(this._connectionString, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints); //, null); } bulkCopy.BulkCopyTimeout = 360; bulkCopy.DestinationTableName = "tblGoods"; DataTable dataTable = new DataTable(); DataColumn col0 = dataTable.Columns.Add("goods_id", typeof(System.String)); col0.AllowDBNull = false; DataColumn col1 = dataTable.Columns.Add("barcode", typeof(System.String)); col1.AllowDBNull = false; DataColumn col2 = dataTable.Columns.Add("mbc", typeof(System.Boolean)); col2.AllowDBNull = false; DataColumn col3 = dataTable.Columns.Add("ref", typeof(System.String)); col3.AllowDBNull = true; DataColumn col4 = dataTable.Columns.Add("grp_id", typeof(System.String)); col4.AllowDBNull = true; DataColumn col5 = dataTable.Columns.Add("short_name", typeof(System.String)); col5.AllowDBNull = false; DataColumn col6 = dataTable.Columns.Add("full_name", typeof(System.String)); col6.AllowDBNull = false; DataColumn col7 = dataTable.Columns.Add("packunit", typeof(System.String)); col7.AllowDBNull = false; DataColumn col8 = dataTable.Columns.Add("piceunit", typeof(System.String)); col8.AllowDBNull = false; DataColumn col9 = dataTable.Columns.Add("unitconv", typeof(System.Decimal)); col9.AllowDBNull = false; DataColumn col10 = dataTable.Columns.Add("supp_id", typeof(System.String)); col10.AllowDBNull = true; DataColumn col11 = dataTable.Columns.Add("image", typeof(System.Byte[])); col11.AllowDBNull = true; DataColumn col12 = dataTable.Columns.Add("open_date", typeof(System.DateTime)); col12.AllowDBNull = true; DataColumn col13 = dataTable.Columns.Add("tax_code", typeof(System.String)); col13.AllowDBNull = true; DataColumn col14 = dataTable.Columns.Add("merc_type", typeof(System.String)); col14.AllowDBNull = true; DataColumn col15 = dataTable.Columns.Add("attr_type", typeof(System.String)); col15.AllowDBNull = true; DataColumn col16 = dataTable.Columns.Add("domestic", typeof(System.Boolean)); col16.AllowDBNull = true; DataColumn col17 = dataTable.Columns.Add("warranty", typeof(System.Boolean)); col17.AllowDBNull = true; DataColumn col18 = dataTable.Columns.Add("status", typeof(System.Boolean)); col18.AllowDBNull = true; bulkCopy.ColumnMappings.Add("goods_id", "goods_id"); bulkCopy.ColumnMappings.Add("barcode", "barcode"); bulkCopy.ColumnMappings.Add("mbc", "mbc"); bulkCopy.ColumnMappings.Add("ref", "ref"); bulkCopy.ColumnMappings.Add("grp_id", "grp_id"); bulkCopy.ColumnMappings.Add("short_name", "short_name"); bulkCopy.ColumnMappings.Add("full_name", "full_name"); bulkCopy.ColumnMappings.Add("packunit", "packunit"); bulkCopy.ColumnMappings.Add("piceunit", "piceunit"); bulkCopy.ColumnMappings.Add("unitconv", "unitconv"); bulkCopy.ColumnMappings.Add("supp_id", "supp_id"); bulkCopy.ColumnMappings.Add("image", "image"); bulkCopy.ColumnMappings.Add("open_date", "open_date"); bulkCopy.ColumnMappings.Add("tax_code", "tax_code"); bulkCopy.ColumnMappings.Add("merc_type", "merc_type"); bulkCopy.ColumnMappings.Add("attr_type", "attr_type"); bulkCopy.ColumnMappings.Add("domestic", "domestic"); bulkCopy.ColumnMappings.Add("warranty", "warranty"); bulkCopy.ColumnMappings.Add("status", "status"); foreach (LibraryManagement.Domain.Goods entity in entities) { if (entity.EntityState != EntityState.Added) { continue; } DataRow row = dataTable.NewRow(); row["goods_id"] = entity.GoodsId; row["barcode"] = entity.Barcode; row["mbc"] = entity.Mbc; row["ref"] = entity.SafeNameRef; row["grp_id"] = entity.GrpId; row["short_name"] = entity.ShortName; row["full_name"] = entity.FullName; row["packunit"] = entity.Packunit; row["piceunit"] = entity.Piceunit; row["unitconv"] = entity.Unitconv; row["supp_id"] = entity.SuppId; row["image"] = entity.Image; row["open_date"] = entity.OpenDate.HasValue ? (object)entity.OpenDate : System.DBNull.Value; row["tax_code"] = entity.TaxCode; row["merc_type"] = entity.MercType; row["attr_type"] = entity.AttrType; row["domestic"] = entity.Domestic.HasValue ? (object)entity.Domestic : System.DBNull.Value; row["warranty"] = entity.Warranty.HasValue ? (object)entity.Warranty : System.DBNull.Value; row["status"] = entity.Status.HasValue ? (object)entity.Status : System.DBNull.Value; dataTable.Rows.Add(row); } // send the data to the server bulkCopy.WriteToServer(dataTable); // update back the state foreach (LibraryManagement.Domain.Goods entity in entities) { if (entity.EntityState != EntityState.Added) { continue; } entity.AcceptChanges(); } }
private void AsociarRendiciones(System.Data.SqlClient.SqlTransaction transaccion, int GuiaID, int rendicionID) { Config.Conexion.EjecutarSinResultados(transaccion, "AsociarRendicionesINS", GuiaID, rendicionID); }
/// <summary> /// Редактирование записи в базе данных /// </summary> /// <param name="ACCOUNTPLAN_GUID">УИ счёта</param> /// <param name="ACCOUNTPLAN_NAME">наименование</param> /// <param name="ACCOUNTPLAN_1C_CODE">код в 1С</param> /// <param name="ACCOUNTPLAN_ACTIVE">признак "запись активна"/param> /// <param name="objProfile">профайл</param> /// <param name="strErr">сообщение об ошибке</param> /// <returns>true - удачное завершение операции; false - ошибка</returns> public static System.Boolean EditObjectInDataBase(System.Guid ACCOUNTPLAN_GUID, System.String ACCOUNTPLAN_NAME, System.String ACCOUNTPLAN_1C_CODE, System.Boolean ACCOUNTPLAN_ACTIVE, UniXP.Common.CProfile objProfile, ref System.String strErr) { System.Boolean bRet = false; if (IsAllParametersValid(ACCOUNTPLAN_NAME, ACCOUNTPLAN_1C_CODE, ref strErr) == false) { return(bRet); } System.Data.SqlClient.SqlConnection DBConnection = null; System.Data.SqlClient.SqlCommand cmd = null; System.Data.SqlClient.SqlTransaction DBTransaction = null; try { DBConnection = objProfile.GetDBSource(); if (DBConnection == null) { strErr += ("Не удалось получить соединение с базой данных."); return(bRet); } DBTransaction = DBConnection.BeginTransaction(); cmd = new System.Data.SqlClient.SqlCommand(); cmd.Connection = DBConnection; cmd.Transaction = DBTransaction; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = System.String.Format("[{0}].[dbo].[usp_EditAccountPlan]", objProfile.GetOptionsDllDBName()); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ACCOUNTPLAN_GUID", System.Data.SqlDbType.UniqueIdentifier)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ACCOUNTPLAN_NAME", System.Data.DbType.String)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ACCOUNTPLAN_1C_CODE", System.Data.DbType.String)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ACCOUNTPLAN_ACTIVE", System.Data.SqlDbType.Bit)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ERROR_NUM", System.Data.SqlDbType.Int, 8, System.Data.ParameterDirection.Output, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ERROR_MES", System.Data.SqlDbType.NVarChar, 4000)); cmd.Parameters["@ERROR_MES"].Direction = System.Data.ParameterDirection.Output; cmd.Parameters["@ACCOUNTPLAN_GUID"].Value = ACCOUNTPLAN_GUID; cmd.Parameters["@ACCOUNTPLAN_NAME"].Value = ACCOUNTPLAN_NAME; cmd.Parameters["@ACCOUNTPLAN_1C_CODE"].Value = ACCOUNTPLAN_1C_CODE; cmd.Parameters["@ACCOUNTPLAN_ACTIVE"].Value = ACCOUNTPLAN_ACTIVE; cmd.ExecuteNonQuery(); System.Int32 iRes = (System.Int32)cmd.Parameters["@RETURN_VALUE"].Value; if (iRes == 0) { // подтверждаем транзакцию DBTransaction.Commit(); } else { DBTransaction.Rollback(); strErr += ((cmd.Parameters["@ERROR_MES"].Value == System.DBNull.Value) ? "" : (System.String)cmd.Parameters["@ERROR_MES"].Value); } cmd.Dispose(); bRet = (iRes == 0); } catch (System.Exception f) { DBTransaction.Rollback(); strErr += ("Не удалось внести изменения в объект 'счёт'. Текст ошибки: " + f.Message); } finally { DBConnection.Close(); } return(bRet); }
public bool RecibirGuiasAsociadas(System.Data.SqlClient.SqlTransaction transaccion, IUsuarios usuario) { foreach (GuiaRendicionDetalle guiaRendida in this.guiasRendidas) { GuiaEstadoHistorico oGuiaEstado = new GuiaEstadoHistorico(); //GuiaEstadoHistoricoDatos oGuiaDatos = new GuiaEstadoHistoricoDatos(); //guiaRendida.GuiaID=this.GuiaID; if (guiaRendida.EnAdministracion) { /*SFE: Ver si la guia con servicio que debe rendirse es para cliente eventual o corporativo*/ IGuia guia = new Guia(); guia.GuiaID = guiaRendida.GuiaRendidaID; DsGuiaFactura ds = new DsGuiaFactura(); ds = guia.GetGuiaFacturaByGuiaID(); bool eventual = false; if (ds.Datos != null && ds.Datos.Rows.Count > 0) { DsGuiaFactura.DatosRow dr = (DsGuiaFactura.DatosRow)ds.Datos.Rows[0]; if ((dr.TipoAgenteGuiaPagoID == (int)NegociosSisPackInterface.SisPack.TipoAgenteGuia.Remitente && dr.IsRemitenteClienteNull()) || (dr.TipoAgenteGuiaPagoID == (int)NegociosSisPackInterface.SisPack.TipoAgenteGuia.Destinatario && dr.IsDestinatarioClienteNull())) { eventual = true; } } /*Si la guia es de un cliente eventual y debe rendirse entonces se cierra el circuito administrativo*/ if (eventual) { oGuiaEstado.GuiaID = guiaRendida.GuiaRendidaID; oGuiaEstado.EstadoGuiaID = (int)SisPack.ValorEstadoRendicionAdministracion.Ninguno; oGuiaEstado.TipoEstadoGuiaID = SisPack.TipoEstadoGuia.EstadoRendicionAdministracion; oGuiaEstado.UsuarioID = usuario.UsuarioID; oGuiaEstado.FechaHis = DateTime.Today; oGuiaEstado.AgenciaID = agenciaUsuaria; //oGuiaEstado.Observaciones = obs; oGuiaEstado.Observaciones = ""; oGuiaEstado.Guardar(transaccion); } /*Si la guia es de un cliente corporativo y debe rendirse entonces se debe seguir con el circuito administrativo*/ else { oGuiaEstado.GuiaID = guiaRendida.GuiaRendidaID; oGuiaEstado.EstadoGuiaID = (int)SisPack.ValorEstadoRendicionAdministracion.PendienteAsignarPlanillaRendicCliente; oGuiaEstado.TipoEstadoGuiaID = SisPack.TipoEstadoGuia.EstadoRendicionAdministracion; oGuiaEstado.UsuarioID = usuario.UsuarioID; oGuiaEstado.FechaHis = DateTime.Today; oGuiaEstado.AgenciaID = agenciaUsuaria; //oGuiaEstado.Observaciones = obs; oGuiaEstado.Observaciones = ""; oGuiaEstado.Guardar(transaccion); } } else //Quiere decir que la guia no llegó y le debe aparecer nuevamente a la agencia que emitió la guia de rendición, para asociarla a una nueva guía de rendición { oGuiaEstado.GuiaID = guiaRendida.GuiaRendidaID; oGuiaEstado.EstadoGuiaID = (int)SisPack.ValorEstadoRendicionAdministracion.PendienteAsignarGuiaRendicion; oGuiaEstado.TipoEstadoGuiaID = SisPack.TipoEstadoGuia.EstadoRendicionAdministracion; oGuiaEstado.UsuarioID = usuario.UsuarioID; oGuiaEstado.FechaHis = DateTime.Today; oGuiaEstado.AgenciaID = agenciaUsuaria; //oGuiaEstado.Observaciones = obs; oGuiaEstado.Observaciones = ""; oGuiaEstado.Guardar(transaccion); } } return(true); }
public bool Guardar(System.Data.SqlClient.SqlTransaction transaccion) { Config.Conexion.EjecutarSinResultados(transaccion, "PlanillaRemitoClienteGuiasINS", this.PlanillaRemitoClienteID, this.GuiaID, this.guiaRendicionID); return(true); }
/// <summary> /// Lets you efficiently bulk insert many entities to the database. /// </summary> /// <param name="transactionManager">The transaction manager.</param> /// <param name="entities">The entities.</param> /// <remarks> /// After inserting into the datasource, the Nettiers.AdventureWorks.Entities.SalesPerson object will be updated /// to refelect any changes made by the datasource. (ie: identity or computed columns) /// </remarks> public override void BulkInsert(TransactionManager transactionManager, TList <Nettiers.AdventureWorks.Entities.SalesPerson> entities) { //System.Data.SqlClient.SqlBulkCopy bulkCopy = new System.Data.SqlClient.SqlBulkCopy(this._connectionString, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints); //, null); System.Data.SqlClient.SqlBulkCopy bulkCopy = null; if (transactionManager != null && transactionManager.IsOpen) { System.Data.SqlClient.SqlConnection cnx = transactionManager.TransactionObject.Connection as System.Data.SqlClient.SqlConnection; System.Data.SqlClient.SqlTransaction transaction = transactionManager.TransactionObject as System.Data.SqlClient.SqlTransaction; bulkCopy = new System.Data.SqlClient.SqlBulkCopy(cnx, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints, transaction); //, null); } else { bulkCopy = new System.Data.SqlClient.SqlBulkCopy(this._connectionString, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints); //, null); } bulkCopy.BulkCopyTimeout = 360; bulkCopy.DestinationTableName = "SalesPerson"; DataTable dataTable = new DataTable(); DataColumn col0 = dataTable.Columns.Add("SalesPersonID", typeof(System.Int32)); col0.AllowDBNull = false; DataColumn col1 = dataTable.Columns.Add("TerritoryID", typeof(System.Int32)); col1.AllowDBNull = true; DataColumn col2 = dataTable.Columns.Add("SalesQuota", typeof(System.Decimal)); col2.AllowDBNull = true; DataColumn col3 = dataTable.Columns.Add("Bonus", typeof(System.Decimal)); col3.AllowDBNull = false; DataColumn col4 = dataTable.Columns.Add("CommissionPct", typeof(System.Decimal)); col4.AllowDBNull = false; DataColumn col5 = dataTable.Columns.Add("SalesYTD", typeof(System.Decimal)); col5.AllowDBNull = false; DataColumn col6 = dataTable.Columns.Add("SalesLastYear", typeof(System.Decimal)); col6.AllowDBNull = false; DataColumn col7 = dataTable.Columns.Add("rowguid", typeof(System.Guid)); col7.AllowDBNull = false; DataColumn col8 = dataTable.Columns.Add("ModifiedDate", typeof(System.DateTime)); col8.AllowDBNull = false; bulkCopy.ColumnMappings.Add("SalesPersonID", "SalesPersonID"); bulkCopy.ColumnMappings.Add("TerritoryID", "TerritoryID"); bulkCopy.ColumnMappings.Add("SalesQuota", "SalesQuota"); bulkCopy.ColumnMappings.Add("Bonus", "Bonus"); bulkCopy.ColumnMappings.Add("CommissionPct", "CommissionPct"); bulkCopy.ColumnMappings.Add("SalesYTD", "SalesYTD"); bulkCopy.ColumnMappings.Add("SalesLastYear", "SalesLastYear"); bulkCopy.ColumnMappings.Add("rowguid", "rowguid"); bulkCopy.ColumnMappings.Add("ModifiedDate", "ModifiedDate"); foreach (Nettiers.AdventureWorks.Entities.SalesPerson entity in entities) { if (entity.EntityState != EntityState.Added) { continue; } DataRow row = dataTable.NewRow(); row["SalesPersonID"] = entity.SalesPersonId; row["TerritoryID"] = entity.TerritoryId.HasValue ? (object)entity.TerritoryId : System.DBNull.Value; row["SalesQuota"] = entity.SalesQuota.HasValue ? (object)entity.SalesQuota : System.DBNull.Value; row["Bonus"] = entity.Bonus; row["CommissionPct"] = entity.CommissionPct; row["SalesYTD"] = entity.SalesYtd; row["SalesLastYear"] = entity.SalesLastYear; row["rowguid"] = entity.Rowguid; row["ModifiedDate"] = entity.ModifiedDate; dataTable.Rows.Add(row); } // send the data to the server bulkCopy.WriteToServer(dataTable); // update back the state foreach (Nettiers.AdventureWorks.Entities.SalesPerson entity in entities) { if (entity.EntityState != EntityState.Added) { continue; } entity.AcceptChanges(); } }
/// <summary> /// 获得数据列表 /// </summary> public List <WTCJ.Model.JD_SF> GetModelList(System.Data.SqlClient.SqlTransaction tran, string strWhere) { DataSet ds = dal.GetList(tran, strWhere); return(DataTableToList(ds.Tables[0])); }
private void 升级数据库版本ToolStripMenuItem_Click(object sender, EventArgs e) { if (MessageBox.Show("确定需要升级数据库?", "提示", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.Cancel) { return; } var re = ServiceContext.LoadConnectionStringSettings(); try { System.Data.SqlClient.SqlConnection oleConnection = new System.Data.SqlClient.SqlConnection(re.ConnectionString); oleConnection.Open(); string sql = "select * from __MigrationHistory"; System.Data.SqlClient.SqlDataAdapter sda = new System.Data.SqlClient.SqlDataAdapter(sql, oleConnection); DataSet dsM = new DataSet(); sda.Fill(dsM); DataTable dtM = dsM.Tables[0]; Action <System.Data.SqlClient.SqlConnection, System.Data.SqlClient.SqlDataAdapter, DataSet, DataTable> ReleaseDb = (a, b, c, d) => { a.Close(); a.Dispose(); a = null; b.Dispose(); b = null; c.Dispose(); c = null; d.Dispose(); d = null; }; var v = dtM.AsEnumerable().OrderBy(r => r.Field <string>(0)).LastOrDefault(); DateTime DBMDT = DateTime.ParseExact(v.Field <string>(0).Substring(0, 8), "yyyyMMdd", null, System.Globalization.DateTimeStyles.None); DateTime MDT = DateTime.ParseExact(DataBaseMigrationDataModel.MigrationKeys.MigrationId.Substring(0, 8), "yyyyMMdd", null, System.Globalization.DateTimeStyles.None); if (MDT <= DBMDT) { MessageBox.Show("数据库服务器已经是最新的版本!"); ReleaseDb(oleConnection, sda, dsM, dtM); return; } System.Data.SqlClient.SqlCommand sqlc = new System.Data.SqlClient.SqlCommand(); System.Data.SqlClient.SqlTransaction sqltrans = oleConnection.BeginTransaction(); sqlc.Connection = oleConnection; sqlc.Transaction = sqltrans; string ins = "INSERT INTO __MigrationHistory (MigrationId,ProductVersion,Model) VALUES('" + DataBaseMigrationDataModel.MigrationKeys.MigrationId + "','" + DataBaseMigrationDataModel.MigrationKeys.ProductVersion + "'," + DataBaseMigrationDataModel.MigrationKeys.Model + ")"; sqlc.CommandText = ins; sqlc.ExecuteNonQuery(); System.IO.StreamReader sr = new System.IO.StreamReader("pharmacy_Update3.publish.sql", Encoding.UTF8); System.Text.RegularExpressions.Regex reg = new System.Text.RegularExpressions.Regex(@";Initial Catalog=\w+;"); var Regdbname = reg.Match(re.ConnectionString).ToString(); Regdbname = Regdbname.Substring(0, Regdbname.Length - 1); int idx = Regdbname.LastIndexOf("="); string DBName = Regdbname.Substring(idx + 1); sqlc.CommandText = string.Format("use [{0}] ", DBName); bool IsNote = false; while (sr.Peek() > -1) { string s = sr.ReadLine(); if (string.IsNullOrEmpty(s.Trim())) { continue; } if (s.StartsWith("/*")) { IsNote = true; } if (s.StartsWith("*/")) { IsNote = false; continue; } if (s.Trim().Contains("GO")) { continue; } if (s.StartsWith(":")) { s = s.Substring(1); } if (s.Trim().Contains("USE [$(DatabaseName)]")) { continue; } if (s.Contains("PRINT")) { continue; } if (!IsNote) { sqlc.CommandText += s + "\r\n"; } } sqlc.ExecuteNonQuery(); sqltrans.Commit(); sqlc.Dispose(); sqlc = null; ReleaseDb(oleConnection, sda, dsM, dtM); MessageBox.Show("数据库服务器升级完毕!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { } }
public bool Eliminar(System.Data.SqlClient.SqlTransaction transaccion) { Config.Conexion.EjecutarSinResultados(transaccion, "CotizacionClienteUVentaModalidadDEL", this.cotizacionClienteUVentaModalidadID); return(true); }
/// <summary> /// Creates and configures a new instance of the SqlDataAdapter_tblCategory class. /// </summary> /// <param name="sqlTransaction">A valid System.Data.SqlClient.SqlTransaction to the database.</param> /// <param name="tableName">Table name to be use in the DataSet.</param> public SqlDataAdapter_tblCategory(System.Data.SqlClient.SqlTransaction sqlTransaction, string tableName) : this(sqlTransaction) { this.Configure(tableName); }
/// <summary> /// Редактирование записи в базе данных /// </summary> /// <param name="IntWaybillState_Guid">УИ записи</param> /// <param name="IntWaybillState_Name">наименование состояния накладной на внутреннее перемещение</param> /// <param name="IntWaybillState_Description">примечание</param> /// <param name="IntWaybillState_IsActive">признак "запись активна"</param> /// <param name="IntWaybillState_IsDefault">признак "использовать по умолчанию"</param> /// <param name="IntWaybillState_Id">код вида оплаты</param> /// <param name="IntWaybillState_Guid">УИ записи</param> /// <param name="objProfile">профайл</param> /// <param name="strErr">сообщение об ошибке</param> /// <returns>true - удачное завершение операции; false - ошибка</returns> public static System.Boolean EditObjectInDataBase(System.Guid IntWaybillState_Guid, System.String IntWaybillState_Name, System.String IntWaybillState_Description, System.Boolean IntWaybillState_IsActive, System.Boolean IntWaybillState_IsDefault, System.Int32 IntWaybillState_Id, UniXP.Common.CProfile objProfile, ref System.String strErr) { System.Boolean bRet = false; if (IsAllParametersValid(IntWaybillState_Name, IntWaybillState_Id, ref strErr) == false) { return(bRet); } System.Data.SqlClient.SqlConnection DBConnection = null; System.Data.SqlClient.SqlCommand cmd = null; System.Data.SqlClient.SqlTransaction DBTransaction = null; try { DBConnection = objProfile.GetDBSource(); if (DBConnection == null) { strErr += ("Не удалось получить соединение с базой данных."); return(bRet); } DBTransaction = DBConnection.BeginTransaction(); cmd = new System.Data.SqlClient.SqlCommand(); cmd.Connection = DBConnection; cmd.Transaction = DBTransaction; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = System.String.Format("[{0}].[dbo].[usp_EditWaybillState]", objProfile.GetOptionsDllDBName()); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IntWaybillState_Guid", System.Data.SqlDbType.UniqueIdentifier)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IntWaybillState_Name", System.Data.DbType.String)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IntWaybillState_Description", System.Data.DbType.String)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IntWaybillState_IsActive", System.Data.SqlDbType.Bit)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IntWaybillState_IsDefault", System.Data.SqlDbType.Bit)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IntWaybillState_Id", System.Data.SqlDbType.Int)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ERROR_NUM", System.Data.SqlDbType.Int, 8, System.Data.ParameterDirection.Output, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ERROR_MES", System.Data.SqlDbType.NVarChar, 4000)); cmd.Parameters["@ERROR_MES"].Direction = System.Data.ParameterDirection.Output; cmd.Parameters["@IntWaybillState_Guid"].Value = IntWaybillState_Guid; cmd.Parameters["@IntWaybillState_Name"].Value = IntWaybillState_Name; cmd.Parameters["@IntWaybillState_Description"].Value = IntWaybillState_Description; cmd.Parameters["@IntWaybillState_IsActive"].Value = IntWaybillState_IsActive; cmd.Parameters["@IntWaybillState_IsDefault"].Value = IntWaybillState_IsDefault; cmd.Parameters["@IntWaybillState_Id"].Value = IntWaybillState_Id; cmd.ExecuteNonQuery(); System.Int32 iRes = (System.Int32)cmd.Parameters["@RETURN_VALUE"].Value; if (iRes == 0) { // подтверждаем транзакцию DBTransaction.Commit(); } else { DBTransaction.Rollback(); strErr += ((cmd.Parameters["@ERROR_MES"].Value == System.DBNull.Value) ? "" : (System.String)cmd.Parameters["@ERROR_MES"].Value); } cmd.Dispose(); bRet = (iRes == 0); } catch (System.Exception f) { DBTransaction.Rollback(); strErr += ("Не удалось внести изменения в объект \"состояние накладной на внутреннее перемещение\". Текст ошибки: " + f.Message); } finally { DBConnection.Close(); } return(bRet); }
public override void CommitTransaction() { System.Data.SqlClient.SqlConnection oSqlConnection = _SqlTransaction.Connection; _SqlTransaction.Commit(); oSqlConnection.Close(); _SqlTransaction = null; }
/// <summary> /// Lets you efficiently bulk insert many entities to the database. /// </summary> /// <param name="transactionManager">The transaction manager.</param> /// <param name="entities">The entities.</param> /// <remarks> /// After inserting into the datasource, the LibraryManagement.Domain.Language object will be updated /// to refelect any changes made by the datasource. (ie: identity or computed columns) /// </remarks> public override void BulkInsert(TransactionManager transactionManager, TList <LibraryManagement.Domain.Language> entities) { //System.Data.SqlClient.SqlBulkCopy bulkCopy = new System.Data.SqlClient.SqlBulkCopy(this._connectionString, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints); //, null); System.Data.SqlClient.SqlBulkCopy bulkCopy = null; if (transactionManager != null && transactionManager.IsOpen) { System.Data.SqlClient.SqlConnection cnx = transactionManager.TransactionObject.Connection as System.Data.SqlClient.SqlConnection; System.Data.SqlClient.SqlTransaction transaction = transactionManager.TransactionObject as System.Data.SqlClient.SqlTransaction; bulkCopy = new System.Data.SqlClient.SqlBulkCopy(cnx, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints, transaction); //, null); } else { bulkCopy = new System.Data.SqlClient.SqlBulkCopy(this._connectionString, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints); //, null); } bulkCopy.BulkCopyTimeout = 360; bulkCopy.DestinationTableName = "tblLanguage"; DataTable dataTable = new DataTable(); DataColumn col0 = dataTable.Columns.Add("id", typeof(System.Decimal)); col0.AllowDBNull = false; DataColumn col1 = dataTable.Columns.Add("description", typeof(System.String)); col1.AllowDBNull = false; DataColumn col2 = dataTable.Columns.Add("status", typeof(System.Boolean)); col2.AllowDBNull = false; bulkCopy.ColumnMappings.Add("id", "id"); bulkCopy.ColumnMappings.Add("description", "description"); bulkCopy.ColumnMappings.Add("status", "status"); foreach (LibraryManagement.Domain.Language entity in entities) { if (entity.EntityState != EntityState.Added) { continue; } DataRow row = dataTable.NewRow(); row["id"] = entity.Id; row["description"] = entity.Description; row["status"] = entity.Status; dataTable.Rows.Add(row); } // send the data to the server bulkCopy.WriteToServer(dataTable); // update back the state foreach (LibraryManagement.Domain.Language entity in entities) { if (entity.EntityState != EntityState.Added) { continue; } entity.AcceptChanges(); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hi.Model.YZT_FirstCamp model, System.Data.SqlClient.SqlTransaction Tran) { return(dal.Add(model, Tran)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hi.Model.YZT_FirstCamp model, System.Data.SqlClient.SqlTransaction Tran) { return(dal.Update(model, Tran)); }
/// <summary> /// Lets you efficiently bulk insert many entities to the database. /// </summary> /// <param name="transactionManager">The transaction manager.</param> /// <param name="entities">The entities.</param> /// <remarks> /// After inserting into the datasource, the LibraryManagement.Domain.PaymentOrder object will be updated /// to refelect any changes made by the datasource. (ie: identity or computed columns) /// </remarks> public override void BulkInsert(TransactionManager transactionManager, TList<LibraryManagement.Domain.PaymentOrder> entities) { //System.Data.SqlClient.SqlBulkCopy bulkCopy = new System.Data.SqlClient.SqlBulkCopy(this._connectionString, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints); //, null); System.Data.SqlClient.SqlBulkCopy bulkCopy = null; if (transactionManager != null && transactionManager.IsOpen) { System.Data.SqlClient.SqlConnection cnx = transactionManager.TransactionObject.Connection as System.Data.SqlClient.SqlConnection; System.Data.SqlClient.SqlTransaction transaction = transactionManager.TransactionObject as System.Data.SqlClient.SqlTransaction; bulkCopy = new System.Data.SqlClient.SqlBulkCopy(cnx, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints, transaction); //, null); } else { bulkCopy = new System.Data.SqlClient.SqlBulkCopy(this._connectionString, System.Data.SqlClient.SqlBulkCopyOptions.CheckConstraints); //, null); } bulkCopy.BulkCopyTimeout = 360; bulkCopy.DestinationTableName = "tblPaymentOrder"; DataTable dataTable = new DataTable(); DataColumn col0 = dataTable.Columns.Add("trans_num", typeof(System.String)); col0.AllowDBNull = false; DataColumn col1 = dataTable.Columns.Add("payer", typeof(System.String)); col1.AllowDBNull = false; DataColumn col2 = dataTable.Columns.Add("payer_acc", typeof(System.String)); col2.AllowDBNull = false; DataColumn col3 = dataTable.Columns.Add("payer_bank", typeof(System.String)); col3.AllowDBNull = false; DataColumn col4 = dataTable.Columns.Add("payer_branch", typeof(System.String)); col4.AllowDBNull = false; DataColumn col5 = dataTable.Columns.Add("benef", typeof(System.String)); col5.AllowDBNull = false; DataColumn col6 = dataTable.Columns.Add("benef_acc", typeof(System.String)); col6.AllowDBNull = false; DataColumn col7 = dataTable.Columns.Add("benef_bank", typeof(System.String)); col7.AllowDBNull = false; DataColumn col8 = dataTable.Columns.Add("benef_branch", typeof(System.String)); col8.AllowDBNull = false; DataColumn col9 = dataTable.Columns.Add("amount", typeof(System.Decimal)); col9.AllowDBNull = false; bulkCopy.ColumnMappings.Add("trans_num", "trans_num"); bulkCopy.ColumnMappings.Add("payer", "payer"); bulkCopy.ColumnMappings.Add("payer_acc", "payer_acc"); bulkCopy.ColumnMappings.Add("payer_bank", "payer_bank"); bulkCopy.ColumnMappings.Add("payer_branch", "payer_branch"); bulkCopy.ColumnMappings.Add("benef", "benef"); bulkCopy.ColumnMappings.Add("benef_acc", "benef_acc"); bulkCopy.ColumnMappings.Add("benef_bank", "benef_bank"); bulkCopy.ColumnMappings.Add("benef_branch", "benef_branch"); bulkCopy.ColumnMappings.Add("amount", "amount"); foreach(LibraryManagement.Domain.PaymentOrder entity in entities) { if (entity.EntityState != EntityState.Added) continue; DataRow row = dataTable.NewRow(); row["trans_num"] = entity.TransNum; row["payer"] = entity.Payer; row["payer_acc"] = entity.PayerAcc; row["payer_bank"] = entity.PayerBank; row["payer_branch"] = entity.PayerBranch; row["benef"] = entity.Benef; row["benef_acc"] = entity.BenefAcc; row["benef_bank"] = entity.BenefBank; row["benef_branch"] = entity.BenefBranch; row["amount"] = entity.Amount; dataTable.Rows.Add(row); } // send the data to the server bulkCopy.WriteToServer(dataTable); // update back the state foreach(LibraryManagement.Domain.PaymentOrder entity in entities) { if (entity.EntityState != EntityState.Added) continue; entity.AcceptChanges(); } }