📄 cw_fycbjh.cs

📁 企业管理信息化之财务管理系统
💻 CS
字号:

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

namespace Com.Ascs.Plp.CW

{
	/// <summary>
	///  对象CW_FYCBJH的定义
	///  根据表 CW_FYCBJH
	/// </summary>
	
	public class CW_FYCBJH
	{
		/// <summary>
		/// 对象CW_FYCBJH的构造函数
		/// </summary>
		public CW_FYCBJH()
		{
			m_FYCBJHDH = "";
			m_JGDM = "";
			m_ZDR = "";
			m_ZXRLX = "";
			m_ZXR = "";
			m_KJND = "";
			m_KJQJ = "";
			m_ZDSJ = DateTime.Now;
			m_XGR = "";
			m_XGSJ = DateTime.Now;
			m_ZTBJ = "";
			m_BZ = "";
		}
		
		private string m_FYCBJHDH;
		private string m_JGDM;
		private string m_ZDR;
		private string m_ZXRLX;
		private string m_ZXR;
		private string m_KJND;
		private string m_KJQJ;
		private DateTime m_ZDSJ;
		private string m_XGR;
		private DateTime m_XGSJ;
		private string m_ZTBJ;
		private string m_BZ;
		
		/// <summary>
		/// 属性 FYCBJHDH
		/// </summary>
		public string FYCBJHDH
		{
			get
			{
				return m_FYCBJHDH;
			}
			set
			{
				m_FYCBJHDH = value;
			}
		}
		
		/// <summary>
		/// 属性 JGDM
		/// </summary>
		public string JGDM
		{
			get
			{
				return m_JGDM;
			}
			set
			{
				m_JGDM = value;
			}
		}
		
		/// <summary>
		/// 属性 ZDR
		/// </summary>
		public string ZDR
		{
			get
			{
				return m_ZDR;
			}
			set
			{
				m_ZDR = value;
			}
		}
		
		/// <summary>
		/// 属性 ZXRLX
		/// </summary>
		public string ZXRLX
		{
			get
			{
				return m_ZXRLX;
			}
			set
			{
				m_ZXRLX = value;
			}
		}
		
		/// <summary>
		/// 属性 ZXR
		/// </summary>
		public string ZXR
		{
			get
			{
				return m_ZXR;
			}
			set
			{
				m_ZXR = value;
			}
		}
		
		/// <summary>
		/// 属性 KJND
		/// </summary>
		public string KJND
		{
			get
			{
				return m_KJND;
			}
			set
			{
				m_KJND = value;
			}
		}
		
		/// <summary>
		/// 属性 KJQJ
		/// </summary>
		public string KJQJ
		{
			get
			{
				return m_KJQJ;
			}
			set
			{
				m_KJQJ = value;
			}
		}
		
		/// <summary>
		/// 属性 ZDSJ
		/// </summary>
		public DateTime ZDSJ
		{
			get
			{
				return m_ZDSJ;
			}
			set
			{
				m_ZDSJ = value;
			}
		}
		
		/// <summary>
		/// 属性 XGR
		/// </summary>
		public string XGR
		{
			get
			{
				return m_XGR;
			}
			set
			{
				m_XGR = value;
			}
		}
		
