/// <summary> /// 执行SQL语句,并且发送指定表更新信息 /// </summary> /// <param name="strSQL"></param> /// <param name="UpdateTableName"></param> /// <returns>收影响的行数</returns> public static int ExecuteSQL(string strSQL, string UpdateTableName) { try { using (SqlConnection conn = new SqlConnection(Global.ServerDBStr)) { using (SqlCommand command = new SqlCommand(strSQL, conn)) { conn.Open(); command.CommandText = strSQL; int result = 0; result = command.ExecuteNonQuery(); if (result > 0) { //给服务器发送更新数据库命令 Socket_Service.SendMessage(Socket_Service.Command_C2S_UpdateDB, UpdateTableName, "", "", "", "", "", "", "", ""); } return(result); } } } catch (Exception ex) { throw ex; } }
/// <summary> /// 从表更新数据库 /// </summary> /// <param name="MainDataSetTable"></param> /// <returns></returns> public static int UpdateDBFromTable(DataTable MainDataSetTable) { try { using (SqlConnection conn = new SqlConnection(Global.ServerDBStr)) { using (SqlCommand command = new SqlCommand("select * from " + MainDataSetTable.TableName, conn)) { using (SqlDataAdapter adapter = new SqlDataAdapter(command)) { using (SqlCommandBuilder myBuilder = new SqlCommandBuilder(adapter)) { int result = 0; result = adapter.Update(MainDataSetTable); if (result > 0) { //给服务器发送更新数据库命令 Socket_Service.SendMessage(Socket_Service.Command_C2S_UpdateDB, MainDataSetTable.TableName, "", "", "", "", "", "", "", ""); } return(result); } } } } } catch (Exception ex) { throw ex; } }
/// <summary> /// 以一个事务执行SQL语句组 /// </summary> /// <param name="strSQLs"></param> /// <returns>收影响的行数</returns> public static int ExecuteSQLs(List <string> strSQLs, string[] UpdateTableNameArray) { int result = 0; SqlTransaction tran = null; try { using (SqlConnection conn = new SqlConnection(Global.ServerDBStr)) { using (SqlCommand command = new SqlCommand()) { conn.Open(); tran = conn.BeginTransaction(); command.Connection = conn; command.Transaction = tran; for (int i = 0; i < strSQLs.Count; i++) { command.CommandText = strSQLs[i].ToString(); result += command.ExecuteNonQuery(); } tran.Commit(); } } if (result > 0) { //给服务器发送更新数据库命令 switch (UpdateTableNameArray.Length) { case 1: Socket_Service.SendMessage(Socket_Service.Command_C2S_UpdateDB, UpdateTableNameArray[0], "", "", "", "", "", "", "", ""); break; case 2: Socket_Service.SendMessage(Socket_Service.Command_C2S_UpdateDB, UpdateTableNameArray[0], UpdateTableNameArray[1], "", "", "", "", "", "", ""); break; case 3: Socket_Service.SendMessage(Socket_Service.Command_C2S_UpdateDB, UpdateTableNameArray[0], UpdateTableNameArray[1], UpdateTableNameArray[2], "", "", "", "", "", ""); break; case 4: Socket_Service.SendMessage(Socket_Service.Command_C2S_UpdateDB, UpdateTableNameArray[0], UpdateTableNameArray[1], UpdateTableNameArray[2], UpdateTableNameArray[3], "", "", "", "", ""); break; case 5: Socket_Service.SendMessage(Socket_Service.Command_C2S_UpdateDB, UpdateTableNameArray[0], UpdateTableNameArray[1], UpdateTableNameArray[2], UpdateTableNameArray[3], UpdateTableNameArray[4], "", "", "", ""); break; case 6: Socket_Service.SendMessage(Socket_Service.Command_C2S_UpdateDB, UpdateTableNameArray[0], UpdateTableNameArray[1], UpdateTableNameArray[2], UpdateTableNameArray[3], UpdateTableNameArray[4], UpdateTableNameArray[5], "", "", ""); break; case 7: Socket_Service.SendMessage(Socket_Service.Command_C2S_UpdateDB, UpdateTableNameArray[0], UpdateTableNameArray[1], UpdateTableNameArray[2], UpdateTableNameArray[3], UpdateTableNameArray[4], UpdateTableNameArray[5], UpdateTableNameArray[6], "", ""); break; case 8: Socket_Service.SendMessage(Socket_Service.Command_C2S_UpdateDB, UpdateTableNameArray[0], UpdateTableNameArray[1], UpdateTableNameArray[2], UpdateTableNameArray[3], UpdateTableNameArray[4], UpdateTableNameArray[5], UpdateTableNameArray[6], UpdateTableNameArray[7], ""); break; case 9: Socket_Service.SendMessage(Socket_Service.Command_C2S_UpdateDB, UpdateTableNameArray[0], UpdateTableNameArray[1], UpdateTableNameArray[2], UpdateTableNameArray[3], UpdateTableNameArray[4], UpdateTableNameArray[5], UpdateTableNameArray[6], UpdateTableNameArray[7], UpdateTableNameArray[8]); break; } } return(result); } catch (Exception ex) { throw ex; } }