using (SqlConnection con = new SqlConnection(conStr))
{
con.Open();
using (SqlTransaction tran = con.BeginTransaction())
{
using (SqlCommand com = new SqlCommand("", con, tran))
{
try
{
Guid id = Guid.NewGuid();
com.Parameters.Add(new SqlParameter("id", id));
com.Parameters.Add(new SqlParameter("targetId", form.TargetId));
com.Parameters.Add(new SqlParameter("fileName", form.FileName));
com.Parameters.Add(new SqlParameter("fileName1", form.FileName1));
com.Parameters.Add(new SqlParameter("Name", form.Name));
com.Parameters.Add(new SqlParameter("CUserId", form.CUserId));
com.CommandText = "insert into dbo.cs_UploadFiles([Id],[TargetId],[FileName],[FileName1]) values(@id,@targetId,@fileName,@fileName1)";
com.ExecuteNonQuery();
com.CommandText = "insert into dbo.cs_Infos([Id],[TargetId],[Name],[CUserId]) values(@id,@targetId,@Name,@CUserId)";
com.ExecuteNonQuery();
tran.Commit();
return 1;
}
catch
{
tran.Rollback();
return 0;
}
}
}
}
ADO.net - 事务使用范例
最新推荐文章于 2019-07-10 09:44:43 发布