void btnC_Click(object sender, EventArgs e) { BP.WF.Node mynd = new BP.WF.Node(this.RefNo); BP.WF.Nodes nds = new BP.WF.Nodes(mynd.FK_Flow); foreach (BP.WF.Node nd in nds) { if ("ND" + nd.NodeID == this.RefNo) { continue; } GroupFields gfs = new GroupFields("ND" + nd.NodeID); foreach (GroupField gf in gfs) { string id = "CB_" + gf.OID; if (this.Pub1.GetCBByID(id).Checked == false) { continue; } MapAttrs attrs = new MapAttrs(); attrs.Retrieve(MapAttrAttr.GroupID, gf.OID); if (attrs.Count == 0) { continue; } } } }
public static string[] GetGroupFields(GroupFields fields) { var s = Enum.GetValues(typeof(GroupFields)) .OfType <GroupFields>() .Where(a => a != GroupFields.Everything && a != GroupFields.None) .Where(a => (fields & a) == a) .Select(a => a.ToNCString().ToSnake()) .ToArray(); return(s); }
void btn_Click(object sender, EventArgs e) { FrmAttachment ath = new FrmAttachment(); Button btn = sender as Button; if (btn.ID == "Btn_Delete") { ath.MyPK = this.FK_MapData + "_" + this.Ath; ath.Delete(); this.WinClose("删除成功."); return; } ath.MyPK = this.FK_MapData + "_" + this.Ath; if (this.Ath != null) { ath.RetrieveFromDBSources(); } ath = this.Pub1.Copy(ath) as FrmAttachment; ath.FK_MapData = this.FK_MapData; ath.MyPK = this.FK_MapData + "_" + this.Ath; GroupFields gfs1 = new GroupFields(this.FK_MapData); if (gfs1.Count == 1) { GroupField gf = (GroupField)gfs1[0]; ath.GroupID = gf.OID; } else { ath.GroupID = this.Pub1.GetDDLByID("DDL_GroupField").SelectedItemIntVal; } if (this.Ath == null) { ath.UploadType = (AttachmentUploadType)int.Parse(this.UploadType); ath.MyPK = this.FK_MapData + "_" + this.Ath; if (ath.IsExits == true) { this.Alert("附件编号(" + ath.NoOfObj + ")已经存在。"); return; } ath.Insert(); } else { ath.NoOfObj = this.Ath; ath.Update(); } this.WinCloseWithMsg("保存成功"); }
public override List <Sort> RequiredSortFields() { if (GroupFields == null) { return(null); } else { return(GroupFields.Select(c => new Sort { Column = c.SourceColumn, Direction = Sort.EDirection.Ascending }).ToList()); } }
/// <summary> /// 返回信息。 /// </summary> /// <returns></returns> public string RadioBtns_Init() { DataSet ds = new DataSet(); //放入表单字段. MapAttrs attrs = new MapAttrs(this.FK_MapData); ds.Tables.Add(attrs.ToDataTableField("Sys_MapAttr")); //属性. MapAttr attr = new MapAttr(); attr.MyPK = this.FK_MapData + "_" + this.KeyOfEn; attr.Retrieve(); //把分组加入里面. GroupFields gfs = new GroupFields(this.FK_MapData); ds.Tables.Add(gfs.ToDataTableField("Sys_GroupFields")); //字段值. FrmRBs rbs = new FrmRBs(); rbs.Retrieve(FrmRBAttr.FK_MapData, this.FK_MapData, FrmRBAttr.KeyOfEn, this.KeyOfEn); if (rbs.Count == 0) { /*初始枚举值变化. */ SysEnums ses = new SysEnums(attr.UIBindKey); foreach (SysEnum se in ses) { FrmRB rb = new FrmRB(); rb.FK_MapData = this.FK_MapData; rb.KeyOfEn = this.KeyOfEn; rb.IntKey = se.IntKey; rb.Lab = se.Lab; rb.EnumKey = attr.UIBindKey; rb.Insert(); //插入数据. } rbs.Retrieve(FrmRBAttr.FK_MapData, this.FK_MapData, FrmRBAttr.KeyOfEn, this.KeyOfEn); } //加入单选按钮. ds.Tables.Add(rbs.ToDataTableField("Sys_FrmRB")); return(BP.Tools.Json.ToJson(ds)); }
void btn_Save_Click(object sender, EventArgs e) { Button btn = sender as Button; try { MapM2M m2m = new MapM2M(this.FK_MapData, this.NoOfObj); m2m = (MapM2M)this.Pub1.Copy(m2m); m2m.FK_MapData = this.FK_MapData; m2m.ShowWay = (FrmShowWay)this.Pub1.GetDDLByID("DDL_ShowWay").SelectedItemIntVal; m2m.FK_MapData = this.FK_MapData; if (string.IsNullOrEmpty(m2m.NoOfObj)) { m2m.NoOfObj = this.NoOfObj; } if (string.IsNullOrEmpty(m2m.NoOfObj)) { m2m.NoOfObj = DataType.ParseStringToPinyin(m2m.Name); } GroupFields gfs = new GroupFields(m2m.FK_MapData); m2m.GroupID = this.Pub1.GetDDLByID("DDL_GroupField").SelectedItemIntVal; m2m.HisM2MType = M2MType.M2M; m2m.Save(); if (btn.ID.Contains("AndC")) { this.WinClose(); return; } this.Response.Redirect("MapM2M.aspx?DoType=Edit&NoOfObj=" + m2m.NoOfObj + "&FK_MapData=" + this.FK_MapData, true); } catch (Exception ex) { this.Alert(ex.Message); } }
public override object Do() { GroupFields gfs = new GroupFields(); gfs.RetrieveAll(); int delNum = 0; foreach (GroupField item in gfs) { int num = 0; num += DBAccess.RunSQLReturnValInt("SELECT COUNT(*) FROM Sys_MapAttr WHERE GroupID='" + item.OID + "' and FK_MapData='" + item.FrmID + "'"); //num += DBAccess.RunSQLReturnValInt("SELECT COUNT(*) FROM Sys_FrmAttachment WHERE GroupID=" + item.OID + " and FK_MapData='" + item.EnName + "'"); //num += DBAccess.RunSQLReturnValInt("SELECT COUNT(*) FROM Sys_MapDtl WHERE GroupID=" + item.OID + " and FK_MapData='" + item.EnName + "'"); //num += DBAccess.RunSQLReturnValInt("SELECT COUNT(*) FROM Sys_MapFrame WHERE GroupID=" + item.OID + " and FK_MapData='" + item.EnName + "'"); if (num == 0) { delNum++; item.Delete(); } } return("执行成功,删除数量:" + delNum); }
protected override DataSourceSelectArguments CreateDataSourceSelectArguments() { var arguments = base.CreateDataSourceSelectArguments(); if (GroupFields != null && GroupFields.Count > 0) { var order = GroupFields.Aggregate( string.Empty, (current, g) => (current == string.Empty ? string.Empty : current + ",") + g.GroupField + (g.Ascending ? string.Empty : " desc")); if (string.IsNullOrEmpty(arguments.SortExpression)) { arguments.SortExpression = order; } else { arguments.SortExpression += "," + order; } } if (string.IsNullOrEmpty(arguments.SortExpression)) { arguments.SortExpression = SortExpression ?? string.Empty; } else { arguments.SortExpression += "," + SortExpression; } if (!string.IsNullOrEmpty(DefaultSortExpression)) { arguments.SortExpression = string.IsNullOrEmpty(arguments.SortExpression) ? DefaultSortExpression : arguments.SortExpression + "," + DefaultSortExpression; } return(arguments); }
protected void Page_Load(object sender, EventArgs e) { this.Title = "字段复制"; BP.WF.Node nd = new BP.WF.Node(this.FK_Node); BP.WF.Nodes nds = new BP.WF.Nodes(nd.FK_Flow); Node sNd = new Node(this.NodeOfSelect); MapAttrs attrs = new MapAttrs(this.NodeOfSelect); MapAttrs attrsCopy = new MapAttrs(this.FK_Node); this.Pub1.AddFieldSet("选择节点"); this.Pub1.AddUL("Main"); foreach (BP.WF.Node en in nds) { if (this.NodeOfSelect == en.NodeID.ToString()) { this.Pub1.AddLiB("CopyFieldFromNode.aspx?FK_Node=" + this.FK_Node + "&NodeOfSelect=ND" + en.NodeID, "步骤:" + en.Step + ",名称:" + en.Name); } else { this.Pub1.AddLi("CopyFieldFromNode.aspx?FK_Node=" + this.FK_Node + "&NodeOfSelect=ND" + en.NodeID, "步骤:" + en.Step + ",名称:" + en.Name); } } this.Pub1.AddULEnd(); this.Pub1.AddFieldSetEnd(); this.Pub2.AddTable("width='500px'"); //this.Pub2.AddTR(); //this.Pub2.AddTDTitle(this.ToE("Field", "字段")); ////this.Pub2.AddTDTitle("描述"); ////this.Pub2.AddTDTitle("类型"); ////this.Pub2.AddTDTitle(this.ToE("Show", "显示")); //this.Pub2.AddTREnd(); GroupFields gfs = new GroupFields(this.NodeOfSelect); MapDtls dtls = new MapDtls(this.NodeOfSelect); MapM2Ms m2ms = new MapM2Ms(this.NodeOfSelect); MapFrames frms = new MapFrames(this.NodeOfSelect); bool isHave = false; foreach (GroupField gf in gfs) { this.Pub2.AddTRSum(); CheckBox cb = new CheckBox(); cb.ID = "CB" + gf.OID; cb.Text = "<b>" + gf.Lab + "</b>"; this.Pub2.AddTD(cb); this.Pub2.AddTREnd(); foreach (MapDtl dtl in dtls) { if (dtl.GroupID != gf.OID) { continue; } this.Pub2.AddTR(); cb = new CheckBox(); cb.ID = "CB" + dtl.No + "_" + dtl.GroupID; cb.Text = "从表:" + dtl.Name; this.Pub2.AddTD(cb); this.Pub2.AddTREnd(); } foreach (MapM2M m2m in m2ms) { if (m2m.GroupID != gf.OID) { continue; } this.Pub2.AddTR(); cb = new CheckBox(); cb.ID = "CB" + m2m.MyPK + "_" + m2m.GroupID; cb.Text = "多选" + ":" + m2m.Name; this.Pub2.AddTD(cb); this.Pub2.AddTREnd(); } foreach (MapFrame frm in frms) { if (frm.GroupID != gf.OID) { continue; } this.Pub2.AddTR(); cb = new CheckBox(); cb.ID = "CB" + frm.MyPK + "_" + frm.GroupID; cb.Text = "框架" + ":" + frm.Name; this.Pub2.AddTD(cb); this.Pub2.AddTREnd(); } this.Pub2.AddTR(); this.Pub2.AddTDBigDocBegain(); foreach (MapAttr attr in attrs) { if (gf.OID != attr.GroupID) { continue; } switch (attr.KeyOfEn) { case BP.WF.GEStartWorkAttr.CDT: case BP.WF.GEStartWorkAttr.Emps: case BP.WF.GEStartWorkAttr.FID: case BP.WF.GEStartWorkAttr.OID: case BP.WF.GEStartWorkAttr.RDT: case BP.WF.GEStartWorkAttr.Rec: case BP.WF.GEStartWorkAttr.FK_NY: case BP.WF.GEStartWorkAttr.WFState: case BP.WF.GEStartWorkAttr.MyNum: case BP.WF.GEStartWorkAttr.FK_Dept: case BP.WF.GEStartWorkAttr.FK_DeptText: continue; default: break; } cb = new CheckBox(); cb.ID = attr.KeyOfEn; cb.Text = attr.KeyOfEn + " " + attr.Name; if (attrsCopy.Contains(MapAttrAttr.KeyOfEn, attr.KeyOfEn)) { cb.Enabled = false; } else { cb.Enabled = true; } isHave = true; this.Pub2.Add(cb); } this.Pub2.AddTDEnd(); this.Pub2.AddTREnd(); } this.Pub2.AddTableEndWithBR(); Button btn = new Button(); btn.CssClass = "Btn"; if (isHave == false) { return; } this.Pub2.Add("到分组:"); gfs = new GroupFields(this.FK_Node); BP.Web.Controls.DDL ddl = new BP.Web.Controls.DDL(); ddl.ID = "DDL_GroupField"; ddl.Bind(gfs, GroupFieldAttr.OID, GroupFieldAttr.Lab); ddl.SetSelectItem(this.GroupField); this.Pub2.Add(ddl); btn.ID = "Btn_OK"; btn.Text = " 复制 "; btn.UseSubmitBehavior = false; btn.OnClientClick = "this.disabled=true;"; //this.disabled='disabled'; return true;"; // btn.Attributes["onclick"] = " return confirm('您确定要复制选择的字段到 [" + nd.Name + "]表单中吗?');"; // btn.Attributes["onclick"] = " return confirm('" + this.ToE("AYS", "您确定要复制选择的字段到 [" + nd.Name + "]表单中吗?") + "');"; btn.Click += new EventHandler(btn_Copy_Click); this.Pub2.Add(btn); }
public void EditBeforeEnd(MapAttr mapAttr) { #region 字段分组 this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("字段分组"); DDL ddlGroup = new DDL(); ddlGroup.ID = "DDL_GroupID"; GroupFields gfs = new GroupFields(mapAttr.FK_MapData); ddlGroup.Bind(gfs, GroupFieldAttr.OID, GroupFieldAttr.Lab); if (mapAttr.GroupID == 0) { mapAttr.GroupID = this.GroupField; } ddlGroup.SetSelectItem(mapAttr.GroupID); this.Pub1.AddTD("colspan=3", ddlGroup); this.Pub1.AddTREnd(); #endregion 字段分组 #region 是否是数字签名字段 if (mapAttr.UIIsEnable == false && mapAttr.MyDataType == DataType.AppString && mapAttr.LGType == FieldTypeS.Normal) { this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); CheckBox cb = new CheckBox(); cb.ID = "CB_IsSigan"; cb.Text = "是否是数字签名字段"; cb.Checked = mapAttr.IsSigan; this.Pub1.AddTD("colspan=3", cb); this.Pub1.AddTREnd(); } #endregion 字段分组 this.Pub1.AddTRSum(); this.Pub1.Add("<TD colspan=4 align=center>"); Button btn = new Button(); btn.ID = "Btn_Save"; btn.CssClass = "Btn"; btn.Text = " 保存 "; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_SaveAndClose"; btn.CssClass = "Btn"; btn.Text = "保存并关闭"; // "保存并关闭"; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); btn = new Button(); btn.CssClass = "Btn"; btn.ID = "Btn_SaveAndNew"; btn.Text = "保存新建"; // "保存新建"; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); if (this.RefNo != null) { //btn = new Button(); //btn.ID = "Btn_AutoFull"; //btn.Text ="扩展设置"; //btn.Attributes["onclick"] = "javascript:WinOpen('AutoFull.aspx?RefNo=" + this.RefNo + "&FK_MapData=" + mapAttr.FK_MapData + "',''); return false;"; this.Pub1.Add("<input type=button class=Btn value='扩展设置' onclick=\"javascript:WinOpen('AutoFull.aspx?RefNo=" + this.RefNo + "&FK_MapData=" + mapAttr.FK_MapData + "',''); return false;\" />"); if (mapAttr.HisEditType == EditType.Edit) { btn = new Button(); btn.ID = "Btn_Del"; btn.CssClass = "Btn"; btn.Text = "删除"; btn.Click += new EventHandler(btn_Save_Click); btn.Attributes["onclick"] = " return confirm('您确认吗?');"; this.Pub1.Add(btn); } } string url = "Do.aspx?DoType=AddF&MyPK=" + mapAttr.FK_MapData + "&IDX=" + mapAttr.IDX; btn = new Button(); btn.ID = "Btn_New"; btn.CssClass = "Btn"; btn.Text = "新建"; btn.Click += new EventHandler(btn_Click); this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_Back"; btn.CssClass = "Btn"; btn.Text = "返回"; btn.Click += new EventHandler(btn_Click); this.Pub1.Add(btn); // this.Pub1.Add("<input type=button value='" + + "' onclick=\"window.location.href='" + url + "'\" >"); // this.Pub1.Add("<a href='" + url + "'><img src='/WF/Img/Btn/New.gif' border=0>新建</a></TD>"); this.Pub1.AddTREnd(); this.Pub1.AddTableEndWithBR(); }
public Request<Group[]> GetById( int[] groupIds , GroupFields fields ) { var req = new Request<Group[]>{ MethodName = "groups.getById", Parameters = new Dictionary<string, string> { { "group_ids", (groupIds??new int[]{}).ToNCStringA()}, { "fields", String.Join( ",", MiscTools.GetGroupFields( fields ) )}, } }; if (_parent.IsLogged) req.Token = _parent.CurrentToken; return req; }
public void BindEdit(MapData md, MapDtl dtl) { this.Pub1.AddTable(); this.Pub1.AddCaptionLeft("从表属性"); this.Pub1.AddTR(); this.Pub1.AddTDTitle("ID"); this.Pub1.AddTDTitle("项目"); this.Pub1.AddTDTitle("采集"); this.Pub1.AddTDTitle("备注"); this.Pub1.AddTREnd(); int idx = 1; this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("表英文名称"); TB tb = new TB(); tb.ID = "TB_No"; tb.Text = dtl.No; if (this.DoType == "Edit") { tb.Enabled = false; } this.Pub1.AddTD(tb); this.Pub1.AddTD(); //this.Pub1.AddTD("英文名称全局唯一"); this.Pub1.AddTREnd(); this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("表中文名称"); tb = new TB(); tb.ID = "TB_Name"; tb.Text = dtl.Name; this.Pub1.AddTD(tb); this.Pub1.AddTD("XX 从表"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("物理表名"); tb = new TB(); tb.ID = "TB_PTable"; tb.Text = dtl.PTable; this.Pub1.AddTD(tb); this.Pub1.AddTD(); //this.Pub1.AddTD("存储数据的物理表名称"); // this.Pub1.AddTD("存储数据的物理表名称"); this.Pub1.AddTREnd(); this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("操作权限"); DDL ddl = new DDL(); ddl.BindSysEnum(MapDtlAttr.DtlOpenType, (int)dtl.DtlOpenType); ddl.ID = "DDL_DtlOpenType"; this.Pub1.AddTD(ddl); this.Pub1.AddTD(); // this.Pub1.AddTD("用于从表的权限控制"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); CheckBox cb = new CheckBox(); cb.ID = "CB_IsView"; cb.Text = "是否可见"; cb.Checked = dtl.IsView; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_IsUpdate"; cb.Text = "是否可以修改行"; // "是否可以修改行"; cb.Checked = dtl.IsUpdate; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_IsInsert"; cb.Text = "是否可以新增行"; // "是否可以新增行"; cb.Checked = dtl.IsInsert; this.Pub1.AddTD(cb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_IsDelete"; cb.Text = "是否可以删除行"; // "是否可以删除行"; cb.Checked = dtl.IsDelete; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_IsShowIdx"; cb.Text = "是否显示序号列"; //"是否显示序号列"; cb.Checked = dtl.IsShowIdx; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_IsShowSum"; cb.Text = "是否合计行";// "是否合计行"; cb.Checked = dtl.IsShowSum; this.Pub1.AddTD(cb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_IsShowTitle"; cb.Text = "是否显示标头";// "是否显示标头"; cb.Checked = dtl.IsShowTitle; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_IsExp"; cb.Text = "是否可以导出?";// "是否可以导出"; cb.Checked = dtl.IsShowTitle; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_IsImp"; cb.Text = "是否可以导入?";// "是否可以导出"; cb.Checked = dtl.IsShowTitle; this.Pub1.AddTD(cb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_IsCopyNDData"; cb.Text = "是允许从上一个节点Copy数据"; cb.Checked = dtl.IsCopyNDData; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_IsHLDtl"; cb.Text = "是否是合流汇总从表(当前节点是合流节点有效)"; cb.Checked = dtl.IsHLDtl; this.Pub1.AddTD("colspan=2", cb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_IsEnableAthM"; cb.Text = "是否启用多附件"; cb.Checked = dtl.IsEnableAthM; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_" + MapDtlAttr.IsEnableM2M; cb.Text = "是否启用一对多"; cb.Checked = dtl.IsEnableM2M; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_" + MapDtlAttr.IsEnableM2MM; cb.Text = "是否启用一对多多"; cb.Checked = dtl.IsEnableM2MM; this.Pub1.AddTD(cb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_IsEnablePass"; cb.Text = "是否起用审核字段?";// "是否合计行"; cb.Checked = dtl.IsEnablePass; this.Pub1.AddTD(cb); this.Pub1.AddTD(); this.Pub1.AddTD(); this.Pub1.AddTREnd(); //cb = new CheckBox(); //cb.ID = "CB_IsEnableAth"; //cb.Text = "是否启用单附件"; //cb.Checked = dtl.IsEnablePass; //this.Pub1.AddTD(cb); //this.Pub1.AddTREnd(); this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("初始化行数"); tb = new TB(); tb.ID = "TB_RowsOfList"; tb.Attributes["class"] = "TBNum"; tb.TextExtInt = dtl.RowsOfList; this.Pub1.AddTD(tb); this.Pub1.AddTD(""); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("显示格式"); ddl = new DDL(); ddl.ID = "DDL_DtlShowModel"; ddl.BindSysEnum(MapDtlAttr.DtlShowModel, (int)dtl.HisDtlShowModel); this.Pub1.AddTD(ddl); this.Pub1.AddTD(); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("越出处理"); ddl = new DDL(); ddl.ID = "DDL_WhenOverSize"; ddl.BindSysEnum(MapDtlAttr.WhenOverSize, (int)dtl.HisWhenOverSize); this.Pub1.AddTD(ddl); this.Pub1.AddTD(); this.Pub1.AddTREnd(); GroupFields gfs = new GroupFields(md.No); if (gfs.Count > 1) { this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("显示在分组"); ddl = new DDL(); ddl.ID = "DDL_GroupField"; ddl.BindEntities(gfs, GroupFieldAttr.OID, GroupFieldAttr.Lab, false, AddAllLocation.None); ddl.SetSelectItem(dtl.GroupID); this.Pub1.AddTD("colspan=2", ddl); this.Pub1.AddTREnd(); } if (gfs.Count > 1) { this.Pub1.AddTR(); } else { this.Pub1.AddTR1(); } this.Pub1.AddTRSum(); this.Pub1.AddTD(""); this.Pub1.AddTDBegin("colspan=3 align=center"); Button btn = new Button(); btn.ID = "Btn_Save"; btn.CssClass = "Btn"; btn.Text = " 保存 "; btn.Click += new EventHandler(btn_Click); this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_SaveAndClose"; btn.CssClass = "Btn"; btn.Text = " 保存并关闭 "; btn.Click += new EventHandler(btn_Click); this.Pub1.Add(btn); if (this.FK_MapDtl != null) { //btn = new Button(); //btn.ID = "Btn_D"; //btn.Text = this.ToE("DesignSheet", "设计表单"); // "设计表单"; //btn.Click += new EventHandler(btn_Go_Click); //this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_Del"; btn.CssClass = "Btn"; btn.Text = "删除"; // "删除"; btn.Attributes["onclick"] = " return confirm('您确认吗?');"; btn.Click += new EventHandler(btn_Del_Click); this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_New"; btn.CssClass = "Btn"; btn.Text = "新建"; // "删除"; btn.Click += new EventHandler(btn_New_Click); this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_MapExt"; btn.CssClass = "Btn"; btn.Text = "扩展设置"; // "删除"; btn.Click += new EventHandler(btn_MapExt_Click); this.Pub1.Add(btn); if (dtl.IsEnableAthM) { btn = new Button(); btn.CssClass = "Btn"; btn.ID = "Btn_IsEnableAthM"; btn.Text = "附件属性"; // "删除"; btn.Click += new EventHandler(btn_MapAth_Click); this.Pub1.Add(btn); } // btn = new Button(); // btn.ID = "Btn_DtlTR"; // btn.Text = "多表头"; // btn.Attributes["onclick"] = "javascript:WinOpen('')"; //// btn.Click += new EventHandler(btn_DtlTR_Click); // this.Pub1.Add(btn); } this.Pub1.AddTDEnd(); this.Pub1.AddTREnd(); this.Pub1.AddTableEnd(); }
public void BindEdit(MapData md, MapDtl dtl) { bool isItem = false; this.Pub1.AddTable(); this.Pub1.AddTR(); this.Pub1.AddTDTitle("ID"); this.Pub1.AddTDTitle("colspan=3", "基本设置"); this.Pub1.AddTREnd(); int idx = 1; isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("表英文名称"); TB tb = new TB(); tb.ID = "TB_No"; tb.Text = dtl.No; if (this.DoType == "Edit") { tb.Enabled = false; } tb.Columns = 40; this.Pub1.AddTD("colspan=2", tb); this.Pub1.AddTREnd(); isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("表中文名称"); tb = new TB(); tb.ID = "TB_Name"; tb.Text = dtl.Name; tb.Columns = 40; this.Pub1.AddTD("colspan=2", tb); this.Pub1.AddTREnd(); isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("物理表名"); tb = new TB(); tb.ID = "TB_PTable"; tb.Text = dtl.PTable; tb.Columns = 40; this.Pub1.AddTD("colspan=2", tb); this.Pub1.AddTREnd(); DDL ddl = new DDL(); isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("工作模式"); DDL workModelDDl = new DDL(); workModelDDl.BindSysEnum(MapDtlAttr.Model, (int)dtl.DtlModel); workModelDDl.ID = "DDL_Model"; this.Pub1.AddTD(workModelDDl); this.Pub1.AddTD(); this.Pub1.AddTREnd(); if (dtl.DtlModel == DtlModel.FixRow) { tb = new TB(); tb.ID = "TB_" + MapDtlAttr.ImpFixTreeSql; tb.Text = dtl.ImpFixTreeSql; tb.Columns = 80; isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("树形结构数据源"); this.Pub1.AddTD("colspan=2", tb); this.Pub1.AddTREnd(); tb = new TB(); tb.ID = "TB_" + MapDtlAttr.ImpFixDataSql; tb.Text = dtl.ImpFixDataSql; tb.Columns = 80; this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("明细表数据源"); this.Pub1.AddTD("colspan=2", tb); this.Pub1.AddTREnd(); } #region 权限控制. CheckBox cb = new CheckBox(); isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); cb.ID = "CB_IsView"; cb.Text = "是否可见"; cb.Checked = dtl.IsView; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_IsUpdate"; cb.Text = "是否可以修改行"; // "是否可以修改行"; cb.Checked = dtl.IsUpdate; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_IsInsert"; cb.Text = "是否可以新增行"; // "是否可以新增行"; cb.Checked = dtl.IsInsert; this.Pub1.AddTD(cb); this.Pub1.AddTREnd(); isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_IsDelete"; cb.Text = "是否可以删除行"; // "是否可以删除行"; cb.Checked = dtl.IsDelete; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_IsShowIdx"; cb.Text = "是否显示序号列"; //"是否显示序号列"; cb.Checked = dtl.IsShowIdx; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_IsShowSum"; cb.Text = "是否合计行";// "是否合计行"; cb.Checked = dtl.IsShowSum; this.Pub1.AddTD(cb); this.Pub1.AddTREnd(); isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_IsEnableAthM"; cb.Text = "是否启用多附件"; cb.Checked = dtl.IsEnableAthM; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_" + MapDtlAttr.IsEnableM2M; cb.Text = "是否启用一对多"; cb.Checked = dtl.IsEnableM2M; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_" + MapDtlAttr.IsEnableM2MM; cb.Text = "是否启用一对多多"; cb.Checked = dtl.IsEnableM2MM; this.Pub1.AddTD(cb); this.Pub1.AddTREnd(); isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_" + MapDtlAttr.IsRowLock; cb.Text = "是否启用锁定行(如果启用就需要增加IsRowLock一个隐藏的列,默认值为0。)?";// "是否合计行"; cb.Checked = dtl.IsRowLock; this.Pub1.AddTD("colspan=3", cb); this.Pub1.AddTREnd(); isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_" + MapDtlAttr.IsShowTitle; cb.Text = "是否显示标头(如果是多表表头的明细表,就不要显示表头了)?";; cb.Checked = dtl.IsShowTitle; this.Pub1.AddTD("colspan=3", cb); this.Pub1.AddTREnd(); #endregion 权限控制. //this.Pub1.AddTR(); //this.Pub1.AddTDIdx(idx++); //cb = new CheckBox(); //cb.ID = "CB_IsShowTitle"; //cb.Text = "是否显示标头";// "是否显示标头"; //cb.Checked = dtl.IsShowTitle; //this.Pub1.AddTD(cb); //this.Pub1.AddTREnd(); //cb = new CheckBox(); //cb.ID = "CB_IsEnableAth"; //cb.Text = "是否启用单附件"; //cb.Checked = dtl.IsEnablePass; //this.Pub1.AddTD(cb); //this.Pub1.AddTREnd(); //为精英修改. isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("增加记录方式"); ddl = new DDL(); ddl.ID = "DDL_DtlAddRecModel"; ddl.BindSysEnum(MapDtlAttr.DtlAddRecModel, (int)dtl.DtlAddRecModel); this.Pub1.AddTD(ddl); this.Pub1.AddTD("满足不同的用户习惯"); this.Pub1.AddTREnd(); isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("初始化行数"); tb = new TB(); tb.ID = "TB_RowsOfList"; tb.Attributes["class"] = "TBNum"; tb.TextExtInt = dtl.RowsOfList; this.Pub1.AddTD(tb); this.Pub1.AddTD(""); this.Pub1.AddTREnd(); isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("显示格式"); ddl = new DDL(); ddl.ID = "DDL_DtlShowModel"; ddl.BindSysEnum(MapDtlAttr.DtlShowModel, (int)dtl.HisDtlShowModel); this.Pub1.AddTD(ddl); this.Pub1.AddTD(); this.Pub1.AddTREnd(); isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("越出处理"); ddl = new DDL(); ddl.ID = "DDL_WhenOverSize"; ddl.BindSysEnum(MapDtlAttr.WhenOverSize, (int)dtl.HisWhenOverSize); this.Pub1.AddTD(ddl); this.Pub1.AddTD(); this.Pub1.AddTREnd(); isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("存盘方式"); ddl = new DDL(); ddl.ID = "DDL_DtlSaveModel"; ddl.BindSysEnum(MapDtlAttr.DtlSaveModel, (int)dtl.DtlSaveModel); this.Pub1.AddTD(ddl); this.Pub1.AddTD("用于设置在明细表自动存盘还是,手动存盘."); this.Pub1.AddTREnd(); #region 与工作流相关设置. if (this.FK_Node != 0) { this.Pub1.AddTRSum(); this.Pub1.AddTDTitle("colspan=4", "与工作流相关设置"); this.Pub1.AddTREnd(); this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("操作权限"); ddl = new DDL(); ddl.BindSysEnum(MapDtlAttr.DtlOpenType, (int)dtl.DtlOpenType); ddl.ID = "DDL_DtlOpenType"; this.Pub1.AddTD(ddl); this.Pub1.AddTD(); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_IsEnablePass"; cb.Text = "是否起用审核字段?";// "是否合计行"; cb.Checked = dtl.IsEnablePass; this.Pub1.AddTD(cb); // string sql = "SELECT KeyOfEn as No, Name FROM Sys_MapAttr WHERE FK_MapData='" + dtl.No + "' AND ((MyDataType in (1,4,6) and UIVisible=1 ) or (UIContralType=1))"; string sql = "SELECT KeyOfEn as No, Name FROM Sys_MapAttr WHERE FK_MapData='" + dtl.No + "'"; DataTable dt = DBAccess.RunSQLReturnTable(sql); if (dt.Rows.Count == 0) { this.Pub1.AddTD(); this.Pub1.AddTD(); } else { this.Pub1.AddTDBegin("colspan=2"); cb = new CheckBox(); cb.ID = "CB_IsEnableGroupField"; cb.Text = "是否起用分组字段?";// "是否合计行"; cb.Checked = dtl.IsEnableGroupField; this.Pub1.Add(cb); ddl = new DDL(); ddl.ID = "DDL_GroupField"; ddl.BindSQL(sql, "No", "Name", dtl.GroupField); this.Pub1.Add(ddl); this.Pub1.AddTDEnd(); } this.Pub1.AddTREnd(); this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_IsCopyNDData"; cb.Text = "是允许从上一个节点Copy数据"; cb.Checked = dtl.IsCopyNDData; this.Pub1.AddTD("colspan=3", cb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_IsHLDtl"; cb.Text = "是否是合流汇总从表(当前节点是合流节点有效)"; cb.Checked = dtl.IsHLDtl; this.Pub1.AddTD("colspan=3", cb); this.Pub1.AddTREnd(); #region 与分流点发送到子线程,处理子线程处理人相关的设置. for yangtai . this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_IsFLDtl"; cb.Text = "是否是分流点从表(当前节点是分流节点有效)"; cb.Checked = dtl.IsFLDtl; this.Pub1.AddTD("colspan=3", cb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("子线程处理人字段"); sql = "SELECT KeyOfEn as No, Name FROM Sys_MapAttr WHERE FK_MapData='" + dtl.No + "' AND ( (MyDataType =1 and UIVisible=1 ) or (UIContralType=1))"; dt = DBAccess.RunSQLReturnTable(sql); ddl = new DDL(); ddl.ID = "DDL_SubThreadWorker"; ddl.BindSQL(sql, "No", "Name", dtl.SubThreadWorker); this.Pub1.AddTD("colspan=2", ddl); this.Pub1.AddTDEnd(); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("子线程批次号字段"); DataRow dr = dt.NewRow(); dr[0] = ""; dr[1] = "无"; dt.Rows.Add(dr); ddl = new DDL(); ddl.ID = "DDL_SubThreadGroupMark"; ddl.BindSQL(sql, "No", "Name", dtl.SubThreadGroupMark); this.Pub1.AddTD("colspan=2", ddl); this.Pub1.AddTDEnd(); this.Pub1.AddTREnd(); } #endregion 与分流点发送到子线程,处理子线程处理人相关的设置. for yangtai . #endregion 与工作流相关设置. #region 明细表的数据导入导出. this.Pub1.AddTRSum(); this.Pub1.AddTDTitle("colspan=4", "数据导入导出"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_IsExp"; cb.Text = "是否可以导出?";// "是否可以导出"; cb.Checked = dtl.IsExp; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_IsImp"; cb.Text = "是否可以导入?";// "是否可以导出"; cb.Checked = dtl.IsImp; this.Pub1.AddTD(cb); this.Pub1.AddTD(); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_" + MapDtlAttr.IsEnableSelectImp; cb.Text = "是否启用选择性导入(如果true就要配置数据源呈现的sql)?"; cb.Checked = dtl.IsEnableSelectImp; this.Pub1.AddTD("colspan=3", cb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("初始化SQL"); tb = new TB(); tb.ID = "TB_" + MapDtlAttr.ImpSQLInit; tb.Text = dtl.ImpSQLInit; tb.Columns = 80; this.Pub1.AddTD("colspan=2", tb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("查询SQL"); tb = new TB(); tb.ID = "TB_" + MapDtlAttr.ImpSQLSearch; tb.Text = dtl.ImpSQLSearch; tb.Columns = 80; this.Pub1.AddTD("colspan=2", tb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("填充SQL"); tb = new TB(); tb.ID = "TB_" + MapDtlAttr.ImpSQLFull; tb.Text = dtl.ImpSQLFull; tb.Columns = 80; this.Pub1.AddTD("colspan=2", tb); this.Pub1.AddTREnd(); #endregion 明细表的数据导入导出. #region 超连接. this.Pub1.AddTRSum(); this.Pub1.AddTDTitle("colspan=4", "表格右边列超连接配置"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_" + MapDtlAttr.IsEnableLink; cb.Text = "是否启用超连接?"; cb.Checked = dtl.IsEnableLink; this.Pub1.AddTD(cb); this.Pub1.AddTD("超连接标签"); tb = new TB(); tb.ID = "TB_" + MapDtlAttr.LinkLabel; tb.Text = dtl.LinkLabel; this.Pub1.AddTD(tb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("colspan=3", "连接URL"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); tb = new TB(); tb.ID = "TB_" + MapDtlAttr.LinkUrl; tb.Text = dtl.LinkUrl; tb.Columns = 90; this.Pub1.AddTD("colspan=3", tb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("连接目标"); tb = new TB(); tb.ID = "TB_" + MapDtlAttr.LinkTarget; tb.Text = dtl.LinkTarget; this.Pub1.AddTD("colspan=2", tb); this.Pub1.AddTREnd(); #endregion 超连接. GroupFields gfs = new GroupFields(md.No); if (gfs.Count > 1) { this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("显示在分组"); ddl = new DDL(); ddl.ID = "DDL_GroupID"; ddl.BindEntities(gfs, GroupFieldAttr.OID, GroupFieldAttr.Lab, false, AddAllLocation.None); ddl.SetSelectItem(dtl.GroupID); this.Pub1.AddTD("colspan=2", ddl); this.Pub1.AddTREnd(); } if (gfs.Count > 1) { this.Pub1.AddTR(); } else { this.Pub1.AddTR1(); } this.Pub1.AddTRSum(); this.Pub1.AddTD(""); this.Pub1.AddTDBegin("colspan=3 align=center"); Button btn = new Button(); btn.ID = "Btn_Save"; btn.CssClass = "Btn"; btn.Text = " 保存 "; btn.Click += new EventHandler(btn_Click); this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_SaveAndClose"; btn.CssClass = "Btn"; btn.Text = " 保存并关闭 "; btn.Click += new EventHandler(btn_Click); this.Pub1.Add(btn); if (this.FK_MapDtl != null) { //btn = new Button(); //btn.ID = "Btn_D"; //btn.Text = this.ToE("DesignSheet", "设计表单"); // "设计表单"; //btn.Click += new EventHandler(btn_Go_Click); //this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_Del"; btn.CssClass = "Btn"; btn.Text = "删除"; // "删除"; btn.Attributes["onclick"] = " return confirm('您确认吗?');"; btn.Click += new EventHandler(btn_Del_Click); this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_New"; btn.CssClass = "Btn"; btn.Text = "新建"; // "删除"; btn.Click += new EventHandler(btn_New_Click); this.Pub1.Add(btn); //btn = new Button(); //btn.ID = "Btn_MapExt"; //btn.CssClass = "Btn"; //btn.Text = "扩展设置"; // "删除"; //btn.Click += new EventHandler(btn_MapExt_Click); //this.Pub1.Add(btn); if (dtl.IsEnableAthM) { btn = new Button(); btn.CssClass = "Btn"; btn.ID = "Btn_IsEnableAthM"; btn.Text = "附件属性"; // "删除"; btn.Click += new EventHandler(btn_MapAth_Click); this.Pub1.Add(btn); } // btn = new Button(); // btn.ID = "Btn_DtlTR"; // btn.Text = "多表头"; // btn.Attributes["onclick"] = "javascript:WinOpen('')"; //// btn.Click += new EventHandler(btn_DtlTR_Click); // this.Pub1.Add(btn); } this.Pub1.AddTDEnd(); this.Pub1.AddTREnd(); this.Pub1.AddTableEnd(); }
protected void Page_Load(object sender, EventArgs e) { this.Title = "字段分组"; switch (this.DoType) { case "FunList": this.Pub1.AddFieldSet("字段分组向导"); this.Pub1.AddUL(); this.Pub1.AddLi("<b><a href='GroupField.aspx?DoType=NewGroup&RefNo=" + this.RefNo + "'>新建空白字段分组</a></b><br><font color=green>空白字段分组,建立后可以把相关的字段放入此分组里。</font>"); this.Pub1.AddLi("<b><a href='GroupField.aspx?DoType=NewCheckGroup&RefNo=" + this.RefNo + "'>新建审核分组</a></b><br><font color=green>系统会让您输入审核的信息,并创建审核分组。</font>"); this.Pub1.AddLi("<b><a href='GroupField.aspx?DoType=NewEvalGroup&RefNo=" + this.RefNo + "'>创建工作质量考核字段分组</a></b><br><font color=green>创建质量考核: EvalEmpNo,EvalEmpName,EvalCent,EvalNote 4个必要的字段。</font>"); this.Pub1.AddULEnd(); this.Pub1.AddFieldSetEnd(); return; case "NewCheckGroup": this.Pub1.AddFieldSet("<a href=GroupField.aspx?DoType=FunList&RefNo=" + this.RefNo + " >字段分组向导</a> - " + "审核分组"); TB tbc = new TB(); tbc.ID = "TB_Sta"; this.Pub1.Add("审核岗位<font color=red>*</font>"); this.Pub1.Add(tbc); this.Pub1.AddBR("<font color=green>比如:分局长审核、科长审核、总经理审核。</font>"); this.Pub1.AddBR(); tbc = new TB(); tbc.ID = "TB_Prx"; this.Pub1.Add("字段前缀:"); this.Pub1.Add(tbc); this.Pub1.AddBR("<font color=green>用于自动创建字段,请输入英文字母或者字母数字组合。系统自动依据您的输入产生字段。如:XXX_Note,审核意见。XXX_RDT审核时间。XXX_Checker审核人,为空系统自动用拼音表示。</font>"); this.Pub1.AddBR(); this.Pub1.AddHR(); Btn btnc = new Btn(); btnc.Click += new EventHandler(btn_Check_Click); btnc.Text = "保存"; this.Pub1.Add(btnc); this.Pub1.AddFieldSetEnd(); return; case "NewEvalGroup": GroupField gf = new GroupField(); gf.Lab = "工作质量考核"; gf.EnName = this.RefNo; gf.Insert(); MapAttr attr = new MapAttr(); attr.FK_MapData = this.RefNo; attr.KeyOfEn = BP.WF.WorkSysFieldAttr.EvalNote; attr.Name = "审核意见"; attr.MyDataType = DataType.AppString; attr.UIContralType = UIContralType.TB; attr.UIIsEnable = true; attr.UIIsLine = true; attr.MaxLen = 500; attr.GroupID = gf.OID; attr.UIHeight = 23; attr.ColSpan = 4; attr.Idx = 1; attr.Insert(); attr = new MapAttr(); attr.FK_MapData = this.RefNo; attr.KeyOfEn = BP.WF.WorkSysFieldAttr.EvalCent; attr.Name = "分值"; attr.MyDataType = DataType.AppFloat; attr.UIContralType = UIContralType.TB; attr.MaxLen = 50; attr.MinLen = 0; attr.UIIsEnable = true; attr.UIIsLine = false; attr.DefVal = "0"; attr.UIIsEnable = false; attr.GroupID = gf.OID; attr.IsSigan = true; attr.Idx = 2; attr.Insert(); attr = new MapAttr(); attr.FK_MapData = this.RefNo; attr.KeyOfEn = BP.WF.WorkSysFieldAttr.EvalEmpNo; attr.Name = "被评估人编号"; attr.MyDataType = DataType.AppString; attr.UIContralType = UIContralType.TB; attr.UIIsEnable = true; attr.UIIsLine = false; attr.DefVal = ""; attr.UIIsEnable = false; attr.GroupID = gf.OID; attr.Idx = 3; attr.Insert(); attr = new MapAttr(); attr.FK_MapData = this.RefNo; attr.KeyOfEn = BP.WF.WorkSysFieldAttr.EvalEmpName; attr.Name = "被评估人名称"; attr.MyDataType = DataType.AppString; attr.UIContralType = UIContralType.TB; attr.UIIsEnable = true; attr.UIIsLine = false; attr.DefVal = ""; attr.UIIsEnable = false; attr.GroupID = gf.OID; attr.Idx = 4; attr.Insert(); this.WinCloseWithMsg("保存成功"); // "增加成功,您可以调整它的位置与修改字段的标签。" return; case "NewGroup": GroupFields mygfs = new GroupFields(this.RefNo); GroupField gf1 = new GroupField(); gf1.Idx = mygfs.Count; gf1.Lab = "新建字段分组"; // "新建字段分组"; gf1.EnName = this.RefNo; if (gf1.IsExit(GroupFieldAttr.EnName, gf1.EnName, GroupFieldAttr.Lab, gf1.Lab) == false) { gf1.Insert(); } this.Response.Redirect("GroupField.aspx?RefNo=" + this.RefNo + "&RefOID=" + gf1.OID, true); return; default: break; } #region edit operation GroupField en = new GroupField(this.RefOID); this.Pub1.Add("<Table border=0 align=center>"); this.Pub1.AddCaptionLeft("字段分组"); this.Pub1.AddTR(); this.Pub1.AddTD("分组名称"); TB tb = new TB(); tb.ID = "TB_Lab_" + en.OID; tb.Text = en.Lab; tb.Columns = 50; this.Pub1.AddTD(tb); this.Pub1.AddTREnd(); this.Pub1.AddTRSum(); this.Pub1.Add("<TD align=center colspan=2>"); Btn btn = new Btn(); btn.Text = "保存"; btn.ID = "Btn_Save"; btn.Click += new EventHandler(btn_Click); this.Pub1.Add(btn); btn = new Btn(); btn.Text = "保存并关闭"; btn.ID = "Btn_SaveAndClose"; btn.Click += new EventHandler(btn_Click); this.Pub1.Add(btn); btn = new Btn(); btn.Text = "新建字段"; btn.ID = "Btn_NewField"; btn.Click += new EventHandler(btn_Click); this.Pub1.Add(btn); //btn = new Btn(); //btn.Text = this.ToE("CopyField", "复制字段"); //btn.ID = "Btn_CopyField"; //btn.Click += new EventHandler(btn_Click); //this.Pub1.Add(btn); btn = new Btn(); btn.Text = "删除"; btn.ID = "Btn_Delete"; btn.Click += new EventHandler(btn_del_Click); btn.Attributes["onclick"] = " return confirm('您确认吗?');"; this.Pub1.Add(btn); this.Pub1.Add("</TD>"); this.Pub1.AddTREnd(); this.Pub1.AddTableEnd(); this.Pub1.Add("把相近的字段放在一个大单元格里,只是为了显示所用没有任何计算意义。"); #endregion }
public async Task<string> GetById( int[] groupIds , GroupFields fields ){ return await _parent.Executor.ExecRawAsync( _parent._reqapi.Groups.GetById( groupIds,fields ) ).ConfigureAwait(false); }
public void BindEdit(MapData md, MapFrame dtl) { this.Pub1.AddTable(); // this.Pub1.AddCaptionLeftTX("<a href='MapDef.aspx?MyPK=" + md.No + "'>" + "返回" + ":" + md.Name + "</a> - " + this.ToE("DtlTable", "从表") + ":(" + dtl.Name + ")"); this.Pub1.AddTR(); this.Pub1.AddTDTitle("ID"); this.Pub1.AddTDTitle("项目"); this.Pub1.AddTDTitle("采集"); this.Pub1.AddTDTitle("备注"); this.Pub1.AddTREnd(); int idx = 1; this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("编号"); TB tb = new TB(); tb.ID = "TB_" + MapFrameAttr.NoOfObj; tb.Text = dtl.NoOfObj; if (this.DoType == "Edit") { tb.Enabled = false; } this.Pub1.AddTD(tb); this.Pub1.AddTD(); this.Pub1.AddTREnd(); this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("描述"); tb = new TB(); tb.ID = "TB_Name"; tb.Text = dtl.Name; tb.Columns = 50; this.Pub1.AddTD("colspan=2", tb); this.Pub1.AddTREnd(); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("框架连接"); tb = new TB(); tb.ID = "TB_URL"; tb.Text = dtl.URL; tb.Columns = 50; this.Pub1.AddTD("colspan=2", tb); this.Pub1.AddTREnd(); this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("框架宽度"); tb = new TB(); tb.ID = "TB_W"; tb.Text = dtl.W; tb.ShowType = TBType.TB; this.Pub1.AddTD(tb); this.Pub1.AddTD(); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("框架高度"); tb = new TB(); tb.ID = "TB_H"; tb.ShowType = TBType.TB; tb.Text = dtl.H; this.Pub1.AddTD(tb); this.Pub1.AddTD(); this.Pub1.AddTREnd(); this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTDBegin("colspan=3"); RadioBtn rb = new RadioBtn(); rb.Text = "指定框架宽度高度"; rb.ID = "RB_IsAutoSize_0"; rb.GroupName = "s"; if (dtl.IsAutoSize) { rb.Checked = false; } else { rb.Checked = true; } this.Pub1.Add(rb); rb = new RadioBtn(); rb.Text = "让框架自适应大小"; rb.ID = "RB_IsAutoSize_1"; rb.GroupName = "s"; if (dtl.IsAutoSize) { rb.Checked = true; } else { rb.Checked = false; } this.Pub1.Add(rb); this.Pub1.AddTDEnd(); this.Pub1.AddTREnd(); GroupFields gfs = new GroupFields(md.No); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("显示在分组"); DDL ddl = new DDL(); ddl.ID = "DDL_GroupField"; ddl.BindEntities(gfs, GroupFieldAttr.OID, GroupFieldAttr.Lab, false, AddAllLocation.None); ddl.SetSelectItem(dtl.GroupID); this.Pub1.AddTD("colspan=2", ddl); this.Pub1.AddTREnd(); this.Pub1.AddTRSum(); this.Pub1.AddTDBegin("colspan=4 align=center"); Button btn = new Button(); btn.ID = "Btn_Save"; btn.CssClass = "Btn"; btn.Text = " 保存 "; btn.Click += new EventHandler(btn_Click); this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_SaveAndClose"; btn.CssClass = "Btn"; btn.Text = " 保存并关闭 "; btn.Click += new EventHandler(btn_Click); this.Pub1.Add(btn); if (this.FK_MapFrame != null) { btn = new Button(); btn.ID = "Btn_Del"; btn.CssClass = "Btn"; btn.Text = "删除"; // "删除"; btn.Attributes["onclick"] = " return confirm('您确认吗?');"; btn.Click += new EventHandler(btn_Del_Click); this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_New"; btn.CssClass = "Btn"; btn.Text = "新建"; // "删除"; btn.Click += new EventHandler(btn_New_Click); this.Pub1.Add(btn); } this.Pub1.AddTDEnd(); this.Pub1.AddTREnd(); this.Pub1.AddTableEnd(); }
void btn_Copy_Click(object sender, EventArgs e) { BP.WF.Node nd = new BP.WF.Node(this.FK_Node); Node sNd = new Node(this.NodeOfSelect); BP.En.Attrs attrs = sNd.HisWork.EnMap.Attrs; BP.En.Attrs attrsCopy = nd.HisWork.EnMap.Attrs; // 开始copy 分组的节点。 GroupFields gfs = new GroupFields(this.NodeOfSelect); MapDtls dtls = new MapDtls(this.NodeOfSelect); MapM2Ms m2ms = new MapM2Ms(this.NodeOfSelect); MapFrames frms = new MapFrames(this.NodeOfSelect); foreach (GroupField gf in gfs) { CheckBox cb = this.Pub2.GetCBByID("CB" + gf.OID); if (cb.Checked == false) { continue; } // 生成一个分组实体. GroupField mygf = new GroupField(); mygf.Lab = gf.Lab; mygf.EnName = this.FK_Node; mygf.Idx = gf.Idx; mygf.Insert(); foreach (MapM2M m2m in m2ms) { if (m2m.GroupID != gf.OID) { continue; } MapM2M mym2m = new MapM2M(); mym2m.MyPK = m2m.MyPK.Replace(this.NodeOfSelect, this.FK_Node); // mym2m.FK_MapData =this if (mym2m.IsExits) { continue; } mym2m.Copy(m2m); mym2m.FK_MapData = this.FK_Node; mym2m.GroupID = mygf.OID; mym2m.MyPK = m2m.MyPK.Replace(this.NodeOfSelect, this.FK_Node); mym2m.Insert(); } foreach (MapFrame frm in frms) { if (frm.GroupID != gf.OID) { continue; } MapFrame myen = new MapFrame(); myen.MyPK = frm.MyPK.Replace(this.NodeOfSelect, this.FK_Node); if (myen.IsExits) { continue; } myen.Copy(frm); myen.FK_MapData = this.FK_Node; myen.GroupID = mygf.OID; myen.MyPK = frm.MyPK.Replace(this.NodeOfSelect, this.FK_Node); myen.Insert(); } // 复制从表. foreach (MapDtl dtl in dtls) { cb = this.Pub2.GetCBByID("CB_" + dtl.No + gf.OID); MapDtl dtlNew = new MapDtl(); dtlNew.No = dtl.No.Replace(this.NodeOfSelect, this.FK_Node); if (dtlNew.IsExits) { continue; } dtlNew.Copy(dtl); dtlNew.FK_MapData = this.FK_Node; dtlNew.No = dtl.No.Replace(this.NodeOfSelect, this.FK_Node); // dtlNew.No = this.FK_Node + "Dtl"; // dtlNew.No = dtl.No.Replace(this.FK_Node, this.NodeOfSelect); dtlNew.IsInsert = false; dtlNew.IsUpdate = false; dtlNew.IsDelete = false; dtlNew.GroupID = mygf.OID; dtlNew.PTable = dtlNew.No; dtlNew.Insert(); // 复制从表里面的明细。 int idx = 0; MapAttrs mattrs = new MapAttrs(dtl.No); foreach (MapAttr attr in mattrs) { MapAttr attrNew = new MapAttr(); attrNew.Copy(attr); attrNew.FK_MapData = dtlNew.No; attrNew.UIIsEnable = false; if (attrNew.DefVal.Contains("@")) { attrNew.DefVal = ""; } dtlNew.RowIdx = idx; attrNew.HisEditType = EditType.Edit; attrNew.Insert(); } } // copy his fields. MapAttrs willCopyAttrs = new MapAttrs(); willCopyAttrs.Retrieve(MapAttrAttr.GroupID, gf.OID, MapAttrAttr.Idx); int idx1 = 0; foreach (MapAttr attr in willCopyAttrs) { MapAttr attrNew = new MapAttr(); if (attrNew.IsExit(MapAttrAttr.FK_MapData, this.FK_Node, MapAttrAttr.KeyOfEn, attr.KeyOfEn) == true) { continue; } if (attr.UIVisible == false) { continue; } idx1++; attrNew.Copy(attr); attrNew.GroupID = mygf.OID; attrNew.FK_MapData = this.FK_Node; attrNew.UIIsEnable = false; attrNew.Idx = idx1; if (attrNew.KeyOfEn == "Title") { attrNew.HisEditType = EditType.Edit; } attrNew.HisEditType = EditType.Edit; attrNew.DefVal = ""; attrNew.Insert(); } } int GroupField = this.Pub2.GetDDLByID("DDL_GroupField").SelectedItemIntVal; foreach (Attr attr in attrs) { if (this.Pub2.IsExit(attr.Key) == false) { continue; } CheckBox cb = this.Pub2.GetCBByID(attr.Key); if (cb.Checked == false) { continue; } BP.Sys.MapAttr ma = new BP.Sys.MapAttr(); int i = ma.Retrieve(BP.Sys.MapAttrAttr.KeyOfEn, attr.Key, BP.Sys.MapAttrAttr.FK_MapData, this.NodeOfSelect); BP.Sys.MapAttr ma1 = new BP.Sys.MapAttr(); bool ishavle = ma1.IsExit(BP.Sys.MapAttrAttr.KeyOfEn, attr.Key, BP.Sys.MapAttrAttr.FK_MapData, this.FK_Node); if (ishavle) { continue; } ma1.Copy(ma); ma1.FK_MapData = this.FK_Node; ma1.KeyOfEn = ma.KeyOfEn; ma1.Name = ma.Name; ma1.GroupID = GroupField; ma1.UIIsEnable = false; ma1.HisEditType = EditType.Edit; if (ma1.DefVal != null && ma1.DefVal.Contains("@")) { ma1.DefVal = ""; } ma1.Insert(); } if (this.Pub2.IsExit("CB_Table")) { if (this.Pub2.GetCBByID("CB_Table").Checked) { MapData md1 = new MapData(this.NodeOfSelect); MapData md2 = new MapData(this.FK_Node); //md2.CellsX = md1.CellsX; //md2.CellsY = md1.CellsY; md2.Update(); //MapAttrs ma1 = md1.GenerHisTableCells; // 删除历史数据。 //ma1.Delete(MapAttrAttr.FK_MapData, this.FK_Node + "T"); //foreach (MapAttr attr in ma1) //{ // MapAttr attr2 = new MapAttr(); // attr2.Copy(attr); // // attr2.OID = 0; // attr2.GroupID = 0; // attr2.Idx = 0; // attr2.FK_MapData = this.FK_Node + "T"; // attr2.UIIsEnable = false; // attr2.Insert(); //} } } this.WinClose(); //this.WinCloseWithMsg("复制成功"); //this.Response.Redirect("MapDef.aspx?PK=" + this.FK_Node + "&NodeOfSelect=" + this.NodeOfSelect); }
protected void Page_Load(object sender, EventArgs e) { this.Pub1.AddTable(" width='80%' "); this.Pub1.AddCaptionLeft("隐藏字段"); this.Pub1.AddTR(); this.Pub1.AddTDTitle("IDX"); this.Pub1.AddTDTitle("字段"); this.Pub1.AddTDTitle("名称(点击编辑)"); this.Pub1.AddTDTitle("类型"); this.Pub1.AddTREnd(); MapAttrs mattrs = new MapAttrs(this.FK_MapData); GroupFields gfs = new GroupFields(this.FK_MapData); string msg = ""; int idx = 0; foreach (MapAttr attr in mattrs) { if (attr.UIVisible) { continue; } switch (attr.KeyOfEn) { case "BatchID": case "OID": case "FID": case "FK_NY": case "RefPK": case "Emps": case "FK_Dept": case "WFState": case "RDT": case "MyNum": case "Rec": case "CDT": continue; default: break; } this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD(attr.KeyOfEn); switch (attr.LGType) { case FieldTypeS.Normal: this.Pub1.AddTD("<a href=\"javascript:Edit('" + attr.FK_MapData + "','" + attr.MyPK + "','" + attr.MyDataType + "');\">" + attr.Name + "</a>"); break; case FieldTypeS.Enum: this.Pub1.AddTD("<a href=\"javascript:EditEnum('" + attr.FK_MapData + "','" + attr.MyPK + "','" + attr.MyDataType + "');\">" + attr.Name + "</a>"); break; case FieldTypeS.FK: this.Pub1.AddTD("<a href=\"javascript:EditTable('" + attr.FK_MapData + "','" + attr.MyPK + "','" + attr.MyDataType + "');\">" + attr.Name + "</a>"); break; default: break; } this.Pub1.AddTD(attr.LGType.ToString()); this.Pub1.AddTREnd(); } this.Pub1.AddTableEndWithHR(); return; this.Pub1.AddFieldSet("编辑隐藏字段"); this.Pub1.Add("说明:隐藏字段是不显示在表单里面,多用于属性的计算、方向条件的设置,报表的体现。"); this.Pub1.AddFieldSetEnd(); }
/// <summary> /// 产生一个WorkNode /// </summary> /// <param name="fk_flow">流程编号</param> /// <param name="fk_node">节点ID</param> /// <param name="workID">工作ID</param> /// <param name="fid">FID</param> /// <param name="userNo">用户编号</param> /// <returns>返回dataset</returns> public static DataSet GenerWorkNode(string fk_flow, int fk_node, Int64 workID, Int64 fid, string userNo, string fromWorkOpt = "0") { //节点. if (fk_node == 0) { fk_node = int.Parse(fk_flow + "01"); } if (workID == 0) { workID = BP.WF.Dev2Interface.Node_CreateBlankWork(fk_flow, null, null, userNo, null); } Node nd = new Node(fk_node); try { nd.WorkID = workID; //为获取表单ID提供参数. MapData md = new MapData(); md.No = nd.NodeFrmID; if (md.RetrieveFromDBSources() == 0) { throw new Exception("装载错误,该表单ID=" + md.No + "丢失,请修复一次流程重新加载一次."); } Work wk = nd.HisWork; wk.OID = workID; wk.RetrieveFromDBSources(); wk.ResetDefaultVal(); // 第1.2: 调用,处理用户定义的业务逻辑. string sendWhen = nd.HisFlow.DoFlowEventEntity(EventListOfNode.FrmLoadBefore, nd, wk, null); //获得表单模版. DataSet myds = BP.Sys.CCFormAPI.GenerHisDataSet(md.No, nd.Name); //移除MapAttr myds.Tables.Remove("Sys_MapAttr"); //移除. //获取表单的mapAttr //求出集合. MapAttrs mattrs = new MapAttrs(md.No); if (fk_node != null) { /*处理表单权限控制方案*/ FrmNode frmNode = new FrmNode(); int count = frmNode.Retrieve(FrmNodeAttr.FK_Frm, md.No, FrmNodeAttr.FK_Node, fk_node); if (count != 0 && frmNode.FrmSln != 0) { FrmFields fls = new FrmFields(md.No, frmNode.FK_Node); foreach (FrmField item in fls) { foreach (MapAttr attr in mattrs) { if (attr.KeyOfEn != item.KeyOfEn) { continue; } if (item.IsSigan) { item.UIIsEnable = false; } attr.UIIsEnable = item.UIIsEnable; attr.UIVisible = item.UIVisible; attr.IsSigan = item.IsSigan; attr.DefValReal = item.DefVal; } } } } DataTable Sys_MapAttr = mattrs.ToDataTableField("Sys_MapAttr"); myds.Tables.Add(Sys_MapAttr); //把流程信息表发送过去. GenerWorkFlow gwf = new GenerWorkFlow(); gwf.WorkID = workID; gwf.RetrieveFromDBSources(); //加入WF_Node. DataTable WF_Node = nd.ToDataTableField("WF_Node"); myds.Tables.Add(WF_Node); #region 加入组件的状态信息, 在解析表单的时候使用. BP.WF.Template.FrmNodeComponent fnc = new FrmNodeComponent(nd.NodeID); nd.WorkID = workID; //为获取表单ID提供参数. if (nd.NodeFrmID != "ND" + nd.NodeID && nd.HisFormType != NodeFormType.RefOneFrmTree) { /*说明这是引用到了其他节点的表单,就需要把一些位置元素修改掉.*/ int refNodeID = int.Parse(nd.NodeFrmID.Replace("ND", "")); BP.WF.Template.FrmNodeComponent refFnc = new FrmNodeComponent(refNodeID); fnc.SetValByKey(FrmWorkCheckAttr.FWC_H, refFnc.GetValFloatByKey(FrmWorkCheckAttr.FWC_H)); fnc.SetValByKey(FrmWorkCheckAttr.FWC_W, refFnc.GetValFloatByKey(FrmWorkCheckAttr.FWC_W)); fnc.SetValByKey(FrmWorkCheckAttr.FWC_X, refFnc.GetValFloatByKey(FrmWorkCheckAttr.FWC_X)); fnc.SetValByKey(FrmWorkCheckAttr.FWC_Y, refFnc.GetValFloatByKey(FrmWorkCheckAttr.FWC_Y)); if (fnc.GetValFloatByKey(FrmWorkCheckAttr.FWC_H) <= 10) { fnc.SetValByKey(FrmWorkCheckAttr.FWC_H, 500); } if (fnc.GetValFloatByKey(FrmWorkCheckAttr.FWC_W) <= 10) { fnc.SetValByKey(FrmWorkCheckAttr.FWC_W, 600); } if (fnc.GetValFloatByKey(FrmWorkCheckAttr.FWC_X) <= 10) { fnc.SetValByKey(FrmWorkCheckAttr.FWC_X, 200); } if (fnc.GetValFloatByKey(FrmWorkCheckAttr.FWC_Y) <= 10) { fnc.SetValByKey(FrmWorkCheckAttr.FWC_Y, 200); } fnc.SetValByKey(FrmSubFlowAttr.SF_H, refFnc.GetValFloatByKey(FrmSubFlowAttr.SF_H)); fnc.SetValByKey(FrmSubFlowAttr.SF_W, refFnc.GetValFloatByKey(FrmSubFlowAttr.SF_W)); fnc.SetValByKey(FrmSubFlowAttr.SF_X, refFnc.GetValFloatByKey(FrmSubFlowAttr.SF_X)); fnc.SetValByKey(FrmSubFlowAttr.SF_Y, refFnc.GetValFloatByKey(FrmSubFlowAttr.SF_Y)); fnc.SetValByKey(FrmThreadAttr.FrmThread_H, refFnc.GetValFloatByKey(FrmThreadAttr.FrmThread_H)); fnc.SetValByKey(FrmThreadAttr.FrmThread_W, refFnc.GetValFloatByKey(FrmThreadAttr.FrmThread_W)); fnc.SetValByKey(FrmThreadAttr.FrmThread_X, refFnc.GetValFloatByKey(FrmThreadAttr.FrmThread_X)); fnc.SetValByKey(FrmThreadAttr.FrmThread_Y, refFnc.GetValFloatByKey(FrmThreadAttr.FrmThread_Y)); fnc.SetValByKey(FrmTrackAttr.FrmTrack_H, refFnc.GetValFloatByKey(FrmTrackAttr.FrmTrack_H)); fnc.SetValByKey(FrmTrackAttr.FrmTrack_W, refFnc.GetValFloatByKey(FrmTrackAttr.FrmTrack_W)); fnc.SetValByKey(FrmTrackAttr.FrmTrack_X, refFnc.GetValFloatByKey(FrmTrackAttr.FrmTrack_X)); fnc.SetValByKey(FrmTrackAttr.FrmTrack_Y, refFnc.GetValFloatByKey(FrmTrackAttr.FrmTrack_Y)); fnc.SetValByKey(FTCAttr.FTC_H, refFnc.GetValFloatByKey(FTCAttr.FTC_H)); fnc.SetValByKey(FTCAttr.FTC_W, refFnc.GetValFloatByKey(FTCAttr.FTC_W)); fnc.SetValByKey(FTCAttr.FTC_X, refFnc.GetValFloatByKey(FTCAttr.FTC_X)); fnc.SetValByKey(FTCAttr.FTC_Y, refFnc.GetValFloatByKey(FTCAttr.FTC_Y)); #region 没有审核组件分组就增加上审核组件分组. @杜需要翻译&测试. if (md.HisFrmType == FrmType.FoolForm) { //判断是否是傻瓜表单,如果是,就要判断该傻瓜表单是否有审核组件groupfield ,没有的话就增加上. DataTable gf = myds.Tables["Sys_GroupField"]; bool isHave = false; foreach (DataRow dr in gf.Rows) { string cType = dr["CtrlType"] as string; if (cType == null) { continue; } if (cType.Equals("FWC") == true) { isHave = true; } } if (isHave == false) { DataRow dr = gf.NewRow(); nd.WorkID = workID; //为获取表单ID提供参数. dr[GroupFieldAttr.OID] = 100; dr[GroupFieldAttr.FrmID] = nd.NodeFrmID; dr[GroupFieldAttr.CtrlType] = "FWC"; dr[GroupFieldAttr.CtrlID] = "FWCND" + nd.NodeID; dr[GroupFieldAttr.Idx] = 100; dr[GroupFieldAttr.Lab] = "审核信息"; gf.Rows.Add(dr); myds.Tables.Remove("Sys_GroupField"); myds.Tables.Add(gf); //执行更新,就自动生成那个丢失的字段分组. refFnc.Update(); /* * //丢失了就插入新的. * BP.Sys.GroupField gfEn = new GroupField(); * gfEn.FrmID = nd.NodeFrmID; * gfEn.CtrlType = "FWC"; * gfEn.CtrlID = "FWCND" + nd.NodeID; * gfEn.Idx = 100; * gfEn.Lab = "审核信息"; * gfEn.Insert(); */ } } #endregion 没有审核组件分组就增加上审核组件分组. } #region 没有审核组件分组就增加上审核组件分组. @杜需要翻译&测试. if (nd.NodeFrmID == "ND" + nd.NodeID && nd.HisFormType != NodeFormType.RefOneFrmTree) { // Work wk1 = nd.HisWork; if (nd.FormType == NodeFormType.FoolForm) { //判断是否是傻瓜表单,如果是,就要判断该傻瓜表单是否有审核组件groupfield ,没有的话就增加上. DataTable gf = myds.Tables["Sys_GroupField"]; bool isHave = false; foreach (DataRow dr in gf.Rows) { string cType = dr["CtrlType"] as string; if (cType == null) { continue; } if (cType.Equals("FWC") == true) { isHave = true; } } if (isHave == false) { DataRow dr = gf.NewRow(); nd.WorkID = workID; //为获取表单ID提供参数. dr[GroupFieldAttr.OID] = 100; dr[GroupFieldAttr.FrmID] = nd.NodeFrmID; dr[GroupFieldAttr.CtrlType] = "FWC"; dr[GroupFieldAttr.CtrlID] = "FWCND" + nd.NodeID; dr[GroupFieldAttr.Idx] = 100; dr[GroupFieldAttr.Lab] = "审核信息"; gf.Rows.Add(dr); myds.Tables.Remove("Sys_GroupField"); myds.Tables.Add(gf); //更新,为了让其自动增加审核分组. BP.WF.Template.FrmNodeComponent refFnc = new FrmNodeComponent(nd.NodeID); refFnc.Update(); } } } #endregion 没有审核组件分组就增加上审核组件分组. myds.Tables.Add(fnc.ToDataTableField("WF_FrmNodeComponent")); #endregion 加入组件的状态信息, 在解析表单的时候使用. #region 增加 groupfields if (nd.FormType == NodeFormType.FoolTruck && nd.IsStartNode == false && DataType.IsNullOrEmpty(wk.HisPassedFrmIDs) == false) { #region 处理字段分组排序. //查询所有的分组, 如果是查看表单的方式,就不应该把当前的表单显示出来. string myFrmIDs = ""; if (fromWorkOpt.Equals("1") == true) { if (gwf.WFState == WFState.Complete) { myFrmIDs = wk.HisPassedFrmIDs + ",'ND" + fk_node + "'"; } else { myFrmIDs = wk.HisPassedFrmIDs; //流程未完成并且是查看表单的情况. } } else { myFrmIDs = wk.HisPassedFrmIDs + ",'ND" + fk_node + "'"; } GroupFields gfs = new GroupFields(); gfs.RetrieveIn(GroupFieldAttr.FrmID, "(" + myFrmIDs + ")"); //按照时间的顺序查找出来 ids . string sqlOrder = "SELECT OID FROM Sys_GroupField WHERE FrmID IN (" + myFrmIDs + ")"; if (BP.Sys.SystemConfig.AppCenterDBType == DBType.Oracle) { myFrmIDs = myFrmIDs.Replace("'", ""); sqlOrder += " ORDER BY INSTR('" + myFrmIDs + "',FrmID) , Idx"; } if (BP.Sys.SystemConfig.AppCenterDBType == DBType.MSSQL) { myFrmIDs = myFrmIDs.Replace("'", ""); sqlOrder += " ORDER BY CHARINDEX(FrmID, '" + myFrmIDs + "'), Idx"; } if (BP.Sys.SystemConfig.AppCenterDBType == DBType.MySQL) { myFrmIDs = myFrmIDs.Replace("'", ""); sqlOrder += " ORDER BY INSTR('" + myFrmIDs + "', FrmID ), Idx"; } DataTable dtOrder = DBAccess.RunSQLReturnTable(sqlOrder); //创建容器,把排序的分组放入这个容器. GroupFields gfsNew = new GroupFields(); //遍历查询出来的分组. foreach (DataRow dr in dtOrder.Rows) { string pkOID = dr[0].ToString(); var mygf = gfs.GetEntityByKey(pkOID); gfsNew.AddEntity(mygf); //把分组字段加入里面去. } DataTable dtGF = gfsNew.ToDataTableField("Sys_GroupField"); myds.Tables.Remove("Sys_GroupField"); myds.Tables.Add(dtGF); #endregion 处理字段分组排序. #region 处理 mapattrs //求当前表单的字段集合. MapAttrs attrs = new MapAttrs(); QueryObject qo = new QueryObject(attrs); qo.AddWhere(MapAttrAttr.FK_MapData, "ND" + nd.NodeID); qo.addOrderBy(MapAttrAttr.Idx); qo.DoQuery(); //计算累加的字段集合. MapAttrs attrsLeiJia = new MapAttrs(); qo = new QueryObject(attrsLeiJia); qo.AddWhere(MapAttrAttr.FK_MapData, " IN ", "(" + wk.HisPassedFrmIDs + ")"); qo.addOrderBy(MapAttrAttr.Idx); qo.DoQuery(); //把两个集合接起来. foreach (MapAttr item in attrsLeiJia) { item.UIIsEnable = false; //设置为只读的. attrs.AddEntity(item); } //替换掉现有的. myds.Tables.Remove("Sys_MapAttr"); //移除. myds.Tables.Add(attrs.ToDataTableField("Sys_MapAttr")); //增加. #endregion 处理mapattrs #region 把枚举放入里面去. myds.Tables.Remove("Sys_Enum"); myFrmIDs = wk.HisPassedFrmIDs + ",'ND" + fk_node + "'"; SysEnums enums = new SysEnums(); enums.RetrieveInSQL(SysEnumAttr.EnumKey, "SELECT UIBindKey FROM Sys_MapAttr WHERE FK_MapData in(" + myFrmIDs + ")"); // 加入最新的枚举. myds.Tables.Add(enums.ToDataTableField("Sys_Enum")); #endregion 把枚举放入里面去. #region MapExt . myds.Tables.Remove("Sys_MapExt"); // 把扩展放入里面去. myFrmIDs = wk.HisPassedFrmIDs + ",'ND" + fk_node + "'"; BP.Sys.MapExts exts = new MapExts(); qo = new QueryObject(exts); qo.AddWhere(MapExtAttr.FK_MapData, " IN ", "(" + myFrmIDs + ")"); qo.DoQuery(); // 加入最新的MapExt. myds.Tables.Add(exts.ToDataTableField("Sys_MapExt")); #endregion MapExt . } #endregion 增加 groupfields #region 流程设置信息. if (nd.IsStartNode == false) { BP.WF.Dev2Interface.Node_SetWorkRead(fk_node, workID); // @杜. if (gwf.TodoEmps.Contains(BP.Web.WebUser.Name + ";") == false) { gwf.TodoEmps += BP.Web.WebUser.No + "," + BP.Web.WebUser.Name; gwf.Update(); } } //增加转向下拉框数据. if (nd.CondModel == CondModel.SendButtonSileSelect) { if (nd.IsStartNode == true || gwf.TodoEmps.Contains(WebUser.No + ",") == true) { /*如果当前不是主持人,如果不是主持人,就不让他显示下拉框了.*/ /*如果当前节点,是可以显示下拉框的.*/ Nodes nds = nd.HisToNodes; DataTable dtToNDs = new DataTable(); dtToNDs.TableName = "ToNodes"; dtToNDs.Columns.Add("No", typeof(string)); //节点ID. dtToNDs.Columns.Add("Name", typeof(string)); //到达的节点名称. dtToNDs.Columns.Add("IsSelectEmps", typeof(string)); //是否弹出选择人的对话框? dtToNDs.Columns.Add("IsSelected", typeof(string)); //是否选择? #region 增加到达延续子流程节点。 NodeYGFlows ygflows = new NodeYGFlows(fk_node.ToString()); if (ygflows.Count > 1 && SystemConfig.CustomerNo.Equals("CZBank") == true) { dtToNDs.Rows.Clear(); //为浙商银行做的特殊判断,如果配置了延续流程,就不让其走分支节点. } foreach (NodeYGFlow item in ygflows) { DataRow dr = dtToNDs.NewRow(); dr["No"] = item.FK_Flow + "01"; dr["Name"] = "启动:" + item.FlowName; //if (item.HisDeliveryWay == DeliveryWay.BySelected) dr["IsSelectEmps"] = "1"; //else // dr["IsSelectEmps"] = "0"; //是不是,可以选择接受人. //设置默认选择的节点. //if (defalutSelectedNodeID == item.NodeID) // dr["IsSelected"] = "1"; //else // dr["IsSelected"] = "0"; dr["IsSelected"] = "0"; dtToNDs.Rows.Add(dr); } #endregion 增加到达延续子流程节点。 #region 到达其他节点. //上一次选择的节点. int defalutSelectedNodeID = 0; if (nds.Count > 1) { string mysql = ""; // 找出来上次发送选择的节点. if (SystemConfig.AppCenterDBType == DBType.MSSQL) { mysql = "SELECT top 1 NDTo FROM ND" + int.Parse(nd.FK_Flow) + "Track A WHERE A.NDFrom=" + fk_node + " AND ActionType=1 ORDER BY WorkID DESC"; } else if (SystemConfig.AppCenterDBType == DBType.Oracle) { mysql = "SELECT * FROM ( SELECT NDTo FROM ND" + int.Parse(nd.FK_Flow) + "Track A WHERE A.NDFrom=" + fk_node + " AND ActionType=1 ORDER BY WorkID DESC ) WHERE ROWNUM =1"; } else if (SystemConfig.AppCenterDBType == DBType.MySQL) { mysql = "SELECT NDTo FROM ND" + int.Parse(nd.FK_Flow) + "Track A WHERE A.NDFrom=" + fk_node + " AND ActionType=1 ORDER BY WorkID DESC limit 1,1"; } //获得上一次发送到的节点. defalutSelectedNodeID = DBAccess.RunSQLReturnValInt(mysql, 0); } #region 为天业集团做一个特殊的判断. if (SystemConfig.CustomerNo == "TianYe" && nd.Name.Contains("董事长") == true) { /*如果是董事长节点, 如果是下一个节点默认的是备案. */ foreach (Node item in nds) { if (item.Name.Contains("备案") == true && item.Name.Contains("待") == false) { defalutSelectedNodeID = item.NodeID; break; } } } #endregion 为天业集团做一个特殊的判断. foreach (Node item in nds) { DataRow dr = dtToNDs.NewRow(); dr["No"] = item.NodeID; dr["Name"] = item.Name; //if (item.hissel if (item.HisDeliveryWay == DeliveryWay.BySelected) { dr["IsSelectEmps"] = "1"; } else { dr["IsSelectEmps"] = "0"; //是不是,可以选择接受人. } //设置默认选择的节点. if (defalutSelectedNodeID == item.NodeID) { dr["IsSelected"] = "1"; } else { dr["IsSelected"] = "0"; } dtToNDs.Rows.Add(dr); } #endregion 到达其他节点。 //增加一个下拉框, 对方判断是否有这个数据. myds.Tables.Add(dtToNDs); } } // 节点数据. //string sql = "SELECT * FROM WF_Node WHERE NodeID=" + fk_node; //DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(sql); //dt.TableName = "WF_NodeBar"; //myds.Tables.Add(dt); //// 流程数据. //Flow fl = new Flow(fk_flow); //myds.Tables.Add(fl.ToDataTableField("WF_Flow")); #endregion 流程设置信息. #region 把主从表数据放入里面. //.工作数据放里面去, 放进去前执行一次装载前填充事件. //重设默认值. wk.ResetDefaultVal(); //@樊雷伟 把这部分代码搬到jflow上去. CCFlowAPI. 114行出. if (BP.Sys.SystemConfig.IsBSsystem == true) { // 处理传递过来的参数。 foreach (string k in System.Web.HttpContext.Current.Request.QueryString.AllKeys) { if (DataType.IsNullOrEmpty(k) == true) { continue; } wk.SetValByKey(k, System.Web.HttpContext.Current.Request.QueryString[k]); } // 处理传递过来的frm参数。 foreach (string k in System.Web.HttpContext.Current.Request.Form.AllKeys) { if (DataType.IsNullOrEmpty(k) == true) { continue; } wk.SetValByKey(k, System.Web.HttpContext.Current.Request.Form[k]); } //更新到数据库里. wk.DirectUpdate(); } // 执行表单事件.. string msg = md.DoEvent(FrmEventList.FrmLoadBefore, wk); if (DataType.IsNullOrEmpty(msg) == false) { throw new Exception("err@错误:" + msg); } // 执行FEE事件. string msgOfLoad = nd.HisFlow.DoFlowEventEntity(EventListOfNode.FrmLoadBefore, nd, wk, null); if (msgOfLoad != null) { wk.RetrieveFromDBSources(); } //执行装载填充. MapExt me = new MapExt(); if (me.Retrieve(MapExtAttr.ExtType, MapExtXmlList.PageLoadFull, MapExtAttr.FK_MapData, wk.NodeFrmID) == 1) { //执行通用的装载方法. MapAttrs attrs = new MapAttrs(wk.NodeFrmID); MapDtls dtls = new MapDtls(wk.NodeFrmID); wk = BP.WF.Glo.DealPageLoadFull(wk, me, attrs, dtls) as Work; } //如果是累加表单,就把整个rpt数据都放入里面去. if (nd.FormType == NodeFormType.FoolTruck && nd.IsStartNode == false && DataType.IsNullOrEmpty(wk.HisPassedFrmIDs) == false) { GERpt rpt = new GERpt("ND" + int.Parse(nd.FK_Flow) + "Rpt", workID); // nd.HisFlow.HisGERpt; rpt.ResetDefaultVal(); //rpt.Copy(wk); //加入后就出现了错误. myds.Tables.Add(rpt.ToDataTableField("MainTable")); // myds.WriteXml("C:\\XX.xml"); } else { DataTable mainTable = wk.ToDataTableField(md.No); mainTable.TableName = "MainTable"; myds.Tables.Add(mainTable); } string sql = ""; DataTable dt = null; #endregion #region 把外键表加入DataSet DataTable dtMapAttr = myds.Tables["Sys_MapAttr"]; MapExts mes = md.MapExts; foreach (DataRow dr in dtMapAttr.Rows) { string lgType = dr["LGType"].ToString(); string uiBindKey = dr["UIBindKey"].ToString(); if (DataType.IsNullOrEmpty(uiBindKey) == true) { continue; //为空就continue. } if (lgType.Equals("1") == true) { continue; //枚举值就continue; } string uiIsEnable = dr["UIIsEnable"].ToString(); if (uiIsEnable.Equals("0") == true && lgType.Equals("1") == true) { continue; //如果是外键,并且是不可以编辑的状态. } if (uiIsEnable.Equals("1") == true && lgType.Equals("0") == true) { continue; //如果是外部数据源,并且是不可以编辑的状态. } // 检查是否有下拉框自动填充。 string keyOfEn = dr["KeyOfEn"].ToString(); string fk_mapData = dr["FK_MapData"].ToString(); #region 处理下拉框数据范围. for 小杨. me = mes.GetEntityByKey(MapExtAttr.ExtType, MapExtXmlList.AutoFullDLL, MapExtAttr.AttrOfOper, keyOfEn) as MapExt; if (me != null) { string fullSQL = me.Doc.Clone() as string; fullSQL = fullSQL.Replace("~", ","); fullSQL = BP.WF.Glo.DealExp(fullSQL, wk, null); dt = DBAccess.RunSQLReturnTable(fullSQL); //重构新表 DataTable dt_FK_Dll = new DataTable(); dt_FK_Dll.TableName = keyOfEn;//可能存在隐患,如果多个字段,绑定同一个表,就存在这样的问题. dt_FK_Dll.Columns.Add("No", typeof(string)); dt_FK_Dll.Columns.Add("Name", typeof(string)); foreach (DataRow dllRow in dt.Rows) { DataRow drDll = dt_FK_Dll.NewRow(); drDll["No"] = dllRow["No"]; drDll["Name"] = dllRow["Name"]; dt_FK_Dll.Rows.Add(drDll); } myds.Tables.Add(dt_FK_Dll); continue; } #endregion 处理下拉框数据范围. // 判断是否存在. if (myds.Tables.Contains(uiBindKey) == true) { continue; } if (BP.Sys.PubClass.GetDataTableByUIBineKey(uiBindKey) != null) { myds.Tables.Add(BP.Sys.PubClass.GetDataTableByUIBineKey(uiBindKey)); } } #endregion End把外键表加入DataSet #region 处理流程-消息提示. DataTable dtAlert = new DataTable(); dtAlert.TableName = "AlertMsg"; dtAlert.Columns.Add("Title", typeof(string)); dtAlert.Columns.Add("Msg", typeof(string)); dtAlert.Columns.Add("URL", typeof(string)); // string msg = ""; switch (gwf.WFState) { case WFState.AskForReplay: // 返回加签的信息. string mysql = "SELECT * FROM ND" + int.Parse(fk_flow) + "Track WHERE WorkID=" + workID + " AND " + TrackAttr.ActionType + "=" + (int)ActionType.ForwardAskfor; DataTable mydt = BP.DA.DBAccess.RunSQLReturnTable(mysql); foreach (DataRow dr in mydt.Rows) { string msgAskFor = dr[TrackAttr.Msg].ToString(); string worker = dr[TrackAttr.EmpFrom].ToString(); string workerName = dr[TrackAttr.EmpFromT].ToString(); string rdt = dr[TrackAttr.RDT].ToString(); DataRow drMsg = dtAlert.NewRow(); drMsg["Title"] = worker + "," + workerName + "回复信息:"; drMsg["Msg"] = DataType.ParseText2Html(msgAskFor) + "<br>" + rdt; dtAlert.Rows.Add(drMsg); } break; case WFState.Askfor: //加签. sql = "SELECT * FROM ND" + int.Parse(fk_flow) + "Track WHERE WorkID=" + workID + " AND " + TrackAttr.ActionType + "=" + (int)ActionType.AskforHelp; dt = BP.DA.DBAccess.RunSQLReturnTable(sql); foreach (DataRow dr in dt.Rows) { string msgAskFor = dr[TrackAttr.Msg].ToString(); string worker = dr[TrackAttr.EmpFrom].ToString(); string workerName = dr[TrackAttr.EmpFromT].ToString(); string rdt = dr[TrackAttr.RDT].ToString(); DataRow drMsg = dtAlert.NewRow(); drMsg["Title"] = worker + "," + workerName + "请求加签:"; drMsg["Msg"] = DataType.ParseText2Html(msgAskFor) + "<br>" + rdt + "<a href='./WorkOpt/AskForRe.htm?FK_Flow=" + fk_flow + "&FK_Node=" + fk_node + "&WorkID=" + workID + "&FID=" + fid + "' >回复加签意见</a> --"; dtAlert.Rows.Add(drMsg); //提示信息. // this.FlowMsg.AlertMsg_Info(worker + "," + workerName + "请求加签:", // DataType.ParseText2Html(msgAskFor) + "<br>" + rdt + " --<a href='./WorkOpt/AskForRe.aspx?FK_Flow=" + this.FK_Flow + "&FK_Node=" + this.FK_Node + "&WorkID=" + this.WorkID + "&FID=" + this.FID + "' >回复加签意见</a> --"); } // isAskFor = true; break; case WFState.ReturnSta: /* 如果工作节点退回了*/ ReturnWorks rws = new ReturnWorks(); rws.Retrieve(ReturnWorkAttr.ReturnToNode, fk_node, ReturnWorkAttr.WorkID, workID, ReturnWorkAttr.RDT); if (rws.Count != 0) { //string msgInfo = ""; //foreach (BP.WF.ReturnWork rw in rws) //{ // DataRow drMsg = dtAlert.NewRow(); // //drMsg["Title"] = "来自节点:" + rw.ReturnNodeName + " 退回人:" + rw.ReturnerName + " " + rw.RDT + " <a href='/DataUser/ReturnLog/" + fk_flow + "/" + rw.MyPK + ".htm' target=_blank>工作日志</a>"; // drMsg["Title"] = "来自节点:" + rw.ReturnNodeName + " 退回人:" + rw.ReturnerName + " " + rw.RDT; // drMsg["Msg"] = rw.BeiZhuHtml; // dtAlert.Rows.Add(drMsg); //} string msgInfo = ""; foreach (BP.WF.ReturnWork rw in rws) { //drMsg["Title"] = "来自节点:" + rw.ReturnNodeName + " 退回人:" + rw.ReturnerName + " " + rw.RDT + " <a href='/DataUser/ReturnLog/" + fk_flow + "/" + rw.MyPK + ".htm' target=_blank>工作日志</a>"; msgInfo += "\t\n来自节点:" + rw.ReturnNodeName + " 退回人:" + rw.ReturnerName + " " + rw.RDT; msgInfo += rw.BeiZhuHtml; } string str = nd.ReturnAlert; if (str != "") { str = str.Replace("~", "'"); str = str.Replace("@PWorkID", workID.ToString()); str = str.Replace("@PNodeID", nd.NodeID.ToString()); str = str.Replace("@FK_Node", nd.NodeID.ToString()); str = str.Replace("@PFlowNo", fk_flow); str = str.Replace("@FK_Flow", fk_flow); str = str.Replace("@PWorkID", workID.ToString()); str = str.Replace("@WorkID", workID.ToString()); str = str.Replace("@OID", workID.ToString()); DataRow drMsg = dtAlert.NewRow(); drMsg["Title"] = "退回信息"; drMsg["Msg"] = msgInfo + "\t\n" + str; dtAlert.Rows.Add(drMsg); } else { DataRow drMsg = dtAlert.NewRow(); drMsg["Title"] = "退回信息"; drMsg["Msg"] = msgInfo + "\t\n" + str; dtAlert.Rows.Add(drMsg); } } break; case WFState.Shift: /* 判断移交过来的。 */ ShiftWorks fws = new ShiftWorks(); BP.En.QueryObject qo = new QueryObject(fws); qo.AddWhere(ShiftWorkAttr.WorkID, workID); qo.addAnd(); qo.AddWhere(ShiftWorkAttr.FK_Node, fk_node); qo.addOrderBy(ShiftWorkAttr.RDT); qo.DoQuery(); if (fws.Count >= 1) { DataRow drMsg = dtAlert.NewRow(); drMsg["Title"] = "移交历史信息"; msg = ""; foreach (ShiftWork fw in fws) { string temp = "@移交人[" + fw.FK_Emp + "," + fw.FK_EmpName + "]。@接受人:" + fw.ToEmp + "," + fw.ToEmpName + "。<br>移交原因:-------------" + fw.NoteHtml; if (fw.FK_Emp == WebUser.No) { temp = "<b>" + temp + "</b>"; } temp = temp.Replace("@", "<br>@"); msg += temp + "<hr/>"; } drMsg["Msg"] = msg; dtAlert.Rows.Add(drMsg); } break; default: break; } #endregion #region 增加流程节点表单绑定信息. if (nd.HisFormType == NodeFormType.RefOneFrmTree) { /* 独立流程节点表单. */ nd.WorkID = workID; //为获取表单ID ( NodeFrmID )提供参数. FrmNode fn = new FrmNode(); fn.MyPK = nd.NodeFrmID + "_" + nd.NodeID + "_" + nd.FK_Flow; fn.Retrieve(); myds.Tables.Add(fn.ToDataTableField("FrmNode")); } #endregion 增加流程节点表单绑定信息. myds.Tables.Add(dtAlert); return(myds); } catch (Exception ex) { Log.DebugWriteError(ex.StackTrace); throw new Exception(ex.Message); } }
public Group[] GetByIdSync( int[] groupIds , GroupFields fields ) { var task = _parent.Executor.ExecAsync( _parent._reqapi.Groups.GetById( groupIds,fields ) ); task.Wait(); return task.Result.Response; }
public async Task <Group[]> GetById( int[] groupIds , GroupFields fields ) { return ( await _parent.Executor.ExecAsync( _parent._reqapi.Groups.GetById( groupIds,fields ) ).ConfigureAwait(false) ).Response; }
public void BindEnum(MapAttr mapAttr) { this.Pub1.AddTable(); this.Pub1.AddTR(); this.Pub1.AddTDTitle("ID"); this.Pub1.AddTDTitle("项目"); this.Pub1.AddTDTitle("采集"); this.Pub1.AddTDTitle("说明"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("字段英文名称"); TB tb = new TB(); if (this.RefNo != null) { this.Pub1.AddTD(mapAttr.KeyOfEn); } else { tb = new TB(); tb.ID = "TB_KeyOfEn"; tb.Text = mapAttr.KeyOfEn; this.Pub1.AddTD(tb); } // this.Pub1.AddTDTitle(" "); //this.Pub1.AddTD("不要以数字开头、不要中文。"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("字段中文名称"); tb = new TB(); tb.ID = "TB_Name"; tb.Text = mapAttr.Name; tb.Attributes["width"] = "100%"; this.Pub1.AddTD(tb); this.Pub1.AddTD(""); this.Pub1.AddTREnd(); this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("默认值"); DDL ddl = new DDL(); ddl.ID = "DDL"; ddl.BindSysEnum(mapAttr.UIBindKey); ddl.SetSelectItem(mapAttr.DefVal); this.Pub1.AddTD(ddl); this.Pub1.AddTD("<a href='SysEnum.aspx?RefNo=" + mapAttr.UIBindKey + "'>编辑</a>"); this.Pub1.AddTREnd(); #region 是否可编辑 this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("是否可编辑"); this.Pub1.AddTDBegin(); RadioButton rb = new RadioButton(); rb.ID = "RB_UIIsEnable_0"; rb.Text = "不可编辑"; rb.GroupName = "s"; if (mapAttr.UIIsEnable) { rb.Checked = false; } else { rb.Checked = true; } this.Pub1.Add(rb); rb = new RadioButton(); rb.ID = "RB_UIIsEnable_1"; rb.Text = "可编辑"; rb.GroupName = "s"; if (mapAttr.UIIsEnable) { rb.Checked = true; } else { rb.Checked = false; } this.Pub1.Add(rb); this.Pub1.AddTDEnd(); this.Pub1.AddTD(""); this.Pub1.AddTREnd(); #endregion 是否可编辑 #region 展示控件 this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("控件类型"); this.Pub1.AddTDBegin(); rb = new RadioButton(); rb.ID = "RB_Ctrl_0"; rb.Text = "下拉框"; rb.GroupName = "Ctrl"; if (mapAttr.UIContralType == UIContralType.DDL) { rb.Checked = true; } else { rb.Checked = false; } this.Pub1.Add(rb); rb = new RadioButton(); rb.ID = "RB_Ctrl_1"; rb.Text = "单选按钮"; rb.GroupName = "Ctrl"; if (mapAttr.UIContralType == UIContralType.DDL) { rb.Checked = false; } else { rb.Checked = true; } this.Pub1.Add(rb); this.Pub1.AddTDEnd(); this.Pub1.AddTD(""); this.Pub1.AddTREnd(); #endregion 展示控件 #region 是否可界面可见 this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("是否界面可见"); //是否界面可见 this.Pub1.AddTDBegin(); rb = new RadioButton(); rb.ID = "RB_UIVisible_0"; rb.Text = "不可见"; // 界面不可见 rb.GroupName = "sa3"; if (mapAttr.UIVisible) { rb.Checked = false; } else { rb.Checked = true; } this.Pub1.Add(rb); if (mapAttr.IsTableAttr) { rb.Enabled = false; } rb = new RadioButton(); rb.ID = "RB_UIVisible_1"; rb.Text = "界面可见"; // 界面可见; rb.GroupName = "sa3"; if (mapAttr.UIVisible) { rb.Checked = true; } else { rb.Checked = false; } if (mapAttr.IsTableAttr) { rb.Enabled = false; } this.Pub1.Add(rb); this.Pub1.AddTDEnd(); this.Pub1.AddTD("不可见则为隐藏字段."); this.Pub1.AddTREnd(); #endregion 是否可界面可见 #region 是否可单独行显示 this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("呈现方式"); //呈现方式; this.Pub1.AddTDBegin(); rb = new RadioButton(); rb.ID = "RB_UIIsLine_0"; rb.Text = "两列显示"; // 两行 rb.GroupName = "sa"; if (mapAttr.UIIsLine) { rb.Checked = false; } else { rb.Checked = true; } this.Pub1.Add(rb); rb = new RadioButton(); rb.ID = "RB_UIIsLine_1"; rb.Text = "整行显示"; // "一行"; rb.GroupName = "sa"; if (mapAttr.UIIsLine) { rb.Checked = true; } else { rb.Checked = false; } this.Pub1.Add(rb); this.Pub1.AddTDEnd(); this.Pub1.AddTD("对傻瓜表单有效"); // this.Pub1.AddTD("控制该它在表单的显示方式"); this.Pub1.AddTREnd(); #endregion 是否可编辑 #region 字段分组 this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("字段分组"); DDL ddlGroup = new DDL(); ddlGroup.ID = "DDL_GroupID"; GroupFields gfs = new GroupFields(mapAttr.FK_MapData); ddlGroup.Bind(gfs, GroupFieldAttr.OID, GroupFieldAttr.Lab); if (mapAttr.GroupID == 0) { mapAttr.GroupID = this.GroupField; } ddlGroup.SetSelectItem(mapAttr.GroupID); this.Pub1.AddTD(ddlGroup); this.Pub1.AddTD("修改隶属分组"); this.Pub1.AddTREnd(); #endregion 字段分组 this.Pub1.AddTRSum(); this.Pub1.Add("<TD colspan=4 >"); Button btn = new Button(); btn.ID = "Btn_Save"; btn.CssClass = "Btn"; btn.Text = " 保存 "; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_SaveAndClose"; btn.CssClass = "Btn"; btn.Text = "保存并关闭"; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_SaveAndNew"; btn.CssClass = "Btn"; btn.Text = "保存并新建"; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); if (this.RefNo != null) { btn = new Button(); btn.ID = "Btn_AutoFull"; btn.CssClass = "Btn"; btn.Text = "扩展设置"; // btn.Click += new EventHandler(btn_Save_Click); btn.Attributes["onclick"] = "javascript:WinOpen('AutoFull.aspx?RefNo=" + this.RefNo + "&FK_MapData=" + mapAttr.FK_MapData + "',''); return false;"; this.Pub1.Add(btn); if (mapAttr.HisEditType == EditType.Edit) { btn = new Button(); btn.ID = "Btn_Del"; btn.CssClass = "Btn"; btn.Text = "删除"; btn.Click += new EventHandler(btn_Save_Click); btn.Attributes["onclick"] = " return confirm('您确认吗?');"; this.Pub1.Add(btn); } } string url = "Do.aspx?DoType=AddF&MyPK=" + mapAttr.FK_MapData + "&IDX=" + mapAttr.IDX; this.Pub1.Add("<a href='" + url + "'><img src='/WF/Img/Btn/New.gif' border=0>新建</a></TD>"); this.Pub1.AddTREnd(); this.Pub1.AddTableEndWithBR(); }
public void InsertDtl() { string sql = "SELECT * FROM Sys_MapDtl WHERE FK_MapData LIKE '" + this.MyPK.Replace("Rpt", "") + "%'"; DataTable dt = BP.DA.DBAccess.RunSQLReturnTable(sql); if (dt.Rows.Count == 0) { this.WinCloseWithMsg("此流程中没有从表所以您不能插入。"); return; } Nodes nds = new Nodes(BP.WF.Glo.GenerFlowNo(this.MyPK)); this.Pub1.AddTable(); this.Pub1.AddCaptionLeft("请选择要插入的从表"); foreach (BP.WF.Node nd in nds) { if (nd.IsEndNode == false) { continue; } this.Pub1.AddTR(); this.Pub1.AddTDTitle("节点步骤:" + nd.Step + " 节点名称:" + nd.Name); this.Pub1.AddTREnd(); MapDtls dtls = new MapDtls("ND" + nd.NodeID); this.Pub1.AddTR(); this.Pub1.AddTDBegin(); foreach (MapDtl dtl in dtls) { CheckBox cb = new CheckBox(); cb.ID = "CB_" + dtl.No; cb.Text = dtl.Name; this.Pub1.Add(cb); #region 字段分组 DDL ddlGroup = new DDL(); ddlGroup.ID = "DDL_" + dtl.No; GroupFields gfs = new GroupFields(dtl.FK_MapData); ddlGroup.Bind(gfs, GroupFieldAttr.OID, GroupFieldAttr.Lab); this.Pub1.Add("插入位置"); this.Pub1.Add(ddlGroup); //this.Pub1.Add("查询条件:"); //MapAttrs attrs = new MapAttrs(dtl.No); //foreach (MapAttr attr in attrs) //{ // if (attr.UIContralType != UIContralType.DDL) // continue; // cb = new CheckBox(); // cb.ID = "CB_" + dtl.No + "_" + attr.KeyOfEn; // cb.Text = attr.Name; // this.Pub1.Add(cb); //} #endregion 字段分组 } this.Pub1.AddTDEnd(); this.Pub1.AddTREnd(); } this.Pub1.AddTRSum(); Button btn = new Button(); btn.ID = "Btn_Save"; btn.Text = "插入到报表"; btn.CssClass = "Btn"; btn.Click += new EventHandler(btn_Click); this.Pub1.AddTD(btn); this.Pub1.AddTREnd(); this.Pub1.AddTableEnd(); }
void btn_Click(object sender, EventArgs e) { FrmAttachment ath = new FrmAttachment(); if (this.FK_Node == 0) { ath.MyPK = this.FK_MapData + "_" + this.Ath; } else { ath.MyPK = this.FK_MapData + "_" + this.Ath + "_" + this.FK_Node; } ath.RetrieveFromDBSources(); Button btn = sender as Button; if (btn.ID == "Btn_Delete") { //ath.MyPK = this.FK_MapData + "_" + this.Ath; ath.Delete(); this.WinClose("删除成功."); return; } ath.MyPK = this.FK_MapData + "_" + this.Ath; if (this.Ath != null) { ath.RetrieveFromDBSources(); } ath = this.Pub1.Copy(ath) as FrmAttachment; ath.FK_MapData = this.FK_MapData; ath.FK_Node = this.FK_Node; if (string.IsNullOrEmpty(this.Ath) == false) { ath.NoOfObj = this.Ath; } if (this.FK_Node == 0) { ath.MyPK = this.FK_MapData + "_" + ath.NoOfObj; } else { ath.MyPK = this.FK_MapData + "_" + ath.NoOfObj + "_" + this.FK_Node; } GroupFields gfs1 = new GroupFields(this.FK_MapData); if (gfs1.Count == 1) { GroupField gf = (GroupField)gfs1[0]; ath.GroupID = gf.OID; } else { ath.GroupID = this.Pub1.GetDDLByID("DDL_GroupField").SelectedItemIntVal; } //对流程的特殊判断. 20160513 加载页面时添加了判断,此处没有添加,导致保存报错。 zqp if (ath.IsNodeSheet == true) { ath.HisCtrlWay = (AthCtrlWay)this.Pub1.GetDDLByID("DDL_CtrlWay").SelectedItemIntVal; ath.AthUploadWay = (AthUploadWay)this.Pub1.GetDDLByID("DDL_AthUploadWay").SelectedItemIntVal; ath.FileShowWay = (FileShowWay)this.Pub1.GetDDLByID("DDL_FileShowWay").SelectedItemIntVal; //文件展现方式. ath.UploadCtrl = this.Pub1.GetDDLByID("DDL_UploadCtrl").SelectedItemIntVal; //使用的附件上传工具. ath.SaveWay = this.Pub1.GetDDLByID("DDL_" + FrmAttachmentAttr.SaveWay).SelectedItemIntVal; //保存方式. ath.IsHeLiuHuiZong = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsHeLiuHuiZong).Checked; //是否是合流节点汇总. ath.IsToHeLiuHZ = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsToHeLiuHZ).Checked; //是否汇总到合流节点.. } //word附件相关. ath.IsWoEnableWF = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsWoEnableWF).Checked; ath.IsWoEnableSave = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsWoEnableSave).Checked; ath.IsWoEnableReadonly = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsWoEnableReadonly).Checked; ath.IsWoEnableRevise = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsWoEnableRevise).Checked; ath.IsWoEnableViewKeepMark = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsWoEnableViewKeepMark).Checked; ath.IsWoEnablePrint = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsWoEnablePrint).Checked; ath.IsWoEnableSeal = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsWoEnableSeal).Checked; ath.IsWoEnableOver = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsWoEnableOver).Checked; ath.IsWoEnableTemplete = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsWoEnableTemplete).Checked; ath.IsWoEnableCheck = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsWoEnableCheck).Checked; ath.IsWoEnableInsertFengXian = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsWoEnableInsertFengXian).Checked; ath.IsWoEnableInsertFlow = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsWoEnableInsertFlow).Checked; ath.IsWoEnableMarks = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsWoEnableMarks).Checked; ath.IsWoEnableDown = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsWoEnableDown).Checked; ath.IsVisable = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsVisable).Checked; //是否可见. ath.FastKeyIsEnable = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.FastKeyIsEnable).Checked; ath.FastKeyGenerRole = this.Pub1.GetTBByID("TB_" + FrmAttachmentAttr.FastKeyGenerRole).Text; ath.IsOrder = this.Pub1.GetCBByID("CB_" + FrmAttachmentAttr.IsOrder).Checked; if (ath.FastKeyIsEnable == true) { if (ath.FastKeyGenerRole.Contains("*OID") == false) { throw new Exception("@快捷键生成规则必须包含*OID,否则会导致文件名重复."); } } if (this.Ath == null) { ath.UploadType = (AttachmentUploadType)int.Parse(this.UploadType); if (this.FK_Node == 0) { ath.MyPK = this.FK_MapData + "_" + ath.NoOfObj; } else { ath.MyPK = this.FK_MapData + "_" + ath.NoOfObj + "_" + this.FK_Node; } if (ath.IsExits == true) { this.Alert("附件编号(" + ath.NoOfObj + ")已经存在。"); return; } ath.Insert(); } else { ath.NoOfObj = this.Ath; if (this.FK_Node == 0) { ath.MyPK = this.FK_MapData + "_" + this.Ath; } else { ath.MyPK = this.FK_MapData + "_" + this.Ath + "_" + this.FK_Node; } ath.Update(); } this.WinCloseWithMsg("保存成功"); }
protected void Page_Load(object sender, EventArgs e) { FrmAttachment ath = new FrmAttachment(); ath.MyPK = this.FK_MapData + "_" + this.Ath; if (this.Ath != null) { ath.RetrieveFromDBSources(); } ath.FK_MapData = this.FK_MapData; ath.NoOfObj = this.Ath; ath.MyPK = this.FK_MapData + "_" + this.Ath; //this.Response.Write(this.Ath); //this.Response.Write(" -- "+this.FK_MapData); this.Title = "附件属性设置"; this.Pub1.AddTable(); //this.Pub1.AddCaptionLeft("附件"); this.Pub1.AddTR(); this.Pub1.AddTDTitle("项目"); this.Pub1.AddTDTitle("采集"); this.Pub1.AddTDTitle("说明"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD("编号"); TextBox tb = new TextBox(); tb.ID = "TB_" + FrmAttachmentAttr.NoOfObj; tb.Text = ath.NoOfObj; if (this.Ath != null) { tb.Enabled = false; } this.Pub1.AddTD(tb); this.Pub1.AddTD("标示号只能英文字母数字或下滑线."); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD("名称"); tb = new TextBox(); tb.ID = "TB_" + FrmAttachmentAttr.Name; tb.Text = ath.Name; this.Pub1.AddTD(tb); this.Pub1.AddTD("附件的中文名称."); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD("文件格式"); tb = new TextBox(); tb.ID = "TB_" + FrmAttachmentAttr.Exts; tb.Text = ath.Exts; this.Pub1.AddTD(tb); this.Pub1.AddTD("实例:doc,docx,xls,多种格式用逗号分开."); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD("保存到"); tb = new TextBox(); tb.ID = "TB_" + FrmAttachmentAttr.SaveTo; tb.Text = ath.SaveTo; tb.Columns = 60; this.Pub1.AddTD("colspan=2", tb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD("类别"); tb = new TextBox(); tb.ID = "TB_" + FrmAttachmentAttr.Sort; tb.Text = ath.Sort; tb.Columns = 60; this.Pub1.AddTD("colspan=2", tb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD("colspan=3", "帮助:类别可以为空,设置的格式为:类别名1,类别名2,类别名3"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD(""); CheckBox cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsDownload; cb.Text = "是否可下载"; cb.Checked = ath.IsDownload; this.Pub1.AddTD(cb); this.Pub1.AddTD(); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD(""); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsDelete; cb.Text = "是否可删除"; cb.Checked = ath.IsDelete; this.Pub1.AddTD(cb); this.Pub1.AddTD(); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD(""); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsUpload; cb.Text = "是否可上传"; cb.Checked = ath.IsUpload; this.Pub1.AddTD(cb); this.Pub1.AddTD(); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD(""); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsNote; cb.Text = "是否增加备注列"; cb.Checked = ath.IsNote; this.Pub1.AddTD(cb); this.Pub1.AddTD(); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD("高度"); BP.Web.Controls.TB mytb = new BP.Web.Controls.TB(); mytb.ID = "TB_" + FrmAttachmentAttr.H; mytb.Text = ath.H.ToString(); mytb.ShowType = BP.Web.Controls.TBType.Float; this.Pub1.AddTD("colspan=1", mytb); this.Pub1.AddTD("对傻瓜表单有效"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD("宽度"); mytb = new BP.Web.Controls.TB(); mytb.ID = "TB_" + FrmAttachmentAttr.W; mytb.Text = ath.W.ToString(); mytb.ShowType = BP.Web.Controls.TBType.Float; mytb.Columns = 60; this.Pub1.AddTD("colspan=1", mytb); this.Pub1.AddTD("对傻瓜表单有效"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD("自动控制"); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsAutoSize; cb.Text = "自动控制高度与宽度(对傻瓜表单有效)"; cb.Checked = ath.IsAutoSize; this.Pub1.AddTD("colspan=2", cb); this.Pub1.AddTREnd(); GroupFields gfs = new GroupFields(ath.FK_MapData); this.Pub1.AddTR1(); this.Pub1.AddTD("显示在分组"); BP.Web.Controls.DDL ddl = new BP.Web.Controls.DDL(); ddl.ID = "DDL_GroupField"; ddl.BindEntities(gfs, GroupFieldAttr.OID, GroupFieldAttr.Lab, false, BP.Web.Controls.AddAllLocation.None); ddl.SetSelectItem(ath.GroupID); this.Pub1.AddTD("colspan=2", ddl); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTD(""); Button btn = new Button(); btn.ID = "Btn_Save"; btn.Text = " Save "; btn.CssClass = "Btn"; btn.Click += new EventHandler(btn_Click); this.Pub1.AddTD(btn); if (this.Ath != null) { btn = new Button(); btn.ID = "Btn_Delete"; btn.Text = " Delete "; btn.CssClass = "Btn"; btn.Attributes["onclick"] = " return confirm('您确认吗?');"; btn.Click += new EventHandler(btn_Click); this.Pub1.AddTD(btn); } else { this.Pub1.AddTD(); } this.Pub1.AddTREnd(); this.Pub1.AddTableEnd(); }
public void EditBeforeEnd(MapAttr mapAttr) { #region 合并单元格数 this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("合并单元格数"); DDL ddl1 = new DDL(); ddl1.ID = "DDL_ColSpan"; for (int i = 1; i < 12; i++) { ddl1.Items.Add(new ListItem(i.ToString(), i.ToString())); } ddl1.SetSelectItem(mapAttr.ColSpan.ToString()); this.Pub1.AddTD(ddl1); this.Pub1.AddTD("对傻瓜表单有效"); this.Pub1.AddTREnd(); #endregion 合并单元格数 #region 字段分组 this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("字段分组"); DDL ddlGroup = new DDL(); ddlGroup.ID = "DDL_GroupID"; GroupFields gfs = new GroupFields(mapAttr.FK_MapData); ddlGroup.Bind(gfs, GroupFieldAttr.OID, GroupFieldAttr.Lab); if (mapAttr.GroupID == 0) { mapAttr.GroupID = this.GroupField; } ddlGroup.SetSelectItem(mapAttr.GroupID); this.Pub1.AddTD("colspan=3", ddlGroup); this.Pub1.AddTREnd(); #endregion 字段分组 #region 是否是数字签名字段 if (mapAttr.UIIsEnable == false && mapAttr.MyDataType == DataType.AppString && mapAttr.LGType == FieldTypeS.Normal) { this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); DDL ddl = new DDL(); ddl.ID = "DDL_SignType"; ddl.Items.Add(new ListItem("无", "0")); ddl.Items.Add(new ListItem("图片签名", "1")); ddl.Items.Add(new ListItem("CA签名", "2")); ddl.SetSelectItem((int)mapAttr.SignType); //CheckBox cb = new CheckBox(); //cb.ID = "CB_IsSigan"; //cb.Text = "是否是数字签名字段"; //cb.Checked = mapAttr.IsSigan; this.Pub1.AddTD("colspan=2", ddl); if (mapAttr.SignType == SignType.CA) { TB sigan = new TB(); sigan.ID = "TB_SiganField"; sigan.Text = mapAttr.Para_SiganField; this.Pub1.AddTD(sigan); } else if (mapAttr.SignType == SignType.Pic) { DDL ddlPic = new DDL(); ddlPic.ID = "DDL_PicType"; ddlPic.Items.Add(new ListItem("自动签名", "0")); ddlPic.Items.Add(new ListItem("手动签名", "1")); ddlPic.SetSelectItem((int)mapAttr.PicType); this.Pub1.AddTD(ddlPic); } else { this.Pub1.AddTD(); } this.Pub1.AddTREnd(); } #endregion 字段分组 #region 字段分组 this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("字体大小"); DDL ddlFont = new DDL(); ddlFont.ID = "DDL_FontSize"; ddlFont.Items.Add(new ListItem("默认", "0")); for (int i = 10; i < 28; i++) { ddlFont.Items.Add(new ListItem(i + "px", i.ToString())); } ddlFont.SetSelectItem(mapAttr.Para_FontSize); this.Pub1.AddTD("colspan=3", ddlFont); this.Pub1.AddTREnd(); #endregion 字段分组 this.Pub1.AddTRSum(); this.Pub1.Add("<TD colspan=4 align=center>"); Button btn = new Button(); btn.ID = "Btn_Save"; btn.CssClass = "Btn"; btn.Text = " 保存 "; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_SaveAndClose"; btn.CssClass = "Btn"; btn.Text = "保存并关闭"; // "保存并关闭"; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); btn = new Button(); btn.CssClass = "Btn"; btn.ID = "Btn_SaveAndNew"; btn.Text = "保存新建"; // "保存新建"; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); if (this.RefNo != null) { //btn = new Button(); //btn.ID = "Btn_AutoFull"; //btn.Text ="扩展设置"; //btn.Attributes["onclick"] = "javascript:WinOpen('AutoFull.aspx?RefNo=" + this.RefNo + "&FK_MapData=" + mapAttr.FK_MapData + "',''); return false;"; this.Pub1.Add("<input type=button class=Btn value='扩展设置' onclick=\"javascript:WinOpen('AutoFull.aspx?RefNo=" + this.RefNo + "&FK_MapData=" + mapAttr.FK_MapData + "',''); return false;\" />"); if (mapAttr.HisEditType == EditType.Edit) { btn = new Button(); btn.ID = "Btn_Del"; btn.CssClass = "Btn"; btn.Text = "删除"; btn.Click += new EventHandler(btn_Save_Click); btn.Attributes["onclick"] = " return confirm('您确认吗?');"; this.Pub1.Add(btn); } string myUrl = "EleBatch.aspx?KeyOfEn=" + mapAttr.KeyOfEn + "&FK_MapData=" + mapAttr.FK_MapData + "&EleType=MapAttr"; this.Pub1.Add("<a href='" + myUrl + "' target='M" + mapAttr.KeyOfEn + "' ><img src='../Img/Btn/Apply.gif' border=0>批处理</a>"); } string url = "Do.aspx?DoType=AddF&MyPK=" + mapAttr.FK_MapData + "&IDX=" + mapAttr.Idx; btn = new Button(); btn.ID = "Btn_New"; btn.CssClass = "Btn"; btn.Text = "新建"; btn.Click += new EventHandler(btn_Click); this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_Back"; btn.CssClass = "Btn"; btn.Text = "返回"; btn.Click += new EventHandler(btn_Click); this.Pub1.Add(btn); this.Pub1.AddTDEnd(); this.Pub1.AddTREnd(); this.Pub1.AddTableEndWithBR(); }
public void SelectColumns() { this.Pub2.AddH2("请选择要显示的字段,然后点保存按钮,系统的查询列表就以您设计的体现."); this.Pub2.AddHR(); this.Pub2.AddTable("width=90% align=left"); GroupFields gfs = new GroupFields(this.FK_Flow); MapAttrs mattrs = new MapAttrs(this.FK_MapData); MapData md = new MapData(this.FK_MapData); bool isBr = false; string attrInTable = md.AttrsInTable; foreach (GroupField gf in gfs) { this.Pub2.AddTR(); this.Pub2.AddTDTitle(gf.Lab); this.Pub2.AddTREnd(); this.Pub2.AddTR(); this.Pub2.AddTDBigDocBegain(); this.Pub2.AddTable("width=100% border=0"); isBr = false; foreach (MapAttr attr in mattrs) { if (attr.GroupID != gf.OID) { continue; } CheckBox cb = new CheckBox(); cb.ID = "CB_" + attr.KeyOfEn; cb.Text = attr.Name + "(" + attr.KeyOfEn + ")"; cb.Checked = attrInTable.Contains("@" + attr.KeyOfEn + "="); if (isBr == false) { this.Pub2.AddTR(); } this.Pub2.AddTD(cb); if (isBr) { this.Pub2.AddTREnd(); } isBr = !isBr; } this.Pub2.AddTableEnd(); this.Pub2.AddTDEnd(); this.Pub2.AddTREnd(); } this.Pub2.AddTR(); this.Pub2.AddTDTitle("未分组"); this.Pub2.AddTREnd(); this.Pub2.AddTR(); this.Pub2.AddTDBigDocBegain(); this.Pub2.AddTable("width=100% border=0"); isBr = false; foreach (MapAttr attr in mattrs) { if (gfs.Contains(attr.GroupID)) { continue; } CheckBox cb = new CheckBox(); cb.ID = "CB_" + attr.KeyOfEn; cb.Text = attr.Name + "(" + attr.KeyOfEn + ")"; cb.Checked = attrInTable.Contains("@" + attr.KeyOfEn + "="); if (isBr == false) { this.Pub2.AddTR(); } this.Pub2.AddTD(cb); if (isBr) { this.Pub2.AddTREnd(); } isBr = !isBr; } this.Pub2.AddTableEnd(); this.Pub2.AddTDEnd(); this.Pub2.AddTREnd(); this.Pub2.AddTRSum(); this.Pub2.AddTDBegin(); Button btn = new Button(); btn.Text = " Save "; btn.CssClass = "Btn"; btn.Click += new EventHandler(btn_SelectColumns_Click); this.Pub2.Add(btn); this.Pub2.AddTDEnd(); this.Pub2.AddTREnd(); this.Pub2.AddTableEnd(); }
public void EditBeforeEnd(MapAttr mapAttr) { #region 合并单元格数 isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("合并单元格数"); DDL ddl1 = new DDL(); ddl1.ID = "DDL_ColSpan"; for (int i = 1; i < 12; i++) { ddl1.Items.Add(new ListItem(i.ToString(), i.ToString())); } ddl1.SetSelectItem(mapAttr.ColSpan.ToString()); this.Pub1.AddTD(ddl1); this.Pub1.AddTD("对傻瓜表单有效"); this.Pub1.AddTREnd(); #endregion 合并单元格数 #region 字段分组 isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("字段分组"); DDL ddlGroup = new DDL(); ddlGroup.ID = "DDL_GroupID"; GroupFields gfs = new GroupFields(mapAttr.FK_MapData); ddlGroup.Bind(gfs, GroupFieldAttr.OID, GroupFieldAttr.Lab); if (mapAttr.GroupID == 0) { mapAttr.GroupID = this.GroupField; } ddlGroup.SetSelectItem(mapAttr.GroupID); this.Pub1.AddTD("colspan=3", ddlGroup); this.Pub1.AddTREnd(); #endregion 字段分组 #region 是否是数字签名字段 if (mapAttr.UIIsEnable == false && mapAttr.MyDataType == DataType.AppString && mapAttr.LGType == FieldTypeS.Normal) { isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("签名模式"); DDL ddl = new DDL(); ddl.ID = "DDL_SignType"; ddl.Items.Add(new ListItem("无", "0")); ddl.Items.Add(new ListItem("图片签名", "1")); ddl.Items.Add(new ListItem("山东CA签名", "2")); ddl.Items.Add(new ListItem("广东CA签名", "3")); ddl.SetSelectItem((int)mapAttr.SignType); this.Pub1.AddTD(ddl); if (mapAttr.SignType == SignType.CA) { TB sigan = new TB(); sigan.ID = "TB_SiganField"; sigan.Text = mapAttr.Para_SiganField; this.Pub1.AddTD(sigan); } else if (mapAttr.SignType == SignType.GDCA) { TB sigan = new TB(); sigan.ID = "TB_SiganField"; sigan.Text = mapAttr.Para_SiganField; this.Pub1.AddTD(sigan); } else if (mapAttr.SignType == SignType.Pic) { DDL ddlPic = new DDL(); ddlPic.ID = "DDL_PicType"; ddlPic.Items.Add(new ListItem("自动签名", "0")); ddlPic.Items.Add(new ListItem("手动签名", "1")); ddlPic.SetSelectItem((int)mapAttr.PicType); this.Pub1.AddTD(ddlPic); } else { this.Pub1.AddTD(); } this.Pub1.AddTREnd(); } #endregion 字段分组 #region 字段分组 isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("字体大小"); DDL ddlFont = new DDL(); ddlFont.ID = "DDL_FontSize"; ddlFont.Items.Add(new ListItem("默认", "0")); for (int i = 10; i < 28; i++) { ddlFont.Items.Add(new ListItem(i + "px", i.ToString())); } ddlFont.SetSelectItem(mapAttr.Para_FontSize); this.Pub1.AddTD(ddlFont); //是否必填字段. this.Pub1.Add("<TD>"); RadioButton rb = new RadioButton(); rb.ID = "RB_UIIsInput_0"; rb.Text = "非必填字段"; rb.GroupName = "si"; rb.Checked = !mapAttr.UIIsInput; this.Pub1.Add(rb); rb = new RadioButton(); rb.ID = "RB_UIIsInput_1"; rb.Text = "必填"; rb.GroupName = "si"; rb.Checked = mapAttr.UIIsInput; this.Pub1.Add(rb); this.Pub1.Add("</TD>"); this.Pub1.AddTREnd(); #endregion 字段分组 #region 扩展设置. if (this.RefNo != null) { isItem = this.Pub1.AddTR(isItem); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("<a href=\"javascript:WinOpen('./MapExt/PopVal.aspx?FK_MapData=" + mapAttr.FK_MapData + "&RefNo=" + mapAttr.KeyOfEn + "&MyPK=" + MapExtXmlList.PopVal + "_" + mapAttr.MyPK + "')\">设置开窗返回值</a>"); string html = "<a href=\"javascript:WinOpen('./MapExt/RegularExpression.aspx?FK_MapData=" + mapAttr.FK_MapData + "&RefNo=" + mapAttr.KeyOfEn + "&OperAttrKey=" + mapAttr.MyPK + "')\">正则表达式</a>"; html += " - <a href=\"javascript:WinOpen('./MapExt/TBFullCtrl.aspx?FK_MapData=" + mapAttr.FK_MapData + "&RefNo=" + mapAttr.KeyOfEn + "&MyPK=" + mapAttr.FK_MapData + "_" + MapExtXmlList.TBFullCtrl + "_" + mapAttr.KeyOfEn + "')\">文本框自动完成</a>"; html += " - <a href=\"javascript:WinOpen('./MapExt/AotuGenerNo.aspx?FK_MapData=" + mapAttr.FK_MapData + "&RefNo=" + mapAttr.KeyOfEn + "')\">自动生成编号</a>"; this.Pub1.AddTD(html); //this.Pub1.AddTD("<a href=\"javascript:WinOpen('./MapExt/AutoFull.aspx?FK_MapData=" + mapAttr.FK_MapData + "&ExtType=AutoFull&RefNo=" + mapAttr.MyPK + "')\">自动计算</a>"); html = "<a href=\"javascript:WinOpen('./MapExt/AutoFull.aspx?FK_MapData=" + mapAttr.FK_MapData + "&ExtType=AutoFull&RefNo=" + mapAttr.MyPK + "')\">自动计算</a>"; html += " - <a href=\"javascript:WinOpen('./MapExt/InputCheck.aspx?FK_MapData=" + mapAttr.FK_MapData + "&RefNo=" + mapAttr.MyPK + "')\">脚本验证</a>"; this.Pub1.AddTD(html); this.Pub1.AddTREnd(); } #endregion pop返回值. this.Pub1.AddTRSum(); this.Pub1.Add("<TD colspan=4 align=center>"); Button btn = new Button(); btn.ID = "Btn_Save"; btn.CssClass = "Btn"; btn.Text = " 保存 "; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_SaveAndClose"; btn.CssClass = "Btn"; btn.Text = "保存并关闭"; // "保存并关闭"; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); btn = new Button(); btn.CssClass = "Btn"; btn.ID = "Btn_SaveAndNew"; btn.Text = "保存新建"; // "保存新建"; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); if (this.RefNo != null) { if (mapAttr.HisEditType == EditType.Edit) { btn = new Button(); btn.ID = "Btn_Del"; btn.CssClass = "Btn"; btn.Text = "删除"; btn.Click += new EventHandler(btn_Save_Click); btn.Attributes["onclick"] = " return confirm('您确认吗?');"; this.Pub1.Add(btn); } string myUrl = "EleBatch.aspx?KeyOfEn=" + mapAttr.KeyOfEn + "&FK_MapData=" + mapAttr.FK_MapData + "&EleType=MapAttr"; this.Pub1.Add("<a href='" + myUrl + "' target='M" + mapAttr.KeyOfEn + "' ><img src='../Img/Btn/Apply.gif' border=0>批处理</a>"); } string url = "Do.aspx?DoType=AddF&MyPK=" + mapAttr.FK_MapData + "&IDX=" + mapAttr.Idx; btn = new Button(); btn.ID = "Btn_New"; btn.CssClass = "Btn"; btn.Text = "新建"; btn.Click += new EventHandler(btn_Click); this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_Back"; btn.CssClass = "Btn"; btn.Text = "返回"; btn.Click += new EventHandler(btn_Click); this.Pub1.Add(btn); this.Pub1.AddTDEnd(); this.Pub1.AddTREnd(); this.Pub1.AddTableEndWithBR(); }
protected void Page_Load(object sender, EventArgs e) { FrmAttachment ath = new FrmAttachment(); ath.FK_MapData = this.FK_MapData; ath.NoOfObj = this.Ath; ath.FK_Node = this.FK_Node; if (this.FK_Node == 0) { ath.MyPK = this.FK_MapData + "_" + this.Ath; } else { ath.MyPK = this.FK_MapData + "_" + this.Ath + "_" + this.FK_Node; } int i = ath.RetrieveFromDBSources(); if (i == 0 && this.FK_Node != 0) { /*这里处理 独立表单解决方案, 如果有FK_Node 就说明该节点需要单独控制该附件的属性. */ MapData mapData = new MapData(); mapData.RetrieveByAttr(MapDataAttr.No, this.FK_MapData); if (mapData.AppType == "0") { FrmAttachment souceAthMent = new FrmAttachment(); // 查询出来原来的数据. int rowCount = souceAthMent.Retrieve(FrmAttachmentAttr.FK_MapData, this.FK_MapData, FrmAttachmentAttr.NoOfObj, this.Ath, FrmAttachmentAttr.FK_Node, "0"); if (rowCount > 0) { ath.Copy(souceAthMent); } } if (this.FK_Node == 0) { ath.MyPK = this.FK_MapData + "_" + this.Ath; } else { ath.MyPK = this.FK_MapData + "_" + this.Ath + "_" + this.FK_Node; } //插入一个新的. ath.FK_Node = this.FK_Node; ath.FK_MapData = this.FK_MapData; ath.NoOfObj = this.Ath; ath.DirectInsert(); } #region 基本属性. this.Title = "附件属性设置"; this.Pub1.AddTable(); this.Pub1.AddCaption("附件属性设置"); int idx = 0; this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTDTitle("colspan=3", "基本属性"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("编号"); TextBox tb = new TextBox(); tb.ID = "TB_" + FrmAttachmentAttr.NoOfObj; tb.Text = ath.NoOfObj; if (this.Ath != null) { tb.Enabled = false; } this.Pub1.AddTD(tb); this.Pub1.AddTD("标示号只能英文字母数字或下滑线."); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("名称"); tb = new TextBox(); tb.ID = "TB_" + FrmAttachmentAttr.Name; tb.Text = ath.Name; this.Pub1.AddTD(tb); this.Pub1.AddTD("附件的中文名称."); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("文件格式"); tb = new TextBox(); tb.ID = "TB_" + FrmAttachmentAttr.Exts; tb.Text = ath.Exts; this.Pub1.AddTD(tb); this.Pub1.AddTD("实例:doc,docx,xls,多种格式用逗号分开."); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("文件数据存储方式"); DDL ddl = new DDL(); ddl.ID = "DDL_" + FrmAttachmentAttr.SaveWay; ddl.Items.Add(new ListItem("按文件方式保存", "0")); ddl.Items.Add(new ListItem("保存到数据库", "1")); ddl.SetSelectItem(ath.SaveWay); this.Pub1.AddTD(ddl); this.Pub1.AddTD("上传的附件如何保存?"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("保存到"); tb = new TextBox(); tb.ID = "TB_" + FrmAttachmentAttr.SaveTo; tb.Text = ath.SaveTo; tb.Columns = 60; this.Pub1.AddTD("colspan=2", "文件存储格式才有意义", tb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("类别"); tb = new TextBox(); tb.ID = "TB_" + FrmAttachmentAttr.Sort; tb.Text = ath.Sort; tb.Columns = 60; this.Pub1.AddTD("colspan=2", tb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("colspan=3", "帮助:类别可以为空,设置的格式为:列头显示名称@类别名1,类别名2,类别名3(列头显示名称@ :可以不写,默认为:类别)"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("完整性校验"); // BP.Web.Controls.DDL ddl=new DDL(); ddl = new DDL(); ddl.ID = "DDL_UploadFileNumCheck"; ddl.BindSysEnum("UploadFileCheck", (int)ath.UploadFileNumCheck); this.Pub1.AddTD("colspan=2", ddl); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("高度"); BP.Web.Controls.TB mytb = new BP.Web.Controls.TB(); mytb.ID = "TB_" + FrmAttachmentAttr.H; mytb.Text = ath.H.ToString(); mytb.ShowType = BP.Web.Controls.TBType.Float; this.Pub1.AddTD("colspan=1", mytb); this.Pub1.AddTD("对傻瓜表单有效"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("宽度"); mytb = new BP.Web.Controls.TB(); mytb.ID = "TB_" + FrmAttachmentAttr.W; mytb.Text = ath.W.ToString(); mytb.ShowType = BP.Web.Controls.TBType.Float; mytb.Columns = 60; this.Pub1.AddTD("colspan=1", mytb); this.Pub1.AddTD("对傻瓜表单有效"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("自动控制"); CheckBox cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsAutoSize; cb.Text = "自动控制高度与宽度(对傻瓜表单有效)"; cb.Checked = ath.IsAutoSize; this.Pub1.AddTD("colspan=2", cb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsNote; cb.Text = "是否增加备注列"; cb.Checked = ath.IsNote; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsShowTitle; cb.Text = "是否显示标题列"; cb.Checked = ath.IsShowTitle; this.Pub1.AddTD(cb); this.Pub1.AddTD(""); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsVisable; cb.Text = "是否可见(不打勾就隐藏,隐藏后就显示不到表单上,可以显示在组件里.)"; cb.Checked = ath.IsVisable; this.Pub1.AddTD("colspan=3", cb); this.Pub1.AddTREnd(); GroupFields gfs = new GroupFields(ath.FK_MapData); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("显示在分组"); ddl = new BP.Web.Controls.DDL(); ddl.ID = "DDL_GroupField"; ddl.BindEntities(gfs, GroupFieldAttr.OID, GroupFieldAttr.Lab, false, BP.Web.Controls.AddAllLocation.None); ddl.SetSelectItem(ath.GroupID); this.Pub1.AddTD("colspan=1", ddl); this.Pub1.AddTD("对傻瓜表单有效"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("展现方式"); ddl = new BP.Web.Controls.DDL(); ddl.ID = "DDL_" + FrmAttachmentAttr.FileShowWay; ddl.Items.Clear(); ddl.Items.Add(new ListItem("Table方式", "0")); ddl.Items.Add(new ListItem("图片轮播方式", "1")); ddl.Items.Add(new ListItem("自由模式", "2")); ddl.SelectedValue = Convert.ToString((int)ath.FileShowWay); this.Pub1.AddTD("colspan=2", ddl); this.Pub1.AddTREnd(); #endregion 基本属性. #region 权限控制. this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTDTitle("colspan=3", "权限控制" + BP.WF.Glo.GenerHelpCCForm("帮助", null, null)); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsDownload; cb.Text = "是否可下载"; cb.Checked = ath.IsDownload; this.Pub1.AddTD(cb); ddl = new BP.Web.Controls.DDL(); ddl.ID = "DDL_" + FrmAttachmentAttr.IsDelete; ddl.Items.Clear(); ddl.Items.Add(new ListItem("不能删除", "0")); ddl.Items.Add(new ListItem("删除所有", "1")); ddl.Items.Add(new ListItem("只能删除自己上传的", "2")); ddl.SetSelectItem(ath.IsDeleteInt); this.Pub1.AddTD(ddl); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsUpload; cb.Text = "是否可上传"; cb.Checked = ath.IsUpload; this.Pub1.AddTD(cb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsOrder; cb.Text = "是否可以排序"; cb.Checked = ath.IsOrder; this.Pub1.AddTD(cb); this.Pub1.AddTD("使用上传控件方式"); ddl = new BP.Web.Controls.DDL(); ddl.ID = "DDL_" + FrmAttachmentAttr.UploadCtrl; ddl.Items.Clear(); ddl.Items.Add(new ListItem("批量上传", "0")); ddl.Items.Add(new ListItem("普通上传", "1")); ddl.SetSelectItem(ath.UploadCtrl); this.Pub1.AddTD(ddl); this.Pub1.AddTREnd(); if (ath.IsNodeSheet == true) { this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("数据显示控制方式"); ddl = new BP.Web.Controls.DDL(); ddl.ID = "DDL_CtrlWay"; ddl.Items.Clear(); ddl.Items.Add(new ListItem("按主键", "0")); ddl.Items.Add(new ListItem("FID", "1")); ddl.Items.Add(new ListItem("ParentWorkID", "2")); ddl.Items.Add(new ListItem("仅可以查看自己上传数据", "3")); ddl.SetSelectItem((int)ath.HisCtrlWay); this.Pub1.AddTD("colspan=2", ddl); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("子线程节点控制(对节点表单有效)"); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsToHeLiuHZ; cb.Text = "该附件是否要汇总到合流节点上去?(对子线程节点有效)"; cb.Checked = ath.IsToHeLiuHZ; this.Pub1.AddTD("colspan=2", cb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("合流节点控制(对节点表单有效)"); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsHeLiuHuiZong; cb.Text = "是否是合流节点的汇总附件组件?(对合流节点有效)"; cb.Checked = ath.IsHeLiuHuiZong; this.Pub1.AddTD("colspan=2", cb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("数据上传控制方式"); ddl = new BP.Web.Controls.DDL(); ddl.ID = "DDL_AthUploadWay"; ddl.Items.Clear(); ddl.Items.Add(new ListItem("继承模式", "0")); ddl.Items.Add(new ListItem("协作模式", "1")); ddl.SetSelectItem((int)ath.AthUploadWay); this.Pub1.AddTD("colspan=2", ddl); this.Pub1.AddTREnd(); this.Pub1.AddTREnd(); } #endregion 权限控制. #region WebOffice控制方式. this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTDTitle("colspan=3", "WebOffice控制方式(如果上传的是excel word附件,在打开的时候对其的控制)."); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsWoEnableWF; cb.Text = "是否启用weboffice?"; cb.Checked = ath.IsWoEnableWF; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsWoEnableSave; cb.Text = "是否启用保存?"; cb.Checked = ath.IsWoEnableSave; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsWoEnableReadonly; cb.Text = "是否只读?"; cb.Checked = ath.IsWoEnableReadonly; this.Pub1.AddTD(cb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsWoEnableRevise; cb.Text = "是否启用修订?"; cb.Checked = ath.IsWoEnableRevise; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsWoEnableViewKeepMark; cb.Text = "是否查看用户留痕?"; cb.Checked = ath.IsWoEnableViewKeepMark; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsWoEnablePrint; cb.Text = "是否打印?"; cb.Checked = ath.IsWoEnablePrint; this.Pub1.AddTD(cb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsWoEnableOver; cb.Text = "是否启用套红?"; cb.Checked = ath.IsWoEnableOver; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsWoEnableSeal; cb.Text = "是否启用签章?"; cb.Checked = ath.IsWoEnableSeal; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsWoEnableTemplete; cb.Text = "是否启用模板文件?"; cb.Checked = ath.IsWoEnableTemplete; this.Pub1.AddTD(cb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsWoEnableCheck; cb.Text = "是否记录节点信息?"; cb.Checked = ath.IsWoEnableCheck; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsWoEnableInsertFlow; cb.Text = "是否启用插入流程?"; cb.Checked = ath.IsWoEnableInsertFlow; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsWoEnableInsertFengXian; cb.Text = "是否启用插入风险点?"; cb.Checked = ath.IsWoEnableInsertFengXian; this.Pub1.AddTD(cb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsWoEnableMarks; cb.Text = "是否进入留痕模式?"; cb.Checked = ath.IsWoEnableMarks; this.Pub1.AddTD(cb); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.IsWoEnableDown; cb.Text = "是否启用下载?"; cb.Checked = ath.IsWoEnableDown; this.Pub1.AddTD(cb); this.Pub1.AddTD(""); this.Pub1.AddTREnd(); this.Pub1.AddTREnd(); #endregion WebOffice控制方式. #region 快捷键生成规则. this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTDTitle("colspan=3", "快捷键生成规则."); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); cb = new CheckBox(); cb.ID = "CB_" + FrmAttachmentAttr.FastKeyIsEnable; cb.Text = "是否启用生成快捷键?(启用就会按照规则生成放在附件的同一个目录里面)"; cb.Checked = ath.FastKeyIsEnable; this.Pub1.AddTD("colspan=3", cb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); tb = new BP.Web.Controls.TB(); tb.ID = "TB_" + FrmAttachmentAttr.FastKeyGenerRole; tb.Text = ath.FastKeyGenerRole; tb.Columns = 30; this.Pub1.AddTD("colspan=3", tb); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("colspan=3", "格式:*FiledName.*OID"); this.Pub1.AddTREnd(); #endregion 快捷键生成规则. #region 保存按钮. this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD(""); Button btn = new Button(); btn.ID = "Btn_Save"; btn.Text = " Save "; btn.CssClass = "Btn"; btn.Click += new EventHandler(btn_Click); this.Pub1.AddTD(btn); if (this.Ath != null) { btn = new Button(); btn.ID = "Btn_Delete"; btn.Text = " Delete "; btn.CssClass = "Btn"; btn.Attributes["onclick"] = " return confirm('您确认吗?');"; btn.Click += new EventHandler(btn_Click); this.Pub1.AddTD(btn); } else { this.Pub1.AddTD(); } this.Pub1.AddTREnd(); #endregion 保存按钮. this.Pub1.AddTableEnd(); }
void btn_Click(object sender, EventArgs e) { Button btn = sender as Button; try { switch (this.DoType) { case "New": default: MapDtl dtlN = new MapDtl(); dtlN = (MapDtl)this.Pub1.Copy(dtlN); try { dtlN.GroupField = this.Pub1.GetDDLByID("DDL_GroupField").SelectedItemStringVal; } catch { } if (this.DoType == "New") { if (dtlN.IsExits) { this.Alert("已存在编号:" + dtlN.No); return; } } dtlN.FK_MapData = this.FK_MapData; dtlN.GroupID = 0; dtlN.RowIdx = 0; // 参数属性. dtlN.DtlSaveModel = (DtlSaveModel)this.Pub1.GetDDLByID("DDL_" + MapDtlAttr.DtlSaveModel).SelectedItemIntVal; dtlN.DtlAddRecModel = (DtlAddRecModel)this.Pub1.GetDDLByID("DDL_" + MapDtlAttr.DtlAddRecModel).SelectedItemIntVal; GroupFields gfs1 = new GroupFields(this.FK_MapData); if (gfs1.Count == 1) { GroupField gf = (GroupField)gfs1[0]; dtlN.GroupID = gf.OID; } else { dtlN.GroupID = this.Pub1.GetDDLByID("DDL_GroupID").SelectedItemIntVal; } dtlN.Insert(); if (btn.ID.Contains("AndClose")) { this.WinClose(); return; } this.Response.Redirect("MapDtl.aspx?DoType=Edit&FK_MapDtl=" + dtlN.No + "&FK_MapData=" + this.FK_MapData, true); break; case "Edit": MapDtl dtl = new MapDtl(this.FK_MapDtl); dtl = (MapDtl)this.Pub1.Copy(dtl); //参数保存. dtl.IsEnableLink = this.Pub1.GetCBByID("CB_" + MapDtlAttr.IsEnableLink).Checked; //手动保存,added by liuxc,2016-4-7 dtl.DtlSaveModel = (DtlSaveModel)this.Pub1.GetDDLByID("DDL_" + MapDtlAttr.DtlSaveModel).SelectedItemIntVal; dtl.DtlAddRecModel = (DtlAddRecModel)this.Pub1.GetDDLByID("DDL_" + MapDtlAttr.DtlAddRecModel).SelectedItemIntVal; if (this.FK_Node != 0) { //是否是分流. add 2015-06-30. dtl.IsFLDtl = this.Pub1.GetCBByID("CB_" + MapDtlAttr.IsFLDtl).Checked; //子线程处理字段. if (this.Pub1.GetDDLByID("DDL_" + MapDtlAttr.SubThreadGroupMark).Items.Count > 0) { dtl.SubThreadGroupMark = this.Pub1.GetDDLByID("DDL_" + MapDtlAttr.SubThreadGroupMark).SelectedItemStringVal; } if (this.Pub1.GetDDLByID("DDL_" + MapDtlAttr.SubThreadWorker).Items.Count > 0) { dtl.SubThreadWorker = this.Pub1.GetDDLByID("DDL_" + MapDtlAttr.SubThreadWorker).SelectedItemStringVal; } } dtl.LinkLabel = this.Pub1.GetTBByID("TB_" + MapDtlAttr.LinkLabel).Text; dtl.LinkTarget = this.Pub1.GetTBByID("TB_" + MapDtlAttr.LinkTarget).Text; dtl.LinkUrl = this.Pub1.GetTBByID("TB_" + MapDtlAttr.LinkUrl).Text; //锁定. dtl.IsRowLock = this.Pub1.GetCBByID("CB_" + MapDtlAttr.IsRowLock).Checked; //分组字段。 try { dtl.GroupField = this.Pub1.GetDDLByID("DDL_GroupField").SelectedItemStringVal; } catch { } if (this.DoType == "New") { if (dtl.IsExits) { this.Alert("已存在编号:" + dtl.No); return; } } dtl.FK_MapData = this.FK_MapData; GroupFields gfs = new GroupFields(dtl.FK_MapData); if (gfs.Count > 1) { dtl.GroupID = this.Pub1.GetDDLByID("DDL_GroupID").SelectedItemIntVal; } if (dtl.IsEnableAthM) { /*如果启用了多附件.*/ FrmAttachment ath = new FrmAttachment(); ath.MyPK = dtl.No + "_AthMDtl"; ath.FK_MapData = dtl.No; ath.NoOfObj = "AthMDtl"; ath.Name = "从表行记录附件"; if (ath.RetrieveFromDBSources() == 0) { ath.Insert(); } } if (this.DoType == "New") { dtl.Insert(); } else { dtl.Update(); } if (btn.ID.Contains("AndC")) { this.WinClose(); return; } this.Response.Redirect("MapDtl.aspx?DoType=Edit&FK_MapDtl=" + dtl.No + "&FK_MapData=" + this.FK_MapData, true); break; } } catch (Exception ex) { this.Alert(ex.Message); } }
public void BindTable(MapAttr mapAttr) { this.Pub1.AddTable(); this.Pub1.AddTR(); this.Pub1.AddTDTitle("ID"); this.Pub1.AddTDTitle("项目"); this.Pub1.AddTDTitle("值"); this.Pub1.AddTDTitle("描述"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("字段中文名"); // 字段中文名称 TB tb = new TB(); tb.ID = "TB_Name"; tb.Text = mapAttr.Name; tb.Attributes["width"] = "100%"; this.Pub1.AddTD(tb); this.Pub1.AddTD(""); this.Pub1.AddTREnd(); this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("字段英文名"); // "字段英文名称" tb = new TB(); if (this.RefNo != null) { this.Pub1.AddTD(mapAttr.KeyOfEn); } else { tb = new TB(); tb.ID = "TB_KeyOfEn"; tb.Text = mapAttr.KeyOfEn; this.Pub1.AddTD(tb); } if (string.IsNullOrEmpty(mapAttr.KeyOfEn)) { this.Pub1.AddTD("字母/数字/下划线组合"); } else { this.Pub1.AddTD("<a href=\"javascript:clipboardData.setData('Text','" + mapAttr.KeyOfEn + "');alert('已经copy到粘帖版上');\" ><img src='../Img/Btn/Copy.gif' class='ICON' />复制字段名</a></TD>"); } this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("外键表/类"); // 字段中文名称 tb = new TB(); tb.ID = "TB_UIBindKey"; tb.Text = mapAttr.UIBindKey; tb.Attributes["width"] = "100%"; this.Pub1.AddTD(tb); this.Pub1.AddTD(""); this.Pub1.AddTREnd(); this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("默认值"); // "默认值" tb = new TB(); tb.ID = "TB_DefVal"; tb.Text = mapAttr.Name; tb.Attributes["width"] = "100%"; tb.Text = mapAttr.DefValReal; this.Pub1.AddTD(tb); //DDL ddl = new DDL(); //ddl.ID = "DDL"; //ddl.BindEntities(mapAttr.HisEntitiesNoName); //ddl.SetSelectItem(mapAttr.DefVal); // this.Pub1.AddTD(ddl); // this.Pub1.AddTD(ddl); if (mapAttr.UIBindKey.Contains(".")) { this.Pub1.AddTD("<a href=\"javascript:WinOpen('../Comm/Search.aspx?EnsName=" + mapAttr.UIBindKey + "','df');\" >打开</a>"); } else { this.Pub1.AddTD("<a href=\"javascript:WinOpen('../MapDef/SFTableEditData.aspx?RefNo=" + mapAttr.UIBindKey + "','df');\" >打开</a>"); } this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("是否可编辑"); this.Pub1.Add("<TD>"); RadioButton rb = new RadioButton(); rb.ID = "RB_UIIsEnable_0"; rb.Text = "不可编辑"; //"不可编辑"; rb.GroupName = "s"; if (mapAttr.UIIsEnable) { rb.Checked = false; } else { rb.Checked = true; } this.Pub1.Add(rb); rb = new RadioButton(); rb.ID = "RB_UIIsEnable_1"; rb.Text = "可编辑"; //"可编辑"; rb.GroupName = "s"; if (mapAttr.UIIsEnable) { rb.Checked = true; } else { rb.Checked = false; } this.Pub1.Add(rb); this.Pub1.AddTDEnd(); this.Pub1.AddTD(""); this.Pub1.AddTREnd(); #region 是否可界面可见 this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("是否界面可见"); //是否界面可见 this.Pub1.AddTDBegin(); rb = new RadioButton(); rb.ID = "RB_UIVisible_0"; rb.Text = "不可见"; // 界面不可见 rb.GroupName = "sa3"; if (mapAttr.UIVisible) { rb.Checked = false; } else { rb.Checked = true; } this.Pub1.Add(rb); if (mapAttr.IsTableAttr) { rb.Enabled = false; } rb = new RadioButton(); rb.ID = "RB_UIVisible_1"; rb.Text = "界面可见"; // 界面可见; rb.GroupName = "sa3"; if (mapAttr.UIVisible) { rb.Checked = true; } else { rb.Checked = false; } if (mapAttr.IsTableAttr) { rb.Enabled = false; } this.Pub1.Add(rb); this.Pub1.AddTDEnd(); this.Pub1.AddTD("不可见则为隐藏字段."); this.Pub1.AddTREnd(); #endregion 是否可界面可见 #region 是否可单独行显示 this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("呈现方式"); //呈现方式; this.Pub1.AddTDBegin(); rb = new RadioButton(); rb.ID = "RB_UIIsLine_0"; rb.Text = "两列显示"; // 两行 rb.GroupName = "sa"; if (mapAttr.UIIsLine) { rb.Checked = false; } else { rb.Checked = true; } this.Pub1.Add(rb); rb = new RadioButton(); rb.ID = "RB_UIIsLine_1"; rb.Text = "整行显示"; // "一行"; rb.GroupName = "sa"; if (mapAttr.UIIsLine) { rb.Checked = true; } else { rb.Checked = false; } this.Pub1.Add(rb); this.Pub1.AddTDEnd(); this.Pub1.AddTD("对傻瓜表单有效"); //this.Pub1.AddTD("控制该它在表单的显示方式"); this.Pub1.AddTREnd(); #endregion 是否可编辑 #region 字段分组 this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("字段分组"); DDL ddlGroup = new DDL(); ddlGroup.ID = "DDL_GroupID"; GroupFields gfs = new GroupFields(mapAttr.FK_MapData); ddlGroup.Bind(gfs, GroupFieldAttr.OID, GroupFieldAttr.Lab); if (mapAttr.GroupID == 0) { mapAttr.GroupID = this.GroupField; } ddlGroup.SetSelectItem(mapAttr.GroupID); this.Pub1.AddTD("colspan=2", ddlGroup); this.Pub1.AddTD(); //( this.to "隶属分组"); this.Pub1.AddTREnd(); #endregion 字段分组 #region 字段按钮 this.Pub1.AddTRSum(); this.Pub1.Add("<TD colspan=4>"); Button btn = new Button(); btn.ID = "Btn_Save"; btn.Text = "保存"; btn.Click += new EventHandler(btn_Save_Click); btn.CssClass = "Btn"; this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_SaveAndClose1"; btn.CssClass = "Btn"; btn.Text = "关闭"; btn.Attributes["onclick"] = " window.close(); return false;"; this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_SaveAndClose"; btn.CssClass = "Btn"; btn.Text = "保存并关闭"; //"保存并关闭"; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); btn = new Button(); btn.ID = "Btn_SaveAndNew"; btn.CssClass = "Btn"; btn.Text = "保存并新建"; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); if (this.RefNo != null) { btn = new Button(); btn.ID = "Btn_AutoFull"; btn.CssClass = "Btn"; btn.Text = "扩展设置"; // btn.Click += new EventHandler(btn_Save_Click); btn.Attributes["onclick"] = "javascript:WinOpen('AutoFull.aspx?RefNo=" + this.RefNo + "&FK_MapData=" + mapAttr.FK_MapData + "',''); return false;"; this.Pub1.Add(btn); if (mapAttr.HisEditType == EditType.Edit) { btn = new Button(); btn.ID = "Btn_Del"; btn.CssClass = "Btn"; btn.Text = "删除"; btn.Click += new EventHandler(btn_Save_Click); btn.Attributes["onclick"] = " return confirm('您确认吗?');"; this.Pub1.Add(btn); } string myUrl = "EleBatch.aspx?KeyOfEn=" + mapAttr.KeyOfEn + "&FK_MapData=" + mapAttr.FK_MapData + "&EleType=MapAttr"; this.Pub1.Add("<a href='" + myUrl + "' target='M" + mapAttr.KeyOfEn + "' ><img src='../Img/Btn/Apply.gif' border=0>批处理</a>"); } string url = "Do.aspx?DoType=AddF&MyPK=" + mapAttr.FK_MapData + "&IDX=" + mapAttr.Idx; this.Pub1.Add("<a href='" + url + "'><img src='../Img/Btn/New.gif' border=0>新建</a></TD>"); this.Pub1.AddTREnd(); this.Pub1.AddTableEnd(); #endregion 字段按钮 }
/// <summary>Возвращает список групп указанного пользователя.</summary> /// <param name="uid">ID пользователя, группы которого необходимо получить</param> /// <param name="extended">Если указать в качестве этого параметра 1, то будет возвращена полная информация о группах пользователя</param> /// <param name="filter">Список фильтров сообществ, которые необходимо вернуть, перечисленные через запятую</param> /// <param name="fields">Список полей из информации о группах, которые необходимо получить</param> /// <param name="offset">Смещение, необходимое для выборки определённого подмножества групп</param> /// <param name="count">Количество записей которое необходимо вернуть, не более 1000</param> /// <returns>Ответ сервера в XML или JSON формате.</returns> private VKResponseBase get(System.Int64? uid, System.Boolean? extended, GroupsFilter? filter, GroupFields? fields, System.Int32? offset, System.Int32? count) { manager.AddValueByName("@uid", uid); manager.AddValueByName("@extended", extended); manager.AddValueByName("@filter", filter); manager.AddValueByName("@fields", fields); manager.AddValueByName("@offset", offset); manager.AddValueByName("@count", count); return new VKResponseBase(GetResponse("get"), IsXMLResponse); }
/// <summary> /// 执行旧版本的兼容性检查. /// </summary> public string DoCheckFixFrmForUpdateVer() { // 更新状态. DBAccess.RunSQL("UPDATE Sys_GroupField SET CtrlType='' WHERE CtrlType IS NULL"); DBAccess.RunSQL("UPDATE Sys_GroupField SET CtrlID='' WHERE CtrlID IS NULL"); DBAccess.RunSQL("UPDATE Sys_GroupField SET CtrlID='' WHERE CtrlID IS NULL"); //删除重影数据. DBAccess.RunSQL("DELETE FROM Sys_GroupField WHERE CtrlType='FWC' and CTRLID is null"); //一直遇到遇到自动变长的问题, 强制其修复过来. DBAccess.RunSQL("UPDATE Sys_Mapattr SET colspan=3 WHERE UIHeight<=38 AND colspan=4"); string str = ""; //处理失去分组的字段. string sql = "SELECT MyPK FROM Sys_MapAttr WHERE FK_MapData='" + this.No + "' AND GroupID NOT IN (SELECT OID FROM Sys_GroupField WHERE FrmID='" + this.No + "' AND ( CtrlType='' OR CtrlType IS NULL) ) OR GroupID IS NULL "; MapAttrs attrs = new MapAttrs(); attrs.RetrieveInSQL(sql); if (attrs.Count != 0) { GroupField gf = null; GroupFields gfs = new GroupFields(this.No); foreach (GroupField mygf in gfs) { if (mygf.CtrlID == "") { gf = mygf; } } if (gf == null) { gf = new GroupField(); gf.Lab = "基本信息"; gf.FrmID = this.No; gf.Insert(); } //设置GID. foreach (MapAttr attr in attrs) { attr.Update(MapAttrAttr.GroupID, gf.OID); } } //从表. MapDtls dtls = new MapDtls(this.No); foreach (MapDtl dtl in dtls) { GroupField gf = new GroupField(); int i = gf.Retrieve(GroupFieldAttr.CtrlID, dtl.No, GroupFieldAttr.FrmID, this.No); if (i == 1) { continue; } //GroupField gf = new GroupField(); //if (gf.IsExit(GroupFieldAttr.CtrlID, dtl.No) == true && !DataType.IsNullOrEmpty(gf.CtrlType)) // continue; gf.Lab = dtl.Name; gf.CtrlID = dtl.No; gf.CtrlType = "Dtl"; gf.FrmID = dtl.FK_MapData; gf.DirectSave(); str += "@为从表" + dtl.Name + " 增加了分组."; } // 框架. MapFrames frams = new MapFrames(this.No); foreach (MapFrame fram in frams) { GroupField gf = new GroupField(); int i = gf.Retrieve(GroupFieldAttr.CtrlID, fram.MyPK, GroupFieldAttr.FrmID, this.No); if (i == 1) { continue; } gf.Lab = fram.Name; gf.CtrlID = fram.MyPK; gf.CtrlType = "Frame"; gf.EnName = fram.FK_MapData; gf.Insert(); str += "@为框架 " + fram.Name + " 增加了分组."; } // 附件. FrmAttachments aths = new FrmAttachments(this.No); foreach (FrmAttachment ath in aths) { if (ath.IsVisable == false) { continue; } GroupField gf = new GroupField(); int i = gf.Retrieve(GroupFieldAttr.CtrlID, ath.MyPK, GroupFieldAttr.FrmID, this.No); if (i == 1) { continue; } gf.Lab = ath.Name; gf.CtrlID = ath.MyPK; gf.CtrlType = "Ath"; gf.FrmID = ath.FK_MapData; gf.Insert(); str += "@为附件 " + ath.Name + " 增加了分组."; } if (this.IsNodeFrm == true) { FrmNodeComponent conn = new FrmNodeComponent(this.NodeID); conn.Update(); } //删除重复的数据, 比如一个从表显示了多个分组里. 增加此部分. if (SystemConfig.AppCenterDBType == DBType.Oracle) { sql = "SELECT * FROM (SELECT FrmID,CtrlID,CtrlType, count(*) as Num FROM sys_groupfield WHERE CtrlID!='' GROUP BY FrmID,CtrlID,CtrlType ) WHERE Num > 1"; } else { sql = "SELECT * FROM (SELECT FrmID,CtrlID,CtrlType, count(*) as Num FROM sys_groupfield WHERE CtrlID!='' GROUP BY FrmID,CtrlID,CtrlType ) AS A WHERE A.Num > 1"; } DataTable dt = DBAccess.RunSQLReturnTable(sql); foreach (DataRow dr in dt.Rows) { string enName = dr[0].ToString(); string ctrlID = dr[1].ToString(); string ctrlType = dr[2].ToString(); GroupFields gfs = new GroupFields(); gfs.Retrieve(GroupFieldAttr.FrmID, enName, GroupFieldAttr.CtrlID, ctrlID, GroupFieldAttr.CtrlType, ctrlType); if (gfs.Count <= 1) { continue; } foreach (GroupField gf in gfs) { gf.Delete(); //删除其中的一个. break; } } if (str == "") { return("检查成功."); } return(str + ", @@@ 检查成功。"); }
/// <summary>Возвращает информацию о заданной группе или о нескольких группах.</summary> /// <param name="gids">ID групп, перечисленные через запятую, информацию о которых необходимо получить</param> /// <param name="fields">Список полей из информации о группах, которые необходимо получить</param> /// <returns>Ответ сервера в XML или JSON формате.</returns> private VKResponseBase getById(IdList gids, GroupFields? fields) { manager.AddValueByName("@gids", gids); manager.AddValueByName("@fields", fields); return new VKResponseBase(GetResponse("getById"), IsXMLResponse); }
protected void Page_Load(object sender, EventArgs e) { MapData md = new MapData(this.FK_MapData); this.Title = md.Name + " - 设计一对多"; MapM2M m2m = new MapM2M(this.FK_MapData, this.NoOfObj); if (m2m.HisM2MType == M2MType.M2MM) { this.Response.Redirect("MapM2MM.aspx?FK_MapData=" + this.FK_MapData + "&NoOfObj=" + this.NoOfObj, true); return; } this.Pub1.AddTable(); this.Pub1.AddCaptionLeft("一对多属性"); int idx = 1; this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("编号"); TB tb = new TB(); tb.ID = "TB_" + MapM2MAttr.NoOfObj; tb.Text = m2m.NoOfObj; if (m2m.IsExits) { tb.Enabled = false; } this.Pub1.AddTD(tb); this.Pub1.AddTD(); this.Pub1.AddTREnd(); this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("描述"); tb = new TB(); tb.ID = "TB_" + MapM2MAttr.Name; tb.Text = m2m.Name; tb.Columns = 50; this.Pub1.AddTD("colspan=2", tb); this.Pub1.AddTREnd(); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("主体数据源<font color=red>*</font>"); tb = new TB(); tb.TextMode = TextBoxMode.MultiLine; tb.Rows = 3; tb.ID = "TB_" + MapM2MAttr.DBOfObjs; tb.Text = m2m.DBOfObjs; tb.Columns = 50; this.Pub1.AddTD("colspan=2", tb); this.Pub1.AddTREnd(); this.Pub1.AddTREnd(); this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("分组数据源"); tb = new TB(); tb.ID = "TB_" + MapM2MAttr.DBOfGroups; tb.Text = m2m.DBOfGroups; tb.Columns = 50; tb.TextMode = TextBoxMode.MultiLine; tb.Rows = 3; this.Pub1.AddTD("colspan=2", tb); this.Pub1.AddTREnd(); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("框架宽度"); tb = new TB(); tb.ID = "TB_" + MapM2MAttr.W; tb.ShowType = TBType.Num; tb.Text = m2m.W.ToString(); this.Pub1.AddTD(tb); this.Pub1.AddTD(); this.Pub1.AddTREnd(); this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("框架高度"); tb = new TB(); tb.ID = "TB_" + MapM2MAttr.H; tb.ShowType = TBType.Num; tb.Text = m2m.H.ToString(); this.Pub1.AddTD(tb); this.Pub1.AddTD(); this.Pub1.AddTREnd(); this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("记录呈现列数"); tb = new TB(); tb.ID = "TB_" + MapM2MAttr.Cols; tb.ShowType = TBType.Num; tb.Text = m2m.Cols.ToString(); this.Pub1.AddTD(tb); this.Pub1.AddTD(); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("显示方式"); DDL ddl = new DDL(); ddl.ID = "DDL_" + MapM2MAttr.ShowWay; ddl.BindSysEnum("FrmUrlShowWay", (int)m2m.ShowWay); this.Pub1.AddTD(ddl); this.Pub1.AddTD("请参考手册"); this.Pub1.AddTREnd(); this.Pub1.AddTR(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("权限"); this.Pub1.AddTDBegin("colspan=2"); CheckBox cb = new CheckBox(); cb.Checked = m2m.IsDelete; cb.Text = "是否可以删除?"; cb.ID = "CB_IsDelete"; this.Pub1.Add(cb); cb = new CheckBox(); cb.Checked = m2m.IsDelete; cb.Text = "是否可以增加?"; cb.ID = "CB_IsInsert"; this.Pub1.Add(cb); this.Pub1.AddTDEnd(); this.Pub1.AddTREnd(); GroupFields gfs = new GroupFields(md.No); this.Pub1.AddTR1(); this.Pub1.AddTDIdx(idx++); this.Pub1.AddTD("显示在分组"); ddl = new DDL(); ddl.ID = "DDL_GroupField"; ddl.BindEntities(gfs, GroupFieldAttr.OID, GroupFieldAttr.Lab, false, AddAllLocation.None); ddl.SetSelectItem(m2m.GroupID); this.Pub1.AddTD("colspan=2", ddl); this.Pub1.AddTREnd(); this.Pub1.AddTRSum(); this.Pub1.AddTDBegin("colspan=4 align=center"); Button btn = new Button(); btn.ID = "Btn_Save"; btn.CssClass = "Btn"; btn.Text = " 保存 "; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); btn = new Button(); btn.CssClass = "Btn"; btn.ID = "Btn_SaveAndClose"; btn.Text = " 保存并关闭 "; btn.Click += new EventHandler(btn_Save_Click); this.Pub1.Add(btn); if (m2m.IsExits) { btn = new Button(); btn.CssClass = "Btn"; btn.ID = "Btn_Del"; btn.Text = "删除"; btn.Attributes["onclick"] = " return confirm('您确认吗?');"; btn.Click += new EventHandler(btn_Del_Click); this.Pub1.Add(btn); } this.Pub1.AddTDEnd(); this.Pub1.AddTREnd(); this.Pub1.AddTableEnd(); this.Pub1.AddFieldSet("SQL事例"); this.Pub1.Add("主体数据源:"); this.Pub1.AddBR("SELECT No,Name,FK_Dept FROM Port_Emp"); this.Pub1.AddBR(); this.Pub1.Add("分组数据源:"); this.Pub1.AddBR("SELECT No,Name FROM Port_Dept "); this.Pub1.AddFieldSetEnd(); }
/// <summary>Возвращает список групп указанного пользователя.</summary> /// <param name="extended">Если указать в качестве этого параметра 1, то будет возвращена полная информация о группах пользователя</param> /// <param name="filter">Список фильтров сообществ, которые необходимо вернуть, перечисленные через запятую</param> /// <param name="fields">Список полей из информации о группах, которые необходимо получить</param> /// <returns>Ответ сервера в XML или JSON формате.</returns> public VKResponseBase Get(bool? extended = null, GroupsFilter? filter = null, GroupFields? fields = null) { return get(null, extended, filter, fields, null, null); }
void btn_Click(object sender, EventArgs e) { Button btn = sender as Button; try { switch (this.DoType) { case "New": default: MapDtl dtlN = new MapDtl(); dtlN = (MapDtl)this.Pub1.Copy(dtlN); if (this.DoType == "New") { if (dtlN.IsExits) { this.Alert("已存在编号:" + dtlN.No); return; } } dtlN.FK_MapData = this.FK_MapData; dtlN.GroupID = 0; dtlN.RowIdx = 0; GroupFields gfs1 = new GroupFields(this.FK_MapData); if (gfs1.Count == 1) { GroupField gf = (GroupField)gfs1[0]; dtlN.GroupID = gf.OID; } else { dtlN.GroupID = this.Pub1.GetDDLByID("DDL_GroupField").SelectedItemIntVal; } dtlN.Insert(); if (btn.ID.Contains("AndClose")) { this.WinClose(); return; } this.Response.Redirect("MapDtl.aspx?DoType=Edit&FK_MapDtl=" + dtlN.No + "&FK_MapData=" + this.FK_MapData, true); break; case "Edit": MapDtl dtl = new MapDtl(this.FK_MapDtl); dtl = (MapDtl)this.Pub1.Copy(dtl); if (this.DoType == "New") { if (dtl.IsExits) { this.Alert("已存在编号:" + dtl.No); return; } } dtl.FK_MapData = this.FK_MapData; GroupFields gfs = new GroupFields(dtl.FK_MapData); if (gfs.Count > 1) { dtl.GroupID = this.Pub1.GetDDLByID("DDL_GroupField").SelectedItemIntVal; } if (this.DoType == "New") { dtl.Insert(); } else { dtl.Update(); } if (btn.ID.Contains("AndC")) { this.WinClose(); return; } this.Response.Redirect("MapDtl.aspx?DoType=Edit&FK_MapDtl=" + dtl.No + "&FK_MapData=" + this.FK_MapData, true); break; } } catch (Exception ex) { this.Alert(ex.Message); } }
/// <summary>Возвращает информацию о заданной группе или о нескольких группах.</summary> /// <param name="gids">ID групп, перечисленные через запятую, информацию о которых необходимо получить</param> /// <param name="fields">Список полей из информации о группах, которые необходимо получить</param> /// <returns>Ответ сервера в XML или JSON формате.</returns> public VKResponseBase GetById(IdList gids, GroupFields? fields = null) { return getById(gids, fields); }