public List<LabMS.Model.Project> GetModelList2(string strWhere)
{
StringBuilder strSql = new StringBuilder();
string sqlStr1 = "select Project.* ,Course.ID from Project, CourseAndProject as PC,Course " +
"where PC.ProjectID=Project.ID and PC.CourseID=Course.ID ";
strSql.Append(sqlStr1);
if (!string.IsNullOrEmpty(strWhere))
{
strSql.Append(" and ");
strSql.Append(strWhere);
}
List<LabMS.Model.Project> ls = new List<LabMS.Model.Project>();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count != 0)
{
LabMS.Model.Project model;
for (int n = 0; n < ds.Tables[0].Rows.Count; n++)
{
model = new LabMS.Model.Project();
if (ds.Tables[0].Rows[n]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[n]["ID"].ToString());
}
model.Project_Code = ds.Tables[0].Rows[n]["Project_Code"].ToString();
model.Project_Category = ds.Tables[0].Rows[n]["Project_Category"].ToString();
model.Project_Name = ds.Tables[0].Rows[n]["Project_Name"].ToString();
if (ds.Tables[0].Rows[n]["Project_Lab"].ToString() != "")
{
model.Project_Lab = int.Parse(ds.Tables[0].Rows[n]["Project_Lab"].ToString());
}
if (ds.Tables[0].Rows[n]["Project_StartTime"].ToString() != "")
{
model.Project_StartTime = DateTime.Parse(ds.Tables[0].Rows[n]["Project_StartTime"].ToString());
}
if (ds.Tables[0].Rows[n]["Project_EndTime"].ToString() != "")
{
model.Project_EndTime = DateTime.Parse(ds.Tables[0].Rows[n]["Project_EndTime"].ToString());
}
if (ds.Tables[0].Rows[n]["Project_ClassHourse"].ToString() != "")
{
model.Project_ClassHourse = int.Parse(ds.Tables[0].Rows[n]["Project_ClassHourse"].ToString());
}
if (ds.Tables[0].Rows[n]["Project_ExpHouse"].ToString() != "")
{
model.Project_ExpHouse = int.Parse(ds.Tables[0].Rows[n]["Project_ExpHouse"].ToString());
}
model.Project_AwardLevel = ds.Tables[0].Rows[n]["Project_AwardLevel"].ToString();
model.Project_PartnerType = ds.Tables[0].Rows[n]["Project_PartnerType"].ToString();
model.Project_Type = ds.Tables[0].Rows[n]["Project_Type"].ToString();
if (ds.Tables[0].Rows[n]["Project_Consume"].ToString() != "")
{
model.Project_Consume = int.Parse(ds.Tables[0].Rows[n]["Project_Consume"].ToString());
}
model.Project_Change = ds.Tables[0].Rows[n]["Project_Change"].ToString();
if (ds.Tables[0].Rows[n]["Project_PartnerNum"].ToString() != "")
{
model.Project_PartnerNum = int.Parse(ds.Tables[0].Rows[n]["Project_PartnerNum"].ToString());
}
if (ds.Tables[0].Rows[n]["Project_Professional"].ToString() != "")
{
model.Project_Professional = int.Parse(ds.Tables[0].Rows[n]["Project_Professional"].ToString());
}
model.Project_Content = ds.Tables[0].Rows[n]["Project_Content"].ToString();
model.Project_CourseMode = ds.Tables[0].Rows[n]["Project_CourseMode"].ToString();
if (ds.Tables[0].Rows[n]["Project_SubmitTime"].ToString() != "")
{
model.Project_SubmitTime = DateTime.Parse(ds.Tables[0].Rows[n]["Project_SubmitTime"].ToString());
}
model.Project_Open = ds.Tables[0].Rows[n]["Project_Open"].ToString();
if (ds.Tables[0].Rows[n]["Project_PartnerTeamNum"].ToString() != "")
{
model.Project_PartnerTeamNum = int.Parse(ds.Tables[0].Rows[n]["Project_PartnerTeamNum"].ToString());
}
if (ds.Tables[0].Rows[n]["OPProjectID"].ToString() != "")
{
model.OPProjectID = int.Parse(ds.Tables[0].Rows[n]["OPProjectID"].ToString());
}
if (ds.Tables[0].Rows[n]["Project_StartWeek"].ToString() != "")
{
model.Project_StartWeek = int.Parse(ds.Tables[0].Rows[n]["Project_StartWeek"].ToString());
}
if (ds.Tables[0].Rows[n]["Project_EndWeek"].ToString() != "")
{
model.Project_EndWeek = int.Parse(ds.Tables[0].Rows[n]["Project_EndWeek"].ToString());
}
model.Project_Subject = ds.Tables[0].Rows[n]["Project_Subject"].ToString();
model.Project_Request = ds.Tables[0].Rows[n]["Project_Request"].ToString();
if (ds.Tables[0].Rows[n]["Project_PerConsume"].ToString() != "")
{
model.Project_PerConsume = int.Parse(ds.Tables[0].Rows[n]["Project_PerConsume"].ToString());
}
ls.Add(model);
}
}
return ls;
}
/// <summary>
/// ��������б�
/// </summary>
public List<LabMS.Model.Project> GetModelList(string strWhere)
{
DataSet ds = dal.GetList(strWhere);
List<LabMS.Model.Project> modelList = new List<LabMS.Model.Project>();
int rowsCount = ds.Tables[0].Rows.Count;
if (rowsCount > 0)
{
LabMS.Model.Project model;
for (int n = 0; n < rowsCount; n++)
{
model = new LabMS.Model.Project();
if(ds.Tables[0].Rows[n]["ID"].ToString()!="")
{
model.ID=int.Parse(ds.Tables[0].Rows[n]["ID"].ToString());
}
model.Project_Code=ds.Tables[0].Rows[n]["Project_Code"].ToString();
model.Project_Category=ds.Tables[0].Rows[n]["Project_Category"].ToString();
model.Project_Name=ds.Tables[0].Rows[n]["Project_Name"].ToString();
if(ds.Tables[0].Rows[n]["Project_Lab"].ToString()!="")
{
model.Project_Lab=int.Parse(ds.Tables[0].Rows[n]["Project_Lab"].ToString());
}
if(ds.Tables[0].Rows[n]["Project_StartTime"].ToString()!="")
{
model.Project_StartTime=DateTime.Parse(ds.Tables[0].Rows[n]["Project_StartTime"].ToString());
}
if(ds.Tables[0].Rows[n]["Project_EndTime"].ToString()!="")
{
model.Project_EndTime=DateTime.Parse(ds.Tables[0].Rows[n]["Project_EndTime"].ToString());
}
if(ds.Tables[0].Rows[n]["Project_ClassHourse"].ToString()!="")
{
model.Project_ClassHourse=int.Parse(ds.Tables[0].Rows[n]["Project_ClassHourse"].ToString());
}
if(ds.Tables[0].Rows[n]["Project_ExpHouse"].ToString()!="")
{
model.Project_ExpHouse=int.Parse(ds.Tables[0].Rows[n]["Project_ExpHouse"].ToString());
}
model.Project_AwardLevel=ds.Tables[0].Rows[n]["Project_AwardLevel"].ToString();
model.Project_PartnerType=ds.Tables[0].Rows[n]["Project_PartnerType"].ToString();
model.Project_Type=ds.Tables[0].Rows[n]["Project_Type"].ToString();
if(ds.Tables[0].Rows[n]["Project_Consume"].ToString()!="")
{
model.Project_Consume=int.Parse(ds.Tables[0].Rows[n]["Project_Consume"].ToString());
}
model.Project_Change=ds.Tables[0].Rows[n]["Project_Change"].ToString();
if(ds.Tables[0].Rows[n]["Project_PartnerNum"].ToString()!="")
{
model.Project_PartnerNum=int.Parse(ds.Tables[0].Rows[n]["Project_PartnerNum"].ToString());
}
if(ds.Tables[0].Rows[n]["Project_Professional"].ToString()!="")
{
model.Project_Professional=int.Parse(ds.Tables[0].Rows[n]["Project_Professional"].ToString());
}
model.Project_Content=ds.Tables[0].Rows[n]["Project_Content"].ToString();
model.Project_CourseMode=ds.Tables[0].Rows[n]["Project_CourseMode"].ToString();
if(ds.Tables[0].Rows[n]["Project_SubmitTime"].ToString()!="")
{
model.Project_SubmitTime=DateTime.Parse(ds.Tables[0].Rows[n]["Project_SubmitTime"].ToString());
}
model.Project_Open=ds.Tables[0].Rows[n]["Project_Open"].ToString();
if(ds.Tables[0].Rows[n]["Project_PartnerTeamNum"].ToString()!="")
{
model.Project_PartnerTeamNum=int.Parse(ds.Tables[0].Rows[n]["Project_PartnerTeamNum"].ToString());
}
if(ds.Tables[0].Rows[n]["OPProjectID"].ToString()!="")
{
model.OPProjectID=int.Parse(ds.Tables[0].Rows[n]["OPProjectID"].ToString());
}
if(ds.Tables[0].Rows[n]["Project_StartWeek"].ToString()!="")
{
model.Project_StartWeek=int.Parse(ds.Tables[0].Rows[n]["Project_StartWeek"].ToString());
}
if(ds.Tables[0].Rows[n]["Project_EndWeek"].ToString()!="")
{
model.Project_EndWeek=int.Parse(ds.Tables[0].Rows[n]["Project_EndWeek"].ToString());
}
model.Project_Subject=ds.Tables[0].Rows[n]["Project_Subject"].ToString();
model.Project_Request=ds.Tables[0].Rows[n]["Project_Request"].ToString();
if(ds.Tables[0].Rows[n]["Project_PerConsume"].ToString()!="")
{
model.Project_PerConsume=int.Parse(ds.Tables[0].Rows[n]["Project_PerConsume"].ToString());
}
modelList.Add(model);
}
}
return modelList;
}
