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

namespace Com.Ascs.Plp.CW
{
	/// <summary>
	///  對象CW_FYCBXM的定義
	///  根據表 CW_FYCBXM
	/// </summary>
	
	public class CW_FYCBXM
	{
		/// <summary>
		/// 對象CW_FYCBXM的構造函數
		/// </summary>
		public CW_FYCBXM()
		{
			m_FYCBDH = "";
			m_XH = 0;
			m_KJKM = "";
			m_FSRQ = DateTime.Now;
			m_FYJE = 0;
			m_BMBH = null;
			m_YGBH = null;
			m_BZ = "";
		}
		
		private string m_FYCBDH;
		private int m_XH;
		private string m_KJKM;
		private DateTime m_FSRQ;
		private double m_FYJE;
		private string m_BMBH;
		private string m_YGBH;
		private string m_BZ;
		
		/// <summary>
		/// 屬性 FYCBDH
		/// </summary>
		public string FYCBDH
		{
			get
			{
				return m_FYCBDH;
			}
			set
			{
				m_FYCBDH = value;
			}
		}
		
		/// <summary>
		/// 屬性 XH
		/// </summary>
		public int XH
		{
			get
			{
				return m_XH;
			}
			set
			{
				m_XH = value;
			}
		}
		
		/// <summary>
		/// 屬性 KJKM
		/// </summary>
		public string KJKM
		{
			get
			{
				return m_KJKM;
			}
			set
			{
				m_KJKM = value;
			}
		}
		
		/// <summary>
		/// 屬性 FSRQ
		/// </summary>
		public DateTime FSRQ
		{
			get
			{
				return m_FSRQ;
			}
			set
			{
				m_FSRQ = value;
			}
		}
		
		/// <summary>
		/// 屬性 FYJE
		/// </summary>
		public double FYJE
		{
			get
			{
				return m_FYJE;
			}
			set
			{
				m_FYJE = value;
			}
		}
		
		/// <summary>
		/// 屬性 BMBH
		/// </summary>
		public string BMBH
		{
			get
			{
				return m_BMBH;
			}
			set
			{
				m_BMBH = value;
			}
		}
		
		/// <summary>
		/// 屬性 YGBH
		/// </summary>
		public string YGBH
		{
			get
			{
				return m_YGBH;
			}
			set
			{
				m_YGBH = value;
			}
		}
		
