📄 cw_ysd.cs

📁 ASP.NET的一些开发实例,有论坛管理系统等
💻 CS
📖 第 1 页 / 共 2 页
字号:
上一页 12
				m_YSKSJ = value;
			}
		}
		
	}
	
}
namespace Com.Ascs.Plp.CW
{
	/// <summary>
	/// 实现对 CW_YSD对象的管理
	/// </summary>
	
	public class CW_YSDMgr
	{
		/// <summary>
		///  添加新的CW_YSD对象
		/// </summary>
		/// <param name="theCW_YSD">要添加的CW_YSD对象</param>
		
		public bool AddCW_YSD(SqlConnection cn,CW_YSD theCW_YSD)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				string sql;
				sql = "insert into CW_YSD (YSDH, JGDM, WLHLX, WLHBH, YSDJH, DJLX, HBLX, YSJE, SJYSJE, YSYE, FZR, ZDR, SHR, ZTBJ, BZ, CJR, CJRQ, XGR, XGRQ, QCBJ, GZBJ, YSKSJ) values (@YSDH, @JGDM, @WLHLX, @WLHBH, @YSDJH, @DJLX, @HBLX, @YSJE, @SJYSJE, @YSYE, @FZR, @ZDR, @SHR, @ZTBJ, @BZ, @CJR, @CJRQ, @XGR, @XGRQ, @QCBJ, @GZBJ, @YSKSJ)";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@YSDH", theCW_YSD.YSDH);
				cmd.Parameters.Add ("@JGDM", theCW_YSD.JGDM);
				cmd.Parameters.Add ("@WLHLX", theCW_YSD.WLHLX);
				cmd.Parameters.Add ("@WLHBH", theCW_YSD.WLHBH);
				cmd.Parameters.Add ("@YSDJH", theCW_YSD.YSDJH);
				cmd.Parameters.Add ("@DJLX", theCW_YSD.DJLX);
				cmd.Parameters.Add ("@HBLX", theCW_YSD.HBLX);
				cmd.Parameters.Add ("@YSJE", theCW_YSD.YSJE);
				cmd.Parameters.Add ("@SJYSJE", theCW_YSD.SJYSJE);
				cmd.Parameters.Add ("@YSYE", theCW_YSD.YSYE);
				if(theCW_YSD.FZR==null || theCW_YSD.FZR=="")
					cmd.Parameters.Add ("@FZR", DBNull.Value);
				else
					cmd.Parameters.Add ("@FZR", theCW_YSD.FZR);
				cmd.Parameters.Add ("@ZDR", theCW_YSD.ZDR);
				if(theCW_YSD.SHR==null)
					cmd.Parameters.Add ("@SHR", DBNull.Value);
				else
					cmd.Parameters.Add ("@SHR", theCW_YSD.SHR);
				cmd.Parameters.Add ("@ZTBJ", theCW_YSD.ZTBJ);
				cmd.Parameters.Add ("@BZ", theCW_YSD.BZ);
				cmd.Parameters.Add ("@CJR", theCW_YSD.CJR);
				cmd.Parameters.Add ("@CJRQ", theCW_YSD.CJRQ);
				if(theCW_YSD.XGR==null)
					cmd.Parameters.Add ("@XGR", DBNull.Value);
				else
					cmd.Parameters.Add ("@XGR", theCW_YSD.XGR);
				cmd.Parameters.Add ("@XGRQ", theCW_YSD.XGRQ);
				cmd.Parameters.Add ("@QCBJ", theCW_YSD.QCBJ);
				cmd.Parameters.Add ("@GZBJ", theCW_YSD.GZBJ);
//				if(theCW_YSD.YSKSJ==null)
//					cmd.Parameters.Add ("@YSKSJ", DBNull.Value);
//				else
					cmd.Parameters.Add ("@YSKSJ", theCW_YSD.YSKSJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("AddCW_YSD(CW_YSD theCW_YSD)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  更新CW_YSD对象
		/// </summary>
		/// <param name="theCW_YSD">要更新的CW_YSD对象</param>
		
		public bool UpdateCW_YSD(SqlConnection cn,CW_YSD theCW_YSD)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
//				
				string sql;
				sql = "update CW_YSD set JGDM=@JGDM, WLHLX=@WLHLX, WLHBH=@WLHBH, YSDJH=@YSDJH, DJLX=@DJLX, HBLX=@HBLX, YSJE=@YSJE, SJYSJE=@SJYSJE, YSYE=@YSYE, FZR=@FZR, ZDR=@ZDR, SHR=@SHR, ZTBJ=@ZTBJ, BZ=@BZ, CJR=@CJR, CJRQ=@CJRQ, XGR=@XGR, XGRQ=@XGRQ, QCBJ=@QCBJ, GZBJ=@GZBJ, YSKSJ=@YSKSJ where YSDH=@YSDH";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@YSDH", theCW_YSD.YSDH);
				cmd.Parameters.Add ("@JGDM", theCW_YSD.JGDM);
				cmd.Parameters.Add ("@WLHLX", theCW_YSD.WLHLX);
				cmd.Parameters.Add ("@WLHBH", theCW_YSD.WLHBH);
				cmd.Parameters.Add ("@YSDJH", theCW_YSD.YSDJH);
				cmd.Parameters.Add ("@DJLX", theCW_YSD.DJLX);
				cmd.Parameters.Add ("@HBLX", theCW_YSD.HBLX);
				cmd.Parameters.Add ("@YSJE", theCW_YSD.YSJE);
				cmd.Parameters.Add ("@SJYSJE", theCW_YSD.SJYSJE);
				cmd.Parameters.Add ("@YSYE", theCW_YSD.YSYE);
				if(theCW_YSD.FZR==null || theCW_YSD.FZR=="")
					cmd.Parameters.Add ("@FZR", DBNull.Value);
				else
					cmd.Parameters.Add ("@FZR", theCW_YSD.FZR);
				cmd.Parameters.Add ("@ZDR", theCW_YSD.ZDR);
				if(theCW_YSD.SHR==null)
					cmd.Parameters.Add ("@SHR", DBNull.Value);
				else
					cmd.Parameters.Add ("@SHR", theCW_YSD.SHR);
				cmd.Parameters.Add ("@ZTBJ", theCW_YSD.ZTBJ);
				cmd.Parameters.Add ("@BZ", theCW_YSD.BZ);
				cmd.Parameters.Add ("@CJR", theCW_YSD.CJR);
				cmd.Parameters.Add ("@CJRQ", theCW_YSD.CJRQ);
				if(theCW_YSD.XGR==null)
					cmd.Parameters.Add ("@XGR", DBNull.Value);
				else
					cmd.Parameters.Add ("@XGR", theCW_YSD.XGR);
				cmd.Parameters.Add ("@XGRQ", theCW_YSD.XGRQ);
				cmd.Parameters.Add ("@QCBJ", theCW_YSD.QCBJ);
				cmd.Parameters.Add ("@GZBJ", theCW_YSD.GZBJ);
				cmd.Parameters.Add ("@YSKSJ", theCW_YSD.YSKSJ);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_YSD(CW_YSD theCW_YSD)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  删除CW_YSD对象
		/// </summary>
		/// <param name="YSDH">主键</param>
		
		public bool DelCW_YSD(SqlConnection cn,string YSDH)
		{
			try
			{
//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
//				cn.Open();
				
				//
				string sql;
				sql = "delete from CW_YSDXM where YSDH=@YSDH";
				SqlCommand  cmd = new SqlCommand(sql, cn);				
				cmd.Parameters.Add ("@YSDH", YSDH);				
				cmd.ExecuteNonQuery();

				
				sql = "delete from CW_YSD where YSDH=@YSDH";
				
				cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@YSDH", YSDH);
				
				cmd.ExecuteNonQuery();
				
//				cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_YSD(string YSDH)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根据主键标识获得CW_YSD对象
		/// </summary>
		/// <param name="YSDH">主键</param>
		
		public CW_YSD GetCW_YSD(string YSDH)
		{
			try
			{
				CW_YSD result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_YSD where YSDH=@YSDH";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@YSDH", YSDH);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_YSD();
					if (dr["YSDH"] != null)
						if (!System.DBNull.Equals(dr["YSDH"], System.DBNull.Value))
							result.YSDH = (string)dr["YSDH"];
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							result.JGDM = (string)dr["JGDM"];
					if (dr["WLHLX"] != null)
						if (!System.DBNull.Equals(dr["WLHLX"], System.DBNull.Value))
							result.WLHLX = (string)dr["WLHLX"];
					if (dr["WLHBH"] != null)
						if (!System.DBNull.Equals(dr["WLHBH"], System.DBNull.Value))
							result.WLHBH = (string)dr["WLHBH"];
					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["YSJE"] != null)
						if (!System.DBNull.Equals(dr["YSJE"], System.DBNull.Value))
							result.YSJE = (double)dr["YSJE"];
					if (dr["SJYSJE"] != null)
						if (!System.DBNull.Equals(dr["SJYSJE"], System.DBNull.Value))
							result.SJYSJE = (double)dr["SJYSJE"];
					if (dr["YSYE"] != null)
						if (!System.DBNull.Equals(dr["YSYE"], System.DBNull.Value))
							result.YSYE = (double)dr["YSYE"];
					if (dr["FZR"] != null)
						if (!System.DBNull.Equals(dr["FZR"], System.DBNull.Value))
							result.FZR = (string)dr["FZR"];
					if (dr["ZDR"] != null)
						if (!System.DBNull.Equals(dr["ZDR"], System.DBNull.Value))
							result.ZDR = (string)dr["ZDR"];
					if (dr["SHR"] != null)
						if (!System.DBNull.Equals(dr["SHR"], System.DBNull.Value))
							result.SHR = (string)dr["SHR"];
					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["CJR"] != null)
						if (!System.DBNull.Equals(dr["CJR"], System.DBNull.Value))
							result.CJR = (string)dr["CJR"];
					if (dr["CJRQ"] != null)
						if (!System.DBNull.Equals(dr["CJRQ"], System.DBNull.Value))
							result.CJRQ = (DateTime)dr["CJRQ"];
					if (dr["XGR"] != null)
						if (!System.DBNull.Equals(dr["XGR"], System.DBNull.Value))
							result.XGR = (string)dr["XGR"];
					if (dr["XGRQ"] != null)
						if (!System.DBNull.Equals(dr["XGRQ"], System.DBNull.Value))
							result.XGRQ = (DateTime)dr["XGRQ"];
					if (dr["QCBJ"] != null)
						if (!System.DBNull.Equals(dr["QCBJ"], System.DBNull.Value))
							result.QCBJ = (string)dr["QCBJ"];
					if (dr["GZBJ"] != null)
						if (!System.DBNull.Equals(dr["GZBJ"], System.DBNull.Value))
							result.GZBJ = (string)dr["GZBJ"];
					if (dr["YSKSJ"] != null)
						if (!System.DBNull.Equals(dr["YSKSJ"], System.DBNull.Value))
							result.YSKSJ = (DateTime)dr["YSKSJ"];
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("GetCW_YSD(string YSDH)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_YSD对象
		/// </summary>
	
		public ArrayList FindCW_YSD()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_YSD";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_YSD obj = new CW_YSD();
					if (dr["YSDH"] != null)
						if (!System.DBNull.Equals(dr["YSDH"], System.DBNull.Value))
							obj.YSDH = (string)dr["YSDH"];
					if (dr["JGDM"] != null)
						if (!System.DBNull.Equals(dr["JGDM"], System.DBNull.Value))
							obj.JGDM = (string)dr["JGDM"];
					if (dr["WLHLX"] != null)
						if (!System.DBNull.Equals(dr["WLHLX"], System.DBNull.Value))
							obj.WLHLX = (string)dr["WLHLX"];
					if (dr["WLHBH"] != null)
						if (!System.DBNull.Equals(dr["WLHBH"], System.DBNull.Value))
							obj.WLHBH = (string)dr["WLHBH"];
					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["YSJE"] != null)
						if (!System.DBNull.Equals(dr["YSJE"], System.DBNull.Value))
							obj.YSJE = (double)dr["YSJE"];
					if (dr["SJYSJE"] != null)
						if (!System.DBNull.Equals(dr["SJYSJE"], System.DBNull.Value))
							obj.SJYSJE = (double)dr["SJYSJE"];
					if (dr["YSYE"] != null)
						if (!System.DBNull.Equals(dr["YSYE"], System.DBNull.Value))
							obj.YSYE = (double)dr["YSYE"];
					if (dr["FZR"] != null)
						if (!System.DBNull.Equals(dr["FZR"], System.DBNull.Value))
							obj.FZR = (string)dr["FZR"];
					if (dr["ZDR"] != null)
						if (!System.DBNull.Equals(dr["ZDR"], System.DBNull.Value))
							obj.ZDR = (string)dr["ZDR"];
					if (dr["SHR"] != null)
						if (!System.DBNull.Equals(dr["SHR"], System.DBNull.Value))
							obj.SHR = (string)dr["SHR"];
					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["CJR"] != null)
						if (!System.DBNull.Equals(dr["CJR"], System.DBNull.Value))
							obj.CJR = (string)dr["CJR"];
					if (dr["CJRQ"] != null)
						if (!System.DBNull.Equals(dr["CJRQ"], System.DBNull.Value))
							obj.CJRQ = (DateTime)dr["CJRQ"];
					if (dr["XGR"] != null)
						if (!System.DBNull.Equals(dr["XGR"], System.DBNull.Value))
							obj.XGR = (string)dr["XGR"];
					if (dr["XGRQ"] != null)
						if (!System.DBNull.Equals(dr["XGRQ"], System.DBNull.Value))
							obj.XGRQ = (DateTime)dr["XGRQ"];
					if (dr["QCBJ"] != null)
						if (!System.DBNull.Equals(dr["QCBJ"], System.DBNull.Value))
							obj.QCBJ = (string)dr["QCBJ"];
					if (dr["GZBJ"] != null)
						if (!System.DBNull.Equals(dr["GZBJ"], System.DBNull.Value))
							obj.GZBJ = (string)dr["GZBJ"];
					if (dr["YSKSJ"] != null)
						if (!System.DBNull.Equals(dr["YSKSJ"], System.DBNull.Value))
							obj.YSKSJ = (DateTime)dr["YSKSJ"];
					result.Add(obj);
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("FindCW_YSD()");
				LogService.Write (e.Message);
				return null;
			}
		}
	
	
	}
}
上一页 12
⌨️ 快捷键说明

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