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

namespace Com.Ascs.Plp.CW
{
	/// <summary>
	///  對象CW_PZXM的定義
	///  根據表 CW_PZXM
	/// </summary>
	
	public class CW_PZXM
	{
		/// <summary>
		/// 對象CW_PZXM的構造函數
		/// </summary>
		public CW_PZXM()
		{
			m_PZBH = "";
			m_XH = 0;
			m_KJND = "";
			m_KJQJ = "";
			m_JGDM = "";
			m_ZY = "";
			m_KJKM = "";
			m_JFJE = 0;
			m_DFJE = 0;
			m_BMBH = "";
			m_YGBH = "";
			m_WLHLX = "";
			m_WLHBM = "";
			m_BZ = "";
		}
		
		private string m_PZBH;
		private int m_XH;
		private string m_KJND;
		private string m_KJQJ;
		private string m_JGDM;
		private string m_ZY;
		private string m_KJKM;
		private decimal m_JFJE;
		private decimal m_DFJE;
		private string m_BMBH;
		private string m_YGBH;
		private string m_WLHLX;
		private string m_WLHBM;
		private string m_BZ;
		
		/// <summary>
		/// 屬性 PZBH
		/// </summary>
		public string PZBH
		{
			get
			{
				return m_PZBH;
			}
			set
			{
				m_PZBH = value;
			}
		}
		
		/// <summary>
		/// 屬性 XH
		/// </summary>
		public int XH
		{
			get
			{
				return m_XH;
			}
			set
			{
				m_XH = value;
			}
		}
		
		/// <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>
		/// 屬性 JGDM
		/// </summary>
		public string JGDM
		{
			get
			{
				return m_JGDM;
			}
			set
			{
				m_JGDM = value;
			}
		}
		
		/// <summary>
		/// 屬性 ZY
		/// </summary>
		public string ZY
		{
			get
			{
				return m_ZY;
			}
			set
			{
				m_ZY = value;
			}
		}
		
		/// <summary>
		/// 屬性 KJKM
		/// </summary>
		public string KJKM
		{
			get
			{
				return m_KJKM;
			}
			set
			{
				m_KJKM = value;
			}
		}
		
		/// <summary>
		/// 屬性 JFJE
		/// </summary>
		public decimal JFJE
		{
			get
			{
				return m_JFJE;
			}
			set
			{
				m_JFJE = value;
			}
		}
		
