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