/// <summary>
/// 得到一个对象实体
/// </summary>
public Danyl.SnnuURP.Model.StuInfo DataRowToModel(DataRow row)
{
Danyl.SnnuURP.Model.StuInfo model=new Danyl.SnnuURP.Model.StuInfo();
if (row != null)
{
if(row["Sid"]!=null && row["Sid"].ToString()!="")
{
model.Sid=int.Parse(row["Sid"].ToString());
}
if(row["Sname"]!=null)
{
model.Sname=row["Sname"].ToString();
}
if(row["SnameSpell"]!=null)
{
model.SnameSpell=row["SnameSpell"].ToString();
}
if(row["SnameEnglish"]!=null)
{
model.SnameEnglish=row["SnameEnglish"].ToString();
}
if(row["SnameOld"]!=null)
{
model.SnameOld=row["SnameOld"].ToString();
}
if(row["IdNumber"]!=null)
{
model.IdNumber=row["IdNumber"].ToString();
}
if(row["Sex"]!=null && row["Sex"].ToString()!="")
{
if((row["Sex"].ToString()=="1")||(row["Sex"].ToString().ToLower()=="true"))
{
model.Sex=true;
}
else
{
model.Sex=false;
}
}
if(row["StuType"]!=null)
{
model.StuType=row["StuType"].ToString();
}
if(row["StuNationality"]!=null)
{
model.StuNationality=row["StuNationality"].ToString();
}
if(row["StuProvince"]!=null)
{
model.StuProvince=row["StuProvince"].ToString();
}
if(row["StuBirthday"]!=null && row["StuBirthday"].ToString()!="")
{
model.StuBirthday=DateTime.Parse(row["StuBirthday"].ToString());
}
if(row["StuPolitical"]!=null)
{
model.StuPolitical=row["StuPolitical"].ToString();
}
if(row["StuDept"]!=null && row["StuDept"].ToString()!="")
{
model.StuDept=int.Parse(row["StuDept"].ToString());
}
if(row["StuZipCode"]!=null)
{
model.StuZipCode=row["StuZipCode"].ToString();
}
if(row["StuEnrollDate"]!=null && row["StuEnrollDate"].ToString()!="")
{
model.StuEnrollDate=DateTime.Parse(row["StuEnrollDate"].ToString());
}
if(row["StuMajor"]!=null && row["StuMajor"].ToString()!="")
{
model.StuMajor=int.Parse(row["StuMajor"].ToString());
}
if(row["StuGrade"]!=null && row["StuGrade"].ToString()!="")
{
model.StuGrade=int.Parse(row["StuGrade"].ToString());
}
if(row["StuClassId"]!=null && row["StuClassId"].ToString()!="")
{
model.StuClassId=int.Parse(row["StuClassId"].ToString());
}
if(row["PlanId"]!=null && row["PlanId"].ToString()!="")
{
model.PlanId=int.Parse(row["PlanId"].ToString());
}
if(row["District"]!=null)
{
model.District=row["District"].ToString();
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Danyl.SnnuURP.Model.StuInfo GetModel(int Sid,int StuMajor,int StuClassId,int PlanId)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 Sid,Sname,SnameSpell,SnameEnglish,SnameOld,IdNumber,Sex,StuType,StuNationality,StuProvince,StuBirthday,StuPolitical,StuDept,StuZipCode,StuEnrollDate,StuMajor,StuGrade,StuClassId,PlanId,District from StuInfo ");
strSql.Append(" where Sid=@Sid and StuMajor=@StuMajor and StuClassId=@StuClassId and PlanId=@PlanId ");
SqlParameter[] parameters = {
new SqlParameter("@Sid", SqlDbType.Int,4),
new SqlParameter("@StuMajor", SqlDbType.Int,4),
new SqlParameter("@StuClassId", SqlDbType.Int,4),
new SqlParameter("@PlanId", SqlDbType.Int,4) };
parameters[0].Value = Sid;
parameters[1].Value = StuMajor;
parameters[2].Value = StuClassId;
parameters[3].Value = PlanId;
Danyl.SnnuURP.Model.StuInfo model=new Danyl.SnnuURP.Model.StuInfo();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}