		/// <summary>
		/// 屬性 BZ
		/// </summary>
		public string BZ
		{
			get
			{
				return m_BZ;
			}
			set
			{
				m_BZ = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 實現對 CW_FYCBXM對象的管理
	/// </summary>
	
	public class CW_FYCBXMMgr
	{
		/// <summary>
		///  添加新的CW_FYCBXM對象
		/// </summary>
		/// <param name="theCW_FYCBXM">要添加的CW_FYCBXM對象</param>
		
		public bool AddCW_FYCBXM(SqlConnection cn,CW_FYCBXM theCW_FYCBXM)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "insert into CW_FYCBXM (FYCBDH, XH, KJKM, FSRQ, FYJE, BMBH, YGBH, BZ) values (@FYCBDH, @XH, @KJKM, @FSRQ, @FYJE, @BMBH, @YGBH, @BZ)";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@FYCBDH", theCW_FYCBXM.FYCBDH);
				cmd.Parameters.Add ("@XH", theCW_FYCBXM.XH);
				cmd.Parameters.Add ("@KJKM", theCW_FYCBXM.KJKM);
				cmd.Parameters.Add ("@FSRQ", theCW_FYCBXM.FSRQ);
				cmd.Parameters.Add ("@FYJE", theCW_FYCBXM.FYJE);				
				if(theCW_FYCBXM.BMBH==null || theCW_FYCBXM.BMBH=="")
					cmd.Parameters.Add ("@BMBH", DBNull.Value);
				else
					cmd.Parameters.Add ("@BMBH", theCW_FYCBXM.BMBH);
				if(theCW_FYCBXM.YGBH==null || theCW_FYCBXM.YGBH=="")
					cmd.Parameters.Add ("@YGBH", DBNull.Value);
				else
					cmd.Parameters.Add ("@YGBH", theCW_FYCBXM.YGBH);
				cmd.Parameters.Add ("@BZ", theCW_FYCBXM.BZ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_FYCBXM(CW_FYCBXM theCW_FYCBXM)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_FYCBXM對象
		/// </summary>
		/// <param name="theCW_FYCBXM">要更新的CW_FYCBXM對象</param>
		
		public bool UpdateCW_FYCBXM(SqlConnection cn,CW_FYCBXM theCW_FYCBXM)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "update CW_FYCBXM set KJKM=@KJKM, FSRQ=@FSRQ, FYJE=@FYJE, BMBH=@BMBH, YGBH=@YGBH, BZ=@BZ where FYCBDH=@FYCBDH and XH=@XH";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@FYCBDH", theCW_FYCBXM.FYCBDH);
				cmd.Parameters.Add ("@XH", theCW_FYCBXM.XH);
				cmd.Parameters.Add ("@KJKM", theCW_FYCBXM.KJKM);
				cmd.Parameters.Add ("@FSRQ", theCW_FYCBXM.FSRQ);
				cmd.Parameters.Add ("@FYJE", theCW_FYCBXM.FYJE);
				if(theCW_FYCBXM.BMBH==null || theCW_FYCBXM.BMBH=="")
					cmd.Parameters.Add ("@BMBH", DBNull.Value);
				else
					cmd.Parameters.Add ("@BMBH", theCW_FYCBXM.BMBH);
				if(theCW_FYCBXM.YGBH==null || theCW_FYCBXM.YGBH=="")
					cmd.Parameters.Add ("@YGBH", DBNull.Value);
				else
					cmd.Parameters.Add ("@YGBH", theCW_FYCBXM.YGBH);
				cmd.Parameters.Add ("@BZ", theCW_FYCBXM.BZ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_FYCBXM(CW_FYCBXM theCW_FYCBXM)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  刪除CW_FYCBXM對象
		/// </summary>
		/// <param name="FYCBDH">主鍵</param>
		/// <param name="XH">主鍵</param>
		
		public bool DelCW_FYCBXM(SqlConnection cn,string FYCBDH, int XH)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "delete from CW_FYCBXM where FYCBDH=@FYCBDH and XH=@XH";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@FYCBDH", FYCBDH);
				cmd.Parameters.Add ("@XH", XH);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_FYCBXM(string FYCBDH, int XH)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根據主鍵標識獲得CW_FYCBXM對象
		/// </summary>
		/// <param name="FYCBDH">主鍵</param>
		/// <param name="XH">主鍵</param>
		
		public CW_FYCBXM GetCW_FYCBXM(string FYCBDH, int XH)
		{
			try
			{
				CW_FYCBXM result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_FYCBXM where FYCBDH=@FYCBDH and XH=@XH";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@FYCBDH", FYCBDH);
				cmd.Parameters.Add ("@XH", XH);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_FYCBXM();
					if (dr["FYCBDH"] != null)
						if (!System.DBNull.Equals(dr["FYCBDH"], System.DBNull.Value))
							result.FYCBDH = (string)dr["FYCBDH"];
					if (dr["XH"] != null)
						if (!System.DBNull.Equals(dr["XH"], System.DBNull.Value))
							result.XH = (int)dr["XH"];
					if (dr["KJKM"] != null)
						if (!System.DBNull.Equals(dr["KJKM"], System.DBNull.Value))
							result.KJKM = (string)dr["KJKM"];
					if (dr["FSRQ"] != null)
						if (!System.DBNull.Equals(dr["FSRQ"], System.DBNull.Value))
							result.FSRQ = (DateTime)dr["FSRQ"];
					if (dr["FYJE"] != null)
						if (!System.DBNull.Equals(dr["FYJE"], System.DBNull.Value))
							result.FYJE = (double)dr["FYJE"];
					if (dr["BMBH"] != null)
						if (!System.DBNull.Equals(dr["BMBH"], System.DBNull.Value))
							result.BMBH = (string)dr["BMBH"];
					if (dr["YGBH"] != null)
						if (!System.DBNull.Equals(dr["YGBH"], System.DBNull.Value))
							result.YGBH = (string)dr["YGBH"];
					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_FYCBXM(string FYCBDH, int XH)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_FYCBXM對象
		/// </summary>
	
		public ArrayList FindCW_FYCBXM()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_FYCBXM";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_FYCBXM obj = new CW_FYCBXM();
					if (dr["FYCBDH"] != null)
						if (!System.DBNull.Equals(dr["FYCBDH"], System.DBNull.Value))
							obj.FYCBDH = (string)dr["FYCBDH"];
					if (dr["XH"] != null)
						if (!System.DBNull.Equals(dr["XH"], System.DBNull.Value))
							obj.XH = (int)dr["XH"];
					if (dr["KJKM"] != null)
						if (!System.DBNull.Equals(dr["KJKM"], System.DBNull.Value))
							obj.KJKM = (string)dr["KJKM"];
					if (dr["FSRQ"] != null)
						if (!System.DBNull.Equals(dr["FSRQ"], System.DBNull.Value))
							obj.FSRQ = (DateTime)dr["FSRQ"];
					if (dr["FYJE"] != null)
						if (!System.DBNull.Equals(dr["FYJE"], System.DBNull.Value))
							obj.FYJE = (double)dr["FYJE"];
					if (dr["BMBH"] != null)
						if (!System.DBNull.Equals(dr["BMBH"], System.DBNull.Value))
							obj.BMBH = (string)dr["BMBH"];
					if (dr["YGBH"] != null)
						if (!System.DBNull.Equals(dr["YGBH"], System.DBNull.Value))
							obj.YGBH = (string)dr["YGBH"];
					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_FYCBXM()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
	
	}
}