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

namespace Com.Ascs.Plp.CW
{
	/// <summary>
	///  對象CW_TJD的定義
	///  根據表 CW_TJD
	/// </summary>
	
	public class CW_TJD
	{
		/// <summary>
		/// 對象CW_TJD的構造函數
		/// </summary>
		public CW_TJD()
		{
			m_TJDH = "";
			m_JGDM = "";
			m_SQR = "";
			m_SHR = null;
			m_CJRQ = DateTime.Now;
			m_ZTBJ = "";
			m_XGR = null;
			m_XGRQ = DateTime.Now;
			m_GZBJ = "";
			m_BZ = "";
		}
		
		private string m_TJDH;
		private string m_JGDM;
		private string m_SQR;
		private string m_SHR;
		private DateTime m_CJRQ;
		private string m_ZTBJ;
		private string m_XGR;
		private DateTime m_XGRQ;
		private string m_GZBJ;
		private string m_BZ;
		
		/// <summary>
		/// 屬性 TJDH
		/// </summary>
		public string TJDH
		{
			get
			{
				return m_TJDH;
			}
			set
			{
				m_TJDH = value;
			}
		}
		
		/// <summary>
		/// 屬性 JGDM
		/// </summary>
		public string JGDM
		{
			get
			{
				return m_JGDM;
			}
			set
			{
				m_JGDM = value;
			}
		}
		
		/// <summary>
		/// 屬性 SQR
		/// </summary>
		public string SQR
		{
			get
			{
				return m_SQR;
			}
			set
			{
				m_SQR = value;
			}
		}
		
		/// <summary>
		/// 屬性 SHR
		/// </summary>
		public string SHR
		{
			get
			{
				return m_SHR;
			}
			set
			{
				m_SHR = value;
			}
		}
		
		/// <summary>
		/// 屬性 CJRQ
		/// </summary>
		public DateTime CJRQ
		{
			get
			{
				return m_CJRQ;
			}
			set
			{
				m_CJRQ = value;
			}
		}
		
		/// <summary>
		/// 屬性 ZTBJ
		/// </summary>
		public string ZTBJ
		{
			get
			{
				return m_ZTBJ;
			}
			set
			{
				m_ZTBJ = value;
			}
		}
		
		/// <summary>
		/// 屬性 XGR
		/// </summary>
		public string XGR
		{
			get
			{
				return m_XGR;
			}
			set
			{
				m_XGR = value;
			}
		}
		
		/// <summary>
		/// 屬性 XGRQ
		/// </summary>
		public DateTime XGRQ
		{
			get
			{
				return m_XGRQ;
			}
			set
			{
				m_XGRQ = value;
			}
		}
		
		/// <summary>
		/// 屬性 GZBJ
		/// </summary>
		public string GZBJ
		{
			get
			{
				return m_GZBJ;
			}
			set
			{
				m_GZBJ = value;
			}
		}
		
