62,046
社区成员
发帖
与我相关
我的任务
分享
if (bl0200.Exists(ENNMCD) == false)
{
..............................................
}
else
{
Response.Write("<script languge='javascript'>alert('该水库已存在');</script>");
}
public bool Exists(string ENNMCD)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select count(1) from SS_PROJECT_0200_RS");
strSql.Append(" where ENNMCD=:ENNMCD ");
OracleParameter[] parameters = {
new OracleParameter(":ENNMCD", OracleType.VarChar,18) };
parameters[0].Value = ENNMCD;
return DbHelperOra.Exists(strSql.ToString(),parameters);
}
public static bool Exists(string strSql, params OracleParameter[] cmdParms)
{
object obj = GetSingle(strSql, cmdParms);
//StrongSoftManage.Common.DebugLogHp.Write(obj.ToString() + "-----");
int cmdresult;
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = 0;
}
else
{
cmdresult = 0;
try
{
cmdresult = int.Parse(obj.ToString());
StrongSoftManage.Common.DebugLogHp.Write(obj.ToString() + "-----" );
}
catch (Exception EX)
{
StrongSoftManage.Common.DebugLogHp.Write(obj.ToString() + "-----" + EX.Message);
}
}
if (cmdresult == 0)
{
return false;
}
else
{
return true;
}
}
public static object GetSingle(string SQLString, params OracleParameter[] cmdParms)
{
using (OracleConnection connection = new OracleConnection(connectionString))
{
using (OracleCommand cmd = new OracleCommand())
{
try
{
PrepareCommand(cmd, connection, null, SQLString, cmdParms);
object obj = cmd.ExecuteScalar();
cmd.Parameters.Clear();
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
return null;
}
else
{
return obj;
}
}
catch (System.Data.OracleClient.OracleException e)
{
throw new Exception(e.Message);
}
}
}
}