cw_zjzy.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_ZJZY的定义
	///  根据表 CW_ZJZY
	/// </summary>
	
	public class CW_ZJZY
	{
		/// <summary>
		/// 对象CW_ZJZY的构造函数
		/// </summary>
		public CW_ZJZY()
		{
			m_JGDM = "";
			m_ND = "";
			m_ZYJE = 0;
			m_BL = 0;
			m_CZBL = 0;
		}
		
		private string m_JGDM;
		private string m_ND;
		private double m_ZYJE;
		private double m_BL;
		private double m_CZBL;
		
		/// <summary>
		/// 属性 JGDM
		/// </summary>
		public string JGDM
		{
			get
			{
				return m_JGDM;
			}
			set
			{
				m_JGDM = value;
			}
		}
		
		/// <summary>
		/// 属性 ND
		/// </summary>
		public string ND
		{
			get
			{
				return m_ND;
			}
			set
			{
				m_ND = value;
			}
		}
		
		/// <summary>
		/// 属性 ZYJE
		/// </summary>
		public double ZYJE
		{
			get
			{
				return m_ZYJE;
			}
			set
			{
				m_ZYJE = value;
			}
		}
		
		/// <summary>
		/// 属性 BL
		/// </summary>
		public double BL
		{
			get
			{
				return m_BL;
			}
			set
			{
				m_BL = value;
			}
		}
		
		/// <summary>
		/// 属性 CZBL
		/// </summary>
		public double CZBL
		{
			get
			{
				return m_CZBL;
			}
			set
			{
				m_CZBL = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 实现对 CW_ZJZY对象的管理
	/// </summary>
	
	public class CW_ZJZYMgr
	{
		/// <summary>
		///  添加新的CW_ZJZY对象
		/// </summary>
		/// <param name="theCW_ZJZY">要添加的CW_ZJZY对象</param>
		
		public bool AddCW_ZJZY(System.Data.SqlClient.SqlConnection cn ,CW_ZJZY theCW_ZJZY)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "insert into CW_ZJZY (JGDM, ND, ZYJE, BL, CZBL) values (@JGDM, @ND, @ZYJE, @BL, @CZBL)";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@JGDM", theCW_ZJZY.JGDM);
				cmd.Parameters.Add ("@ND", theCW_ZJZY.ND);
				cmd.Parameters.Add ("@ZYJE", theCW_ZJZY.ZYJE);
				cmd.Parameters.Add ("@BL", theCW_ZJZY.BL);
				cmd.Parameters.Add ("@CZBL", theCW_ZJZY.CZBL);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_ZJZY(CW_ZJZY theCW_ZJZY)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_ZJZY对象
		/// </summary>
		/// <param name="theCW_ZJZY">要更新的CW_ZJZY对象</param>
		
		public bool UpdateCW_ZJZY(System.Data.SqlClient.SqlConnection cn ,CW_ZJZY theCW_ZJZY)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "update CW_ZJZY set ZYJE=@ZYJE, BL=@BL, CZBL=@CZBL where JGDM=@JGDM and ND=@ND";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@JGDM", theCW_ZJZY.JGDM);
				cmd.Parameters.Add ("@ND", theCW_ZJZY.ND);
				cmd.Parameters.Add ("@ZYJE", theCW_ZJZY.ZYJE);
				cmd.Parameters.Add ("@BL", theCW_ZJZY.BL);
				cmd.Parameters.Add ("@CZBL", theCW_ZJZY.CZBL);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_ZJZY(CW_ZJZY theCW_ZJZY)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  删除CW_ZJZY对象
		/// </summary>
		/// <param name="JGDM">主键</param>
		/// <param name="ND">主键</param>
		
		public bool DelCW_ZJZY(System.Data.SqlClient.SqlConnection cn ,string JGDM, string ND)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "delete from CW_ZJZY where JGDM=@JGDM and ND=@ND";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@JGDM", JGDM);
				cmd.Parameters.Add ("@ND", ND);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_ZJZY(string JGDM, string ND)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根据主键标识获得CW_ZJZY对象
		/// </summary>
		/// <param name="JGDM">主键</param>
		/// <param name="ND">主键</param>
		
		public CW_ZJZY GetCW_ZJZY(string JGDM, string ND)
		{
			try
			{
				CW_ZJZY result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_ZJZY where JGDM=@JGDM and ND=@ND";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@JGDM", JGDM);
				cmd.Parameters.Add ("@ND", ND);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_ZJZY();
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							result.JGDM = (string)dr["JGDM"];
					if (dr["ND"] != null)
						if (!System.DBNull.Equals(dr["ND"], System.DBNull.Value))
							result.ND = (string)dr["ND"];
					if (dr["ZYJE"] != null)
						if (!System.DBNull.Equals(dr["ZYJE"], System.DBNull.Value))
							result.ZYJE = (double)dr["ZYJE"];
					if (dr["BL"] != null)
						if (!System.DBNull.Equals(dr["BL"], System.DBNull.Value))
							result.BL = (double)dr["BL"];
					if (dr["CZBL"] != null)
						if (!System.DBNull.Equals(dr["CZBL"], System.DBNull.Value))
							result.CZBL = (double)dr["CZBL"];
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("GetCW_ZJZY(string JGDM, string ND)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_ZJZY对象
		/// </summary>
	
		public ArrayList FindCW_ZJZY()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_ZJZY";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_ZJZY obj = new CW_ZJZY();
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							obj.JGDM = (string)dr["JGDM"];
					if (dr["ND"] != null)
						if (!System.DBNull.Equals(dr["ND"], System.DBNull.Value))
							obj.ND = (string)dr["ND"];
					if (dr["ZYJE"] != null)
						if (!System.DBNull.Equals(dr["ZYJE"], System.DBNull.Value))
							obj.ZYJE = (double)dr["ZYJE"];
					if (dr["BL"] != null)
						if (!System.DBNull.Equals(dr["BL"], System.DBNull.Value))
							obj.BL = (double)dr["BL"];
					if (dr["CZBL"] != null)
						if (!System.DBNull.Equals(dr["CZBL"], System.DBNull.Value))
							obj.CZBL = (double)dr["CZBL"];
					result.Add(obj);
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("FindCW_ZJZY()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
	
	}
}