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

namespace Com.Ascs.Plp.CW
{
	/// <summary>
	///  對象CW_PZ的定義
	///  根據表 CW_PZ
	/// </summary>
	
	public class CW_PZ
	{
		/// <summary>
		/// 對象CW_PZ的構造函數
		/// </summary>
		public CW_PZ()
		{
			m_PZBH = "";
			m_KJND = "";
			m_KJQJ = "";
			m_JGDM = "";
			m_PZLX = "";
			m_FDS = 0;
			m_YSPJLX = 0;
			m_YSPJBH = "";
			m_ZDR = "";
			m_ZDRQ = DateTime.Now;
			m_SHR = "";
			m_SHRQ = Convert.ToDateTime("1900-01-01");
			m_CNR = "";
			m_CNRQ = Convert.ToDateTime("1900-01-01");
			m_GZR = "";
			m_GZRQ = Convert.ToDateTime("1900-01-01");
			m_GZBJ = "0";
			m_KGLBJ = "0";
			m_DCBJ = "0";
			m_DCBH = "";
			m_BZ = "";
		}
		
		private string m_PZBH;
		private string m_KJND;
		private string m_KJQJ;
		private string m_JGDM;
		private string m_PZLX;
		private int m_FDS;
		private int m_YSPJLX;
		private string m_YSPJBH;
		private string m_ZDR;
		private DateTime m_ZDRQ;
		private string m_SHR;
		private DateTime m_SHRQ;
		private string m_CNR;
		private DateTime m_CNRQ;
		private string m_GZR;
		private DateTime m_GZRQ;
		private string m_GZBJ;
		private string m_KGLBJ;
		private string m_DCBJ;
		private string m_DCBH;
		private string m_BZ;
		
