protected void Page_Load(object sender, EventArgs e)
{
sea1 = Session["user"] as ITCastOCSS.Model.Teacher;
if (sea1 == null)
{
Response.Write("<script>alert('请先登录');location.href='../Index.aspx'</script>");
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
//学生为1 老师为2
string type = ddlType.SelectedValue;
string no = txtNo.Text.Trim();
string pwd = txtPwd.Text.Trim();
//md5加密
pwd = Common.Getmd5(pwd);
string code = txtCode.Text.Trim();
if (Session["code"] != null && code.ToLower() == Session["code"].ToString().ToLower())
{
Session.Remove("code");
string msg;
if (type == "1")//学生
{
ITCastOCSS.BLL.Student stu = new ITCastOCSS.BLL.Student();
ITCastOCSS.Model.Student stu1 = new ITCastOCSS.Model.Student();
if (stu.login(no, pwd, out msg, out stu1))
{
Session["user"] = stu1;
Response.Redirect("student/Index.aspx");
}
lblMsg.Text = msg;
}
else if (type == "2")//老师
{
ITCastOCSS.BLL.Teacher tea = new ITCastOCSS.BLL.Teacher();
ITCastOCSS.Model.Teacher tea1 = new ITCastOCSS.Model.Teacher();
if (tea.login(no, pwd, out msg, out tea1))
{
Session["user"] = tea1;
if (tea1.TIsAdmin == 0)
{
Response.Redirect("teacher/Index.aspx");
}
else if (tea1.TIsAdmin == 1)
{
Response.Redirect("Admin/Index.aspx");
}
}
lblMsg.Text = msg;
}
//Response.Redirect("student/Index.aspx");
}
else
{
lblMsg.Text = "验证码错误！！！";
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ITCastOCSS.Model.Teacher model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Teacher set ");
strSql.Append("TNo=@TNo,");
strSql.Append("TName=@TName,");
strSql.Append("TSex=@TSex,");
strSql.Append("TMajor=@TMajor,");
strSql.Append("TPwd=@TPwd,");
strSql.Append("TDepartment=@TDepartment,");
strSql.Append("TTitle=@TTitle,");
strSql.Append("TIsAdmin=@TIsAdmin");
strSql.Append(" where TID=@TID");
SqlParameter[] parameters =
{
new SqlParameter("@TNo", SqlDbType.Char, 4),
new SqlParameter("@TName", SqlDbType.NVarChar, 8),
new SqlParameter("@TSex", SqlDbType.NChar, 1),
new SqlParameter("@TMajor", SqlDbType.NVarChar, 20),
new SqlParameter("@TPwd", SqlDbType.NVarChar, 20),
new SqlParameter("@TDepartment", SqlDbType.NVarChar, 20),
new SqlParameter("@TTitle", SqlDbType.NVarChar, 10),
new SqlParameter("@TIsAdmin", SqlDbType.Int, 4),
new SqlParameter("@TID", SqlDbType.Int, 4)
};
parameters[0].Value = model.TNo;
parameters[1].Value = model.TName;
parameters[2].Value = model.TSex;
parameters[3].Value = model.TMajor;
parameters[4].Value = model.TPwd;
parameters[5].Value = model.TDepartment;
parameters[6].Value = model.TTitle;
parameters[7].Value = model.TIsAdmin;
parameters[8].Value = model.TID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ITCastOCSS.Model.Teacher DataRowToModel(DataRow row)
{
ITCastOCSS.Model.Teacher model = new ITCastOCSS.Model.Teacher();
if (row != null)
{
if (row["TID"] != null && row["TID"].ToString() != "")
{
model.TID = int.Parse(row["TID"].ToString());
}
if (row["TNo"] != null)
{
model.TNo = row["TNo"].ToString();
}
if (row["TName"] != null)
{
model.TName = row["TName"].ToString();
}
if (row["TSex"] != null)
{
model.TSex = row["TSex"].ToString();
}
if (row["TMajor"] != null)
{
model.TMajor = row["TMajor"].ToString();
}
if (row["TPwd"] != null)
{
model.TPwd = row["TPwd"].ToString();
}
if (row["TDepartment"] != null)
{
model.TDepartment = row["TDepartment"].ToString();
}
if (row["TTitle"] != null)
{
model.TTitle = row["TTitle"].ToString();
}
if (row["TIsAdmin"] != null && row["TIsAdmin"].ToString() != "")
{
model.TIsAdmin = int.Parse(row["TIsAdmin"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ITCastOCSS.Model.Teacher model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Teacher(");
strSql.Append("TNo,TName,TSex,TMajor,TPwd,TDepartment,TTitle,TIsAdmin)");
strSql.Append(" values (");
strSql.Append("@TNo,@TName,@TSex,@TMajor,@TPwd,@TDepartment,@TTitle,@TIsAdmin)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@TNo", SqlDbType.Char, 4),
new SqlParameter("@TName", SqlDbType.NVarChar, 8),
new SqlParameter("@TSex", SqlDbType.NChar, 1),
new SqlParameter("@TMajor", SqlDbType.NVarChar, 20),
new SqlParameter("@TPwd", SqlDbType.NVarChar, 20),
new SqlParameter("@TDepartment", SqlDbType.NVarChar, 20),
new SqlParameter("@TTitle", SqlDbType.NVarChar, 10),
new SqlParameter("@TIsAdmin", SqlDbType.Int, 4)
};
parameters[0].Value = model.TNo;
parameters[1].Value = model.TName;
parameters[2].Value = model.TSex;
parameters[3].Value = model.TMajor;
parameters[4].Value = model.TPwd;
parameters[5].Value = model.TDepartment;
parameters[6].Value = model.TTitle;
parameters[7].Value = model.TIsAdmin;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "Teacher";
* parameters[1].Value = "TID";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 得到一个对象实体
/// </summary>
public ITCastOCSS.Model.Teacher GetModel(string no)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 TID,TNo,TName,TSex,TMajor,TPwd,TDepartment,TTitle,TIsAdmin from Teacher ");
strSql.Append(" where TNo=@TNo");
SqlParameter[] parameters =
{
new SqlParameter("@TNo", SqlDbType.Char)
};
parameters[0].Value = no;
ITCastOCSS.Model.Teacher model = new ITCastOCSS.Model.Teacher();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
