public static System.Xml.XmlReader GetXmlReader(String cnName, string sSql)
{
SqlBase db = NewDB(cnName);
db.Connect();
if (!db.IsConnected)
{
return(null);
}
System.Xml.XmlReader xr = db.GetXmlReader(sSql);
db.Close();
return(xr);
}
public static DbResult GetXDataTable_R(String cnName, string sSql)
{
SqlBase db = NewDB(cnName);
db.Connect();
if (!db.IsConnected)
{
return(new DbResult(db));
}
DbResult dr = db.GetXDataTable_R(sSql);
db.Close();
return(dr);
}
public static XDataTable GetXDataTable(String cnName, string sSql)
{
SqlBase db = NewDB(cnName);
db.Connect();
if (!db.IsConnected)
{
return(null);
}
XDataTable xdt = db.GetXDataTable(sSql);
db.Close();
return(xdt);
}
public static DataSet GetDataSet(String cnName, string sSql)
{
SqlBase db = NewDB(cnName);
db.Connect();
if (!db.IsConnected)
{
return(null);
}
DataSet ds = db.GetDataSet(sSql);
db.Close();
return(ds);
}
public static DbValues GetDatas(String cnName, string sSql)
{
SqlBase db = NewDB(cnName);
db.Connect();
if (!db.IsConnected)
{
return(null);
}
DbValues dvs = db.GetDatas(sSql);
db.Close();
return(dvs);
}
public static bool IsHasRow(String cnName, string sSql)
{
SqlBase db = NewDB(cnName);
db.Connect();
if (!db.IsConnected)
{
return(false);
}
bool blnR = db.IsHasRow(sSql);
db.Close();
return(blnR);
}
public static object GetDataReader(String cnName, string sSql)
{
SqlBase db = NewDB(cnName);
db.Connect();
if (!db.IsConnected)
{
return(-1);
}
object oR = db.GetDataReader(sSql);
db.Close();
return(oR);
}
public static object ExecuteGeneral(String cnName, CommandType cmdType, string sSql, object cmdParameters, CommandMode cmdMode)
{
SqlBase db = NewDB(cnName);
db.Connect();
if (!db.IsConnected)
{
return(null);
}
object oR = db.ExecuteGeneral(cmdType, sSql, cmdParameters, cmdMode);
db.Close();
return(oR);
}
public static int Execute(String cnName, string sSql)
{
SqlBase db = NewDB(cnName);
db.Connect();
if (!db.IsConnected)
{
return(-1);
}
int iR = db.Execute(sSql);
db.Close();
return(iR);
}
public static DbResult ExecuteGeneral_R(String cnName, CommandType cmdType, string sSql, object cmdParameters, CommandMode cmdMode)
{
SqlBase db = NewDB(cnName);
db.Connect();
object oR = null;
if (db.IsConnected)
{
oR = db.ExecuteGeneral(cmdType, sSql, cmdParameters, cmdMode);
}
DbResult dr = new DbResult(db);
db.Close();
return(dr);
}
public int DeleteFiles(String cnName, string sSql)
{
SqlBase db = NewDB(cnName);
db.Connect();
if (!db.IsConnected)
{
return(-1);
}
if (ULCode.QDA.Debug.IS_FORM_CLIENT)
{
return(-1);
}
int iR = db.DeleteFiles(sSql);
db.Close();
return(iR);
}
public static DbResult Execute_R(String cnName, string sSql)
{
SqlBase db = NewDB(cnName);
db.Connect();
int iR = 0;
if (!db.IsConnected)
{
iR = -1;
}
else
{
iR = db.Execute(sSql);
}
DbResult dr = new DbResult(db);
dr.ReturnValue = iR;
db.Close();
return(dr);
}