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();
}
}
