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

namespace Com.Ascs.Plp.CW
{
	/// <summary>
	///  對象CW_SKD的定義
	///  根據表 CW_SKD
	/// </summary>
	
	public class CW_SKD
	{
		/// <summary>
		/// 對象CW_SKD的構造函數
		/// </summary>
		public CW_SKD()
		{
			m_SKDH = "";
			m_JGDM = "";
			m_WLHLX = "";
			m_WLHBH = "";
			m_SKJE = 0;
			m_SKRQ = DateTime.Now;
			m_DJLX = 0;
			m_YSPZH = "";
			m_DZBJ = "";
			m_HBLX = "";
			m_HXJE = 0;
			m_ZDR = "";
			m_JBR = "";
			m_SHR = null;
			m_ZTBJ = "";
			m_GZBJ = "";
		}
		
		private string m_SKDH;
		private string m_JGDM;
		private string m_WLHLX;
		private string m_WLHBH;
		private double m_SKJE;
		private DateTime m_SKRQ;
		private int m_DJLX;
		private string m_YSPZH;
		private string m_DZBJ;
		private string m_HBLX;
		private double m_HXJE;
		private string m_ZDR;
		private string m_JBR;
		private string m_SHR;
		private string m_ZTBJ;
		private string m_GZBJ;
		
		/// <summary>
		/// 屬性 SKDH
		/// </summary>
		public string SKDH
		{
			get
			{
				return m_SKDH;
			}
			set
			{
				m_SKDH = value;
			}
		}
		
		/// <summary>
		/// 屬性 JGDM
		/// </summary>
		public string JGDM
		{
			get
			{
				return m_JGDM;
			}
			set
			{
				m_JGDM = value;
			}
		}
		
		/// <summary>
		/// 屬性 WLHLX
		/// </summary>
		public string WLHLX
		{
			get
			{
				return m_WLHLX;
			}
			set
			{
				m_WLHLX = value;
			}
		}
		
		/// <summary>
		/// 屬性 WLHBH
		/// </summary>
		public string WLHBH
		{
			get
			{
				return m_WLHBH;
			}
			set
			{
				m_WLHBH = value;
			}
		}
		
		/// <summary>
		/// 屬性 SKJE
		/// </summary>
		public double SKJE
		{
			get
			{
				return m_SKJE;
			}
			set
			{
				m_SKJE = value;
			}
		}
		
		/// <summary>
		/// 屬性 SKRQ
		/// </summary>
		public DateTime SKRQ
		{
			get
			{
				return m_SKRQ;
			}
			set
			{
				m_SKRQ = value;
			}
		}
		
		/// <summary>
		/// 屬性 DJLX
		/// </summary>
		public int DJLX
		{
			get
			{
				return m_DJLX;
			}
			set
			{
				m_DJLX = value;
			}
		}
		
		/// <summary>
		/// 屬性 YSPZH
		/// </summary>
		public string YSPZH
		{
			get
			{
				return m_YSPZH;
			}
			set
			{
				m_YSPZH = value;
			}
		}
		
		/// <summary>
		/// 屬性 DZBJ
		/// </summary>
		public string DZBJ
		{
			get
			{
				return m_DZBJ;
			}
			set
			{
				m_DZBJ = value;
			}
		}
		
		/// <summary>
		/// 屬性 HBLX
		/// </summary>
		public string HBLX
		{
			get
			{
				return m_HBLX;
			}
			set
			{
				m_HBLX = value;
			}
		}
		
		/// <summary>
		/// 屬性 HXJE
		/// </summary>
		public double HXJE
		{
			get
			{
				return m_HXJE;
			}
			set
			{
				m_HXJE = value;
			}
		}
		
		/// <summary>
		/// 屬性 ZDR
		/// </summary>
		public string ZDR
		{
			get
			{
				return m_ZDR;
			}
			set
			{
				m_ZDR = value;
			}
		}
		
		/// <summary>
		/// 屬性 JBR
		/// </summary>
		public string JBR
		{
			get
			{
				return m_JBR;
			}
			set
			{
				m_JBR = value;
			}
		}
		
