• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

C# Oracle.OracleDatabase类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了C#中Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase的典型用法代码示例。如果您正苦于以下问题:C# OracleDatabase类的具体用法?C# OracleDatabase怎么用?C# OracleDatabase使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



OracleDatabase类属于Microsoft.Practices.EnterpriseLibrary.Data.Oracle命名空间,在下文中一共展示了OracleDatabase类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: FindAll

 public static List<MEOMSS_discipline_new> FindAll(string sql)
 {
     OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
     //OracleDatabase db = new OracleDatabase(UserSecurity.ConnectionString);
     DbCommand cmd = db.GetSqlStringCommand(sql);
     return EntityBase<MEOMSS_discipline_new>.DReaderToEntityList(db.ExecuteReader(cmd));
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:7,代码来源:MEOMSS_discipline_new.cs


示例2: FindAll

 /// <summary>
 /// ��������Project�б�
 /// </summary>
 /// <returns></returns>
 public static List<project> FindAll()
 {
     OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
        // Database db = DatabaseFactory.CreateDatabase("ifsConnection");
     string sql = "SELECT * FROM IFSAPP.PROJECT";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     return EntityBase<project>.DReaderToEntityList(db.ExecuteReader(cmd));
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:12,代码来源:project.cs


示例3: Find

 /// <summary>
 /// ����Ȩ�ޱ�ʶ�����Ȩ����Ϣ
 /// </summary>
 /// <param name="flag"></param>
 /// <returns></returns>
 public static Privilege Find(string flag)
 {
     OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
     string sql = "SELECT * FROM PLM.PRIVILEGE_TAB WHERE PRIVILEGE_FLAG=:flag";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     db.AddInParameter(cmd, "flag", DbType.String, flag);
     return Populate(db.ExecuteReader(cmd));
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:13,代码来源:Privilege.cs


示例4: FindUnitDataset

 /// <summary>
 /// ��������Project�б�
 /// </summary>
 /// <returns></returns>
 public static DataSet FindUnitDataset()
 {
     OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
        // Database db = DatabaseFactory.CreateDatabase("ifsConnection");
     string sql = "SELECT UNIT_CODE  from IFSAPP.ISO_UNIT";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     return db.ExecuteDataSet(cmd);
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:12,代码来源:Unit.cs


示例5: FindAll

 /// <summary>
 /// ��������Project�б�
 /// </summary>
 /// <returns></returns>
 public static List<ReasonCode> FindAll()
 {
     OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
        // Database db = DatabaseFactory.CreateDatabase("ifsConnection");
     string sql = "SELECT * FROM IFSAPP.YRS_REQUISITION_REASON_TAB";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     return EntityBase<ReasonCode>.DReaderToEntityList(db.ExecuteReader(cmd));
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:12,代码来源:ReasonCode.cs


示例6: Exist

 /// <summary>
 /// ����Ȩ�ޱ�ʶ���ж��Ƿ���ڴ�Ȩ��
 /// </summary>
 /// <param name="flag"></param>
 /// <returns></returns>
 public static bool Exist(string flag)
 {
     OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
     string sql = "SELECT PRIVILEGE_FLAG FROM PLM.PRIVILEGE_TAB WHERE PRIVILEGE_FLAG=:flag";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     db.AddInParameter(cmd, "flag", DbType.String, flag);
     object ret = db.ExecuteScalar(cmd);
     return (ret == null || ret == DBNull.Value) ? false : true;
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:14,代码来源:Privilege.cs


示例7: Find

 public static Activity Find(string id)
 {
     // Database db = DatabaseFactory.CreateDatabase("ifsConnection");
     OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
     string sql = "SELECT * FROM IFSAPP.ACTIVITY WHERE activity_seq=:id";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     db.AddInParameter(cmd, "id", DbType.String, id);
     return Populate(db.ExecuteReader(cmd));
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:9,代码来源:Activity.cs


示例8: Find

 public static Unit Find(string id)
 {
     //Database db = DatabaseFactory.CreateDatabase();
     OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
     string sql = "SELECT UNIT_CODE FROM IFSAPP.ISO_UNIT WHERE UNIT_CODE=:id";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     db.AddInParameter(cmd, "id", DbType.String, id);
     return Populate(db.ExecuteReader(cmd));
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:9,代码来源:Unit.cs


示例9: FindECDMSID

 /// <summary>
 /// ����ERPID��ȡ��Ӧ��ECDMSID
 /// </summary>
 /// <param name="id"></param>
 /// <returns></returns>
 public static string FindECDMSID(string id)
 {
     //Database db = DatabaseFactory.CreateDatabase();
     OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
     string sql = "SELECT ECDMSID FROM plm.PROJECT_RELATION_TAB WHERE ERPid=:id";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     db.AddInParameter(cmd, "id", DbType.String, id);
     return Convert.ToString(db.ExecuteScalar(cmd));
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:14,代码来源:project.cs


示例10: FindDesc

 public static string FindDesc(string id)
 {
     //Database db = DatabaseFactory.CreateDatabase();
     OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
     string sql = "SELECT DESCRIPTION FROM IFSAPP.YRS_REQUISITION_REASON_TAB WHERE REASON_CODE=:id";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     db.AddInParameter(cmd, "id", DbType.String, id);
     return Convert.ToString(db.ExecuteScalar(cmd));
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:9,代码来源:ReasonCode.cs


示例11: Find

 public static SubProject Find(string id)
 {
     //Database db = DatabaseFactory.CreateDatabase();
     OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
     string sql = "SELECT * FROM IFSAPP.SUB_PROJECT WHERE project_id=:id";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     db.AddInParameter(cmd, "id", DbType.String, id);
     return Populate(db.ExecuteReader(cmd));
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:9,代码来源:SubProject.cs


示例12: Find

 public static ReasonCode Find(string id)
 {
     OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
     //Database db = DatabaseFactory.CreateDatabase();
     //OracleDatabase db = new OracleDatabase(UserSecurity.ConnectionString);
     string sql = "SELECT * FROM IFSAPP.YRS_REQUISITION_REASON_TAB WHERE REASON_CODE=:id";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     db.AddInParameter(cmd, "id", DbType.String, id);
     return Populate(db.ExecuteReader(cmd));
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:10,代码来源:ReasonCode.cs


示例13: Available

 /// <summary>
 /// �жϽ�ɫ�Ƿ����
 /// </summary>
 /// <param name="roleName"></param>
 /// <returns></returns>
 public static bool Available(string roleName)
 {
     OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
     string sql = "SELECT STATE FROM PLM.ROLE_TAB WHERE ROLENAME=:rolename";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     db.AddInParameter(cmd, "rolename", DbType.String, roleName);
     object state = db.ExecuteScalar(cmd);
     if (state == null || state == DBNull.Value) return false;
     return state.ToString().ToUpper() == RoleState.NORMAL.ToString();
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:15,代码来源:Role.cs


示例14: AddPrivilege

 /// <summary>
 /// ��ӽ�ɫ��Ȩ��
 /// </summary>
 /// <param name="roleName">��ɫ����</param>
 /// <param name="privilegeId">Ȩ��ID</param>
 /// <param name="projectIDs">��ĿID����</param>
 /// <returns></returns>
 public static int AddPrivilege(string roleName, int privilegeId, string projectIDs)
 {
     string sql = "INSERT INTO PLM.ROLEINPRIVILEGE_TAB (ROLENAME, PRIVILEGE_ID, PROJECT_ID) VALUES (:rolename, :privilegeid, :projectids)";
     OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
     DbCommand cmd = db.GetSqlStringCommand(sql);
     db.AddInParameter(cmd, "rolename", DbType.String, roleName);
     db.AddInParameter(cmd, "privilegeid", DbType.Int32, privilegeId);
     db.AddInParameter(cmd, "projectids", DbType.String, projectIDs);
     return db.ExecuteNonQuery(cmd);
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:17,代码来源:Role.cs


示例15: ExistModifyDrawing

 /// <summary>
 /// 查看是否存在修改通知单
 /// </summary>
 /// <param name="pid"></param>
 /// <param name="drawingno"></param>
 /// <returns></returns>
 public static bool ExistModifyDrawing(string pid, string drawingno)
 {
     OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
     string sql = "select t.modifydrawings from plm.SP_CREATEPDFDRAWING t  where t.projectid='" + pid + "' and t.drawingno='" + drawingno + "' and t.FRONTPAGE is not null AND t.FLAG = 'Y'";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     object ret = db.ExecuteScalar(cmd);
     if (ret == null || ret == DBNull.Value)
         return false;
     return true;
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:16,代码来源:CreatePDFDrawing.cs


示例16: ExistInfo

 /// <summary>
 /// 查看合并生成图纸表中是否存在该项
 /// </summary>
 /// <param name="pid"></param>
 /// <param name="drawingno"></param>
 /// <returns></returns>
 public static bool ExistInfo(string pid,string drawingno)
 {
     OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
     string sql = "select count(*) from plm.SP_CREATEPDFDRAWING t  where t.projectid='"+pid+"' and t.drawingno='"+drawingno+"' AND t.FLAG = 'Y'";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     object ret = db.ExecuteScalar(cmd);
     int num = Convert.ToInt32(ret);
     if (num==0)
         return false;
     return true;
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:17,代码来源:CreatePDFDrawing.cs


示例17: ExistPrivilege

 /// <summary>
 /// �ڵ��Ƿ��и�Ȩ������
 /// </summary>
 /// <returns></returns>
 public static bool ExistPrivilege(int privilegeid,int nodeid)
 {
     OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
     //OracleDatabase db = new OracleDatabase(UserSecurity.ConnectionString);
     string sql = "SELECT * FROM PLM.PRIVILEGE_NODE_TAB WHERE PRIVILEGE_ID=:privilegeid AND NODE_ID=:nodeid";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     db.AddInParameter(cmd, "privilegeid", DbType.Int32, privilegeid);
     db.AddInParameter(cmd, "nodeid", DbType.Int32, nodeid);
     object ret = db.ExecuteScalar(cmd);
     if (ret == null || ret == DBNull.Value) return false;
     return true;
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:16,代码来源:PrivilegeNode.cs


示例18: AddInherit

 /// <summary>
 /// ��ӽ�ɫ�̳�
 /// </summary>
 /// <param name="roleName"></param>
 /// <param name="inheritRoleName"></param>
 /// <returns></returns>
 public static void AddInherit(string roleName, string[] inheritRoleName)
 {
     string sql = "INSERT INTO PLM.ROLEINHERIT_TAB (ROLENAME, INHERITNAME) VALUES (:rolename, :inheritname)";
     OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
     DbCommand cmd = db.GetSqlStringCommand(sql);
     db.AddInParameter(cmd, "rolename", DbType.String, roleName);
     foreach (string inheritName in inheritRoleName)
     {
         if (inheritName == string.Empty) continue;
         if (cmd.Parameters.Contains("inheritname")) cmd.Parameters.RemoveAt("inheritname");
         db.AddInParameter(cmd, "inheritname", DbType.String, inheritName);
         db.ExecuteNonQuery(cmd);
     }
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:20,代码来源:Role.cs


示例19: GetPrivilegeIds

 /// <summary>
 /// ��øĽڵ����е�Ȩ��id
 /// </summary>
 /// <param name="nodeid"></param>
 /// <returns></returns>
 public static List<int> GetPrivilegeIds(int nodeid)
 {
     List<int> privilegeids=new List<int>();
     OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
     //Database db = DatabaseFactory.CreateDatabase("oidsConnection");
     string sql = "SELECT PRIVILEGE_ID FROM PRIVILEGE_NODE_TAB WHERE NODE_ID=:nodeid ORDER BY PRIVILEGE_ID";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     db.AddInParameter(cmd, "nodeid", DbType.Int32, nodeid);
     using (IDataReader dr = db.ExecuteReader(cmd))
     {
         while (dr.Read())
         {
            privilegeids.Add(Convert.ToInt32(dr[0]));
         }
         dr.Close();
     }
     return privilegeids;
 }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:23,代码来源:PrivilegeNode.cs


示例20: DrawingAllowedFlag

        /// <summary>
        /// ���ݽ�ɫ��ͼֽ��Ż�ȡ�Ƿ�������ʱ�ʶ
        /// </summary>
        /// <param name="roleName"></param>
        /// <param name="drawingId"></param>
        /// <returns></returns>
        public static string DrawingAllowedFlag(string roleName, int drawingId)
        {
            OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
            string sql = "SELECT ALLOW_FLAG FROM PLM.ROLEINDRAWING_TAB WHERE ROLENAME=:rolename AND DRAWING_ID=:drawingid";
            DbCommand cmd = db.GetSqlStringCommand(sql);
            db.AddInParameter(cmd, "rolename", DbType.String, roleName);
            db.AddInParameter(cmd, "drawingid", DbType.Int32, drawingId);
            object allowFlag = db.ExecuteScalar(cmd);

            if (allowFlag == DBNull.Value || allowFlag == null) return string.Empty;
            return allowFlag.ToString();
        }
开发者ID:freudshow,项目名称:raffles-codes,代码行数:18,代码来源:Role.cs



注:本文中的Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# Sql.SqlDatabase类代码示例发布时间:2022-05-26
下一篇:
C# Data.Database类代码示例发布时间:2022-05-26
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap