private void lovButtonEx2_Click(object sender, EventArgs e)
{
Mes.ControlsEx.LovFormExParameter test2 = new Mes.ControlsEx.LovFormExParameter();
test2.QuerySql = @"select item_id,item_code,descriptions from hcm_item where 1=1 and plant_id " + Mes.Core.Utility.StrUtil.ProcInput(this.tbPlantId.Text, false);
test2.LovFormExTitle = "物料";
test2.ColumnsName.Add("ID");
test2.ColumnsName.Add("物料编码");
test2.ColumnsName.Add("物料描述");
test2.ColumnVisableList.Add(true);
test2.ColumnVisableList.Add(true);
test2.ColumnVisableList.Add(true);
test2.TargetTextBoxEx = tbItemNo;
lovButtonEx2.LovParameter = test2;
}
private void QueryForm_Load(object sender, EventArgs e)
{
OnQuery += QueryForm_OnQuery;
OnCancelQuery += QueryForm_OnCancelQuery;
Mes.ControlsEx.LovFormExParameter test1 = new Mes.ControlsEx.LovFormExParameter();
//Mes.ControlsEx.LovFormExParameter test2 = new Mes.ControlsEx.LovFormExParameter();
test1.QuerySql = @"select plant_id,plant_code,DESCRIPTIONS from HCM_PLANT where 1=1";
test1.LovFormExTitle = "工厂";
test1.ColumnsName.Add("ID");
test1.ColumnsName.Add("工厂编号");
test1.ColumnsName.Add("工厂描述");
test1.ColumnVisableList.Add(true);
test1.ColumnVisableList.Add(true);
test1.ColumnVisableList.Add(true);
test1.TargetTextBoxEx = tbPlantId;
lovButtonEx1.LovParameter = test1;
}
private void QueryForm_Load(object sender, EventArgs e)
{
panelEx1.Dock = DockStyle.Fill;
cmbTest.InitType = ComboBoxInitType.FASTWITHNULL;
cmbTest.InitFastCodeOrSql = "YES_NO";
cmbTest.InitType = ComboBoxInitType.SQLWITHNULL;
cmbTest.InitFastCodeOrSql = "select id,name feom table";
Mes.ControlsEx.LovFormExParameter test = new Mes.ControlsEx.LovFormExParameter();
test.QuerySql = @"select id,code,className,className from classtable a where a.className"
+ Mes.Core.Utility.StrUtil.SQL_PLACEHOLDER;
test.LovFormExTitle = "班级";
test.ColumnsName.Add("ID");
test.ColumnsName.Add("班级编号");
test.ColumnsName.Add("班级名称");
test.ColumnVisableList.Add(true);
test.ColumnVisableList.Add(true);
test.ColumnVisableList.Add(true);
test.TargetTextBoxEx = textBoxEx1;
lovButtonEx1.LovParameter = test;
}
