C# OracleDatabase.ExecuteDataSet方法代码示例

 /// <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);
 }

        /// <summary>
        /// ��������Project�б�
        /// </summary>
        /// <returns></returns>
        public static DataSet FindStnPartDataset(string ProjectId,string Site)
        {
            OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
            //Database db = DatabaseFactory.CreateDatabase("ifsConnection");
            string sql = "SELECT typeid, STA_PART_NO, PART_NAME FROM plm.MM_STA_PART_TAB a  where   PROJECTID=:proId  and SITE=:site ";
            DbCommand cmd = db.GetSqlStringCommand(sql);
            db.AddInParameter(cmd, "proId", DbType.String, ProjectId);

            db.AddInParameter(cmd, "site", DbType.String, Site);
            return db.ExecuteDataSet(cmd);
        }

 /// <summary>
 /// �鿴��PROJECT_System_TAB������û�� ѡ�����Ŀ
 /// </summary>
 /// <param name="dr"></param>
 /// <returns></returns>
 public static DataSet TreeByPid(string id, string keyword, string newFlag)
 {
     OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
     string sql = "SELECT * FROM PLM.PROJECT_System_TAB WHERE project_id=:id and NEWFLAG ='" + newFlag + "'";
     if (keyword != string.Empty) sql += " AND DESCRIPTION LIKE '%" + keyword + "%'";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     db.AddInParameter(cmd, "id", DbType.String, id);
     return db.ExecuteDataSet((cmd));
 }

 /// <summary>
 /// ������������Ŀ�µ�����Ŀ�б�
 /// </summary>
 /// <returns></returns>
 public static DataSet FindSub2ProjectsDs(string id, string subId)
 {
     OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
        // Database db = DatabaseFactory.CreateDatabase("ifsConnection");
     string sql = "	 SELECT * FROM IFSAPP.SUB_PROJECT T  WHERE T.PROJECT_ID = :id 	 AND T.PARENT_SUB_PROJECT_ID =:subId ORDER BY t.sub_project_id";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     db.AddInParameter(cmd, "id", DbType.String, id);
     db.AddInParameter(cmd, "subId", DbType.String, subId);
     return db.ExecuteDataSet(cmd);
 }

 /// <summary>
 /// ��������Site�б�
 /// </summary>
 /// <returns></returns>
 public static DataSet FindSiteDataset()
 {
     OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
        // Database db = DatabaseFactory.CreateDatabase("ifsConnection");
     string sql = "SELECT * FROM IFSAPP.site_tab";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     return db.ExecuteDataSet(cmd);
 }

 public static DataSet FindERPPartDataset(string partno, string site,string ProId,string ActSeq)
 {
     // Database db = DatabaseFactory.CreateDatabase("ifsConnection");
     OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
     string sql = "SELECT ERP_PART_NO,PART_NAME,site FROM plm.MM_IFS_STA_PART_TAB where STA_PART_NO=:staPartno  and PROJECTID=:proId and ACTIVITYSEQ=:actSeq and SITE=:site";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     db.AddInParameter(cmd, "staPartno", DbType.String, partno);
     db.AddInParameter(cmd, "proId", DbType.String, ProId);
     db.AddInParameter(cmd, "actSeq", DbType.Int32, ActSeq);
     db.AddInParameter(cmd, "site", DbType.String, site);
     return db.ExecuteDataSet(cmd);
 }

 public static DataSet PartTypeDs()
 {
     OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
     //Database db = DatabaseFactory.CreateDatabase("ifsConnection");
     string sql = "SELECT TYPEID, TYPE_DESC FROM plm.MM_PART_TYPE_TAB";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     return db.ExecuteDataSet(cmd);
 }

 /// <summary>
 /// ȡ�����No�б�
 /// </summary>
 /// <param name="pid"></param>
 /// <param name="contract"></param>
 /// <returns></returns>
 public static DataSet PartNoData(string pid, string contract)
 {
     OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
     //Database db = DatabaseFactory.CreateDatabase("ifsConnection");
     string sql = "SELECT part_no FROM plm.MM_PART_TAB where parentid=" + pid + " and contract='" + contract + "'";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     return db.ExecuteDataSet(cmd);
 }

 public static DataSet FindInvPartFamilyDataset()
 {
     //Database db = DatabaseFactory.CreateDatabase("ifsConnection");
     OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
     string sql = "  select PART_PRODUCT_FAMILY, IFSAPP.INVENTORY_PRODUCT_FAMILY_API.Get_Description(PART_PRODUCT_FAMILY) familyname  from (SELECT distinct PART_PRODUCT_FAMILY FROM IFSAPP.inventory_part)";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     return db.ExecuteDataSet(cmd);
 }

 public static DataSet FindInvPartDimDataset()
 {
     // Database db = DatabaseFactory.CreateDatabase("ifsConnection");
     OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
     string sql = "SELECT distinct dim_quality FROM IFSAPP.inventory_part";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     return db.ExecuteDataSet(cmd);
 }

 /// <summary>
 /// Executes the data set.
 /// </summary>
 /// <param name="commandType">Type of the command.</param>
 /// <param name="commandText">The command text.</param>
 /// <returns></returns>
 public static DataSet ExecuteDataSet(CommandType commandType, string commandText)
 {
     OracleDatabase database = new OracleDatabase(ConnectionString);
     return database.ExecuteDataSet(commandType, commandText);
 }

        /// <summary>
        /// ������������Ŀ�б�
        /// </summary>
        /// <returns></returns>
        public static DataSet FindActivityDs(string id)
        {
            // Database db = DatabaseFactory.CreateDatabase("ifsConnection");
            OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
            string sql = "SELECT activity_seq,description,sub_project_id,activity_no FROM IFSAPP.ACTIVITY T  WHERE T.PROJECT_ID =:id	ORDER BY t.activity_seq";
            DbCommand cmd = db.GetSqlStringCommand(sql);
            db.AddInParameter(cmd, "id", DbType.String, id);

            return db.ExecuteDataSet(cmd);
        }

 /// <summary>
 /// 返回数据集
 /// </summary>
 /// <param name="sr"></param>
 /// <param name="dat"></param>
 public static DataSet getds(string sr)
 {
     OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
     string sql = sr;
     DbCommand cmd = db.GetSqlStringCommand(sql);
     return db.ExecuteDataSet(cmd);
 }

 public static DataSet FindInvPartInfByPartNameDataset(string partname,string site)
 {
     // Database db = DatabaseFactory.CreateDatabase("ifsConnection");
     OracleDatabase db = new OracleDatabase(DataAccess.IFSConnStr);
     string sql = "SELECT PART_NO,DESCRIPTION FROM IFSAPP.inventory_part where DESCRIPTION like '%" + partname + "%' and CONTRACT='" + site + "'";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     return db.ExecuteDataSet(cmd);
 }

 /// <summary>
 /// ��øýڵ����е��ӽڵ�
 /// </summary>
 /// <param name="nodeid"></param>
 /// <returns></returns>
 public static DataSet GetSubNodes(int nodeid)
 {
     OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr);
     //OracleDatabase db = new OracleDatabase(UserSecurity.ConnectionString);
     string sql = "SELECT PARENT_INDEX,TEXT FROM PLM.TREENODES_TAB WHERE PARENT_ID=" + nodeid + " ORDER BY PARENT_INDEX";
     DbCommand cmd = db.GetSqlStringCommand(sql);
     return db.ExecuteDataSet(cmd);
 }