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; }