code

using System;
using System.Data;
using System.Data.SqlClient;
namespace BrightClassLibrary
{
 public class DBInfo
 {
  public static string cnn()
  {
   return "data source=(local);initial catalog=bright;user id=sa;password=sa;";
  }

 }
 

 /// <summary>
 /// BrightClassEmployee 的摘要说明。
 /// </summary>
 public class BrightClassEmployee
 {
  public BrightClassEmployee()
  {
   //
   // TODO: 在此处添加构造函数逻辑
   //
  }
 }
 #region Employee 员工类
 public class Employee
 {
  private string m_ename;
  private string m_euser;
  private string m_eworkid;
  private string m_epassword;
  private int m_eposition;
  private int m_edepartment;
  private bool m_egender;
  private string m_etel;
  private DateTime m_elasttime;

  public  Employee()
  {
   
  }
  
  public string ename
  {
   get
   {
    return m_ename;
   }
   set
   {
    m_ename=value;
   }
  }
  public string euser
  {
   get
   {
    return m_euser;
   }
   set
   {
    m_euser=value;
   }
  }
  public string eworkid
  {
   get
   {
    return m_eworkid;
   }
   set
   {
    m_eworkid=value;
   }
  }
  public int eposition
  {
   get
   {
    return m_eposition;
   }
   set
   {
    m_eposition=value;
   }
  }
  public int edepartment
  {
   get
   {
    return m_edepartment;
   }
   set
   {
    m_edepartment=value;
   }
  }

  public bool egender
  {
   get
   {
    return m_egender;
   }
   set
   {
    m_egender=value;
   }
  }

  public string etel
  {
   get
   {
    return m_etel;
   }
   set
   {
    m_etel=value;
   }
  }

  public DateTime elasttime
  {
   get
   {
    return m_elasttime;
   }
   set
   {
    m_elasttime=value;
   }
  }

 

  public static bool matchingPW(string user,string pw)
  {
   SqlConnection myConnection = new SqlConnection();
   myConnection.ConnectionString = DBInfo.cnn();
   string mySelectQuery = "SELECT epassword FROM employee WHERE (euser = N'"+user+"')";
   SqlCommand myCommand = new SqlCommand(mySelectQuery);
   myCommand.Connection = myConnection;
   myConnection.Open();
   SqlDataReader myReader = myCommand.ExecuteReader();
   try
   {
    while (myReader.Read())
    {
     if(pw.ToLower() == myReader.GetString(0).ToLower())
     {
      return true;
     }
     else
     {
      return false;
     }
    }
   }
   finally
   {
    // always call Close when done reading.
    myReader.Close();
    // always call Close when done reading.
    myConnection.Close();
   }
   return false;
   
  }
  /// <summary>
  /// 查看是否workid或username已经存在
  /// </summary>
  /// <param name="eworkid">eworkid</param>
  /// <param name="euser">euser</param>
  /// <returns>true表示存在</returns>
  public static bool recordIsExist(string eworkid,string euser)
  {
   SqlConnection myConnection = new SqlConnection();
   myConnection.ConnectionString = DBInfo.cnn();
   string mySelectQuery = "SELECT * FROM employee WHERE (euser = N'"+euser+"') OR (eworkid =N'"+eworkid+"')";
   SqlCommand myCommand = new SqlCommand(mySelectQuery);
   myCommand.Connection = myConnection;
   myConnection.Open();
   int result = myCommand.ExecuteNonQuery();
   if(result>0)
   {
    return true;
   }
   else
   {
    return false;
   }
  }
  public bool creatOneRecord()
  {
   SqlConnection myConnection = new SqlConnection();
   myConnection.ConnectionString = DBInfo.cnn();
   if(m_euser!=null &&m_eworkid!=null &&m_ename!=null )
   {
    string myInsertQuery = "INSERT INTO employee  (euser, eworkid, ename, eposition, edepartment, egender, etel) VALUES ('"+m_euser+"', '"+m_eworkid+"', '"+m_ename+"', '"+m_eposition+"', '"+m_edepartment+"', '"+m_egender+"',' "+m_etel+"')";
    SqlCommand myCommand = new SqlCommand(myInsertQuery);
    myCommand.Connection = myConnection;
    myConnection.Open();
    int result = myCommand.ExecuteNonQuery();
    myConnection.Close();
    if(result>0)
    {
     return true;
    }
    else
    {
     return false;
    }
   }
   else
   {
    return false;
   }
  }
 }

