using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using com.unicafe.common;
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	///  對象CW_XJRJZ的定義
	///  根據表 CW_XJRJZ
	/// </summary>
	
	public class CW_XJRJZ
	{
		/// <summary>
		/// 對象CW_XJRJZ的構造函數
		/// </summary>
		public CW_XJRJZ()
		{
			m_KJND = "";
			m_KJQJ = "";
			m_JZRQ = DateTime.Now;
			m_KJKM = "";
			m_PJH = "";
			m_ZY = "";
			m_DFKM = "";
			m_PZH = "";
			m_JFJE = 0;
			m_DFJE = 0;
			m_BZ = "";
		}
		
		private string m_KJND;
		private string m_KJQJ;
		private DateTime m_JZRQ;
		private string m_KJKM;
		private string m_PJH;
		private string m_ZY;
		private string m_DFKM;
		private string m_PZH;
		private double m_JFJE;
		private double m_DFJE;
		private string m_BZ;
		
		/// <summary>
		/// 屬性 KJND
		/// </summary>
		public string KJND
		{
			get
			{
				return m_KJND;
			}
			set
			{
				m_KJND = value;
			}
		}
		
		/// <summary>
		/// 屬性 KJQJ
		/// </summary>
		public string KJQJ
		{
			get
			{
				return m_KJQJ;
			}
			set
			{
				m_KJQJ = value;
			}
		}
		
		/// <summary>
		/// 屬性 JZRQ
		/// </summary>
		public DateTime JZRQ
		{
			get
			{
				return m_JZRQ;
			}
			set
			{
				m_JZRQ = value;
			}
		}
		
		/// <summary>
		/// 屬性 KJKM
		/// </summary>
		public string KJKM
		{
			get
			{
				return m_KJKM;
			}
			set
			{
				m_KJKM = value;
			}
		}
		
		/// <summary>
		/// 屬性 PJH
		/// </summary>
		public string PJH
		{
			get
			{
				return m_PJH;
			}
			set
			{
				m_PJH = value;
			}
		}
		
		/// <summary>
		/// 屬性 ZY
		/// </summary>
		public string ZY
		{
			get
			{
				return m_ZY;
			}
			set
			{
				m_ZY = value;
			}
		}
		
		/// <summary>
		/// 屬性 DFKM
		/// </summary>
		public string DFKM
		{
			get
			{
				return m_DFKM;
			}
			set
			{
				m_DFKM = value;
			}
		}
		
		/// <summary>
		/// 屬性 PZH
		/// </summary>
		public string PZH
		{
			get
			{
				return m_PZH;
			}
			set
			{
				m_PZH = value;
			}
		}
		
		/// <summary>
		/// 屬性 JFJE
		/// </summary>
		public double JFJE
		{
			get
			{
				return m_JFJE;
			}
			set
			{
				m_JFJE = value;
			}
		}
		
		/// <summary>
		/// 屬性 DFJE
		/// </summary>
		public double DFJE
		{
			get
			{
				return m_DFJE;
			}
			set
			{
				m_DFJE = value;
			}
		}
		
		/// <summary>
		/// 屬性 BZ
		/// </summary>
		public string BZ
		{
			get
			{
				return m_BZ;
			}
			set
			{
				m_BZ = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 實現對 CW_XJRJZ對象的管理
	/// </summary>
	
	public class CW_XJRJZMgr
	{
		/// <summary>
		///  添加新的CW_XJRJZ對象
		/// </summary>
		/// <param name="theCW_XJRJZ">要添加的CW_XJRJZ對象</param>
		
		public bool AddCW_XJRJZ(System.Data.SqlClient.SqlConnection cn ,CW_XJRJZ theCW_XJRJZ)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "insert into CW_XJRJZ (KJND, KJQJ, JZRQ, KJKM, PJH, ZY, DFKM, PZH, JFJE, DFJE, BZ) values (@KJND, @KJQJ, @JZRQ, @KJKM, @PJH, @ZY, @DFKM, @PZH, @JFJE, @DFJE, @BZ)";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@KJND", theCW_XJRJZ.KJND);
				cmd.Parameters.Add ("@KJQJ", theCW_XJRJZ.KJQJ);
				cmd.Parameters.Add ("@JZRQ", theCW_XJRJZ.JZRQ);
				cmd.Parameters.Add ("@KJKM", theCW_XJRJZ.KJKM);
				cmd.Parameters.Add ("@PJH", theCW_XJRJZ.PJH);
				cmd.Parameters.Add ("@ZY", theCW_XJRJZ.ZY);
				cmd.Parameters.Add ("@DFKM", theCW_XJRJZ.DFKM);
				cmd.Parameters.Add ("@PZH", theCW_XJRJZ.PZH);
				cmd.Parameters.Add ("@JFJE", theCW_XJRJZ.JFJE);
				cmd.Parameters.Add ("@DFJE", theCW_XJRJZ.DFJE);
				cmd.Parameters.Add ("@BZ", theCW_XJRJZ.BZ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_XJRJZ(CW_XJRJZ theCW_XJRJZ)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_XJRJZ對象
		/// </summary>
		/// <param name="theCW_XJRJZ">要更新的CW_XJRJZ對象</param>
		
		public bool UpdateCW_XJRJZ(System.Data.SqlClient.SqlConnection cn ,CW_XJRJZ theCW_XJRJZ)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
//				
				string sql;
				sql = "update CW_XJRJZ set KJND=@KJND, KJQJ=@KJQJ, JZRQ=@JZRQ, KJKM=@KJKM, PJH=@PJH, ZY=@ZY, DFKM=@DFKM, PZH=@PZH, JFJE=@JFJE, DFJE=@DFJE, BZ=@BZ where ";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@KJND", theCW_XJRJZ.KJND);
				cmd.Parameters.Add ("@KJQJ", theCW_XJRJZ.KJQJ);
				cmd.Parameters.Add ("@JZRQ", theCW_XJRJZ.JZRQ);
				cmd.Parameters.Add ("@KJKM", theCW_XJRJZ.KJKM);
				cmd.Parameters.Add ("@PJH", theCW_XJRJZ.PJH);
				cmd.Parameters.Add ("@ZY", theCW_XJRJZ.ZY);
				cmd.Parameters.Add ("@DFKM", theCW_XJRJZ.DFKM);
				cmd.Parameters.Add ("@PZH", theCW_XJRJZ.PZH);
				cmd.Parameters.Add ("@JFJE", theCW_XJRJZ.JFJE);
				cmd.Parameters.Add ("@DFJE", theCW_XJRJZ.DFJE);
				cmd.Parameters.Add ("@BZ", theCW_XJRJZ.BZ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_XJRJZ(CW_XJRJZ theCW_XJRJZ)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  刪除CW_XJRJZ對象
		/// </summary>
		
		public bool DelCW_XJRJZ(System.Data.SqlClient.SqlConnection cn )
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "delete from CW_XJRJZ where ";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_XJRJZ()");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根據主鍵標識獲得CW_XJRJZ對象
		/// </summary>
		
		public CW_XJRJZ GetCW_XJRJZ()
		{
			try
			{
				CW_XJRJZ result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_XJRJZ";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_XJRJZ();
					if (dr["KJND"] != null)
						if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
							result.KJND = (string)dr["KJND"];
					if (dr["KJQJ"] != null)
						if (!System.DBNull.Equals(dr["KJQJ"], System.DBNull.Value))
							result.KJQJ = (string)dr["KJQJ"];
					if (dr["JZRQ"] != null)
						if (!System.DBNull.Equals(dr["JZRQ"], System.DBNull.Value))
							result.JZRQ = (DateTime)dr["JZRQ"];
					if (dr["KJKM"] != null)
						if (!System.DBNull.Equals(dr["KJKM"], System.DBNull.Value))
							result.KJKM = (string)dr["KJKM"];
					if (dr["PJH"] != null)
						if (!System.DBNull.Equals(dr["PJH"], System.DBNull.Value))
							result.PJH = (string)dr["PJH"];
					if (dr["ZY"] != null)
						if (!System.DBNull.Equals(dr["ZY"], System.DBNull.Value))
							result.ZY = (string)dr["ZY"];
					if (dr["DFKM"] != null)
						if (!System.DBNull.Equals(dr["DFKM"], System.DBNull.Value))
							result.DFKM = (string)dr["DFKM"];
					if (dr["PZH"] != null)
						if (!System.DBNull.Equals(dr["PZH"], System.DBNull.Value))
							result.PZH = (string)dr["PZH"];
					if (dr["JFJE"] != null)
						if (!System.DBNull.Equals(dr["JFJE"], System.DBNull.Value))
							result.JFJE = (double)dr["JFJE"];
					if (dr["DFJE"] != null)
						if (!System.DBNull.Equals(dr["DFJE"], System.DBNull.Value))
							result.DFJE = (double)dr["DFJE"];
					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_XJRJZ()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_XJRJZ對象
		/// </summary>
	
		public ArrayList FindCW_XJRJZ()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_XJRJZ";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_XJRJZ obj = new CW_XJRJZ();
					if (dr["KJND"] != null)
						if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
							obj.KJND = (string)dr["KJND"];
					if (dr["KJQJ"] != null)
						if (!System.DBNull.Equals(dr["KJQJ"], System.DBNull.Value))
							obj.KJQJ = (string)dr["KJQJ"];
					if (dr["JZRQ"] != null)
						if (!System.DBNull.Equals(dr["JZRQ"], System.DBNull.Value))
							obj.JZRQ = (DateTime)dr["JZRQ"];
					if (dr["KJKM"] != null)
						if (!System.DBNull.Equals(dr["KJKM"], System.DBNull.Value))
							obj.KJKM = (string)dr["KJKM"];
					if (dr["PJH"] != null)
						if (!System.DBNull.Equals(dr["PJH"], System.DBNull.Value))
							obj.PJH = (string)dr["PJH"];
					if (dr["ZY"] != null)
						if (!System.DBNull.Equals(dr["ZY"], System.DBNull.Value))
							obj.ZY = (string)dr["ZY"];
					if (dr["DFKM"] != null)
						if (!System.DBNull.Equals(dr["DFKM"], System.DBNull.Value))
							obj.DFKM = (string)dr["DFKM"];
					if (dr["PZH"] != null)
						if (!System.DBNull.Equals(dr["PZH"], System.DBNull.Value))
							obj.PZH = (string)dr["PZH"];
					if (dr["JFJE"] != null)
						if (!System.DBNull.Equals(dr["JFJE"], System.DBNull.Value))
							obj.JFJE = (double)dr["JFJE"];
					if (dr["DFJE"] != null)
						if (!System.DBNull.Equals(dr["DFJE"], System.DBNull.Value))
							obj.DFJE = (double)dr["DFJE"];
					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_XJRJZ()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
	
	}
}