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.
103 lines
3.3 KiB
Plaintext
103 lines
3.3 KiB
Plaintext
11 months ago
|
using System;
|
||
|
|
using System.Data;
|
||
|
|
using BP.DA;
|
||
|
|
using BP.Sys;
|
||
|
|
namespace BP.Cloud.HttpHandler
|
||
|
|
{
|
||
|
|
/// <summary>
|
||
|
|
/// 处理页面的业务逻辑
|
||
|
|
/// </summary>
|
||
|
|
public class Admin_CCFormDesigner_SFTable : BP.WF.HttpHandler.DirectoryPageBase
|
||
|
|
{
|
||
|
|
|
||
|
|
#region SFList 外键表列表.
|
||
|
|
/// <summary>
|
||
|
|
/// 删除
|
||
|
|
/// </summary>
|
||
|
|
/// <returns></returns>
|
||
|
|
public string SFList_Delete()
|
||
|
|
{
|
||
|
|
try
|
||
|
|
{
|
||
|
|
SFTable sf = new SFTable(this.FK_SFTable);
|
||
|
|
sf.Delete();
|
||
|
|
return "删除成功...";
|
||
|
|
}
|
||
|
|
catch (Exception ex)
|
||
|
|
{
|
||
|
|
return "err@" + ex.Message;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
/// <summary>
|
||
|
|
/// 字典表列表.
|
||
|
|
/// </summary>
|
||
|
|
/// <returns></returns>
|
||
|
|
public string SFList_Init()
|
||
|
|
{
|
||
|
|
DataSet ds = new DataSet();
|
||
|
|
|
||
|
|
BP.Cloud.Sys.SFTables ens = new BP.Cloud.Sys.SFTables();
|
||
|
|
ens.Retrieve("OrgNo", BP.Web.WebUser.OrgNo);
|
||
|
|
|
||
|
|
DataTable dt = ens.ToDataTableField("SFTables");
|
||
|
|
ds.Tables.Add(dt);
|
||
|
|
|
||
|
|
int pTableModel = 0;
|
||
|
|
if (this.GetRequestVal("PTableModel").Equals("2"))
|
||
|
|
pTableModel = 2;
|
||
|
|
|
||
|
|
//获得ptableModel.
|
||
|
|
if (pTableModel == 0)
|
||
|
|
{
|
||
|
|
MapDtl dtl = new MapDtl();
|
||
|
|
dtl.No = this.FK_MapData;
|
||
|
|
if (dtl.RetrieveFromDBSources() == 1)
|
||
|
|
{
|
||
|
|
pTableModel = dtl.PTableModel;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
MapData md = new MapData();
|
||
|
|
md.No = this.FK_MapData;
|
||
|
|
if (md.RetrieveFromDBSources() == 1)
|
||
|
|
pTableModel = md.PTableModel;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
if (pTableModel == 2)
|
||
|
|
{
|
||
|
|
DataTable mydt = MapData.GetFieldsOfPTableMode2(this.FK_MapData);
|
||
|
|
mydt.TableName = "Fields";
|
||
|
|
ds.Tables.Add(mydt);
|
||
|
|
}
|
||
|
|
|
||
|
|
return BP.Tools.Json.ToJson(ds);
|
||
|
|
}
|
||
|
|
public string SFList_SaveSFField()
|
||
|
|
{
|
||
|
|
MapAttr attr = new BP.Sys.MapAttr();
|
||
|
|
attr.setMyPK(this.FK_MapData + "_" + this.KeyOfEn);
|
||
|
|
if (attr.RetrieveFromDBSources() != 0)
|
||
|
|
return "err@字段名[" + this.KeyOfEn + "]已经存在.";
|
||
|
|
|
||
|
|
BP.Sys.CCFormAPI.SaveFieldSFTable(this.FK_MapData, this.KeyOfEn, null, this.GetRequestVal("SFTable"), 100, 100, 1);
|
||
|
|
|
||
|
|
attr.Retrieve();
|
||
|
|
Paras ps = new Paras();
|
||
|
|
ps.SQL = "SELECT OID FROM Sys_GroupField A WHERE A.FrmID=" + BP.Difference.SystemConfig.AppCenterDBVarStr + "FrmID AND (CtrlType='' OR CtrlType IS NULL) ORDER BY OID DESC ";
|
||
|
|
ps.Add("FrmID", this.FK_MapData);
|
||
|
|
attr.GroupID = DBAccess.RunSQLReturnValInt(ps, 0);
|
||
|
|
attr.Update();
|
||
|
|
|
||
|
|
SFTable sf = new SFTable(attr.UIBindKey);
|
||
|
|
|
||
|
|
if (sf.SrcType == SrcType.TableOrView || sf.SrcType == SrcType.BPClass || sf.SrcType == SrcType.CreateTable)
|
||
|
|
return "../../Comm/En.htm?EnName=BP.Sys.FrmUI.MapAttrSFTable&PKVal=" + attr.MyPK;
|
||
|
|
else
|
||
|
|
return "../../Comm/En.htm?EnName=BP.Sys.FrmUI.MapAttrSFSQL&PKVal=" + attr.MyPK;
|
||
|
|
}
|
||
|
|
#endregion 外键表列表.
|
||
|
|
|
||
|
|
}
|
||
|
|
}
|