		/// <summary>
		/// 屬性 SHR
		/// </summary>
		public string SHR
		{
			get
			{
				return m_SHR;
			}
			set
			{
				m_SHR = value;
			}
		}
		
		/// <summary>
		/// 屬性 ZTBJ
		/// </summary>
		public string ZTBJ
		{
			get
			{
				return m_ZTBJ;
			}
			set
			{
				m_ZTBJ = value;
			}
		}
		
		/// <summary>
		/// 屬性 GZBJ
		/// </summary>
		public string GZBJ
		{
			get
			{
				return m_GZBJ;
			}
			set
			{
				m_GZBJ = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 實現對 CW_SKD對象的管理
	/// </summary>
	
	public class CW_SKDMgr
	{
		/// <summary>
		///  添加新的CW_SKD對象
		/// </summary>
		/// <param name="theCW_SKD">要添加的CW_SKD對象</param>
		
		public bool AddCW_SKD(System.Data.SqlClient.SqlConnection cn ,CW_SKD theCW_SKD)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "insert into CW_SKD (SKDH, JGDM, WLHLX, WLHBH, SKJE, SKRQ, DJLX, YSPZH, DZBJ, HBLX, HXJE, ZDR, JBR, SHR, ZTBJ, GZBJ) values (@SKDH, @JGDM, @WLHLX, @WLHBH, @SKJE, @SKRQ, @DJLX, @YSPZH, @DZBJ, @HBLX, @HXJE, @ZDR, @JBR, @SHR, @ZTBJ, @GZBJ)";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@SKDH", theCW_SKD.SKDH);
				cmd.Parameters.Add ("@JGDM", theCW_SKD.JGDM);
				cmd.Parameters.Add ("@WLHLX", theCW_SKD.WLHLX);
				cmd.Parameters.Add ("@WLHBH", theCW_SKD.WLHBH);
				cmd.Parameters.Add ("@SKJE", theCW_SKD.SKJE);
				cmd.Parameters.Add ("@SKRQ", theCW_SKD.SKRQ);
				cmd.Parameters.Add ("@DJLX", theCW_SKD.DJLX);
				cmd.Parameters.Add ("@YSPZH", theCW_SKD.YSPZH);
				cmd.Parameters.Add ("@DZBJ", theCW_SKD.DZBJ);
				cmd.Parameters.Add ("@HBLX", theCW_SKD.HBLX);
				cmd.Parameters.Add ("@HXJE", theCW_SKD.HXJE);
				cmd.Parameters.Add ("@ZDR", theCW_SKD.ZDR);
				cmd.Parameters.Add ("@JBR", theCW_SKD.JBR);				
				if(theCW_SKD.SHR==null)
					cmd.Parameters.Add ("@SHR", DBNull.Value);
                else       
					cmd.Parameters.Add ("@SHR", theCW_SKD.SHR);
				cmd.Parameters.Add ("@ZTBJ", theCW_SKD.ZTBJ);
				cmd.Parameters.Add ("@GZBJ", theCW_SKD.GZBJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_SKD(CW_SKD theCW_SKD)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_SKD對象
		/// </summary>
		/// <param name="theCW_SKD">要更新的CW_SKD對象</param>
		
		public bool UpdateCW_SKD(System.Data.SqlClient.SqlConnection cn ,CW_SKD theCW_SKD)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "update CW_SKD set JGDM=@JGDM, WLHLX=@WLHLX, WLHBH=@WLHBH, SKJE=@SKJE, SKRQ=@SKRQ, DJLX=@DJLX, YSPZH=@YSPZH, DZBJ=@DZBJ, HBLX=@HBLX, HXJE=@HXJE, ZDR=@ZDR, JBR=@JBR, SHR=@SHR, ZTBJ=@ZTBJ, GZBJ=@GZBJ where SKDH=@SKDH";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@SKDH", theCW_SKD.SKDH);
				cmd.Parameters.Add ("@JGDM", theCW_SKD.JGDM);
				cmd.Parameters.Add ("@WLHLX", theCW_SKD.WLHLX);
				cmd.Parameters.Add ("@WLHBH", theCW_SKD.WLHBH);
				cmd.Parameters.Add ("@SKJE", theCW_SKD.SKJE);
				cmd.Parameters.Add ("@SKRQ", theCW_SKD.SKRQ);
				cmd.Parameters.Add ("@DJLX", theCW_SKD.DJLX);
				cmd.Parameters.Add ("@YSPZH", theCW_SKD.YSPZH);
				cmd.Parameters.Add ("@DZBJ", theCW_SKD.DZBJ);
				cmd.Parameters.Add ("@HBLX", theCW_SKD.HBLX);
				cmd.Parameters.Add ("@HXJE", theCW_SKD.HXJE);
				cmd.Parameters.Add ("@ZDR", theCW_SKD.ZDR);
				cmd.Parameters.Add ("@JBR", theCW_SKD.JBR);
				if(theCW_SKD.SHR==null)
					cmd.Parameters.Add ("@SHR", DBNull.Value);
				else       
					cmd.Parameters.Add ("@SHR", theCW_SKD.SHR);
				cmd.Parameters.Add ("@ZTBJ", theCW_SKD.ZTBJ);
				cmd.Parameters.Add ("@GZBJ", theCW_SKD.GZBJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_SKD(CW_SKD theCW_SKD)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  刪除CW_SKD對象
		/// </summary>
		/// <param name="SKDH">主鍵</param>
		
		public bool DelCW_SKD(System.Data.SqlClient.SqlConnection cn ,string SKDH)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				
				sql = "delete from CW_SKD where SKDH=@SKDH";
				
				SqlCommand  cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@SKDH", SKDH);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_SKD(string SKDH)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根據主鍵標識獲得CW_SKD對象
		/// </summary>
		/// <param name="SKDH">主鍵</param>
		
		public CW_SKD GetCW_SKD(string SKDH)
		{
			try
			{
				CW_SKD result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_SKD where SKDH=@SKDH";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@SKDH", SKDH);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_SKD();
					if (dr["SKDH"] != null)
						if (!System.DBNull.Equals(dr["SKDH"], System.DBNull.Value))
							result.SKDH = (string)dr["SKDH"];
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							result.JGDM = (string)dr["JGDM"];
					if (dr["WLHLX"] != null)
						if (!System.DBNull.Equals(dr["WLHLX"], System.DBNull.Value))
							result.WLHLX = (string)dr["WLHLX"];
					if (dr["WLHBH"] != null)
						if (!System.DBNull.Equals(dr["WLHBH"], System.DBNull.Value))
							result.WLHBH = (string)dr["WLHBH"];
					if (dr["SKJE"] != null)
						if (!System.DBNull.Equals(dr["SKJE"], System.DBNull.Value))
							result.SKJE = (double)dr["SKJE"];
					if (dr["SKRQ"] != null)
						if (!System.DBNull.Equals(dr["SKRQ"], System.DBNull.Value))
							result.SKRQ = (DateTime)dr["SKRQ"];
					if (dr["DJLX"] != null)
						if (!System.DBNull.Equals(dr["DJLX"], System.DBNull.Value))
							result.DJLX = (int)dr["DJLX"];
					if (dr["YSPZH"] != null)
						if (!System.DBNull.Equals(dr["YSPZH"], System.DBNull.Value))
							result.YSPZH = (string)dr["YSPZH"];
					if (dr["DZBJ"] != null)
						if (!System.DBNull.Equals(dr["DZBJ"], System.DBNull.Value))
							result.DZBJ = (string)dr["DZBJ"];
					if (dr["HBLX"] != null)
						if (!System.DBNull.Equals(dr["HBLX"], System.DBNull.Value))
							result.HBLX = (string)dr["HBLX"];
					if (dr["HXJE"] != null)
						if (!System.DBNull.Equals(dr["HXJE"], System.DBNull.Value))
							result.HXJE = (double)dr["HXJE"];
					if (dr["ZDR"] != null)
						if (!System.DBNull.Equals(dr["ZDR"], System.DBNull.Value))
							result.ZDR = (string)dr["ZDR"];
					if (dr["JBR"] != null)
						if (!System.DBNull.Equals(dr["JBR"], System.DBNull.Value))
							result.JBR = (string)dr["JBR"];
					if (dr["SHR"] != null)
						if (!System.DBNull.Equals(dr["SHR"], System.DBNull.Value))
							result.SHR = (string)dr["SHR"];
					if (dr["ZTBJ"] != null)
						if (!System.DBNull.Equals(dr["ZTBJ"], System.DBNull.Value))
							result.ZTBJ = (string)dr["ZTBJ"];
					if (dr["GZBJ"] != null)
						if (!System.DBNull.Equals(dr["GZBJ"], System.DBNull.Value))
							result.GZBJ = (string)dr["GZBJ"];
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("GetCW_SKD(string SKDH)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_SKD對象
		/// </summary>
	
		public ArrayList FindCW_SKD()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_SKD";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_SKD obj = new CW_SKD();
					if (dr["SKDH"] != null)
						if (!System.DBNull.Equals(dr["SKDH"], System.DBNull.Value))
							obj.SKDH = (string)dr["SKDH"];
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							obj.JGDM = (string)dr["JGDM"];
					if (dr["WLHLX"] != null)
						if (!System.DBNull.Equals(dr["WLHLX"], System.DBNull.Value))
							obj.WLHLX = (string)dr["WLHLX"];
					if (dr["WLHBH"] != null)
						if (!System.DBNull.Equals(dr["WLHBH"], System.DBNull.Value))
							obj.WLHBH = (string)dr["WLHBH"];
					if (dr["SKJE"] != null)
						if (!System.DBNull.Equals(dr["SKJE"], System.DBNull.Value))
							obj.SKJE = (double)dr["SKJE"];
					if (dr["SKRQ"] != null)
						if (!System.DBNull.Equals(dr["SKRQ"], System.DBNull.Value))
							obj.SKRQ = (DateTime)dr["SKRQ"];
					if (dr["DJLX"] != null)
						if (!System.DBNull.Equals(dr["DJLX"], System.DBNull.Value))
							obj.DJLX = (int)dr["DJLX"];
					if (dr["YSPZH"] != null)
						if (!System.DBNull.Equals(dr["YSPZH"], System.DBNull.Value))
							obj.YSPZH = (string)dr["YSPZH"];
					if (dr["DZBJ"] != null)
						if (!System.DBNull.Equals(dr["DZBJ"], System.DBNull.Value))
							obj.DZBJ = (string)dr["DZBJ"];
					if (dr["HBLX"] != null)
						if (!System.DBNull.Equals(dr["HBLX"], System.DBNull.Value))
							obj.HBLX = (string)dr["HBLX"];
					if (dr["HXJE"] != null)
						if (!System.DBNull.Equals(dr["HXJE"], System.DBNull.Value))
							obj.HXJE = (double)dr["HXJE"];
					if (dr["ZDR"] != null)
						if (!System.DBNull.Equals(dr["ZDR"], System.DBNull.Value))
							obj.ZDR = (string)dr["ZDR"];
					if (dr["JBR"] != null)
						if (!System.DBNull.Equals(dr["JBR"], System.DBNull.Value))
							obj.JBR = (string)dr["JBR"];
					if (dr["SHR"] != null)
						if (!System.DBNull.Equals(dr["SHR"], System.DBNull.Value))
							obj.SHR = (string)dr["SHR"];
					if (dr["ZTBJ"] != null)
						if (!System.DBNull.Equals(dr["ZTBJ"], System.DBNull.Value))
							obj.ZTBJ = (string)dr["ZTBJ"];
					if (dr["GZBJ"] != null)
						if (!System.DBNull.Equals(dr["GZBJ"], System.DBNull.Value))
							obj.GZBJ = (string)dr["GZBJ"];
					result.Add(obj);
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("FindCW_SKD()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
	
	}
}