/// <summary>
/// 新建文本框自动完成
/// </summary>
public void EditAutoFullM2M_TB()
{
MapExt myme = new MapExt(this.MyPK);
MapM2Ms m2ms = new MapM2Ms(myme.FK_MapData);
if (m2ms.Count == 0)
{
this.Pub1.Clear();
//this.Pub1.AddFieldSet("设置自动填充从表. <a href='?ExtType=" + this.ExtType + "&MyPK=" + this.MyPK + "&FK_MapData=" + this.FK_MapData + "&RefNo=" + this.RefNo + "'>返回</a>");
//this.Pub1.Add("该表单下没有从表，所以您不能为从表设置自动填充。");
//this.Pub1.AddFieldSetEnd();
Pub1.AddEasyUiPanelInfo("设置自动填充从表", "<p>该表单下没有从表，所以您不能为从表设置自动填充。<a href='?ExtType=" + this.ExtType + "&MyPK=" + this.MyPK + "&FK_MapData=" + this.FK_MapData + "&RefNo=" + this.RefNo + "'>返回</a></p>");
return;
}
Pub1.AddTableNormal();
Pub1.AddTRGroupTitle("设置自动填充从表. <a href='?ExtType=" + this.ExtType + "&MyPK=" + this.MyPK + "&FK_MapData=" + this.FK_MapData + "&RefNo=" + this.RefNo + "'>返回</a>");
string[] strs = myme.Tag2.Split('$');
bool isHaveM2M = false;
bool isHaveM2MM = false;
foreach (MapM2M m2m in m2ms)
{
if (m2m.HisM2MType == M2MType.M2M)
{
isHaveM2M = true;
}
if (m2m.HisM2MType == M2MType.M2MM)
{
isHaveM2MM = true;
}
TextBox tb = new TextBox();
tb.ID = "TB_" + m2m.NoOfObj;
tb.Columns = 70;
tb.Style.Add("width", "100%");
tb.Rows = 5;
tb.TextMode = TextBoxMode.MultiLine;
foreach (string s in strs)
{
if (s == null)
{
continue;
}
if (s.Contains(m2m.NoOfObj + ":") == false)
{
continue;
}
string[] ss = s.Split(':');
tb.Text = ss[1];
}
//this.Pub1.AddFieldSet("编号:" + m2m.NoOfObj + ",名称:" + m2m.Name);
Pub1.AddTR();
Pub1.AddTDBegin();
Pub1.Add("编号:" + m2m.NoOfObj + ",名称:" + m2m.Name);
Pub1.Add(tb);
Pub1.AddTDEnd();
Pub1.AddTREnd();
//this.Pub1.AddFieldSetEnd();
}
//this.Pub1.AddHR();
Pub1.AddTableEnd();
Pub1.AddBR();
//Button mybtn = new Button();
var mybtn = new LinkBtn(false, NamesOfBtn.Save, "保存");
mybtn.Click += new EventHandler(mybtn_SaveAutoFullM2M_Click);
this.Pub1.Add(mybtn);
Pub1.AddSpace(1);
mybtn = new LinkBtn(false, NamesOfBtn.Cancel, "取消");
mybtn.Click += new EventHandler(mybtn_SaveAutoFullM2M_Click);
this.Pub1.Add(mybtn);
Pub1.AddBR();
//this.Pub1.AddFieldSetEnd();
if (isHaveM2M)
{
//this.Pub1.AddFieldSet("帮助:一对多");
Pub1.AddEasyUiPanelInfoBegin("帮助:一对多", "icon-help");
this.Pub1.Add("在主表相关数据发生变化后，一对多数据要发生变化，变化的格式为：");
this.Pub1.AddBR("实例：SELECT No,Name FROM WF_Emp WHERE FK_Dept='@Key' ");
this.Pub1.AddBR("相关内容的值发生改变时而自动填充checkbox。");
this.Pub1.AddBR("注意:");
this.Pub1.AddBR("1，@Key 是主表字段传递过来的变量。");
this.Pub1.AddBR("2，必须并且仅有No,Name两个列，顺序不要颠倒。");
//this.Pub1.AddFieldSetEnd();
Pub1.AddEasyUiPanelInfoEnd();
}
if (isHaveM2MM)
{
//this.Pub1.AddFieldSet("帮助:一对多多");
Pub1.AddEasyUiPanelInfoBegin("帮助:一对多多", "icon-help");
this.Pub1.Add("在主表相关数据发生变化后，一对多多数据要发生变化，变化的格式为：");
this.Pub1.AddBR("实例：SELECT a.FK_Emp M1ID, a.FK_Station as M2ID, b.Name as M2Name FROM " + BP.WF.Glo.EmpStation + " a, Port_Station b WHERE A.FK_Station=B.No and a.FK_Emp='@Key'");
this.Pub1.AddBR("相关内容的值发生改变时而自动填充checkbox。");
this.Pub1.AddBR("注意:");
this.Pub1.AddBR("1，@Key 是主表字段传递过来的变量。");
this.Pub1.AddBR("2，必须并且仅有3个列 M1ID,M2ID,M2Name，顺序不要颠倒。第1列的ID对应列表的ID，第2，3列对应的是列表数据源的ID与名称。");
//this.Pub1.AddFieldSetEnd();
Pub1.AddEasyUiPanelInfoEnd();
}
}
/// <summary>
/// 新建文本框自动完成
/// </summary>
public void EditAutoFullDtl_TB()
{
MapExt myme = new MapExt(this.MyPK);
MapDtls dtls = new MapDtls(myme.FK_MapData);
if (dtls.Count == 0)
{
this.Pub1.Clear();
Pub1.AddEasyUiPanelInfo("设置自动填充从表", "<p>该表单下没有从表，所以您不能为从表设置自动填充。<a href='?ExtType=" + this.ExtType + "&MyPK=" + this.MyPK + "&FK_MapData=" + this.FK_MapData + "&RefNo=" + this.RefNo + "'>返回</a></p>");
return;
}
Pub1.AddTableNormal();
Pub1.AddTRGroupTitle("设置自动填充从表. <a href='?ExtType=" + this.ExtType + "&MyPK=" + this.MyPK + "&FK_MapData=" + this.FK_MapData + "&RefNo=" + this.RefNo + "'>返回</a>");
string[] strs = myme.Tag1.Split('$');
foreach (MapDtl dtl in dtls)
{
TextBox tb = new TextBox();
tb.ID = "TB_" + dtl.No;
tb.Columns = 70;
tb.Style.Add("width", "100%");
tb.Rows = 5;
tb.TextMode = TextBoxMode.MultiLine;
foreach (string s in strs)
{
if (s == null)
{
continue;
}
if (s.Contains(dtl.No + ":") == false)
{
continue;
}
string[] ss = s.Split(':');
tb.Text = ss[1];
}
//this.Pub1.AddFieldSet("编号:" + dtl.No + ",名称:" + dtl.Name);
Pub1.AddTR();
Pub1.AddTDBegin();
Pub1.Add("编号:" + dtl.No + ",名称:" + dtl.Name);
Pub1.AddBR();
Pub1.Add(tb);
Pub1.AddBR();
string fs = "可填充的字段:";
MapAttrs attrs = new MapAttrs(dtl.No);
foreach (MapAttr item in attrs)
{
if (item.KeyOfEn == "OID" || item.KeyOfEn == "RefPKVal")
{
continue;
}
fs += item.KeyOfEn + ",";
}
this.Pub1.Add(fs.Substring(0, fs.Length - 1));
//this.Pub1.AddFieldSetEnd();
Pub1.AddTDEnd();
Pub1.AddTREnd();
}
//this.Pub1.AddHR();
Pub1.AddTableEnd();
Pub1.AddBR();
//Button mybtn = new Button();
var mybtn = new LinkBtn(false, NamesOfBtn.Save, "保存");
mybtn.Click += new EventHandler(mybtn_SaveAutoFullDtl_Click);
this.Pub1.Add(mybtn);
Pub1.AddSpace(1);
mybtn = new LinkBtn(false, NamesOfBtn.Cancel, "取消");
mybtn.Click += new EventHandler(mybtn_SaveAutoFullDtl_Click);
this.Pub1.Add(mybtn);
Pub1.AddBR();
//this.Pub1.AddFieldSetEnd();
//this.Pub1.AddFieldSet("帮助:");
Pub1.AddEasyUiPanelInfoBegin("帮助", "icon-help");
this.Pub1.Add("在这里您需要设置一个查询语句");
this.Pub1.AddBR("例如：SELECT XLMC AS suozaixianlu, bustype as V_BusType FROM [V_XLVsBusType] WHERE jbxx_htid='@Key'");
this.Pub1.AddBR("这个查询语句要与从表的列对应上就可以在文本框的值发生改变时而自动填充。");
this.Pub1.AddBR("注意:");
this.Pub1.AddBR("1，@Key 是主表字段传递过来的变量。");
this.Pub1.AddBR("2，从表列字段字名，与填充sql列字段大小写匹配。");
//this.Pub1.AddFieldSetEnd();
Pub1.AddEasyUiPanelInfoEnd();
}
public void EditAutoJL()
{
// string mypk= this.DoType
string mypk = this.ExtType + "_" + this.FK_MapData + "_" + this.RefNo;
MapExt myme = new MapExt(mypk);
MapAttrs attrs = new MapAttrs(myme.FK_MapData);
string[] strs = myme.Tag.Split('$');
this.Pub1.AddTableNormal();
this.Pub1.AddTRGroupTitle("<a href='TBFullCtrl.aspx?ExtType=" + this.ExtType + "&MyPK=" + this.MyPK + "&FK_MapData=" + this.FK_MapData + "&RefNo=" + this.RefNo + "'>返回</a> - 设置级连菜单");
foreach (MapAttr attr in attrs)
{
if (attr.LGType == FieldTypeS.Normal)
{
continue;
}
if (attr.UIIsEnable == false)
{
continue;
}
TextBox tb = new TextBox();
tb.ID = "TB_" + attr.KeyOfEn;
tb.Style.Add("width", "100%");
tb.Columns = 90;
tb.Rows = 4;
tb.TextMode = TextBoxMode.MultiLine;
foreach (string s in strs)
{
if (s == null)
{
continue;
}
if (s.Contains(attr.KeyOfEn + ":") == false)
{
continue;
}
string[] ss = s.Split(':');
tb.Text = ss[1];
}
this.Pub1.AddTR();
this.Pub1.AddTD(attr.Name + " " + attr.KeyOfEn + " 字段");
this.Pub1.AddTREnd();
this.Pub1.AddTR();
this.Pub1.AddTD(tb);
this.Pub1.AddTREnd();
}
this.Pub1.AddTableEnd();
Pub1.AddBR();
var mybtn = new LinkBtn(false, NamesOfBtn.Save, "保存");
mybtn.Click += new EventHandler(mybtn_SaveAutoFullJilian_Click);
this.Pub1.Add(mybtn);
Pub1.AddSpace(1);
mybtn = new LinkBtn(false, NamesOfBtn.Cancel, "取消");
mybtn.Click += new EventHandler(mybtn_SaveAutoFullJilian_Click);
this.Pub1.Add(mybtn);
}
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);
}
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()
{
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);
}
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);
}
protected void Page_Load(object sender, EventArgs e)
{
FrmEvents ndevs = new FrmEvents();
ndevs.Retrieve(FrmEventAttr.FK_MapData, this.FK_MapData);
FrmEvent mynde = ndevs.GetEntityByKey(FrmEventAttr.FK_Event, this.Event) as FrmEvent;
if (mynde == null)
{
mynde = new FrmEvent();
mynde.FK_Event = this.Event;
}
if (!string.IsNullOrWhiteSpace(this.EventDoType))
{
mynde.HisDoType = (EventDoType)Enum.Parse(typeof(EventDoType), this.EventDoType);
}
this.Pub1.AddTable("class='Table' cellspacing='1' cellpadding='1' border='1' style='width:100%'");
//删除旧类型.
BP.DA.DBAccess.RunSQL("delete from sys_enum where enumkey='EventDoType'");
this.Pub1.AddTR();
this.Pub1.AddTD("width='200'", "内容类型:");
DDL ddl = new DDL();
ddl.BindSysEnum("EventDoType");
ddl.ID = "DDL_EventDoType";
ddl.SetSelectItem((int)mynde.HisDoType);
ddl.Attributes["onchange"] = string.Format("location.href='ActionEvent.aspx?NodeID={0}&MyPK={1}&Event={2}&FK_MapData={3}&EventDoType=' + this.options[this.selectedIndex].value + '&tk=' + Math.random()", this.NodeID, this.MyPK, this.Event, this.FK_MapData);
this.Pub1.AddTD(ddl);
this.Pub1.AddTREnd();
TextBox tb = null;
#region //执行DLL类方法设置， edited by liuxc,2016-01-17
if (mynde.HisDoType == BP.Sys.EventDoType.SpecClass)
{
this.Pub1.AddTR();
this.Pub1.AddTD("选择一个DLL文件:");
//绑定 DLL 文件.
ddl = new DDL();
ddl.ID = "DDL_MonthedDLL";
string[] fs = System.IO.Directory.GetFiles(BP.Sys.SystemConfig.PathOfWebApp + "\\Bin\\", "*.dll");
foreach (string str in fs)
{
string mystr = str.Replace(BP.Sys.SystemConfig.PathOfWebApp + "\\Bin\\", "");
switch (mystr)
{
case "BitmapCutter.Core.dll":
case "BP.Demo.dll":
// case "BP.En30.dll":
case "BP.GPM.dll":
case "BP.GPMClient.dll":
case "BP.Web.Controls.dll":
// case "BP.WF.dll":
case "CCFlow.dll":
case "ChineseConverter.dll":
case "FtpSupport.dll":
case "FusionCharts.dll":
case "IBM.Data.Informix.dll":
case "ICSharpCode.SharpZipLib.dll":
case "Interop.Excel.dll":
case "Interop.VBIDE.dll":
case "Microsoft.Expression.Interactions.dll":
case "Microsoft.Web.UI.WebControls.dll":
case "Newtonsoft.Json.dll":
case "NPOI.dll":
case "NPOI.OOXML.dll":
case "NPOI.OpenXml4Net.dll":
case "NPOI.OpenXmlFormats.dll":
case "office.dll":
case "Silverlight.DataSetConnector.dll":
case "System.Windows.Interactivity.dll":
continue;
default:
break;
}
ddl.Items.Add(new ListItem(mystr, str));
//ddl.Items.Add(new ListItem(str, str));
}
ddl.SetSelectItem(mynde.MonthedDLL);
ddl.AutoPostBack = true;
ddl.SelectedIndexChanged += new EventHandler(ddl_SelectedIndexChanged);
this.Pub1.AddTD(ddl);
this.Pub1.AddTREnd();
//获得类名.
this.Pub1.AddTR();
this.Pub1.AddTD("选择一个类名:");
Assembly abl = Assembly.LoadFrom(ddl.SelectedItemStringVal); // 载入程序集
Type[] types = abl.GetTypes();
ddl = new DDL();
ddl.ID = "DDL_MonthedClass";
//绑定类名称.
Type mytype = this.InitClassName(ddl, types, mynde.MonthedClass);
ddl.SetSelectItem(mynde.MonthedClass);
ddl.AutoPostBack = true;
ddl.SelectedIndexChanged += new EventHandler(ddl_Class_SelectedIndexChanged);
this.Pub1.AddTD(ddl);
this.Pub1.AddTREnd();
this.Pub1.AddTR();
this.Pub1.AddTD("选择一个方法:");
ddl = new DDL();
ddl.ID = "DDL_MonthedName";
//绑定方法.
ParameterInfo[] myPI = this.InitMethodName(ddl, mytype.GetMethods(), mynde.MonthedName);
ddl.SetSelectItem(mynde.MonthedName);
ddl.AutoPostBack = true;
ddl.SelectedIndexChanged += new EventHandler(ddl_Monthed_SelectedIndexChanged);
this.Pub1.AddTD(ddl);
this.Pub1.AddTREnd();
#region 参数与参数格式.
this.Pub1.AddTR();
this.Pub1.AddTD("执行方法的参数");
//参数.
tb = new TextBox();
tb.ID = "TB_MonthedParas";
tb.Text = mynde.MonthedParas.Replace("~", "@");
tb.Columns = 80;
this.Pub1.AddTD(tb);
this.Pub1.AddTREnd();
this.Pub1.AddTR();
this.Pub1.AddTD("参数格式:");
Label lab = new Label();
lab.ID = "Lab_Note";
lab.Text = this.GenerParas(myPI);
this.Pub1.AddTD(lab);
this.Pub1.AddTREnd();
#endregion 参数与参数格式.
}
#endregion
this.Pub1.AddTR();
this.Pub1.AddTDBegin("colspan=2");
this.Pub1.Add(" 要执行的内容<br>");
tb = new TextBox();
tb.ID = "TB_Doc";
tb.Columns = 50;
tb.Style.Add("width", "99%");
tb.TextMode = TextBoxMode.MultiLine;
tb.Rows = 5;
tb.Text = mynde.DoDoc;
this.Pub1.Add(tb);
this.Pub1.AddTDEnd();
this.Pub1.AddTREnd();
this.Pub1.AddTR();
this.Pub1.AddTDBegin("colspan=2");
tb = new TextBox();
tb.ID = "TB_MsgOK";
tb.Style.Add("width", "99%");
tb.Text = mynde.MsgOKString;
this.Pub1.Add("执行成功信息提示(可为空)<br>");
this.Pub1.Add(tb);
this.Pub1.AddTDEnd();
this.Pub1.AddTREnd();
this.Pub1.AddTR();
this.Pub1.AddTDBegin("colspan=2");
this.Pub1.Add("执行失败信息提示(可为空)<br>");
tb = new TextBox();
tb.ID = "TB_MsgErr";
tb.Style.Add("width", "99%");
tb.Text = mynde.MsgErrorString;
this.Pub1.Add(tb);
this.Pub1.AddTDEnd();
this.Pub1.AddTREnd();
this.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(this.MyPK))
{
Pub1.AddSpace(1);
Pub1.Add(
string.Format(
"<a href='javascript:void(0)' onclick=\"DoDel('{2}','{0}','{1}')\" class='easyui-linkbutton' data-options=\"iconCls:'icon-delete'\">删除</a>",
NodeID, Event, FK_Flow));
}
}
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);
}
protected void Page_Load(object sender, EventArgs e)
{
FrmEvents ndevs = new FrmEvents();
ndevs.Retrieve(FrmEventAttr.FK_MapData, this.FK_MapData);
FrmEvent mynde = ndevs.GetEntityByKey(FrmEventAttr.FK_Event, this.Event) as FrmEvent;
if (mynde == null)
{
mynde = new FrmEvent();
mynde.FK_Event = this.Event;
}
this.Pub1.AddTable("class='Table' cellspacing='1' cellpadding='1' border='1' style='width:100%'");
this.Pub1.AddTR();
this.Pub1.AddTD("控制方式");
var ddl = new DDL();
ddl.BindSysEnum("MsgCtrl");
ddl.ID = "DDL_" + FrmEventAttr.MsgCtrl;
ddl.SetSelectItem((int)mynde.MsgCtrl);
this.Pub1.AddTD(ddl);
this.Pub1.AddTREnd();
this.Pub1.AddTR();
this.Pub1.AddTD("");
CheckBox cb = new CheckBox();
cb.ID = "CB_" + FrmEventAttr.MsgMailEnable;
cb.Text = "是否启用邮件通知？";
cb.Checked = mynde.MsgMailEnable;
this.Pub1.AddTD(cb);
this.Pub1.AddTREnd();
this.Pub1.AddTR();
this.Pub1.AddTD("邮件标题模版");
var tb = new TextBox();
tb.ID = "TB_" + FrmEventAttr.MailTitle;
tb.Text = mynde.MailTitle_Real;
tb.Style.Add("width", "99%");
this.Pub1.AddTD(tb);
this.Pub1.AddTREnd();
this.Pub1.AddTR();
this.Pub1.AddTD("邮件内容模版:");
tb = new TextBox();
tb.ID = "TB_" + FrmEventAttr.MailDoc;
tb.Text = mynde.MailDoc_Real;
tb.TextMode = TextBoxMode.MultiLine;
tb.Columns = 50;
tb.Rows = 4;
tb.Style.Add("width", "99%");
this.Pub1.AddTD(tb);
this.Pub1.AddTREnd();
//手机短信....
this.Pub1.AddTR();
this.Pub1.AddTD("默认:不启用");
cb = new CheckBox();
cb.ID = "CB_" + FrmEventAttr.SMSEnable;
cb.Text = "是否启用手机短信通知？";
cb.Checked = mynde.SMSEnable;
this.Pub1.AddTD(cb);
this.Pub1.AddTREnd();
tb = new TextBox();
tb.ID = "TB_" + FrmEventAttr.SMSDoc;
tb.Text = mynde.SMSDoc_Real;
tb.Style.Add("width", "99%");
tb.Rows = 2;
this.Pub1.AddTR();
if (string.IsNullOrEmpty(tb.Text) == true)
{
this.Pub1.AddTD("短信模版:");
}
else
{
this.Pub1.AddTD("短信模版");
}
this.Pub1.AddTD(tb);
this.Pub1.AddTREnd();
this.Pub1.AddTR();
this.Pub1.AddTD("默认:启用");
cb = new CheckBox();
cb.ID = "CB_" + FrmEventAttr.MobilePushEnable;
cb.Text = "是否启用手机应用，平板应用信息推送？";
cb.Checked = mynde.MobilePushEnable;
this.Pub1.AddTD(cb);
this.Pub1.AddTREnd();
this.Pub1.AddTableEnd();
Pub1.AddBR();
Pub1.AddSpace(1);
var btn = new LinkBtn(false, NamesOfBtn.Save, "保存");
btn.Click += new EventHandler(btn_Click);
Pub1.Add(btn);
}
protected void Page_Load(object sender, EventArgs e)
{
FrmEvents ndevs = new FrmEvents();
ndevs.Retrieve(FrmEventAttr.FK_MapData, this.FK_MapData);
FrmEvent mynde = ndevs.GetEntityByKey(FrmEventAttr.FK_Event, this.Event) as FrmEvent;
if (mynde == null)
{
mynde = new FrmEvent();
mynde.FK_Event = this.Event;
}
this.Pub1.AddTable("class='Table' cellspacing='1' cellpadding='1' border='1' style='width:100%'");
this.Pub1.AddTR();
this.Pub1.AddTD("内容类型:");
DDL ddl = new DDL();
ddl.BindSysEnum("EventDoType");
ddl.ID = "DDL_EventDoType";
ddl.SetSelectItem((int)mynde.HisDoType);
this.Pub1.AddTD(ddl);
this.Pub1.AddTREnd();
this.Pub1.AddTR();
this.Pub1.AddTDBegin("colspan=2");
this.Pub1.Add(" 要执行的内容<br>");
TextBox tb = new TextBox();
tb.ID = "TB_Doc";
tb.Columns = 50;
tb.Style.Add("width", "99%");
tb.TextMode = TextBoxMode.MultiLine;
tb.Rows = 20;
tb.Text = mynde.DoDoc;
this.Pub1.Add(tb);
this.Pub1.AddTDEnd();
this.Pub1.AddTREnd();
this.Pub1.AddTR();
this.Pub1.AddTDBegin("colspan=2");
tb = new TextBox();
tb.ID = "TB_MsgOK";
tb.Style.Add("width", "99%");
tb.Text = mynde.MsgOKString;
this.Pub1.Add("执行成功信息提示(可为空)<br>");
this.Pub1.Add(tb);
this.Pub1.AddTDEnd();
this.Pub1.AddTREnd();
this.Pub1.AddTR();
this.Pub1.AddTDBegin("colspan=2");
this.Pub1.Add("执行失败信息提示(可为空)<br>");
tb = new TextBox();
tb.ID = "TB_MsgErr";
tb.Style.Add("width", "99%");
tb.Text = mynde.MsgErrorString;
this.Pub1.Add(tb);
this.Pub1.AddTDEnd();
this.Pub1.AddTREnd();
this.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(this.MyPK))
{
Pub1.AddSpace(1);
Pub1.Add(
string.Format(
"<a href='javascript:void(0)' onclick=\"DoDel('{0}','{1}')\" class='easyui-linkbutton' data-options=\"iconCls:'icon-delete'\">删除</a>",
NodeID, Event));
}
}
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
}
protected void Page_Load(object sender, EventArgs e)
{
GloVar gvar = new GloVar();
gvars = gvar.GetNewEntities as GloVars;
gvars.Retrieve(GloVarAttr.GroupKey, "IntegrationSet");
gvarSModel = gvars.GetEntityByKey("StructureModel") as GloVar;
gvarSMKind = gvars.GetEntityByKey("StructureMngKind") as GloVar;
gvarSSource = gvars.GetEntityByKey("StructureSource") as GloVar;
GenerateCheckedInfo();
switch (Step)
{
case 1:
#region 设置组织结构模式
Pub1.Add("选择组织结构模式：");
if (gvarSModel == null)
{
gvarSModel = new GloVar();
gvarSModel.No = "StructureModel";
gvarSModel.Name = "组织结构模式";
gvarSModel.Val = "1";
gvarSModel.GroupKey = "IntegrationSet";
gvarSModel.Note = GetJoinStringFromArray(_smodels);
gvarSModel.Insert();
}
BPRadioButtonList rads = new BPRadioButtonList();
rads.ID = "Rads_StructureModel";
AddCheckItems(rads, _smodels);
rads.RepeatDirection = RepeatDirection.Horizontal;
rads.RepeatLayout = RepeatLayout.Flow;
rads.SetSelectItem(gvarSModel.Val);
Pub1.Add(rads);
Pub1.AddBR();
Pub1.AddBR();
AddButton(NamesOfBtn.Save, "保存并继续");
#endregion
break;
case 2:
#region 设置组织结构维护方式
Pub1.Add("设置组织结构维护方式：");
if (gvarSMKind == null)
{
gvarSMKind = new GloVar();
gvarSMKind.No = "StructureMngKind";
gvarSMKind.Name = "组织结构维护方式";
gvarSMKind.Val = "1";
gvarSMKind.GroupKey = "IntegrationSet";
gvarSMKind.Note = GetJoinStringFromArray(_smkinds);
gvarSMKind.Insert();
}
rads = new BPRadioButtonList();
rads.ID = "Rads_StructureMngKind";
AddCheckItems(rads, _smkinds);
rads.RepeatDirection = RepeatDirection.Horizontal;
rads.RepeatLayout = RepeatLayout.Flow;
rads.SetSelectItem(gvarSMKind.Val);
Pub1.Add(rads);
Pub1.AddBR();
Pub1.AddBR();
AddButton(NamesOfBtn.Save, "保存并继续");
Pub1.AddSpace(1);
AddButton(NamesOfBtn.Back, "上一步");
#endregion
break;
case 3:
#region 择组织结构来源
Pub1.Add("选择组织结构来源：");
if (gvarSSource == null)
{
gvarSSource = new GloVar();
gvarSSource.No = "StructureSource";
gvarSSource.Name = "选择组织结构来源";
gvarSSource.Val = "1";
gvarSSource.GroupKey = "IntegrationSet";
gvarSSource.Note = GetJoinStringFromArray(_ssources);
gvarSSource.Insert();
}
rads = new BPRadioButtonList();
rads.ID = "Rads_StructureSource";
AddCheckItems(rads, _ssources);
rads.RepeatDirection = RepeatDirection.Horizontal;
rads.RepeatLayout = RepeatLayout.Flow;
rads.SetSelectItem(gvarSSource.Val);
Pub1.Add(rads);
Pub1.AddBR();
Pub1.AddBR();
AddButton(NamesOfBtn.Save, "保存并继续");
Pub1.AddSpace(1);
AddButton(NamesOfBtn.Back, "上一步");
#endregion
break;
case 4:
#region 配置查询语句
string msg = string.Empty;
if (gvarSModel == null)
{
msg = "“<a href='?step=1'>组织结构模式</a>”、";
}
if (gvarSMKind == null)
{
msg += "“<a href='?step=2'>组织结构维护方式</a>”、";
}
if (gvarSSource == null)
{
msg += "“<a href='?step=3'>组织结构来源</a>”";
}
if (!string.IsNullOrWhiteSpace(msg))
{
Pub1.AddEasyUiPanelInfo("信息", "请先配置" + msg.TrimEnd('、') + "，然后配置此项！");
Pub1.AddBR();
AddButton(NamesOfBtn.Back, "上一步");
return;
}
//如果组织结构来源选择的是WebService和AD，则提示用户编写提供的通用webservice，以联接这两方载体
if (gvarSSource.Val == "2" || gvarSSource.Val == "3")
{
Pub1.AddEasyUiPanelInfo("信息", "您选择的组织结构数据来源是“<span style='font-weight:bold;'>" + _ssources[int.Parse(gvarSSource.Val) - 1] + "</span>”，该种方式目前请自行修改位于CCFlow项目下的WebService文件：\\DataUser\\PortalInterface.asmx，此WebService用来提供组织结构的相关数据。");
Pub1.AddBR();
AddButton(NamesOfBtn.Back, "上一步");
return;
}
if (gvarSModel.Val == "1")
{
//一个用户一个部门
_oneones = new Dictionary <string, Dictionary <string, string> >();
maps = new[]
{
new BP.Port.Station().EnMap,
new BP.Port.Dept().EnMap,
new BP.Port.Emp().EnMap,
new BP.Port.EmpStation().EnMap
};
GenerateMapAttrs(_oneones, maps);
}
else
{
//一个用户多个部门
_onemores = new Dictionary <string, Dictionary <string, string> >();
maps = new[]
{
new BP.GPM.StationType().EnMap,
new BP.GPM.Station().EnMap,
new BP.GPM.Dept().EnMap,
new BP.GPM.Duty().EnMap,
new BP.GPM.DeptDuty().EnMap,
new BP.GPM.Emp().EnMap,
new BP.GPM.DeptEmp().EnMap,
new BP.GPM.DeptStation().EnMap,
new BP.GPM.DeptEmpStation().EnMap
};
GenerateMapAttrs(_onemores, maps);
}
//如果组织结构维护方式选择的是由“CCBPM组织结构维护”，则下面的配置查询语句就不需要了
if (gvarSMKind.Val == "1")
{
msg = "您选择的组织结构数据来源是“<span style='font-weight:bold;'>" + _ssources[int.Parse(gvarSSource.Val) - 1] + "</span>”，组织结构维护方式选择的是“<span style='font-weight:bold;'>" + _smkinds[int.Parse(gvarSMKind.Val) - 1] + "</span>”，组织结构模式是“<span style='font-weight:bold;'>" + _smodels[int.Parse(gvarSModel.Val) - 1] + "</span>”，此种模式下，在ccbpm的主库中需要维护的相关表有：<br />";
if (gvarSModel.Val == "1")
{
//一个用户一个部门
msg += "1.岗位类型[Sys_Enum]。Sys_Enum枚举表中EnumKey='StaGrade'的枚举。<br />";
for (int i = 0; i < maps.Length; i++)
{
msg += string.Format("{0}.{1}[{2}]。<br />", i + 2, maps[i].EnDesc, maps[i].PhysicsTable);
}
}
else
{
//一个用户多个部门
for (int i = 0; i < maps.Length; i++)
{
msg += string.Format("{0}.{1}[{2}]。<br />", i + 1, maps[i].EnDesc, maps[i].PhysicsTable);
}
}
msg += " <hr> 在这种运行模式下，ccbpm系统已经为您提供了一套维护组织机构的功能，您可以左边的组织机构树进行维护。";
Pub1.AddEasyUiPanelInfo("信息", msg);
Pub1.AddBR();
AddButton(NamesOfBtn.Back, "上一步");
}
else
{
Pub1.Add(
"您选择的组织结构数据来源是“<span style='font-weight:bold;'>" + _ssources[int.Parse(gvarSSource.Val) - 1] + "</span>”，组织结构维护方式选择的是“<span style='font-weight:bold;'>" + _smkinds[int.Parse(gvarSMKind.Val) - 1] + "</span>”，组织结构模式是“<span style='font-weight:bold;'>" + _smodels[int.Parse(gvarSModel.Val) - 1] + "</span>”。<br />");
gvarDBSrc = gvars.GetEntityByKey("StructureDBSrc") as GloVar;
if (gvarDBSrc == null)
{
gvarDBSrc = new GloVar();
gvarDBSrc.No = "StructureDBSrc";
gvarDBSrc.Name = "数据源编号";
gvarDBSrc.Val = "local";
gvarDBSrc.Note = "数据源是Sys_SFDBSrc表";
gvarDBSrc.GroupKey = "IntegrationSet";
gvarDBSrc.Save();
}
//gvarDBOver = gvars.GetEntityByKey("StructureDBOver") as GloVar;
//if (gvarDBOver == null)
//{
// gvarDBOver = new GloVar();
// gvarDBOver.No = "StructureDBOver";
// gvarDBOver.Name = "数据源SQL配置是否完成";
// gvarDBOver.Val = "False";
// gvarDBOver.Note = "若组织结构配置的SQL已经配置完成，且有效，则为True；反之，为False";
// gvarDBOver.GroupKey = "IntegrationSet";
// gvarDBOver.Save();
//}
SFDBSrcs srcs = new SFDBSrcs();
srcs.RetrieveAll(SFDBSrcAttr.DBSrcType);
//根据传来的数据源编号，变更当前的数据源
if (!string.IsNullOrWhiteSpace(Request.QueryString["src"]) && srcs.IsExits(SFDBSrcAttr.No, Request.QueryString["src"]))
{
gvarDBSrc.Val = Request.QueryString["src"];
gvarDBSrc.Update();
}
DDL ddl = new DDL();
ddl.CssClass = "easyui-combobox";
ddl.Attributes["data-options"] = "onSelect:function(rcd){location.href='Integration.aspx?step=4&src=' + rcd.value;}";
ddl.ID = "DDL_DBSrcs";
ddl.AutoPostBack = true;
ddl.BindEntities(srcs);
ddl.SetSelectItem(gvarDBSrc.Val);
Pub1.AddBR();
Pub1.Add("选择数据源：");
Pub1.Add(ddl);
Pub1.AddSpace(1);
Pub1.Add("<a href=\"javascript: OpenEasyUiDialog('../../Comm/Sys/SFDBSrcNewGuide.aspx', 'eudlgframe', '新建数据源', 760, 470, 'icon-add', true, function () {location.href = location.href;})\" class='easyui-linkbutton' data-optinos=\"iconCls:'icon-add'\">新建数据源</a>");
Pub1.AddBR();
Pub1.AddBR();
//if (gvarDBSrc.Val == "local")
//{
// Pub1.AddEasyUiPanelInfo("信息", string.Format("“<span style='font-weight:bold;'>{0}</span>”是CCFlow主数据源，不需要进行组织结构的SQL配置。", ddl.SelectedItem.Text));
// Pub1.AddBR();
// AddButton(NamesOfBtn.Back, "上一步");
// return;
//}
Pub1.Add("选择此数据源，需要配置的相关表的SQL查询语句如下：");
Pub1.AddBR();
Pub1.AddBR();
if (gvarSModel.Val == "1")
{
#region //一个用户一个部门
Pub1.Add("1.<span style='font-weight:bold;'>岗位类型数据</span>。<br />");
LinkBtn btn = new LinkBtn(false, NamesOfBtn.Edit, " 编辑数据");
btn.PostBackUrl = "javascript:void(0)";
btn.OnClientClick = "OpenEasyUiDialog('../../Comm/Sys/EnumList.aspx?RefNo=StaGrade&t=' + Math.random(), 'euiframe','编辑岗位类型',600,374,'icon-edit')";
Pub1.Add(btn);
Pub1.AddBR();
Pub1.AddBR();
#endregion
}
int idx = gvarSModel.Val == "1" ? 2 : 1;
TB tb = null;
foreach (BP.En.Map map in maps)
{
gvar = CheckGloVar(gvars, map.PhysicsTable, map.EnDesc);
Pub1.Add(GenerateAttrDescs(map, idx++));
tb = new TB();
tb.ID = "TB_" + map.PhysicsTable;
tb.TextMode = TextBoxMode.MultiLine;
tb.Text = (gvar.Val ?? string.Empty).Replace('~', '\'');
tb.Wrap = true;
tb.Width = 760;
tb.Height = 60;
Pub1.Add(tb);
Pub1.AddBR();
AddButton(NamesOfBtn.DataCheck + "_" + map.PhysicsTable, "检查正确性");
Pub1.AddSpace(1);
AddButton(NamesOfBtn.Open + "_" + map.PhysicsTable, "打开数据源");
Pub1.AddBR();
Pub1.AddBR();
}
AddButton(NamesOfBtn.Setting, "设置全部");
Pub1.AddSpace(1);
AddButton(NamesOfBtn.Back, "上一步");
Pub1.AddBR();
Pub1.AddBR();
}
#endregion
break;
}
}