c#中对事务的处理(部分)

最新推荐文章于 2019-07-14 21:23:46 发布

zhangweibo2008

最新推荐文章于 2019-07-14 21:23:46 发布

阅读量429

点赞数 1

文章标签： c# string cmd

本文链接：https://blog.csdn.net/zhangweibo2008/article/details/6463282

版权

private bool TransferAccount()
        {
            bool flag = false;
            string transferFrom=cbbTransferFrom.SelectedValue.ToString();
            string transferTo=cbbTransferTo.SelectedValue.ToString();
            if (tbAccounts.Text=="")
            {
                MessageBox.Show("请输入转账金额");
                tbAccounts.Focus();
            }
            else
            {
                int account = int.Parse(tbAccounts.Text.ToString());
                if (transferFrom != transferTo)
                {
                    cn = GetCn();
                    SqlTransaction st = cn.BeginTransaction();
                    cmd = cn.CreateCommand();
                    cmd.Transaction = st;
                    try
                    {
                        cmd.CommandText = string.Format("update bankAccount set bankroll=bankroll+{0} where id={1}", -account, transferFrom);
                        cmd.ExecuteNonQuery();
                        cmd.CommandText = string.Format("update bankAccount set bankroll=bankroll+{0} where id={1}", account, transferTo);
                        cmd.ExecuteNonQuery();
                        st.Commit();
                        flag = true;
                    }
                    catch
                    {
                        st.Rollback();
                    }
                }
                else
                {
                    MessageBox.Show("不能给自己转账");
                }
            }
            return flag;