BLL/teachermanage.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using DAL;
namespace BLL
{
   public  class teachermanage
    {
       private DbOperator db;
       public teachermanage()
       {
           db = new DbOperator(DBcommon.dbType,DBcommon.connString);
       }
       public int insert(string loginame,string loginpwd,int teachertype,int DepartmentID)
       {
           string strsql = "insert into Logininfo(LoginName,LoginPwd,TeacherTypeID,DepartmentID)values('"+loginame+"','"+loginpwd+"',"+teachertype+","+DepartmentID+")";
           int result = db.ExecuteNonQuery(strsql);
           return result;
       }
       public DataTable selectAll()
       {
           string sql = "select a.ID ,a.LoginName,a.LoginPwd ,b.TeacherType,c.DepartmentName from LoginInfo as a inner join TeacherTypeInfo as b on a.TeacherTypeID=b.TeacherTypeID  inner join  DepartmentInfo  as c on a.DepartmentID=c.DepartmentID where 1=1";
           return db.ExecuteQuery(sql);
       }
       public int updateteacherinfo( string teachername, int Department, int teachertype,string teacherno)
       {
           string sql = "update LoginInfo  set LoginName='" + teachername + "',DepartmentID=" + Department + " ,TeacherTypeID=" + teachertype + " where  LoginPwd='" + teacherno + "'";
           int result = db.ExecuteNonQuery(sql);
           return result;

       }
       public int Deleteteacherinfo(int id)
       {
           string sql = "delete from LoginInfo where ID='"+id+"'";
           int result = db.ExecuteNonQuery(sql);
           return result;

       }
       public DataTable selectByCondition(string loginpwd, string loginname, int teacherType, int department) 
       {

           string sql = "select a.ID ,a.LoginName,a.LoginPwd ,b.TeacherType,c.DepartmentName from LoginInfo as a inner join TeacherTypeInfo as b on a.TeacherTypeID=b.TeacherTypeID  inner join  DepartmentInfo  as c on a.DepartmentID=c.DepartmentID where 1=1";

           if (loginpwd.Length > 0)
           {
               sql += "and a.LoginPwd like'%" + loginpwd + "%'";
           }
           else if (loginname.Length > 0)
           {
               sql += "and a.LoginName ='"+loginname+"'";
           }
          else  if (!department.Equals("请选择系别"))
           {
               sql += "and a.DepartmentID="+department+"";
           }
           else if (!teacherType.Equals("请选择角色"))
           {
               sql += "and a.TeacherType";
           }