cw_kjkm.cs

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

using System;
using System.Collections;
using System.Data.SqlClient;
using com.unicafe.common;
using System.Data;

namespace Com.Ascs.Plp.CW
{
	/// <summary>
	///  对象CW_KJKM的定义
	///  根据表 CW_KJKM
	/// </summary>
	
	public class CW_KJKM
	{
		/// <summary>
		/// 对象CW_KJKM的构造函数
		/// </summary>
		public CW_KJKM()
		{
			m_KJND = "";
			m_KMBM = "";
			m_KMMC = "";
			m_SJKMBM = "";
			m_LB = "";
			m_KMFX = "";
			m_KMJB = 0;
			m_SFMX = "";
			m_SFXJHS = "";
			m_TYBJ = "";
			m_SFYJSY = "";
			m_SFBMHS = "";
			m_SFYGHS = "";
			m_SFWLHHS = "";
		}
		
		private string m_KJND;
		private string m_KMBM;
		private string m_KMMC;
		private string m_SJKMBM;
		private string m_LB;
		private string m_KMFX;
		private int m_KMJB;
		private string m_SFMX;
		private string m_SFXJHS;
		private string m_TYBJ;
		private string m_SFYJSY;
		private string m_SFBMHS;
		private string m_SFYGHS;
		private string m_SFWLHHS;
		
		/// <summary>
		/// 属性 KJND
		/// </summary>
		public string KJND
		{
			get
			{
				return m_KJND;
			}
			set
			{
				m_KJND = value;
			}
		}
		
		/// <summary>
		/// 属性 KMBM
		/// </summary>
		public string KMBM
		{
			get
			{
				return m_KMBM;
			}
			set
			{
				m_KMBM = value;
			}
		}
		
		/// <summary>
		/// 属性 KMMC
		/// </summary>
		public string KMMC
		{
			get
			{
				return m_KMMC;
			}
			set
			{
				m_KMMC = value;
			}
		}
		
		/// <summary>
		/// 属性 SJKMBM
		/// </summary>
		public string SJKMBM
		{
			get
			{
				return m_SJKMBM;
			}
			set
			{
				m_SJKMBM = value;
			}
		}
		
		/// <summary>
		/// 属性 LB
		/// </summary>
		public string LB
		{
			get
			{
				return m_LB;
			}
			set
			{
				m_LB = value;
			}
		}
		
		/// <summary>
		/// 属性 KMFX
		/// </summary>
		public string KMFX
		{
			get
			{
				return m_KMFX;
			}
			set
			{
				m_KMFX = value;
			}
		}
		
		/// <summary>
		/// 属性 KMJB
		/// </summary>
		public int KMJB
		{
			get
			{
				return m_KMJB;
			}
			set
			{
				m_KMJB = value;
			}
		}
		
		/// <summary>
		/// 属性 SFMX
		/// </summary>
		public string SFMX
		{
			get
			{
				return m_SFMX;
			}
			set
			{
				m_SFMX = value;
			}
		}
		
		/// <summary>
		/// 属性 SFXJHS
		/// </summary>
		public string SFXJHS
		{
			get
			{
				return m_SFXJHS;
			}
			set
			{
				m_SFXJHS = value;
			}
		}
		
		/// <summary>
		/// 属性 TYBJ
		/// </summary>
		public string TYBJ
		{
			get
			{
				return m_TYBJ;
			}
			set
			{
				m_TYBJ = value;
			}
		}
		
		/// <summary>
		/// 属性 SFYJSY
		/// </summary>
		public string SFYJSY
		{
			get
			{
				return m_SFYJSY;
			}
			set
			{
				m_SFYJSY = value;
			}
		}
		
		/// <summary>
		/// 属性 SFBMHS
		/// </summary>
		public string SFBMHS
		{
			get
			{
				return m_SFBMHS;
			}
			set
			{
				m_SFBMHS = value;
			}
		}
		
		/// <summary>
		/// 属性 SFYGHS
		/// </summary>
		public string SFYGHS
		{
			get
			{
				return m_SFYGHS;
			}
			set
			{
				m_SFYGHS = value;
			}
		}
		
