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;
}
}
}
