dataprovider.cs

其主要的功能就是,进行后台管理模块整合. 1)其可以支持多个应用,多个模块的权限管理. 2)支持Access和MsSql200/2005. 3)采用角色来进行权限的授权,每个用户可以属于多个角色

        public abstract ArrayList sys_ModuleList(QueryParam qp, out int RecordCount);

        /// <summary>
        /// 将记录集转为sys_ModuleTable实体类
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <returns>sys_ModuleTable</returns>
        protected object Populatesys_Module(IDataReader dr)
        {
            sys_ModuleTable nc = new sys_ModuleTable();

            if (!Convert.IsDBNull(dr["ModuleID"])) nc.ModuleID = Convert.ToInt32(dr["ModuleID"]); // 功能模块ID号
            if (!Convert.IsDBNull(dr["M_ApplicationID"])) nc.M_ApplicationID = Convert.ToInt32(dr["M_ApplicationID"]); // 所属应用程序ID
            if (!Convert.IsDBNull(dr["M_ParentID"])) nc.M_ParentID = Convert.ToInt32(dr["M_ParentID"]); // 所属父级模块ID与ModuleID关联,0为顶级
            if (!Convert.IsDBNull(dr["M_PageCode"])) nc.M_PageCode = Convert.ToString(dr["M_PageCode"]).Trim(); // 模块编码Parent为0,则为S00(xx),否则为S00M00(xx)
            if (!Convert.IsDBNull(dr["M_CName"])) nc.M_CName = Convert.ToString(dr["M_CName"]).Trim(); // 模块/栏目名称当ParentID为0为模块名称
            if (!Convert.IsDBNull(dr["M_Directory"])) nc.M_Directory = Convert.ToString(dr["M_Directory"]).Trim(); // 模块/栏目目录名
            if (!Convert.IsDBNull(dr["M_OrderLevel"])) nc.M_OrderLevel = Convert.ToString(dr["M_OrderLevel"]).Trim(); // 当前所在排序级别支持双层99级菜单
            if (!Convert.IsDBNull(dr["M_IsSystem"])) nc.M_IsSystem = Convert.ToInt32(dr["M_IsSystem"]); // 是否为系统模块1:是0:否如为系统则无法修改
            if (!Convert.IsDBNull(dr["M_Close"])) nc.M_Close = Convert.ToInt32(dr["M_Close"]); // 是否关闭1:是0:否
            return nc;
        }
        #endregion
        #region "sys_RoleApplication - DataProvider"
        /// <summary>
        /// 新增/删除/修改 sys_RoleApplication
        /// </summary>
        /// <param name="fam">sys_RoleApplicationTable实体类</param>
        /// <returns>返回0操正常</returns>
        public abstract int sys_RoleApplicationInsertUpdate(sys_RoleApplicationTable fam);

        /// <summary>
        /// 返回sys_RoleApplicationTable实体类的ArrayList对象
        /// </summary>
        /// <param name="qp">查询类</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>sys_RoleApplicationTable实体类的ArrayList对象</returns>
        public abstract ArrayList sys_RoleApplicationList(QueryParam qp, out int RecordCount);

        /// <summary>
        /// 将记录集转为sys_RoleApplicationTable实体类
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <returns>sys_RoleApplicationTable</returns>
        protected object Populatesys_RoleApplication(IDataReader dr)
        {
            sys_RoleApplicationTable nc = new sys_RoleApplicationTable();

            if (!Convert.IsDBNull(dr["A_RoleID"])) nc.A_RoleID = Convert.ToInt32(dr["A_RoleID"]); // 角色ID与sys_Roles中RoleID相关
            if (!Convert.IsDBNull(dr["A_ApplicationID"])) nc.A_ApplicationID = Convert.ToInt32(dr["A_ApplicationID"]); // 应用ID与sys_Applications中Appl
            return nc;
        }
        #endregion

        #region "sys_RolePermission - DataProvider"
        /// <summary>
        /// 新增/删除/修改 sys_RolePermission
        /// </summary>
        /// <param name="fam">sys_RolePermissionTable实体类</param>
        /// <returns>返回0操正常</returns>
        public abstract int sys_RolePermissionInsertUpdate(sys_RolePermissionTable fam);

        /// <summary>
        /// 返回sys_RolePermissionTable实体类的ArrayList对象
        /// </summary>
        /// <param name="qp">查询类</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>sys_RolePermissionTable实体类的ArrayList对象</returns>
        public abstract ArrayList sys_RolePermissionList(QueryParam qp, out int RecordCount);

        /// <summary>
        /// 将记录集转为sys_RolePermissionTable实体类
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <returns>sys_RolePermissionTable</returns>
        protected object Populatesys_RolePermission(IDataReader dr)
        {
            sys_RolePermissionTable nc = new sys_RolePermissionTable();

            if (!Convert.IsDBNull(dr["PermissionID"])) nc.PermissionID = Convert.ToInt32(dr["PermissionID"]); // 角色应用权限自动ID
            if (!Convert.IsDBNull(dr["P_RoleID"])) nc.P_RoleID = Convert.ToInt32(dr["P_RoleID"]); // 角色ID与sys_Roles表中RoleID相
            if (!Convert.IsDBNull(dr["P_ApplicationID"])) nc.P_ApplicationID = Convert.ToInt32(dr["P_ApplicationID"]); // 角色所属应用ID与sys_Applicatio
            if (!Convert.IsDBNull(dr["P_PageCode"])) nc.P_PageCode = Convert.ToString(dr["P_PageCode"]).Trim(); // 角色应用中页面权限代码
            if (!Convert.IsDBNull(dr["P_Value"])) nc.P_Value = Convert.ToInt32(dr["P_Value"]); // 权限值
            return nc;
        }
        #endregion

        #region "sys_SystemInfo - DataProvider"
        /// <summary>
        /// 新增/删除/修改 sys_SystemInfo
        /// </summary>
        /// <param name="fam">sys_SystemInfoTable实体类</param>
        /// <returns>返回0操正常</returns>
        public abstract int sys_SystemInfoInsertUpdate(sys_SystemInfoTable fam);

        /// <summary>
        /// 返回sys_SystemInfoTable实体类的ArrayList对象
        /// </summary>
        /// <param name="qp">查询类</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>sys_SystemInfoTable实体类的ArrayList对象</returns>
        public abstract ArrayList sys_SystemInfoList(QueryParam qp, out int RecordCount);

        /// <summary>
        /// 将记录集转为sys_SystemInfoTable实体类
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <returns>sys_SystemInfoTable</returns>
        protected object Populatesys_SystemInfo(IDataReader dr)
        {
            sys_SystemInfoTable nc = new sys_SystemInfoTable();

            if (!Convert.IsDBNull(dr["SystemID"])) nc.SystemID = Convert.ToInt32(dr["SystemID"]); // 自动ID
            if (!Convert.IsDBNull(dr["S_Name"])) nc.S_Name = Convert.ToString(dr["S_Name"]).Trim(); // 系统名称
            if (!Convert.IsDBNull(dr["S_Version"])) nc.S_Version = Convert.ToString(dr["S_Version"]).Trim(); // 版本号
            if (!Convert.IsDBNull(dr["S_Licensed"])) nc.S_Licensed = Convert.ToString(dr["S_Licensed"]).Trim(); // 序列号
            if (!Convert.IsDBNull(dr["S_SystemConfigData"])) nc.S_SystemConfigData = FrameSystemInfo.Deserialize_sys_ConfigDataTable((byte[])dr["S_SystemConfigData"]); // 系统配置信息
            if (nc.S_SystemConfigData.C_UploadSizeKb == 0)
                nc.S_SystemConfigData.C_UploadSizeKb = 512;
            if (nc.S_SystemConfigData.C_LoginErrorDisableMinute == 0)
                nc.S_SystemConfigData.C_LoginErrorDisableMinute = 30;
            if (nc.S_SystemConfigData.C_LoginErrorMaxNum == 0)
                nc.S_SystemConfigData.C_LoginErrorMaxNum = 5;
            return nc;
        }
        #endregion

        #region "sys_Online - CommonDataProvider"
        /// <summary>
        /// 新增/删除/修改 sys_Online
        /// </summary>
        /// <param name="fam">sys_OnlineTable实体类</param>
        /// <returns>返回0操正常</returns>
        public abstract int sys_OnlineInsertUpdate(sys_OnlineTable fam);

        /// <summary>
        /// 返回sys_OnlineTable实体类的ArrayList对象
        /// </summary>
        /// <param name="qp">查询类</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>sys_OnlineTable实体类的ArrayList对象</returns>
        public abstract ArrayList sys_OnlineList(QueryParam qp, out int RecordCount);

        /// <summary>
        /// 将记录集转为sys_OnlineTable实体类
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <returns>sys_OnlineTable</returns>
        protected object Populatesys_Online(IDataReader dr)
        {
            sys_OnlineTable nc = new sys_OnlineTable();

            if (!Convert.IsDBNull(dr["OnlineID"])) nc.OnlineID = Convert.ToInt32(dr["OnlineID"]); // 自动ID
            if (!Convert.IsDBNull(dr["O_SessionID"])) nc.O_SessionID = Convert.ToString(dr["O_SessionID"]).Trim(); // 用户SessionID
            if (!Convert.IsDBNull(dr["O_UserName"])) nc.O_UserName = Convert.ToString(dr["O_UserName"]).Trim(); // 用户名
            if (!Convert.IsDBNull(dr["O_Ip"])) nc.O_Ip = Convert.ToString(dr["O_Ip"]).Trim(); // 用户IP地址
            if (!Convert.IsDBNull(dr["O_LoginTime"])) nc.O_LoginTime = Convert.ToDateTime(dr["O_LoginTime"]); // 登陆时间
            if (!Convert.IsDBNull(dr["O_LastTime"])) nc.O_LastTime = Convert.ToDateTime(dr["O_LastTime"]); // 最后访问时间
            if (!Convert.IsDBNull(dr["O_LastUrl"])) nc.O_LastUrl = Convert.ToString(dr["O_LastUrl"]).Trim(); // 最后请求网站
            return nc;
        }
        #endregion


                
        #region "获取表中字段值"
        /// <summary>
        /// 获取表中字段值
        /// </summary>
        /// <param name="table_name">表名</param>
        /// <param name="table_fileds">字段</param>
        /// <param name="where_fileds">查询条件字段</param>
        /// <param name="where_value">查询值</param>
        /// <returns></returns>
        public abstract string get_table_fileds(string table_name, string table_fileds, string where_fileds, string where_value);
        #endregion

        #region "列新表中字段值"
        /// <summary>
        /// 列新表中字段值
        /// </summary>
        /// <param name="Table">表名</param>
        /// <param name="Table_FiledsValue">需要列新值(不用带Set)</param>
        /// <param name="Wheres">更新条件(需带Where)</param>
        /// <returns></returns>
        public abstract int Update_Table_Fileds(string Table, string Table_FiledsValue, string Wheres);
        #endregion
    }
}