.net+oracle 实现分页 和 菜单 (二)

最新推荐文章于 2024-09-11 07:16:42 发布
最新推荐文章于 2024-09-11 07:16:42 发布
阅读量872 收藏
点赞数
分类专栏： demo 文章标签： oracle .net dataset string exception null
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/sql_xep/article/details/5411220
版权

--用户自定义控件  用于分页datagrid(2003的控件  05后叫gridview )

chagepage.aspx页面 

[code]

 

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="changePage.ascx.cs" Inherits="changePage" %>
<div>
    <table width="100%">
        <tr>
            <td>
                当前第<asp:Label ID="lblcurrentCount" runat="server"></asp:Label>页
            </td>
            <td>
                共<asp:Label ID="lblpageCount" runat="server"></asp:Label>页
            </td>
            <td>
                第<asp:DropDownList ID="ddlnextPage" runat="server"></asp:DropDownList>页
                <asp:Button ID="btngo" runat="server"  Text=" GO " οnclick="btngo_Click"/>
            </td>
           
        </tr>
    </table>
</div>

 

[/code]

 

chagepage.aspx.cs页面 

 

[code]

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using MyApplication;

public partial class changePage : System.Web.UI.UserControl
{
    public ClickEventHandler Handler
    { get; set; }

    #region 属性
    //当前页

    public string CurrentPage
    {
        get
        {
            if (ViewState["currentPage"] == null)
            {
                return "1";
            }
            return ViewState["currentPage"].ToString();
        }
        set
        {
            ViewState["currentPage"] = value;
        }
    }
    public string PageCount
    {
        get
        {
            if (ViewState["pageCount"] == null)
            {
                return "1";
            }
            return ViewState["pageCount"].ToString();
        }
        set
        {
            ViewState["pageCount"] = value;
        }
    }
    #endregion
    public event XiaoEventHandler XiaoClick;

    protected void Page_Load(object sender, EventArgs e)
    {
        Button btnsearch = this.Page.FindControl("btnSearch") as Button;
        Handler += BindDDL;
        if (!IsPostBack)
        {
            BindDDL();
        }

    }
    public void BindDDL()
    {
        ddlnextPage.Items.Clear();
        int i = int.Parse(PageCount);
        for (int t = 1; t <= i; t++)
        {
            ddlnextPage.Items.Add(t.ToString());
        }
        lblcurrentCount.Text = this.CurrentPage;
        lblpageCount.Text = this.PageCount;
    }
    protected void btngo_Click(object sender, EventArgs e)
    {
        this.CurrentPage = ddlnextPage.SelectedItem.Text;
        lblcurrentCount.Text = this.CurrentPage;
        //lblpageCount.Text = this.PageCount;

        OnXiaoClick();

    }

    protected virtual void OnXiaoClick()
    {
        if (XiaoClick != null)
        {
            XiaoClick(int.Parse(CurrentPage));
        }
    }


}

 

 

[/code] 

因为只是个demo 所以用comm.cs 代表通用层 用 BLLlogic.cs 代表逻辑层 DALBase代表数据库访问层

 

Comm.cs页面

 

[code]

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
/// <summary>
/// Summary description for Comm
/// </summary>
namespace MyApplication
{
    public delegate void XiaoEventHandler(int currentCount);

    public delegate void ClickEventHandler();
}

