📄 cw_tjdxm.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_TJDXM的定义
	///  根据表 CW_TJDXM
	/// </summary>
	
	public class CW_TJDXM
	{
		/// <summary>
		/// 对象CW_TJDXM的构造函数
		/// </summary>
		public CW_TJDXM()
		{
			m_TJDH = "";
			m_CKDM = "";
			m_KWDM = "";
			m_CPDM = "";
			m_ZLZK = "";
			m_PC = "";
			m_TZSL = 0;
			m_TZQJG = 0;
			m_TZHJG = 0;
			m_TZYY = "";
			m_SHYJ = "";
		}
		
		private string m_TJDH;
		private string m_CKDM;
		private string m_KWDM;
		private string m_CPDM;
		private string m_ZLZK;
		private string m_PC;
		private double m_TZSL;
		private double m_TZQJG;
		private double m_TZHJG;
		private string m_TZYY;
		private string m_SHYJ;
		
		/// <summary>
		/// 属性 TJDH
		/// </summary>
		public string TJDH
		{
			get
			{
				return m_TJDH;
			}
			set
			{
				m_TJDH = value;
			}
		}
		
		/// <summary>
		/// 属性 CKDM
		/// </summary>
		public string CKDM
		{
			get
			{
				return m_CKDM;
			}
			set
			{
				m_CKDM = value;
			}
		}
		
		/// <summary>
		/// 属性 KWDM
		/// </summary>
		public string KWDM
		{
			get
			{
				return m_KWDM;
			}
			set
			{
				m_KWDM = value;
			}
		}
		
		/// <summary>
		/// 属性 CPDM
		/// </summary>
		public string CPDM
		{
			get
			{
				return m_CPDM;
			}
			set
			{
				m_CPDM = value;
			}
		}
		
		/// <summary>
		/// 属性 ZLZK
		/// </summary>
		public string ZLZK
		{
			get
			{
				return m_ZLZK;
			}
			set
			{
				m_ZLZK = value;
			}
		}
		
		/// <summary>
		/// 属性 PC
		/// </summary>
		public string PC
		{
			get
			{
				return m_PC;
			}
			set
			{
				m_PC = value;
			}
		}
		
		/// <summary>
		/// 属性 TZSL
		/// </summary>
		public double TZSL
		{
			get
			{
				return m_TZSL;
			}
			set
			{
				m_TZSL = value;
			}
		}
		
		/// <summary>
		/// 属性 TZQJG
		/// </summary>
		public double TZQJG
		{
			get
			{
				return m_TZQJG;
			}
			set
			{
				m_TZQJG = value;
			}
		}
		
		/// <summary>
		/// 属性 TZHJG
		/// </summary>
		public double TZHJG
		{
			get
			{
				return m_TZHJG;
			}
			set
			{
				m_TZHJG = value;
			}
		}
		
		/// <summary>
		/// 属性 TZYY
		/// </summary>
		public string TZYY
		{
			get
			{
				return m_TZYY;
			}
			set
			{
				m_TZYY = value;
			}
		}
		
		/// <summary>
		/// 属性 SHYJ
		/// </summary>
		public string SHYJ
		{
			get
			{
				return m_SHYJ;
			}
			set
			{
				m_SHYJ = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 实现对 CW_TJDXM对象的管理
	/// </summary>
	
	public class CW_TJDXMMgr
	{
		/// <summary>
		///  添加新的CW_TJDXM对象
		/// </summary>
		/// <param name="theCW_TJDXM">要添加的CW_TJDXM对象</param>
		
		public bool AddCW_TJDXM(SqlConnection cn,CW_TJDXM theCW_TJDXM)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "insert into CW_TJDXM (TJDH, CKDM, KWDM, CPDM, ZLZK, PC, TZSL, TZQJG, TZHJG, TZYY, SHYJ) values (@TJDH, @CKDM, @KWDM, @CPDM, @ZLZK, @PC, @TZSL, @TZQJG, @TZHJG, @TZYY, @SHYJ)";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@TJDH", theCW_TJDXM.TJDH);
				cmd.Parameters.Add ("@CKDM", theCW_TJDXM.CKDM);
				cmd.Parameters.Add ("@KWDM", theCW_TJDXM.KWDM);
				cmd.Parameters.Add ("@CPDM", theCW_TJDXM.CPDM);
				cmd.Parameters.Add ("@ZLZK", theCW_TJDXM.ZLZK);
				cmd.Parameters.Add ("@PC", theCW_TJDXM.PC);
				cmd.Parameters.Add ("@TZSL", theCW_TJDXM.TZSL);
				cmd.Parameters.Add ("@TZQJG", theCW_TJDXM.TZQJG);
				cmd.Parameters.Add ("@TZHJG", theCW_TJDXM.TZHJG);
				cmd.Parameters.Add ("@TZYY", theCW_TJDXM.TZYY);
				cmd.Parameters.Add ("@SHYJ", theCW_TJDXM.SHYJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_TJDXM(CW_TJDXM theCW_TJDXM)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_TJDXM对象
		/// </summary>
		/// <param name="theCW_TJDXM">要更新的CW_TJDXM对象</param>
		
		public bool UpdateCW_TJDXM(SqlConnection cn,CW_TJDXM theCW_TJDXM)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "update CW_TJDXM set TZSL=@TZSL, TZQJG=@TZQJG, TZHJG=@TZHJG, TZYY=@TZYY, SHYJ=@SHYJ where TJDH=@TJDH and CKDM=@CKDM and KWDM=@KWDM and CPDM=@CPDM and ZLZK=@ZLZK and PC=@PC";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@TJDH", theCW_TJDXM.TJDH);
				cmd.Parameters.Add ("@CKDM", theCW_TJDXM.CKDM);
				cmd.Parameters.Add ("@KWDM", theCW_TJDXM.KWDM);
				cmd.Parameters.Add ("@CPDM", theCW_TJDXM.CPDM);
				cmd.Parameters.Add ("@ZLZK", theCW_TJDXM.ZLZK);
				cmd.Parameters.Add ("@PC", theCW_TJDXM.PC);
				cmd.Parameters.Add ("@TZSL", theCW_TJDXM.TZSL);
				cmd.Parameters.Add ("@TZQJG", theCW_TJDXM.TZQJG);
				cmd.Parameters.Add ("@TZHJG", theCW_TJDXM.TZHJG);
				cmd.Parameters.Add ("@TZYY", theCW_TJDXM.TZYY);
				cmd.Parameters.Add ("@SHYJ", theCW_TJDXM.SHYJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_TJDXM(CW_TJDXM theCW_TJDXM)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  删除CW_TJDXM对象
		/// </summary>
		/// <param name="TJDH">主键</param>
		/// <param name="CKDM">主键</param>
		/// <param name="KWDM">主键</param>
		/// <param name="CPDM">主键</param>
		/// <param name="ZLZK">主键</param>
		/// <param name="PC">主键</param>
		
		public bool DelCW_TJDXM(SqlConnection cn,string TJDH, string CKDM, string KWDM, string CPDM, string ZLZK, string PC)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "delete from CW_TJDXM where TJDH=@TJDH and CKDM=@CKDM and KWDM=@KWDM and CPDM=@CPDM and ZLZK=@ZLZK and PC=@PC";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@TJDH", TJDH);
				cmd.Parameters.Add ("@CKDM", CKDM);
				cmd.Parameters.Add ("@KWDM", KWDM);
				cmd.Parameters.Add ("@CPDM", CPDM);
				cmd.Parameters.Add ("@ZLZK", ZLZK);
				cmd.Parameters.Add ("@PC", PC);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_TJDXM(string TJDH, string CKDM, string KWDM, string CPDM, string ZLZK, string PC)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根据主键标识获得CW_TJDXM对象
		/// </summary>
		/// <param name="TJDH">主键</param>
		/// <param name="CKDM">主键</param>
		/// <param name="KWDM">主键</param>
		/// <param name="CPDM">主键</param>
		/// <param name="ZLZK">主键</param>
		/// <param name="PC">主键</param>
		
		public CW_TJDXM GetCW_TJDXM(string TJDH, string CKDM, string KWDM, string CPDM, string ZLZK, string PC)
		{
			try
			{
				CW_TJDXM result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_TJDXM where TJDH=@TJDH and CKDM=@CKDM and KWDM=@KWDM and CPDM=@CPDM and ZLZK=@ZLZK and PC=@PC";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@TJDH", TJDH);
				cmd.Parameters.Add ("@CKDM", CKDM);
				cmd.Parameters.Add ("@KWDM", KWDM);
				cmd.Parameters.Add ("@CPDM", CPDM);
				cmd.Parameters.Add ("@ZLZK", ZLZK);
				cmd.Parameters.Add ("@PC", PC);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_TJDXM();
					if (dr["TJDH"] != null)
						if (!System.DBNull.Equals(dr["TJDH"], System.DBNull.Value))
							result.TJDH = (string)dr["TJDH"];
					if (dr["CKDM"] != null)
						if (!System.DBNull.Equals(dr["CKDM"], System.DBNull.Value))
							result.CKDM = (string)dr["CKDM"];
					if (dr["KWDM"] != null)
						if (!System.DBNull.Equals(dr["KWDM"], System.DBNull.Value))
							result.KWDM = (string)dr["KWDM"];
					if (dr["CPDM"] != null)
						if (!System.DBNull.Equals(dr["CPDM"], System.DBNull.Value))
							result.CPDM = (string)dr["CPDM"];
					if (dr["ZLZK"] != null)
						if (!System.DBNull.Equals(dr["ZLZK"], System.DBNull.Value))
							result.ZLZK = (string)dr["ZLZK"];
					if (dr["PC"] != null)
						if (!System.DBNull.Equals(dr["PC"], System.DBNull.Value))
							result.PC = (string)dr["PC"];
					if (dr["TZSL"] != null)
						if (!System.DBNull.Equals(dr["TZSL"], System.DBNull.Value))
							result.TZSL = (double)dr["TZSL"];
					if (dr["TZQJG"] != null)
						if (!System.DBNull.Equals(dr["TZQJG"], System.DBNull.Value))
							result.TZQJG = (double)dr["TZQJG"];
					if (dr["TZHJG"] != null)
						if (!System.DBNull.Equals(dr["TZHJG"], System.DBNull.Value))
							result.TZHJG = (double)dr["TZHJG"];
					if (dr["TZYY"] != null)
						if (!System.DBNull.Equals(dr["TZYY"], System.DBNull.Value))
							result.TZYY = (string)dr["TZYY"];
					if (dr["SHYJ"] != null)
						if (!System.DBNull.Equals(dr["SHYJ"], System.DBNull.Value))
							result.SHYJ = (string)dr["SHYJ"];
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("GetCW_TJDXM(string TJDH, string CKDM, string KWDM, string CPDM, string ZLZK, string PC)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_TJDXM对象
		/// </summary>
	
		public ArrayList FindCW_TJDXM()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_TJDXM";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_TJDXM obj = new CW_TJDXM();
					if (dr["TJDH"] != null)
						if (!System.DBNull.Equals(dr["TJDH"], System.DBNull.Value))
							obj.TJDH = (string)dr["TJDH"];
					if (dr["CKDM"] != null)
						if (!System.DBNull.Equals(dr["CKDM"], System.DBNull.Value))
							obj.CKDM = (string)dr["CKDM"];
					if (dr["KWDM"] != null)
						if (!System.DBNull.Equals(dr["KWDM"], System.DBNull.Value))
							obj.KWDM = (string)dr["KWDM"];
					if (dr["CPDM"] != null)
						if (!System.DBNull.Equals(dr["CPDM"], System.DBNull.Value))
							obj.CPDM = (string)dr["CPDM"];
					if (dr["ZLZK"] != null)
						if (!System.DBNull.Equals(dr["ZLZK"], System.DBNull.Value))
							obj.ZLZK = (string)dr["ZLZK"];
					if (dr["PC"] != null)
						if (!System.DBNull.Equals(dr["PC"], System.DBNull.Value))
							obj.PC = (string)dr["PC"];
					if (dr["TZSL"] != null)
						if (!System.DBNull.Equals(dr["TZSL"], System.DBNull.Value))
							obj.TZSL = (double)dr["TZSL"];
					if (dr["TZQJG"] != null)
						if (!System.DBNull.Equals(dr["TZQJG"], System.DBNull.Value))
							obj.TZQJG = (double)dr["TZQJG"];
					if (dr["TZHJG"] != null)
						if (!System.DBNull.Equals(dr["TZHJG"], System.DBNull.Value))
							obj.TZHJG = (double)dr["TZHJG"];
					if (dr["TZYY"] != null)
						if (!System.DBNull.Equals(dr["TZYY"], System.DBNull.Value))
							obj.TZYY = (string)dr["TZYY"];
					if (dr["SHYJ"] != null)
						if (!System.DBNull.Equals(dr["SHYJ"], System.DBNull.Value))
							obj.SHYJ = (string)dr["SHYJ"];
					result.Add(obj);
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("FindCW_TJDXM()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
	
	}
}
⌨️ 快捷键说明

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