/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from t_agent_store");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@ID", MySqlDbType.Int32)
};
parameters[0].Value = ID;
return(DbHelperMySql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 查询是否存在该记录
/// </summary>
public bool Exists(string name)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from " + databaseprefix + "navigation");
strSql.Append(" where name=@name ");
MySqlParameter[] parameters =
{
new MySqlParameter("@name", MySqlDbType.VarChar, 50)
};
parameters[0].Value = name;
return(DbHelperMySql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from dt_manager_role");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32)
};
parameters[0].Value = id;
return(DbHelperMySql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from " + databaseprefix + "navigation");
strSql.Append(" where id=@id");
MySqlParameter[] parameters =
{
new MySqlParameter("@id", MySqlDbType.Int32, 4)
};
parameters[0].Value = id;
return(DbHelperMySql.Exists(strSql.ToString(), parameters));
}
/// <summary>
/// 查询用户名是否存在
/// </summary>
public bool Exists(string user_name)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from " + databaseprefix + "manager");
strSql.Append(" where user_name=@user_name ");
MySqlParameter[] parameters =
{
new MySqlParameter("@user_name", MySqlDbType.VarChar, 100)
};
parameters[0].Value = user_name;
return(DbHelperMySql.Exists(strSql.ToString(), parameters));
}