public class Comm
{
    public Comm()
    {
        //
        // TODO: Add constructor logic here
        //
    }
    /// <summary>
    /// 弹出消息框
    /// </summary>
    /// <param name="page"></param>
    /// <param name="key"></param>
    /// <param name="Message"></param>
    public static void Show(System.Web.UI.Page page, string key, string Message)
    {
        string myScript = @"alert('" + Message + "');";
        if (!page.ClientScript.IsClientScriptBlockRegistered(key))
        {
            page.ClientScript.RegisterClientScriptBlock(page.GetType(), key, myScript, true);
        }
    }
    /// <summary>
    /// 判断是否为空
    /// </summary>
    /// <param name="ds"></param>
    /// <returns></returns>
    public static bool CheckDatasetISNULL(DataSet ds)
    {
        if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
        {
            return false;
        }
        return true;
    }
    public static string CheckObjectISNULL(object str)
    {
        if (str == null || str.ToString().Trim() == string.Empty)
        {
            return "";
        }
        return str.ToString().Trim();
    }
    public static string ReturnZoreWhenempty(string str)
    {
        if (str == string.Empty)
        {
            return "0";
        }
        else
        {
            return str;
        }
    }
}

 

[/code]

 

BLLlogic.cs页面

 

[code]

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Text;
using System.IO;

/// <summary>
/// Summary description for BLLLogic
/// </summary>
public class BLLLogic
{
    public BLLLogic()
    {
        //
        // TODO: Add constructor logic here
        //
    }
    /// <summary>
    ///验证用户合法性
    /// </summary>
    /// <param name="userName"></param>
    /// <param name="password"></param>
    /// <returns></returns>
    public bool CheckUserNameAndPassword(string userName, string password)
    {
        DALBase dal = new DALBase();
        string str = dal.CheckUserNameAndPassword(userName, password);
        if (str.Trim() != "")
        {
            return true;
        }
        return false;

    }
    public bool InsertUserInfo(string userName, string password)
    {
        DALBase dal = new DALBase();
        int count = dal.InsertUserInfo(userName, password);
        if (count > 0)
        {
            return true;
        }
        return false;
    }
    public DataSet GetSchemaInfo()
    {
        DataSet ds = new DALBase().GetSchemaInfo();
        return ds;
    }
    public DataSet GetTypeInfo()
    {
        DataSet ds = new DALBase().GetTypeInfo();
        return ds;
    }
    /// <summary>
    /// 检察菜单文本是否存在
    /// </summary>
    /// <param name="fileName"></param>
    /// <returns></returns>
    public bool CheckExistFile(string fileName)
    {

        return File.Exists(HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath + "//" + fileName));
    }
    public void WriteMenuJS()
    {
        string str = GetMenuInfo();
        string path = HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath);
        using (StreamWriter sw = new StreamWriter(path + "//" + "MENU_ITEMS.js"))
        {
            sw.Write(str);
        }

    }
   
    public string GetMenuInfo()
    {
        DataSet ds = new DALBase().GetMenuInfo();
        if (!Comm.CheckDatasetISNULL(ds))
        {
            StringBuilder sb = new StringBuilder(6000);
            sb.Append("var MENU_ITEMS = [");
            DataView dv = ds.Tables[0].DefaultView;
            dv.RowFilter = "nodepid=0";
            string nodeid = "";
            string nodename = "";
            string url = "";
            //i 是计数器 n是项数
            int i = 0, n = 0;         
            foreach (DataRowView dvi in dv)
            {
                n++;
            }
            foreach (DataRowView viewrow in dv)
            {
                i++;
                nodeid = Comm.CheckObjectISNULL(viewrow["nodeID"]);
                nodename = Comm.CheckObjectISNULL(viewrow["nodeName"]);
                url = Comm.CheckObjectISNULL(viewrow["urlPath"]);
                sb.Append(ConcatenateHTMLString(nodeid, nodename, url, ds, i, n));
                GetMenuChilds(Comm.CheckObjectISNULL(viewrow["nodeID"]), ds, sb);
                if (n - i == 0)
                {
                    sb.Append("]");
                }
                else
                {
                    sb.Append("],");
                }

            }

            return sb.Append(" ] ;").ToString();
        }
        else
        {
            return "";
        }

    }
    public void GetMenuChilds(string nodeid, DataSet ds, StringBuilder sb)
    {
        DataView dvTreeData = ds.Tables[0].DefaultView;
        dvTreeData.RowFilter = "nodepid=" + nodeid;
        string nid = "";
        string nodename = "";
        string url = "";
        int i = 0, n = 0;
        foreach (DataRowView dvi in dvTreeData)
        {
            n++;
        }
        foreach (DataRowView viewrow in dvTreeData)
        {
            i++;

            nid = Comm.CheckObjectISNULL(viewrow["nodeID"]);
            nodename = Comm.CheckObjectISNULL(viewrow["nodeName"]);
            url = Comm.CheckObjectISNULL(viewrow["urlPath"]);
            sb.Append(ConcatenateHTMLString(nid, nodename, url, ds, i, n));

            GetMenuChilds(Comm.CheckObjectISNULL(viewrow["nodeID"]), ds, sb);
            if (n - i == 0)
            {
                sb.Append("]");
            }
            else
            {
                sb.Append("],");
            }

        }

    }
    /// <summary>
    /// 拼js串
    /// </summary>
    /// <returns></returns>
    public string ConcatenateHTMLString(string nodeid, string nodename, string url, DataSet ds, int cn, int tn)
    {
        DataView dv = ds.Tables[0].DefaultView;
        dv.RowFilter = "nodepid=" + nodeid;
        int count = 0;
        //判断当前节点下是否还有子项
        foreach (DataRowView viewrow in dv)
        {
            count++;
            break;
        }

        if (count > 0)
        {
            if (url == string.Empty)
            {
                return " [ '" + nodename + "'" + "," + "null " + "," + "null" + ",";
            }
            else
            {
                return " [ '" + nodename + "'" + "," + "'" + url + "'" + "," + "null" + ",";
            }
        }
        else
        {
            if (url == string.Empty)
            {
                return " [ '" + nodename + "'" + "," + "null  ";
            }
            else
            {
                return " [ '" + nodename + "'" + "," + "'" + url +"'";
            }
        }
    }
    /// <summary>
    /// 获取用户信息
    /// </summary>
    /// <param name="currPage">                 当前页数</param>
    /// <param name="count">                       每页显示页数</param>
    /// <param name="userSchema">            要查询的用户名称</param>
    /// <param name="userType">                 要查询的用户类型</param>
    /// <param name="objectName">             要查询的对像名称</param>
    /// <returns>                                             获取用户信息</returns>
    public DataSet GetUserOjbectSchemaInfo(int currPage, int count, string userSchema, string userType, string objectName)
    {
        return new DALBase().GetUserOjbectSchemaInfo(currPage,count,userSchema,userType,objectName);
    }
}

 

