accessdataprovider.cs

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

                if (fam.DB_Option_Action_ == "Insert")
                {
                    CommTxt = "Insert into 	sys_Module(M_ApplicationID,M_ParentID,M_PageCode,M_CName,M_Directory,M_OrderLevel,M_IsSystem,M_Close)VALUES(@M_ApplicationID,@M_ParentID,@M_PageCode,@M_CName,@M_Directory,@M_OrderLevel,@M_IsSystem,@M_Close)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("@M_ApplicationID", OleDbType.Integer).Value = fam.M_ApplicationID; //所属应用程序ID	
                    cmd.Parameters.Add("@M_ParentID", OleDbType.Integer).Value = fam.M_ParentID; //所属父级模块ID与ModuleID关联,0为顶级	
                    cmd.Parameters.Add("@M_PageCode", OleDbType.VarWChar).Value = fam.M_PageCode + ""; //模块编码Parent为0,则为S00(xx),否则为S00M00(xx)
                    cmd.Parameters.Add("@M_CName", OleDbType.VarWChar).Value = fam.M_CName + ""; //模块/栏目名称当ParentID为0为模块名称
                    cmd.Parameters.Add("@M_Directory", OleDbType.VarWChar).Value = fam.M_Directory + ""; //模块/栏目目录名	
                    cmd.Parameters.Add("@M_OrderLevel", OleDbType.VarWChar).Value = fam.M_OrderLevel + ""; //当前所在排序级别支持双层99级菜单
                    cmd.Parameters.Add("@M_IsSystem", OleDbType.LongVarWChar).Value = fam.M_IsSystem + "";  //是否为系统模块1:是0:否如为系统则无法修改
                    cmd.Parameters.Add("@M_Close", OleDbType.LongVarWChar).Value = fam.M_Close + "";  //是否关闭1:是0:否
                }
                else if (fam.DB_Option_Action_ == "Update")
                {

                    CommTxt = "UPDATE sys_Module SET	M_ApplicationID = @M_ApplicationID,M_ParentID = @M_ParentID,M_PageCode = @M_PageCode,M_CName = @M_CName,M_Directory = @M_Directory,M_OrderLevel = @M_OrderLevel,M_IsSystem = @M_IsSystem,M_Close = @M_Close WHERE (ModuleID = @ModuleID)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("@M_ApplicationID", OleDbType.Integer).Value = fam.M_ApplicationID; //所属应用程序ID	
                    cmd.Parameters.Add("@M_ParentID", OleDbType.Integer).Value = fam.M_ParentID; //所属父级模块ID与ModuleID关联,0为顶级	
                    cmd.Parameters.Add("@M_PageCode", OleDbType.VarWChar).Value = fam.M_PageCode + ""; //模块编码Parent为0,则为S00(xx),否则为S00M00(xx)
                    cmd.Parameters.Add("@M_CName", OleDbType.VarWChar).Value = fam.M_CName + ""; //模块/栏目名称当ParentID为0为模块名称
                    cmd.Parameters.Add("@M_Directory", OleDbType.VarWChar).Value = fam.M_Directory + ""; //模块/栏目目录名	
                    cmd.Parameters.Add("@M_OrderLevel", OleDbType.VarWChar).Value = fam.M_OrderLevel + ""; //当前所在排序级别支持双层99级菜单
                    cmd.Parameters.Add("@M_IsSystem", OleDbType.LongVarWChar).Value = fam.M_IsSystem + "";  //是否为系统模块1:是0:否如为系统则无法修改
                    cmd.Parameters.Add("@M_Close", OleDbType.LongVarWChar).Value = fam.M_Close + "";  //是否关闭1:是0:否
                    cmd.Parameters.Add("@ModuleID", OleDbType.Integer).Value = fam.ModuleID;
                }
                else if (fam.DB_Option_Action_ == "Delete")
                {
                    CommTxt = "Delete from  sys_Module  WHERE (ModuleID = @ModuleID)";
                    cmd.CommandText = CommTxt;
                    cmd.Parameters.Add("@ModuleID", OleDbType.Integer).Value = fam.ModuleID;
                }
                else
                    throw new ApplicationException("无法识别的操作命令!");
                Conn.Open();
                rInt = cmd.ExecuteNonQuery();
                if (fam.DB_Option_Action_ == "Insert")
                {
                    cmd.CommandText = "SELECT @@identity";
                    rInt = Convert.ToInt32(cmd.ExecuteScalar());
                }
                cmd.Dispose();
                Conn.Dispose();
                Conn.Close();
            }
            return rInt;
        }

        /// <summary>
        /// 返回sys_ModuleTable实体类的ArrayList对象
        /// </summary>
        /// <param name="qp">查询类</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>sys_ModuleTable实体类的ArrayList对象</returns>
        public override ArrayList sys_ModuleList(QueryParam qp, out int RecordCount)
        {
            PopulateDelegate mypd = new PopulateDelegate(base.Populatesys_Module);
            return this.GetObjectList(mypd, qp, out RecordCount);
        }

        #endregion		
	
        #region "sys_RoleApplication - AccessDataProvider"
        /// <summary>
        /// 新增/删除/修改 sys_RoleApplication
        /// </summary>
        /// <param name="fam">sys_RoleApplicationTable实体类</param>
        /// <returns>返回0操正常</returns>
        public override int sys_RoleApplicationInsertUpdate(sys_RoleApplicationTable fam)
        {
            int rInt = 0;

            using (OleDbConnection Conn = GetSqlConnection())
            {
                string CommTxt;
                OleDbCommand cmd = new OleDbCommand();
                cmd.Connection = Conn;
                if (fam.DB_Option_Action_ == "Insert")
                {
                    CommTxt = "Insert into 	sys_RoleApplication(A_RoleID,A_ApplicationID)VALUES(@A_RoleID,@A_ApplicationID)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("@A_RoleID", OleDbType.Integer).Value = fam.A_RoleID; //角色ID与sys_Roles中RoleID相关	
                    cmd.Parameters.Add("@A_ApplicationID", OleDbType.Integer).Value = fam.A_ApplicationID; //应用ID与sys_Applications中Appl
                }
                else if (fam.DB_Option_Action_ == "Update")
                {

                    CommTxt = "UPDATE sys_RoleApplication SET	A_RoleID = @A_RoleID,A_ApplicationID = @A_ApplicationID WHERE (A_RoleID= @A_RoleID and A_ApplicationID = @A_ApplicationID)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("@A_RoleID", OleDbType.Integer).Value = fam.A_RoleID; //角色ID与sys_Roles中RoleID相关	
                    cmd.Parameters.Add("@A_ApplicationID", OleDbType.Integer).Value = fam.A_ApplicationID; //应用ID与sys_Applications中Appl
                }
                else if (fam.DB_Option_Action_ == "Delete")
                {
                    CommTxt = "Delete from  sys_RoleApplication  WHERE (A_RoleID= @A_RoleID and A_ApplicationID = @A_ApplicationID)";
                    cmd.CommandText = CommTxt;
                    cmd.Parameters.Add("@A_RoleID", OleDbType.Integer).Value = fam.A_RoleID; //角色ID与sys_Roles中RoleID相关	
                    cmd.Parameters.Add("@A_ApplicationID", OleDbType.Integer).Value = fam.A_ApplicationID; //应用ID与sys_Applications中Appl
                }
                else
                    throw new ApplicationException("无法识别的操作命令!");
                Conn.Open();
                rInt = cmd.ExecuteNonQuery();
                if (fam.DB_Option_Action_ == "Insert")
                {
                    cmd.CommandText = "SELECT @@identity";
                    rInt = Convert.ToInt32(cmd.ExecuteScalar());
                }
                cmd.Dispose();
                Conn.Dispose();
                Conn.Close();
            }
            return rInt;
        }

        /// <summary>
        /// 返回sys_RoleApplicationTable实体类的ArrayList对象
        /// </summary>
        /// <param name="qp">查询类</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>sys_RoleApplicationTable实体类的ArrayList对象</returns>
        public override ArrayList sys_RoleApplicationList(QueryParam qp, out int RecordCount)
        {
            PopulateDelegate mypd = new PopulateDelegate(base.Populatesys_RoleApplication);
            return this.GetObjectList(mypd, qp, out RecordCount);
        }

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

            using (OleDbConnection Conn = GetSqlConnection())
            {
                string CommTxt;
                OleDbCommand cmd = new OleDbCommand();
                cmd.Connection = Conn;
                if (fam.DB_Option_Action_ == "Insert")
                {
                    CommTxt = "Insert into 	sys_RolePermission(P_RoleID,P_ApplicationID,P_PageCode,P_Value)VALUES(@P_RoleID,@P_ApplicationID,@P_PageCode,@P_Value)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("@P_RoleID", OleDbType.Integer).Value = fam.P_RoleID; //角色ID与sys_Roles表中RoleID相	
                    cmd.Parameters.Add("@P_ApplicationID", OleDbType.Integer).Value = fam.P_ApplicationID; //角色所属应用ID与sys_Applicatio	
                    cmd.Parameters.Add("@P_PageCode", OleDbType.VarWChar).Value = fam.P_PageCode + ""; //角色应用中页面权限代码	
                    cmd.Parameters.Add("@P_Value", OleDbType.Integer).Value = fam.P_Value; //权限值
                }
                else if (fam.DB_Option_Action_ == "Update")
                {

                    CommTxt = "UPDATE sys_RolePermission SET	P_RoleID = @P_RoleID,P_ApplicationID = @P_ApplicationID,P_PageCode = @P_PageCode,P_Value = @P_Value WHERE (PermissionID = @PermissionID)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("@P_RoleID", OleDbType.Integer).Value = fam.P_RoleID; //角色ID与sys_Roles表中RoleID相	
                    cmd.Parameters.Add("@P_ApplicationID", OleDbType.Integer).Value = fam.P_ApplicationID; //角色所属应用ID与sys_Applicatio	
                    cmd.Parameters.Add("@P_PageCode", OleDbType.VarWChar).Value = fam.P_PageCode + ""; //角色应用中页面权限代码	
                    cmd.Parameters.Add("@P_Value", OleDbType.Integer).Value = fam.P_Value; //权限值
                    cmd.Parameters.Add("@PermissionID", OleDbType.Integer).Value = fam.PermissionID;
                }
                else if (fam.DB_Option_Action_ == "Delete")
                {
                    CommTxt = "Delete from  sys_RolePermission  WHERE (PermissionID = @PermissionID)";
                    cmd.CommandText = CommTxt;
                    cmd.Parameters.Add("@PermissionID", OleDbType.Integer).Value = fam.PermissionID;
                }
                else
                    throw new ApplicationException("无法识别的操作命令!");
                Conn.Open();
                rInt = cmd.ExecuteNonQuery();
                if (fam.DB_Option_Action_ == "Insert")
                {
                    cmd.CommandText = "SELECT @@identity";
                    rInt = Convert.ToInt32(cmd.ExecuteScalar());
                }
                cmd.Dispose();
                Conn.Dispose();
                Conn.Close();
            }
            return rInt;
        }

        /// <summary>
        /// 返回sys_RolePermissionTable实体类的ArrayList对象
        /// </summary>
        /// <param name="qp">查询类</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>sys_RolePermissionTable实体类的ArrayList对象</returns>
        public override ArrayList sys_RolePermissionList(QueryParam qp, out int RecordCount)
        {
            PopulateDelegate mypd = new PopulateDelegate(base.Populatesys_RolePermission);
            return this.GetObjectList(mypd, qp, out RecordCount);
        }

        #endregion		

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

            using (OleDbConnection Conn = GetSqlConnection())
            {
                string CommTxt;
                OleDbCommand cmd = new OleDbCommand();
                cmd.Connection = Conn;
                if (fam.DB_Option_Action_ == "Insert")
                {
                    CommTxt = "Insert into 	sys_SystemInfo(S_Name,S_Version,S_SystemConfigData,S_Licensed)VALUES(@S_Name,@S_Version,@S_SystemConfigData,@S_Licensed)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("@S_Name", OleDbType.VarWChar).Value = fam.S_Name + ""; //系统名称
                    cmd.Parameters.Add("@S_Version", OleDbType.VarWChar).Value = fam.S_Version + ""; //版本号
                    cmd.Parameters.Add("@S_SystemConfigData", OleDbType.VarBinary).Value = FrameSystemInfo.Serializable_sys_ConfigDataTable(fam.S_SystemConfigData) ;  //系统配置信息	
                    cmd.Parameters.Add("@S_Licensed", OleDbType.VarWChar).Value = fam.S_Licensed + ""; //序列号
                }
                else if (fam.DB_Option_Action_ == "Update")
                {

                    CommTxt = "UPDATE sys_SystemInfo SET	S_Name = @S_Name,S_Version = @S_Version,S_SystemConfigData = @S_SystemConfigData,S_Licensed = @S_Licensed WHERE (SystemID = @SystemID)";
                    cmd.CommandText = CommTxt;