public IEnumerable <WanChengQingkuangModel> GetWanChengQingKuang(string className)
{
DataTable dt = SqlHelper.ExecuteDataTable("SELECT id,`Name`,UserName,HaveBY,r.num FROM T_StudentInfo as s LEFT JOIN (SELECT StuId,count(StuId) as num from T_StuRelationship GROUP BY StuId) as r on s.id=r.StuId where UserName=@UserName",
new MySqlParameter("UserName", className));
List <WanChengQingkuangModel> list = new List <WanChengQingkuangModel>();
foreach (DataRow row in dt.Rows)
{
WanChengQingkuangModel model = new WanChengQingkuangModel();
model.id = new Guid(row["id"].ToString());
model.StuName = (string)row["Name"];
if (Convert.ToBoolean(row["HaveBY"]))
{
model.WanCheng = "已完成";
}
else
{
model.WanCheng = "未完成";
}
if (row["num"] == DBNull.Value)
{
model.JhNum = 0;
}
else
{
model.JhNum = Convert.ToInt32(row["num"]);
}
list.Add(model);
}
return(list);
}
public WanChengQingkuangModel GetNumberOfRelationship(string idcardno)
{
DataTable dt1 = SqlHelper.ExecuteDataTable("SELECT id FROM T_StudentInfo where IDCardNO=@IDCardNO",
new MySqlParameter("IDCardNO", idcardno));
WanChengQingkuangModel model = new WanChengQingkuangModel();
model.id = new Guid(dt1.Rows[0]["id"].ToString());
model.JhNum = Convert.ToInt32(SqlHelper.ExecuteScalar("SELECT count(*) from T_StuRelationship where StuId=@StuId",
new MySqlParameter("StuId", model.id)));
return(model);
}
