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(""); } }