public override void LoadData(DBConn dbConn)
{
dbConn.SourceInfo = "MiscData.LoadData";
colNo = -88;
string dataType;
decimal curr;
DateTime dt;
try
{
for (int k = 0; k < dbConn.ColumnCount; k++)
{
if (k > theData.Length)
{
break;
}
dataType = dbConn.ColDataType("", k).ToUpper();
if (dataType.Contains("DATE"))
{
dt = dbConn.ColDate("", k);
theData[k] = Tools.DateToString(dt, 7, 0); // yyyy-mm-dd
}
else if (dataType.Contains("DECIMAL") || dataType.Contains("FLOAT"))
{
curr = dbConn.ColDecimal("", k);
theData[k] = Tools.DecimalToString(curr, 2);
}
else
{
theData[k] = dbConn.ColValue(k);
}
if (theData[k].ToUpper().StartsWith("[FORECOLOR]"))
{
foreColor = System.Drawing.Color.FromName(theData[k].Substring(11).Trim());
}
else if (theData[k].ToUpper().StartsWith("[BACKCOLOR]"))
{
backColor = System.Drawing.Color.FromName(theData[k].Substring(11).Trim());
}
}
}
catch (Exception ex)
{
Tools.LogException("LoadData", "", ex, this);
}
}
public static string SQLDebug(string sql)
{
sql = Tools.NullToString(sql);
if (sql.Length < 3)
{
return("Invalid SQL" + (sql.Length > 0 ? " (" + sql + ")" : ""));
}
DBConn conn = null;
StringBuilder ret = new StringBuilder();
string str = "SQL = " + sql;
try
{
Tools.LogInfo("Tools.SQLDebug/2", str, 255);
ret.Append(str + Constants.C_HTMLBREAK());
Tools.OpenDB(ref conn);
if (conn.Execute(sql))
{
str = "Execution successful, column count = " + conn.ColumnCount.ToString() + (conn.EOF ? " (NO rows)" : " (At least one row)");
Tools.LogInfo("Tools.SQLDebug/3", str, 255);
ret.Append(str + "<hr />"); // Constants.C_HTMLBREAK());
string colType;
for (int k = 0; k < conn.ColumnCount; k++)
{
str = "(Col " + k.ToString()
+ ") Name = " + conn.ColName(k)
+ ", Type = " + conn.ColDataType("", k)
+ ", Value = ";
colType = conn.ColDataType("", k).ToUpper();
if (conn.ColStatus("", k) == Constants.DBColumnStatus.ValueIsNull)
{
str = str + "NULL";
}
else if (colType == "NVARCHAR" || colType == "NCHAR")
{
str = str + conn.ColUniCode("", 0, k);
}
else
{
str = str + conn.ColValue(k);
}
Tools.LogInfo("Tools.SQLDebug/4", str, 255);
ret.Append(str + Constants.C_HTMLBREAK());
}
}
else
{
str = "Execution failed";
Tools.LogInfo("Tools.SQLDebug/5", str, 255);
ret.Append(str + Constants.C_HTMLBREAK());
}
}
catch (Exception ex)
{
str = "Error : " + ex.Message;
Tools.LogInfo("Tools.SQLDebug/6", str, 255);
ret.Append(str + Constants.C_HTMLBREAK());
}
finally
{
Tools.CloseDB(ref conn);
}
return(ret.ToString());
}
