protected void Page_Load(object sender, EventArgs e) { //this.Response.Redirect("ImpTableField1504.aspx?EnsName=" + this.FK_MapData, // true); //return; #region 第1步. if (this.Step == 1) { BP.Sys.SFDBSrcs ens = new BP.Sys.SFDBSrcs(); ens.RetrieveAll(); Pub1.AddTable("class='Table' cellSpacing='0' cellPadding='0' border='0' style='width:100%'"); Pub1.AddTR(); Pub1.AddTDGroupTitle("", "第1步:请选择数据源"); Pub1.AddTREnd(); Pub1.AddTR(); Pub1.AddTDBegin(); Pub1.AddUL("class='navlist'"); foreach (BP.Sys.SFDBSrc item in ens) { Pub1.AddLi("<div><a href='ImpTableField.aspx?Step=2&FK_MapData=" + this.FK_MapData + "&FK_SFDBSrc=" + item.No + "'><span class='nav'>" + item.No + " - " + item.Name + "</span></a></div>"); } Pub1.AddLi("<div><a href=\"javascript:WinOpen('/WF/Comm/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 第1步. #region 第2步. if (this.Step == 2) { SFDBSrc src = new SFDBSrc(this.FK_SFDBSrc); this.Pub1.Add("<div class='easyui-layout' data-options=\"fit:true\">"); this.Pub1.Add(string.Format("<div data-options=\"region:'west',split:true,title:'选择 {0} 数据表/视图'\" style='width:200px;'>", src.DBName)); DataTable dt = src.GetTables(); this.Pub1.AddUL(); foreach (DataRow dr in dt.Rows) { string url = "?Step=" + this.Step + "&FK_MapData=" + this.FK_MapData + "&FK_SFDBSrc=" + this.FK_SFDBSrc + "&STable=" + dr["No"].ToString(); if (dr["No"].ToString() == this.STable) { this.Pub1.Add("<li><font color=red><b>" + dr["Name"] + "</font></b></li>"); } else { this.Pub1.Add("<li><a href='" + url + "' >" + dr["Name"] + "</a></li>"); } } this.Pub1.AddULEnd(); Pub1.AddDivEnd(); this.Pub1.Add("<div data-options=\"region:'center',title:'第2步:请选择要导入的数据列(" + this.STable + ")'\" style='padding:5px;'>"); //加载选中数据表/视图的列信息 this.Pub1.AddTable(); // ("id='maintable' class='Table' cellSpacing='0' cellPadding='0' border='0' style='width:100%'"); this.Pub1.AddTR(); var cb = new CheckBox(); cb.ID = "CB_CheckAll"; cb.Attributes["onclick"] = "CheckAll(this.checked)"; this.Pub1.AddTDGroupTitle("style='width:40px;text-align:center'", cb); this.Pub1.AddTDGroupTitle("序"); this.Pub1.AddTDGroupTitle("字段名"); this.Pub1.AddTDGroupTitle("中文描述"); this.Pub1.AddTDGroupTitle("style='width:80px;text-align:center'", "类型"); this.Pub1.AddTDGroupTitle("style='width:50px;text-align:center'", "最大长度"); this.Pub1.AddTREnd(); MapAttrs attrs = new MapAttrs(this.FK_MapData); bool isHave = false; var tableColumns = src.GetColumns(this.STable); foreach (DataRow dr in tableColumns.Rows) { cb = new CheckBox(); cb.ID = "CB_Col_" + dr["name"]; cb.Checked = this.SColumns == null ? false : this.SColumns.Contains(dr["name"] + ","); //如果已经有该字段,就放弃. if (attrs.Contains(MapAttrAttr.KeyOfEn, dr["name"].ToString())) { continue; cb.Enabled = false; } this.Pub1.AddTR(); this.Pub1.AddTD(cb); this.Pub1.AddTD(dr["colid"].ToString()); this.Pub1.AddTD(dr["name"].ToString()); this.Pub1.AddTD(dr["Desc"].ToString()); this.Pub1.AddTD(dr["type"].ToString()); this.Pub1.AddTD(Convert.ToInt32(dr["length"])); this.Pub1.AddTREnd(); } this.Pub1.AddTableEnd(); this.Pub1.AddBR(); this.Pub1.AddBR(); this.Pub1.AddSpace(1); var btn = new LinkBtn(false, NamesOfBtn.Next, "下一步"); btn.Click += new EventHandler(btn_Click); this.Pub1.Add(btn); this.Pub1.AddSpace(1); this.Pub1.Add(string.Format("<a href='{0}?Step=1&FK_MapData={1}' class='easyui-linkbutton'>上一步</a>", Request.Url.AbsolutePath, this.FK_MapData)); this.Pub1.AddBR(); this.Pub1.AddBR(); this.Pub1.AddDivEnd(); this.Pub1.AddDivEnd(); } #endregion 第2步. #region 第3步. if (this.Step == 3) { SFDBSrc src = new SFDBSrc(this.FK_SFDBSrc); this.Pub1.AddTable(); // ("id='maintable' class='Table' cellSpacing='0' cellPadding='0' border='0' style='width:100%'"); this.Pub1.AddTDGroupTitle("序"); this.Pub1.AddTDGroupTitle("字段名"); this.Pub1.AddTDGroupTitle("中文描述"); this.Pub1.AddTDGroupTitle("数据类型"); this.Pub1.AddTDGroupTitle("逻辑类型"); this.Pub1.AddTDGroupTitle("绑定值(双击选择)"); this.Pub1.AddTDGroupTitle("最大长度"); this.Pub1.AddTDGroupTitle("顺序"); this.Pub1.AddTREnd(); var tableColumns = src.GetColumns(this.STable); var idx = 0; foreach (DataRow dr in tableColumns.Rows) { if (this.SColumns.Contains(dr["name"] + ",") == false) { continue; } string typeString = dr["type"].ToString().ToLower(); int mydatatype = 1; if (typeString.Contains("int")) { mydatatype = BP.DA.DataType.AppInt; } if (typeString.Contains("float")) { mydatatype = BP.DA.DataType.AppFloat; } if (typeString.Contains("double")) { mydatatype = BP.DA.DataType.AppDouble; } idx++; this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx); this.Pub1.AddTD(dr["name"].ToString()); //中文描述. var tb = new TB(); tb.ID = "TB_Desc_" + dr["name"]; tb.Columns = 20; tb.Text = dr["Desc"].ToString(); if (tb.Text.Length == 0) { tb.Text = dr["name"].ToString(); } this.Pub1.AddTD(tb); //数据类型. var ddl = new DDL(); ddl.ID = "DDL_DBType_" + dr["name"]; ddl.SelfBindSysEnum(MapAttrAttr.MyDataType); ddl.SetSelectItem(mydatatype); //设置选择的项目. this.Pub1.AddTD(ddl); //逻辑类型. ddl = new DDL(); ddl.ID = "DDL_LogicType_" + dr["name"]; ddl.SelfBindSysEnum(MapAttrAttr.LGType); this.Pub1.AddTD(ddl); //绑定的逻辑类型. tb = new TB(); tb.ID = "TB_BindKey_" + dr["name"]; tb.Columns = 30; tb.Text = dr["name"].ToString(); tb.Attributes["ondblclick"] = "OpenSelectBindKey(this)"; this.Pub1.AddTD(tb); //最大长度. //绑定的逻辑类型. tb = new TB(); tb.ID = "TB_Len_" + dr["name"]; tb.Columns = 5; tb.Text = dr["length"].ToString(); this.Pub1.AddTD(tb); this.Pub1.AddTDBegin("style='text-align:center'"); var hiddenIdx = new HiddenField(); hiddenIdx.ID = "HID_Idx_" + dr["name"]; hiddenIdx.Value = idx.ToString(); this.Pub1.Add(hiddenIdx); this.Pub1.Add("<a href='javascript:void(0)' onclick='up(this, 6)' class='easyui-linkbutton' data-options=\"iconCls:'icon-up'\"></a> "); this.Pub1.Add("<a href='javascript:void(0)' onclick='down(this, 6)' class='easyui-linkbutton' data-options=\"iconCls:'icon-down'\"></a>"); this.Pub1.AddTDEnd(); this.Pub1.AddTREnd(); } this.Pub1.AddTableEnd(); this.Pub1.AddBR(); this.Pub1.AddBR(); this.Pub1.AddSpace(1); var btn = new LinkBtn(false, NamesOfBtn.Save, "导入字段,生成表单"); btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); this.Pub1.AddSpace(1); this.Pub1.Add(string.Format("<a href='{0}' class='easyui-linkbutton'>上一步</a>", Request.Url.ToString().Replace("Step=3", "Step=2"))); this.Pub1.AddBR(); this.Pub1.AddBR(); } #endregion 第3步. }
private void BindSearch() { Flow fl = new Flow(this.FK_Flow); var gwfs = new GenerWorkFlows(); var qo = new QueryObject(gwfs); qo.AddWhere(GenerWorkFlowAttr.FK_Flow, FK_Flow); if (!string.IsNullOrWhiteSpace(Depts)) { qo.addAnd(); qo.AddWhereIn(GenerWorkFlowAttr.FK_Dept, "(" + Depts + ")"); } if (!string.IsNullOrWhiteSpace(Emps)) { qo.addAnd(); qo.AddWhereIn(GenerWorkFlowAttr.Starter, "(" + Emps.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Aggregate(string.Empty, (curr, next) => curr + "'" + next + "',").TrimEnd(',') + ")"); } if (!string.IsNullOrWhiteSpace(DateFrom)) { qo.addAnd(); qo.AddWhere(GenerWorkFlowAttr.RDT, ">", DateFrom); } if (!string.IsNullOrWhiteSpace(DateTo)) { qo.addAnd(); qo.AddWhere(GenerWorkFlowAttr.RDT, "<=", DateTo); } if (!string.IsNullOrWhiteSpace(Keywords)) { qo.addAnd(); qo.AddWhere(GenerWorkFlowAttr.Title, "LIKE", "%" + Keywords + "%"); } qo.addOrderBy(GenerWorkFlowAttr.RDT); var url = string.Format("FlowDB.aspx?FK_Flow={0}&WorkID={1}&IsSearch=1&Depts={2}&DeptsText={3}&Emps={4}&EmpsText={5}&DateFrom={6}&DateTo={7}&Keywords={8}", FK_Flow, WorkID, Depts, DeptsText, Emps, EmpsText, DateFrom, DateTo, Keywords); Pub2.BindPageIdxEasyUi(qo.GetCount(), url, this.PageIdx, SystemConfig.PageSize); qo.DoQuery(gwfs.GetNewEntity.PK, SystemConfig.PageSize, this.PageIdx); this.Pub1.AddTable("class='Table' cellspacing='0' cellpadding='0' border='0' style='width:100%'"); Pub1.AddTR(); Pub1.AddTDGroupTitle("colspan='8'", fl.Name); Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDGroupTitle("style='text-align:center'", "序号"); this.Pub1.AddTDGroupTitle("部门"); this.Pub1.AddTDGroupTitle("发起人"); this.Pub1.AddTDGroupTitle("发起时间"); this.Pub1.AddTDGroupTitle("当前停留节点"); this.Pub1.AddTDGroupTitle("标题"); this.Pub1.AddTDGroupTitle("处理人"); this.Pub1.AddTDGroupTitle("操作"); this.Pub1.AddTREnd(); int idx = 0; foreach (GenerWorkFlow item in gwfs) { idx++; this.Pub1.AddTR(); this.Pub1.AddTDIdx(SystemConfig.PageSize * (this.PageIdx - 1) + idx); this.Pub1.AddTD(item.DeptName); this.Pub1.AddTD(item.StarterName); this.Pub1.AddTD(item.RDT); this.Pub1.AddTD(item.NodeName); this.Pub1.AddTD(item.Title); this.Pub1.AddTD(item.TodoEmps); this.Pub1.AddTDBegin(); this.Pub1.Add("<a href=\"javascript:WinOpen('./../../WFRpt.aspx?WorkID=" + item.WorkID + "&FK_Flow=" + this.FK_Flow + "&FID=" + item.FID + "','ds'); \" class='easyui-linkbutton'>轨迹</a> "); //this.Pub1.Add("<a href=\"javascript:WinOpen('../../../WFRpt.aspx?WorkID=" + item.WorkID + "&FK_Flow=" + this.FK_Flow + "&FID=" + item.FID + "&FK_Node=" + item.FK_Node + "','ds'); \" >报告</a>-"); this.Pub1.Add("<a href=\"javascript:DelIt('" + item.FK_Flow + "','" + item.WorkID + "');\" class='easyui-linkbutton' data-options=\"iconCls:'icon-delete'\" onclick=\"return confirm('您确定要删除吗?');\">删除</a> "); this.Pub1.Add("<a href=\"javascript:FlowShift('" + item.FK_Flow + "','" + item.WorkID + "');\" class='easyui-linkbutton'>移交</a> "); this.Pub1.Add("<a href=\"javascript:FlowSkip('" + item.FK_Flow + "','" + item.WorkID + "');\" class='easyui-linkbutton'>跳转</a>"); this.Pub1.AddTDEnd(); this.Pub1.AddTREnd(); } this.Pub1.AddTableEnd(); }
public void DataPanelDtl(Entities ens, string ctrlId) { // this.Controls.Clear(); Entity myen = ens.GetNewEntity; string pk = myen.PK; string clName = myen.ToString(); Attrs attrs = myen.EnMap.Attrs; var attrCount = 0; var visibleAttrs = new List <Attr>(); foreach (Attr attrT in attrs) { if (attrT.UIVisible == false) { continue; } if (attrT.Key == "Title" || attrT.Key == "MyNum") { continue; } attrCount++; visibleAttrs.Add(attrT); } MapRpt md = new MapRpt(this.RptNo); this.Pub1.AddTable("class='Table' cellSpacing='0' cellPadding='0' border='0' style='width:100%'"); this.Pub1.AddTR(); this.Pub1.AddTDGroupTitle("colspan=" + (attrCount + 2), myen.EnMap.EnDesc + " 记录:" + ens.Count + "条"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDGroupTitle("style='text-align:center'", "序"); this.Pub1.AddTDGroupTitle("标题"); visibleAttrs.ForEach(attr => Pub1.AddTDGroupTitle(attr.Desc)); bool isRefFunc = false; isRefFunc = true; int pageidx = this.PageIdx - 1; int idx = SystemConfig.PageSize * pageidx; this.Pub1.AddTREnd(); string style = WebUser.Style; foreach (Entity en in ens) { this.Pub1.AddTR(); idx++; this.Pub1.AddTDIdx(idx); //this.Pub1.Add("<TD class='TD'><a href=\"javascript:WinOpen('../WorkOpt/OneWork/Track.aspx?FK_Flow=" + this.FK_Flow + "&WorkID=" + en.GetValStrByKey("OID") + "');\" ><img src='../Img/Track.png' border=0 />"+en.GetValStrByKey("Title")+"</a></TD>"); this.Pub1.Add("<TD class='TD'><a href=\"javascript:WinOpen('../WorkOpt/OneWork/Track.aspx?FK_Flow=" + this.FK_Flow + "&WorkID=" + en.GetValStrByKey("OID") + "');\" ><img src='../Img/Track.png' border=0 />" + en.GetValStrByKey("Title") + "</a></TD>"); foreach (var attr in visibleAttrs) { if (attr.UIContralType == UIContralType.DDL) { if (attr.UIBindKey == "BP.Pub.NYs") { this.Pub1.AddTD(en.GetValStrByKey(attr.Key)); } else { this.Pub1.AddTD(en.GetValRefTextByKey(attr.Key)); } continue; } if (attr.UIHeight != 0) { this.Pub1.AddTDDoc("...", "..."); continue; } string str = en.GetValStrByKey(attr.Key); switch (attr.MyDataType) { case DataType.AppDate: case DataType.AppDateTime: if (str == "" || str == null) { str = " "; } this.Pub1.AddTD(str); break; case DataType.AppString: if (str == "" || str == null) { str = " "; } if (attr.UIHeight != 0) { this.Pub1.AddTDDoc(str, str); } else { this.Pub1.AddTD(str); } break; case DataType.AppBoolean: if (str == "1") { this.Pub1.AddTD("是"); } else { this.Pub1.AddTD("否"); } break; case DataType.AppFloat: case DataType.AppInt: case DataType.AppRate: case DataType.AppDouble: this.Pub1.AddTDNum(str); break; case DataType.AppMoney: this.Pub1.AddTDNum(decimal.Parse(str).ToString("0.00")); break; default: throw new Exception("no this case ..."); } } this.Pub1.AddTREnd(); } #region 求合计代码写在这里。 bool IsHJ = false; foreach (Attr attr in attrs) { if (attr.MyFieldType == FieldType.RefText || attr.UIContralType == UIContralType.DDL) { continue; } if (attr.Key == "OID" || attr.Key == "FID" || attr.Key == "MID" || attr.Key.ToUpper() == "WORKID" || attr.Key == BP.WF.Data.NDXRptBaseAttr.FlowEndNode || attr.Key == BP.WF.Data.NDXRptBaseAttr.PWorkID) { continue; } switch (attr.MyDataType) { case DataType.AppDouble: case DataType.AppFloat: case DataType.AppInt: case DataType.AppMoney: IsHJ = true; break; default: break; } } if (IsHJ) { // 找出配置是不显示合计的列。 this.Pub1.Add("<TR class='TRSum'>"); this.Pub1.AddTD("class=Sum", "合计"); this.Pub1.AddTD("class=Sum", ""); foreach (Attr attr in attrs) { if (attr.MyFieldType == FieldType.RefText || attr.UIVisible == false || attr.Key == "MyNum") { continue; } if (attr.MyDataType == DataType.AppBoolean) { this.Pub1.AddTD("class=Sum", ""); continue; } if (attr.UIContralType == UIContralType.DDL) { this.Pub1.AddTD("class=Sum", ""); continue; } if (attr.Key == "OID" || attr.Key == "FID" || attr.Key == "MID" || attr.Key.ToUpper() == "WORKID") { this.Pub1.AddTD("class=Sum", ""); continue; } switch (attr.MyDataType) { case DataType.AppDouble: this.Pub1.AddTDNum(ens.GetSumDecimalByKey(attr.Key)); break; case DataType.AppFloat: this.Pub1.AddTDNum(ens.GetSumDecimalByKey(attr.Key)); break; case DataType.AppInt: this.Pub1.AddTDNum(ens.GetSumDecimalByKey(attr.Key)); break; case DataType.AppMoney: this.Pub1.AddTDJE(ens.GetSumDecimalByKey(attr.Key)); break; default: this.Pub1.AddTD("class=Sum", ""); break; } } this.Pub1.AddTREnd(); } #endregion this.Pub1.AddTableEnd(); }
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 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 }