/// <summary>
/// 获取学生信息
/// </summary>
public void getStudents()
{
if (Xuehao != null)
{
model = bll.getModel(Xuehao);
this.tbx_xuehao.Text = model.Xuehao;
this.tbx_name.Text = model.Name;
this.tbx_age.Text = model.Age;
this.tbx_zhuanye.Text = model.Zhuanye;
this.tbx_xueli.Text = model.Xueli;
this.tbx_hobby.Text = model.Hobby;
}
}
/// <summary>
/// 获取学生个人信息
/// </summary>
/// <param name="row"></param>
/// <returns></returns>
public Model.v_students DataRowToModel(DataRow row)
{
Model.v_students model = new Model.v_students();
if (row != null)
{
if (row["Xuehao"] != null)
{
model.Xuehao = row["Xuehao"].ToString();
}
if (row["Name"] != null)
{
model.Name = row["Name"].ToString();
}
if (row["Age"] != null)
{
model.Age = row["Age"].ToString();
}
if (row["Hobby"] != null)
{
model.Hobby = row["Hobby"].ToString();
}
if (row["Zhuanye"] != null)
{
model.Zhuanye = row["Zhuanye"].ToString();
}
if (row["Xueli"] != null)
{
model.Xueli = row["Xueli"].ToString();
}
//if (row["roleName"] != null)
//{
// model.Xueli = row["roleName"].ToString();
//}
}
return(model);
}
/// <summary>
/// 根据学号获取学生个人信息
/// </summary>
/// <param name="xuehao"></param>
/// <returns></returns>
public Model.v_students getModel(string xuehao)
{
StringBuilder sqlstr = new StringBuilder();
sqlstr.Append("select xuehao, name, age, hobby, zhuanye, xueli");
sqlstr.Append(" from v_students");
sqlstr.Append(" where xuehao = @xuehao");
SqlParameter[] parameters =
{
new SqlParameter("@xuehao", SqlDbType.VarChar, 50)
};
parameters[0].Value = xuehao;
Model.v_students model = new Model.v_students();
DataSet ds = DbHelperSQL.Query(sqlstr.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(model = null);
}
}
/// <summary>
/// 根据学号获取学生个人信息
/// </summary>
/// <param name="xuehao"></param>
/// <returns></returns>
public Model.v_students getModel(string xuehao)
{
model = dal.getModel(xuehao);
return(model);
}
