departmentmanage_aspx_cs_checkdepartment.cs

用vs2005写的一个生产任务管理系统。数据的统计和综合查询是主要功能

using System; 
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using RWSB.DatabaseOper ;
using System.Data.SqlClient;


namespace RWSB.Manage
 {


	public class checkDepartment:System.Web .UI.Page 
	{
		public checkDepartment()
		{
		}
		/// <summary>
		/// 检查当前部门在数据库中是否存在
		/// </summary>
		/// <param name="departmentName">用户名</param>
		/// <returns></returns>
		public bool ExistDepartment(string departmentName)
		{
			RWSB.DatabaseOper.DatabaseConnect  dc=new DatabaseConnect();
			string sql="select count(*)  from ExigenceDegree where bmname='"+departmentName+"'" ;
			int count=0;
			try
			{
				count =int.Parse (dc.GetValueBySql(sql));
			}
			catch(Exception er)
			{
				Response.Write (er.Message );
				Response.End ();
			}
			if (count>0)
			{
				return true;
			}
			return false;
		}
		/// <summary>
		/// 检查当前部门在数据库中是否存在，此方法用在部门修改
		/// </summary>
		/// <param name="departmentName">用户名</param>
		/// <param name="userid">原用户ID</param>
		/// <returns></returns>
		public bool ExistDepartment(string departmentName,int  departmentid)
		{
			RWSB.DatabaseOper.DatabaseConnect  dc=new DatabaseConnect();
			string sql="select count(*)  from ExigenceDegree where bmname='"+departmentName+"' and id !="+departmentid.ToString () ;
			int count=0;
			try
			{
				count =int.Parse (dc.GetValueBySql(sql));
			}
			catch(Exception er)
			{
				Response.Write (er.Message );
				Response.End ();
			}
			if (count>0)
			{
				return true;
			}
			return false;
		}
	}

}