public static void ExecVoid(string sqlstr, string accountName)
{
DataSql agent = new DataSql(accountName);
try
{
SqlDataItem item = new SqlDataItem();
item.CommandText = sqlstr;
agent.ExeSql_void(item);
agent.Close();
}
catch (Exception ee)
{
agent.Close();
throw ee;
}
}
public static bool testConn(string accountName)
{
try
{
DataSql agent = new DataSql(accountName);
agent.Open();
agent.Close();
return(true);
}
catch
{
return(false);
}
}
public static bool ExecSQLs(SqlDataItemArray items, string accountName)
{
try
{
DataSql agent = new DataSql(accountName);
bool flag = agent.ExeSqls_bool(items);
agent.Close();
return(flag);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable getTable(SqlDataItem item, string accountName)
{
try
{
DataSql agent = new DataSql(accountName);
DataTable dt = agent.ExeSql_DT(item);
agent.Close();
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable getTable(string SQLstr, string accountName)
{
try
{
SqlDataItem item = new SqlDataItem();
item.CommandText = SQLstr;
DataSql agent = new DataSql(accountName);
DataTable dt = agent.ExeSql_DT(item);
agent.Close();
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
