accessdataprovider.cs

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

        }

        #endregion			
        
        #region "sys_Field - AccessDataProvider"
        /// <summary>
        /// 新增/删除/修改 sys_Field
        /// </summary>
        /// <param name="fam">sys_FieldTable实体类</param>
        /// <returns>返回0操正常</returns>
        public override int sys_FieldInsertUpdate(sys_FieldTable 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_Field(F_Key,F_CName,F_Remark)VALUES(@F_Key,@F_CName,@F_Remark)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("@F_Key", OleDbType.VarWChar).Value = fam.F_Key + ""; //应用字段关键字
                    cmd.Parameters.Add("@F_CName", OleDbType.VarWChar).Value = fam.F_CName + ""; //应用字段中文说明
                    cmd.Parameters.Add("@F_Remark", OleDbType.VarWChar).Value = fam.F_Remark + ""; //描述说明
                }
                else if (fam.DB_Option_Action_ == "Update")
                {

                    CommTxt = "UPDATE sys_Field SET	F_Key = @F_Key,F_CName = @F_CName,F_Remark = @F_Remark WHERE (FieldID = @FieldID)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("@F_Key", OleDbType.VarWChar).Value = fam.F_Key + ""; //应用字段关键字
                    cmd.Parameters.Add("@F_CName", OleDbType.VarWChar).Value = fam.F_CName + ""; //应用字段中文说明
                    cmd.Parameters.Add("@F_Remark", OleDbType.VarWChar).Value = fam.F_Remark + ""; //描述说明
                    cmd.Parameters.Add("@FieldID", OleDbType.Integer).Value = fam.FieldID;
                }
                else if (fam.DB_Option_Action_ == "Delete")
                {
                    CommTxt = "Delete from  sys_Field  WHERE (FieldID = @FieldID)";
                    cmd.CommandText = CommTxt;
                    cmd.Parameters.Add("@FieldID", OleDbType.Integer).Value = fam.FieldID;
                }
                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_FieldTable实体类的ArrayList对象
        /// </summary>
        /// <param name="qp">查询类</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>sys_FieldTable实体类的ArrayList对象</returns>
        public override ArrayList sys_FieldList(QueryParam qp, out int RecordCount)
        {
            PopulateDelegate mypd = new PopulateDelegate(base.Populatesys_Field);
            return this.GetObjectList(mypd, qp, out RecordCount);
        }

        #endregion		
	
        #region "sys_FieldValue - AccessDataProvider"
        /// <summary>
        /// 新增/删除/修改 sys_FieldValue
        /// </summary>
        /// <param name="fam">sys_FieldValueTable实体类</param>
        /// <returns>返回0操正常</returns>
        public override int sys_FieldValueInsertUpdate(sys_FieldValueTable 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_FieldValue(V_F_Key,V_Text,V_ShowOrder)VALUES(@V_F_Key,@V_Text,@V_ShowOrder)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("@V_F_Key", OleDbType.VarWChar).Value = fam.V_F_Key + ""; //与sys_Field表中F_Key字段关联
                    cmd.Parameters.Add("@V_Text", OleDbType.VarWChar).Value = fam.V_Text + ""; //中文说明	
                    cmd.Parameters.Add("@V_ShowOrder", OleDbType.Integer).Value = fam.V_ShowOrder; //同级显示顺序
                }
                else if (fam.DB_Option_Action_ == "Update")
                {

                    CommTxt = "UPDATE sys_FieldValue SET	V_F_Key = @V_F_Key,V_Text = @V_Text,V_ShowOrder = @V_ShowOrder WHERE (ValueID = @ValueID)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("@V_F_Key", OleDbType.VarWChar).Value = fam.V_F_Key + ""; //与sys_Field表中F_Key字段关联
                    cmd.Parameters.Add("@V_Text", OleDbType.VarWChar).Value = fam.V_Text + ""; //中文说明	
                    cmd.Parameters.Add("@V_ShowOrder", OleDbType.Integer).Value = fam.V_ShowOrder; //同级显示顺序
                    cmd.Parameters.Add("@ValueID", OleDbType.Integer).Value = fam.ValueID;
                }
                else if (fam.DB_Option_Action_ == "Delete")
                {
                    CommTxt = "Delete from  sys_FieldValue  WHERE (ValueID = @ValueID)";
                    cmd.CommandText = CommTxt;
                    cmd.Parameters.Add("@ValueID", OleDbType.Integer).Value = fam.ValueID;
                }
                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_FieldValueTable实体类的ArrayList对象
        /// </summary>
        /// <param name="qp">查询类</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>sys_FieldValueTable实体类的ArrayList对象</returns>
        public override ArrayList sys_FieldValueList(QueryParam qp, out int RecordCount)
        {
            PopulateDelegate mypd = new PopulateDelegate(base.Populatesys_FieldValue);
            return this.GetObjectList(mypd, qp, out RecordCount);
        }

        #endregion		
	
        #region "sys_Group - AccessDataProvider"
        /// <summary>
        /// 新增/删除/修改 sys_Group
        /// </summary>
        /// <param name="fam">sys_GroupTable实体类</param>
        /// <returns>返回0操正常</returns>
        public override int sys_GroupInsertUpdate(sys_GroupTable 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_Group(G_CName,G_ParentID,G_ShowOrder,G_Level,G_ChildCount,G_Delete)VALUES(@G_CName,@G_ParentID,@G_ShowOrder,@G_Level,@G_ChildCount,@G_Delete)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("@G_CName", OleDbType.VarWChar).Value = fam.G_CName + ""; //分类中文说明	
                    cmd.Parameters.Add("@G_ParentID", OleDbType.Integer).Value = fam.G_ParentID; //上级分类ID0:为最高级	
                    cmd.Parameters.Add("@G_ShowOrder", OleDbType.Integer).Value = fam.G_ShowOrder; //显示顺序	
                    cmd.Parameters.Add("@G_Level", OleDbType.Integer).Value = fam.G_Level; //当前分类所在层数	
                    cmd.Parameters.Add("@G_ChildCount", OleDbType.Integer).Value = fam.G_ChildCount; //当前分类子分类数
                    cmd.Parameters.Add("@G_Delete", OleDbType.LongVarWChar).Value = fam.G_Delete + "";  //是否删除1:是0:否
                }
                else if (fam.DB_Option_Action_ == "Update")
                {

                    CommTxt = "UPDATE sys_Group SET	G_CName = @G_CName,G_ParentID = @G_ParentID,G_ShowOrder = @G_ShowOrder,G_Level = @G_Level,G_ChildCount = @G_ChildCount,G_Delete = @G_Delete WHERE (GroupID = @GroupID)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("@G_CName", OleDbType.VarWChar).Value = fam.G_CName + ""; //分类中文说明	
                    cmd.Parameters.Add("@G_ParentID", OleDbType.Integer).Value = fam.G_ParentID; //上级分类ID0:为最高级	
                    cmd.Parameters.Add("@G_ShowOrder", OleDbType.Integer).Value = fam.G_ShowOrder; //显示顺序	
                    cmd.Parameters.Add("@G_Level", OleDbType.Integer).Value = fam.G_Level; //当前分类所在层数	
                    cmd.Parameters.Add("@G_ChildCount", OleDbType.Integer).Value = fam.G_ChildCount; //当前分类子分类数
                    cmd.Parameters.Add("@G_Delete", OleDbType.LongVarWChar).Value = fam.G_Delete + "";  //是否删除1:是0:否
                    cmd.Parameters.Add("@GroupID", OleDbType.Integer).Value = fam.GroupID;
                }
                else if (fam.DB_Option_Action_ == "Delete")
                {
                    CommTxt = "Delete from  sys_Group  WHERE (GroupID = @GroupID)";
                    cmd.CommandText = CommTxt;
                    cmd.Parameters.Add("@GroupID", OleDbType.Integer).Value = fam.GroupID;
                }
                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_GroupTable实体类的ArrayList对象
        /// </summary>
        /// <param name="qp">查询类</param>
        /// <param name="RecordCount">返回记录总数</param>
        /// <returns>sys_GroupTable实体类的ArrayList对象</returns>
        public override ArrayList sys_GroupList(QueryParam qp, out int RecordCount)
        {
            PopulateDelegate mypd = new PopulateDelegate(base.Populatesys_Group);
            return this.GetObjectList(mypd, qp, out RecordCount);
        }

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

            using (OleDbConnection Conn = GetSqlConnection())
            {
                string CommTxt;
                OleDbCommand cmd = new OleDbCommand();
                cmd.Connection = Conn;