dataprovider.cs

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

        }
        #endregion

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

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

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

            if (!Convert.IsDBNull(dr["ApplicationID"])) nc.ApplicationID = Convert.ToInt32(dr["ApplicationID"]); // 自动ID 1:为系统管理应用
            if (!Convert.IsDBNull(dr["A_AppName"])) nc.A_AppName = Convert.ToString(dr["A_AppName"]).Trim(); // 应用名称
            if (!Convert.IsDBNull(dr["A_AppDescription"])) nc.A_AppDescription = Convert.ToString(dr["A_AppDescription"]).Trim(); // 应用介绍
            if (!Convert.IsDBNull(dr["A_AppUrl"])) nc.A_AppUrl = Convert.ToString(dr["A_AppUrl"]).Trim(); // 应用Url地址
            return nc;
        }
        #endregion

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

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

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

            if (!Convert.IsDBNull(dr["EventID"])) nc.EventID = Convert.ToInt32(dr["EventID"]); // 事件ID号
            if (!Convert.IsDBNull(dr["E_U_LoginName"])) nc.E_U_LoginName = Convert.ToString(dr["E_U_LoginName"]).Trim(); // 用户名
            if (!Convert.IsDBNull(dr["E_UserID"])) nc.E_UserID = Convert.ToInt32(dr["E_UserID"]); // 操作时用户ID与sys_Users中UserID
            if (!Convert.IsDBNull(dr["E_DateTime"])) nc.E_DateTime = Convert.ToDateTime(dr["E_DateTime"]); // 事件发生的日期及时间
            if (!Convert.IsDBNull(dr["E_ApplicationID"])) nc.E_ApplicationID = Convert.ToInt32(dr["E_ApplicationID"]); // 所属应用程序ID与sys_Applicatio
            if (!Convert.IsDBNull(dr["E_A_AppName"])) nc.E_A_AppName = Convert.ToString(dr["E_A_AppName"]).Trim(); // 所属应用名称
            if (!Convert.IsDBNull(dr["E_M_Name"])) nc.E_M_Name = Convert.ToString(dr["E_M_Name"]).Trim(); // PageCode模块名称与sys_Module相同
            if (!Convert.IsDBNull(dr["E_M_PageCode"])) nc.E_M_PageCode = Convert.ToString(dr["E_M_PageCode"]).Trim(); // 发生事件时模块名称
            if (!Convert.IsDBNull(dr["E_From"])) nc.E_From = Convert.ToString(dr["E_From"]).Trim(); // 来源
            if (!Convert.IsDBNull(dr["E_Type"])) nc.E_Type = Convert.ToInt32(dr["E_Type"]); // 日记类型,1:操作日记2:安全日志3
            if (!Convert.IsDBNull(dr["E_IP"])) nc.E_IP = Convert.ToString(dr["E_IP"]).Trim(); // 客户端IP地址
            if (!Convert.IsDBNull(dr["E_Record"])) nc.E_Record = Convert.ToString(dr["E_Record"]).Trim(); // 详细描述
            return nc;
        }
        #endregion

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

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

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

            if (!Convert.IsDBNull(dr["FieldID"])) nc.FieldID = Convert.ToInt32(dr["FieldID"]); // 应用字段ID号
            if (!Convert.IsDBNull(dr["F_Key"])) nc.F_Key = Convert.ToString(dr["F_Key"]).Trim(); // 应用字段关键字
            if (!Convert.IsDBNull(dr["F_CName"])) nc.F_CName = Convert.ToString(dr["F_CName"]).Trim(); // 应用字段中文说明
            if (!Convert.IsDBNull(dr["F_Remark"])) nc.F_Remark = Convert.ToString(dr["F_Remark"]).Trim(); // 描述说明
            return nc;
        }
        #endregion

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

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

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

            if (!Convert.IsDBNull(dr["ValueID"])) nc.ValueID = Convert.ToInt32(dr["ValueID"]); // 索引ID号
            if (!Convert.IsDBNull(dr["V_F_Key"])) nc.V_F_Key = Convert.ToString(dr["V_F_Key"]).Trim(); // 与sys_Field表中F_Key字段关联
            if (!Convert.IsDBNull(dr["V_Text"])) nc.V_Text = Convert.ToString(dr["V_Text"]).Trim(); // 中文说明
            if (!Convert.IsDBNull(dr["V_ShowOrder"])) nc.V_ShowOrder = Convert.ToInt32(dr["V_ShowOrder"]); // 同级显示顺序
            return nc;
        }
        #endregion

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

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

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

            if (!Convert.IsDBNull(dr["GroupID"])) nc.GroupID = Convert.ToInt32(dr["GroupID"]); // 分类ID号
            if (!Convert.IsDBNull(dr["G_CName"])) nc.G_CName = Convert.ToString(dr["G_CName"]).Trim(); // 分类中文说明
            if (!Convert.IsDBNull(dr["G_ParentID"])) nc.G_ParentID = Convert.ToInt32(dr["G_ParentID"]); // 上级分类ID0:为最高级
            if (!Convert.IsDBNull(dr["G_ShowOrder"])) nc.G_ShowOrder = Convert.ToInt32(dr["G_ShowOrder"]); // 显示顺序
            if (!Convert.IsDBNull(dr["G_Level"])) nc.G_Level = Convert.ToInt32(dr["G_Level"]); // 当前分类所在层数
            if (!Convert.IsDBNull(dr["G_ChildCount"])) nc.G_ChildCount = Convert.ToInt32(dr["G_ChildCount"]); // 当前分类子分类数
            if (!Convert.IsDBNull(dr["G_Delete"])) nc.G_Delete = Convert.ToInt32(dr["G_Delete"]); // 是否删除1:是0:否
            return nc;
        }
        #endregion

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

        /// <summary>
        /// 返回sys_ModuleTable实体类的ArrayList对象
        /// </summary>
        /// <param name="qp">查询类</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>sys_ModuleTable实体类的ArrayList对象</returns>