using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using com.unicafe.common;

namespace Com.Ascs.Plp.CW
{
	/// <summary>
	///  對象CW_DJLX的定義
	///  根據表 CW_DJLX
	/// </summary>
	
	public class CW_DJLX
	{
		/// <summary>
		/// 對象CW_DJLX的構造函數
		/// </summary>
		public CW_DJLX()
		{
			m_LXBH = 0;
			m_BJ = "";
			m_DJLX = "";
			m_LXMC = "";
		}
		
		private int m_LXBH;
		private string m_BJ;
		private string m_DJLX;
		private string m_LXMC;
		
		/// <summary>
		/// 屬性 LXBH
		/// </summary>
		public int LXBH
		{
			get
			{
				return m_LXBH;
			}
			set
			{
				m_LXBH = value;
			}
		}
		
		/// <summary>
		/// 屬性 BJ
		/// </summary>
		public string BJ
		{
			get
			{
				return m_BJ;
			}
			set
			{
				m_BJ = value;
			}
		}
		
		/// <summary>
		/// 屬性 DJLX
		/// </summary>
		public string DJLX
		{
			get
			{
				return m_DJLX;
			}
			set
			{
				m_DJLX = value;
			}
		}
		
		/// <summary>
		/// 屬性 LXMC
		/// </summary>
		public string LXMC
		{
			get
			{
				return m_LXMC;
			}
			set
			{
				m_LXMC = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 實現對 CW_DJLX對象的管理
	/// </summary>
	
	public class CW_DJLXMgr
	{
		/// <summary>
		///  添加新的CW_DJLX對象
		/// </summary>
		/// <param name="theCW_DJLX">要添加的CW_DJLX對象</param>
		
		public bool AddCW_DJLX(SqlConnection cn,CW_DJLX theCW_DJLX)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "insert into CW_DJLX (LXBH, BJ, DJLX, LXMC) values (@LXBH, @BJ, @DJLX, @LXMC)";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@LXBH", theCW_DJLX.LXBH);
				cmd.Parameters.Add ("@BJ", theCW_DJLX.BJ);
				cmd.Parameters.Add ("@DJLX", theCW_DJLX.DJLX);
				cmd.Parameters.Add ("@LXMC", theCW_DJLX.LXMC);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_DJLX(CW_DJLX theCW_DJLX)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_DJLX對象
		/// </summary>
		/// <param name="theCW_DJLX">要更新的CW_DJLX對象</param>
		
		public bool UpdateCW_DJLX(SqlConnection cn,CW_DJLX theCW_DJLX)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "update CW_DJLX set BJ=@BJ, DJLX=@DJLX, LXMC=@LXMC where LXBH=@LXBH";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@LXBH", theCW_DJLX.LXBH);
				cmd.Parameters.Add ("@BJ", theCW_DJLX.BJ);
				cmd.Parameters.Add ("@DJLX", theCW_DJLX.DJLX);
				cmd.Parameters.Add ("@LXMC", theCW_DJLX.LXMC);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_DJLX(CW_DJLX theCW_DJLX)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  刪除CW_DJLX對象
		/// </summary>
		/// <param name="LXBH">主鍵</param>
		
		public bool DelCW_DJLX(SqlConnection cn,int LXBH)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "delete from CW_DJLX where LXBH=@LXBH";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@LXBH", LXBH);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_DJLX(int LXBH)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根據主鍵標識獲得CW_DJLX對象
		/// </summary>
		/// <param name="LXBH">主鍵</param>
		
		public CW_DJLX GetCW_DJLX(int LXBH)
		{
			try
			{
				CW_DJLX result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_DJLX where LXBH=@LXBH";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@LXBH", LXBH);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_DJLX();
					if (dr["LXBH"] != null)
						if (!System.DBNull.Equals(dr["LXBH"], System.DBNull.Value))
							result.LXBH = (int)dr["LXBH"];
					if (dr["BJ"] != null)
						if (!System.DBNull.Equals(dr["BJ"], System.DBNull.Value))
							result.BJ = (string)dr["BJ"];
					if (dr["DJLX"] != null)
						if (!System.DBNull.Equals(dr["DJLX"], System.DBNull.Value))
							result.DJLX = (string)dr["DJLX"];
					if (dr["LXMC"] != null)
						if (!System.DBNull.Equals(dr["LXMC"], System.DBNull.Value))
							result.LXMC = (string)dr["LXMC"];
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("GetCW_DJLX(int LXBH)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_DJLX對象
		/// </summary>
	
		public ArrayList FindCW_DJLX()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_DJLX";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_DJLX obj = new CW_DJLX();
					if (dr["LXBH"] != null)
						if (!System.DBNull.Equals(dr["LXBH"], System.DBNull.Value))
							obj.LXBH = (int)dr["LXBH"];
					if (dr["BJ"] != null)
						if (!System.DBNull.Equals(dr["BJ"], System.DBNull.Value))
							obj.BJ = (string)dr["BJ"];
					if (dr["DJLX"] != null)
						if (!System.DBNull.Equals(dr["DJLX"], System.DBNull.Value))
							obj.DJLX = (string)dr["DJLX"];
					if (dr["LXMC"] != null)
						if (!System.DBNull.Equals(dr["LXMC"], System.DBNull.Value))
							obj.LXMC = (string)dr["LXMC"];
					result.Add(obj);
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("FindCW_DJLX()");
				LogService.Write (e.Message);
				return null;
			}
		}
	///begin
		/// <summary>
		///  查找CW_DJLX對象
		/// </summary>
	
		public ArrayList FindCW_DJLX(string djlx)
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_DJLX where djlx=@djlx";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
				cmd.Parameters.Add ("@djlx", djlx);

				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_DJLX obj = new CW_DJLX();
					if (dr["LXBH"] != null)
						if (!System.DBNull.Equals(dr["LXBH"], System.DBNull.Value))
							obj.LXBH = (int)dr["LXBH"];
					if (dr["BJ"] != null)
						if (!System.DBNull.Equals(dr["BJ"], System.DBNull.Value))
							obj.BJ = (string)dr["BJ"];
					if (dr["DJLX"] != null)
						if (!System.DBNull.Equals(dr["DJLX"], System.DBNull.Value))
							obj.DJLX = (string)dr["DJLX"];
					if (dr["LXMC"] != null)
						if (!System.DBNull.Equals(dr["LXMC"], System.DBNull.Value))
							obj.LXMC = (string)dr["LXMC"];
					result.Add(obj);
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("FindCW_DJLX(string djlx)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		//end
	
	}
}