public static void LoadComboBox(ComboBox cb, DataTable dt, string valueMember, string displayMember, string focusID) { string text = ""; string value = ""; cb.Items.Clear(); ListItem l = new ListItem("###", "请选择"); cb.Items.Add(l); int focusindex = -1,i=1; foreach (DataRow dr in dt.Rows) { text = dr[displayMember].ToString(); value = dr[valueMember].ToString(); l = new ListItem(value, text); cb.Items.Add(l); if (focusID!=""&&value == focusID) { focusindex = i; } i++; } cb.DisplayMember = "name"; cb.ValueMember = "id"; if (focusindex > -1) { cb.SelectedIndex = focusindex; } else { cb.SelectedIndex = 0; } }
private void frmExcelEditSQLSet_Load(object sender, EventArgs e) { int i = 0; LP_Temple tp = ClientHelper.PlatformSqlMap.GetOneByKey<LP_Temple>(rowData.ParentID); string[] comItem = SelectorHelper.ToDBC(rowData.ColumnName).Split('|'); griddt = new DataTable(); griddt.Columns.Add("name", typeof(string)); griddt.Columns.Add("sql", typeof(string)); griddt.Rows.Clear(); comboBox1.Items.Clear(); i = 0; foreach (string strname in comItem) { DataRow dr = griddt.NewRow(); if (strname == "") continue; dr["name"] = strname; Regex r1 = new Regex(@"(?<=\[" + i + ":).*?(?=\\])"); if (r1.Match(rowData.ComBoxItem).Value != "") { dr["sql"] = r1.Match(rowData.ComBoxItem).Value; } griddt.Rows.Add(dr); i++; } WinFormFun.LoadComboBox(columnBox, griddt, "sql", "name"); gridControl1.DataSource = griddt; gridView1.Columns["name"].Caption = "列名"; gridView1.Columns["name"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; gridView1.Columns["name"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; gridView1.Columns["name"].OptionsColumn.AllowEdit = false; gridView1.Columns["sql"].Caption = "绑定控件"; gridView1.Columns["sql"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; gridView1.Columns["sql"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center; gridView1.Columns["sql"].OptionsColumn.AllowEdit = true; //gridView1.OptionsBehavior.Editable = false; ListItem lt = new ListItem("RepositoryItemComboBox", "下拉控件"); comboBox1.Items.Add(lt); lt = new ListItem("RepositoryItemCheckedComboBoxEdit", "下拉多选控件"); comboBox1.Items.Add(lt); lt = new ListItem("RepositoryItemDateEdit", "时间控件"); comboBox1.Items.Add(lt); lt = new ListItem("RepositoryItemCalcEdit", "计算器"); comboBox1.Items.Add(lt); lt = new ListItem("RepositoryItemSpinEdit", "数字控件"); comboBox1.Items.Add(lt); lt = new ListItem("yyyy年MM月dd日", "yyyy年MM月dd日"); comboBox2.Items.Add(lt); lt = new ListItem("yyyy-MM-dd", "yyyy-MM-dd"); comboBox2.Items.Add(lt); lt = new ListItem("MM-dd日", "MM-dd日"); comboBox2.Items.Add(lt); lt = new ListItem("yyyy-MM-dd HH:mm", "yyyy-MM-dd HH:mm"); comboBox2.Items.Add(lt); lt = new ListItem("yyyy-MM-dd HH:mm:ss", "yyyy-MM-dd HH:mm:ss"); comboBox2.Items.Add(lt); lt = new ListItem("MM-dd日 HH:mm", "MM-dd日 HH:mm"); comboBox2.Items.Add(lt); lt = new ListItem("dd日 HH:mm", "dd日 HH:mm"); comboBox2.Items.Add(lt); lt = new ListItem("HH:mm:ss", "HH:mm:ss"); comboBox2.Items.Add(lt); lt = new ListItem("HH:mm", "HH:mm"); comboBox2.Items.Add(lt); lt = new ListItem("yyyy", "yyyy"); comboBox2.Items.Add(lt); lt = new ListItem("yyyy年MM月dd日", "yyyy年MM月dd日"); comboBox2.Items.Add(lt); lt = new ListItem("0.0000", "0.0000"); comboBox3.Items.Add(lt); lt = new ListItem("#########0.0000", "#########0.0000"); comboBox3.Items.Add(lt); lt = new ListItem("##########.0000", "##########.0000"); comboBox3.Items.Add(lt); lt = new ListItem("p", "p"); comboBox3.Items.Add(lt); lt = new ListItem("c", "c"); comboBox3.Items.Add(lt); lt = new ListItem("n0", "n0"); comboBox3.Items.Add(lt); lt = new ListItem("##########.##", "##########.##"); comboBox3.Items.Add(lt); lt = new ListItem("000.##", "000.##"); comboBox3.Items.Add(lt); }
private void frmExcelEditSQLSet_Load(object sender, EventArgs e) { cbxSWorkFolwDataTable.Items.Clear(); cbxTWorkFolwDataTable.Items.Clear(); comboBox1.Items.Clear(); ListItem l = new ListItem("###", "请选择"); cbxSWorkFolwDataTable.Items.Add(l); cbxTWorkFolwDataTable.Items.Add(l); IList li = MainHelper.PlatformSqlMap.GetList("SelectWF_WorkFlowList", " where 1=1 order by FlowCaption "); DataTable dt = ConvertHelper.ToDataTable(li); WinFormFun.LoadComboBox(cbxTWorkFolwDataTable, dt, "WorkFlowId", "FlowCaption"); WF_WorkFlow wf = new WF_WorkFlow(); wf.FlowCaption = "无"; wf.WorkFlowId = "无"; li.Insert(0, wf); dt = ConvertHelper.ToDataTable(li); WinFormFun.LoadComboBox(cbxSWorkFolwDataTable, dt, "WorkFlowId", "FlowCaption"); WinFormFun.LoadComboBox(cbxTWorkFolwDataTable, dt, "WorkFlowId", "FlowCaption"); l = new ListItem("下拉并选中", "下拉并选中"); comboBox1.Items.Add(l); l = new ListItem("下拉不选中", "下拉不选中"); comboBox1.Items.Add(l); l = new ListItem("赋值", "赋值"); comboBox1.Items.Add(l); setComoboxFocusIndex(cbxSWorkFolwDataTable, rowData.slcid); setComoboxFocusIndex(cbxTWorkFolwDataTable, rowData.tlcid); if (strtype == "edit") { setComoboxFocusIndex(cbxSWorkFolwDataTable, rowData.slcid); setComoboxFocusIndex(cbxSWorkTastDataTable, rowData.slcjdid); setComoboxFocusIndex(cbxSWorkTastzdDataTable, rowData.slcjdzdid); tetSWorkSQL.Text = rowData.sSQL; setComoboxFocusIndex(comboBox1, rowData.cdfs); setComoboxFocusIndex(cbxTWorkFolwDataTable, rowData.tlcid); setComoboxFocusIndex(cbxTWorkTastDataTable, rowData.tlcjdid); setComoboxFocusIndex(cbxTWorkTastzdDataTable, rowData.tlcjdzdid); tetTWorkSQL.Text = rowData.tSQL; } }
private void cbxTWorkTastDataTable_SelectedIndexChanged(object sender, EventArgs e) { if (cbxTWorkTastDataTable.SelectedIndex < 1) return; ListItem l = new ListItem("###", "请选择"); cbxTWorkTastzdDataTable.Items.Clear(); cbxTWorkTastzdDataTable.Items.Add(l); WF_WorkTaskModle wtmtemp = MainHelper.PlatformSqlMap.GetOne<WF_WorkTaskModle> (string.Format(" where WorkTaskId='{0}'", ((ListItem)cbxTWorkTastDataTable.SelectedItem).ID)); mModule mu = MainHelper.PlatformSqlMap.GetOneByKey<mModule>(wtmtemp.Modu_ID); WF_WorkTaskControls wtc = MainHelper.PlatformSqlMap.GetOne<WF_WorkTaskControls> (string.Format(" where WorkTaskId='{0}' and ControlType='表单'", ((ListItem)cbxTWorkTastDataTable.SelectedItem).ID)); DataTable dt = null; if (mu.ModuTypes.ToLower() != "ebada.scgl.lcgl.frmlp") { string varDbTableName = ""; WF_WorkTaskModle wtm = MainHelper.PlatformSqlMap.GetOne<WF_WorkTaskModle> (string.Format(" where WorkTaskId='{0}'", ((ListItem)cbxTWorkTastDataTable.SelectedItem).ID)); if (wtm != null) { mModule obj = MainHelper.PlatformSqlMap.GetOneByKey<mModule>(wtm.Modu_ID); object fromCtrl = CreatNewMoldeIns(obj.AssemblyFileName, obj.ModuTypes, obj.MethodName, obj.ModuName); if (fromCtrl.GetType().GetProperty("VarDbTableName") != null && fromCtrl.GetType().GetProperty("VarDbTableName").GetValue(fromCtrl, null) != null) varDbTableName = fromCtrl.GetType().GetProperty("VarDbTableName").GetValue(fromCtrl, null).ToString(); string[] strli = varDbTableName.Split(','); IList tbli = new List<WF_WorkFlow>(); string strname = ""; foreach (string str in strli) { IList tbli2 = MainHelper.PlatformSqlMap.GetList("GetTableColumns", str); Assembly assembly = Assembly.LoadFile(AppDomain.CurrentDomain.BaseDirectory + "Ebada.Scgl.Model.dll"); Type tpe = assembly.GetType("Ebada.Scgl.Model." + str); foreach (WF_WorkFlow wf in tbli2) { strname=GetDisplayName(tpe, wf.Name); if (string.IsNullOrEmpty(strname)) continue; wf.WorkFlowId = str + " " + wf.Name; wf.Name = str + " " + strname; tbli.Add(wf); } } if (tbli.Count > 0) { dt = new DataTable(); dt = ConvertHelper.ToDataTable(tbli); rowData.tlcjdzdlx = "模块"; } } } else { IList lpli = MainHelper.PlatformSqlMap.GetList("SelectWF_TableUsedFieldList", string.Format(" where WorktaskId='{0}' and UserControlId='{1}' ", wtc.WorktaskId, wtc.UserControlId)); if (lpli.Count > 0) { dt = new DataTable(); dt = ConvertHelper.ToDataTable(lpli); rowData.tlcjdzdlx = "表单"; } } if (dt != null && (mu.ModuTypes.ToLower() != "ebada.scgl.lcgl.frmlp")) { WinFormFun.LoadComboBox(cbxTWorkTastzdDataTable, dt, "WorkFlowId", "Name"); cbxTWorkTastzdDataTable.SelectedIndex = 0; } else if (dt != null && (mu.ModuTypes.ToLower() == "ebada.scgl.lcgl.frmlp")) { rowData.tlcjdzdbid = ""; foreach (DataRow dr in dt.Rows) { if (rowData.tlcjdzdbid == "") rowData.tlcjdzdbid = dr["UserControlId"].ToString(); //dr["CellName"] = dr["SortID"] + " " + dr["CellName"]; break; } WinFormFun.LoadComboBox(cbxTWorkTastzdDataTable, dt, "FieldId", "FieldName"); cbxTWorkTastzdDataTable.SelectedIndex = 0; } else { cbxTWorkTastzdDataTable.SelectedIndex = 0; } }
private void cbxTWorkFolwDataTable_SelectedIndexChanged(object sender, EventArgs e) { if (cbxTWorkFolwDataTable.SelectedIndex < 1) return; ListItem l = new ListItem("###", "请选择"); cbxTWorkTastDataTable.Items.Clear(); cbxTWorkTastDataTable.Items.Add(l); IList li = MainHelper.PlatformSqlMap.GetList("SelectWF_WorkTaskList", "where WorkFlowId ='" + ((ListItem)cbxTWorkFolwDataTable.SelectedItem).ID + "' and TaskTypeId!='2' order by TaskTypeId"); DataTable dt = new DataTable(); if (li.Count > 0) dt = ConvertHelper.ToDataTable(li); wfhash.Clear(); for (int i = 0; i < li.Count; i++) { if (((WF_WorkTask)li[i]).TaskTypeId == "6") { GetTaskList(ref dt, ((WF_WorkTask)li[i]).WorkFlowId, ((WF_WorkTask)li[i]).WorkTaskId); // WF_SubWorkFlow sbf = MainHelper.PlatformSqlMap.GetOne<WF_SubWorkFlow> // (string.Format(" where WorkflowId='{0}' and WorkTaskId='{1}'", // ((WF_WorkTask)li[i]).WorkFlowId, ((WF_WorkTask)li[i]).WorkTaskId)); // IList<WF_WorkTask> wtli = MainHelper.PlatformSqlMap.GetList<WF_WorkTask>("SelectWF_WorkTaskList", //"where WorkFlowId ='" + ((WF_WorkTask)li[i]).WorkFlowId + "' and WorkTaskId='" //+ ((WF_WorkTask)li[i]).WorkTaskId + "' order by TaskTypeId"); // for (int j = 0; j < wtli.Count; j++) // { // DataRow dr = dt.NewRow(); // dt.Rows[j]["TaskCaption"] = dt.Rows[j]["TaskCaption"] + "-" + wtli[j].TaskCaption; // } } } DataRow[] rows = dt.Select("TaskTypeId='6'"); foreach (DataRow row in rows) { dt.Rows.Remove(row); } WinFormFun.LoadComboBox(cbxTWorkTastDataTable, dt, "WorkTaskId", "TaskCaption"); cbxTWorkTastDataTable.SelectedIndex = 0; if (((ListItem)cbxSWorkFolwDataTable.SelectedItem).ID != ((ListItem)cbxTWorkFolwDataTable.SelectedItem).ID) { cbxSWorkTastzdDataTable_SelectedIndexChanged(sender, e); } }
private void cbxSWorkFolwDataTable_SelectedIndexChanged(object sender, EventArgs e) { if (cbxSWorkFolwDataTable.SelectedIndex < 1) return; ListItem l = new ListItem("###", "请选择"); cbxSWorkTastDataTable.Items.Clear(); cbxSWorkTastDataTable.Items.Add(l); IList li = MainHelper.PlatformSqlMap.GetList("SelectWF_WorkTaskList", "where WorkFlowId ='" + ((ListItem)cbxSWorkFolwDataTable.SelectedItem).ID + "' and TaskTypeId!='2' order by TaskTypeId"); DataTable dt = new DataTable(); if (((ListItem)cbxSWorkFolwDataTable.SelectedItem).ID == "无") { li.Clear(); WF_WorkTask wt = new WF_WorkTask(); wt.WorkTaskId = "无"; wt.TaskCaption = "无"; li.Add(wt); } if (li.Count > 0) dt = ConvertHelper.ToDataTable(li); wfhash.Clear(); for (int i = 0; i < li.Count; i++) { if (((WF_WorkTask)li[i]).TaskTypeId == "6") GetTaskList(ref dt, ((WF_WorkTask)li[i]).WorkFlowId, ((WF_WorkTask)li[i]).WorkTaskId); } DataRow[] rows = dt.Select("TaskTypeId='6'"); foreach (DataRow row in rows) { dt.Rows.Remove(row); } WinFormFun.LoadComboBox(cbxSWorkTastDataTable, dt, "WorkTaskId", "TaskCaption"); cbxSWorkTastDataTable.SelectedIndex = 0; }
private void frmExcelEditSQLSet_Load(object sender, EventArgs e) { ListItem l = new ListItem("###", "请选择"); int i = 0; Hashtable hs = new Hashtable(); DataTable dt = new DataTable(); dt.Columns.Add("name", typeof(string)); DataRow dr = dt.NewRow(); dr["name"] = "###"; dt.Rows.Add(dr); hs.Add("###", "请选择"); IList<WF_WorkTask> litemp = MainHelper.PlatformSqlMap.GetList<WF_WorkTask>("SelectWF_WorkTaskList", "where WorkFlowId ='" + rowData["WorkFlowId"] + "' and TaskTypeId='1' order by TaskTypeId"); wfList.Clear(); foreach (WF_WorkTask wt in litemp) { dr = dt.NewRow(); dr["name"] = wt.WorkTaskId; dt.Rows.Add(dr); hs.Add(wt.WorkTaskId, wt.TaskCaption); GetNextTask(wt.WorkTaskId, wt.WorkFlowId, ref hs, ref dt); } string taskcaption = ""; for (i = 0; i < dt.Rows.Count; i++) { taskcaption = hs[dt.Rows[i]["name"]] as string; ListItem item = new ListItem(dt.Rows[i]["name"].ToString(), taskcaption); cbxSWorkTastDataTable.Items.Add(item); } cbxSWorkTastDataTable.SelectedIndex = 0; //dt = ConvertHelper.ToDataTable(li); //WinFormFun.LoadComboBox(cbxSWorkTastDataTable, dt, "WorkTaskId", "TaskCaption"); IList li = MainHelper.PlatformSqlMap.GetList("SelectOneStr", "select name as 'name' from sysobjects where xtype='U' or xtype='V' order by xtype ,name"); //dt = ConvertHelper.ToDataTable(li); dt = new DataTable(); dt.Columns.Add("name", typeof(string)); for (i = 0; i < li.Count; i++) { dr = dt.NewRow(); dr["name"] = li[i]; dt.Rows.Add(dr); } WinFormFun.LoadComboBox(cbxSWorkTastzdDataTable, dt, "name", "name"); if (strtype == "edit") { setComoboxFocusIndex(cbxSWorkTastDataTable, rowData["WorkTaskId"].ToString()); setComoboxFocusIndex(cbxSWorkTastzdDataTable, rowData["VarName"].ToString()); tetSWorkSQL.Text = rowData["InitValue"].ToString(); } }
private void iniBindTask() { Hashtable hs = new Hashtable(); GetPreviousTask(NowTask.TaskId, NowTask.WorkFlowId, ref hs); ArrayList akeys=new ArrayList(hs.Keys); string taskcaption = ""; for (int i = 0; i < akeys.Count; i++) { taskcaption= hs[akeys[i]] as string; ListItem item = new ListItem(akeys[i].ToString(),taskcaption); comTaskboBox.Items.Add(item); } if (comTaskboBox.Items.Count > 0) comTaskboBox.SelectedIndex = 0; DataTable binddt = WorkFlowTask.GetTaskBindTaskContent(NowTask.TaskId); if (binddt.Rows.Count > 0) { WF_WorkTask wt = MainHelper.PlatformSqlMap.GetOneByKey<WF_WorkTask>(binddt.Rows[0]["UserControlId"]); if (wt != null) { comTaskboBox.Text = wt.TaskCaption; for (int i = 0; i < comTaskboBox.Items.Count;i++ ) { ListItem item =comTaskboBox.Items[i] as ListItem; if (item.ID==wt.WorkTaskId) { comTaskboBox.SelectedIndex = i; comTaskboBox.SelectedItem = item; break; } } } } }