第十三篇
其实一个COMBOX就能完成的功能
但是数据源 非得输入自动匹配 又得点按钮弹对话框加数据源
没办法 只有吧要保存的东西放在控件的TAG里面
一个数据源字段弄这么多 里面不下10个呀
而且 这样一改 以前一段很精彩的程序也得另谋其他的出路
private void SaleCompany_EditValueChanged(object sender, EventArgs e)
{
}
private void SaleCompany_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar != 13)
return;
if (dt6 == null)
dt6 = SqlHelper.ExecuteDataTable(connString, sqlCompany);
string s = SaleCompany.Text;
DataRow[] rows = dt6.Select(@"名称='" + s + "'");
if (rows.Length == 0)
{
rows = dt6.Select(@"编码='" + s + "'");
if (rows.Length == 0)
{
SaleCompany.TextChanged -= SaleCompany_EditValueChanged;
SaleCompany.Text = "";
SaleCompany.TextChanged += SaleCompany_EditValueChanged;
}
else
{
SaleCompany.TextChanged -= SaleCompany_EditValueChanged;
SaleCompany.Text = rows[0]["名称"].ToString();
SaleCompany.Tag = rows[0]["编码"].ToString();
SaleCompany.TextChanged += SaleCompany_EditValueChanged;
}
}
else
{
SaleCompany.Tag = rows[0]["编码"].ToString();
}
}
private void SaleCompany_Properties_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (dt6 == null)
dt6 = SqlHelper.ExecuteDataTable(connString, sqlCompany);
using (C11020012 form = new C11020012())
{
form.TreeList.DataSource = dt6.DefaultView;
if (form.ShowDialog() == DialogResult.OK)
{
}
else
{
if (form.aRow != null)
{
SaleCompany.EditValue = form.aRow["名称"].ToString();
SaleCompany.Tag = form.aRow["编码"].ToString();
//moneyType.EditValue = form.aRow["编码"].ToString();
}
}
form.Dispose();
}
}
{
}
private void SaleCompany_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar != 13)
return;
if (dt6 == null)
dt6 = SqlHelper.ExecuteDataTable(connString, sqlCompany);
string s = SaleCompany.Text;
DataRow[] rows = dt6.Select(@"名称='" + s + "'");
if (rows.Length == 0)
{
rows = dt6.Select(@"编码='" + s + "'");
if (rows.Length == 0)
{
SaleCompany.TextChanged -= SaleCompany_EditValueChanged;
SaleCompany.Text = "";
SaleCompany.TextChanged += SaleCompany_EditValueChanged;
}
else
{
SaleCompany.TextChanged -= SaleCompany_EditValueChanged;
SaleCompany.Text = rows[0]["名称"].ToString();
SaleCompany.Tag = rows[0]["编码"].ToString();
SaleCompany.TextChanged += SaleCompany_EditValueChanged;
}
}
else
{
SaleCompany.Tag = rows[0]["编码"].ToString();
}
}
private void SaleCompany_Properties_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (dt6 == null)
dt6 = SqlHelper.ExecuteDataTable(connString, sqlCompany);
using (C11020012 form = new C11020012())
{
form.TreeList.DataSource = dt6.DefaultView;
if (form.ShowDialog() == DialogResult.OK)
{
}
else
{
if (form.aRow != null)
{
SaleCompany.EditValue = form.aRow["名称"].ToString();
SaleCompany.Tag = form.aRow["编码"].ToString();
//moneyType.EditValue = form.aRow["编码"].ToString();
}
}
form.Dispose();
}
}