		/// <summary>
		/// 属性 SFWLHHS
		/// </summary>
		public string SFWLHHS
		{
			get
			{
				return m_SFWLHHS;
			}
			set
			{
				m_SFWLHHS = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 实现对 CW_KJKM对象的管理
	/// </summary>
	
	public class CW_KJKMMgr
	{
		/// <summary>
		///  添加新的CW_KJKM对象
		/// </summary>
		/// <param name="theCW_KJKM">要添加的CW_KJKM对象</param>
		
		public bool AddCW_KJKM(SqlCommand cmd, CW_KJKM theCW_KJKM)
		{
			try
			{
				string sql;
				sql = "insert into CW_KJKM (KJND, KMBM, KMMC, SJKMBM, LB, KMFX, KMJB, SFMX, SFXJHS, TYBJ, SFYJSY, SFBMHS, SFYGHS, SFWLHHS) values (@KJND, @KMBM, @KMMC, @SJKMBM, @LB, @KMFX, @KMJB, @SFMX, @SFXJHS, @TYBJ, @SFYJSY, @SFBMHS, @SFYGHS, @SFWLHHS)";
				
				cmd.CommandText = sql;
				
				cmd.Parameters.Add ("@KJND", theCW_KJKM.KJND);
				//string str =theCW_KJKM.KMBM;
				cmd.Parameters.Add ("@KMBM", theCW_KJKM.KMBM);
				cmd.Parameters.Add ("@KMMC", theCW_KJKM.KMMC);
				cmd.Parameters.Add ("@SJKMBM", theCW_KJKM.SJKMBM);
				cmd.Parameters.Add ("@LB", theCW_KJKM.LB);
				cmd.Parameters.Add ("@KMFX", theCW_KJKM.KMFX);
				cmd.Parameters.Add ("@KMJB", theCW_KJKM.KMJB);
				cmd.Parameters.Add ("@SFMX", theCW_KJKM.SFMX);
				cmd.Parameters.Add ("@SFXJHS", theCW_KJKM.SFXJHS);
				cmd.Parameters.Add ("@TYBJ", theCW_KJKM.TYBJ);
				cmd.Parameters.Add ("@SFYJSY", theCW_KJKM.SFYJSY);
				cmd.Parameters.Add ("@SFBMHS", theCW_KJKM.SFBMHS);
				cmd.Parameters.Add ("@SFYGHS", theCW_KJKM.SFYGHS);
				cmd.Parameters.Add ("@SFWLHHS", theCW_KJKM.SFWLHHS);
				
				cmd.ExecuteNonQuery();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_KJKM(CW_KJKM theCW_KJKM)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_KJKM对象
		/// </summary>
		/// <param name="theCW_KJKM">要更新的CW_KJKM对象</param>
		
		public bool UpdateCW_KJKM(SqlCommand cmd, CW_KJKM theCW_KJKM)
		{
			try
			{
				
				string sql;
				sql = "update CW_KJKM set KMMC=@KMMC, SJKMBM=@SJKMBM, LB=@LB, KMFX=@KMFX, KMJB=@KMJB, SFMX=@SFMX, SFXJHS=@SFXJHS, TYBJ=@TYBJ, SFYJSY=@SFYJSY, SFBMHS=@SFBMHS, SFYGHS=@SFYGHS, SFWLHHS=@SFWLHHS where KJND=@KJND and KMBM=@KMBM";
				
				cmd.CommandText = sql;
				
				cmd.Parameters.Clear();
				cmd.Parameters.Add ("@KJND", theCW_KJKM.KJND);
				cmd.Parameters.Add ("@KMBM", theCW_KJKM.KMBM);
				cmd.Parameters.Add ("@KMMC", theCW_KJKM.KMMC);
				cmd.Parameters.Add ("@SJKMBM", theCW_KJKM.SJKMBM);
				cmd.Parameters.Add ("@LB", theCW_KJKM.LB);