		/// <summary>
		/// 属性 XGSJ
		/// </summary>
		public DateTime XGSJ
		{
			get
			{
				return m_XGSJ;
			}
			set
			{
				m_XGSJ = 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_FYCBJH对象的管理
	/// </summary>
	
	public class CW_FYCBJHMgr
	{
		/// <summary>
		///  添加新的CW_FYCBJH对象
		/// </summary>
		/// <param name="theCW_FYCBJH">要添加的CW_FYCBJH对象</param>
		
		public bool AddCW_FYCBJH(SqlConnection cn,CW_FYCBJH theCW_FYCBJH)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
//				
				string sql;
				sql = "insert into CW_FYCBJH (FYCBJHDH, JGDM, ZDR, ZXRLX, ZXR, KJND, KJQJ, ZDSJ, XGR, XGSJ, ZTBJ, BZ) values (@FYCBJHDH, @JGDM, @ZDR, @ZXRLX, @ZXR, @KJND, @KJQJ, @ZDSJ, @XGR, @XGSJ, @ZTBJ, @BZ)";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@FYCBJHDH", theCW_FYCBJH.FYCBJHDH);
				cmd.Parameters.Add ("@JGDM", theCW_FYCBJH.JGDM);
				cmd.Parameters.Add ("@ZDR", theCW_FYCBJH.ZDR);
				cmd.Parameters.Add ("@ZXRLX", theCW_FYCBJH.ZXRLX);
				cmd.Parameters.Add ("@ZXR", theCW_FYCBJH.ZXR);
				cmd.Parameters.Add ("@KJND", theCW_FYCBJH.KJND);
				cmd.Parameters.Add ("@KJQJ", theCW_FYCBJH.KJQJ);
				cmd.Parameters.Add ("@ZDSJ", theCW_FYCBJH.ZDSJ);
				cmd.Parameters.Add ("@XGR", theCW_FYCBJH.XGR);
				cmd.Parameters.Add ("@XGSJ", theCW_FYCBJH.XGSJ);
				cmd.Parameters.Add ("@ZTBJ", theCW_FYCBJH.ZTBJ);
				cmd.Parameters.Add ("@BZ", theCW_FYCBJH.BZ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_FYCBJH(CW_FYCBJH theCW_FYCBJH)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_FYCBJH对象
		/// </summary>
		/// <param name="theCW_FYCBJH">要更新的CW_FYCBJH对象</param>
		
		public bool UpdateCW_FYCBJH(SqlConnection cn,CW_FYCBJH theCW_FYCBJH)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "update CW_FYCBJH set JGDM=@JGDM, ZDR=@ZDR, ZXRLX=@ZXRLX, ZXR=@ZXR, KJND=@KJND, KJQJ=@KJQJ, ZDSJ=@ZDSJ, XGR=@XGR, XGSJ=@XGSJ, ZTBJ=@ZTBJ, BZ=@BZ where FYCBJHDH=@FYCBJHDH";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@FYCBJHDH", theCW_FYCBJH.FYCBJHDH);
				cmd.Parameters.Add ("@JGDM", theCW_FYCBJH.JGDM);
				cmd.Parameters.Add ("@ZDR", theCW_FYCBJH.ZDR);
				cmd.Parameters.Add ("@ZXRLX", theCW_FYCBJH.ZXRLX);
				cmd.Parameters.Add ("@ZXR", theCW_FYCBJH.ZXR);
				cmd.Parameters.Add ("@KJND", theCW_FYCBJH.KJND);
				cmd.Parameters.Add ("@KJQJ", theCW_FYCBJH.KJQJ);
				cmd.Parameters.Add ("@ZDSJ", theCW_FYCBJH.ZDSJ);
				cmd.Parameters.Add ("@XGR", theCW_FYCBJH.XGR);
				cmd.Parameters.Add ("@XGSJ", theCW_FYCBJH.XGSJ);
				cmd.Parameters.Add ("@ZTBJ", theCW_FYCBJH.ZTBJ);
				cmd.Parameters.Add ("@BZ", theCW_FYCBJH.BZ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_FYCBJH(CW_FYCBJH theCW_FYCBJH)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  删除CW_FYCBJH对象
		/// </summary>
		/// <param name="FYCBJHDH">主键</param>
		
		public bool DelCW_FYCBJH(SqlConnection cn,string FYCBJHDH)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
								
				string sql;

				//删除细目
				sql = "delete from CW_FYJHXM where FYCBJHDH=@FYCBJHDH ";
				SqlCommand cmd = new SqlCommand(sql, cn);				
				cmd.Parameters.Add ("@FYCBJHDH", FYCBJHDH);				
				cmd.ExecuteNonQuery();

				//删除主表
				sql = "delete from CW_FYCBJH where FYCBJHDH=@FYCBJHDH";				
				cmd = new SqlCommand(sql, cn);				
				cmd.Parameters.Add ("@FYCBJHDH", FYCBJHDH);				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_FYCBJH(string FYCBJHDH)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根据主键标识获得CW_FYCBJH对象
		/// </summary>
		/// <param name="FYCBJHDH">主键</param>
		
		public CW_FYCBJH GetCW_FYCBJH(string FYCBJHDH)
		{
			try
			{
				CW_FYCBJH result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_FYCBJH where FYCBJHDH=@FYCBJHDH";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@FYCBJHDH", FYCBJHDH);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_FYCBJH();
					if (dr["FYCBJHDH"] != null)
						if (!System.DBNull.Equals(dr["FYCBJHDH"], System.DBNull.Value))
							result.FYCBJHDH = (string)dr["FYCBJHDH"];
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							result.JGDM = (string)dr["JGDM"];
					if (dr["ZDR"] != null)
						if (!System.DBNull.Equals(dr["ZDR"], System.DBNull.Value))
							result.ZDR = (string)dr["ZDR"];
					if (dr["ZXRLX"] != null)
						if (!System.DBNull.Equals(dr["ZXRLX"], System.DBNull.Value))
							result.ZXRLX = (string)dr["ZXRLX"];
					if (dr["ZXR"] != null)
						if (!System.DBNull.Equals(dr["ZXR"], System.DBNull.Value))
							result.ZXR = (string)dr["ZXR"];
					if (dr["KJND"] != null)
						if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
							result.KJND = (string)dr["KJND"];
					if (dr["KJQJ"] != null)
						if (!System.DBNull.Equals(dr["KJQJ"], System.DBNull.Value))
							result.KJQJ = (string)dr["KJQJ"];
					if (dr["ZDSJ"] != null)
						if (!System.DBNull.Equals(dr["ZDSJ"], System.DBNull.Value))
							result.ZDSJ = (DateTime)dr["ZDSJ"];
					if (dr["XGR"] != null)
						if (!System.DBNull.Equals(dr["XGR"], System.DBNull.Value))
							result.XGR = (string)dr["XGR"];
					if (dr["XGSJ"] != null)
						if (!System.DBNull.Equals(dr["XGSJ"], System.DBNull.Value))
							result.XGSJ = (DateTime)dr["XGSJ"];
					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_FYCBJH(string FYCBJHDH)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_FYCBJH对象
		/// </summary>
	
		public ArrayList FindCW_FYCBJH()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_FYCBJH";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_FYCBJH obj = new CW_FYCBJH();
					if (dr["FYCBJHDH"] != null)
						if (!System.DBNull.Equals(dr["FYCBJHDH"], System.DBNull.Value))
							obj.FYCBJHDH = (string)dr["FYCBJHDH"];
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							obj.JGDM = (string)dr["JGDM"];
					if (dr["ZDR"] != null)
						if (!System.DBNull.Equals(dr["ZDR"], System.DBNull.Value))
							obj.ZDR = (string)dr["ZDR"];
					if (dr["ZXRLX"] != null)
						if (!System.DBNull.Equals(dr["ZXRLX"], System.DBNull.Value))
							obj.ZXRLX = (string)dr["ZXRLX"];
					if (dr["ZXR"] != null)
						if (!System.DBNull.Equals(dr["ZXR"], System.DBNull.Value))
							obj.ZXR = (string)dr["ZXR"];
					if (dr["KJND"] != null)
						if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
							obj.KJND = (string)dr["KJND"];
					if (dr["KJQJ"] != null)
						if (!System.DBNull.Equals(dr["KJQJ"], System.DBNull.Value))
							obj.KJQJ = (string)dr["KJQJ"];
					if (dr["ZDSJ"] != null)
						if (!System.DBNull.Equals(dr["ZDSJ"], System.DBNull.Value))
							obj.ZDSJ = (DateTime)dr["ZDSJ"];
					if (dr["XGR"] != null)
						if (!System.DBNull.Equals(dr["XGR"], System.DBNull.Value))
							obj.XGR = (string)dr["XGR"];
					if (dr["XGSJ"] != null)
						if (!System.DBNull.Equals(dr["XGSJ"], System.DBNull.Value))
							obj.XGSJ = (DateTime)dr["XGSJ"];
					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_FYCBJH()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
	
	}
}
⌨️ 快捷键说明

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