📄 cw_fkd.cs

📁 ASP.NET的一些开发实例,有论坛管理系统等
💻 CS
字号:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using com.unicafe.common;
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	///  对象CW_FKD的定义
	///  根据表 CW_FKD
	/// </summary>
	
	public class CW_FKD
	{
		/// <summary>
		/// 对象CW_FKD的构造函数
		/// </summary>
		public CW_FKD()
		{
			m_FKDH = "";
			m_JGDM = "";
			m_WLHBH = "";
			m_WLHLX = "";
			m_YSDJH = "";
			m_DJLX = 0;
			m_HBLX = "";
			m_YFJE = 0;
			m_FKRQ = DateTime.Now;
			m_HXYE = 0;
			m_ZDR = "";
			m_ZTBJ = "";
			m_BZ = "";
			m_GZBJ = "";
		}
		
		private string m_FKDH;
		private string m_JGDM;
		private string m_WLHBH;
		private string m_WLHLX;
		private string m_YSDJH;
		private int m_DJLX;
		private string m_HBLX;
		private double m_YFJE;
		private DateTime m_FKRQ;
		private double m_HXYE;
		private string m_ZDR;
		private string m_ZTBJ;
		private string m_BZ;
		private string m_GZBJ;
		
		/// <summary>
		/// 属性 FKDH
		/// </summary>
		public string FKDH
		{
			get
			{
				return m_FKDH;
			}
			set
			{
				m_FKDH = value;
			}
		}
		
		/// <summary>
		/// 属性 JGDM
		/// </summary>
		public string JGDM
		{
			get
			{
				return m_JGDM;
			}
			set
			{
				m_JGDM = value;
			}
		}
		
		/// <summary>
		/// 属性 WLHBH
		/// </summary>
		public string WLHBH
		{
			get
			{
				return m_WLHBH;
			}
			set
			{
				m_WLHBH = value;
			}
		}
		
		/// <summary>
		/// 属性 WLHLX
		/// </summary>
		public string WLHLX
		{
			get
			{
				return m_WLHLX;
			}
			set
			{
				m_WLHLX = value;
			}
		}
		
		/// <summary>
		/// 属性 YSDJH
		/// </summary>
		public string YSDJH
		{
			get
			{
				return m_YSDJH;
			}
			set
			{
				m_YSDJH = value;
			}
		}
		
		/// <summary>
		/// 属性 DJLX
		/// </summary>
		public int DJLX
		{
			get
			{
				return m_DJLX;
			}
			set
			{
				m_DJLX = value;
			}
		}
		
		/// <summary>
		/// 属性 HBLX
		/// </summary>
		public string HBLX
		{
			get
			{
				return m_HBLX;
			}
			set
			{
				m_HBLX = value;
			}
		}
		
		/// <summary>
		/// 属性 YFJE
		/// </summary>
		public double YFJE
		{
			get
			{
				return m_YFJE;
			}
			set
			{
				m_YFJE = value;
			}
		}
		
		/// <summary>
		/// 属性 FKRQ
		/// </summary>
		public DateTime FKRQ
		{
			get
			{
				return m_FKRQ;
			}
			set
			{
				m_FKRQ = value;
			}
		}
		
		/// <summary>
		/// 属性 HXYE
		/// </summary>
		public double HXYE
		{
			get
			{
				return m_HXYE;
			}
			set
			{
				m_HXYE = value;
			}
		}
		
		/// <summary>
		/// 属性 ZDR
		/// </summary>
		public string ZDR
		{
			get
			{
				return m_ZDR;
			}
			set
			{
				m_ZDR = value;
			}
		}
		
		/// <summary>
		/// 属性 ZTBJ
		/// </summary>
		public string ZTBJ
		{
			get
			{
				return m_ZTBJ;
			}
			set
			{
				m_ZTBJ = value;
			}
		}
		
		/// <summary>
		/// 属性 BZ
		/// </summary>
		public string BZ
		{
			get
			{
				return m_BZ;
			}
			set
			{
				m_BZ = value;
			}
		}
		
		/// <summary>
		/// 属性 GZBJ
		/// </summary>
		public string GZBJ
		{
			get
			{
				return m_GZBJ;
			}
			set
			{
				m_GZBJ = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 实现对 CW_FKD对象的管理
	/// </summary>
	
	public class CW_FKDMgr
	{
		/// <summary>
		///  添加新的CW_FKD对象
		/// </summary>
		/// <param name="theCW_FKD">要添加的CW_FKD对象</param>
		
		public bool AddCW_FKD(System.Data.SqlClient.SqlConnection cn ,CW_FKD theCW_FKD)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "insert into CW_FKD (FKDH, JGDM, WLHBH, WLHLX, YSDJH, DJLX, HBLX, YFJE, FKRQ, HXYE, ZDR, ZTBJ, BZ, GZBJ) values (@FKDH, @JGDM, @WLHBH, @WLHLX, @YSDJH, @DJLX, @HBLX, @YFJE, @FKRQ, @HXYE, @ZDR, @ZTBJ, @BZ, @GZBJ)";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@FKDH", theCW_FKD.FKDH);
				cmd.Parameters.Add ("@JGDM", theCW_FKD.JGDM);
				cmd.Parameters.Add ("@WLHBH", theCW_FKD.WLHBH);
				cmd.Parameters.Add ("@WLHLX", theCW_FKD.WLHLX);
				cmd.Parameters.Add ("@YSDJH", theCW_FKD.YSDJH);
				cmd.Parameters.Add ("@DJLX", theCW_FKD.DJLX);
				cmd.Parameters.Add ("@HBLX", theCW_FKD.HBLX);
				cmd.Parameters.Add ("@YFJE", theCW_FKD.YFJE);
				cmd.Parameters.Add ("@FKRQ", theCW_FKD.FKRQ);
				cmd.Parameters.Add ("@HXYE", theCW_FKD.HXYE);
				cmd.Parameters.Add ("@ZDR", theCW_FKD.ZDR);
				cmd.Parameters.Add ("@ZTBJ", theCW_FKD.ZTBJ);
				cmd.Parameters.Add ("@BZ", theCW_FKD.BZ);
				cmd.Parameters.Add ("@GZBJ", theCW_FKD.GZBJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_FKD(CW_FKD theCW_FKD)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_FKD对象
		/// </summary>
		/// <param name="theCW_FKD">要更新的CW_FKD对象</param>
		
		public bool UpdateCW_FKD(System.Data.SqlClient.SqlConnection cn ,CW_FKD theCW_FKD)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "update CW_FKD set JGDM=@JGDM, WLHBH=@WLHBH, WLHLX=@WLHLX, YSDJH=@YSDJH, DJLX=@DJLX, HBLX=@HBLX, YFJE=@YFJE, FKRQ=@FKRQ, HXYE=@HXYE, ZDR=@ZDR, ZTBJ=@ZTBJ, BZ=@BZ, GZBJ=@GZBJ where FKDH=@FKDH";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@FKDH", theCW_FKD.FKDH);
				cmd.Parameters.Add ("@JGDM", theCW_FKD.JGDM);
				cmd.Parameters.Add ("@WLHBH", theCW_FKD.WLHBH);
				cmd.Parameters.Add ("@WLHLX", theCW_FKD.WLHLX);
				cmd.Parameters.Add ("@YSDJH", theCW_FKD.YSDJH);
				cmd.Parameters.Add ("@DJLX", theCW_FKD.DJLX);
				cmd.Parameters.Add ("@HBLX", theCW_FKD.HBLX);
				cmd.Parameters.Add ("@YFJE", theCW_FKD.YFJE);
				cmd.Parameters.Add ("@FKRQ", theCW_FKD.FKRQ);
				cmd.Parameters.Add ("@HXYE", theCW_FKD.HXYE);
				cmd.Parameters.Add ("@ZDR", theCW_FKD.ZDR);
				cmd.Parameters.Add ("@ZTBJ", theCW_FKD.ZTBJ);
				cmd.Parameters.Add ("@BZ", theCW_FKD.BZ);
				cmd.Parameters.Add ("@GZBJ", theCW_FKD.GZBJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_FKD(CW_FKD theCW_FKD)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  删除CW_FKD对象
		/// </summary>
		/// <param name="FKDH">主键</param>
		
		public bool DelCW_FKD(System.Data.SqlClient.SqlConnection cn ,string FKDH)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "delete from CW_FKD where FKDH=@FKDH";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@FKDH", FKDH);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_FKD(string FKDH)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根据主键标识获得CW_FKD对象
		/// </summary>
		/// <param name="FKDH">主键</param>
		
		public CW_FKD GetCW_FKD(string FKDH)
		{
			try
			{
				CW_FKD result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_FKD where FKDH=@FKDH";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@FKDH", FKDH);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_FKD();
					if (dr["FKDH"] != null)
						if (!System.DBNull.Equals(dr["FKDH"], System.DBNull.Value))
							result.FKDH = (string)dr["FKDH"];
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							result.JGDM = (string)dr["JGDM"];
					if (dr["WLHBH"] != null)
						if (!System.DBNull.Equals(dr["WLHBH"], System.DBNull.Value))
							result.WLHBH = (string)dr["WLHBH"];
					if (dr["WLHLX"] != null)
						if (!System.DBNull.Equals(dr["WLHLX"], System.DBNull.Value))
							result.WLHLX = (string)dr["WLHLX"];
					if (dr["YSDJH"] != null)
						if (!System.DBNull.Equals(dr["YSDJH"], System.DBNull.Value))
							result.YSDJH = (string)dr["YSDJH"];
					if (dr["DJLX"] != null)
						if (!System.DBNull.Equals(dr["DJLX"], System.DBNull.Value))
							result.DJLX = (int)dr["DJLX"];
					if (dr["HBLX"] != null)
						if (!System.DBNull.Equals(dr["HBLX"], System.DBNull.Value))
							result.HBLX = (string)dr["HBLX"];
					if (dr["YFJE"] != null)
						if (!System.DBNull.Equals(dr["YFJE"], System.DBNull.Value))
							result.YFJE = (double)dr["YFJE"];
					if (dr["FKRQ"] != null)
						if (!System.DBNull.Equals(dr["FKRQ"], System.DBNull.Value))
							result.FKRQ = (DateTime)dr["FKRQ"];
					if (dr["HXYE"] != null)
						if (!System.DBNull.Equals(dr["HXYE"], System.DBNull.Value))
							result.HXYE = (double)dr["HXYE"];
					if (dr["ZDR"] != null)
						if (!System.DBNull.Equals(dr["ZDR"], System.DBNull.Value))
							result.ZDR = (string)dr["ZDR"];
					if (dr["ZTBJ"] != null)
						if (!System.DBNull.Equals(dr["ZTBJ"], System.DBNull.Value))
							result.ZTBJ = (string)dr["ZTBJ"];
					if (dr["BZ"] != null)
						if (!System.DBNull.Equals(dr["BZ"], System.DBNull.Value))
							result.BZ = (string)dr["BZ"];
					if (dr["GZBJ"] != null)
						if (!System.DBNull.Equals(dr["GZBJ"], System.DBNull.Value))
							result.GZBJ = (string)dr["GZBJ"];
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("GetCW_FKD(string FKDH)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_FKD对象
		/// </summary>
	
		public ArrayList FindCW_FKD()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_FKD";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_FKD obj = new CW_FKD();
					if (dr["FKDH"] != null)
						if (!System.DBNull.Equals(dr["FKDH"], System.DBNull.Value))
							obj.FKDH = (string)dr["FKDH"];
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							obj.JGDM = (string)dr["JGDM"];
					if (dr["WLHBH"] != null)
						if (!System.DBNull.Equals(dr["WLHBH"], System.DBNull.Value))
							obj.WLHBH = (string)dr["WLHBH"];
					if (dr["WLHLX"] != null)
						if (!System.DBNull.Equals(dr["WLHLX"], System.DBNull.Value))
							obj.WLHLX = (string)dr["WLHLX"];
					if (dr["YSDJH"] != null)
						if (!System.DBNull.Equals(dr["YSDJH"], System.DBNull.Value))
							obj.YSDJH = (string)dr["YSDJH"];
					if (dr["DJLX"] != null)
						if (!System.DBNull.Equals(dr["DJLX"], System.DBNull.Value))
							obj.DJLX = (int)dr["DJLX"];
					if (dr["HBLX"] != null)
						if (!System.DBNull.Equals(dr["HBLX"], System.DBNull.Value))
							obj.HBLX = (string)dr["HBLX"];
					if (dr["YFJE"] != null)
						if (!System.DBNull.Equals(dr["YFJE"], System.DBNull.Value))
							obj.YFJE = (double)dr["YFJE"];
					if (dr["FKRQ"] != null)
						if (!System.DBNull.Equals(dr["FKRQ"], System.DBNull.Value))
							obj.FKRQ = (DateTime)dr["FKRQ"];
					if (dr["HXYE"] != null)
						if (!System.DBNull.Equals(dr["HXYE"], System.DBNull.Value))
							obj.HXYE = (double)dr["HXYE"];
					if (dr["ZDR"] != null)
						if (!System.DBNull.Equals(dr["ZDR"], System.DBNull.Value))
							obj.ZDR = (string)dr["ZDR"];
					if (dr["ZTBJ"] != null)
						if (!System.DBNull.Equals(dr["ZTBJ"], System.DBNull.Value))
							obj.ZTBJ = (string)dr["ZTBJ"];
					if (dr["BZ"] != null)
						if (!System.DBNull.Equals(dr["BZ"], System.DBNull.Value))
							obj.BZ = (string)dr["BZ"];
					if (dr["GZBJ"] != null)
						if (!System.DBNull.Equals(dr["GZBJ"], System.DBNull.Value))
							obj.GZBJ = (string)dr["GZBJ"];
					result.Add(obj);
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("FindCW_FKD()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
	
	}
}
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -