Web/Model/TeacherExtend.cs

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

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

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;
using System.Web.UI.WebControls;//Please add references

namespace StudentExamination.Model
{
    //扩展Department类，增加自定义的方法

    public partial class Teacher
    {      
        /// <summary>
        ///用户登录
        /// </summary>       
        public void Login(string loginName, string loginPassword)
        {
            //
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select TeacherID,TeacherCode,TeacherName,DepartmentID,IsUsed,Password,CreateDate ");
            strSql.Append(" FROM [Teacher] ");
            strSql.Append("  where IsUsed = 1 and TeacherCode=@loginName ");
            SqlParameter[] parameters = {
					new SqlParameter("@loginName", SqlDbType.NChar,30)			};
            parameters[0].Value = loginName;
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["TeacherID"] != null && ds.Tables[0].Rows[0]["TeacherID"].ToString() != "")
                {
                    this.TeacherID = int.Parse(ds.Tables[0].Rows[0]["TeacherID"].ToString());
                }
                if (ds.Tables[0].Rows[0]["TeacherCode"] != null && ds.Tables[0].Rows[0]["TeacherCode"].ToString() != "")
                {
                    this.TeacherCode = ds.Tables[0].Rows[0]["TeacherCode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["TeacherName"] != null && ds.Tables[0].Rows[0]["TeacherName"].ToString() != "")
                {
                    this.TeacherName = ds.Tables[0].Rows[0]["TeacherName"].ToString();
                }
                if (ds.Tables[0].Rows[0]["DepartmentID"] != null && ds.Tables[0].Rows[0]["DepartmentID"].ToString() != "")
                {
                    this.DepartmentID = int.Parse(ds.Tables[0].Rows[0]["DepartmentID"].ToString());
                }
                if (ds.Tables[0].Rows[0]["IsUsed"] != null && ds.Tables[0].Rows[0]["IsUsed"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["IsUsed"].ToString() == "1") || (ds.Tables[0].Rows[0]["IsUsed"].ToString().ToLower() == "true"))
                    {
                        this.IsUsed = true;
                    }
                    else
                    {
                        this.IsUsed = false;
                    }
                }
                if (ds.Tables[0].Rows[0]["Password"] != null && ds.Tables[0].Rows[0]["Password"].ToString() != "")
                {
                    this.Password = ds.Tables[0].Rows[0]["Password"].ToString();
                }