		/// <summary>
		/// 屬性 DFJE
		/// </summary>
		public decimal DFJE
		{
			get
			{
				return m_DFJE;
			}
			set
			{
				m_DFJE = 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>
		/// 屬性 WLHLX
		/// </summary>
		public string WLHLX
		{
			get
			{
				return m_WLHLX;
			}
			set
			{
				m_WLHLX = value;
			}
		}
		
		/// <summary>
		/// 屬性 WLHBM
		/// </summary>
		public string WLHBM
		{
			get
			{
				return m_WLHBM;
			}
			set
			{
				m_WLHBM = value;
			}
		}
		
		/// <summary>
		/// 屬性 BZ
		/// </summary>
		public string BZ
		{
			get
			{
				return m_BZ;
			}
			set
			{
				m_BZ = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 實現對 CW_PZXM對象的管理
	/// </summary>
	
	public class CW_PZXMMgr
	{
		/// <summary>
		///  添加新的CW_PZXM對象
		/// </summary>
		/// <param name="theCW_PZXM">要添加的CW_PZXM對象</param>
		
		public bool AddCW_PZXM(SqlCommand cmd,CW_PZXM theCW_PZXM)
		{
			try
			{
				string sql;
				sql = "insert into CW_PZXM (PZBH, KJND, KJQJ, JGDM, ZY, KJKM, JFJE, DFJE, BMBH, YGBH, WLHLX, WLHBM, BZ) values (@PZBH, @KJND, @KJQJ, @JGDM, @ZY, @KJKM, @JFJE, @DFJE, @BMBH, @YGBH, @WLHLX, @WLHBM, @BZ)";
				cmd.CommandText=sql;
				cmd.Parameters.Clear();
				cmd.Parameters.Add ("@PZBH", theCW_PZXM.PZBH);
				cmd.Parameters.Add ("@KJND", theCW_PZXM.KJND);
				cmd.Parameters.Add ("@KJQJ", theCW_PZXM.KJQJ);
				cmd.Parameters.Add ("@JGDM", theCW_PZXM.JGDM);
				cmd.Parameters.Add ("@ZY", theCW_PZXM.ZY);
				cmd.Parameters.Add ("@KJKM", theCW_PZXM.KJKM);
				if(theCW_PZXM.JFJE!=0)
				{
					cmd.Parameters.Add ("@JFJE", theCW_PZXM.JFJE);
				}
				else
				{
					cmd.Parameters.Add("@JFJE",SqlDbType.Decimal);
					cmd.Parameters["@JFJE"].Value=DBNull.Value;
				}
				if(theCW_PZXM.DFJE!=0)
				{
					cmd.Parameters.Add ("@DFJE", theCW_PZXM.DFJE);
				}
				else
				{
					cmd.Parameters.Add("@DFJE",SqlDbType.Decimal);
					cmd.Parameters["@DFJE"].Value=DBNull.Value;
				}
				if(theCW_PZXM.BMBH ==null || theCW_PZXM.BMBH =="")
					cmd.Parameters.Add ("@BMBH", DBNull.Value);
				else
					cmd.Parameters.Add ("@BMBH", theCW_PZXM.BMBH);

				if(theCW_PZXM.YGBH ==null || theCW_PZXM.YGBH =="")
					cmd.Parameters.Add ("@YGBH", DBNull.Value);
				else
					cmd.Parameters.Add ("@YGBH", theCW_PZXM.YGBH);
				cmd.Parameters.Add ("@WLHLX", theCW_PZXM.WLHLX);
				cmd.Parameters.Add ("@WLHBM", theCW_PZXM.WLHBM);
				cmd.Parameters.Add ("@BZ", theCW_PZXM.BZ);
				
				cmd.ExecuteNonQuery();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_PZXM(CW_PZXM theCW_PZXM)");
				LogService.Write (e.Message);
				return false;
			}
		}


		/// <summary>
		///  更新CW_PZXM對象
		/// </summary>
		/// <param name="theCW_PZXM">要更新的CW_PZXM對象</param>
		
		public bool UpdateCW_PZXM(SqlCommand cmd,CW_PZXM theCW_PZXM)
		{
			try
			{
				
				string sql;
				sql = "update CW_PZXM set ZY=@ZY, KJKM=@KJKM, JFJE=@JFJE, DFJE=@DFJE, BMBH=@BMBH, YGBH=@YGBH, WLHLX=@WLHLX, WLHBM=@WLHBM, BZ=@BZ where PZBH=@PZBH and XH=@XH and KJND=@KJND and KJQJ=@KJQJ and JGDM=@JGDM";
				cmd.CommandText =sql;
				cmd.Parameters.Clear();
				cmd.Parameters.Add ("@PZBH", theCW_PZXM.PZBH);
				cmd.Parameters.Add ("@XH", theCW_PZXM.XH);
				cmd.Parameters.Add ("@KJND", theCW_PZXM.KJND);
				cmd.Parameters.Add ("@KJQJ", theCW_PZXM.KJQJ);
				cmd.Parameters.Add ("@JGDM", theCW_PZXM.JGDM);
				cmd.Parameters.Add ("@ZY", theCW_PZXM.ZY);
				cmd.Parameters.Add ("@KJKM", theCW_PZXM.KJKM);
				if(theCW_PZXM.JFJE!=0)
				{
					cmd.Parameters.Add ("@JFJE", theCW_PZXM.JFJE);
				}
				else
				{
					cmd.Parameters.Add("@JFJE",SqlDbType.Decimal);
					cmd.Parameters["@JFJE"].Value=DBNull.Value;
				}
				if(theCW_PZXM.DFJE!=0)
				{
					cmd.Parameters.Add ("@DFJE", theCW_PZXM.DFJE);
				}
				else
				{
					cmd.Parameters.Add("@DFJE",SqlDbType.Decimal);
					cmd.Parameters["@DFJE"].Value=DBNull.Value;
				}
				if(theCW_PZXM.BMBH ==null || theCW_PZXM.BMBH =="")
					cmd.Parameters.Add ("@BMBH", DBNull.Value);
				else
					cmd.Parameters.Add ("@BMBH", theCW_PZXM.BMBH);

				if(theCW_PZXM.YGBH ==null || theCW_PZXM.YGBH =="")
					cmd.Parameters.Add ("@YGBH", DBNull.Value);
				else
					cmd.Parameters.Add ("@YGBH", theCW_PZXM.YGBH);
				cmd.Parameters.Add ("@WLHLX", theCW_PZXM.WLHLX);
				cmd.Parameters.Add ("@WLHBM", theCW_PZXM.WLHBM);
				cmd.Parameters.Add ("@BZ", theCW_PZXM.BZ);
				
				cmd.ExecuteNonQuery();
				
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_PZXM(CW_PZXM theCW_PZXM)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  刪除CW_PZXM對象
		/// </summary>
		/// <param name="PZBH">主鍵</param>
		/// <param name="XH">主鍵</param>
		/// <param name="KJND">主鍵</param>
		/// <param name="KJQJ">主鍵</param>
		/// <param name="JGDM">主鍵</param>
		
		public bool DelCW_PZXM(SqlCommand cmd,string PZBH, string KJND, string KJQJ, string JGDM,int XH)
		{
			try
			{
				string sql;
				sql = "delete from CW_PZXM where PZBH=@PZBH and XH=@XH and KJND=@KJND and KJQJ=@KJQJ and JGDM=@JGDM";
				cmd.CommandText = sql;
				cmd.Parameters.Clear();
				cmd.Parameters.Add ("@PZBH", PZBH);
				cmd.Parameters.Add ("@XH", XH);
				cmd.Parameters.Add ("@KJND", KJND);
				cmd.Parameters.Add ("@KJQJ", KJQJ);
				cmd.Parameters.Add ("@JGDM", JGDM);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_PZXM(string PZBH, int XH, string KJND, string KJQJ, string JGDM)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根據主鍵標識獲得CW_PZXM對象
		/// </summary>
		/// <param name="PZBH">主鍵</param>
		/// <param name="XH">主鍵</param>
		/// <param name="KJND">主鍵</param>
		/// <param name="KJQJ">主鍵</param>
		/// <param name="JGDM">主鍵</param>
		
		public CW_PZXM GetCW_PZXM(string PZBH, int XH, string KJND, string KJQJ, string JGDM)
		{
			try
			{
				CW_PZXM result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_PZXM where PZBH=@PZBH and XH=@XH and KJND=@KJND and KJQJ=@KJQJ and JGDM=@JGDM";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@PZBH", PZBH);
				cmd.Parameters.Add ("@XH", XH);
				cmd.Parameters.Add ("@KJND", KJND);
				cmd.Parameters.Add ("@KJQJ", KJQJ);
				cmd.Parameters.Add ("@JGDM", JGDM);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_PZXM();
					if (dr["PZBH"] != null)
						if (!System.DBNull.Equals(dr["PZBH"], System.DBNull.Value))
							result.PZBH = (string)dr["PZBH"];
					if (dr["XH"] != null)
						if (!System.DBNull.Equals(dr["XH"], System.DBNull.Value))
							result.XH = (int)dr["XH"];
					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["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							result.JGDM = (string)dr["JGDM"];
					if (dr["ZY"] != null)
						if (!System.DBNull.Equals(dr["ZY"], System.DBNull.Value))
							result.ZY = (string)dr["ZY"];
					if (dr["KJKM"] != null)
						if (!System.DBNull.Equals(dr["KJKM"], System.DBNull.Value))
							result.KJKM = (string)dr["KJKM"];
					if (dr["JFJE"] != null)
						if (!System.DBNull.Equals(dr["JFJE"], System.DBNull.Value))
							result.JFJE = (decimal)dr["JFJE"];
					if (dr["DFJE"] != null)
						if (!System.DBNull.Equals(dr["DFJE"], System.DBNull.Value))
							result.DFJE = (decimal)dr["DFJE"];
					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["WLHLX"] != null)
						if (!System.DBNull.Equals(dr["WLHLX"], System.DBNull.Value))
							result.WLHLX = (string)dr["WLHLX"];
					if (dr["WLHBM"] != null)
						if (!System.DBNull.Equals(dr["WLHBM"], System.DBNull.Value))
							result.WLHBM = (string)dr["WLHBM"];
					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_PZXM(string PZBH, int XH, string KJND, string KJQJ, string JGDM)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_PZXM對象
		/// </summary>
	
		public ArrayList FindCW_PZXM()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_PZXM";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_PZXM obj = new CW_PZXM();
					if (dr["PZBH"] != null)
						if (!System.DBNull.Equals(dr["PZBH"], System.DBNull.Value))
							obj.PZBH = (string)dr["PZBH"];
					if (dr["XH"] != null)
						if (!System.DBNull.Equals(dr["XH"], System.DBNull.Value))
							obj.XH = (int)dr["XH"];
					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["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							obj.JGDM = (string)dr["JGDM"];
					if (dr["ZY"] != null)
						if (!System.DBNull.Equals(dr["ZY"], System.DBNull.Value))
							obj.ZY = (string)dr["ZY"];
					if (dr["KJKM"] != null)
						if (!System.DBNull.Equals(dr["KJKM"], System.DBNull.Value))
							obj.KJKM = (string)dr["KJKM"];
					if (dr["JFJE"] != null)
						if (!System.DBNull.Equals(dr["JFJE"], System.DBNull.Value))
							obj.JFJE = (decimal)dr["JFJE"];
					if (dr["DFJE"] != null)
						if (!System.DBNull.Equals(dr["DFJE"], System.DBNull.Value))
							obj.DFJE = (decimal)dr["DFJE"];
					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["WLHLX"] != null)
						if (!System.DBNull.Equals(dr["WLHLX"], System.DBNull.Value))
							obj.WLHLX = (string)dr["WLHLX"];
					if (dr["WLHBM"] != null)
						if (!System.DBNull.Equals(dr["WLHBM"], System.DBNull.Value))
							obj.WLHBM = (string)dr["WLHBM"];
					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_PZXM()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		public string GetYJKMCD()
		{
			string YJKMCD="NULL";
			string sql=string.Format("select CD from CW_KJKMJB where KMJB='1'");
			SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			SqlCommand cmd=new SqlCommand(sql,cn);
			cn.Open();
			SqlDataReader dr=cmd.ExecuteReader();
			if(dr.Read())
			{
				YJKMCD=dr["CD"].ToString();
			}
			cn.Close();
			return YJKMCD;
		}
	}
}