using System.Data.SqlClient;



 1 string idStr="123";
 2 using (SqlConnection conn = new SqlConnection(Appconfig.GetMSSQLStr()))
 3 {
 4 
 5       conn.Open();
 6       using (SqlTransaction trans = conn.BeginTransaction())
 7       {
 8              try
 9              {
10                     SqlCommand cmd = new SqlCommand();
11                     cmd.Connection = conn;
12                     cmd.Transaction = trans;
13 
14                     StringBuilder strHead = new StringBuilder();
15                     strHead.AppendLine("*********日志记录**********：");
16                     strHead.AppendLine("......");
17                     strHead.AppendLine("*********日志记录**********：");
18                     Appconfig.WriteLogFile(strHead.ToString(), "日志文件");
19 
20                     string chksql = "";
21                     #region   sql语句1
22                     chksql = @"select * from table1 where id='{0}'";
23                           
24                     chksql = string.Format(chksql, idStr);
25 
26                     cmd.CommandText = chksql;
27                     cmd.ExecuteNonQuery();
28                     #endregion
29 
30                     #region   sql语句2
31                     chksql = @"select * from table2 where id='{0}'";
32                           
33                     chksql = string.Format(chksql, idStr);
34 
35                     cmd.CommandText = chksql;
36                     cmd.ExecuteNonQuery();
37                     #endregion
38 
39 
40                     trans.Commit();
41 
42                     StringBuilder strHead = new StringBuilder();
43                     resultlog.AppendLine("执行完毕");
44                     Appconfig.WriteLogFile(resultlog.ToString(), "日志文件");
45 
46              }
47              catch (Exception ex)
48              {
49                     trans.Rollback();
50                     StringBuilder str = new StringBuilder();
51                     Appconfig.WriteLogFile(str.ToString(), "日志文件");
52              }
53       }
54       conn.Close();
55 }
  • 1.
  • 2.
  • 3.
  • 4.
  • 5.
  • 6.
  • 7.
  • 8.
  • 9.
  • 10.
  • 11.
  • 12.
  • 13.
  • 14.
  • 15.
  • 16.
  • 17.
  • 18.
  • 19.
  • 20.
  • 21.
  • 22.
  • 23.
  • 24.
  • 25.
  • 26.
  • 27.
  • 28.
  • 29.
  • 30.
  • 31.
  • 32.
  • 33.
  • 34.
  • 35.
  • 36.
  • 37.
  • 38.
  • 39.
  • 40.
  • 41.
  • 42.
  • 43.
  • 44.
  • 45.
  • 46.
  • 47.
  • 48.
  • 49.
  • 50.
  • 51.
  • 52.
  • 53.
  • 54.
  • 55.
  • 56.
  • 57.
  • 58.
  • 59.

作者：꧁执笔小白꧂