cw_djkm.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_DJKM的定义
	///  根据表 CW_DJKM
	/// </summary>
	
	public class CW_DJKM
	{
		/// <summary>
		/// 对象CW_DJKM的构造函数
		/// </summary>
		public CW_DJKM()
		{
			m_DJLX = 0;
			m_KJND = "";
			m_KJKM = "";
		}
		
		private int m_DJLX;
		private string m_KJND;
		private string m_KJKM;
		
		/// <summary>
		/// 属性 DJLX
		/// </summary>
		public int DJLX
		{
			get
			{
				return m_DJLX;
			}
			set
			{
				m_DJLX = value;
			}
		}
		
		/// <summary>
		/// 属性 KJND
		/// </summary>
		public string KJND
		{
			get
			{
				return m_KJND;
			}
			set
			{
				m_KJND = value;
			}
		}
		
		/// <summary>
		/// 属性 KJKM
		/// </summary>
		public string KJKM
		{
			get
			{
				return m_KJKM;
			}
			set
			{
				m_KJKM = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 实现对 CW_DJKM对象的管理
	/// </summary>
	
	public class CW_DJKMMgr
	{
		/// <summary>
		///  添加新的CW_DJKM对象
		/// </summary>
		/// <param name="theCW_DJKM">要添加的CW_DJKM对象</param>
		
		public bool AddCW_DJKM(SqlConnection cn,CW_DJKM theCW_DJKM)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "insert into CW_DJKM (DJLX, KJND, KJKM) values (@DJLX, @KJND, @KJKM)";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@DJLX", theCW_DJKM.DJLX);
				cmd.Parameters.Add ("@KJND", theCW_DJKM.KJND);
				cmd.Parameters.Add ("@KJKM", theCW_DJKM.KJKM);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_DJKM(CW_DJKM theCW_DJKM)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_DJKM对象
		/// </summary>
		/// <param name="theCW_DJKM">要更新的CW_DJKM对象</param>
		
		public bool UpdateCW_DJKM(SqlConnection cn,CW_DJKM theCW_DJKM)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
		
				string sql;
				sql = "update CW_DJKM set  where DJLX=@DJLX and KJND=@KJND and KJKM=@KJKM";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@DJLX", theCW_DJKM.DJLX);
				cmd.Parameters.Add ("@KJND", theCW_DJKM.KJND);
				cmd.Parameters.Add ("@KJKM", theCW_DJKM.KJKM);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_DJKM(CW_DJKM theCW_DJKM)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  删除CW_DJKM对象
		/// </summary>
		/// <param name="DJLX">主键</param>
		/// <param name="KJND">主键</param>
		/// <param name="KJKM">主键</param>
		
		public bool DelCW_DJKM(SqlConnection cn,int DJLX, string KJND, string KJKM)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "delete from CW_DJKM where DJLX=@DJLX and KJND=@KJND and KJKM=@KJKM";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@DJLX", DJLX);
				cmd.Parameters.Add ("@KJND", KJND);
				cmd.Parameters.Add ("@KJKM", KJKM);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_DJKM(int DJLX, string KJND, string KJKM)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根据主键标识获得CW_DJKM对象
		/// </summary>
		/// <param name="DJLX">主键</param>
		/// <param name="KJND">主键</param>
		/// <param name="KJKM">主键</param>
		
		public CW_DJKM GetCW_DJKM(int DJLX, string KJND, string KJKM)
		{
			try
			{
				CW_DJKM result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_DJKM where DJLX=@DJLX and KJND=@KJND and KJKM=@KJKM";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@DJLX", DJLX);
				cmd.Parameters.Add ("@KJND", KJND);
				cmd.Parameters.Add ("@KJKM", KJKM);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_DJKM();
					if (dr["DJLX"] != null)
						if (!System.DBNull.Equals(dr["DJLX"], System.DBNull.Value))
							result.DJLX = (int)dr["DJLX"];
					if (dr["KJND"] != null)
						if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
							result.KJND = (string)dr["KJND"];
					if (dr["KJKM"] != null)
						if (!System.DBNull.Equals(dr["KJKM"], System.DBNull.Value))
							result.KJKM = (string)dr["KJKM"];
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("GetCW_DJKM(int DJLX, string KJND, string KJKM)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_DJKM对象
		/// </summary>
	
		public ArrayList FindCW_DJKM()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_DJKM";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_DJKM obj = new CW_DJKM();
					if (dr["DJLX"] != null)
						if (!System.DBNull.Equals(dr["DJLX"], System.DBNull.Value))
							obj.DJLX = (int)dr["DJLX"];
					if (dr["KJND"] != null)
						if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
							obj.KJND = (string)dr["KJND"];
					if (dr["KJKM"] != null)
						if (!System.DBNull.Equals(dr["KJKM"], System.DBNull.Value))
							obj.KJKM = (string)dr["KJKM"];
					result.Add(obj);
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("FindCW_DJKM()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
	
	}
}