cw_fycbjhxm.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_FYJHXM的定义
	///  根据表 CW_FYJHXM
	/// </summary>
	
	public class CW_FYJHXM
	{
		/// <summary>
		/// 对象CW_FYJHXM的构造函数
		/// </summary>
		public CW_FYJHXM()
		{
			m_FYCBJHDH = "";
			m_KMDM = "";
			m_FYJE = 0;
			m_SHYJ = "";
		}
		
		private string m_FYCBJHDH;
		private string m_KMDM;
		private double m_FYJE;
		private string m_SHYJ;
		
		/// <summary>
		/// 属性 FYCBJHDH
		/// </summary>
		public string FYCBJHDH
		{
			get
			{
				return m_FYCBJHDH;
			}
			set
			{
				m_FYCBJHDH = value;
			}
		}
		
		/// <summary>
		/// 属性 KMDM
		/// </summary>
		public string KMDM
		{
			get
			{
				return m_KMDM;
			}
			set
			{
				m_KMDM = value;
			}
		}
		
		/// <summary>
		/// 属性 FYJE
		/// </summary>
		public double FYJE
		{
			get
			{
				return m_FYJE;
			}
			set
			{
				m_FYJE = value;
			}
		}
		
		/// <summary>
		/// 属性 SHYJ
		/// </summary>
		public string SHYJ
		{
			get
			{
				return m_SHYJ;
			}
			set
			{
				m_SHYJ = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 实现对 CW_FYJHXM对象的管理
	/// </summary>
	
	public class CW_FYJHXMMgr
	{
		/// <summary>
		///  添加新的CW_FYJHXM对象
		/// </summary>
		/// <param name="theCW_FYJHXM">要添加的CW_FYJHXM对象</param>
		
		public bool AddCW_FYJHXM(SqlConnection cn,CW_FYJHXM theCW_FYJHXM)
		{
			try
		{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "insert into CW_FYJHXM (FYCBJHDH, KMDM, FYJE, SHYJ) values (@FYCBJHDH, @KMDM, @FYJE, @SHYJ)";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@FYCBJHDH", theCW_FYJHXM.FYCBJHDH);
				cmd.Parameters.Add ("@KMDM", theCW_FYJHXM.KMDM);
				cmd.Parameters.Add ("@FYJE", theCW_FYJHXM.FYJE);
				cmd.Parameters.Add ("@SHYJ", theCW_FYJHXM.SHYJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_FYJHXM(CW_FYJHXM theCW_FYJHXM)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_FYJHXM对象
		/// </summary>
		/// <param name="theCW_FYJHXM">要更新的CW_FYJHXM对象</param>
		
		public bool UpdateCW_FYJHXM(SqlConnection cn,CW_FYJHXM theCW_FYJHXM)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "update CW_FYJHXM set FYJE=@FYJE, SHYJ=@SHYJ where FYCBJHDH=@FYCBJHDH and KMDM=@KMDM";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@FYCBJHDH", theCW_FYJHXM.FYCBJHDH);
				cmd.Parameters.Add ("@KMDM", theCW_FYJHXM.KMDM);
				cmd.Parameters.Add ("@FYJE", theCW_FYJHXM.FYJE);
				cmd.Parameters.Add ("@SHYJ", theCW_FYJHXM.SHYJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_FYJHXM(CW_FYJHXM theCW_FYJHXM)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  删除CW_FYJHXM对象
		/// </summary>
		/// <param name="FYCBJHDH">主键</param>
		/// <param name="KMDM">主键</param>
		
		public bool DelCW_FYJHXM(SqlConnection cn,string FYCBJHDH, string KMDM)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "delete from CW_FYJHXM where FYCBJHDH=@FYCBJHDH and KMDM=@KMDM";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@FYCBJHDH", FYCBJHDH);
				cmd.Parameters.Add ("@KMDM", KMDM);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_FYJHXM(string FYCBJHDH, string KMDM)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根据主键标识获得CW_FYJHXM对象
		/// </summary>
		/// <param name="FYCBJHDH">主键</param>
		/// <param name="KMDM">主键</param>
		
		public CW_FYJHXM GetCW_FYJHXM(string FYCBJHDH, string KMDM)
		{
			try
			{
				CW_FYJHXM result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_FYJHXM where FYCBJHDH=@FYCBJHDH and KMDM=@KMDM";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@FYCBJHDH", FYCBJHDH);
				cmd.Parameters.Add ("@KMDM", KMDM);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_FYJHXM();
					if (dr["FYCBJHDH"] != null)
						if (!System.DBNull.Equals(dr["FYCBJHDH"], System.DBNull.Value))
							result.FYCBJHDH = (string)dr["FYCBJHDH"];
					if (dr["KMDM"] != null)
						if (!System.DBNull.Equals(dr["KMDM"], System.DBNull.Value))
							result.KMDM = (string)dr["KMDM"];
					if (dr["FYJE"] != null)
						if (!System.DBNull.Equals(dr["FYJE"], System.DBNull.Value))
							result.FYJE = (double)dr["FYJE"];
					if (dr["SHYJ"] != null)
						if (!System.DBNull.Equals(dr["SHYJ"], System.DBNull.Value))
							result.SHYJ = (string)dr["SHYJ"];
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("GetCW_FYJHXM(string FYCBJHDH, string KMDM)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_FYJHXM对象
		/// </summary>
	
		public ArrayList FindCW_FYJHXM()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_FYJHXM";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_FYJHXM obj = new CW_FYJHXM();
					if (dr["FYCBJHDH"] != null)
						if (!System.DBNull.Equals(dr["FYCBJHDH"], System.DBNull.Value))
							obj.FYCBJHDH = (string)dr["FYCBJHDH"];
					if (dr["KMDM"] != null)
						if (!System.DBNull.Equals(dr["KMDM"], System.DBNull.Value))
							obj.KMDM = (string)dr["KMDM"];
					if (dr["FYJE"] != null)
						if (!System.DBNull.Equals(dr["FYJE"], System.DBNull.Value))
							obj.FYJE = (double)dr["FYJE"];
					if (dr["SHYJ"] != null)
						if (!System.DBNull.Equals(dr["SHYJ"], System.DBNull.Value))
							obj.SHYJ = (string)dr["SHYJ"];
					result.Add(obj);
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("FindCW_FYJHXM()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
	
	}
}