cw_kjqj.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_KJQJ的定义
	///  根据表 CW_KJQJ
	/// </summary>
	
	public class CW_KJQJ
	{
		/// <summary>
		/// 对象CW_KJQJ的构造函数
		/// </summary>
		public CW_KJQJ()
		{
			m_JGDM=string.Empty;
			m_KJND = "";
			m_KJQJBH = "";
			m_KSRQ = DateTime.Now;
			m_JSRQ = DateTime.Now;
			m_ZTQYBJ = "";
			m_JZBJ = "";
			m_DQQJBJ = "";
		}
		
		private string m_JGDM;
		private string m_KJND;
		private string m_KJQJBH;
		private DateTime m_KSRQ;
		private DateTime m_JSRQ;
		private string m_ZTQYBJ;
		private string m_JZBJ;
		private string m_DQQJBJ;
		
		/// <summary>
		/// 属性 JGDM
		/// </summary>
		public string JGDM
		{
			get
			{
				return m_JGDM;
			}
			set
			{
				m_JGDM = value;
			}
		}

		/// <summary>
		/// 属性 KJND
		/// </summary>
		public string KJND
		{
			get
			{
				return m_KJND;
			}
			set
			{
				m_KJND = value;
			}
		}
		
		/// <summary>
		/// 属性 KJQJBH
		/// </summary>
		public string KJQJBH
		{
			get
			{
				return m_KJQJBH;
			}
			set
			{
				m_KJQJBH = value;
			}
		}
		
		/// <summary>
		/// 属性 KSRQ
		/// </summary>
		public DateTime KSRQ
		{
			get
			{
				return m_KSRQ;
			}
			set
			{
				m_KSRQ = value;
			}
		}
		
		/// <summary>
		/// 属性 JSRQ
		/// </summary>
		public DateTime JSRQ
		{
			get
			{
				return m_JSRQ;
			}
			set
			{
				m_JSRQ = value;
			}
		}
		
		/// <summary>
		/// 属性 ZTQYBJ
		/// </summary>
		public string ZTQYBJ
		{
			get
			{
				return m_ZTQYBJ;
			}
			set
			{
				m_ZTQYBJ = value;
			}
		}
		
		/// <summary>
		/// 属性 JZBJ
		/// </summary>
		public string JZBJ
		{
			get
			{
				return m_JZBJ;
			}
			set
			{
				m_JZBJ = value;
			}
		}
		
		/// <summary>
		/// 属性 DQQJBJ
		/// </summary>
		public string DQQJBJ
		{
			get
			{
				return m_DQQJBJ;
			}
			set
			{
				m_DQQJBJ = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 实现对 CW_KJQJ对象的管理
	/// </summary>
	
	public class CW_KJQJMgr
	{
		/// <summary>
		///  添加新的CW_KJQJ对象
		/// </summary>
		/// <param name="theCW_KJQJ">要添加的CW_KJQJ对象</param>
		
		public bool AddCW_KJQJ(SqlCommand cmd ,CW_KJQJ theCW_KJQJ)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "insert into CW_KJQJ (JGDM,KJND, KJQJBH, KSRQ, JSRQ, ZTQYBJ, JZBJ, DQQJBJ) values (@JGDM,@KJND, @KJQJBH, @KSRQ, @JSRQ, @ZTQYBJ, @JZBJ, @DQQJBJ)";
				
				cmd.CommandText = sql;
				cmd.Parameters.Clear();
				cmd.Parameters.Add ("@JGDM", theCW_KJQJ.JGDM);
				cmd.Parameters.Add ("@KJND", theCW_KJQJ.KJND);
				cmd.Parameters.Add ("@KJQJBH", theCW_KJQJ.KJQJBH);
				cmd.Parameters.Add ("@KSRQ", theCW_KJQJ.KSRQ);
				cmd.Parameters.Add ("@JSRQ", theCW_KJQJ.JSRQ);
				cmd.Parameters.Add ("@ZTQYBJ", theCW_KJQJ.ZTQYBJ);
				cmd.Parameters.Add ("@JZBJ", theCW_KJQJ.JZBJ);
				cmd.Parameters.Add ("@DQQJBJ", theCW_KJQJ.DQQJBJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_KJQJ(CW_KJQJ theCW_KJQJ)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_KJQJ对象
		/// </summary>
		/// <param name="theCW_KJQJ">要更新的CW_KJQJ对象</param>
		
		public bool UpdateCW_KJQJ(SqlCommand cmd ,CW_KJQJ theCW_KJQJ)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "update CW_KJQJ set KSRQ=@KSRQ, JSRQ=@JSRQ, ZTQYBJ=@ZTQYBJ, JZBJ=@JZBJ, DQQJBJ=@DQQJBJ where JGDM=@JGDM and KJND=@KJND and KJQJBH=@KJQJBH";
				
				cmd.CommandText = sql;
				cmd.Parameters.Clear();
				cmd.Parameters.Add ("@JGDM", theCW_KJQJ.JGDM);
				cmd.Parameters.Add ("@KJND", theCW_KJQJ.KJND);
				cmd.Parameters.Add ("@KJQJBH", theCW_KJQJ.KJQJBH);
				cmd.Parameters.Add ("@KSRQ", theCW_KJQJ.KSRQ);
				cmd.Parameters.Add ("@JSRQ", theCW_KJQJ.JSRQ);
				cmd.Parameters.Add ("@ZTQYBJ", theCW_KJQJ.ZTQYBJ);
				cmd.Parameters.Add ("@JZBJ", theCW_KJQJ.JZBJ);
				cmd.Parameters.Add ("@DQQJBJ", theCW_KJQJ.DQQJBJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_KJQJ(CW_KJQJ theCW_KJQJ)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  删除CW_KJQJ对象
		/// </summary>
		/// <param name="KJND">主键</param>
		/// <param name="KJQJBH">主键</param>
		
		public bool DelCW_KJQJ(SqlCommand cmd ,string JGDM,string KJND, string KJQJBH)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "delete from CW_KJQJ where JGDM=@JGDM and KJND=@KJND and KJQJBH=@KJQJBH";
				
				cmd.CommandText = sql;
				cmd.Parameters.Clear();
				cmd.Parameters.Add ("@JGDM",JGDM);
				cmd.Parameters.Add ("@KJND", KJND);
				cmd.Parameters.Add ("@KJQJBH", KJQJBH);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_KJQJ(string KJND, string KJQJBH)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根据主键标识获得CW_KJQJ对象
		/// </summary>
		/// <param name="KJND">主键</param>
		/// <param name="KJQJBH">主键</param>
		
		public CW_KJQJ GetCW_KJQJ(string JGDM,string KJND, string KJQJBH)
		{
			try
			{
				CW_KJQJ result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_KJQJ where JGDM=@JGDM and KJND=@KJND and KJQJBH=@KJQJBH";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@JGDM",JGDM);
				cmd.Parameters.Add ("@KJND", KJND);
				cmd.Parameters.Add ("@KJQJBH", KJQJBH);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_KJQJ();
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							result.JGDM = (string)dr["JGDM"];
					if (dr["KJND"] != null)
						if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
							result.KJND = (string)dr["KJND"];
					if (dr["KJQJBH"] != null)
						if (!System.DBNull.Equals(dr["KJQJBH"], System.DBNull.Value))
							result.KJQJBH = (string)dr["KJQJBH"];
					if (dr["KSRQ"] != null)
						if (!System.DBNull.Equals(dr["KSRQ"], System.DBNull.Value))
							result.KSRQ = (DateTime)dr["KSRQ"];
					if (dr["JSRQ"] != null)
						if (!System.DBNull.Equals(dr["JSRQ"], System.DBNull.Value))
							result.JSRQ = (DateTime)dr["JSRQ"];
					if (dr["ZTQYBJ"] != null)
						if (!System.DBNull.Equals(dr["ZTQYBJ"], System.DBNull.Value))
							result.ZTQYBJ = (string)dr["ZTQYBJ"];
					if (dr["JZBJ"] != null)
						if (!System.DBNull.Equals(dr["JZBJ"], System.DBNull.Value))
							result.JZBJ = (string)dr["JZBJ"];
					if (dr["DQQJBJ"] != null)
						if (!System.DBNull.Equals(dr["DQQJBJ"], System.DBNull.Value))
							result.DQQJBJ = (string)dr["DQQJBJ"];
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("GetCW_KJQJ(string KJND, string KJQJBH)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_KJQJ对象
		/// </summary>
	
		public ArrayList FindCW_KJQJ()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_KJQJ";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_KJQJ obj = new CW_KJQJ();
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							obj.JGDM = (string)dr["JGDM"];
					if (dr["KJND"] != null)
						if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
							obj.KJND = (string)dr["KJND"];
					if (dr["KJQJBH"] != null)
						if (!System.DBNull.Equals(dr["KJQJBH"], System.DBNull.Value))
							obj.KJQJBH = (string)dr["KJQJBH"];
					if (dr["KSRQ"] != null)
						if (!System.DBNull.Equals(dr["KSRQ"], System.DBNull.Value))
							obj.KSRQ = (DateTime)dr["KSRQ"];
					if (dr["JSRQ"] != null)
						if (!System.DBNull.Equals(dr["JSRQ"], System.DBNull.Value))
							obj.JSRQ = (DateTime)dr["JSRQ"];
					if (dr["ZTQYBJ"] != null)
						if (!System.DBNull.Equals(dr["ZTQYBJ"], System.DBNull.Value))
							obj.ZTQYBJ = (string)dr["ZTQYBJ"];
					if (dr["JZBJ"] != null)
						if (!System.DBNull.Equals(dr["JZBJ"], System.DBNull.Value))
							obj.JZBJ = (string)dr["JZBJ"];
					if (dr["DQQJBJ"] != null)
						if (!System.DBNull.Equals(dr["DQQJBJ"], System.DBNull.Value))
							obj.DQQJBJ = (string)dr["DQQJBJ"];
					result.Add(obj);
				}
				dr.Close();