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