You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
157 lines
4.4 KiB
Plaintext
157 lines
4.4 KiB
Plaintext
using System;
|
|
using System.Collections;
|
|
using System.Data;
|
|
using BP.Sys;
|
|
using BP.En;
|
|
|
|
namespace BP.WF.HttpHandler
|
|
{
|
|
/// <summary>
|
|
/// 页面功能实体
|
|
/// </summary>
|
|
public class WF_Admin_FoolFormDesigner_SFTable : DirectoryPageBase
|
|
{
|
|
/// <summary>
|
|
/// 构造函数
|
|
/// </summary>
|
|
public WF_Admin_FoolFormDesigner_SFTable()
|
|
{
|
|
|
|
}
|
|
|
|
#region xxx 界面 .
|
|
/// <summary>
|
|
/// 初始化sf0. @于庆海，新方法.
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public string SF0_Init()
|
|
{
|
|
string cl = "BP.En.Entities";
|
|
ArrayList al = ClassFactory.GetObjects(cl);
|
|
|
|
//定义容器.
|
|
DataTable dt = new DataTable();
|
|
dt.Columns.Add("No");
|
|
dt.Columns.Add("Name");
|
|
|
|
SFTables sfs = new SFTables();
|
|
sfs.RetrieveAll();
|
|
|
|
foreach (object obj in al)
|
|
{
|
|
Entities ens = obj as Entities;
|
|
if (ens == null)
|
|
continue;
|
|
|
|
try
|
|
{
|
|
Entity en = ens.GetNewEntity;
|
|
if (en == null)
|
|
continue;
|
|
|
|
if (en.EnMap.Attrs.Contains("No") == false)
|
|
continue;
|
|
|
|
if (sfs.Contains(ens.ToString()) == true)
|
|
continue;
|
|
|
|
DataRow dr = dt.NewRow();
|
|
dr["No"] = ens.ToString();
|
|
|
|
if (en.IsTreeEntity)
|
|
dr["Name"] = en.EnMap.EnDesc + "(树结构) " + ens.ToString();
|
|
else
|
|
dr["Name"] = en.EnMap.EnDesc + " " + ens.ToString();
|
|
|
|
dt.Rows.Add(dr);
|
|
}
|
|
catch
|
|
{
|
|
|
|
}
|
|
}
|
|
return BP.Tools.Json.ToJson(dt);
|
|
}
|
|
public string SF0_Save()
|
|
{
|
|
return "保存成功.";
|
|
}
|
|
#endregion xxx 界面方法.
|
|
|
|
#region 表或者视图 .
|
|
/// <summary>
|
|
/// 初始化sf2.
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public string SF2_Init()
|
|
{
|
|
SFDBSrcs srcs = new SFDBSrcs();
|
|
srcs.RetrieveAll();
|
|
return srcs.ToJson();
|
|
}
|
|
|
|
public string SF2_GetTVs()
|
|
{
|
|
string src = this.GetRequestVal("src");
|
|
|
|
SFDBSrc sr = new SFDBSrc(src);
|
|
DataTable dt = sr.GetTables();
|
|
|
|
return BP.Tools.Json.ToJson(dt);
|
|
}
|
|
|
|
public string SF2_GetCols()
|
|
{
|
|
string src = this.GetRequestVal("src");
|
|
string table = this.GetRequestVal("table");
|
|
|
|
if (string.IsNullOrWhiteSpace(src))
|
|
throw new Exception("err@参数不正确");
|
|
|
|
if (string.IsNullOrWhiteSpace(table))
|
|
{
|
|
return "[]";
|
|
}
|
|
|
|
SFDBSrc sr = new SFDBSrc(src);
|
|
DataTable dt = sr.GetColumns(table);
|
|
|
|
foreach (DataRow r in dt.Rows)
|
|
{
|
|
r["Name"] = r["No"] + (r["Name"] == null || r["Name"] == DBNull.Value || string.IsNullOrWhiteSpace(r["Name"].ToString()) ? "" : string.Format("[{0}]", r["Name"]));
|
|
}
|
|
|
|
return BP.Tools.Json.ToJson(dt);
|
|
}
|
|
|
|
public string SF2_Save()
|
|
{
|
|
SFTable sf = new SFTable();
|
|
sf.No = this.GetValFromFrmByKey("No");
|
|
if (sf.IsExits)
|
|
return "err@标记:" + sf.No + "已经存在.";
|
|
|
|
sf.Name = this.GetValFromFrmByKey("Name");
|
|
sf.FK_SFDBSrc = this.GetValFromFrmByKey("FK_DBSrc");
|
|
sf.SrcTable = this.GetValFromFrmByKey("SrcTable");
|
|
sf.CodeStruct = (CodeStruct) this.GetValIntFromFrmByKey("CodeStruct");
|
|
sf.ColumnValue = this.GetValFromFrmByKey("ColumnValue");
|
|
sf.ColumnText = this.GetValFromFrmByKey("ColumnText");
|
|
if (sf.CodeStruct == CodeStruct.Tree)
|
|
{
|
|
sf.ParentValue = this.GetValFromFrmByKey("ParentValue");
|
|
sf.DefVal = this.GetValFromFrmByKey("RootValue");
|
|
}
|
|
sf.SelectStatement = this.GetValFromFrmByKey("Selectstatement");
|
|
sf.SrcType = DictSrcType.TableOrView;
|
|
sf.FK_Val = "FK_" + sf.No;
|
|
sf.Save();
|
|
|
|
return "保存成功！";
|
|
}
|
|
|
|
#endregion xxx 界面方法.
|
|
|
|
}
|
|
}
|