private int NoExit(string no)
{
string strSQL = String.Format("Select count(*) From T_namesize where no='{0}'", no);
int m = 0;
OracleCommand command = null;
command = new OracleCommand();
conn = new OracleConnection(ConnectionString);
conn.Open();
command.Connection = conn;
command.CommandText = strSQL;
object obj = command.ExecuteOracleScalar();
if (obj.ToString() != "Null")
{
m = Convert.ToInt32(obj.ToString());
conn.Close();
return m;
}
else
{
conn.Close();
return 0;
}
}
{
string strSQL = String.Format("Select count(*) From T_namesize where no='{0}'", no);
int m = 0;
OracleCommand command = null;
command = new OracleCommand();
conn = new OracleConnection(ConnectionString);
conn.Open();
command.Connection = conn;
command.CommandText = strSQL;
object obj = command.ExecuteOracleScalar();
if (obj.ToString() != "Null")
{
m = Convert.ToInt32(obj.ToString());
conn.Close();
return m;
}
else
{
conn.Close();
return 0;
}
}