private void Add_Click(object sender, EventArgs e)
{
if (tbKh.Text.Trim() == "")
{
MessageBox.Show("请输入 客户 ！"); return;
}
string OutValue = "";
int showx, showy;
showx = Left + tbKh.Left;
showy = Top + tbKh.Top + tbKh.Height;
if (CommFunction.ShowGetCodeForm(this.Handle, CommFunction.ConnectString,
"select MISC_INSTR_CODE_2 as 货主客户代码,客户名称 from V_VENDOR_MASTER group by MISC_INSTR_CODE_2,客户名称",
"MISC_INSTR_CODE_2,客户名称", tbKh.Text, "代码", 0,
showx, showy, true,
false, true,
true, ref OutValue) && (OutValue != ""))
{
string[] sArray = OutValue.Split('|');
for (int i = 0; i < lvKh.Items.Count; i++)
{
if (lvKh.Items[i].SubItems[0].Text.ToString() == sArray[0].ToString())
{
return;
}
}
ListViewItem lvi = new ListViewItem(sArray[0].ToString());
lvi.SubItems.Add(sArray[1].ToString());
lvKh.Items.Add(lvi);
}
tbKh.Focus();
tbKh.SelectAll();
}
private void tbSku_id_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyValue != 13)
{
return;
}
if (tbSku_id.Text.Trim() == "")
{
MessageBox.Show("请输入 SKU_ID ！"); return;
}
string OutValue = "";
int showx, showy;
showx = Left + (sender as TextBox).Left;
showy = Top + (sender as TextBox).Top + (sender as TextBox).Height;
if (CommFunction.ShowGetCodeForm(this.Handle, CommFunction.ConnectString,
"select sku_id,season as 货主代码,size_desc as 商品代码,sku_desc as 品名规格, " +
" spl_instr_1||spl_instr_2 as 生产厂家,std_pack_qty as 件装数 from item_master@wmrdc " +
" where sku_id='" + tbSku_id.Text.Trim() + "'",
"sku_id,size_desc,sku_desc", (sender as TextBox).Text, "代码", 0,
showx, showy, true,
false, true,
false, ref OutValue) && (OutValue != ""))
{
string[] sArray = OutValue.Split('|');
(sender as TextBox).Text = sArray[0];
cbHz.Text = sArray[1];
tbSpdm.Text = sArray[2];
tbPmgg.Text = sArray[3];
tbSccj.Text = sArray[4];
tbJzs.Text = sArray[5];
}
}
