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);
}
