protected void Page_Load(object sender, EventArgs e)
{
PushMsgs msgs = new PushMsgs(this.FK_Flow);
var msg = msgs.GetEntityByKey(PushMsgAttr.FK_Event, this.Event, PushMsgAttr.FK_Node, int.Parse(this.NodeID)) as PushMsg;
if (msg == null)
{
msg = new PushMsg();
msg.FK_Event = this.Event;
msg.FK_Node = int.Parse(this.NodeID);
}
if (!string.IsNullOrWhiteSpace(this.ThePushWay))
{
if (this.ThePushWay != msg.PushWay.ToString())
{
msg.PushDoc = string.Empty;
msg.Tag = string.Empty;
}
msg.PushWay = int.Parse(this.ThePushWay);
}
this.Pub1.AddTable("class='Table' cellspacing='1' cellpadding='1' border='1' style='width:100%'");
this.Pub1.AddTR();
this.Pub1.AddTD("style='width:100px'", "推送设置方式：");
var ddl = new DDL();
ddl.BindSysEnum(PushMsgAttr.PushWay);
ddl.ID = "DDL_" + PushMsgAttr.PushWay;
ddl.SetSelectItem((int)msg.PushWay);
ddl.AutoPostBack = true;
ddl.SelectedIndexChanged += new EventHandler(ddl_SelectedIndexChanged);
this.Pub1.AddTD(ddl);
this.Pub1.AddTREnd();
switch ((PushWay)msg.PushWay)
{
case PushWay.ByParas:
#region 照系统指定参数
Pub1.AddTR();
Pub1.AddTD("输入参数名：");
Pub1.AddTDBegin();
var rad = new RadioBtn();
rad.GroupName = "Para";
rad.ID = "RB_0";
rad.Text = "系统参数";
rad.Checked = msg.PushDoc == "0";
Pub1.Add(rad);
var tb = new TB();
tb.ID = "TB_" + PushMsgAttr.Tag;
if (msg.PushDoc == "0")
{
tb.Text = msg.Tag;
}
else
{
tb.Text = "NoticeTo";
}
Pub1.Add(tb);
Pub1.Add(" 默认为NoticeTo");
Pub1.AddBR();
rad = new RadioBtn();
rad.GroupName = "Para";
rad.ID = "RB_1";
rad.Text = "表单字段参数";
rad.Checked = msg.PushDoc == "1";
Pub1.Add(rad);
MapAttrs attrs = new MapAttrs();
attrs.Retrieve(MapAttrAttr.FK_MapData, "ND" + this.NodeID);
MapAttrs attrNs = new MapAttrs();
foreach (MapAttr attr in attrs)
{
if (attr.IsBigDoc)
{
continue;
}
switch (attr.KeyOfEn)
{
case "Title":
case "FK_Emp":
case "MyNum":
case "FK_NY":
case WorkAttr.Emps:
case WorkAttr.OID:
case StartWorkAttr.Rec:
case StartWorkAttr.FID:
continue;
default:
break;
}
attrNs.AddEntity(attr);
}
ddl = new DDL();
ddl.ID = "DDL_" + PushMsgAttr.Tag;
ddl.BindEntities(attrNs, MapAttrAttr.MyPK, MapAttrAttr.Name);
ddl.AutoPostBack = false;
if (msg.PushDoc == "1")
{
ddl.SetSelectItem(msg.Tag);
}
Pub1.Add(ddl);
Pub1.AddTREnd();
#endregion
break;
case PushWay.NodeWorker:
#region 照指定结点的工作人员
Pub1.AddTR();
Pub1.AddTDBegin("colspan='2'");
Pub1.Add("请选择要推送到的节点工作人员：<br />");
Nodes nds = new Nodes(this.FK_Flow);
CheckBox cb = null;
foreach (BP.WF.Node nd in nds)
{
if (nd.NodeID == int.Parse(this.NodeID))
{
continue;
}
cb = new CheckBox();
cb.ID = "CB_" + nd.NodeID;
cb.Text = nd.NodeID + " " + nd.Name;
cb.Checked = msg.PushDoc.Contains("@" + nd.NodeID + "@");
Pub1.Add(cb);
Pub1.AddBR();
}
Pub1.AddTDEnd();
Pub1.AddTREnd();
#endregion
break;
case PushWay.SpecDepts:
#region 照指定的部门
Pub1.AddTR();
Pub1.AddTDBegin("colspan='2'");
this.Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'");
this.Pub1.AddTR();
this.Pub1.AddTD("colspan='3' class='GroupTitle'", "部门选择");
this.Pub1.AddTREnd();
//NodeDepts ndepts = new NodeDepts(int.Parse(this.NodeID));
Depts depts = new Depts();
depts.RetrieveAll();
int i = 0;
//foreach (NodeDept dept in ndepts)
foreach (Dept dept in depts)
{
i++;
if (i == 4)
{
i = 1;
}
if (i == 1)
{
Pub1.AddTR();
}
cb = new CheckBox();
//cb.ID = "CB_" + dept.FK_Dept;
//cb.Text = (depts.GetEntityByKey(dept.FK_Dept) as Dept).Name;
cb.ID = "CB_" + dept.No;
cb.Text = dept.Name;
//if (msg.PushDoc.Contains("@" + dept.FK_Dept + "@"))
if (msg.PushDoc.Contains("@" + dept.No + "@"))
{
cb.Checked = true;
}
this.Pub1.AddTD(cb);
if (i == 3)
{
Pub1.AddTREnd();
}
}
switch (i)
{
case 1:
Pub1.AddTD();
Pub1.AddTD();
Pub1.AddTREnd();
break;
case 2:
Pub1.AddTD();
Pub1.AddTREnd();
break;
default:
break;
}
this.Pub1.AddTableEnd();
Pub1.AddTDEnd();
Pub1.AddTREnd();
#endregion
break;
case PushWay.SpecEmps:
#region 照指定的人员
Pub1.AddTR();
//Pub1.AddTDBegin("colspan='2'");
Pub1.AddTD("选择人员：");
Pub1.AddTDBegin();
tb = new TB();
tb.ID = "TB_Users";
tb.TextMode = TextBoxMode.MultiLine;
tb.Style.Add("width", "99%");
tb.Rows = 4;
tb.ReadOnly = true;
var hf = new HiddenField();
hf.ID = "HID_Users";
//加载已经选择的人员
if (!string.IsNullOrWhiteSpace(msg.PushDoc))
{
hf.Value = msg.PushDoc.Replace("@@", ",").Trim('@');
var emps = new Emps();
emps.RetrieveAll();
tb.Text =
hf.Value.Split(',').Select(o => (emps.GetEntityByKey(o) as Emp).Name).Aggregate(
string.Empty, (curr, next) => curr + next + ",").TrimEnd(',');
}
Pub1.Add(tb);
Pub1.Add(hf);
Pub1.AddBR();
Pub1.AddBR();
Pub1.Add(
"<a class='easyui-linkbutton' data-options=\"iconCls:'icon-user'\" href='javascript:void(0)' onclick=\"showWin('../Comm/Port/SelectUser_Jq.aspx','" +
tb.ClientID + "','" + hf.ClientID + "');\">选择人员...</a>");
Pub1.AddTDEnd();
//Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'");
//depts = new Depts();
//depts.RetrieveAll();
//var emps = new Emps();
//emps.RetrieveAll();
//var empDepts = new EmpDepts();
//empDepts.RetrieveAll();
//var nemps = new NodeEmps(int.Parse(this.NodeID));
//Emp emp = null;
//foreach (Dept dept in depts)
//{
// this.Pub1.AddTR();
// var mycb = new CheckBox();
// mycb.Text = dept.Name;
// mycb.ID = "CB_D_" + dept.No;
// this.Pub1.AddTD("colspan='3' class='GroupTitle'", mycb);
// this.Pub1.AddTREnd();
// i = 0;
// string ctlIDs = "";
// foreach (EmpDept ed in empDepts)
// {
// if (ed.FK_Dept != dept.No)
// continue;
// //排除非当前结点绑定的人员
// if (nemps.GetEntityByKey(NodeEmpAttr.FK_Emp, ed.FK_Emp) == null)
// continue;
// i++;
// if (i == 4)
// i = 1;
// if (i == 1)
// Pub1.AddTR();
// emp = emps.GetEntityByKey(ed.FK_Emp) as Emp;
// cb = new CheckBox();
// cb.ID = "CB_E_" + emp.No;
// ctlIDs += cb.ID + ",";
// cb.Text = emp.Name;
// if (msg.PushDoc.Contains("@" + emp.No + "@"))
// cb.Checked = true;
// Pub1.AddTD(cb);
// if (i == 3)
// Pub1.AddTREnd();
// }
// mycb.Attributes["onclick"] = "SetSelected(this,'" + ctlIDs + "')";
// switch (i)
// {
// case 1:
// Pub1.AddTD();
// Pub1.AddTD();
// Pub1.AddTREnd();
// break;
// case 2:
// Pub1.AddTD();
// Pub1.AddTREnd();
// break;
// default:
// break;
// }
//}
//Pub1.AddTableEnd();
//Pub1.AddTDEnd();
Pub1.AddTREnd();
#endregion
break;
case PushWay.SpecSQL:
#region 照指定的SQL查询语句
Pub1.AddTR();
this.Pub1.AddTDBegin("colspan='2'");
this.Pub1.Add("SQL查询语句：<br />");
tb = new TB();
tb.ID = "TB_" + PushMsgAttr.PushDoc;
tb.Columns = 50;
tb.Style.Add("width", "99%");
tb.TextMode = TextBoxMode.MultiLine;
tb.Rows = 4;
tb.Text = msg.PushDoc;
this.Pub1.Add(tb);
this.Pub1.AddTDEnd();
Pub1.AddTREnd();
#endregion
break;
case PushWay.SpecStations:
#region 照指定的岗位
Pub1.AddTR();
Pub1.AddTDBegin("colspan='2'");
if (BP.WF.Glo.OSModel == OSModel.WorkFlow)
{
SysEnums ses = new SysEnums("StaGrade");
Stations sts = new Stations();
sts.RetrieveAll();
string sql = "SELECT No,Name FROM Port_Station WHERE StaGrade NOT IN (SELECT IntKey FROM Sys_Enum WHERE EnumKey='StaGrade')";
DataTable dt = DBAccess.RunSQLReturnTable(sql);
if (dt.Rows.Count != 0)
{
if (ses.Count == 0)
{
SysEnum se = new SysEnum();
se.EnumKey = "StaGrade";
se.Lab = "普通岗";
se.IntKey = 0;
se.Insert();
ses.AddEntity(se);
}
foreach (Station st in sts)
{
st.StaGrade = 0;
st.Save();
}
}
this.Pub1.AddTable("class='Table' cellSpacing='0' cellPadding='0' border='0' style='width:100%'");
foreach (SysEnum se in ses)
{
this.Pub1.AddTR();
CheckBox mycb = new CheckBox();
mycb.Text = se.Lab;
mycb.ID = "CB_SG_" + se.IntKey;
this.Pub1.AddTD("colspan='3' class='GroupTitle'", mycb);
this.Pub1.AddTREnd();
i = 0;
string ctlIDs = "";
foreach (Station st in sts)
{
if (st.StaGrade != se.IntKey)
{
continue;
}
i++;
if (i == 4)
{
i = 1;
}
if (i == 1)
{
Pub1.AddTR();
}
cb = new CheckBox();
cb.ID = "CB_S_" + st.No;
ctlIDs += cb.ID + ",";
cb.Text = st.Name;
if (msg.PushDoc.Contains("@" + st.No + "@"))
{
cb.Checked = true;
}
Pub1.AddTD(cb);
if (i == 3)
{
Pub1.AddTREnd();
}
}
mycb.Attributes["onclick"] = "SetSelected(this,'" + ctlIDs + "')";
switch (i)
{
case 1:
Pub1.AddTD();
Pub1.AddTD();
Pub1.AddTREnd();
break;
case 2:
Pub1.AddTD();
Pub1.AddTREnd();
break;
default:
break;
}
}
this.Pub1.AddTableEnd();
}
else
{
/*BPM 模式*/
BP.GPM.StationTypes tps = new BP.GPM.StationTypes();
tps.RetrieveAll();
BP.GPM.Stations sts = new BP.GPM.Stations();
sts.RetrieveAll();
string sql = "SELECT No,Name FROM Port_Station WHERE FK_StationType NOT IN (SELECT No FROM Port_StationType)";
DataTable dt = DBAccess.RunSQLReturnTable(sql);
if (dt.Rows.Count != 0)
{
if (tps.Count == 0)
{
var stp = new BP.GPM.StationType {
No = "01", Name = "普通岗"
};
stp.Save();
tps.AddEntity(stp);
}
//更新所有对不上岗位类型的岗位，岗位类型为01或第一个
foreach (BP.GPM.Station st in sts)
{
st.FK_StationType = tps[0].No;
st.Update();
}
}
this.Pub1.AddTable("class='Table' cellSpacing='0' cellPadding='0' border='0' style='width:100%'");
foreach (BP.GPM.StationType tp in tps)
{
this.Pub1.AddTR();
CheckBox mycb = new CheckBox();
mycb.Text = tp.Name;
mycb.ID = "CB_ST_" + tp.No;
this.Pub1.AddTD("colspan='3' class='GroupTitle'", mycb);
this.Pub1.AddTREnd();
i = 0;
string ctlIDs = "";
foreach (BP.GPM.Station st in sts)
{
if (st.FK_StationType != tp.No)
{
continue;
}
i++;
if (i == 4)
{
i = 1;
}
if (i == 1)
{
Pub1.AddTR();
}
cb = new CheckBox();
cb.ID = "CB_S_" + st.No;
ctlIDs += cb.ID + ",";
cb.Text = st.Name;
if (msg.PushDoc.Contains("@" + st.No + "@"))
{
cb.Checked = true;
}
this.Pub1.AddTD(cb);
if (i == 3)
{
Pub1.AddTREnd();
}
}
mycb.Attributes["onclick"] = "SetSelected(this,'" + ctlIDs + "')";
switch (i)
{
case 1:
Pub1.AddTD();
Pub1.AddTD();
Pub1.AddTREnd();
break;
case 2:
Pub1.AddTD();
Pub1.AddTREnd();
break;
default:
break;
}
}
this.Pub1.AddTableEnd();
}
#region 原逻辑，只考虑了一种模式，停用
//Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'");
//SysEnums ses = new SysEnums("StaGrade");
//Stations sts = new Stations();
//NodeStations nsts = new NodeStations(int.Parse(this.NodeID));
//sts.RetrieveAll();
//foreach (SysEnum se in ses)
//{
// this.Pub1.AddTR();
// var mycb = new CheckBox();
// mycb.Text = se.Lab;
// mycb.ID = "CB_SG_" + se.IntKey;
// this.Pub1.AddTD("colspan=3 class='GroupTitle'", mycb);
// this.Pub1.AddTREnd();
// i = 0;
// string ctlIDs = "";
// foreach (Station st in sts)
// {
// if (st.StaGrade != se.IntKey)
// continue;
// //排除非当前结点的岗位
// if (nsts.GetEntityByKey(NodeStationAttr.FK_Station, st.No) == null)
// continue;
// i++;
// if (i == 4)
// i = 1;
// if (i == 1)
// Pub1.AddTR();
// cb = new CheckBox();
// cb.ID = "CB_S_" + st.No;
// ctlIDs += cb.ID + ",";
// cb.Text = st.Name;
// if (msg.PushDoc.Contains("@" + st.No + "@"))
// cb.Checked = true;
// Pub1.AddTD(cb);
// if (i == 3)
// Pub1.AddTREnd();
// }
// mycb.Attributes["onclick"] = "SetSelected(this,'" + ctlIDs + "')";
// switch (i)
// {
// case 1:
// Pub1.AddTD();
// Pub1.AddTD();
// Pub1.AddTREnd();
// break;
// case 2:
// Pub1.AddTD();
// Pub1.AddTREnd();
// break;
// default:
// break;
// }
//}
//Pub1.AddTableEnd();
#endregion
Pub1.AddTDEnd();
Pub1.AddTREnd();
#endregion
break;
}
Pub1.AddTableEnd();
Pub1.AddBR();
Pub1.AddSpace(1);
var btn = new LinkBtn(false, NamesOfBtn.Save, "保存");
btn.Click += new EventHandler(btn_Click);
Pub1.Add(btn);
if (!string.IsNullOrWhiteSpace(msg.MyPK))
{
Pub1.AddSpace(1);
btn = new LinkBtn(false, NamesOfBtn.Delete, "删除");
btn.Click += new EventHandler(btn_Delete_Click);
btn.Attributes["onclick"] = "return confirm('你确定要删除此消息推送设置吗？');";
Pub1.Add(btn);
}
}
public void BindCond()
{
Cond cond = new Cond();
cond.MyPK = this.GenerMyPK;
cond.RetrieveFromDBSources();
/*BPM 模式*/
BP.GPM.StationTypes tps = new BP.GPM.StationTypes();
tps.RetrieveAll();
BP.GPM.Stations sts = new BP.GPM.Stations();
sts.RetrieveAll();
string sql = "SELECT No,Name FROM Port_Station WHERE FK_StationType NOT IN (SELECT No FROM Port_StationType)";
DataTable dt = DBAccess.RunSQLReturnTable(sql);
if (dt.Rows.Count != 0)
{
if (tps.Count == 0)
{
var stp = new BP.GPM.StationType {
No = "01", Name = "普通岗"
};
stp.Save();
tps.AddEntity(stp);
}
//更新所有对不上岗位类型的岗位，岗位类型为01或第一个
foreach (BP.GPM.Station st in sts)
{
st.FK_StationType = tps[0].No;
st.Update();
}
}
this.Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'");
foreach (BP.GPM.StationType tp in tps)
{
this.Pub1.AddTR();
CheckBox mycb = new CheckBox();
mycb.Text = tp.Name;
mycb.ID = "CB_s_d" + tp.No;
this.Pub1.AddTD("colspan=3 class='GroupTitle'", mycb);
this.Pub1.AddTREnd();
int i = 0;
string ctlIDs = "";
foreach (BP.GPM.Station st in sts)
{
if (st.FK_StationType != tp.No)
{
continue;
}
i++;
if (i == 4)
{
i = 1;
}
if (i == 1)
{
Pub1.AddTR();
}
CheckBox cb = new CheckBox();
cb.ID = "CB_" + st.No;
ctlIDs += cb.ID + ",";
cb.Text = st.Name;
if (cond.OperatorValue.ToString().Contains("@" + st.No + "@"))
{
cb.Checked = true;
}
this.Pub1.AddTD(cb);
if (i == 3)
{
Pub1.AddTREnd();
}
}
mycb.Attributes["onclick"] = "SetSelected(this,'" + ctlIDs + "')";
switch (i)
{
case 1:
Pub1.AddTD();
Pub1.AddTD();
Pub1.AddTREnd();
break;
case 2:
Pub1.AddTD();
Pub1.AddTREnd();
break;
default:
break;
}
}
this.Pub1.AddTableEnd();
Pub1.AddBR();
#region //增加“指定的操作员”选项，added by liuxc,2015-10-7
var ddl = new DDL();
ddl.ID = "DDL_" + CondAttr.SpecOperWay;
ddl.Width = 200;
ddl.Items.Add(new ListItem("当前操作员", "0"));
ddl.Items.Add(new ListItem("指定节点的操作员", "1"));
ddl.Items.Add(new ListItem("指定表单字段作为操作员", "2"));
ddl.Items.Add(new ListItem("指定操作员编号", "3"));
ddl.SetSelectItem((int)cond.SpecOperWay);
ddl.AutoPostBack = true;
ddl.SelectedIndexChanged += new EventHandler(ddl_SelectedIndexChanged);
Pub1.Add("指定的操作员：");
Pub1.Add(ddl);
Pub1.AddBR();
Pub1.AddBR();
var lbl = new Label();
lbl.ID = "LBL1";
switch (cond.SpecOperWay)
{
case SpecOperWay.SpecNodeOper:
lbl.Text = "节点编号：";
break;
case SpecOperWay.SpecSheetField:
lbl.Text = "表单字段：";
break;
case SpecOperWay.SpenEmpNo:
lbl.Text = "操作员编号：";
break;
case SpecOperWay.CurrOper:
lbl.Text = "参数：";
break;
}
Pub1.Add(lbl);
var tb = new TB();
tb.ID = "TB_" + CondAttr.SpecOperPara;
tb.Width = 200;
tb.Text = cond.SpecOperPara;
tb.Enabled = cond.SpecOperWay != SpecOperWay.CurrOper;
Pub1.Add(tb);
Pub1.AddSpace(1);
Pub1.Add("多个值请用英文“逗号”来分隔。");
Pub1.AddBR();
Pub1.AddBR();
#endregion
Pub1.AddSpace(1);
var btn = new LinkBtn(false, NamesOfBtn.Save, "保存");
btn.Click += new EventHandler(btn_Save_Click);
this.Pub1.Add(btn);
Pub1.AddSpace(1);
btn = new LinkBtn(false, NamesOfBtn.Delete, "删除");
btn.Attributes["onclick"] = " return confirm('您确定要删除吗？');";
btn.Click += new EventHandler(btn_Save_Click);
this.Pub1.Add(btn);
}
public void BindCond()
{
Cond cond = new Cond();
cond.MyPK = this.GenerMyPK;
cond.RetrieveFromDBSources();
BP.WF.Node nd = new BP.WF.Node(this.FK_MainNode);
BP.WF.Node tond = new BP.WF.Node(this.ToNodeID);
this.Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'");
this.Pub1.AddTR();
this.Pub1.AddTD("colspan=3 class='GroupTitle'", "部门选择");
this.Pub1.AddTREnd();
Depts sts = new Depts();
sts.RetrieveAllFromDBSource();
int i = 0;
foreach (Dept st in sts)
{
i++;
if (i == 4)
{
i = 1;
}
if (i == 1)
{
Pub1.AddTR();
}
CheckBox cb = new CheckBox();
cb.ID = "CB_" + st.No;
cb.Text = st.Name;
if (cond.OperatorValue.ToString().Contains("@" + st.No + "@"))
{
cb.Checked = true;
}
this.Pub1.AddTD(cb);
if (i == 3)
{
Pub1.AddTREnd();
}
}
switch (i)
{
case 1:
Pub1.AddTD();
Pub1.AddTD();
Pub1.AddTREnd();
break;
case 2:
Pub1.AddTD();
Pub1.AddTREnd();
break;
default:
break;
}
this.Pub1.AddTableEnd();
Pub1.AddBR();
Pub1.AddSpace(1);
var btn = new LinkBtn(false, NamesOfBtn.Save, "保存");
btn.Click += new EventHandler(btn_Save_Click);
this.Pub1.Add(btn);
Pub1.AddSpace(1);
btn = new LinkBtn(false, NamesOfBtn.Delete, "删除");
btn.Attributes["onclick"] = " return confirm('您确定要删除吗？');";
btn.Click += new EventHandler(btn_Save_Click);
this.Pub1.Add(btn);
}
public void BindCond()
{
string msg = "";
string note = "";
Cond cond = new Cond();
cond.MyPK = this.GenerMyPK;
cond.RetrieveFromDBSources();
if (BP.WF.Glo.OSModel == OSModel.WorkFlow)
{
SysEnums ses = new SysEnums("StaGrade");
Stations sts = new Stations();
sts.RetrieveAll();
string sql = "SELECT No,Name FROM Port_Station WHERE StaGrade NOT IN (SELECT IntKey FROM Sys_Enum WHERE EnumKey='StaGrade')";
DataTable dt = DBAccess.RunSQLReturnTable(sql);
if (dt.Rows.Count != 0)
{
if (ses.Count == 0)
{
SysEnum se = new SysEnum();
se.EnumKey = "StaGrade";
se.Lab = "普通岗";
se.IntKey = 0;
se.Insert();
ses.AddEntity(se);
}
foreach (Station st in sts)
{
st.StaGrade = 0;
st.Save();
}
//Pub1.AddEasyUiPanelInfo("错误",
// "在ccflow的集成工作模式下,岗位表集成或者维护错误,有" + dt.Rows.Count +
// "个岗位枚举值对应不上:<br />{技术信息:排查的sql:" + sql + "}", "icon-no");
//return;
}
this.Pub1.AddTable("class='Table' cellSpacing='0' cellPadding='0' border='0' style='width:100%'");
foreach (SysEnum se in ses)
{
this.Pub1.AddTR();
CheckBox mycb = new CheckBox();
mycb.Text = se.Lab;
mycb.ID = "CB_s_d" + se.IntKey;
this.Pub1.AddTD("colspan=3 class='GroupTitle'", mycb);
this.Pub1.AddTREnd();
int i = 0;
string ctlIDs = "";
foreach (Station st in sts)
{
if (st.StaGrade != se.IntKey)
{
continue;
}
i++;
if (i == 4)
{
i = 1;
}
if (i == 1)
{
Pub1.AddTR();
}
CheckBox cb = new CheckBox();
cb.ID = "CB_" + st.No;
ctlIDs += cb.ID + ",";
cb.Text = st.Name;
if (cond.OperatorValue.ToString().Contains("@" + st.No + "@"))
{
cb.Checked = true;
}
Pub1.AddTD(cb);
if (i == 3)
{
Pub1.AddTREnd();
}
}
mycb.Attributes["onclick"] = "SetSelected(this,'" + ctlIDs + "')";
switch (i)
{
case 1:
Pub1.AddTD();
Pub1.AddTD();
Pub1.AddTREnd();
break;
case 2:
Pub1.AddTD();
Pub1.AddTREnd();
break;
default:
break;
}
}
}
else
{
/*BPM 模式*/
BP.GPM.StationTypes tps = new BP.GPM.StationTypes();
tps.RetrieveAll();
BP.GPM.Stations sts = new BP.GPM.Stations();
sts.RetrieveAll();
string sql = "SELECT No,Name FROM Port_Station WHERE FK_StationType NOT IN (SELECT No FROM Port_StationType)";
DataTable dt = DBAccess.RunSQLReturnTable(sql);
if (dt.Rows.Count != 0)
{
if (tps.Count == 0)
{
var stp = new BP.GPM.StationType {
No = "01", Name = "普通岗"
};
stp.Save();
tps.AddEntity(stp);
}
//更新所有对不上岗位类型的岗位，岗位类型为01或第一个
foreach (BP.GPM.Station st in sts)
{
st.FK_StationType = tps[0].No;
st.Update();
}
//Pub1.AddEasyUiPanelInfo("错误",
// "在ccflow的集成工作模式下,岗位表集成或者维护错误,有" + dt.Rows.Count +
// "个岗位外键对应不上:<br />{技术信息:排查的sql:" + sql + "}", "icon-no");
//return;
}
this.Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'");
foreach (BP.GPM.StationType tp in tps)
{
this.Pub1.AddTR();
CheckBox mycb = new CheckBox();
mycb.Text = tp.Name;
mycb.ID = "CB_s_d" + tp.No;
this.Pub1.AddTD("colspan=3 class='GroupTitle'", mycb);
this.Pub1.AddTREnd();
int i = 0;
string ctlIDs = "";
foreach (BP.GPM.Station st in sts)
{
if (st.FK_StationType != tp.No)
{
continue;
}
i++;
if (i == 4)
{
i = 1;
}
if (i == 1)
{
Pub1.AddTR();
}
CheckBox cb = new CheckBox();
cb.ID = "CB_" + st.No;
ctlIDs += cb.ID + ",";
cb.Text = st.Name;
if (cond.OperatorValue.ToString().Contains("@" + st.No + "@"))
{
cb.Checked = true;
}
this.Pub1.AddTD(cb);
if (i == 3)
{
Pub1.AddTREnd();
}
}
mycb.Attributes["onclick"] = "SetSelected(this,'" + ctlIDs + "')";
switch (i)
{
case 1:
Pub1.AddTD();
Pub1.AddTD();
Pub1.AddTREnd();
break;
case 2:
Pub1.AddTD();
Pub1.AddTREnd();
break;
default:
break;
}
}
}
this.Pub1.AddTableEnd();
Pub1.AddBR();
Pub1.AddSpace(1);
var btn = new LinkBtn(false, NamesOfBtn.Save, "保存");
btn.Click += new EventHandler(btn_Save_Click);
this.Pub1.Add(btn);
Pub1.AddSpace(1);
btn = new LinkBtn(false, NamesOfBtn.Delete, "删除");
btn.Attributes["onclick"] = " return confirm('您确定要删除吗？');";
btn.Click += new EventHandler(btn_Save_Click);
this.Pub1.Add(btn);
}
protected void Page_Load(object sender, EventArgs e)
{
#region Step = 1
if (this.Step == 1)
{
BP.Sys.SFDBSrcs ens = new BP.Sys.SFDBSrcs();
ens.RetrieveAll();
Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'");
Pub1.AddTR();
Pub1.AddTDGroupTitle("", "第1步：请选择数据源");
Pub1.AddTREnd();
Pub1.AddTR();
Pub1.AddTDBegin();
Pub1.AddUL("class='navlist'");
Pub1.AddLi("<div><a href='SFGuide.aspx?Step=12&FK_SFDBsrc=local'><img src='../../Img/New.gif' align='middle' /><span>创建本地编码字典表</span></a></div>");
foreach (BP.Sys.SFDBSrc item in ens)
{
Pub1.AddLi("<div><a href='SFGuide.aspx?Step=2&FK_SFDBSrc=" + item.No + "'><span class='nav'>" + item.No + " - " + item.Name + "</span></a></div>");
}
Pub1.AddLi("<div><a href=\"javascript:WinOpen('../RefFunc/UIEn.aspx?EnsName=BP.Sys.SFDBSrcs')\" ><img src='../../Img/New.gif' align='middle' /><span class='nav'>新建数据源</span></a></div>");
Pub1.AddULEnd();
Pub1.AddTDEnd();
Pub1.AddTREnd();
Pub1.AddTableEnd();
}
#endregion
#region Step = 2
if (this.Step == 2)
{
SFDBSrc src = new SFDBSrc(this.FK_SFDBSrc);
Pub1.Add("<div class='easyui-layout' data-options=\"fit:true\">");
Pub1.Add(string.Format("<div data-options=\"region:'west',split:true,title:'选择 {0} 表/视图'\" style='width:200px;'>",
src.No));
var lb = new LB();
lb.ID = "LB_Table";
lb.BindByTableNoName(src.GetTables());
lb.Style.Add("width", "100%");
lb.Style.Add("height", "100%");
lb.AutoPostBack = true;
lb.SelectedIndexChanged += new EventHandler(lb_SelectedIndexChanged);
Pub1.Add(lb);
Pub1.AddDivEnd();
Pub1.Add("<div data-options=\"region:'center',title:'第2步：请填写基础信息'\" style='padding:5px;'>");
Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'");
var dbType = src.DBSrcType;
if (dbType == DBSrcType.Localhost)
{
switch (SystemConfig.AppCenterDBType)
{
case DBType.MSSQL:
dbType = DBSrcType.SQLServer;
break;
case DBType.Oracle:
dbType = DBSrcType.Oracle;
break;
case DBType.MySQL:
dbType = DBSrcType.MySQL;
break;
case DBType.Informix:
dbType = DBSrcType.Infomax;
break;
default:
throw new Exception("没有涉及到的连接测试类型...");
}
}
var islocal = (src.DBSrcType == DBSrcType.Localhost).ToString().ToLower();
Pub1.AddTR();
Pub1.AddTDGroupTitle("style='width:100px'", "值(编号)：");
var ddl = new DDL();
ddl.ID = "DDL_ColValue";
ddl.Attributes.Add("onchange", string.Format("generateSQL('{0}','{1}','{2}',{3})", src.No, src.DBName, dbType, islocal));
Pub1.AddTDBegin();
Pub1.Add(ddl);
Pub1.Add(" 编号列，比如：类别编号");
Pub1.AddTDEnd();
Pub1.AddTREnd();
Pub1.AddTR();
Pub1.AddTDGroupTitle("标签(名称)：");
ddl = new DDL();
ddl.ID = "DDL_ColText";
ddl.Attributes.Add("onchange", string.Format("generateSQL('{0}','{1}','{2}',{3})", src.No, src.DBName, dbType, islocal));
Pub1.AddTDBegin();
Pub1.Add(ddl);
Pub1.Add(" 显示的列，比如：类别名称");
Pub1.AddTDEnd();
Pub1.AddTREnd();
Pub1.AddTR();
Pub1.AddTDGroupTitle("父结点值(字段)：");
ddl = new DDL();
ddl.ID = "DDL_ColParentNo";
ddl.Attributes.Add("onchange", string.Format("generateSQL('{0}','{1}','{2}',{3})", src.No, src.DBName, dbType, islocal));
Pub1.AddTDBegin();
Pub1.Add(ddl);
Pub1.Add(" 如果是树类型实体，该列设置有效，比如：上级类别编号");
Pub1.AddTDEnd();
Pub1.AddTREnd();
Pub1.AddTR();
Pub1.AddTDGroupTitle("字典表类型：");
ddl = new DDL();
ddl.ID = "DDL_SFTableType";
ddl.SelfBindSysEnum(SFTableAttr.SFTableType);
ddl.Attributes.Add("onchange", string.Format("generateSQL('{0}','{1}','{2}',{3})", src.No, src.DBName, dbType, islocal));
Pub1.AddTD(ddl);
Pub1.AddTREnd();
Pub1.AddTR();
Pub1.AddTDGroupTitle("查询语句：");
var tb = new TB();
tb.ID = "TB_SelectStatement";
tb.TextMode = TextBoxMode.MultiLine;
tb.Columns = 60;
tb.Rows = 10;
tb.Style.Add("width", "99%");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add("<br /> 说明：查询语句可以修改，但请保证查询语句的准确性及有效性！");
Pub1.AddTDEnd();
Pub1.AddTREnd();
Pub1.AddTableEnd();
Pub1.AddBR();
Pub1.AddBR();
Pub1.AddSpace(1);
var btn = new LinkBtn(false, NamesOfBtn.Next, "下一步");
btn.Click += new EventHandler(btn_Click);
Pub1.Add(btn);
Pub1.AddSpace(1);
Pub1.Add("<a href='" + Request.UrlReferrer + "' class='easyui-linkbutton'>上一步</a>");
Pub1.AddDivEnd();
Pub1.AddDivEnd();
if (!IsPostBack && lb.Items.Count > 0)
{
lb.SelectedIndex = 0;
ShowSelectedTableColumns();
}
}
#endregion
#region Step = 12
if (this.Step == 12)
{
Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'");
Pub1.AddTR();
Pub1.AddTDGroupTitle("colspan='2'", "第2步：创建");
Pub1.AddTREnd();
TextBox tb = new TextBox();
tb.ID = "TB_No";
Pub1.AddTR();
Pub1.AddTDGroupTitle("style='width:100px'", "表英文名称：");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add(" 必须以字母或者下画线开头");
Pub1.AddTDEnd();
Pub1.AddTREnd();
tb = new TextBox();
tb.ID = "TB_" + SFTableAttr.Name;
Pub1.AddTR();
Pub1.AddTDGroupTitle("", "表中文名称：");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add(" 显示的标签");
Pub1.AddTDEnd();
Pub1.AddTREnd();
tb = new TextBox();
tb.ID = "TB_" + SFTableAttr.TableDesc;
Pub1.AddTR();
Pub1.AddTDGroupTitle("", "描述：");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add(" 表描述");
Pub1.AddTDEnd();
Pub1.AddTREnd();
Pub1.AddTableEnd();
Pub1.AddBR();
Pub1.AddBR();
Pub1.AddSpace(1);
var btn = new LinkBtn(false, NamesOfBtn.Apply, "执行创建");
btn.Click += new EventHandler(btn_Create_Local_Click);
Pub1.Add(btn);
Pub1.AddSpace(1);
Pub1.Add("<a href='" + Request.UrlReferrer + "' class='easyui-linkbutton'>上一步</a>");
}
#endregion
#region Step = 3
if (this.Step == 3)
{
Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'");
Pub1.AddTR();
Pub1.AddTDGroupTitle("colspan='2'", "第3步：创建");
Pub1.AddTREnd();
TextBox tb = new TextBox();
tb.ID = "TB_No";
Pub1.AddTR();
Pub1.AddTDGroupTitle("style='width:100px'", "表英文名称：");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add(" 必须以字母或者下画线开头");
Pub1.AddTDEnd();
Pub1.AddTREnd();
tb = new TextBox();
tb.ID = "TB_" + SFTableAttr.Name;
Pub1.AddTR();
Pub1.AddTDGroupTitle("", "表中文名称：");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add(" 显示的标签");
Pub1.AddTDEnd();
Pub1.AddTREnd();
tb = new TextBox();
tb.ID = "TB_" + SFTableAttr.TableDesc;
Pub1.AddTR();
Pub1.AddTDGroupTitle("", "描述：");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add(" 表描述");
Pub1.AddTDEnd();
Pub1.AddTREnd();
Pub1.AddTableEnd();
Pub1.AddBR();
Pub1.AddBR();
Pub1.AddSpace(1);
var btn = new LinkBtn(false, NamesOfBtn.Apply, "执行创建");
btn.Click += new EventHandler(btn_Create_Click);
Pub1.Add(btn);
Pub1.AddSpace(1);
Pub1.Add("<a href='" + Request.UrlReferrer + "' class='easyui-linkbutton'>上一步</a>");
}
#endregion
}
public void BindCond()
{
Cond cond = new Cond();
cond.MyPK = this.GenerMyPK;
cond.RetrieveFromDBSources();
BP.WF.Node nd = new BP.WF.Node(this.FK_MainNode);
BP.WF.Node tond = new BP.WF.Node(this.ToNodeID);
this.Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'");
this.Pub1.AddTR();
this.Pub1.AddTD("colspan=3 class='GroupTitle'", "部门选择");
this.Pub1.AddTREnd();
Depts sts = new Depts();
sts.RetrieveAllFromDBSource();
int i = 0;
foreach (Dept st in sts)
{
i++;
if (i == 4)
{
i = 1;
}
if (i == 1)
{
Pub1.AddTR();
}
CheckBox cb = new CheckBox();
cb.ID = "CB_" + st.No;
cb.Text = st.Name;
if (cond.OperatorValue.ToString().Contains("@" + st.No + "@"))
{
cb.Checked = true;
}
this.Pub1.AddTD(cb);
if (i == 3)
{
Pub1.AddTREnd();
}
}
switch (i)
{
case 1:
Pub1.AddTD();
Pub1.AddTD();
Pub1.AddTREnd();
break;
case 2:
Pub1.AddTD();
Pub1.AddTREnd();
break;
default:
break;
}
this.Pub1.AddTableEnd();
Pub1.AddBR();
#region //增加“指定的操作员”选项，added by liuxc,2015-10-7
var ddl = new DDL();
ddl.ID = "DDL_" + CondAttr.SpecOperWay;
ddl.Width = 200;
ddl.Items.Add(new ListItem("当前操作员", "0"));
ddl.Items.Add(new ListItem("指定节点的操作员", "1"));
ddl.Items.Add(new ListItem("指定表单字段作为操作员", "2"));
ddl.Items.Add(new ListItem("指定操作员编号", "3"));
ddl.SetSelectItem((int)cond.SpecOperWay);
ddl.AutoPostBack = true;
ddl.SelectedIndexChanged += new EventHandler(ddl_SelectedIndexChanged);
Pub1.Add("指定的操作员：");
Pub1.Add(ddl);
Pub1.AddBR();
Pub1.AddBR();
var lbl = new Label();
lbl.ID = "LBL1";
switch (cond.SpecOperWay)
{
case SpecOperWay.SpecNodeOper:
lbl.Text = "节点编号：";
break;
case SpecOperWay.SpecSheetField:
lbl.Text = "表单字段：";
break;
case SpecOperWay.SpenEmpNo:
lbl.Text = "操作员编号：";
break;
case SpecOperWay.CurrOper:
lbl.Text = "参数：";
break;
}
Pub1.Add(lbl);
var tb = new TB();
tb.ID = "TB_" + CondAttr.SpecOperPara;
tb.Width = 200;
tb.Text = cond.SpecOperPara;
tb.Enabled = cond.SpecOperWay != SpecOperWay.CurrOper;
Pub1.Add(tb);
Pub1.AddSpace(1);
Pub1.Add("多个值请用英文“逗号”来分隔。");
Pub1.AddBR();
Pub1.AddBR();
#endregion
Pub1.AddSpace(1);
var btn = new LinkBtn(false, NamesOfBtn.Save, "保存");
btn.Click += new EventHandler(btn_Save_Click);
this.Pub1.Add(btn);
Pub1.AddSpace(1);
btn = new LinkBtn(false, NamesOfBtn.Delete, "删除");
btn.Attributes["onclick"] = " return confirm('您确定要删除吗？');";
btn.Click += new EventHandler(btn_Save_Click);
this.Pub1.Add(btn);
}
public void OutExcel(string desc)
{
Entities ens = BP.En.ClassFactory.GetEns(this.EnsName);
Map map = ens.GetNewEntity.EnMap;
System.Collections.Generic.Dictionary <string, string> attrs =
new System.Collections.Generic.Dictionary <string, string>();
foreach (Attr attr in map.Attrs)
{
if (attr.Key.IndexOf("Text") == -1)
{
if (attr.UIVisible == false)
{
continue;
}
}
if (attr.MyFieldType == FieldType.Enum ||
attr.MyFieldType == FieldType.PKEnum ||
attr.MyFieldType == FieldType.PKFK ||
attr.MyFieldType == FieldType.FK)
{
continue;
}
attrs.Add(attr.Key, attr.Desc);
}
//string strLine = "<table border=1 style='width:100%' >";
//strLine += "<caption>"+desc+"</caption>";
this.Pub1.AddTableNormal();
this.Pub1.AddTRGroupTitle(attrs.Count, desc);
this.Pub1.AddTR();
//生成文件标题
//strLine += "<TR>";
//foreach (Attr attr in map.Attrs)
//{
// if (attr.Key.IndexOf("Text") == -1)
// {
// if (attr.UIVisible == false)
// continue;
// }
// if (attr.MyFieldType == FieldType.Enum
// || attr.MyFieldType == FieldType.PKEnum
// || attr.MyFieldType == FieldType.PKFK
// || attr.MyFieldType == FieldType.FK)
// continue;
// strLine += "<th>" + attr.Desc + "</th>";
//}
//strLine += "</TR>";
foreach (System.Collections.Generic.KeyValuePair <string, string> attr in attrs)
{
Pub1.AddTDGroupTitle(attr.Value);
}
Pub1.AddTREnd();
for (int i = 0; i < 12; i++)
{
//strLine += "<TR>";
//foreach (Attr attr in map.Attrs)
//{
// if (attr.Key.IndexOf("Text") == -1)
// {
// if (attr.UIVisible == false)
// continue;
// }
// if (attr.MyFieldType == FieldType.Enum
// || attr.MyFieldType == FieldType.PKEnum
// || attr.MyFieldType == FieldType.PKFK
// || attr.MyFieldType == FieldType.FK)
// continue;
// strLine += "<td> </td>";
//}
//strLine += "</TR>";
Pub1.AddTR();
foreach (System.Collections.Generic.KeyValuePair <string, string> attr in attrs)
{
Pub1.AddTD(" ");
}
Pub1.AddTREnd();
}
//strLine += "</Table>";
Pub1.AddTableEnd();
//this.Pub1.DivInfoBlockBegin();
//this.Pub1.Add(strLine);
//this.Pub1.DivInfoBlockEnd();
}
protected void Page_Load(object sender, EventArgs e)
{
#region Step = 1
if (this.Step == 1)
{
BP.Sys.SFDBSrcs ens = new BP.Sys.SFDBSrcs();
ens.RetrieveAll();
Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'");
Pub1.AddTR();
Pub1.AddTDGroupTitle("", "第1步：选择下拉框数据来源类型");
Pub1.AddTREnd();
Pub1.AddTR();
Pub1.AddTDBegin();
Pub1.AddUL("class='navlist'");
this.Pub1.AddLi("<a href='/WF/MapDef/SFTable.aspx?DoType=New&MyPK=" + this.MyPK + "&Idx=" + this.Idx + "&FromApp=SL' ><b><img src='./Img/Table.png' border=0 style='width:17px;height:17px;' />外键型表或视图</b></a> - 比如：岗位、税种、行业、科目，本机上一个表组成一个下拉框。");
this.Pub1.AddLi("<a href='/WF/MapDef/SFSQL.aspx?DoType=New&MyPK=" + this.MyPK + "&Idx=" + this.Idx + "&FromApp=SL'><b><img src='./Img/View.png' border=0 style='width:17px;height:17px;' />外部表SQL数据源</b></a> - 比如：配置一个SQL通过数据库连接或获取的外部数据，组成一个下拉框。");
this.Pub1.AddLi("<a href='/WF/MapDef/SFWS.aspx?DoType=AddSFWebServeces&MyPK=" + this.MyPK + "&FType=Class&Idx=" + this.Idx + "&GroupField=" + this.GroupField + "&FromApp=SL'><b><img src='./Img/WS.png' border=0 />WebServices数据</b></a> - 比如：通过调用Webservices接口获得数据，组成一个下拉框。");
//// Pub1.AddLi("<div><a href='SFGuide.aspx?Step=12&FK_SFDBsrc=local'><img src='../../Img/New.gif' align='middle' /><span>创建本地编码字典表</span></a></div>");
// foreach (BP.Sys.SFDBSrc item in ens)
// {
// Pub1.AddLi("<div><a href='SFGuide.aspx?Step=2&FK_SFDBSrc=" + item.No + "'><span class='nav'>" +item.IP+ item.No + " - " + item.Name + "</span></a></div>");
// }
// this.Pub1.AddFieldSet("新增下拉框(外键、外部表、WebServices)字段(通常只有编号名称两个列)");
// this.Pub1.AddUL();
// this.Pub1.AddLi("<a href='Do.aspx?DoType=AddSFTable&MyPK=" + this.MyPK + "&FType=Class&Idx=" + this.Idx + "&GroupField=" + this.GroupField + "'><b>外键型</b></a> - 比如：岗位、税种、行业、科目，本机上一个表组成一个下拉框。");
// this.Pub1.AddLi("<a href='Do.aspx?DoType=AddSFSQL&MyPK=" + this.MyPK + "&FType=Class&Idx=" + this.Idx + "&GroupField=" + this.GroupField + "'><b>外部表</b></a> - 比如：配置一个SQL通过数据库连接或获取的外部数据，组成一个下拉框。");
// this.Pub1.AddLi("<a href='Do.aspx?DoType=AddSFWebServeces&MyPK=" + this.MyPK + "&FType=Class&Idx=" + this.Idx + "&GroupField=" + this.GroupField + "'><b>WebServices</b></a> - 比如：通过调用Webservices接口获得数据，组成一个下拉框。");
// this.Pub1.AddULEnd();
// this.Pub1.AddFieldSetEnd();
//创建.
//Pub1.AddLi("<div><a href=\"javascript:WinOpen('../RefFunc/UIEn.aspx?EnsName=BP.Sys.SFDBSrcs')\" ><img src='../../Img/New.gif' align='middle' /><span class='nav'>新建数据源</span></a></div>");
//Pub1.AddLi("<div><a href='SFGuide.aspx?Step=22'><img src='../../Img/New.gif' align='middle' /><span class='nav'>新建WebService数据源</span></a></div>");
Pub1.AddULEnd();
Pub1.AddTDEnd();
Pub1.AddTREnd();
Pub1.AddTREnd();
Pub1.AddTableEnd();
}
#endregion
#region Step = 2
if (this.Step == 2)
{
SFDBSrc src = new SFDBSrc(this.FK_SFDBSrc);
Pub1.Add("<div class='easyui-layout' data-options=\"fit:true\">");
Pub1.Add(string.Format("<div data-options=\"region:'west',split:true,title:'选择 {0} 表/视图'\" style='width:200px;'>",
src.No));
var lb = new LB();
lb.ID = "LB_Table";
lb.BindByTableNoName(src.GetTables());
lb.Style.Add("width", "100%");
lb.Style.Add("height", "100%");
lb.AutoPostBack = true;
lb.SelectedIndexChanged += new EventHandler(lb_SelectedIndexChanged);
Pub1.Add(lb);
Pub1.AddDivEnd();
Pub1.Add("<div data-options=\"region:'center',title:'第2步：请填写基础信息'\" style='padding:5px;'>");
Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'");
var dbType = src.DBSrcType;
if (dbType == DBSrcType.Localhost)
{
switch (SystemConfig.AppCenterDBType)
{
case DBType.MSSQL:
dbType = DBSrcType.SQLServer;
break;
case DBType.Oracle:
dbType = DBSrcType.Oracle;
break;
case DBType.MySQL:
dbType = DBSrcType.MySQL;
break;
case DBType.Informix:
dbType = DBSrcType.Informix;
break;
default:
throw new Exception("没有涉及到的连接测试类型...");
}
}
var islocal = (src.DBSrcType == DBSrcType.Localhost).ToString().ToLower();
Pub1.AddTR();
Pub1.AddTDGroupTitle("style='width:100px'", "值(编号)：");
var ddl = new DDL();
ddl.ID = "DDL_ColValue";
ddl.Attributes.Add("onchange", string.Format("generateSQL('{0}','{1}','{2}',{3})", src.No, src.DBName, dbType, islocal));
Pub1.AddTDBegin();
Pub1.Add(ddl);
Pub1.Add(" 编号列，比如：类别编号");
Pub1.AddTDEnd();
Pub1.AddTREnd();
Pub1.AddTR();
Pub1.AddTDGroupTitle("标签(名称)：");
ddl = new DDL();
ddl.ID = "DDL_ColText";
ddl.Attributes.Add("onchange", string.Format("generateSQL('{0}','{1}','{2}',{3})", src.No, src.DBName, dbType, islocal));
Pub1.AddTDBegin();
Pub1.Add(ddl);
Pub1.Add(" 显示的列，比如：类别名称");
Pub1.AddTDEnd();
Pub1.AddTREnd();
Pub1.AddTR();
Pub1.AddTDGroupTitle("父结点值(字段)：");
ddl = new DDL();
ddl.ID = "DDL_ColParentNo";
ddl.Attributes.Add("onchange", string.Format("generateSQL('{0}','{1}','{2}',{3})", src.No, src.DBName, dbType, islocal));
Pub1.AddTDBegin();
Pub1.Add(ddl);
Pub1.Add(" 如果是树类型实体，该列设置有效，比如：上级类别编号");
Pub1.AddTDEnd();
Pub1.AddTREnd();
Pub1.AddTR();
Pub1.AddTDGroupTitle("字典表类型：");
ddl = new DDL();
ddl.ID = "DDL_CodeStruct";
ddl.SelfBindSysEnum(SFTableAttr.CodeStruct);
ddl.Attributes.Add("onchange", string.Format("generateSQL('{0}','{1}','{2}',{3})", src.No, src.DBName, dbType, islocal));
Pub1.AddTD(ddl);
Pub1.AddTREnd();
Pub1.AddTR();
Pub1.AddTDGroupTitle("查询语句：");
var tb = new TB();
tb.ID = "TB_SelectStatement";
tb.TextMode = TextBoxMode.MultiLine;
tb.Columns = 60;
tb.Rows = 10;
tb.Style.Add("width", "99%");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add("<br /> 说明：查询语句可以修改，但请保证查询语句的准确性及有效性！");
Pub1.AddTDEnd();
Pub1.AddTREnd();
Pub1.AddTableEnd();
Pub1.AddBR();
Pub1.AddBR();
Pub1.AddSpace(1);
var btn = new LinkBtn(false, NamesOfBtn.Next, "下一步");
btn.Click += new EventHandler(btn_Click);
Pub1.Add(btn);
Pub1.AddSpace(1);
Pub1.Add("<a href='" + Request.UrlReferrer + "' class='easyui-linkbutton'>上一步</a>");
Pub1.AddDivEnd();
Pub1.AddDivEnd();
if (!IsPostBack && lb.Items.Count > 0)
{
lb.SelectedIndex = 0;
ShowSelectedTableColumns();
}
}
#endregion
#region Step = 12
if (this.Step == 12)
{
Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'");
Pub1.AddTR();
Pub1.AddTDGroupTitle("colspan='2'", "第2步：创建");
Pub1.AddTREnd();
TextBox tb = new TextBox();
tb.ID = "TB_No";
Pub1.AddTR();
Pub1.AddTDGroupTitle("style='width:100px'", "表英文名称：");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add(" 必须以字母或者下画线开头");
Pub1.AddTDEnd();
Pub1.AddTREnd();
tb = new TextBox();
tb.ID = "TB_" + SFTableAttr.Name;
Pub1.AddTR();
Pub1.AddTDGroupTitle("", "表中文名称：");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add(" 显示的标签");
Pub1.AddTDEnd();
Pub1.AddTREnd();
tb = new TextBox();
tb.ID = "TB_" + SFTableAttr.TableDesc;
Pub1.AddTR();
Pub1.AddTDGroupTitle("", "描述：");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add(" 表描述");
Pub1.AddTDEnd();
Pub1.AddTREnd();
Pub1.AddTableEnd();
Pub1.AddBR();
Pub1.AddBR();
Pub1.AddSpace(1);
var btn = new LinkBtn(false, NamesOfBtn.Apply, "执行创建");
btn.Click += new EventHandler(btn_Create_Local_Click);
Pub1.Add(btn);
Pub1.AddSpace(1);
Pub1.Add("<a href='" + Request.UrlReferrer + "' class='easyui-linkbutton'>上一步</a>");
}
#endregion
#region Step = 22
if (this.Step == 22)
{
Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'");
Pub1.AddTR();
Pub1.AddTDGroupTitle("colspan='2'", "第2步：创建本地WebService数据源表");
Pub1.AddTREnd();
TextBox tb = new TextBox();
tb.ID = "TB_No";
Pub1.AddTR();
Pub1.AddTDGroupTitle("style='width:100px'", "WebService数据源编号：");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add(" 必须以字母或者下画线开头，比如：HR,CRM");
Pub1.AddTDEnd();
Pub1.AddTREnd();
tb = new TextBox();
tb.ID = "TB_" + SFTableAttr.Name;
Pub1.AddTR();
Pub1.AddTDGroupTitle("", "WebService数据源名称：");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add(" 显示的数据源名称,比如:人力资源系统,客户关系管理系统.");
Pub1.AddTDEnd();
Pub1.AddTREnd();
tb = new TextBox();
tb.ID = "TB_" + SFTableAttr.TableDesc;
tb.Style.Add("width", "300px");
Pub1.AddTR();
Pub1.AddTDGroupTitle("", "WebService连接Url：");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add(" WebService地址,比如:http://127.0.0.1/CCFormTester.asmx");
Pub1.AddTDEnd();
Pub1.AddTREnd();
tb = new TextBox();
tb.ID = "TB_" + SFTableAttr.SrcTable;
tb.Style.Add("width", "300px");
Pub1.AddTR();
Pub1.AddTDGroupTitle("", "WebService接口名称：");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add(" 比如：GetEmps");
Pub1.AddTDEnd();
Pub1.AddTREnd();
tb = new TextBox();
tb.ID = "TB_" + SFTableAttr.SelectStatement;
tb.Style.Add("width", "300px");
Pub1.AddTR();
Pub1.AddTDGroupTitle("", "WebService接口参数：");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.AddTDEnd();
Pub1.AddTREnd();
Pub1.AddTR();
Pub1.AddTDGroupTitle("格式说明");
Pub1.AddTDDoc("如：WorkId=@WorkID&FK_Flow=@FK_Flow&FK_Node=@FK_Node&SearchType=1，带@的参数值在运行时自动使用发起流程的相关参数值替换，而不带@的参数值使用后面的赋值；参数个数与WebServices接口方法的参数个数一致，且顺序一致，且值均为字符类型。");
Pub1.AddTREnd();
Pub1.AddTableEnd();
Pub1.AddBR();
Pub1.AddBR();
Pub1.AddSpace(1);
var btn = new LinkBtn(false, NamesOfBtn.Apply, "执行创建");
btn.Click += new EventHandler(btn_Create_WebService_Click);
Pub1.Add(btn);
Pub1.AddSpace(1);
Pub1.Add("<a href='" + Request.UrlReferrer + "' class='easyui-linkbutton'>上一步</a>");
}
#endregion
#region Step = 3
if (this.Step == 3)
{
Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'");
Pub1.AddTR();
Pub1.AddTDGroupTitle("colspan='2'", "第3步：创建");
Pub1.AddTREnd();
TextBox tb = new TextBox();
tb.ID = "TB_No";
Pub1.AddTR();
Pub1.AddTDGroupTitle("style='width:100px'", "表英文名称：");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add(" 必须以字母或者下画线开头");
Pub1.AddTDEnd();
Pub1.AddTREnd();
tb = new TextBox();
tb.ID = "TB_" + SFTableAttr.Name;
Pub1.AddTR();
Pub1.AddTDGroupTitle("", "表中文名称：");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add(" 显示的标签");
Pub1.AddTDEnd();
Pub1.AddTREnd();
tb = new TextBox();
tb.ID = "TB_" + SFTableAttr.TableDesc;
Pub1.AddTR();
Pub1.AddTDGroupTitle("", "描述：");
Pub1.AddTDBegin();
Pub1.Add(tb);
Pub1.Add(" 表描述");
Pub1.AddTDEnd();
Pub1.AddTREnd();
Pub1.AddTableEnd();
Pub1.AddBR();
Pub1.AddBR();
Pub1.AddSpace(1);
var btn = new LinkBtn(false, NamesOfBtn.Apply, "执行创建");
btn.Click += new EventHandler(btn_Create_Click);
Pub1.Add(btn);
Pub1.AddSpace(1);
Pub1.Add("<a href='" + Request.UrlReferrer + "' class='easyui-linkbutton'>上一步</a>");
}
#endregion
}