		/// <summary>
		/// 屬性 PZBH
		/// </summary>
		public string PZBH
		{
			get
			{
				return m_PZBH;
			}
			set
			{
				m_PZBH = 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>
		/// 屬性 PZLX
		/// </summary>
		public string PZLX
		{
			get
			{
				return m_PZLX;
			}
			set
			{
				m_PZLX = value;
			}
		}
		
		/// <summary>
		/// 屬性 FDS
		/// </summary>
		public int FDS
		{
			get
			{
				return m_FDS;
			}
			set
			{
				m_FDS = value;
			}
		}
		
		/// <summary>
		/// 屬性 YSPJLX
		/// </summary>
		public int YSPJLX
		{
			get
			{
				return m_YSPJLX;
			}
			set
			{
				m_YSPJLX = value;
			}
		}
		
		/// <summary>
		/// 屬性 YSPJBH
		/// </summary>
		public string YSPJBH
		{
			get
			{
				return m_YSPJBH;
			}
			set
			{
				m_YSPJBH = value;
			}
		}
		
		/// <summary>
		/// 屬性 ZDR
		/// </summary>
		public string ZDR
		{
			get
			{
				return m_ZDR;
			}
			set
			{
				m_ZDR = value;
			}
		}
		
		/// <summary>
		/// 屬性 ZDRQ
		/// </summary>
		public DateTime ZDRQ
		{
			get
			{
				return m_ZDRQ;
			}
			set
			{
				m_ZDRQ = value;
			}
		}
		
		/// <summary>
		/// 屬性 SHR
		/// </summary>
		public string SHR
		{
			get
			{
				return m_SHR;
			}
			set
			{
				m_SHR = value;
			}
		}
		
		/// <summary>
		/// 屬性 SHRQ
		/// </summary>
		public DateTime SHRQ
		{
			get
			{
				return m_SHRQ;
			}
			set
			{
				m_SHRQ = value;
			}
		}
		
		/// <summary>
		/// 屬性 CNR
		/// </summary>
		public string CNR
		{
			get
			{
				return m_CNR;
			}
			set
			{
				m_CNR = value;
			}
		}
		
		/// <summary>
		/// 屬性 CNRQ
		/// </summary>
		public DateTime CNRQ
		{
			get
			{
				return m_CNRQ;
			}
			set
			{
				m_CNRQ = value;
			}
		}
		
		/// <summary>
		/// 屬性 GZR
		/// </summary>
		public string GZR
		{
			get
			{
				return m_GZR;
			}
			set
			{
				m_GZR = value;
			}
		}
		
		/// <summary>
		/// 屬性 GZRQ
		/// </summary>
		public DateTime GZRQ
		{
			get
			{
				return m_GZRQ;
			}
			set
			{
				m_GZRQ = value;
			}
		}
		
		/// <summary>
		/// 屬性 GZBJ
		/// </summary>
		public string GZBJ
		{
			get
			{
				return m_GZBJ;
			}
			set
			{
				m_GZBJ = value;
			}
		}
		
		/// <summary>
		/// 屬性 KGLBJ
		/// </summary>
		public string KGLBJ
		{
			get
			{
				return m_KGLBJ;
			}
			set
			{
				m_KGLBJ = value;
			}
		}
		
		/// <summary>
		/// 屬性 DCBJ
		/// </summary>
		public string DCBJ
		{
			get
			{
				return m_DCBJ;
			}
			set
			{
				m_DCBJ = value;
			}
		}
		
		/// <summary>
		/// 屬性 DCBH
		/// </summary>
		public string DCBH
		{
			get
			{
				return m_DCBH;
			}
			set
			{
				m_DCBH = value;
			}
		}
		
		/// <summary>
		/// 屬性 BZ
		/// </summary>
		public string BZ
		{
			get
			{
				return m_BZ;
			}
			set
			{
				m_BZ = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 實現對 CW_PZ對象的管理
	/// </summary>
	
	public class CW_PZMgr
	{
		/// <summary>
		///  添加新的CW_PZ對象
		/// </summary>
		/// <param name="theCW_PZ">要添加的CW_PZ對象</param>
		
		public bool AddCW_PZ(SqlCommand cmd,CW_PZ theCW_PZ)
		{
			try
			{
				string sql;
				sql = "insert into CW_PZ (PZBH, KJND, KJQJ, JGDM, PZLX, FDS, YSPJLX, YSPJBH, ZDR, ZDRQ, SHR, SHRQ, CNR, CNRQ, GZR, GZRQ, GZBJ, KGLBJ, DCBJ, DCBH, BZ) values (@PZBH, @KJND, @KJQJ, @JGDM, @PZLX, @FDS, @YSPJLX, @YSPJBH, @ZDR, @ZDRQ, @SHR, @SHRQ, @CNR, @CNRQ, @GZR, @GZRQ, @GZBJ, @KGLBJ, @DCBJ, @DCBH, @BZ)";
				cmd.CommandText=sql;
				cmd.Parameters.Clear();
				cmd.Parameters.Add ("@PZBH", theCW_PZ.PZBH);
				cmd.Parameters.Add ("@KJND", theCW_PZ.KJND);
				cmd.Parameters.Add ("@KJQJ", theCW_PZ.KJQJ);
				cmd.Parameters.Add ("@JGDM", theCW_PZ.JGDM);
				cmd.Parameters.Add ("@PZLX", theCW_PZ.PZLX);
				cmd.Parameters.Add ("@FDS", theCW_PZ.FDS);
				cmd.Parameters.Add ("@YSPJLX", theCW_PZ.YSPJLX);
				cmd.Parameters.Add ("@YSPJBH", theCW_PZ.YSPJBH);
				cmd.Parameters.Add ("@ZDR", theCW_PZ.ZDR);
				cmd.Parameters.Add ("@ZDRQ", theCW_PZ.ZDRQ);
				cmd.Parameters.Add ("@SHR", theCW_PZ.SHR);
				if(theCW_PZ.SHRQ==Convert.ToDateTime("1900-01-01"))
				{
					cmd.Parameters.Add ("@SHRQ",SqlDbType.DateTime);
					cmd.Parameters["@SHRQ"].Value=DBNull.Value;
				}
				else
				{
					cmd.Parameters.Add ("@SHRQ", theCW_PZ.SHRQ);
				}
				if(theCW_PZ.GZRQ==Convert.ToDateTime("1900-01-01"))
				{
					cmd.Parameters.Add ("@GZRQ",SqlDbType.DateTime);
					cmd.Parameters["@GZRQ"].Value=DBNull.Value;
				}
				else
				{
					cmd.Parameters.Add ("@GZRQ", theCW_PZ.GZRQ);
				}
				if(theCW_PZ.CNRQ==Convert.ToDateTime("1900-01-01"))
				{
					cmd.Parameters.Add ("@CNRQ",SqlDbType.DateTime);
					cmd.Parameters["@CNRQ"].Value=DBNull.Value;
				}
				else
				{
					cmd.Parameters.Add ("@CNRQ", theCW_PZ.CNRQ);
				}
				cmd.Parameters.Add ("@CNR", theCW_PZ.CNR);
				cmd.Parameters.Add ("@GZR", theCW_PZ.GZR);
				cmd.Parameters.Add ("@GZBJ", theCW_PZ.GZBJ);
				cmd.Parameters.Add ("@KGLBJ", theCW_PZ.KGLBJ);
				cmd.Parameters.Add ("@DCBJ", theCW_PZ.DCBJ);
				cmd.Parameters.Add ("@DCBH", theCW_PZ.DCBH);
				cmd.Parameters.Add ("@BZ", theCW_PZ.BZ);
				
				cmd.ExecuteNonQuery();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_PZ(CW_PZ theCW_PZ)");
				LogService.Write (e.Message);
				return false;
			}
		}

		
		/// <summary>
		/// 生成憑證編號
		/// </summary>
		/// <param name="cmd"></param>
		/// <param name="JGDM"></param>
		/// <param name="KJND"></param>