cw_kjkm.cs

ASP.NET的一些开发实例,有论坛管理系统等

				cmd.Parameters.Add ("@KMFX", theCW_KJKM.KMFX);
				cmd.Parameters.Add ("@KMJB", theCW_KJKM.KMJB);
				cmd.Parameters.Add ("@SFMX", theCW_KJKM.SFMX);
				cmd.Parameters.Add ("@SFXJHS", theCW_KJKM.SFXJHS);
				cmd.Parameters.Add ("@TYBJ", theCW_KJKM.TYBJ);
				cmd.Parameters.Add ("@SFYJSY", theCW_KJKM.SFYJSY);
				cmd.Parameters.Add ("@SFBMHS", theCW_KJKM.SFBMHS);
				cmd.Parameters.Add ("@SFYGHS", theCW_KJKM.SFYGHS);
				cmd.Parameters.Add ("@SFWLHHS", theCW_KJKM.SFWLHHS);
				
				cmd.ExecuteNonQuery();

				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_KJKM(CW_KJKM theCW_KJKM)");
				LogService.Write (e.Message);
				return false;
			}
		}
		


		/// <summary>
		///  更新CW_KJKM对象
		/// </summary>
		/// <param name="theCW_KJKM">要更新的CW_KJKM对象</param>
		
		public bool UpdateCW_KJKM(SqlConnection cn,CW_KJKM theCW_KJKM)
		{
			try
			{
				//				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				//				cn.Open();
				
				string sql;
				sql = "update CW_KJKM set KMMC=@KMMC, SJKMBM=@SJKMBM, LB=@LB, KMFX=@KMFX, KMJB=@KMJB, SFMX=@SFMX, SFXJHS=@SFXJHS, TYBJ=@TYBJ, SFYJSY=@SFYJSY, SFBMHS=@SFBMHS, SFYGHS=@SFYGHS, SFWLHHS=@SFWLHHS where KJND=@KJND and KMBM=@KMBM";
				
				SqlCommand cmd = new SqlCommand(sql, cn);
				
				cmd.Parameters.Add ("@KJND", theCW_KJKM.KJND);
				cmd.Parameters.Add ("@KMBM", theCW_KJKM.KMBM);
				cmd.Parameters.Add ("@KMMC", theCW_KJKM.KMMC);
				cmd.Parameters.Add ("@SJKMBM", theCW_KJKM.SJKMBM);
				cmd.Parameters.Add ("@LB", theCW_KJKM.LB);
				cmd.Parameters.Add ("@KMFX", theCW_KJKM.KMFX);
				cmd.Parameters.Add ("@KMJB", theCW_KJKM.KMJB);
				cmd.Parameters.Add ("@SFMX", theCW_KJKM.SFMX);
				cmd.Parameters.Add ("@SFXJHS", theCW_KJKM.SFXJHS);
				cmd.Parameters.Add ("@TYBJ", theCW_KJKM.TYBJ);
				cmd.Parameters.Add ("@SFYJSY", theCW_KJKM.SFYJSY);
				cmd.Parameters.Add ("@SFBMHS", theCW_KJKM.SFBMHS);
				cmd.Parameters.Add ("@SFYGHS", theCW_KJKM.SFYGHS);
				cmd.Parameters.Add ("@SFWLHHS", theCW_KJKM.SFWLHHS);
				
				cmd.ExecuteNonQuery();
				
				//cn.Close();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("UpdateCW_KJKM(CW_KJKM theCW_KJKM)");
				LogService.Write (e.Message);
				return false;
			}
		}



		/// <summary>
		///  删除CW_KJKM对象
		/// </summary>
		/// <param name="KJND">主键</param>
		/// <param name="KMBM">主键</param>
		
		public bool DelCW_KJKM(SqlCommand cmd, string KJND, string KMBM)
		{
			try
			{
				//检查该会计科目是否允许删除
				if(CheckChild(cmd, KJND, KMBM, 3) == false || CheckChild(cmd, KJND, KMBM, 4) == false)
				{
					return false;
				}

				string sql;
				sql = "delete from CW_KJKM where KJND=@KJND and KMBM=@KMBM";

				cmd.CommandText = sql;
				cmd.Parameters.Clear();
				cmd.Parameters.Add ("@KJND", KJND);
				cmd.Parameters.Add ("@KMBM", KMBM);
				
				cmd.ExecuteNonQuery();
				return true;
			}
			catch(Exception e)
			{
				LogService.Write ("DelCW_KJKM(string KJND, string KMBM)");
				LogService.Write (e.Message);
				return false;
			}
		}
		
		/// <summary>
		///  根据主键标识获得CW_KJKM对象
		/// </summary>
		/// <param name="KJND">主键</param>
		/// <param name="KMBM">主键</param>
		
		public CW_KJKM GetCW_KJKM(string KJND, string KMBM)
		{
			try
			{
				CW_KJKM result = null;
				
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
				
				string sql;
				sql = "select * from CW_KJKM where KJND=@KJND and KMBM=@KMBM";
				
				SqlCommand cmd = new SqlCommand(sql,cn);
				cmd.Parameters.Add ("@KJND", KJND);
				cmd.Parameters.Add ("@KMBM", KMBM);
				
				SqlDataReader dr = cmd.ExecuteReader();
				
				if (dr.Read())
				{
					result = new CW_KJKM();
					if (dr["KJND"] != null)
						if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
							result.KJND = (string)dr["KJND"];
					if (dr["KMBM"] != null)
						if (!System.DBNull.Equals(dr["KMBM"], System.DBNull.Value))
							result.KMBM = (string)dr["KMBM"];
					if (dr["KMMC"] != null)
						if (!System.DBNull.Equals(dr["KMMC"], System.DBNull.Value))
							result.KMMC = (string)dr["KMMC"];
					if (dr["SJKMBM"] != null)
						if (!System.DBNull.Equals(dr["SJKMBM"], System.DBNull.Value))
							result.SJKMBM = (string)dr["SJKMBM"];
					if (dr["LB"] != null)
						if (!System.DBNull.Equals(dr["LB"], System.DBNull.Value))
							result.LB = (string)dr["LB"];
					if (dr["KMFX"] != null)
						if (!System.DBNull.Equals(dr["KMFX"], System.DBNull.Value))
							result.KMFX = (string)dr["KMFX"];
					if (dr["KMJB"] != null)
						if (!System.DBNull.Equals(dr["KMJB"], System.DBNull.Value))
							result.KMJB = (int)dr["KMJB"];
					if (dr["SFMX"] != null)
						if (!System.DBNull.Equals(dr["SFMX"], System.DBNull.Value))
							result.SFMX = (string)dr["SFMX"];
					if (dr["SFXJHS"] != null)
						if (!System.DBNull.Equals(dr["SFXJHS"], System.DBNull.Value))
							result.SFXJHS = (string)dr["SFXJHS"];
					if (dr["TYBJ"] != null)
						if (!System.DBNull.Equals(dr["TYBJ"], System.DBNull.Value))
							result.TYBJ = (string)dr["TYBJ"];
					if (dr["SFYJSY"] != null)
						if (!System.DBNull.Equals(dr["SFYJSY"], System.DBNull.Value))
							result.SFYJSY = (string)dr["SFYJSY"];
					if (dr["SFBMHS"] != null)
						if (!System.DBNull.Equals(dr["SFBMHS"], System.DBNull.Value))
							result.SFBMHS = (string)dr["SFBMHS"];
					if (dr["SFYGHS"] != null)
						if (!System.DBNull.Equals(dr["SFYGHS"], System.DBNull.Value))
							result.SFYGHS = (string)dr["SFYGHS"];
					if (dr["SFWLHHS"] != null)
						if (!System.DBNull.Equals(dr["SFWLHHS"], System.DBNull.Value))
							result.SFWLHHS = (string)dr["SFWLHHS"];
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("GetCW_KJKM(string KJND, string KMBM)");
				LogService.Write (e.Message);
				return null;
			}
		}
	
		/// <summary>
		///  查找CW_KJKM对象
		/// </summary>
	
		public ArrayList FindCW_KJKM()
		{
			try
			{
				ArrayList result = new ArrayList();
			
				SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
				cn.Open();
			
				string sql;
				sql = "select * from CW_KJKM";
			
				SqlCommand cmd = new SqlCommand(sql, cn);
			
				SqlDataReader dr = cmd.ExecuteReader();
			
				while (dr.Read())
				{
					CW_KJKM obj = new CW_KJKM();
					if (dr["KJND"] != null)
						if (!System.DBNull.Equals(dr["KJND"], System.DBNull.Value))
							obj.KJND = (string)dr["KJND"];
					if (dr["KMBM"] != null)
						if (!System.DBNull.Equals(dr["KMBM"], System.DBNull.Value))
							obj.KMBM = (string)dr["KMBM"];
					if (dr["KMMC"] != null)
						if (!System.DBNull.Equals(dr["KMMC"], System.DBNull.Value))
							obj.KMMC = (string)dr["KMMC"];
					if (dr["SJKMBM"] != null)
						if (!System.DBNull.Equals(dr["SJKMBM"], System.DBNull.Value))
							obj.SJKMBM = (string)dr["SJKMBM"];
					if (dr["LB"] != null)
						if (!System.DBNull.Equals(dr["LB"], System.DBNull.Value))
							obj.LB = (string)dr["LB"];
					if (dr["KMFX"] != null)
						if (!System.DBNull.Equals(dr["KMFX"], System.DBNull.Value))
							obj.KMFX = (string)dr["KMFX"];
					if (dr["KMJB"] != null)
						if (!System.DBNull.Equals(dr["KMJB"], System.DBNull.Value))
							obj.KMJB = (int)dr["KMJB"];
					if (dr["SFMX"] != null)
						if (!System.DBNull.Equals(dr["SFMX"], System.DBNull.Value))
							obj.SFMX = (string)dr["SFMX"];
					if (dr["SFXJHS"] != null)
						if (!System.DBNull.Equals(dr["SFXJHS"], System.DBNull.Value))
							obj.SFXJHS = (string)dr["SFXJHS"];
					if (dr["TYBJ"] != null)
						if (!System.DBNull.Equals(dr["TYBJ"], System.DBNull.Value))
							obj.TYBJ = (string)dr["TYBJ"];
					if (dr["SFYJSY"] != null)
						if (!System.DBNull.Equals(dr["SFYJSY"], System.DBNull.Value))
							obj.SFYJSY = (string)dr["SFYJSY"];
					if (dr["SFBMHS"] != null)
						if (!System.DBNull.Equals(dr["SFBMHS"], System.DBNull.Value))
							obj.SFBMHS = (string)dr["SFBMHS"];
					if (dr["SFYGHS"] != null)
						if (!System.DBNull.Equals(dr["SFYGHS"], System.DBNull.Value))
							obj.SFYGHS = (string)dr["SFYGHS"];
					if (dr["SFWLHHS"] != null)
						if (!System.DBNull.Equals(dr["SFWLHHS"], System.DBNull.Value))
							obj.SFWLHHS = (string)dr["SFWLHHS"];
					result.Add(obj);
				}
				dr.Close();
				cn.Close();
				return result;
			}
			catch(Exception e)
			{
				LogService.Write ("FindCW_KJKM()");
				LogService.Write (e.Message);
				return null;
			}
		}
	



		



		/// <summary>
		/// 判断是否允许删除或停用
		/// </summary>
		/// <param name="KJKM"></param>
		/// <param name="Flag">判断标志，为1时表示判断是否允许停用，为2时表示判断是否允许启用，为3时表示判断是否存在下级科目，为4时表示判断会计科目是否已经使用</param>
		/// <returns>布尔型返回值，通过判断返回true，未通过判断返回false</returns>
		public bool CheckChild(SqlCommand cmd, string KJND, string KMBM, int Flag)
		{
			//SqlConnection cn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
			//SqlCommand cmd = cn.CreateCommand();

			string sql;
			
			//定义查询语句
			if(Flag == 1)
			{
				sql = "Select Count(*) From CW_KJKM Where KJND=@KJND And SJKMBM=@SJKMBM And TYBJ = '0'";
			}
			else if(Flag == 2)
			{
				sql = "Select Count(*) From CW_KJKM C1, CW_KJKM C2 Where C1.KJND=C2.KJND And C1.KJND=@KJND And C1.SJKMBM = C2.KMBM And C1.KMBM=@SJKMBM And C2.TYBJ = '1'";
			}
			else if (Flag == 3)
			{
				sql = "Select Count(*) From CW_KJKM Where KJND=@KJND And SJKMBM=@SJKMBM";
			}
			else if(Flag == 4)
			{
				sql = "Select Count(*) From CW_KJKM Where KJND=@KJND And KMBM=@SJKMBM And SFYJSY='1'";
			}
			else
			{
				//cn.Close();
				return false;
			}

			cmd.CommandText = sql;
			cmd.Parameters.Clear();	
			cmd.Parameters.Add ("@KJND", KJND);
			cmd.Parameters.Add ("@SJKMBM", KMBM);
			//cn.Open();

			if(int.Parse(cmd.ExecuteScalar().ToString()) == 0)
			{
				//cn.Close();
				return true;
			}
			else
			{
				//cn.Close();
				return false;
			}
		}
	
	}
}