dbsysmenu.cs

来自「c#编写的汽车销售公司erp进销存系统」· CS 代码 · 共 38 行

using System;
using CallCenter.IDAL;
using CallCenter.Modules;
using System.Data;
using System.Data.OracleClient;
using System.Collections;
using System.Text;

namespace CallCenter.OracleDAL
{
	/// <summary>
	/// 
	/// </summary>
	public class DBSysMenu:ISysMenu
	{
		public DBSysMenu()
		{
			// 
			// TODO: 在此处添加构造函数逻辑
			//
		}
	
		public DataSet getSysmenu()
		{
			string selSql = "SELECT id,mname,mdescription,pid,murl,chname,enname,shortcuts,ordernum,toolbar,imagename FROM sysmenu";
			
			try
			{
				return OraHelper.ExecuteDataSet(OraHelper.GetOracleConnection(),CommandType.Text,"sysmenu",selSql,null);
			}
			catch(Exception e)
			{
				throw e;
			}
		}
	}
}