private void lookUpEdit1_Properties_EditValueChanged(object sender, EventArgs e)
{
try
{
if (panCountrylook.Text.Trim() != "")
{
string sql = f1.StoredProcedure + "@TYPE='P_SE_TU_COUNTRY' ";
sql = sql + string.Format(",@BU ='{0}' ", panCountrylook.Text.Trim());
DataSet ds = f1.sqlQ(sql);
ControlsUtils.BindLookUpEdit(barPolook, ds.Tables[0], "PO_CER", "PO_CER", false);
ControlsUtils.BindLookUpEdit(barPoEDlook, ds.Tables[1], "PO_ED", "PO_ED", false);
}
else
{
barPolook.Properties.DataSource = null;
barPolook.Properties.DisplayMember = null;
barPolook.Properties.ValueMember = null;
barPoEDlook.Properties.DataSource = null;
barPoEDlook.Properties.DisplayMember = null;
barPoEDlook.Properties.ValueMember = null;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void WritePortLook(string po)
{
string sql = form1.StoredProcedure + "@TYPE = 'PORT_LIST'";
sql = sql + string.Format(",@PO = '{0}'", po);
DataSet ds = form1.sqlQ(sql);
ControlsUtils.BindLookUpEdit(lookPort, ds.Tables[0], "D_PORT", "D_PORT", false);
}
public void LoadBindLookUp()
{
luEdit_GroupMat.EditValue = null;
luEdit_GroupMat.Text = string.Empty;
string sql = form1.StoredProcedure + " @TYPE='MAT_MASTER_GET' ";
DataSet ds = form1.sqlQ(sql);
ControlsUtils.BindLookUpEdit(luEdit_GroupMat, ds.Tables[3], "RG_NAME", "ROW_GROUP_ID", false);
}
public void loadProdPlan()
{
//string sql = "SELECT Customer_Name AS P_B_UNIT FROM UXFMUNI..UTAX_CUSTOMER WHERE Use_Active = 1 ORDER BY Customer_Name";
//DataSet ds = f1.sqlQ(sql);
//ControlsUtils.BindLookUpEdit(panCountrylook, ds.Tables[0], "P_B_UNIT", "P_B_UNIT", false);
string sql = f1.StoredProcedure + " @TYPE = 'P_START'";
DataSet ds = f1.sqlQ(sql);
ControlsUtils.BindLookUpEdit(panCountrylook, ds.Tables[7], "P_B_UNIT", "P_B_UNIT", false);
ControlsUtils.BindLookUpEdit(lookListBu, ds.Tables[7], "P_B_UNIT", "P_B_UNIT", false);
ControlsUtils.BindLookUpEdit(blPoTxt, ds.Tables[4], "PO_BRA", "PO_BRA", false);
}
//======================== TAB SET Master material group =========================================//
public void Load_MatMasterList()
{
try
{
DataSet ds = MatGroup.ds_MatMasterList();
gCtrl_GroupMas.DataSource = ds.Tables[2];
//ControlsUtils.BindLookUpEdit(cStockLu, ds.Tables[1], "COLOR", "COLOR", false);
ControlsUtils.BindLookUpEdit(luEdit_GroupID, ds.Tables[3], "RG_NAME", "ROW_GROUP_ID", false);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}