 #endregion
 #region department 部门类
 /// <summary>
 /// department 部门类
 /// </summary>
 public class department
 {
  public department()
  {
  }
  private int m_did;
  private string m_dname;
  /// <summary>
  /// 编号（流水号）
  /// </summary>
  public int did
  {
   get
   {
    return m_did;
   }
   set
   {
    m_did=value;
   }
  }
  /// <summary>
  /// 部门名称
  /// </summary>
  public string dname
  {
   get
   {
    return m_dname;
   }
   set
   {
    m_dname=value;
   }
  }
  
  
  public static string getDepartmentName(int did)
  {
   SqlConnection myConnection = new SqlConnection();
   myConnection.ConnectionString = DBInfo.cnn();
   string mySelectQuery = "SELECT dname FROM department WHERE (did = "+did+")";
   SqlCommand myCommand = new SqlCommand(mySelectQuery);
   myCommand.Connection = myConnection;
   myConnection.Open();
   SqlDataReader myReader = myCommand.ExecuteReader();
   try
   {
    while (myReader.Read())
    {
     //Console.WriteLine(myReader.GetString(0));
     return myReader.GetString(0);
    }
   }
   finally
   {
    // always call Close when done reading.
    myReader.Close();
    // always call Close when done reading.
    myConnection.Close();
   }
   return "";
  }
  public static bool createOneDepartment(string dname)
  {
   SqlConnection myConnection = new SqlConnection();
   myConnection.ConnectionString = DBInfo.cnn();
   if(dname!="")
   {
    string mySelectQuery = "INSERT INTO department  (dname) VALUES (N'"+dname+"')";
    SqlCommand myCommand = new SqlCommand(mySelectQuery);
    myCommand.Connection = myConnection;
    myConnection.Open();
    int result = myCommand.ExecuteNonQuery();
    myConnection.Close();
    if(result>0)
    {
     return true;
    }
    else
    {
     return false;
    }
   }
   else
   {
    return false;
   }
  }
  
  public static bool DepartmentIsExist(string dname)
  {
   SqlConnection myConnection = new SqlConnection();
   myConnection.ConnectionString = DBInfo.cnn();
   if(dname!="")
   {
    string mySelectQuery = "SELECT dname FROM department WHERE (dname = N'"+dname+"')";
    SqlCommand myCommand = new SqlCommand(mySelectQuery);
    myCommand.Connection = myConnection;
    myConnection.Open();
    int result = myCommand.ExecuteNonQuery();
    myConnection.Close();
    if(result>0)
    {
     return true;
    }
    else
    {
     return false;
    }
   }
   else
   {
    return false;
   }
  }
 }
#endregion

 #region position 职位类
 public class position
 {
  public position()
  {
  }
  public static bool creatOneRecord(string pname)
  {
   SqlConnection myConnection = new SqlConnection();
   myConnection.ConnectionString = DBInfo.cnn();
   if(pname!="")
   {
    string mySelectQuery = "INSERT INTO position  (pname) VALUES (N'"+pname+"')";
    SqlCommand myCommand = new SqlCommand(mySelectQuery);
    myCommand.Connection = myConnection;
    myConnection.Open();
    int result = myCommand.ExecuteNonQuery();
    myConnection.Close();
    if(result>0)
    {
     return true;
    }
    else
    {
     return false;
    }
   }
   else
   {
    return true;
   }
  }
  public bool positionIsExist(string pname)
  {
   SqlConnection myConnection = new SqlConnection();
   myConnection.ConnectionString = DBInfo.cnn();
   if(pname!="")
   {
    string mySelectQuery = "SELECT pname FROM position WHERE (pname = N'"+pname+"')";
    SqlCommand myCommand = new SqlCommand(mySelectQuery);
    myCommand.Connection = myConnection;
    myConnection.Open();
    int result = myCommand.ExecuteNonQuery();
    myConnection.Close();
    if(result>0)
    {
     return true;
    }
    else
    {
     return false;
    }
   }
   else
   {
    return true;
   }
  }

 }
 #endregion
}