public void BindSFTable(SFTable en) { string star = "<font color=red><b>(*)</b></font>"; this.Ucsys1.AddTable(); if (this.FromApp == "SL") { if (this.RefNo == null) { this.Ucsys1.AddCaption("新建表"); } else { this.Ucsys1.AddCaption("编辑表"); } } else { if (this.RefNo == null) { this.Ucsys1.AddCaption("<a href='Do.aspx?DoType=AddF&MyPK=" + this.MyPK + "&IDX=" + this.IDX + "'><img src='/WF/Img/Btn/Back.gif'>返回</a> - <a href='Do.aspx?DoType=AddSFTable&MyPK=" + this.MyPK + "&IDX=" + this.IDX + "'>外键</a> - 新建表"); } else { this.Ucsys1.AddCaption("<a href='Do.aspx?DoType=AddF&MyPK=" + this.MyPK + "&IDX=" + this.IDX + "'><img src='/WF/Img/Btn/Back.gif'>返回</a> - <a href='Do.aspx?DoType=AddSFTable&MyPK=" + this.MyPK + "&IDX=" + this.IDX + "'>外键</a> - 编辑表"); } } if (this.RefNo == null) { this.Title = "新建表"; } else { this.Title = "编辑表"; } int idx = 0; bool isItem = false; this.Ucsys1.AddTR(); this.Ucsys1.AddTDTitle("Idx"); this.Ucsys1.AddTDTitle("项目"); this.Ucsys1.AddTDTitle("采集"); // this.Ucsys1.AddFieldSet("帮助", help); this.Ucsys1.AddTDTitle("备注"); this.Ucsys1.AddTREnd(); isItem = this.Ucsys1.AddTR(isItem); this.Ucsys1.AddTDIdx(idx++); this.Ucsys1.AddTD("数据源" + star); BP.Web.Controls.DDL ddl = new BP.Web.Controls.DDL(); ddl.ID = "DDL_FK_SFDBSrc"; SFDBSrcs srcs = new SFDBSrcs(); srcs.RetrieveDBSrc(); ddl.Bind(srcs, en.FK_SFDBSrc); this.Ucsys1.AddTD(ddl); // this.Ucsys1.AddTD("外键表的数据源必须与该表单的数据源一致."); this.Ucsys1.AddTD("选择数据源,点击这里<a href=\"javascript:WinOpen('/WF/Comm/Search.aspx?EnsName=BP.Sys.SFDBSrcs')\">创建</a>,<a href='SFSQL.aspx?DoType=New&MyPK=" + this.MyPK + "&Idx='>刷新</a>。"); this.Ucsys1.AddTREnd(); isItem = this.Ucsys1.AddTR(isItem); this.Ucsys1.AddTDIdx(idx++); this.Ucsys1.AddTD("表中文名称" + star); BP.Web.Controls.TB tb = new BP.Web.Controls.TB(); tb.ID = "TB_Name"; tb.Text = en.Name; tb.AutoPostBack = true; tb.TextChanged += new EventHandler(tbName_TextChanged); this.Ucsys1.AddTD(tb); this.Ucsys1.AddTD("该表的中文名称,比如:物料类别,科目。"); this.Ucsys1.AddTREnd(); isItem = this.Ucsys1.AddTR(isItem); this.Ucsys1.AddTDIdx(idx++); this.Ucsys1.AddTD("表英文名称" + star); tb = new BP.Web.Controls.TB(); tb.ID = "TB_No"; tb.Text = en.No; if (this.RefNo == null) { tb.Enabled = true; } else { tb.Enabled = false; } if (tb.Text == "") { tb.Text = ""; } this.Ucsys1.AddTD(tb); this.Ucsys1.AddTDBigDoc("必须以字母或者下划线开头,不能包含特殊字符。"); this.Ucsys1.AddTREnd(); isItem = this.Ucsys1.AddTR(isItem); this.Ucsys1.AddTDIdx(idx++); this.Ucsys1.AddTD("数据结构"); ddl = new BP.Web.Controls.DDL(); ddl.ID = "DDL_" + SFTableAttr.CodeStruct; ddl.BindSysEnum(SFTableAttr.CodeStruct, (int)en.CodeStruct); this.Ucsys1.AddTD(ddl); this.Ucsys1.AddTD("用于在下拉框中不同格式的展现."); this.Ucsys1.AddTREnd(); //isItem = this.Ucsys1.AddTR(isItem); //this.Ucsys1.AddTDIdx(idx++); //this.Ucsys1.AddTD("数据源" + star); //ddl = new BP.Web.Controls.DDL(); //SFDBSrcs srcs = new SFDBSrcs(); //BP.En.QueryObject qo = new QueryObject(srcs); //qo.AddWhere(SFDBSrcAttr.DBSrcType, " < ", "100"); //qo.DoQuery(); //ddl.Bind(srcs, en.FK_SFDBSrc); //this.Ucsys1.AddTD(ddl); //this.Ucsys1.AddTD("选择数据源,点击这里<a href=\"javascript:WinOpen('/WF/Comm/Search.aspx?EnsName=BP.Sys.SFDBSrcs')\">创建</a>,<a href='SFSQL.aspx?DoType=New&MyPK=" + this.MyPK + "&Idx='>刷新</a>。"); //this.Ucsys1.AddTREnd(); //isItem = this.Ucsys1.AddTR(isItem); //this.Ucsys1.AddTDIdx(idx++); //this.Ucsys1.AddTD("描述" + star); //tb = new BP.Web.Controls.TB(); //tb.ID = "TB_TableDesc"; //tb.Text = en.TableDesc; //this.Ucsys1.AddTD(tb); //this.Ucsys1.AddTD("对该表的备注,比如:物料类别字典表,科目字典表。"); //this.Ucsys1.AddTREnd(); isItem = this.Ucsys1.AddTR(isItem); this.Ucsys1.AddTDIdx(idx++); this.Ucsys1.Add("<TD colspan=3 align=center>"); Button btn = new Button(); btn.ID = "Btn_Save"; btn.CssClass = "Btn"; if (this.RefNo == null) { btn.Text = "创建"; } else { btn.Text = "保存"; } btn.Click += new EventHandler(btn_Save_Click); this.Ucsys1.Add(btn); btn = new Button(); btn.ID = "Btn_Edit"; btn.Text = "编辑数据"; // "编辑数据" if (this.RefNo == null) { btn.Enabled = false; } if (en.IsClass) { btn.Attributes["onclick"] = "WinOpen('../Search.aspx?EnsName=" + en.No + "', 'dg'); return false;"; } else { btn.Attributes["onclick"] = "WinOpen('SFTableEditData.aspx?RefNo=" + this.RefNo + "', 'dg'); return false;"; } this.Ucsys1.Add(btn); if (this.FromApp != "SL") { btn = new Button(); btn.ID = "Btn_Add"; btn.CssClass = "Btn"; btn.Text = "添加到表单";; // "添加到表单"; btn.Attributes["onclick"] = " return confirm('您确认吗?');"; btn.Click += new EventHandler(btn_Add_Click); if (this.RefNo == null) { btn.Enabled = false; } } this.Ucsys1.Add(btn); btn = new Button(); btn.ID = "Btn_Del"; btn.CssClass = "Btn"; btn.Text = "删除"; btn.Attributes["onclick"] = " return confirm('您确认吗?');"; if (this.RefNo == null) { btn.Enabled = false; } btn.Click += new EventHandler(btn_Del_Click); this.Ucsys1.Add(btn); //string help = "<ul>"; //help += "<li>输入:新表名或已经存在的表名或者视图,必须是英文字母或者下划线。</li>"; //help += "<li>如果该表或者视图已经存在本机中,系统就会把他注册到ccform的数据源(Sys_SFTable)里,您可以打开Sys_SFTable查看ccform对外部数据源管理的信息。</li>"; //help += "<li>如果不存在ccform就会自动创建表,该表有No,Name两个列,并且初始化3笔数据,您可以对该表进行编辑。</li>"; //help += "</ul>"; this.Ucsys1.Add(BP.WF.Glo.GenerHelpCCForm("帮助", null, null)); this.Ucsys1.Add("</TD>"); this.Ucsys1.AddTREnd(); this.Ucsys1.AddTableEnd(); }
public void BindSFTable(SFTable en) { bool isItem = false; string star = "<font color=red><b>(*)</b></font>"; this.Ucsys1.AddTable(); #region 生成标题. if (this.FromApp == "SL") { if (this.RefNo == null) { this.Ucsys1.AddCaption("新建表"); } else { this.Ucsys1.AddCaption("编辑表"); } } else { if (this.RefNo == null) { this.Ucsys1.AddCaption("<a href='Do.aspx?DoType=AddF&MyPK=" + this.MyPK + "&IDX=" + this.IDX + "'><img src='/WF/Img/Btn/Back.gif'>返回</a> - <a href='Do.aspx?DoType=AddSFSQL&MyPK=" + this.MyPK + "&IDX=" + this.IDX + "'>外部表</a> - 新建表"); } else { this.Ucsys1.AddCaption("<a href='Do.aspx?DoType=AddF&MyPK=" + this.MyPK + "&IDX=" + this.IDX + "'><img src='/WF/Img/Btn/Back.gif'>返回</a> - <a href='Do.aspx?DoType=AddSFSQL&MyPK=" + this.MyPK + "&IDX=" + this.IDX + "'>外部表</a> - 编辑表"); } } if (this.RefNo == null) { this.Title = "新建表"; } else { this.Title = "编辑表"; } #endregion 生成标题. int idx = 0; this.Ucsys1.AddTR(); this.Ucsys1.AddTDTitle("Idx"); this.Ucsys1.AddTDTitle("项目"); this.Ucsys1.AddTDTitle("采集"); this.Ucsys1.AddTDTitle("备注"); this.Ucsys1.AddTREnd(); isItem = this.Ucsys1.AddTR(isItem); this.Ucsys1.AddTDIdx(idx++); this.Ucsys1.AddTD("数据源" + star); BP.Web.Controls.DDL ddl = new BP.Web.Controls.DDL(); ddl.ID = "DDL_FK_SFDBSrc"; SFDBSrcs srcs = new SFDBSrcs(); srcs.RetrieveDBSrc(); ddl.Bind(srcs, en.FK_SFDBSrc); this.Ucsys1.AddTD(ddl); this.Ucsys1.AddTD("选择数据源,点击这里<a href=\"javascript:WinOpen('/WF/Comm/Search.aspx?EnsName=BP.Sys.SFDBSrcs')\">创建</a>,<a href='SFSQL.aspx?DoType=New&MyPK=" + this.MyPK + "&Idx='>刷新</a>。"); this.Ucsys1.AddTREnd(); isItem = this.Ucsys1.AddTR(isItem); this.Ucsys1.AddTDIdx(idx++); this.Ucsys1.AddTD("中文名称" + star); BP.Web.Controls.TB tb = new BP.Web.Controls.TB(); tb.ID = "TB_" + SFTableAttr.Name; tb.Text = en.Name; tb.Columns = 35; tb.AutoPostBack = true; tb.TextChanged += new EventHandler(tbName_TextChanged); this.Ucsys1.AddTD(tb); this.Ucsys1.AddTD("该表的中文名称,比如:物料类别,科目。"); this.Ucsys1.AddTREnd(); isItem = this.Ucsys1.AddTR(isItem); this.Ucsys1.AddTDIdx(idx++); this.Ucsys1.AddTD("英文名称" + star); tb = new BP.Web.Controls.TB(); tb.ID = "TB_" + SFTableAttr.No; tb.Text = en.No; if (this.RefNo == null) { tb.Enabled = true; } else { tb.Enabled = false; } if (tb.Text == "") { tb.Text = ""; } tb.Columns = 35; tb.Attributes["onkeyup"] = "return IsDigit(this);"; this.Ucsys1.AddTD(tb); this.Ucsys1.AddTDBigDoc("必须以字母或者下划线开头,不能包含特殊字符。"); this.Ucsys1.AddTREnd(); isItem = this.Ucsys1.AddTR(isItem); this.Ucsys1.AddTDIdx(idx++); this.Ucsys1.AddTD("数据结构"); ddl = new BP.Web.Controls.DDL(); ddl.ID = "DDL_" + SFTableAttr.CodeStruct; ddl.BindSysEnum(SFTableAttr.CodeStruct, (int)en.CodeStruct); this.Ucsys1.AddTD(ddl); this.Ucsys1.AddTD("字典表的数据结构,用于在下拉框中不同格式的展现。"); this.Ucsys1.AddTREnd(); //isItem = this.Ucsys1.AddTR(isItem); //this.Ucsys1.AddTDIdx(idx++); //this.Ucsys1.AddTD("描述"); //tb = new BP.Web.Controls.TB(); //tb.ID = "TB_"+SFTableAttr.TableDesc; //tb.Text = en.TableDesc; //this.Ucsys1.AddTD(tb); //this.Ucsys1.AddTD("对该表的备注,比如:物料类别字典表,科目字典表。"); //this.Ucsys1.AddTREnd(); isItem = this.Ucsys1.AddTR(isItem); this.Ucsys1.AddTDIdx(idx++); this.Ucsys1.AddTD("colspan=3", "查询SQL" + star + "支持ccform表达式,允许有@WebUser.No,@WebUser.Name,@WebUser.FK_Dept变量。"); this.Ucsys1.AddTREnd(); isItem = this.Ucsys1.AddTR(isItem); this.Ucsys1.AddTDIdx(idx++); tb = new BP.Web.Controls.TB(); tb.ID = "TB_" + SFTableAttr.SelectStatement; //查询. tb.Text = en.SelectStatement; //查询语句. tb.TextMode = TextBoxMode.MultiLine; tb.Rows = 4; tb.Columns = 70; //tb.Attributes["width"] = "98%"; this.Ucsys1.AddTD("colspan=3", tb); this.Ucsys1.AddTREnd(); isItem = this.Ucsys1.AddTR(isItem); this.Ucsys1.AddTDIdx(idx++); this.Ucsys1.AddTD("colspan=3", "比如:SELECT BH AS No, MC as Name FROM CC_USER WHERE CCType=3<br>SELECT BH AS No, MC as Name FROM CC_USER WHERE [email protected]_Dept"); this.Ucsys1.AddTREnd(); //isItem = this.Ucsys1.AddTR(isItem); //this.Ucsys1.AddTDIdx(idx++); //this.Ucsys1.AddTD("数据缓存(分钟)" + star); //tb = new BP.Web.Controls.TB(); //tb.ID = "TB_"+SFTableAttr.CashMinute; //tb.TextExtInt = en.CashMinute; //tb.Columns = 5; //this.Ucsys1.AddTD(tb); //this.Ucsys1.AddTD("默认为0表示不缓存,缓存的数据存储在Sys_Dict里面."); //this.Ucsys1.AddTREnd(); isItem = this.Ucsys1.AddTR(isItem); this.Ucsys1.AddTDIdx(idx++); this.Ucsys1.Add("<TD colspan=3 align=center>"); Button btn = new Button(); btn.ID = "Btn_Save"; btn.CssClass = "Btn"; if (this.RefNo == null) { btn.Text = "创建"; } else { btn.Text = "保存"; } btn.Click += new EventHandler(btn_Save_Click); this.Ucsys1.Add(btn); //btn = new Button(); //btn.ID = "Btn_Edit"; //btn.CssClass = "Btn"; //btn.Text = "查看数据"; // "编辑数据" //if (this.RefNo == null) // btn.Enabled = false; //if (en.IsClass) // btn.Attributes["onclick"] = "WinOpen('../Search.aspx?EnsName=" + en.No + "','dg' ); return false;"; //else // btn.Attributes["onclick"] = "WinOpen('SFTableEditData.aspx?RefNo=" + this.RefNo + "','dg' ); return false;"; //this.Ucsys1.Add(btn); if (this.FromApp != "SL") { btn = new Button(); btn.ID = "Btn_Add"; btn.CssClass = "Btn"; btn.Text = "添加到表单";; // "添加到表单"; btn.Attributes["onclick"] = " return confirm('您确认吗?');"; btn.Click += new EventHandler(btn_Add_Click); if (this.RefNo == null) { btn.Enabled = false; } this.Ucsys1.Add(btn); } btn = new Button(); btn.ID = "Btn_Del"; btn.CssClass = "Btn"; btn.Text = "删除"; btn.Attributes["onclick"] = " return confirm('您确认吗?');"; if (this.RefNo == null) { btn.Enabled = false; } btn.Click += new EventHandler(btn_Del_Click); this.Ucsys1.Add(btn); this.Ucsys1.Add("</TD>"); this.Ucsys1.AddTREnd(); this.Ucsys1.AddTableEnd(); //string help = "<ul>"; //help += "<li>输入:新表名或已经存在的表名或者视图,必须是英文字母或者下划线。</li>"; //help += "<li>如果该表或者视图已经存在本机中,系统就会把他注册到ccform的数据源(Sys_SFTable)里,您可以打开Sys_SFTable查看ccform对外部数据源管理的信息。</li>"; //help += "<li>如果不存在ccform就会自动创建表,该表有No,Name两个列,并且初始化3笔数据,您可以对该表进行编辑。</li>"; //help += "</ul>"; //this.Ucsys1.AddFieldSet("帮助", help); }