[/code]

 

DALBase.cs页面

 

[code]

 

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OracleClient;
using System.Web;
using System.Configuration;


/// <summary>
/// Summary description for DALBase
/// </summary>
public class DALBase
{
   

 public DALBase()
 {
  //
  // TODO: Add constructor logic here
  //
 }
    /// <summary>
    /// 验证用户合法性
    /// </summary>
    /// <param name="userName"></param>
    /// <param name="password"></param>
    /// <returns></returns>
    public string CheckUserNameAndPassword(string userName, string password)
    {
        string connstr = System.Configuration.ConfigurationManager.AppSettings["oracleConnection"];
        OracleConnection conn = new OracleConnection(connstr);
        OracleCommand cmd = new OracleCommand("P_CheckUser", conn);
        cmd.CommandType = System.Data.CommandType.StoredProcedure;

        #region 为cmd参数
        OracleParameter para = new OracleParameter();
        para.ParameterName="UserName";
        para.DbType = System.Data.DbType.String;
        para.Direction = System.Data.ParameterDirection.InputOutput;
        para.Value = userName;
        cmd.Parameters.Add(para);
        cmd.Parameters.Add("Password", System.Data.DbType.String).Value = password;
        #endregion
        try
        {
            userName = "";
            conn.Open();
            cmd.ExecuteScalar();

            userName = cmd.Parameters[0].Value.ToString();
        }
        catch(Exception e)
        {
            throw e;
        }
        finally
        {
            if (conn != null)
            {
                conn.Close();
            }
        }
        return userName;
    }

