110,567
社区成员
发帖
与我相关
我的任务
分享
//删除 修改操作
public static int ExecuteNonQuery(string cmdText, params SqlParameter[] parameters)
{
int result;
if (NetState.isConnect())
{
try
{
result = ExeNonLocal(cmdText, parameters);
LoggerLib.log(typeof(SqlHelper), result > 0 ? "删除、修改操作,Local正常" : "删除、修改操作,Local异常");
result = ExeNonRemote(cmdText, parameters);
LoggerLib.log(typeof(SqlHelper), result > 0 ? "删除、修改操作,Remote正常" : "删除、修改操作,Remote异常");
}
catch (SqlException ex)
{
//防止用着用着突然就断开了。
result = ExeNonLocal(cmdText, parameters);
}
}
else
{
result = ExeNonLocal(cmdText, parameters);
}
return result;
}
private static int ExeNonLocal(string cmdText, SqlParameter[] parameters)
{
int result;
SqlConnection conn = new SqlConnection(conLocal);
conn.Open();
SqlCommand cmd = new SqlCommand(conLocal, conn);
cmd.CommandText = cmdText;
cmd.Parameters.AddRange(parameters);
result = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
cmd.Dispose();
conn.Close();
conn.Dispose();
return result;
}
private static int ExeNonRemote(string cmdText, SqlParameter[] parameters)
{
int result;
using (SqlConnection conn = new SqlConnection(conRemote))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(conRemote, conn))
{
cmd.CommandText = cmdText;
cmd.Parameters.AddRange(parameters);
result = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return result;
}
}
}