cw_rygz.cs

ASP.NET的一些开发实例,有论坛管理系统等

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using com.unicafe.common;
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	///  对象CW_RYGZ的定义
	///  根据表 CW_RYGZ
	/// </summary>
	
	public class CW_RYGZ
	{
		/// <summary>
		/// 对象CW_RYGZ的构造函数
		/// </summary>
		public CW_RYGZ()
		{
			m_EMPLID = "";
			m_GZ = 0;
			m_ND = "";
			m_YF = "";
			m_BZ = "";
			m_GZBJ = "";
		}
		
		private string m_EMPLID;
		private double m_GZ;
		private string m_ND;
		private string m_YF;
		private string m_BZ;
		private string m_GZBJ;
		
		/// <summary>
		/// 属性 EMPLID
		/// </summary>
		public string EMPLID
		{
			get
			{
				return m_EMPLID;
			}
			set
			{
				m_EMPLID = value;
			}
		}
		
		/// <summary>
		/// 属性 GZ
		/// </summary>
		public double GZ
		{
			get
			{
				return m_GZ;
			}
			set
			{
				m_GZ = value;
			}
		}
		
		/// <summary>
		/// 属性 ND
		/// </summary>
		public string ND
		{
			get
			{
				return m_ND;
			}
			set
			{
				m_ND = value;
			}
		}
		
		/// <summary>
		/// 属性 YF
		/// </summary>
		public string YF
		{
			get
			{
				return m_YF;
			}
			set
			{
				m_YF = 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>
	/// 实现对 CW_RYGZ对象的管理
	/// </summary>
	
	public class CW_RYGZMgr
	{
		/// <summary>
		///  添加新的CW_RYGZ对象
		/// </summary>
		/// <param name="theCW_RYGZ">要添加的CW_RYGZ对象</param>
		
		public bool AddCW_RYGZ(System.Data.SqlClient.SqlConnection cn ,CW_RYGZ theCW_RYGZ)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "insert into CW_RYGZ (EMPLID, GZ, ND, YF, BZ, GZBJ) values (@EMPLID, @GZ, @ND, @YF, @BZ, @GZBJ)";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@EMPLID", theCW_RYGZ.EMPLID);
				cmd.Parameters.Add ("@GZ", theCW_RYGZ.GZ);
				cmd.Parameters.Add ("@ND", theCW_RYGZ.ND);
				cmd.Parameters.Add ("@YF", theCW_RYGZ.YF);
				cmd.Parameters.Add ("@BZ", theCW_RYGZ.BZ);
				cmd.Parameters.Add ("@GZBJ", theCW_RYGZ.GZBJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_RYGZ(CW_RYGZ theCW_RYGZ)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_RYGZ对象
		/// </summary>
		/// <param name="theCW_RYGZ">要更新的CW_RYGZ对象</param>
		
		public bool UpdateCW_RYGZ(System.Data.SqlClient.SqlConnection cn ,CW_RYGZ theCW_RYGZ)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "update CW_RYGZ set GZ=@GZ, BZ=@BZ, GZBJ=@GZBJ where EMPLID=@EMPLID and ND=@ND and YF=@YF";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@EMPLID", theCW_RYGZ.EMPLID);
				cmd.Parameters.Add ("@GZ", theCW_RYGZ.GZ);
				cmd.Parameters.Add ("@ND", theCW_RYGZ.ND);
				cmd.Parameters.Add ("@YF", theCW_RYGZ.YF);
				cmd.Parameters.Add ("@BZ", theCW_RYGZ.BZ);
				cmd.Parameters.Add ("@GZBJ", theCW_RYGZ.GZBJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_RYGZ(CW_RYGZ theCW_RYGZ)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  删除CW_RYGZ对象
		/// </summary>
		/// <param name="EMPLID">主键</param>
		/// <param name="ND">主键</param>
		/// <param name="YF">主键</param>
		
		public bool DelCW_RYGZ(System.Data.SqlClient.SqlConnection cn ,string EMPLID, string ND, string YF)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "delete from CW_RYGZ where EMPLID=@EMPLID and ND=@ND and YF=@YF";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@EMPLID", EMPLID);
				cmd.Parameters.Add ("@ND", ND);
				cmd.Parameters.Add ("@YF", YF);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_RYGZ(string EMPLID, string ND, string YF)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根据主键标识获得CW_RYGZ对象
		/// </summary>
		/// <param name="EMPLID">主键</param>
		/// <param name="ND">主键</param>
		/// <param name="YF">主键</param>
		
		public CW_RYGZ GetCW_RYGZ(string EMPLID, string ND, string YF)
		{
			try
			{
				CW_RYGZ result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_RYGZ where EMPLID=@EMPLID and ND=@ND and YF=@YF";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@EMPLID", EMPLID);
				cmd.Parameters.Add ("@ND", ND);
				cmd.Parameters.Add ("@YF", YF);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_RYGZ();
					if (dr["EMPLID"] != null)
						if (!System.DBNull.Equals(dr["EMPLID"], System.DBNull.Value))
							result.EMPLID = (string)dr["EMPLID"];
					if (dr["GZ"] != null)
						if (!System.DBNull.Equals(dr["GZ"], System.DBNull.Value))
							result.GZ = (double)dr["GZ"];
					if (dr["ND"] != null)
						if (!System.DBNull.Equals(dr["ND"], System.DBNull.Value))
							result.ND = (string)dr["ND"];
					if (dr["YF"] != null)
						if (!System.DBNull.Equals(dr["YF"], System.DBNull.Value))
							result.YF = (string)dr["YF"];
					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_RYGZ(string EMPLID, string ND, string YF)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_RYGZ对象
		/// </summary>
	
		public ArrayList FindCW_RYGZ()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_RYGZ";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_RYGZ obj = new CW_RYGZ();
					if (dr["EMPLID"] != null)
						if (!System.DBNull.Equals(dr["EMPLID"], System.DBNull.Value))
							obj.EMPLID = (string)dr["EMPLID"];
					if (dr["GZ"] != null)
						if (!System.DBNull.Equals(dr["GZ"], System.DBNull.Value))
							obj.GZ = (double)dr["GZ"];
					if (dr["ND"] != null)
						if (!System.DBNull.Equals(dr["ND"], System.DBNull.Value))
							obj.ND = (string)dr["ND"];
					if (dr["YF"] != null)
						if (!System.DBNull.Equals(dr["YF"], System.DBNull.Value))
							obj.YF = (string)dr["YF"];
					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_RYGZ()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
	
	}
}