/*
* public static int ExecuteCommand(string[] tableNames, string sql, SqlConnection conn)
* {
* int nRet = 1;
* if (Program.EnableRemoting)
* {
* nRet = mDataTableProxy.ExecuteCommand(tableNames, sql);
* }
* else
* {
* nRet = ExecuteCommand(sql, conn);
* }
* return nRet;
* }
*/
public static object ExecuteScalar(string tableName, string sql, SqlConnection conn, bool modify)
{
object result = null;
if (Program.EnableRemoting)
{
if (mDataTableProxy.ExistRemotingTable(tableName))
{
result = mDataTableProxy.ExecuteScalar(tableName, sql, modify);
}
else
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
result = cmd.ExecuteScalar();
}
}
else
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
result = cmd.ExecuteScalar();
}
return(result);
}
