protected void Page_Load(object sender, EventArgs e)
{
ITCastOCSS.Model.Student stu = Session["user"] as ITCastOCSS.Model.Student;
if (stu == 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 int Add(ITCastOCSS.Model.Student model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Student(");
strSql.Append("SNo,SName,SPwd,SSex,SClass,SType,SDepartment,SMajor,SMaxNum,SActualNum,SBirthday,SInTime,SGrade,SNote)");
strSql.Append(" values (");
strSql.Append("@SNo,@SName,@SPwd,@SSex,@SClass,@SType,@SDepartment,@SMajor,@SMaxNum,@SActualNum,@SBirthday,@SInTime,@SGrade,@SNote)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@SNo", SqlDbType.Char, 9),
new SqlParameter("@SName", SqlDbType.NVarChar, 8),
new SqlParameter("@SPwd", SqlDbType.VarChar, 20),
new SqlParameter("@SSex", SqlDbType.NChar, 1),
new SqlParameter("@SClass", SqlDbType.VarChar, 10),
new SqlParameter("@SType", SqlDbType.VarChar, 10),
new SqlParameter("@SDepartment", SqlDbType.NVarChar, 20),
new SqlParameter("@SMajor", SqlDbType.NVarChar, 20),
new SqlParameter("@SMaxNum", SqlDbType.Int, 4),
new SqlParameter("@SActualNum", SqlDbType.Int, 4),
new SqlParameter("@SBirthday", SqlDbType.DateTime),
new SqlParameter("@SInTime", SqlDbType.DateTime),
new SqlParameter("@SGrade", SqlDbType.NVarChar, 10),
new SqlParameter("@SNote", SqlDbType.NVarChar, 100)
};
parameters[0].Value = model.SNo;
parameters[1].Value = model.SName;
parameters[2].Value = model.SPwd;
parameters[3].Value = model.SSex;
parameters[4].Value = model.SClass;
parameters[5].Value = model.SType;
parameters[6].Value = model.SDepartment;
parameters[7].Value = model.SMajor;
parameters[8].Value = model.SMaxNum;
parameters[9].Value = model.SActualNum;
parameters[10].Value = model.SBirthday;
parameters[11].Value = model.SInTime;
parameters[12].Value = model.SGrade;
parameters[13].Value = model.SNote;
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 = "Student";
* parameters[1].Value = "SID";
* 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.Student GetModel(string no)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 SID,SNo,SName,SPwd,SSex,SClass,SType,SDepartment,SMajor,SMaxNum,SActualNum,SBirthday,SInTime,SGrade,SNote from Student ");
strSql.Append(" where SNo=@SNo");
SqlParameter[] parameters =
{
new SqlParameter("@SNo", SqlDbType.Char)
};
parameters[0].Value = no;
ITCastOCSS.Model.Student model = new ITCastOCSS.Model.Student();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ITCastOCSS.Model.Student DataRowToModel(DataRow row)
{
ITCastOCSS.Model.Student model = new ITCastOCSS.Model.Student();
if (row != null)
{
if (row["SID"] != null && row["SID"].ToString() != "")
{
model.SID = int.Parse(row["SID"].ToString());
}
if (row["SNo"] != null)
{
model.SNo = row["SNo"].ToString();
}
if (row["SName"] != null)
{
model.SName = row["SName"].ToString();
}
if (row["SPwd"] != null)
{
model.SPwd = row["SPwd"].ToString();
}
if (row["SSex"] != null)
{
model.SSex = row["SSex"].ToString();
}
if (row["SClass"] != null)
{
model.SClass = row["SClass"].ToString();
}
if (row["SType"] != null)
{
model.SType = row["SType"].ToString();
}
if (row["SDepartment"] != null)
{
model.SDepartment = row["SDepartment"].ToString();
}
if (row["SMajor"] != null)
{
model.SMajor = row["SMajor"].ToString();
}
if (row["SMaxNum"] != null && row["SMaxNum"].ToString() != "")
{
model.SMaxNum = int.Parse(row["SMaxNum"].ToString());
}
if (row["SActualNum"] != null && row["SActualNum"].ToString() != "")
{
model.SActualNum = int.Parse(row["SActualNum"].ToString());
}
if (row["SBirthday"] != null && row["SBirthday"].ToString() != "")
{
model.SBirthday = DateTime.Parse(row["SBirthday"].ToString());
}
if (row["SInTime"] != null && row["SInTime"].ToString() != "")
{
model.SInTime = DateTime.Parse(row["SInTime"].ToString());
}
if (row["SGrade"] != null)
{
model.SGrade = row["SGrade"].ToString();
}
if (row["SNote"] != null)
{
model.SNote = row["SNote"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ITCastOCSS.Model.Student model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Student set ");
strSql.Append("SNo=@SNo,");
strSql.Append("SName=@SName,");
strSql.Append("SPwd=@SPwd,");
strSql.Append("SSex=@SSex,");
strSql.Append("SClass=@SClass,");
strSql.Append("SType=@SType,");
strSql.Append("SDepartment=@SDepartment,");
strSql.Append("SMajor=@SMajor,");
strSql.Append("SMaxNum=@SMaxNum,");
strSql.Append("SActualNum=@SActualNum,");
strSql.Append("SBirthday=@SBirthday,");
strSql.Append("SInTime=@SInTime,");
strSql.Append("SGrade=@SGrade,");
strSql.Append("SNote=@SNote");
strSql.Append(" where SID=@SID");
SqlParameter[] parameters =
{
new SqlParameter("@SNo", SqlDbType.Char, 9),
new SqlParameter("@SName", SqlDbType.NVarChar, 8),
new SqlParameter("@SPwd", SqlDbType.VarChar, 20),
new SqlParameter("@SSex", SqlDbType.NChar, 1),
new SqlParameter("@SClass", SqlDbType.VarChar, 10),
new SqlParameter("@SType", SqlDbType.VarChar, 10),
new SqlParameter("@SDepartment", SqlDbType.NVarChar, 20),
new SqlParameter("@SMajor", SqlDbType.NVarChar, 20),
new SqlParameter("@SMaxNum", SqlDbType.Int, 4),
new SqlParameter("@SActualNum", SqlDbType.Int, 4),
new SqlParameter("@SBirthday", SqlDbType.DateTime),
new SqlParameter("@SInTime", SqlDbType.DateTime),
new SqlParameter("@SGrade", SqlDbType.NVarChar, 10),
new SqlParameter("@SNote", SqlDbType.NVarChar, 100),
new SqlParameter("@SID", SqlDbType.Int, 4)
};
parameters[0].Value = model.SNo;
parameters[1].Value = model.SName;
parameters[2].Value = model.SPwd;
parameters[3].Value = model.SSex;
parameters[4].Value = model.SClass;
parameters[5].Value = model.SType;
parameters[6].Value = model.SDepartment;
parameters[7].Value = model.SMajor;
parameters[8].Value = model.SMaxNum;
parameters[9].Value = model.SActualNum;
parameters[10].Value = model.SBirthday;
parameters[11].Value = model.SInTime;
parameters[12].Value = model.SGrade;
parameters[13].Value = model.SNote;
parameters[14].Value = model.SID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
