/// <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;
}
}
