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

namespace Com.Ascs.Plp.CW

{
	/// <summary>
	///  對(duì)象CW_FYCB的定義
	///  根據(jù)表 CW_FYCB
	/// </summary>
	
	public class CW_FYCB
	{
		/// <summary>
		/// 對(duì)象CW_FYCB的構(gòu)造函數(shù)
		/// </summary>
		public CW_FYCB()
		{
			m_FYCBDH = "";
			m_JGDM = "";
			m_JBR = "";
			m_ZFY = 0;
			m_CJR = "";
			m_CJSJ = DateTime.Now;
			m_XGR = "";
			m_XGSJ = DateTime.Now;
			m_ZTBJ = "";
			m_BZ = "";
			m_GZBJ = "";
		}
		
		private string m_FYCBDH;
		private string m_JGDM;
		private string m_JBR;
		private double m_ZFY;
		private string m_CJR;
		private DateTime m_CJSJ;
		private string m_XGR;
		private DateTime m_XGSJ;
		private string m_ZTBJ;
		private string m_BZ;
		private string m_GZBJ;
		
		/// <summary>
		/// 屬性 FYCBDH
		/// </summary>
		public string FYCBDH
		{
			get
			{
				return m_FYCBDH;
			}
			set
			{
				m_FYCBDH = value;
			}
		}
		
		/// <summary>
		/// 屬性 JGDM
		/// </summary>
		public string JGDM
		{
			get
			{
				return m_JGDM;
			}
			set
			{
				m_JGDM = value;
			}
		}
		
		/// <summary>
		/// 屬性 JBR
		/// </summary>
		public string JBR
		{
			get
			{
				return m_JBR;
			}
			set
			{
				m_JBR = value;
			}
		}
		
		/// <summary>
		/// 屬性 ZFY
		/// </summary>
		public double ZFY
		{
			get
			{
				return m_ZFY;
			}
			set
			{
				m_ZFY = value;
			}
		}
		
		/// <summary>
		/// 屬性 CJR
		/// </summary>
		public string CJR
		{
			get
			{
				return m_CJR;
			}
			set
			{
				m_CJR = value;
			}
		}
		
		/// <summary>
		/// 屬性 CJSJ
		/// </summary>
		public DateTime CJSJ
		{
			get
			{
				return m_CJSJ;
			}
			set
			{
				m_CJSJ = value;
			}
		}
		
		/// <summary>
		/// 屬性 XGR
		/// </summary>
		public string XGR
		{
			get
			{
				return m_XGR;
			}
			set
			{
				m_XGR = value;
			}
		}
		
		/// <summary>
		/// 屬性 XGSJ
		/// </summary>
		public DateTime XGSJ
		{
			get
			{
				return m_XGSJ;
			}
			set
			{
				m_XGSJ = value;
			}
		}
		
		/// <summary>
		/// 屬性 ZTBJ
		/// </summary>
		public string ZTBJ
		{
			get
			{
				return m_ZTBJ;
			}
			set
			{
				m_ZTBJ = value;
			}
		}
		
		/// <summary>
		/// 屬性 BZ
		/// </summary>
		public string BZ
		{
			get
			{
				return m_BZ;
			}
			set
			{
				m_BZ = value;
			}
		}
		
