📄 cw_gdzc.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_GDZC的定义
	///  根据表 CW_GDZC
	/// </summary>
	
	public class CW_GDZC
	{
		/// <summary>
		/// 对象CW_GDZC的构造函数
		/// </summary>
		public CW_GDZC()
		{
			m_ZCBH = 0;
			m_JGDM = "";
			m_ZCMC = "";
			m_GGXH = "";
			m_GMRQ = DateTime.Now;
			m_GMJE = 0;
			m_YZJL = 0;
			m_BGR = "";
			m_ZTBJ = "";
			m_BZ = "";
		}
		
		private int m_ZCBH;
		private string m_JGDM;
		private string m_ZCMC;
		private string m_GGXH;
		private DateTime m_GMRQ;
		private double m_GMJE;
		private double m_YZJL;
		private string m_BGR;
		private string m_ZTBJ;
		private string m_BZ;
		
		/// <summary>
		/// 属性 ZCBH
		/// </summary>
		public int ZCBH
		{
			get
			{
				return m_ZCBH;
			}
			set
			{
				m_ZCBH = value;
			}
		}
		
		/// <summary>
		/// 属性 JGDM
		/// </summary>
		public string JGDM
		{
			get
			{
				return m_JGDM;
			}
			set
			{
				m_JGDM = value;
			}
		}
		
		/// <summary>
		/// 属性 ZCMC
		/// </summary>
		public string ZCMC
		{
			get
			{
				return m_ZCMC;
			}
			set
			{
				m_ZCMC = value;
			}
		}
		
		/// <summary>
		/// 属性 GGXH
		/// </summary>
		public string GGXH
		{
			get
			{
				return m_GGXH;
			}
			set
			{
				m_GGXH = value;
			}
		}
		
		/// <summary>
		/// 属性 GMRQ
		/// </summary>
		public DateTime GMRQ
		{
			get
			{
				return m_GMRQ;
			}
			set
			{
				m_GMRQ = value;
			}
		}
		
		/// <summary>
		/// 属性 GMJE
		/// </summary>
		public double GMJE
		{
			get
			{
				return m_GMJE;
			}
			set
			{
				m_GMJE = value;
			}
		}
		
		/// <summary>
		/// 属性 YZJL
		/// </summary>
		public double YZJL
		{
			get
			{
				return m_YZJL;
			}
			set
			{
				m_YZJL = value;
			}
		}
		
		/// <summary>
		/// 属性 BGR
		/// </summary>
		public string BGR
		{
			get
			{
				return m_BGR;
			}
			set
			{
				m_BGR = 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;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 实现对 CW_GDZC对象的管理
	/// </summary>
	
	public class CW_GDZCMgr
	{
		/// <summary>
		///  添加新的CW_GDZC对象
		/// </summary>
		/// <param name="theCW_GDZC">要添加的CW_GDZC对象</param>
		
		public bool AddCW_GDZC(System.Data.SqlClient.SqlConnection cn ,CW_GDZC theCW_GDZC)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "insert into CW_GDZC (ZCBH, JGDM, ZCMC, GGXH, GMRQ, GMJE, YZJL, BGR, ZTBJ, BZ) values (@ZCBH, @JGDM, @ZCMC, @GGXH, @GMRQ, @GMJE, @YZJL, @BGR, @ZTBJ, @BZ)";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@ZCBH", theCW_GDZC.ZCBH);
				cmd.Parameters.Add ("@JGDM", theCW_GDZC.JGDM);
				cmd.Parameters.Add ("@ZCMC", theCW_GDZC.ZCMC);
				cmd.Parameters.Add ("@GGXH", theCW_GDZC.GGXH);
				cmd.Parameters.Add ("@GMRQ", theCW_GDZC.GMRQ);
				cmd.Parameters.Add ("@GMJE", theCW_GDZC.GMJE);
				cmd.Parameters.Add ("@YZJL", theCW_GDZC.YZJL);
				cmd.Parameters.Add ("@BGR", theCW_GDZC.BGR);
				cmd.Parameters.Add ("@ZTBJ", theCW_GDZC.ZTBJ);
				cmd.Parameters.Add ("@BZ", theCW_GDZC.BZ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_GDZC(CW_GDZC theCW_GDZC)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_GDZC对象
		/// </summary>
		/// <param name="theCW_GDZC">要更新的CW_GDZC对象</param>
		
		public bool UpdateCW_GDZC(System.Data.SqlClient.SqlConnection cn ,CW_GDZC theCW_GDZC)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "update CW_GDZC set ZCMC=@ZCMC, GGXH=@GGXH, GMRQ=@GMRQ, GMJE=@GMJE, YZJL=@YZJL, BGR=@BGR, ZTBJ=@ZTBJ, BZ=@BZ where ZCBH=@ZCBH and JGDM=@JGDM";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@ZCBH", theCW_GDZC.ZCBH);
				cmd.Parameters.Add ("@JGDM", theCW_GDZC.JGDM);
				cmd.Parameters.Add ("@ZCMC", theCW_GDZC.ZCMC);
				cmd.Parameters.Add ("@GGXH", theCW_GDZC.GGXH);
				cmd.Parameters.Add ("@GMRQ", theCW_GDZC.GMRQ);
				cmd.Parameters.Add ("@GMJE", theCW_GDZC.GMJE);
				cmd.Parameters.Add ("@YZJL", theCW_GDZC.YZJL);
				cmd.Parameters.Add ("@BGR", theCW_GDZC.BGR);
				cmd.Parameters.Add ("@ZTBJ", theCW_GDZC.ZTBJ);
				cmd.Parameters.Add ("@BZ", theCW_GDZC.BZ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_GDZC(CW_GDZC theCW_GDZC)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  删除CW_GDZC对象
		/// </summary>
		/// <param name="ZCBH">主键</param>
		/// <param name="JGDM">主键</param>
		
		public bool DelCW_GDZC(System.Data.SqlClient.SqlConnection cn ,int ZCBH, string JGDM)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "delete from CW_GDZC where ZCBH=@ZCBH and JGDM=@JGDM";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@ZCBH", ZCBH);
				cmd.Parameters.Add ("@JGDM", JGDM);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_GDZC(int ZCBH, string JGDM)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根据主键标识获得CW_GDZC对象
		/// </summary>
		/// <param name="ZCBH">主键</param>
		/// <param name="JGDM">主键</param>
		
		public CW_GDZC GetCW_GDZC(int ZCBH, string JGDM)
		{
			try
			{
				CW_GDZC result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_GDZC where ZCBH=@ZCBH and JGDM=@JGDM";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@ZCBH", ZCBH);
				cmd.Parameters.Add ("@JGDM", JGDM);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_GDZC();
					if (dr["ZCBH"] != null)
						if (!System.DBNull.Equals(dr["ZCBH"], System.DBNull.Value))
							result.ZCBH = (int)dr["ZCBH"];
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							result.JGDM = (string)dr["JGDM"];
					if (dr["ZCMC"] != null)
						if (!System.DBNull.Equals(dr["ZCMC"], System.DBNull.Value))
							result.ZCMC = (string)dr["ZCMC"];
					if (dr["GGXH"] != null)
						if (!System.DBNull.Equals(dr["GGXH"], System.DBNull.Value))
							result.GGXH = (string)dr["GGXH"];
					if (dr["GMRQ"] != null)
						if (!System.DBNull.Equals(dr["GMRQ"], System.DBNull.Value))
							result.GMRQ = (DateTime)dr["GMRQ"];
					if (dr["GMJE"] != null)
						if (!System.DBNull.Equals(dr["GMJE"], System.DBNull.Value))
							result.GMJE = (double)dr["GMJE"];
					if (dr["YZJL"] != null)
						if (!System.DBNull.Equals(dr["YZJL"], System.DBNull.Value))
							result.YZJL = (double)dr["YZJL"];
					if (dr["BGR"] != null)
						if (!System.DBNull.Equals(dr["BGR"], System.DBNull.Value))
							result.BGR = (string)dr["BGR"];
					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"];
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("GetCW_GDZC(int ZCBH, string JGDM)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_GDZC对象
		/// </summary>
	
		public ArrayList FindCW_GDZC()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_GDZC";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_GDZC obj = new CW_GDZC();
					if (dr["ZCBH"] != null)
						if (!System.DBNull.Equals(dr["ZCBH"], System.DBNull.Value))
							obj.ZCBH = (int)dr["ZCBH"];
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							obj.JGDM = (string)dr["JGDM"];
					if (dr["ZCMC"] != null)
						if (!System.DBNull.Equals(dr["ZCMC"], System.DBNull.Value))
							obj.ZCMC = (string)dr["ZCMC"];
					if (dr["GGXH"] != null)
						if (!System.DBNull.Equals(dr["GGXH"], System.DBNull.Value))
							obj.GGXH = (string)dr["GGXH"];
					if (dr["GMRQ"] != null)
						if (!System.DBNull.Equals(dr["GMRQ"], System.DBNull.Value))
							obj.GMRQ = (DateTime)dr["GMRQ"];
					if (dr["GMJE"] != null)
						if (!System.DBNull.Equals(dr["GMJE"], System.DBNull.Value))
							obj.GMJE = (double)dr["GMJE"];
					if (dr["YZJL"] != null)
						if (!System.DBNull.Equals(dr["YZJL"], System.DBNull.Value))
							obj.YZJL = (double)dr["YZJL"];
					if (dr["BGR"] != null)
						if (!System.DBNull.Equals(dr["BGR"], System.DBNull.Value))
							obj.BGR = (string)dr["BGR"];
					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"];
					result.Add(obj);
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("FindCW_GDZC()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
	
	}
}
⌨️ 快捷键说明

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