public override DataTable GetDateTable(int cmdtype, string cmdText, object commandParameters) { try { CommandType cmdType; if (cmdtype == 1) { cmdType = CommandType.StoredProcedure; } else { cmdType = CommandType.Text; } SqlParameter[] cmdParameters = null; if (commandParameters != null) { cmdParameters = commandParameters as SqlParameter[]; } DataTable ds = MsSqlHelper.GetDateTable(ConnectionstringLocalTransaction, cmdType, cmdText, cmdParameters); return(ds); } catch (SqlException ex) { } return(null); }
public override DataTable GetDateTable(string cmdText) { try { DataTable ds = MsSqlHelper.GetDateTable(ConnectionstringLocalTransaction, CommandType.Text, cmdText, null); return(ds); } catch (SqlException ex) { } return(null); }
public static DataTable GetDateTable(CommandType cmdType, string cmdText, params SqlParameter[] commandParameters) { try { DateTime dt1 = DateTime.Now; DataTable ds = MsSqlHelper.GetDateTable(ConnectionstringLocalTransaction, cmdType, cmdText, commandParameters); if ((DateTime.Now - dt1).TotalMilliseconds > 3000) { SMSLog.Debug("SqlDBExec =>GetDateTable 耗时:" + (DateTime.Now - dt1).TotalMilliseconds + "毫秒"); } return(ds); }catch (SqlException ex) { } return(null); }