    /// <summary>
    /// 新加用户
    /// </summary>
    /// <param name="userName"></param>
    /// <param name="password"></param>
    /// <returns></returns>
    public int InsertUserInfo(string userName, string password)
    {
        string connstr = System.Configuration.ConfigurationManager.AppSettings["oracleConnection"];
        OracleConnection conn = new OracleConnection(connstr);
        OracleCommand cmd = new OracleCommand("P_InsertUser", conn);
        cmd.CommandType = System.Data.CommandType.StoredProcedure;

        #region 为cmd参数
        cmd.Parameters.Add("userName", System.Data.DbType.String).Value = userName;
        cmd.Parameters.Add("Password", System.Data.DbType.String).Value = password;
        #endregion
        int count = 0;
        try
        {
            conn.Open();
            count = Convert.ToInt32( cmd.ExecuteOracleScalar());
        }
        catch (Exception e)
        {
            throw e;
        }
        finally
        {
            if (conn != null)
            {
                conn.Close();
            }
        }
        return count>0?1:0;
    }
    public DataSet GetSchemaInfo()
    {
        DataSet ds = new DataSet();
        string connstr = System.Configuration.ConfigurationManager.AppSettings["oracleConnection"];
        OracleConnection conn = new OracleConnection(connstr);
        OracleCommand cmd = new OracleCommand("P_SelectSchema", conn);
        cmd.CommandType = System.Data.CommandType.StoredProcedure;

        cmd.Parameters.Add("mycur", OracleType.Cursor).Direction = ParameterDirection.Output;

        OracleDataAdapter oda = new OracleDataAdapter(cmd);
        try
        {
            oda.Fill(ds);

        }
        catch (Exception e)
        {
            throw e;
        }
        finally
        {
            if (conn != null)
            {
                conn.Close();
            }
        }
        return ds;
    }
    public DataSet GetTypeInfo()
    {
        DataSet ds = new DataSet();
        string connstr = System.Configuration.ConfigurationManager.AppSettings["oracleConnection"];
        OracleConnection conn = new OracleConnection(connstr);
        OracleCommand cmd = new OracleCommand("P_SelectType", conn);

        cmd.Parameters.Add("mycur", OracleType.Cursor).Direction=ParameterDirection.Output;

        cmd.CommandType = System.Data.CommandType.StoredProcedure;
        OracleDataAdapter oda = new OracleDataAdapter(cmd);
        try
        {
            oda.Fill(ds);

        }
        catch (Exception e)
        {
            throw e;
        }
        finally
        {
            if (conn != null)
            {
                conn.Close();
            }
        }
        return ds;
    }
    /// <summary>
    /// 获取一级菜单信息
    /// </summary>
    /// <returns></returns>
    public DataSet GetMenuInfo()
    {
        DataSet ds = new DataSet();
        string connstr = System.Configuration.ConfigurationManager.AppSettings["oracleConnection"];
        OracleConnection conn = new OracleConnection(connstr);
        OracleCommand cmd = new OracleCommand("P_SelectMenuInfo", conn);

        cmd.Parameters.Add("mycur", OracleType.Cursor).Direction = ParameterDirection.Output;

        cmd.CommandType = System.Data.CommandType.StoredProcedure;
        OracleDataAdapter oda = new OracleDataAdapter(cmd);
        try
        {
            oda.Fill(ds);

        }
        catch (Exception e)
        {
            throw e;
        }
        finally
        {
            if (conn != null)
            {
                conn.Close();
            }
        }
        return ds;
    }
     /// <summary>
    /// 获取用户信息
    /// </summary>
    /// <param name="currPage">                 当前页数</param>
    /// <param name="count">                       每页显示页数</param>
    /// <param name="userSchema">            要查询的用户名称</param>
    /// <param name="userType">                 要查询的用户类型</param>
    /// <param name="objectName">             要查询的对像名称</param>
    /// <returns>                                             获取用户信息</returns>
    public DataSet GetUserOjbectSchemaInfo(int currPage, int count, string userSchema, string userType, string objectName)
    {
        DataSet ds= new DataSet();
        string connString = ConfigurationManager.AppSettings["oracleConnection"];
        OracleConnection conn = new OracleConnection(connString);
        OracleCommand cmd = new OracleCommand("P_SelectUserObjectSchemaInfo", conn);
        #region 存储过程参数
        cmd.Parameters.Add("currentPage", DbType.Int32).Value = currPage;
        cmd.Parameters.Add("recount", DbType.Int32).Value = count;
        cmd.Parameters.Add("userSchema", DbType.String).Value = userSchema;
        cmd.Parameters.Add("userType", DbType.String).Value = userType;
        cmd.Parameters.Add("objectName", DbType.String).Value = objectName;
        cmd.Parameters.Add("mycur",OracleType.Cursor).Direction = ParameterDirection.Output;
        #endregion
        cmd.CommandType = CommandType.StoredProcedure;

        OracleDataAdapter oda = new OracleDataAdapter(cmd);
        try
        {
            oda.Fill(ds);

        }
        catch (Exception e)
        {
            throw e;
        }
        finally
        {
            if (conn != null)
            {
                conn.Close();
            }
        }
        return ds;
    }
}

 

