private void button2_Click(object sender, EventArgs e)
{
try
{
U8RefService.IServiceClass obj = new U8RefService.IServiceClass();
obj.RefID = "hr_hi_person_AA";
obj.Mode = U8RefService.RefModes.modeRefing;
//obj.FilterSQL = " cdepcode in ('01','04','07') and rpersontype =10";
obj.FillText = txtFzr.Text;
obj.Web = false;
obj.MetaXML = "<Ref><RefSet bMultiSel='0' /></Ref>";
obj.RememberLastRst = false;
ADODB.Recordset retRstGrid = null, retRstClass = null;
string sErrMsg = "";
obj.GetPortalHwnd((int)this.Handle);
Object objLogin = canshu.u8Login;
if (obj.ShowRefSecond(ref objLogin, ref retRstClass, ref retRstGrid, ref sErrMsg) == false)
{
MessageBox.Show(sErrMsg);
}
else
{
if (retRstGrid != null)
{
this.txtFzr.Text = DbHelper.GetDbString(retRstGrid.Fields["cpsn_name"].Value);
}
}
}
catch (Exception ex)
{
MessageBox.Show("参照失败，原因：" + ex.Message);
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
U8RefService.IServiceClass obj = new U8RefService.IServiceClass();
obj.RefID = "U8CUSTDEF_0016_AA";
obj.Mode = U8RefService.RefModes.modeRefing;
//obj.FilterSQL = " bbomsub =1";
//obj.FillText = dataGridView1.CurrentCell.Value.ToString();
obj.Web = false;
obj.MetaXML = "<Ref><RefSet bMultiSel='0' /></Ref>";
obj.RememberLastRst = false;
ADODB.Recordset retRstGrid = null, retRstClass = null;
string sErrMsg = "";
obj.GetPortalHwnd((int)this.Handle);
Object objLogin = canshu.u8Login;
if (obj.ShowRefSecond(ref objLogin, ref retRstClass, ref retRstGrid, ref sErrMsg) == false)
{
MessageBox.Show(sErrMsg);
}
else
{
if (retRstGrid != null)
{
txtcgy.Text = DbHelper.GetDbString(retRstGrid.Fields["cNo"].Value);
}
}
}
catch (Exception ex)
{
MessageBox.Show("参照失败，原因：" + ex.Message);
}
}
private void btnWhcode_Click(object sender, EventArgs e)
{
try
{
U8RefService.IServiceClass obj = new U8RefService.IServiceClass();
obj.RefID = "Warehouse_AA";
obj.Mode = U8RefService.RefModes.modeRefing;
//obj.FilterSQL = " Status='3' ";
obj.FillText = txtcWhcode.Text;
obj.Web = false;
obj.MetaXML = "<Ref><RefSet bMultiSel='0' /></Ref>";
obj.RememberLastRst = false;
ADODB.Recordset retRstGrid = null, retRstClass = null;
string sErrMsg = "";
obj.GetPortalHwnd((int)this.Handle);
Object objLogin = canshu.u8Login;
if (obj.ShowRefSecond(ref objLogin, ref retRstClass, ref retRstGrid, ref sErrMsg) == false)
{
MessageBox.Show(sErrMsg);
}
else
{
if (retRstGrid != null)
{
this.txtcWhcode.Text = DbHelper.GetDbString(retRstGrid.Fields["cwhcode"].Value);
}
}
}
catch (Exception ex)
{
MessageBox.Show("参照失败，原因：" + ex.Message);
}
}
void btn_Click(object sender, EventArgs e)
{
if (sColname == "gys")
{
try
{
U8RefService.IServiceClass obj = new U8RefService.IServiceClass();
obj.RefID = "vendor_AA";
obj.Mode = U8RefService.RefModes.modeRefing;
//obj.FilterSQL = " bbomsub =1";
obj.FillText = dataGridView2.CurrentCell.Value.ToString();
obj.Web = false;
obj.MetaXML = "<Ref><RefSet bMultiSel='0' /></Ref>";
obj.RememberLastRst = false;
ADODB.Recordset retRstGrid = null, retRstClass = null;
string sErrMsg = "";
obj.GetPortalHwnd((int)this.Handle);
Object objLogin = canshu.u8Login;
if (obj.ShowRefSecond(ref objLogin, ref retRstClass, ref retRstGrid, ref sErrMsg) == false)
{
MessageBox.Show(sErrMsg);
}
else
{
if (retRstGrid != null)
{
dtXunjia.Rows[dataGridView1.CurrentCell.RowIndex]["cvenname"] = DbHelper.GetDbString(retRstGrid.Fields["cvenname"].Value);
//dataGridView2.CurrentCell.Value = DbHelper.GetDbString(retRstGrid.Fields["cvenname"].Value);
//dataGridView2.Rows[dataGridView2.CurrentCellAddress.Y].Cells["cinvname"].Value = DbHelper.GetDbString(retRstGrid.Fields["cinvname"].Value);
//dataGridView2.Rows[dataGridView2.CurrentCellAddress.Y].Cells["cinvstd"].Value = DbHelper.GetDbString(retRstGrid.Fields["cinvstd"].Value);
//this.textBox3.Text = DbHelper.GetDbString(retRstGrid.Fields["cdepcode"].Value);
}
}
}
catch (Exception ex)
{
MessageBox.Show("参照失败，原因：" + ex.Message);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
U8RefService.IServiceClass obj = new U8RefService.IServiceClass();
obj.RefID = "Inventory_AA";
obj.Mode = U8RefService.RefModes.modeRefing;
//obj.FilterSQL = " cinvcode like '40%' ";
obj.FillText = txtpm.Text;
obj.Web = false;
obj.MetaXML = "<Ref><RefSet bMultiSel='0' /></Ref>";
obj.RememberLastRst = false;
ADODB.Recordset retRstGrid = null, retRstClass = null;
string sErrMsg = "";
obj.GetPortalHwnd((int)this.Handle);
Object objLogin = canshu.u8Login;
if (obj.ShowRefSecond(ref objLogin, ref retRstClass, ref retRstGrid, ref sErrMsg) == false)
{
MessageBox.Show(sErrMsg);
}
else
{
if (retRstGrid != null)
{
this.txtpm.Text = DbHelper.GetDbString(retRstGrid.Fields["cinvcode"].Value);
//this.label10.Text = DbHelper.GetDbString(retRstGrid.Fields["cinvname"].Value);
//this.label11.Text = DbHelper.GetDbString(retRstGrid.Fields["cinvstd"].Value);
//this.label14.Text = DbHelper.GetDbString(retRstGrid.Fields["cinvdefine1"].Value);
//this.textBox3.Text = DbHelper.GetDbString(retRstGrid.Fields["cdepcode"].Value);
}
}
}
catch (Exception ex)
{
MessageBox.Show("参照失败，原因：" + ex.Message);
}
}
