public List <SkillRequirementModel> GetList(string DeptCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,ProfessionalBaseCode,ProfessionalBaseName,DeptCode,DeptName,DeptTime,IsRequired,SkillCode,SkillName,RequiredNum,MasterDegree,Tag1,Tag2,Tag3 from GP_SkillRequirement ");
strSql.Append(" where SkillCode like @SkillCode");
SqlParameter[] parameters =
{
new SqlParameter("@SkillCode", SqlDbType.NVarChar, 50)
};
parameters[0].Value = DeptCode + "%";;
DataTable dt = db.RunDataTable(strSql.ToString(), parameters);
List <SkillRequirementModel> list = null;
if (dt.Rows.Count > 0)
{
list = new List <SkillRequirementModel>();
SkillRequirementModel model = null;
foreach (DataRow row in dt.Rows)
{
model = new SkillRequirementModel();
model = DataRowToModel(row);
list.Add(model);
}
}
return(list);
}
public SkillRequirementModel DataRowToModel(DataRow row)
{
SkillRequirementModel model = new SkillRequirementModel();
if (row != null)
{
if (row["Id"] != null)
{
model.Id = row["Id"].ToString();
}
if (row["ProfessionalBaseCode"] != null)
{
model.ProfessionalBaseCode = row["ProfessionalBaseCode"].ToString();
}
if (row["ProfessionalBaseName"] != null)
{
model.ProfessionalBaseName = row["ProfessionalBaseName"].ToString();
}
if (row["DeptCode"] != null)
{
model.DeptCode = row["DeptCode"].ToString();
}
if (row["DeptName"] != null)
{
model.DeptName = row["DeptName"].ToString();
}
if (row["DeptTime"] != null)
{
model.DeptTime = row["DeptTime"].ToString();
}
if (row["IsRequired"] != null)
{
model.IsRequired = row["IsRequired"].ToString();
}
if (row["SkillCode"] != null)
{
model.SkillCode = row["SkillCode"].ToString();
}
if (row["SkillName"] != null)
{
model.SkillName = row["SkillName"].ToString();
}
if (row["RequiredNum"] != null)
{
model.RequiredNum = row["RequiredNum"].ToString();
}
if (row["MasterDegree"] != null)
{
model.MasterDegree = row["MasterDegree"].ToString();
}
if (row["Tag1"] != null)
{
model.Tag1 = row["Tag1"].ToString();
}
if (row["Tag2"] != null)
{
model.Tag2 = row["Tag2"].ToString();
}
if (row["Tag3"] != null)
{
model.Tag3 = row["Tag3"].ToString();
}
}
return(model);
}