public static void InsertContractTransactionFromApplication(string connectionString, int applicationType, int applicationId)
{
object appObj;
ContractTransaction[] transactionArray = GetTransactionArrayFromApplication(connectionString, applicationType,
applicationId, out appObj);
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlTransaction myTrans = conn.BeginTransaction();
try
{
DataAccess dal = new DataAccess(myTrans);
foreach (ContractTransaction contractTransaction in transactionArray)
{
int id = DbHelper.InsertEntity(dal, contractTransaction);
if(id <= 0)
throw new Exception("insert failed");
}
myTrans.Commit();
}
catch (Exception e)
{
try
{
myTrans.Rollback();
}
catch (SqlException ex)
{
if (myTrans.Connection != null)
{
Console.WriteLine("回滚失败!异常类型:" + ex.GetType());
}
}
}
finally
{
conn.Close();
}
}
{
object appObj;
ContractTransaction[] transactionArray = GetTransactionArrayFromApplication(connectionString, applicationType,
applicationId, out appObj);
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlTransaction myTrans = conn.BeginTransaction();
try
{
DataAccess dal = new DataAccess(myTrans);
foreach (ContractTransaction contractTransaction in transactionArray)
{
int id = DbHelper.InsertEntity(dal, contractTransaction);
if(id <= 0)
throw new Exception("insert failed");
}
myTrans.Commit();
}
catch (Exception e)
{
try
{
myTrans.Rollback();
}
catch (SqlException ex)
{
if (myTrans.Connection != null)
{
Console.WriteLine("回滚失败!异常类型:" + ex.GetType());
}
}
}
finally
{
conn.Close();
}
}