private void cmbRawSecond_SelectedIndexChanged(object sender, EventArgs e) { if (this.cmbRawSecond.SelectedValue.ToString().Length > 5) { return; } string strWhere = "level2_id = 1 and level3_id = " + this.cmbRawFirst.SelectedValue + " and name = " + this.cmbRawSecond.SelectedValue; Material.BLL.level4 lev4 = new Material.BLL.level4(); List <Material.Model.level4> list = lev4.GetModelList(strWhere); cmbRawThird.DataSource = list; cmbRawThird.DisplayMember = "name2"; cmbRawThird.ValueMember = "id4"; cmbRawThird.Text = ""; this.txtCode.Text = ""; this.txtCode.Text = "1." + this.txtCode.Text + this.cmbRawFirst.SelectedValue + "." + this.cmbRawSecond.SelectedValue + "." + this.txtRawLabel.Text + "." + this.txtThick.Text + "." + this.txtSize.Text; }
private void searchLevelThird(string codeFirst, string codeSecond, string codeThird) { string strWhere = "level2_id = 1 and level3_id = " + codeFirst + " and name = " + codeSecond + " and id4 = " + codeThird; Material.BLL.level4 lev4 = new Material.BLL.level4(); List <Material.Model.level4> list = lev4.GetModelList(strWhere); if (1 == list.Count) { Form1 frmMain = Application.OpenForms["Form1"] as Form1; frmMain.setSearchLabel3("三级子类:" + list[0].name2); } }