using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using com.unicafe.common;
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	///  對象CW_JZSYDY的定義
	///  根據表 CW_JZSYDY
	/// </summary>
	
	public class CW_JZSYDY
	{
		/// <summary>
		/// 對象CW_JZSYDY的構造函數
		/// </summary>
		public CW_JZSYDY()
		{
			m_KJND = "";
			m_ZCKM = "";
			m_SYKM = "";
			m_QYZT = "";
		}
		
		private string m_KJND;
		private string m_ZCKM;
		private string m_SYKM;
		private string m_QYZT;
		
		/// <summary>
		/// 屬性 KJND
		/// </summary>
		public string KJND
		{
			get
			{
				return m_KJND;
			}
			set
			{
				m_KJND = value;
			}
		}
		
		/// <summary>
		/// 屬性 ZCKM
		/// </summary>
		public string ZCKM
		{
			get
			{
				return m_ZCKM;
			}
			set
			{
				m_ZCKM = value;
			}
		}
		
		/// <summary>
		/// 屬性 SYKM
		/// </summary>
		public string SYKM
		{
			get
			{
				return m_SYKM;
			}
			set
			{
				m_SYKM = value;
			}
		}
		
		/// <summary>
		/// 屬性 QYZT
		/// </summary>
		public string QYZT
		{
			get
			{
				return m_QYZT;
			}
			set
			{
				m_QYZT = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 實現對 CW_JZSYDY對象的管理
	/// </summary>
	
	public class CW_JZSYDYMgr
	{
		/// <summary>
		///  添加新的CW_JZSYDY對象
		/// </summary>
		/// <param name="theCW_JZSYDY">要添加的CW_JZSYDY對象</param>
		
		public bool AddCW_JZSYDY(System.Data.SqlClient.SqlConnection cn ,CW_JZSYDY theCW_JZSYDY)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "insert into CW_JZSYDY (KJND, ZCKM, SYKM, QYZT) values (@KJND, @ZCKM, @SYKM, @QYZT)";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@KJND", theCW_JZSYDY.KJND);
				cmd.Parameters.Add ("@ZCKM", theCW_JZSYDY.ZCKM);
				cmd.Parameters.Add ("@SYKM", theCW_JZSYDY.SYKM);
				cmd.Parameters.Add ("@QYZT", theCW_JZSYDY.QYZT);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_JZSYDY(CW_JZSYDY theCW_JZSYDY)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_JZSYDY對象
		/// </summary>
		/// <param name="theCW_JZSYDY">要更新的CW_JZSYDY對象</param>
		
		public bool UpdateCW_JZSYDY(System.Data.SqlClient.SqlConnection cn ,CW_JZSYDY theCW_JZSYDY)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "update CW_JZSYDY set SYKM=@SYKM, QYZT=@QYZT where KJND=@KJND and ZCKM=@ZCKM";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@KJND", theCW_JZSYDY.KJND);
				cmd.Parameters.Add ("@ZCKM", theCW_JZSYDY.ZCKM);
				cmd.Parameters.Add ("@SYKM", theCW_JZSYDY.SYKM);
				cmd.Parameters.Add ("@QYZT", theCW_JZSYDY.QYZT);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_JZSYDY(CW_JZSYDY theCW_JZSYDY)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  刪除CW_JZSYDY對象
		/// </summary>
		/// <param name="KJND">主鍵</param>
		/// <param name="ZCKM">主鍵</param>
		
		public bool DelCW_JZSYDY(System.Data.SqlClient.SqlConnection cn ,string KJND, string ZCKM)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "delete from CW_JZSYDY where KJND=@KJND and ZCKM=@ZCKM";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@KJND", KJND);
				cmd.Parameters.Add ("@ZCKM", ZCKM);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_JZSYDY(string KJND, string ZCKM)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根據主鍵標識獲得CW_JZSYDY對象
		/// </summary>
		/// <param name="KJND">主鍵</param>
		/// <param name="ZCKM">主鍵</param>
		
		public CW_JZSYDY GetCW_JZSYDY(string KJND, string ZCKM)
		{
			try
			{
				CW_JZSYDY result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_JZSYDY where KJND=@KJND and ZCKM=@ZCKM";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@KJND", KJND);
				cmd.Parameters.Add ("@ZCKM", ZCKM);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_JZSYDY();
					if (dr["KJND"] != null)
						if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
							result.KJND = (string)dr["KJND"];
					if (dr["ZCKM"] != null)
						if (!System.DBNull.Equals(dr["ZCKM"], System.DBNull.Value))
							result.ZCKM = (string)dr["ZCKM"];
					if (dr["SYKM"] != null)
						if (!System.DBNull.Equals(dr["SYKM"], System.DBNull.Value))
							result.SYKM = (string)dr["SYKM"];
					if (dr["QYZT"] != null)
						if (!System.DBNull.Equals(dr["QYZT"], System.DBNull.Value))
							result.QYZT = (string)dr["QYZT"];
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("GetCW_JZSYDY(string KJND, string ZCKM)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_JZSYDY對象
		/// </summary>
	
		public ArrayList FindCW_JZSYDY()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_JZSYDY";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_JZSYDY obj = new CW_JZSYDY();
					if (dr["KJND"] != null)
						if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
							obj.KJND = (string)dr["KJND"];
					if (dr["ZCKM"] != null)
						if (!System.DBNull.Equals(dr["ZCKM"], System.DBNull.Value))
							obj.ZCKM = (string)dr["ZCKM"];
					if (dr["SYKM"] != null)
						if (!System.DBNull.Equals(dr["SYKM"], System.DBNull.Value))
							obj.SYKM = (string)dr["SYKM"];
					if (dr["QYZT"] != null)
						if (!System.DBNull.Equals(dr["QYZT"], System.DBNull.Value))
							obj.QYZT = (string)dr["QYZT"];
					result.Add(obj);
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("FindCW_JZSYDY()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
	
	}
}