数据库事务，ado数据库操作

1 数据库操作，事务，在dal中

//数据库链接字符串格式
//<add name="sqlconn" connectionString="Data Source=192.168.1.123;Initial Catalog=databasename; User Id=sa;Password=1213456" />
//获取数据库链接字符串
public static string sqlconnectionString = ConfigurationManager.ConnectionStrings["sqlconn"].ToString();

 public int upOrgScore(Object model)
        {
            int res = 0;
            try
            {
                // 创建数据库链接
                using (var conn=new SqlConnection(sqlconnectionString))
                {
                conn.Open();
                    //创建事务
                    using (SqlTransaction tran=conn.BeginTransaction())
                    {
                        //修改机构积分
                        string sql = $"update QX_Base  set Score=2 where BaseId=1";
                        SqlCommand cmd = new SqlCommand(sql, conn, tran);
                        res = cmd.ExecuteNonQuery();
                        if (res<=0)
                        {
                            tran.Rollback();
                            return 0;
                        }

                        //添加积分流水记录表
                         sql = $" insert into table (Id,name)  values (11，'name')";

                        cmd = new SqlCommand(sql, conn, tran);
                        res = cmd.ExecuteNonQuery();
                        if (res <= 0)
                        {
                            tran.Rollback();
                            return 0;
                        }
                        tran.Commit();

                }

            }
            catch (Exception)
            {
                res = 0;
            }

            return res;
        }