[/code]

sql_xeppp
关注
专栏目录
.NET+Oracle 分页
dianjin3567的博客
04-02 256
http://www.cnblogs.com/Jusoc/archive/2011/08/28/2156530.html#commentform 1、在oracle的sqlplus或其他工具中运行一下pl/sql块建立存储过程 ------------------------------------------------------------ --分页存储过...
Oracle 三种分页方法
热门推荐
logqq的专栏
03-14 2万+
使用ROW_NUMBER() OVER()进行分页查询的优点是灵活性高，可以实现各种不同的分页方式，缺点是语法较为复杂。上述查询语句的意思是查询my_table表中的前30条记录，然后在这30条记录中取出第20到第30条记录作为结果返回。使用ROWNUM进行分页查询的优点是简单易懂，缺点是在查询大量数据时性能较差。Oracle的三层分页指的是在进行分页查询时，使用三种不同的方式来实现分页效果，分别是使用ROWNUM、使用OFFSET和FETCH、使用ROW_NUMBER() OVER()
Oracle（三）oracle的分页查询
w_t_y_y的博客
08-23 4632
在oracle中,rownum关键字可以将查询出来的元组编号，如现有good表： 则：select gno,gname,price,rownum from good where rownum 但是如果根据rownum来筛选如：select gno,gname,price,rownum from good where rownum>=2 and rownum=2，继续往后，把整个
.net+oracle 实现分页 和 菜单 (三)
sql_xep的专栏
03-24 543
说明 得为xep分配相应的访问表的权限sql> conn /as sysdbasql> grant select on dba_objects to xep;sql>  接下来是最最最重要的 存储过程        --验证用户       create or replace procedure  p_checkuser (UserName in out varchar
.net+oracle 实现分页 和 菜单
sql_xep的专栏
03-24 2859
这个demo实现了两个功能     下拉菜单 和 gridview分页运行环境 visual studio2008 oracle9i 这个网站下载了几种菜单样式  http://www.javascript-menu.com/docs/运行了一下   感觉挺不错的     分析菜单结构 主要是页面new一个对像调用两个js文件 生成菜单我使用的是一个website（站点结构图可以去
基于Java+Oracle实现的订餐管理系统
毕业作品网站
11-03 294
B/S（Browser/Server）：结构即浏览器和服务器结构。它是随着Internet技术的兴起，对C/S结构的一种变化或者改进的结构。JSP(Java Server Pages)：是由Sun Microsystems公司倡导、许多公司参与一起建立的一种动态网页技术标准。JSP技术有点类似ASP技术，它是在传统的网页HTML文件(.htm,.html)中插入Java程序段(Scriptlet)和JSP标记(tag)，从而形成JSP文件(*.jsp)。
asp.net mvc + dapper + oracle + autofac + repository + adminlte3.0
caifox的博客
09-16 386
本篇使用asp.net mvc + dapper + oracle + autofac + repository + adminlte3.0这些方法和技术来开发一个简单的web程序。
Vue+ElementUI+SpringMVC实现分页
weixin_33701251的博客
08-30 323
2019独角兽企业重金招聘Python工程师标准>>> ...
extjs oracle分页---Json转换
05-26
标题“ExtJS Oracle分页---Json转换”涉及的是在Web应用程序开发中，使用ExtJS框架与Oracle数据库进行分页数据交互，并通过Json格式进行数据转换的技术。以下是对这个主题的详细解释： ExtJS是一个强大的JavaScript...
水晶报表实例——VB.NET2008实现
07-01
4. **绑定数据**：通过“数据”菜单，设置报表的数据源和字段绑定，确保报表能够正确获取和显示数据库中的数据。 5. **运行和测试**：编译并运行VB.NET应用程序，查看水晶报表是否按照预期显示数据。如果需要，可以...
FastReport.Net(v2019.2.6.0).zip
08-25
在实际开发中，FastReport.Net还可以与其他数据库系统（如SQL Server、Oracle、MySQL等）无缝连接，获取并处理数据。它支持数据绑定，能够动态从数据库中提取数据填充到报表中，实现数据驱动的报表生成。同时，...
ASP.NET文章集锦
08-27
8. AJAX和jQuery：ASP.NET提供了AJAX技术，如UpdatePanel和ScriptManager，用于实现部分页面更新，提升用户体验。结合jQuery库，开发者可以更轻松地进行DOM操作、事件处理和动画效果，使网页更加动态和交互性。 9. ...
Spring Boot + PageHelper 实现分页，总结得很全了！
WantFlyDaCheng的博客
10-28 360
本文来自作者 "臣不贰" 投稿。欢迎广大读者投稿，让更多人看到你的文章，>>>投稿请点击Java技术栈公众号投稿菜单。CSDN：https://blo...
sqlldr　direct参数小测试
sql_xep的专栏
11-29 4674
首先建一表  CREATE TABLE XEP.TEST   (    ID NUMBER(*,0),　　                                            --主键        NAME VARCHAR2(16) NOT NULL ENABLE,　--非空        AGE NUMBER(3,0),
将历史记录移到历史表中
sql_xep的专栏
12-29 1677
现在表中的数据量越来越大，需要将历史记录移到历史表中。以下过程可以实现此功能。如果觉得有问题请联系我。 --用一配制表存需要转移数据的大表名称 --每次都查表名与tab_name相匹配且is_used=1的　说明是当前的历史表 create table config_table(configID int,             --ID
简要介绍联合索引
weixin_46028606的博客
09-10 517
联合索引
Oracle EBS AP预付款行分配行剩余预付金额数据修复
最新发布
陈显平的专栏-Oracle EBS
09-11 172
英文：You may not cancel this prepayment. See the Oracle Payables User’s Guide or online help.英文：APP-SQLAP-10117: You cannot delete a prepayment that has been applied to an invoice(s).中文：APP-SQLAP-10117: 您无法删除已核销至发票的预付款。请撤消所有预付款核销，撤消已付预付款的付款单据，然后删除预付款。
mybatisplus+oracle实现分页
12-14
以下是使用Mybatis Plus和Oracle实现分页的示例代码： 1.在pom.xml文件中添加Mybatis Plus的依赖： ```xml <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter <version>3.4.2 ``` 2....
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值