		/// <summary>
		/// 屬性 GZBJ
		/// </summary>
		public string GZBJ
		{
			get
			{
				return m_GZBJ;
			}
			set
			{
				m_GZBJ = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW

{
	/// <summary>
	/// 實(shí)現(xiàn)對(duì) CW_FYCB對(duì)象的管理
	/// </summary>
	
	public class CW_FYCBMgr
	{
		/// <summary>
		///  添加新的CW_FYCB對(duì)象
		/// </summary>
		/// <param name="theCW_FYCB">要添加的CW_FYCB對(duì)象</param>
		
		public bool AddCW_FYCB(SqlConnection cn,CW_FYCB theCW_FYCB)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "insert into CW_FYCB (FYCBDH, JGDM, JBR, ZFY, CJR, CJSJ, XGR, XGSJ, ZTBJ, BZ, GZBJ) values (@FYCBDH, @JGDM, @JBR, @ZFY, @CJR, @CJSJ, @XGR, @XGSJ, @ZTBJ, @BZ, @GZBJ)";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@FYCBDH", theCW_FYCB.FYCBDH);
				cmd.Parameters.Add ("@JGDM", theCW_FYCB.JGDM);
				cmd.Parameters.Add ("@JBR", theCW_FYCB.JBR);
				cmd.Parameters.Add ("@ZFY", theCW_FYCB.ZFY);
				cmd.Parameters.Add ("@CJR", theCW_FYCB.CJR);
				cmd.Parameters.Add ("@CJSJ", theCW_FYCB.CJSJ);
				cmd.Parameters.Add ("@XGR", theCW_FYCB.XGR);
				cmd.Parameters.Add ("@XGSJ", theCW_FYCB.XGSJ);
				cmd.Parameters.Add ("@ZTBJ", theCW_FYCB.ZTBJ);
				cmd.Parameters.Add ("@BZ", theCW_FYCB.BZ);
				cmd.Parameters.Add ("@GZBJ", theCW_FYCB.GZBJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_FYCB(CW_FYCB theCW_FYCB)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_FYCB對(duì)象
		/// </summary>
		/// <param name="theCW_FYCB">要更新的CW_FYCB對(duì)象</param>
		
		public bool UpdateCW_FYCB(SqlConnection cn,CW_FYCB theCW_FYCB)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
//				
				string sql;
				sql = "update CW_FYCB set JGDM=@JGDM, JBR=@JBR, ZFY=@ZFY, CJR=@CJR, CJSJ=@CJSJ, XGR=@XGR, XGSJ=@XGSJ, ZTBJ=@ZTBJ, BZ=@BZ, GZBJ=@GZBJ where FYCBDH=@FYCBDH";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@FYCBDH", theCW_FYCB.FYCBDH);
				cmd.Parameters.Add ("@JGDM", theCW_FYCB.JGDM);
				cmd.Parameters.Add ("@JBR", theCW_FYCB.JBR);
				cmd.Parameters.Add ("@ZFY", theCW_FYCB.ZFY);
				cmd.Parameters.Add ("@CJR", theCW_FYCB.CJR);
				cmd.Parameters.Add ("@CJSJ", theCW_FYCB.CJSJ);
				cmd.Parameters.Add ("@XGR", theCW_FYCB.XGR);
				cmd.Parameters.Add ("@XGSJ", theCW_FYCB.XGSJ);
				cmd.Parameters.Add ("@ZTBJ", theCW_FYCB.ZTBJ);
				cmd.Parameters.Add ("@BZ", theCW_FYCB.BZ);
				cmd.Parameters.Add ("@GZBJ", theCW_FYCB.GZBJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_FYCB(CW_FYCB theCW_FYCB)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  刪除CW_FYCB對(duì)象
		/// </summary>
		/// <param name="FYCBDH">主鍵</param>
		
		public bool DelCW_FYCB(SqlConnection cn,string FYCBDH)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "delete from CW_FYCB where FYCBDH=@FYCBDH";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@FYCBDH", FYCBDH);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_FYCB(string FYCBDH)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根據(jù)主鍵標(biāo)識(shí)獲得CW_FYCB對(duì)象
		/// </summary>
		/// <param name="FYCBDH">主鍵</param>
		
		public CW_FYCB GetCW_FYCB(string FYCBDH)
		{
			try
			{
				CW_FYCB result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_FYCB where FYCBDH=@FYCBDH";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@FYCBDH", FYCBDH);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_FYCB();
					if (dr["FYCBDH"] != null)
						if (!System.DBNull.Equals(dr["FYCBDH"], System.DBNull.Value))
							result.FYCBDH = (string)dr["FYCBDH"];
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							result.JGDM = (string)dr["JGDM"];
					if (dr["JBR"] != null)
						if (!System.DBNull.Equals(dr["JBR"], System.DBNull.Value))
							result.JBR = (string)dr["JBR"];
					if (dr["ZFY"] != null)
						if (!System.DBNull.Equals(dr["ZFY"], System.DBNull.Value))
							result.ZFY = (double)dr["ZFY"];
					if (dr["CJR"] != null)
						if (!System.DBNull.Equals(dr["CJR"], System.DBNull.Value))
							result.CJR = (string)dr["CJR"];
					if (dr["CJSJ"] != null)
						if (!System.DBNull.Equals(dr["CJSJ"], System.DBNull.Value))
							result.CJSJ = (DateTime)dr["CJSJ"];
					if (dr["XGR"] != null)
						if (!System.DBNull.Equals(dr["XGR"], System.DBNull.Value))
							result.XGR = (string)dr["XGR"];
					if (dr["XGSJ"] != null)
						if (!System.DBNull.Equals(dr["XGSJ"], System.DBNull.Value))
							result.XGSJ = (DateTime)dr["XGSJ"];
					if (dr["ZTBJ"] != null)
						if (!System.DBNull.Equals(dr["ZTBJ"], System.DBNull.Value))
							result.ZTBJ = (string)dr["ZTBJ"];
					if (dr["BZ"] != null)
						if (!System.DBNull.Equals(dr["BZ"], System.DBNull.Value))
							result.BZ = (string)dr["BZ"];
					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_FYCB(string FYCBDH)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_FYCB對(duì)象
		/// </summary>
	
		public ArrayList FindCW_FYCB()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_FYCB";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_FYCB obj = new CW_FYCB();
					if (dr["FYCBDH"] != null)
						if (!System.DBNull.Equals(dr["FYCBDH"], System.DBNull.Value))
							obj.FYCBDH = (string)dr["FYCBDH"];
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							obj.JGDM = (string)dr["JGDM"];
					if (dr["JBR"] != null)
						if (!System.DBNull.Equals(dr["JBR"], System.DBNull.Value))
							obj.JBR = (string)dr["JBR"];
					if (dr["ZFY"] != null)
						if (!System.DBNull.Equals(dr["ZFY"], System.DBNull.Value))
							obj.ZFY = (double)dr["ZFY"];
					if (dr["CJR"] != null)
						if (!System.DBNull.Equals(dr["CJR"], System.DBNull.Value))
							obj.CJR = (string)dr["CJR"];
					if (dr["CJSJ"] != null)
						if (!System.DBNull.Equals(dr["CJSJ"], System.DBNull.Value))
							obj.CJSJ = (DateTime)dr["CJSJ"];
					if (dr["XGR"] != null)
						if (!System.DBNull.Equals(dr["XGR"], System.DBNull.Value))
							obj.XGR = (string)dr["XGR"];
					if (dr["XGSJ"] != null)
						if (!System.DBNull.Equals(dr["XGSJ"], System.DBNull.Value))
							obj.XGSJ = (DateTime)dr["XGSJ"];
					if (dr["ZTBJ"] != null)
						if (!System.DBNull.Equals(dr["ZTBJ"], System.DBNull.Value))
							obj.ZTBJ = (string)dr["ZTBJ"];
					if (dr["BZ"] != null)
						if (!System.DBNull.Equals(dr["BZ"], System.DBNull.Value))
							obj.BZ = (string)dr["BZ"];
					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_FYCB()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
	
	}
}