public static void searchAndSetLevel2(ComboBox cbox, String mainClassID, String level1ID)
{
//查询2级类别, mainClassID指明顶级类1-9
string strWhere = "MainClassID = '" + mainClassID + "' and Level1ID = '" + level1ID + "'";
MaterialCodeGenerator.BLL.MaterialCode table = new MaterialCodeGenerator.BLL.MaterialCode();
List <MaterialCodeGenerator.Model.MaterialCode> list = listLevelDistinct(table.GetModelList(strWhere), 2);
cbox.DataSource = list;
cbox.DisplayMember = "Level2Name";
cbox.ValueMember = "Level2ID";
cbox.Text = "";
}
//查询一级大类下的级别
public static string GetFields2(string mainClassID, string subClassID)
{
string strWhere = "MainClassID = '" + mainClassID + "' and (Level1ID = '" + subClassID + "' or Level2ID = '" + subClassID + "' or Level3ID = '" + subClassID + "')";
MaterialCodeGenerator.BLL.MaterialCode table = new MaterialCodeGenerator.BLL.MaterialCode();
List <MaterialCodeGenerator.Model.MaterialCode> list = table.GetModelList(strWhere);
if (list.Count > 0)
{
return(" " + list[0].Level1Name + " " + list[0].Level2Name + " " + list[0].Level3Name);
}
else
{
return("");
}
}
