dbknowledgetype.cs

c#编写的汽车销售公司erp进销存系统

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 DBKnowledgeType:IKnowledgeType
	{
		public DBKnowledgeType()
		{
			// 
			// TODO: 在此处添加构造函数逻辑
			//
		}
		#region IKnowledgeType 成员

		public int addKnowledgeType(KnowledgeTypeInfo info)
		{
			if( info == null)
				throw new Exception("The KnowledgeType Object is null,Can't Save Null object!");
			info.id = OraHelper.createSequence("se_knowledgetype");

			string addSql = "INSERT INTO knowledgetype(id,parentid,tname,oamark) VALUES(:id,:pid,:tname,:oamark)";			
			OracleParameter [] param = new OracleParameter[]
				{
					new OracleParameter(":id",OracleType.Int32,10),
					new OracleParameter(":pid",OracleType.Int32,10),
					new OracleParameter(":tname",OracleType.VarChar,60),
					new OracleParameter(":oamark",OracleType.Int32,10),
			};
			param[0].Value = info.id;
			param[1].Value = info.pid;
			param[2].Value = info.tname;
			param[3].Value = info.oamark;

			try
			{
				
				OraHelper.ExecuteNonQuery(OraHelper.GetOracleConnection(),CommandType.Text,addSql,param);
			}
			catch(Exception e)
			{	
				Console.WriteLine(e.Message.ToString());
				Console.WriteLine(e.StackTrace);
				throw e;
			}
			finally				
			{
				;
			}
			return info.id;
		}

		public void updateKnowledgeType(KnowledgeTypeInfo info)
		{
			if( info == null)
				throw new Exception("The KnowledgeType Object is null,Can't Save Null object!");

			string updateSql = "UPDATE knowledgetype SET parentid=:pid,tname=:tname,oamark=:oamark WHERE id=:id";			
			OracleParameter [] param = new OracleParameter[]
				{
					new OracleParameter(":id",OracleType.Int32,10),
					new OracleParameter(":pid",OracleType.Int32,10),
					new OracleParameter(":tname",OracleType.VarChar,60),
					new OracleParameter(":oamark",OracleType.Int32,10),
			};
			param[0].Value = info.id;
			param[1].Value = info.pid;
			param[2].Value = info.tname;
			param[3].Value = info.oamark;

			try
			{
				OraHelper.ExecuteNonQuery(OraHelper.GetOracleConnection(),CommandType.Text,updateSql,param);
			}
			catch(Exception e)
			{						
				throw e;
			}
			finally				
			{
				;
			}
		}

		public bool getKnowledgeTypeByPId(int pid)
		{
			string selSql = "SELECT * FROM knowledgetype WHERE parentid=:pid";
			OracleParameter[] param = new OracleParameter[]
				{
					new OracleParameter(":pid",OracleType.Int32,10),
				};
			param[0].Value = pid;
			try
			{
				OracleDataReader dr = OraHelper.ExecuteReader(OraHelper.GetOracleConnection(),CommandType.Text,selSql,param);
				if(dr.Read())
				{
					return true;
				}
				else
				{
					return false;
				}
			}
			catch(Exception e){
				throw e;
			}
		}

		public void delKnowledgeType(int id)
		{
			string delSql = "DELETE FROM knowledgetype WHERE id=:id";
			OracleParameter[] param = new OracleParameter[]
				{
					new OracleParameter(":id",OracleType.Int32,10),
			};
			param[0].Value = id;
			try
			{
				OraHelper.ExecuteNonQuery(OraHelper.GetOracleConnection(),CommandType.Text,delSql,param);				
			}
			catch(Exception e)
			{
				throw e;
			}
		}

		public DataSet getKnowledgeType(string tableName){
			string selSql = "SELECT * FROM knowledgetype";
			try
			{
				return OraHelper.ExecuteDataSet(OraHelper.GetOracleConnection(),CommandType.Text,tableName,selSql,null);
			}
			catch(Exception e)
			{
				throw e;
			}
		}

		#endregion
	}
}