//绑定所属实验室
protected void LabDropdownlist()
{
LabMS.BLL.Lab lab = new LabMS.BLL.Lab();
List<LabMS.Model.Lab> ParLab = new List<LabMS.Model.Lab>();
List<LabMS.Model.Lab> SonLab = new List<LabMS.Model.Lab>();
List<LabMS.Model.Lab> LabTemp = new List<LabMS.Model.Lab>();
ParLab = lab.GetModelList("Lab_ParentID is null");
SonLab = lab.GetModelList("Lab_ParentID is not null");
LabTemp = lab.GetModelList("Lab_ParentID is null");
int count = ParLab.Count, count1 = SonLab.Count;
for (int i = 0; i < count; i++)
{
int ID = ParLab[i].ID;
int m = 0;
for (int j = 0; j < count1; j++)
{
LabMS.Model.Lab labModel = new LabMS.Model.Lab();
int ParentID = int.Parse(SonLab[j].Lab_ParentID.ToString());
if (ParentID == ID)
{
labModel.ID = SonLab[j].ID;
labModel.Lab_Name = "|-" + SonLab[j].Lab_Name;
LabTemp.Insert(i + m + 1, labModel);
m++;
}
}
}
RespLabDDL.DataSource = LabTemp;
RespLabDDL.DataBind();
ListItem item = new ListItem("无", "0");
RespLabDDL.Items.Insert(0, item);
}
/// <summary>
/// ��������б�
/// </summary>
public List<LabMS.Model.Lab> GetModelList(string strWhere)
{
DataSet ds = dal.GetList(strWhere);
List<LabMS.Model.Lab> modelList = new List<LabMS.Model.Lab>();
int rowsCount = ds.Tables[0].Rows.Count;
if (rowsCount > 0)
{
LabMS.Model.Lab model;
for (int n = 0; n < rowsCount; n++)
{
model = new LabMS.Model.Lab();
if(ds.Tables[0].Rows[n]["ID"].ToString()!="")
{
model.ID=int.Parse(ds.Tables[0].Rows[n]["ID"].ToString());
}
model.Lab_Code=ds.Tables[0].Rows[n]["Lab_Code"].ToString();
model.Lab_Name=ds.Tables[0].Rows[n]["Lab_Name"].ToString();
model.Lab_Category=ds.Tables[0].Rows[n]["Lab_Category"].ToString();
model.Lab_Level=ds.Tables[0].Rows[n]["Lab_Level"].ToString();
if(ds.Tables[0].Rows[n]["Lab_SetupTime"].ToString()!="")
{
model.Lab_SetupTime=DateTime.Parse(ds.Tables[0].Rows[n]["Lab_SetupTime"].ToString());
}
model.Lab_InCharge=ds.Tables[0].Rows[n]["Lab_InCharge"].ToString();
if(ds.Tables[0].Rows[n]["Lab_ProjectNum"].ToString()!="")
{
model.Lab_ProjectNum=int.Parse(ds.Tables[0].Rows[n]["Lab_ProjectNum"].ToString());
}
model.Lab_Phone=ds.Tables[0].Rows[n]["Lab_Phone"].ToString();
model.Lab_State=ds.Tables[0].Rows[n]["Lab_State"].ToString();
model.Lab_Curriculum=ds.Tables[0].Rows[n]["Lab_Curriculum"].ToString();
if(ds.Tables[0].Rows[n]["Lab_Summary"].ToString()!="")
{
model.Lab_Summary=int.Parse(ds.Tables[0].Rows[n]["Lab_Summary"].ToString());
}
model.Lab_Investment=ds.Tables[0].Rows[n]["Lab_Investment"].ToString();
model.Lab_Type=ds.Tables[0].Rows[n]["Lab_Type"].ToString();
model.Lab_Disciplines=ds.Tables[0].Rows[n]["Lab_Disciplines"].ToString();
model.Lab_AwardLevel=ds.Tables[0].Rows[n]["Lab_AwardLevel"].ToString();
if(ds.Tables[0].Rows[n]["Lab_StAwardNum"].ToString()!="")
{
model.Lab_StAwardNum=int.Parse(ds.Tables[0].Rows[n]["Lab_StAwardNum"].ToString());
}
model.Lab_EnglishName=ds.Tables[0].Rows[n]["Lab_EnglishName"].ToString();
if(ds.Tables[0].Rows[n]["Lab_ParentID"].ToString()!="")
{
model.Lab_ParentID=int.Parse(ds.Tables[0].Rows[n]["Lab_ParentID"].ToString());
}
model.Lab_ApprovalCode=ds.Tables[0].Rows[n]["Lab_ApprovalCode"].ToString();
model.Lab_Professional=ds.Tables[0].Rows[n]["Lab_Professional"].ToString();
model.Lab_Statement=ds.Tables[0].Rows[n]["Lab_Statement"].ToString();
modelList.Add(model);
}
}
return modelList;
}
