public int ExecuteNonQuery(params WrapedDatabaseParameter[] parmss) { long t = DateTime.Now.Ticks; int n = 0; foreach (WrapedDatabaseParameter parms in parmss) { try { DatabaseParameter[] pars = parms.DatabaseParameters ?? new DatabaseParameter[] { }; DbParameter[] ps = ConvertParameter(pars); DAC dac = new DAC(parms.RoutingKey, parms.ConnectionString); n += dac.ExecuteNonQuery(parms.CmdText, (CommandType)parms.CmdType, ps); Log.Write(LogAction.Svc, className, "ExecuteNonQueryWraped", parms.ConnectionString, parms.CmdText.TrimSql(128), DateTime.Now.Ticks - t, "执行成功:" + pars.ToKeyString()); } catch (Exception e) { Log.Write(LogAction.Error, className, "ExecuteNonQueryWraped", parms.ConnectionString, parms.CmdText.TrimSql(128), DateTime.Now.Ticks - t, "执行出错:" + parms + ";" + e.ToString()); return -1; } } return n; }
public int ExecuteNonQuery(string connString, string cmdText, CommandType cmdType, params DatabaseParameter[] parameters) { long t = DateTime.Now.Ticks; try { DbParameter[] ps = ConvertParameter(parameters); DAC dac = new DAC(connString); int rtn = dac.ExecuteNonQuery(cmdText, cmdType, ps); Log.Write(LogAction.Svc, className, "ExecuteNonQuery", connString, cmdText.TrimSql(128), DateTime.Now.Ticks - t, "执行成功:" + parameters.ToKeyString()); return rtn; } catch (Exception e) { Log.Write(LogAction.Error, className, "ExecuteNonQuery", connString, cmdText.TrimSql(128), DateTime.Now.Ticks - t, "执行出错:cmdText:" + cmdText + ";" + parameters.ToKeyString() + ";" + e.ToString()); } return -1; }