• 事务-----2


    事务:
    ACID 原子性,一致性,隔离性,持久性
    一、链接内的事务
    1.创建事务对象。使用链接对象的BeginTransaction()
    SqlTransaction trans = conn.BeginTransaction();
    注意:必须在链接打开的时候创建事务。
    2.把事务对象挂到命令对象上
    cmd.Transaction = trans;
    3.执行命令,提交与回滚事务
    trans.Commit() //一般放在try块中
    trans.Rollback() //一般放在catch块中

    二、跨链接的事务 TransactionScope对象。
    1.启动服务:DTC 分布式事务协调器。
    2.引用事务程序集。在解决方案管理器中,右键添加引用。System.Transactions
    3.使用using System.Transactions 把命名空间导进来。
    4.使用TransactionScope类来控制事务。
    using (TransactionScope ts = new TransactionScope())
    {
    DeleteWork("p001");
    DeleteFamily("p001");
    DeleteInfo("p001");
    ts.Complete(); //必须。它是用来提交事务的。
    }

    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using System.Threading.Tasks;
    using System.Data;
    using System.Data.SqlClient;
    using System.Transactions;

    namespace lian_CommandBehavior
    {
    class Program
    {
    public static string Ab = "server=.;database=wuzi;uid=sa;pwd=123";
    static SqlDataReader Getkc(string name)
    {
    SqlConnection con = new SqlConnection(Ab);
    //try
    //{
    con.Open();
    SqlCommand cmd = con.CreateCommand();
    cmd.CommandText = "select * from kc where WzName='"+name+"'";
    SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
    return dr;
    //}
    //catch (Exception)
    //{
    // Console.WriteLine("文件错误!");
    //}

    }
    static void Main(string[] args)
    {
    string cun="";
    Console.WriteLine("发放物资:");
    Console.Write("请输入要发放的物资的名称:");
    string na = Console.ReadLine();
    cun = Yanname(na);
    if (cun == "ke")
    {
    Jixu(na);
    }
    else
    {
    Console.WriteLine("该物资不存在!");
    }
    Console.ReadLine();
    }
    public static string Yanname(string na)
    {
    string ok = "ke";
    SqlDataReader dr =Getkc(na);
    dr.Read();
    if (dr["WzName"].ToString() == na)
    { ok = "ke"; }
    else ok = "bu";
    dr.Close();
    return ok;

    }
    public static void Jixu(string na)
    {
    int num;
    string unit;
    decimal price;
    SqlDataReader dr = Getkc(na);
    dr.Read();
    num = (int)dr["Num"];
    unit = dr["Unit"].ToString();
    price=(decimal)dr["Price"];
    Console.WriteLine("当前单价:"+price+"元");
    Console.WriteLine("当前库存:"+num+unit);

    Console.Write("请输入发放数量:");
    int numm = Convert.ToInt32(Console.ReadLine());
    Console.Write("请输入接受人:");
    string ren = Console.ReadLine();
    if (num >= numm)
    {
    int num1 = num - numm;
    using (TransactionScope tr = new TransactionScope())
    {
    Gaikcnum(na, num1);
    Chafafang(na, numm, unit, price, ren);
    tr.Complete();
    }
    }
    else
    { Console.WriteLine("您输入的数量已超过该物资的库存数量!"); }
    }
    public static void Gaikcnum(string name,int num)
    {
    SqlConnection con = new SqlConnection(Ab);
    try
    {
    con.Open();
    SqlCommand cmd = con.CreateCommand();
    cmd.CommandText = "update kc set Num=@nu where WzName=@na";
    cmd.Parameters.Clear();
    cmd.Parameters.AddWithValue("@nu",num);
    cmd.Parameters.AddWithValue("@na",name);

    cmd.ExecuteNonQuery();

    }
    catch
    {
    Console.WriteLine("文件错误!--改动");
    }
    finally
    { con.Close(); }
    }
    public static void Chafafang(string na,int num,string unit,decimal price,string ren)
    {
    int count = 0;
    DateTime date = DateTime.Now;
    SqlConnection con = new SqlConnection(Ab);
    try
    {
    con.Open();
    SqlCommand cmd = con.CreateCommand();
    cmd.CommandText = "insert into fafang values (@na,@nu,@un,@pr,@da,@re)";
    cmd.Parameters.Clear();
    cmd.Parameters.AddWithValue("@na",na);
    cmd.Parameters.AddWithValue("@nu", num);
    cmd.Parameters.AddWithValue("@un", unit);
    cmd.Parameters.AddWithValue("@pr", price);
    cmd.Parameters.AddWithValue("@da", date);
    cmd.Parameters.AddWithValue("@re", ren);
    cmd.ExecuteNonQuery();
    cmd.CommandText = "select count(*) from fafang ";
    count = (int)cmd.ExecuteScalar();
    Console.WriteLine("已经有"+count+"人领取了物资!");
    }
    catch
    {
    Console.WriteLine("文件错误!--插入");
    }
    finally
    {
    con.Close();
    }
    }
    }
    }

  • 相关阅读:
    Java学习:线程实现方式
    Java学习:异常的概念
    HDFS 其他命令---fsck
    Linux 常用命令
    Linux命令注释—HDFS运维
    大数据简介
    FusionInsight大数据开发---Oozie应用开发
    FusionInsight大数据开发---Flume应用开发
    FusionInsight大数据开发---Streaming应用开发
    FusionInsight大数据开发---Redis应用开发
  • 原文地址:https://www.cnblogs.com/xianshui/p/4491160.html
Copyright © 2020-2023  润新知