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

namespace Com.Ascs.Plp.CW
{
	/// <summary>
	///  對象CW_CWXTSZ的定義
	///  根據(jù)表 CW_CWXTSZ
	/// </summary>
	
	public class CW_CWXTSZ
	{
		/// <summary>
		/// 對象CW_CWXTSZ的構(gòu)造函數(shù)
		/// </summary>
		public CW_CWXTSZ()
		{
			m_XMBH = 0;
			m_KJND = "";
			m_XMMC = "";
			m_XMZ = "";
			m_QYBJ = "";
		}
		
		private int m_XMBH;
		private string m_KJND;
		private string m_XMMC;
		private string m_XMZ;
		private string m_QYBJ;
		
		/// <summary>
		/// 屬性 XMBH
		/// </summary>
		public int XMBH
		{
			get
			{
				return m_XMBH;
			}
			set
			{
				m_XMBH = value;
			}
		}
		
		/// <summary>
		/// 屬性 KJND
		/// </summary>
		public string KJND
		{
			get
			{
				return m_KJND;
			}
			set
			{
				m_KJND = value;
			}
		}
		
		/// <summary>
		/// 屬性 XMMC
		/// </summary>
		public string XMMC
		{
			get
			{
				return m_XMMC;
			}
			set
			{
				m_XMMC = value;
			}
		}
		
		/// <summary>
		/// 屬性 XMZ
		/// </summary>
		public string XMZ
		{
			get
			{
				return m_XMZ;
			}
			set
			{
				m_XMZ = value;
			}
		}
		
		/// <summary>
		/// 屬性 QYBJ
		/// </summary>
		public string QYBJ
		{
			get
			{
				return m_QYBJ;
			}
			set
			{
				m_QYBJ = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 實現(xiàn)對 CW_CWXTSZ對象的管理
	/// </summary>
	
	public class CW_CWXTSZMgr
	{
		/// <summary>
		///  添加新的CW_CWXTSZ對象
		/// </summary>
		/// <param name="theCW_CWXTSZ">要添加的CW_CWXTSZ對象</param>
		
		public bool AddCW_CWXTSZ(SqlConnection cn,CW_CWXTSZ theCW_CWXTSZ)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "insert into CW_CWXTSZ (XMBH, KJND, XMMC, XMZ, QYBJ) values (@XMBH, @KJND, @XMMC, @XMZ, @QYBJ)";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@XMBH", theCW_CWXTSZ.XMBH);
				cmd.Parameters.Add ("@KJND", theCW_CWXTSZ.KJND);
				cmd.Parameters.Add ("@XMMC", theCW_CWXTSZ.XMMC);
				cmd.Parameters.Add ("@XMZ", theCW_CWXTSZ.XMZ);
				cmd.Parameters.Add ("@QYBJ", theCW_CWXTSZ.QYBJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_CWXTSZ(CW_CWXTSZ theCW_CWXTSZ)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_CWXTSZ對象
		/// </summary>
		/// <param name="theCW_CWXTSZ">要更新的CW_CWXTSZ對象</param>
		
		public bool UpdateCW_CWXTSZ(SqlConnection cn,CW_CWXTSZ theCW_CWXTSZ)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "update CW_CWXTSZ set XMMC=@XMMC, XMZ=@XMZ, QYBJ=@QYBJ where XMBH=@XMBH and KJND=@KJND";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@XMBH", theCW_CWXTSZ.XMBH);
				cmd.Parameters.Add ("@KJND", theCW_CWXTSZ.KJND);
				cmd.Parameters.Add ("@XMMC", theCW_CWXTSZ.XMMC);
				cmd.Parameters.Add ("@XMZ", theCW_CWXTSZ.XMZ);
				cmd.Parameters.Add ("@QYBJ", theCW_CWXTSZ.QYBJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_CWXTSZ(CW_CWXTSZ theCW_CWXTSZ)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  刪除CW_CWXTSZ對象
		/// </summary>
		/// <param name="XMBH">主鍵</param>
		/// <param name="KJND">主鍵</param>
		
		public bool DelCW_CWXTSZ(SqlConnection cn,int XMBH, string KJND)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "delete from CW_CWXTSZ where XMBH=@XMBH and KJND=@KJND";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@XMBH", XMBH);
				cmd.Parameters.Add ("@KJND", KJND);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_CWXTSZ(int XMBH, string KJND)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根據(jù)主鍵標識獲得CW_CWXTSZ對象
		/// </summary>
		/// <param name="XMBH">主鍵</param>
		/// <param name="KJND">主鍵</param>
		
		public CW_CWXTSZ GetCW_CWXTSZ(int XMBH, string KJND)
		{
			try
			{
				CW_CWXTSZ result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_CWXTSZ where XMBH=@XMBH and KJND=@KJND";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@XMBH", XMBH);
				cmd.Parameters.Add ("@KJND", KJND);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_CWXTSZ();
					if (dr["XMBH"] != null)
						if (!System.DBNull.Equals(dr["XMBH"], System.DBNull.Value))
							result.XMBH = (int)dr["XMBH"];
					if (dr["KJND"] != null)
						if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
							result.KJND = (string)dr["KJND"];
					if (dr["XMMC"] != null)
						if (!System.DBNull.Equals(dr["XMMC"], System.DBNull.Value))
							result.XMMC = (string)dr["XMMC"];
					if (dr["XMZ"] != null)
						if (!System.DBNull.Equals(dr["XMZ"], System.DBNull.Value))
							result.XMZ = (string)dr["XMZ"];
					if (dr["QYBJ"] != null)
						if (!System.DBNull.Equals(dr["QYBJ"], System.DBNull.Value))
							result.QYBJ = (string)dr["QYBJ"];
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("GetCW_CWXTSZ(int XMBH, string KJND)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_CWXTSZ對象
		/// </summary>
	
		public ArrayList FindCW_CWXTSZ()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_CWXTSZ";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_CWXTSZ obj = new CW_CWXTSZ();
					if (dr["XMBH"] != null)
						if (!System.DBNull.Equals(dr["XMBH"], System.DBNull.Value))
							obj.XMBH = (int)dr["XMBH"];
					if (dr["KJND"] != null)
						if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
							obj.KJND = (string)dr["KJND"];
					if (dr["XMMC"] != null)
						if (!System.DBNull.Equals(dr["XMMC"], System.DBNull.Value))
							obj.XMMC = (string)dr["XMMC"];
					if (dr["XMZ"] != null)
						if (!System.DBNull.Equals(dr["XMZ"], System.DBNull.Value))
							obj.XMZ = (string)dr["XMZ"];
					if (dr["QYBJ"] != null)
						if (!System.DBNull.Equals(dr["QYBJ"], System.DBNull.Value))
							obj.QYBJ = (string)dr["QYBJ"];
					result.Add(obj);
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("FindCW_CWXTSZ()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
	
	}
}