oracledataprovider.cs

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

            return rInt;
        }

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

        #endregion

        #region "sys_SystemInfo - OracleDataProvider"
        /// <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 (OracleConnection Conn = GetSqlConnection())
            {
                string CommTxt;
                OracleCommand cmd = new OracleCommand();
                cmd.Connection = Conn;
                if (fam.DB_Option_Action_ == "Insert")
                {
                    CommTxt = "Insert into 	sys_SystemInfo(SystemID,S_Name,S_Version,S_SystemConfigData,S_Licensed)VALUES(SEQ_sys_SystemInfo_ID.NEXTVAL,:S_Name,:S_Version,:S_SystemConfigData,:S_Licensed)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("S_Name", OracleType.NVarChar).Value = fam.S_Name + ""; //系统名称
                    cmd.Parameters.Add("S_Version", OracleType.NVarChar).Value = fam.S_Version + ""; //版本号
                    cmd.Parameters.Add("S_SystemConfigData", OracleType.LongRaw).Value = FrameSystemInfo.Serializable_sys_ConfigDataTable(fam.S_SystemConfigData);  //系统配置信息	
                    cmd.Parameters.Add("S_Licensed", OracleType.VarChar).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;

                    cmd.Parameters.Add("S_Name", OracleType.NVarChar).Value = fam.S_Name + ""; //系统名称
                    cmd.Parameters.Add("S_Version", OracleType.NVarChar).Value = fam.S_Version + ""; //版本号
                    cmd.Parameters.Add("S_SystemConfigData", OracleType.LongRaw).Value = FrameSystemInfo.Serializable_sys_ConfigDataTable(fam.S_SystemConfigData);  //系统配置信息	
                    cmd.Parameters.Add("S_Licensed", OracleType.VarChar).Value = fam.S_Licensed + ""; //序列号
                    cmd.Parameters.Add("SystemID", OracleType.Int32).Value = fam.SystemID;
                }
                else if (fam.DB_Option_Action_ == "Delete")
                {
                    CommTxt = "Delete from  sys_SystemInfo  WHERE (SystemID = :SystemID)";
                    cmd.CommandText = CommTxt;
                    cmd.Parameters.Add("SystemID", OracleType.Int32).Value = fam.SystemID;
                }
                else
                    throw new ApplicationException("无法识别的操作命令!");
                Conn.Open();
                OracleTransaction Tran = Conn.BeginTransaction();
                cmd.Transaction = Tran;
                try
                {
                    rInt = cmd.ExecuteNonQuery();
                    cmd.Parameters.Clear();
                    if (fam.DB_Option_Action_ == "Insert")
                    {
                        cmd.CommandText = "select SEQ_sys_SystemInfo_ID.CURRVAL from  dual";
                        rInt = Convert.ToInt32(cmd.ExecuteScalar());
                    }
                    Tran.Commit();
                }
                catch (Exception ex)
                {
                    Tran.Rollback();
                    throw new ApplicationException(ex.ToString());
                }
                finally
                {
                    Tran.Dispose();
                    cmd.Dispose();
                    Conn.Dispose();
                    Conn.Close();
                }
            }
            return rInt;
        }

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

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

            using (OracleConnection Conn = GetSqlConnection())
            {
                string CommTxt;
                OracleCommand cmd = new OracleCommand();
                cmd.Connection = Conn;
                if (fam.DB_Option_Action_ == "Insert")
                {
                    CommTxt = "Insert into 	sys_User(UserID,U_LoginName,U_Password,U_CName,U_EName,U_GroupID,U_Email,U_Type,U_Status,U_Licence,U_Mac,U_Remark,U_IDCard,U_Sex,U_BirthDay,U_MobileNo,U_UserNO,U_WorkStartDate,U_WorkEndDate,U_CompanyMail,U_Title,U_Extension,U_HomeTel,U_PhotoUrl,U_DateTime,U_LastIP,U_LastDateTime,U_ExtendField)VALUES(SEQ_sys_User_ID.NEXTVAL,:U_LoginName,:U_Password,:U_CName,:U_EName,:U_GroupID,:U_Email,:U_Type,:U_Status,:U_Licence,:U_Mac,:U_Remark,:U_IDCard,:U_Sex,:U_BirthDay,:U_MobileNo,:U_UserNO,:U_WorkStartDate,:U_WorkEndDate,:U_CompanyMail,:U_Title,:U_Extension,:U_HomeTel,:U_PhotoUrl,:U_DateTime,:U_LastIP,:U_LastDateTime,:U_ExtendField)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("U_LoginName", OracleType.NVarChar).Value = fam.U_LoginName + ""; //登陆名	
                    cmd.Parameters.Add("U_Password", OracleType.VarChar).Value = fam.U_Password + ""; //密码md5加密字符
                    cmd.Parameters.Add("U_CName", OracleType.NVarChar).Value = fam.U_CName + ""; //中文姓名	
                    cmd.Parameters.Add("U_EName", OracleType.VarChar).Value = fam.U_EName + ""; //英文名	
                    cmd.Parameters.Add("U_GroupID", OracleType.Int32).Value = fam.U_GroupID; //部门ID号与sys_Group表中GroupID关联	
                    cmd.Parameters.Add("U_Email", OracleType.VarChar).Value = fam.U_Email + ""; //电子邮件
                    cmd.Parameters.Add("U_Type", OracleType.SByte).Value = fam.U_Type; //用户类型0:超级用户1:普通用户
                    cmd.Parameters.Add("U_Status", OracleType.SByte).Value = fam.U_Status; //当前状态0:正常 1:禁止登陆 2:删除	
                    cmd.Parameters.Add("U_Licence", OracleType.VarChar).Value = fam.U_Licence + ""; //用户序列号	
                    cmd.Parameters.Add("U_Mac", OracleType.VarChar).Value = fam.U_Mac + ""; //锁定机器硬件地址
                    cmd.Parameters.Add("U_Remark", OracleType.NVarChar).Value = fam.U_Remark + ""; //备注说明	
                    cmd.Parameters.Add("U_IDCard", OracleType.VarChar).Value = fam.U_IDCard + ""; //身份证号码
                    cmd.Parameters.Add("U_Sex", OracleType.SByte).Value = fam.U_Sex; //性别1:男0:女	
                    cmd.Parameters.Add("U_BirthDay", OracleType.DateTime).Value = fam.U_BirthDay; //出生日期	
                    cmd.Parameters.Add("U_MobileNo", OracleType.VarChar).Value = fam.U_MobileNo + ""; //手机号	
                    cmd.Parameters.Add("U_UserNO", OracleType.VarChar).Value = fam.U_UserNO + ""; //员工编号	
                    cmd.Parameters.Add("U_WorkStartDate", OracleType.DateTime).Value = fam.U_WorkStartDate; //到职日期	
                    cmd.Parameters.Add("U_WorkEndDate", OracleType.DateTime).Value = fam.U_WorkEndDate; //离职日期	
                    cmd.Parameters.Add("U_CompanyMail", OracleType.VarChar).Value = fam.U_CompanyMail + ""; //公司邮件地址	
                    cmd.Parameters.Add("U_Title", OracleType.Int32).Value = fam.U_Title; //职称与应用字段关联	
                    cmd.Parameters.Add("U_Extension", OracleType.VarChar).Value = fam.U_Extension + ""; //分机号	
                    cmd.Parameters.Add("U_HomeTel", OracleType.VarChar).Value = fam.U_HomeTel + ""; //家中电话
                    cmd.Parameters.Add("U_PhotoUrl", OracleType.NVarChar).Value = fam.U_PhotoUrl + ""; //用户照片网址	
                    cmd.Parameters.Add("U_DateTime", OracleType.DateTime).Value = fam.U_DateTime; //操作时间	
                    cmd.Parameters.Add("U_LastIP", OracleType.VarChar).Value = fam.U_LastIP + ""; //最后访问IP	
                    cmd.Parameters.Add("U_LastDateTime", OracleType.DateTime).Value = fam.U_LastDateTime; //最后访问时间
                    cmd.Parameters.Add("U_ExtendField", OracleType.VarChar).Value = fam.U_ExtendField + "";  //扩展字段
                }
                else if (fam.DB_Option_Action_ == "Update")
                {

                    CommTxt = "UPDATE sys_User SET	U_LoginName = :U_LoginName,U_Password = :U_Password,U_CName = :U_CName,U_EName = :U_EName,U_GroupID = :U_GroupID,U_Email = :U_Email,U_Type = :U_Type,U_Status = :U_Status,U_Licence = :U_Licence,U_Mac = :U_Mac,U_Remark = :U_Remark,U_IDCard = :U_IDCard,U_Sex = :U_Sex,U_BirthDay = :U_BirthDay,U_MobileNo = :U_MobileNo,U_UserNO = :U_UserNO,U_WorkStartDate = :U_WorkStartDate,U_WorkEndDate = :U_WorkEndDate,U_CompanyMail = :U_CompanyMail,U_Title = :U_Title,U_Extension = :U_Extension,U_HomeTel = :U_HomeTel,U_PhotoUrl = :U_PhotoUrl,U_DateTime = :U_DateTime,U_LastIP = :U_LastIP,U_LastDateTime = :U_LastDateTime,U_ExtendField = :U_ExtendField WHERE (UserID = :UserID)";
                    cmd.CommandText = CommTxt;

                    cmd.Parameters.Add("U_LoginName", OracleType.NVarChar).Value = fam.U_LoginName + ""; //登陆名	
                    cmd.Parameters.Add("U_Password", OracleType.VarChar).Value = fam.U_Password + ""; //密码md5加密字符
                    cmd.Parameters.Add("U_CName", OracleType.NVarChar).Value = fam.U_CName + ""; //中文姓名	
                    cmd.Parameters.Add("U_EName", OracleType.VarChar).Value = fam.U_EName + ""; //英文名	
                    cmd.Parameters.Add("U_GroupID", OracleType.Int32).Value = fam.U_GroupID; //部门ID号与sys_Group表中GroupID关联	
                    cmd.Parameters.Add("U_Email", OracleType.VarChar).Value = fam.U_Email + ""; //电子邮件
                    cmd.Parameters.Add("U_Type", OracleType.SByte).Value = fam.U_Type; //用户类型0:超级用户1:普通用户
                    cmd.Parameters.Add("U_Status", OracleType.SByte).Value = fam.U_Status; //当前状态0:正常 1:禁止登陆 2:删除	
                    cmd.Parameters.Add("U_Licence", OracleType.VarChar).Value = fam.U_Licence + ""; //用户序列号	
                    cmd.Parameters.Add("U_Mac", OracleType.VarChar).Value = fam.U_Mac + ""; //锁定机器硬件地址
                    cmd.Parameters.Add("U_Remark", OracleType.NVarChar).Value = fam.U_Remark + ""; //备注说明	
                    cmd.Parameters.Add("U_IDCard", OracleType.VarChar).Value = fam.U_IDCard + ""; //身份证号码
                    cmd.Parameters.Add("U_Sex", OracleType.SByte).Value = fam.U_Sex; //性别1:男0:女	
                    cmd.Parameters.Add("U_BirthDay", OracleType.DateTime).Value = fam.U_BirthDay; //出生日期	
                    cmd.Parameters.Add("U_MobileNo", OracleType.VarChar).Value = fam.U_MobileNo + ""; //手机号	
                    cmd.Parameters.Add("U_UserNO", OracleType.VarChar).Value = fam.U_UserNO + ""; //员工编号	
                    cmd.Parameters.Add("U_WorkStartDate", OracleType.DateTime).Value = fam.U_WorkStartDate; //到职日期	
                    cmd.Parameters.Add("U_WorkEndDate", OracleType.DateTime).Value = fam.U_WorkEndDate; //离职日期	
                    cmd.Parameters.Add("U_CompanyMail", OracleType.VarChar).Value = fam.U_CompanyMail + ""; //公司邮件地址	
                    cmd.Parameters.Add("U_Title", OracleType.Int32).Value = fam.U_Title; //职称与应用字段关联	
                    cmd.Parameters.Add("U_Extension", OracleType.VarChar).Value = fam.U_Extension + ""; //分机号	
                    cmd.Parameters.Add("U_HomeTel", OracleType.VarChar).Value = fam.U_HomeTel + ""; //家中电话
                    cmd.Parameters.Add("U_PhotoUrl", OracleType.NVarChar).Value = fam.U_PhotoUrl + ""; //用户照片网址	
                    cmd.Parameters.Add("U_DateTime", OracleType.DateTime).Value = fam.U_DateTime; //操作时间	
                    cmd.Parameters.Add("U_LastIP", OracleType.VarChar).Value = fam.U_LastIP + ""; //最后访问IP	
                    cmd.Parameters.Add("U_LastDateTime", OracleType.DateTime).Value = fam.U_LastDateTime; //最后访问时间
                    cmd.Parameters.Add("U_ExtendField", OracleType.VarChar).Value = fam.U_ExtendField + "";  //扩展字段
                    cmd.Parameters.Add("UserID", OracleType.Int32).Value = fam.UserID;
                }
                else if (fam.DB_Option_Action_ == "Delete")
                {
                    CommTxt = "Delete from  sys_User  WHERE (UserID = :UserID)";
                    cmd.CommandText = CommTxt;
                    cmd.Parameters.Add("UserID", OracleType.Int32).Value = fam.UserID;
                }
                else
                    throw new ApplicationException("无法识别的操作命令!");
                Conn.Open();
                OracleTransaction Tran = Conn.BeginTransaction();
                cmd.Transaction = Tran;
                try
                {
                    rInt = cmd.ExecuteNonQuery();
                    cmd.Parameters.Clear();
                    if (fam.DB_Option_Action_ == "Insert")
                    {
                        cmd.CommandText = "select SEQ_sys_User_ID.CURRVAL from  dual";
                        rInt = Convert.ToInt32(cmd.ExecuteScalar());
                    }
                    Tran.Commit();
                }
                catch (Exception ex)
                {
                    Tran.Rollback();
                    throw new ApplicationException(ex.ToString());
                }
                finally
                {
                    Tran.Dispose();
                    cmd.Dispose();
                    Conn.Dispose();
                    Conn.Close();
                }
            }
            return rInt;
        }

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

        #endregion

        #region "sys_UserRoles - OracleDataProvider"
        /// <summary>