		/// <summary>
		/// 屬性 BZ
		/// </summary>
		public string BZ
		{
			get
			{
				return m_BZ;
			}
			set
			{
				m_BZ = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 實現對 CW_TJD對象的管理
	/// </summary>
	
	public class CW_TJDMgr
	{
		/// <summary>
		///  添加新的CW_TJD對象
		/// </summary>
		/// <param name="theCW_TJD">要添加的CW_TJD對象</param>
		
		public bool AddCW_TJD(SqlConnection cn,CW_TJD theCW_TJD)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "insert into CW_TJD (TJDH, JGDM, SQR, SHR, CJRQ, ZTBJ, XGR, XGRQ, GZBJ, BZ) values (@TJDH, @JGDM, @SQR, @SHR, @CJRQ, @ZTBJ, @XGR, @XGRQ, @GZBJ, @BZ)";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@TJDH", theCW_TJD.TJDH);
				cmd.Parameters.Add ("@JGDM", theCW_TJD.JGDM);
				cmd.Parameters.Add ("@SQR", theCW_TJD.SQR);
				if (theCW_TJD.SHR == null)
					cmd.Parameters.Add ("@SHR", DBNull.Value);
				else
					cmd.Parameters.Add ("@SHR", theCW_TJD.SHR);
				cmd.Parameters.Add ("@CJRQ", theCW_TJD.CJRQ);
				cmd.Parameters.Add ("@ZTBJ", theCW_TJD.ZTBJ);
				if(theCW_TJD.XGR==null)
					cmd.Parameters.Add ("@XGR",DBNull.Value);
				else
					cmd.Parameters.Add ("@XGR", theCW_TJD.XGR);				
				cmd.Parameters.Add ("@XGRQ", theCW_TJD.XGRQ);
				cmd.Parameters.Add ("@GZBJ", theCW_TJD.GZBJ);
				cmd.Parameters.Add ("@BZ", theCW_TJD.BZ);
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_TJD(CW_TJD theCW_TJD)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_TJD對象
		/// </summary>
		/// <param name="theCW_TJD">要更新的CW_TJD對象</param>
		
		public bool UpdateCW_TJD(SqlConnection cn,CW_TJD theCW_TJD)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "update CW_TJD set JGDM=@JGDM, SQR=@SQR, SHR=@SHR, CJRQ=@CJRQ, ZTBJ=@ZTBJ, XGR=@XGR, XGRQ=@XGRQ, GZBJ=@GZBJ, BZ=@BZ where TJDH=@TJDH";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@TJDH", theCW_TJD.TJDH);
				cmd.Parameters.Add ("@JGDM", theCW_TJD.JGDM);
				cmd.Parameters.Add ("@SQR", theCW_TJD.SQR);
				cmd.Parameters.Add ("@SHR", theCW_TJD.SHR);
				cmd.Parameters.Add ("@CJRQ", theCW_TJD.CJRQ);
				cmd.Parameters.Add ("@ZTBJ", theCW_TJD.ZTBJ);
				cmd.Parameters.Add ("@XGR", theCW_TJD.XGR);
				cmd.Parameters.Add ("@XGRQ", theCW_TJD.XGRQ);
				cmd.Parameters.Add ("@GZBJ", theCW_TJD.GZBJ);
				cmd.Parameters.Add ("@BZ", theCW_TJD.BZ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_TJD(CW_TJD theCW_TJD)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  刪除CW_TJD對象
		/// </summary>
		/// <param name="TJDH">主鍵</param>
		
		public bool DelCW_TJD(SqlConnection cn,string TJDH)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;

				sql = "delete from CW_TJDXM where TJDH=@TJDH";
				
				SqlCommand cmd = new SqlCommand(sql, cn);				
				cmd.Parameters.Add ("@TJDH", TJDH);				
				cmd.ExecuteNonQuery();


				sql = "delete from CW_TJD where TJDH=@TJDH";				
				cmd = new SqlCommand(sql, cn);				
				cmd.Parameters.Add ("@TJDH", TJDH);				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_TJD(string TJDH)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根據主鍵標識獲得CW_TJD對象
		/// </summary>
		/// <param name="TJDH">主鍵</param>
		
		public CW_TJD GetCW_TJD(string TJDH)
		{
			try
			{
				CW_TJD result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_TJD where TJDH=@TJDH";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@TJDH", TJDH);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_TJD();
					if (dr["TJDH"] != null)
						if (!System.DBNull.Equals(dr["TJDH"], System.DBNull.Value))
							result.TJDH = (string)dr["TJDH"];
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							result.JGDM = (string)dr["JGDM"];
					if (dr["SQR"] != null)
						if (!System.DBNull.Equals(dr["SQR"], System.DBNull.Value))
							result.SQR = (string)dr["SQR"];
					if (dr["SHR"] != null)
						if (!System.DBNull.Equals(dr["SHR"], System.DBNull.Value))
							result.SHR = (string)dr["SHR"];
					if (dr["CJRQ"] != null)
						if (!System.DBNull.Equals(dr["CJRQ"], System.DBNull.Value))
							result.CJRQ = (DateTime)dr["CJRQ"];
					if (dr["ZTBJ"] != null)
						if (!System.DBNull.Equals(dr["ZTBJ"], System.DBNull.Value))
							result.ZTBJ = (string)dr["ZTBJ"];
					if (dr["XGR"] != null)
						if (!System.DBNull.Equals(dr["XGR"], System.DBNull.Value))
							result.XGR = (string)dr["XGR"];
					if (dr["XGRQ"] != null)
						if (!System.DBNull.Equals(dr["XGRQ"], System.DBNull.Value))
							result.XGRQ = (DateTime)dr["XGRQ"];
					if (dr["GZBJ"] != null)
						if (!System.DBNull.Equals(dr["GZBJ"], System.DBNull.Value))
							result.GZBJ = (string)dr["GZBJ"];
					if (dr["BZ"] != null)
						if (!System.DBNull.Equals(dr["BZ"], System.DBNull.Value))
							result.BZ = (string)dr["BZ"];
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("GetCW_TJD(string TJDH)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_TJD對象
		/// </summary>
	
		public ArrayList FindCW_TJD()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_TJD";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_TJD obj = new CW_TJD();
					if (dr["TJDH"] != null)
						if (!System.DBNull.Equals(dr["TJDH"], System.DBNull.Value))
							obj.TJDH = (string)dr["TJDH"];
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							obj.JGDM = (string)dr["JGDM"];
					if (dr["SQR"] != null)
						if (!System.DBNull.Equals(dr["SQR"], System.DBNull.Value))
							obj.SQR = (string)dr["SQR"];
					if (dr["SHR"] != null)
						if (!System.DBNull.Equals(dr["SHR"], System.DBNull.Value))
							obj.SHR = (string)dr["SHR"];
					if (dr["CJRQ"] != null)
						if (!System.DBNull.Equals(dr["CJRQ"], System.DBNull.Value))
							obj.CJRQ = (DateTime)dr["CJRQ"];
					if (dr["ZTBJ"] != null)
						if (!System.DBNull.Equals(dr["ZTBJ"], System.DBNull.Value))
							obj.ZTBJ = (string)dr["ZTBJ"];
					if (dr["XGR"] != null)
						if (!System.DBNull.Equals(dr["XGR"], System.DBNull.Value))
							obj.XGR = (string)dr["XGR"];
					if (dr["XGRQ"] != null)
						if (!System.DBNull.Equals(dr["XGRQ"], System.DBNull.Value))
							obj.XGRQ = (DateTime)dr["XGRQ"];
					if (dr["GZBJ"] != null)
						if (!System.DBNull.Equals(dr["GZBJ"], System.DBNull.Value))
							obj.GZBJ = (string)dr["GZBJ"];
					if (dr["BZ"] != null)
						if (!System.DBNull.Equals(dr["BZ"], System.DBNull.Value))
							obj.BZ = (string)dr["BZ"];
					result.Add(obj);
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("FindCW_TJD()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
	
	}
}