public virtual string getFieldList(string argString)
{
string cmdText = argString;
string argObject = "";
try
{
string connStr = this.connStr;
string argRoutestr = cls.getParameter(connStr, "Data Source");
string newValue = HttpContext.Current.Server.MapPath(cls.getActualRoute(argRoutestr));
OleDbConnection connection = new OleDbConnection(connStr.Replace(argRoutestr, newValue));
connection.Open();
OleDbDataReader reader = new OleDbCommand(cmdText, connection).ExecuteReader();
int fieldCount = reader.FieldCount;
for (int i = 0; i < fieldCount; i++)
{
argObject = argObject + reader.GetName(i) + "|";
}
if (!cls.isEmpty(argObject))
{
argObject = cls.getLRStr(argObject, "|", "leftr");
}
reader.Close();
connection.Close();
}
catch (Exception exception)
{
argObject = "";
this.eMessage = exception.Message;
}
return argObject;
}
public virtual string getFieldList(string argString)
{
string cmdText = argString;
string argObject = "";
try
{
OleDbConnection connection = new OleDbConnection(this.connStr);
connection.Open();
OleDbDataReader reader = new OleDbCommand(cmdText, connection).ExecuteReader();
int fieldCount = reader.FieldCount;
for (int i = 0; i < fieldCount; i++)
{
argObject = argObject + reader.GetName(i) + "|";
}
reader.Close();
connection.Close();
}
catch (Exception exception)
{
argObject = "";
this.eMessage = exception.Message;
}
return argObject;
}
public virtual object[] getDataAry(string argString)
{
this.rState = 0;
string cmdText = argString;
object[] objArray = null;
try
{
string connStr = this.connStr;
string argRoutestr = cls.getParameter(connStr, "Data Source");
string newValue = HttpContext.Current.Server.MapPath(cls.getActualRoute(argRoutestr));
OleDbConnection connection = new OleDbConnection(connStr.Replace(argRoutestr, newValue));
connection.Open();
OleDbDataReader reader = new OleDbCommand(cmdText, connection).ExecuteReader();
int fieldCount = reader.FieldCount;
object[,] objArray2 = null;
while (reader.Read())
{
objArray2 = new object[fieldCount, 2];
for (int i = 0; i < fieldCount; i++)
{
objArray2[i, 0] = reader.GetName(i);
objArray2[i, 1] = reader.GetValue(i);
}
objArray = cls.mergeAry(objArray, objArray2);
}
reader.Close();
connection.Close();
}
catch (Exception exception)
{
this.rState = 1;
objArray = null;
this.eMessage = exception.Message;
}
return objArray;
}
public virtual Dictionary<string, object>[] getDataAry(string strSQL)
{
this.rState = 0;
Dictionary<string, object>[] rsArray = null;
if ((string)strSQL != "")
{
try
{
OleDbConnection connection = new OleDbConnection(this.connStr);
connection.Open();
OleDbDataReader reader = new OleDbCommand(strSQL, connection).ExecuteReader();
Dictionary<int, object> rsList = new Dictionary<int, object>();
int fieldCount = reader.FieldCount;
int num = 0;
while (reader.Read())
{
Dictionary<string, object> rec = new Dictionary<string, object>();
for (int i = 0; i < fieldCount; i++)
{
rec.Add(reader.GetName(i), reader.GetValue(i));
}
rsList.Add(num, rec);
num ++;
}
reader.Close();
connection.Close();
rsArray = new Dictionary<string, object>[num];
foreach (var kv in rsList)
{
rsArray[kv.Key] = (Dictionary<string, object>)kv.Value;
}
}
catch (Exception exception)
{
this.rState = 1;
var errMsg = new Dictionary<string, object>();
errMsg.Add("msg", "Operate DB Error: " + exception.Message);
rsArray = new Dictionary<string, object>[] { errMsg };
this.eMessage = exception.Message;
}
}
else
{
this.rState = 999;
}
return rsArray;
}