三层架构的事务如何处理

2013-10-20 03:18:35 412 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

初识机会网络仿真器ONE中ExternalMovement移动模型（导入外部移动数据）最近半个月一直在研究ONE中关于ExternalMovement移动模型的源代码，在网上几乎没有找到相关的资料，很是苦恼，如果有共同研究方向的小伙伴欢迎联系我，共同讨论进步。下面记录一下几点感悟： 1、使用外部数据的前提是在ONE的配置文件中增加及修改相关代码： Group.movementModel = ExternalMovement ExternalMovement.file = move... 阅读详情

初学asp.net,用的是3层架构，考虑到数据同步，所以想用事务，但是百度了许久，用的都是sqlhelper,目前程序并未使用sqlhelper,所以想问下DAL层的事务（非sqlhelper方式）怎么写？BLL层又如何写？

以下是我目前的部分代码。

DAL

public static void SellInsert(string sellCode, string customer, SqlTransaction tran)

{

	SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString);

	try

	{

		conn.Open();

		//tran = conn.BeginTransaction();

		SqlCommand insertcmd = new SqlCommand("insert into tb_Sell(SellCode,Customer_name) values ('" + sellCode + "'," + "'" + customerName +"')", conn);

		insertcmd.ExecuteNonQuery();

	}

	catch (System.Exception ee)

	{

		HttpContext.Current.Response.Write("<script language=javascript>alert('" + ee.Message.ToString() + "')</script>");

	}

	finally

	{

		conn.Close();

	}

}

public static void SellDetailInsert(string sellCode, string product, SqlTransaction tran)

{

	SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString);

	try

	{

		conn.Open();

		//tran = conn.BeginTransaction();

		SqlCommand insertcmd = new SqlCommand("insert into tb_SellDetail(SellCode,Product) values ('" + sellCode + "'," + "'" + product +"')", conn);

		insertcmd.ExecuteNonQuery();

	}

	catch (System.Exception ee)

	{

		HttpContext.Current.Response.Write("<script language=javascript>alert('" + ee.Message.ToString() + "')</script>");

	}

	finally

	{

		conn.Close();

	}

}







BLL

protected void btnSave_Click(object sender, EventArgs e)

{

	SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ChengYiConnectionString"].ConnectionString);

    conn.Open();

    SqlTransaction tran = conn.BeginTransaction(); 

    try

    {

		DAL.Product.SellInsert(this.lblSellCode.Text,this.tbCustomerName.Text,tran);

		DAL.Product.SellDetailInsert(this.lblSellCode.Text,this.tbProduct.Text,tran);

		tran.Commit();

	catch (Exception ex)

    {

		tran.Rollback();

		Response.Write(ex.Message);

	}

	finally

	{

		tran.Dispose();

		conn.Close();

	} 

}