private void BindCombox() { string sql = "select GoodId,GoodName from tb_GoodsInfo "; ds = dbl.GetDatasetReport(sql, "tb_GoodsInfo"); List <string> listArr = new List <string>(); if (ds != null) { if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { //this.lbgoods.Visible = true; //this.lbgoods.Items.Clear(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { listArr.Add(ds.Tables[0].Rows[i][1].ToString()); cbgoods.Items.Add(ds.Tables[0].Rows[i][1].ToString()); } } string[] myarr = listArr.ToArray(); cbgoods.AutoCompleteCustomSource.AddRange(myarr); cbgoods.AutoCompleteSource = AutoCompleteSource.CustomSource; cbgoods.AutoCompleteMode = AutoCompleteMode.SuggestAppend; tbGoodsname.AutoCompleteCustomSource.AddRange(myarr); tbGoodsname.AutoCompleteSource = AutoCompleteSource.CustomSource; tbGoodsname.AutoCompleteMode = AutoCompleteMode.SuggestAppend; } } }
private void BindWareHouse() { string sql = "select WareID,WareName from tb_WareHouse order by wareid "; ds = dbl.GetDatasetReport(sql, "tb_WareHouse"); List <string> listArr = new List <string>(); if (ds != null) { if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { //this.lbgoods.Visible = true; //this.lbgoods.Items.Clear(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { listArr.Add(ds.Tables[0].Rows[i][1].ToString()); cbwarehouse.Items.Add(ds.Tables[0].Rows[i][1].ToString()); } } string[] myarr = listArr.ToArray(); // cbwarehouse.AutoCompleteCustomSource.AddRange(myarr); //cbwarehouse.AutoCompleteSource = AutoCompleteSource.CustomSource; // cbwarehouse.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cbwarehouse.DataSource = ds.Tables[0]; cbwarehouse.DisplayMember = "WareName"; cbwarehouse.ValueMember = "WareID"; } } }
private void tbgoodsid_TextChanged(object sender, EventArgs e) { /* List<string> listArr = new List<string>(); * if (ds.Tables.Count > 0) * { * if (ds.Tables[0].Rows.Count > 0) * { * //this.lbgoods.Visible = true; * //this.lbgoods.Items.Clear(); * for (int i = 0; i < ds.Tables[0].Rows.Count; i++) * { * listArr.Add(ds.Tables[0].Rows[i][1].ToString()); * } * } * } * //string[] myarr = listArr.ToArray(); * //tbgoodsid.AutoCompleteCustomSource.AddRange(myarr); * //tbgoodsid.AutoCompleteSource = AutoCompleteSource.CustomSource; * //tbgoodsid.AutoCompleteMode = AutoCompleteMode.SuggestAppend; *///DataBase db = new DataBase();//自己写的类 string sql = "select GoodId,GoodName from tb_GoodsInfo where GoodId like " + "'%" + this.tbgoodsid.Text + "%'"; ds = dbl.GetDatasetReport(sql, "tb_GoodsInfo"); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { this.lbgoods.Visible = true; this.lbgoods.Items.Clear(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { this.lbgoods.Items.Add(ds.Tables[0].Rows[i][1].ToString()); } } } }
private void BindColor() { string sql = "select ColorNo,ColorName from tb_ColorInfo where fisstop = 0 "; ds = dbl.GetDatasetReport(sql, "tb_ColorInfo"); List <string> listArr = new List <string>(); if (ds != null) { if (ds.Tables.Count > 0) { tbMaterial.DataSource = ds.Tables[0]; tbMaterial.DisplayMember = "ColorName"; tbMaterial.ValueMember = "ColorNo"; if (ds.Tables[0].Rows.Count > 0) { //this.lbgoods.Visible = true; //this.lbgoods.Items.Clear(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { listArr.Add(ds.Tables[0].Rows[i][1].ToString()); //tbmodelno.Items.Add(ds.Tables[0].Rows[i][1].ToString()); } } string[] myarr = listArr.ToArray(); //cbgoods.AutoCompleteCustomSource.AddRange(myarr); //cbgoods.AutoCompleteSource = AutoCompleteSource.CustomSource; //cbgoods.AutoCompleteMode = AutoCompleteMode.SuggestAppend; tbMaterial.AutoCompleteCustomSource.AddRange(myarr); tbMaterial.AutoCompleteSource = AutoCompleteSource.CustomSource; tbMaterial.AutoCompleteMode = AutoCompleteMode.SuggestAppend; } } }