|
|
using System;
|
|
|
using System.Collections;
|
|
|
using BP.DA;
|
|
|
using BP.Web;
|
|
|
using BP.En;
|
|
|
using System.Data;
|
|
|
using BP.Difference;
|
|
|
|
|
|
namespace BP.Sys
|
|
|
{
|
|
|
/// <summary>
|
|
|
/// Pop返回值类型
|
|
|
/// </summary>
|
|
|
public enum PopValFormat
|
|
|
{
|
|
|
/// <summary>
|
|
|
/// 编号
|
|
|
/// </summary>
|
|
|
OnlyNo,
|
|
|
/// <summary>
|
|
|
/// 名称
|
|
|
/// </summary>
|
|
|
OnlyName,
|
|
|
/// <summary>
|
|
|
/// 编号与名称
|
|
|
/// </summary>
|
|
|
NoName
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 选择模式
|
|
|
/// </summary>
|
|
|
public enum PopValSelectModel
|
|
|
{
|
|
|
/// <summary>
|
|
|
/// 单选
|
|
|
/// </summary>
|
|
|
One,
|
|
|
/// <summary>
|
|
|
/// 多选
|
|
|
/// </summary>
|
|
|
More
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// PopVal - 工作方式
|
|
|
/// </summary>
|
|
|
public enum PopValWorkModel
|
|
|
{
|
|
|
/// <summary>
|
|
|
/// 禁用
|
|
|
/// </summary>
|
|
|
None,
|
|
|
/// <summary>
|
|
|
/// 自定义URL
|
|
|
/// </summary>
|
|
|
SelfUrl,
|
|
|
/// <summary>
|
|
|
/// 表格模式
|
|
|
/// </summary>
|
|
|
TableOnly,
|
|
|
/// <summary>
|
|
|
/// 表格分页模式
|
|
|
/// </summary>
|
|
|
TablePage,
|
|
|
/// <summary>
|
|
|
/// 分组模式
|
|
|
/// </summary>
|
|
|
Group,
|
|
|
/// <summary>
|
|
|
/// 树展现模式
|
|
|
/// </summary>
|
|
|
Tree,
|
|
|
/// <summary>
|
|
|
/// 双实体树
|
|
|
/// </summary>
|
|
|
TreeDouble
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 扩展
|
|
|
/// </summary>
|
|
|
public class MapExtAttr : EntityNoNameAttr
|
|
|
{
|
|
|
/// <summary>
|
|
|
/// 表单ID
|
|
|
/// </summary>
|
|
|
public const string FK_MapData = "FK_MapData";
|
|
|
/// <summary>
|
|
|
/// ExtType
|
|
|
/// </summary>
|
|
|
public const string ExtType = "ExtType";
|
|
|
/// <summary>
|
|
|
/// 模式
|
|
|
/// </summary>
|
|
|
public const string ExtModel = "ExtModel";
|
|
|
/// <summary>
|
|
|
/// 插入表单的位置
|
|
|
/// </summary>
|
|
|
public const string RowIdx = "RowIdx";
|
|
|
/// <summary>
|
|
|
/// GroupID
|
|
|
/// </summary>
|
|
|
public const string GroupID = "GroupID";
|
|
|
/// <summary>
|
|
|
/// 高度
|
|
|
/// </summary>
|
|
|
public const string H = "H";
|
|
|
/// <summary>
|
|
|
/// 宽度
|
|
|
/// </summary>
|
|
|
public const string W = "W";
|
|
|
/// <summary>
|
|
|
/// 是否可以自适应大小
|
|
|
/// </summary>
|
|
|
public const string IsAutoSize = "IsAutoSize";
|
|
|
/// <summary>
|
|
|
/// 设置的属性
|
|
|
/// </summary>
|
|
|
public const string AttrOfOper = "AttrOfOper";
|
|
|
/// <summary>
|
|
|
/// 激活的属性
|
|
|
/// </summary>
|
|
|
public const string AttrsOfActive = "AttrsOfActive";
|
|
|
/// <summary>
|
|
|
/// 执行方式
|
|
|
/// </summary>
|
|
|
public const string DoWay = "DoWay";
|
|
|
/// <summary>
|
|
|
/// Tag
|
|
|
/// </summary>
|
|
|
public const string Tag = "Tag";
|
|
|
/// <summary>
|
|
|
/// Tag1
|
|
|
/// </summary>
|
|
|
public const string Tag1 = "Tag1";
|
|
|
/// <summary>
|
|
|
/// Tag2
|
|
|
/// </summary>
|
|
|
public const string Tag2 = "Tag2";
|
|
|
/// <summary>
|
|
|
/// Tag3
|
|
|
/// </summary>
|
|
|
public const string Tag3 = "Tag3";
|
|
|
/// <summary>
|
|
|
/// tag4
|
|
|
/// </summary>
|
|
|
public const string Tag4 = "Tag4";
|
|
|
/// <summary>
|
|
|
/// tag5
|
|
|
/// </summary>
|
|
|
public const string Tag5 = "Tag5";
|
|
|
/// <summary>
|
|
|
/// tag6
|
|
|
/// </summary>
|
|
|
public const string Tag6 = "Tag6";
|
|
|
/// <summary>
|
|
|
/// 数据源
|
|
|
/// </summary>
|
|
|
public const string DBType = "DBType";
|
|
|
/// <summary>
|
|
|
/// Doc
|
|
|
/// </summary>
|
|
|
public const string Doc = "Doc";
|
|
|
/// <summary>
|
|
|
/// 参数
|
|
|
/// </summary>
|
|
|
public const string AtPara = "AtPara";
|
|
|
/// <summary>
|
|
|
/// 计算的优先级
|
|
|
/// </summary>
|
|
|
public const string PRI = "PRI";
|
|
|
/// <summary>
|
|
|
/// 数据源
|
|
|
/// </summary>
|
|
|
public const string FK_DBSrc = "FK_DBSrc";
|
|
|
/// <summary>
|
|
|
/// 排序
|
|
|
/// </summary>
|
|
|
public const string Idx = "Idx";
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 扩展
|
|
|
/// </summary>
|
|
|
public class MapExt : EntityMyPK
|
|
|
{
|
|
|
#region 关于 Pop at 参数
|
|
|
/// <summary>
|
|
|
/// 转化JSON
|
|
|
/// </summary>
|
|
|
/// <returns></returns>
|
|
|
public string PopValToJson()
|
|
|
{
|
|
|
return BP.Tools.Json.ToJsonEntityModel(this.PopValToHashtable());
|
|
|
}
|
|
|
public Hashtable PopValToHashtable()
|
|
|
{
|
|
|
|
|
|
//创建一个ht, 然后把他转化成json返回出去。
|
|
|
Hashtable ht = new Hashtable();
|
|
|
|
|
|
switch (this.PopValWorkModel)
|
|
|
{
|
|
|
case PopValWorkModel.SelfUrl:
|
|
|
ht.Add("URL", this.PopValUrl);
|
|
|
break;
|
|
|
case PopValWorkModel.TableOnly:
|
|
|
ht.Add("EntitySQL", this.PopValEntitySQL);
|
|
|
break;
|
|
|
case PopValWorkModel.TablePage:
|
|
|
ht.Add("PopValTablePageSQL", this.PopValTablePageSQL);
|
|
|
ht.Add("PopValTablePageSQLCount", this.PopValTablePageSQLCount);
|
|
|
break;
|
|
|
case PopValWorkModel.Group:
|
|
|
ht.Add("GroupSQL", this.Tag1);
|
|
|
ht.Add("EntitySQL", this.PopValEntitySQL);
|
|
|
break;
|
|
|
case PopValWorkModel.Tree:
|
|
|
ht.Add("TreeSQL", this.PopValTreeSQL);
|
|
|
ht.Add("TreeParentNo", this.PopValTreeParentNo);
|
|
|
break;
|
|
|
case PopValWorkModel.TreeDouble:
|
|
|
ht.Add("DoubleTreeSQL", this.PopValTreeSQL);
|
|
|
ht.Add("DoubleTreeParentNo", this.PopValTreeParentNo);
|
|
|
ht.Add("DoubleTreeEntitySQL", this.PopValDoubleTreeEntitySQL);
|
|
|
break;
|
|
|
default:
|
|
|
break;
|
|
|
}
|
|
|
|
|
|
ht.Add(MapExtAttr.W, this.W);
|
|
|
ht.Add(MapExtAttr.H, this.H);
|
|
|
|
|
|
ht.Add("PopValWorkModel", this.PopValWorkModel.ToString()); //工作模式.
|
|
|
ht.Add("PopValSelectModel", this.PopValSelectModel.ToString()); //单选，多选.
|
|
|
|
|
|
ht.Add("PopValFormat", this.PopValFormat.ToString()); //返回值格式.
|
|
|
ht.Add("PopValTitle", this.PopValTitle); //窗口标题.
|
|
|
ht.Add("PopValColNames", this.PopValColNames); //列名 @No=编号@Name=名称@Addr=地址.
|
|
|
ht.Add("PopValSearchTip", this.PopValSearchTip); //搜索提示..
|
|
|
|
|
|
//查询条件.
|
|
|
ht.Add("PopValSearchCond", this.PopValSearchCond); //查询条件..
|
|
|
|
|
|
|
|
|
//转化为Json.
|
|
|
return ht;
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 连接
|
|
|
/// </summary>
|
|
|
public string PopValUrl
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.Doc;
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.Doc = value;
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 实体SQL
|
|
|
/// </summary>
|
|
|
public string PopValEntitySQL
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.Tag2;
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.Tag2 = value;
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 分组SQL
|
|
|
/// </summary>
|
|
|
public string PopValGroupSQL
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.Tag1;
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.Tag1 = value;
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 分页SQL带有关键字
|
|
|
/// </summary>
|
|
|
public string PopValTablePageSQL
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.Tag;
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.Tag = value;
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 分页SQL获取总行数
|
|
|
/// </summary>
|
|
|
public string PopValTablePageSQLCount
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.Tag1;
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.Tag1 = value;
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 标题
|
|
|
/// </summary>
|
|
|
public string PopValTitle
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetParaString("PopValTitle");
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetPara("PopValTitle", value);
|
|
|
}
|
|
|
}
|
|
|
|
|
|
public string PopValTreeSQL
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.PopValEntitySQL;
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.PopValEntitySQL = value;
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 根目录
|
|
|
/// </summary>
|
|
|
public string PopValTreeParentNo
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetParaString("PopValTreeParentNo");
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetPara("PopValTreeParentNo", value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// Pop 返回值的格式.
|
|
|
/// </summary>
|
|
|
public PopValFormat PopValFormat
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return (PopValFormat)this.GetParaInt("PopValFormat");
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetPara("PopValFormat", (int)value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 双实体树的实体
|
|
|
/// </summary>
|
|
|
public string PopValDoubleTreeEntitySQL
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.Tag1;
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.Tag1 = value;
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// pop 选择方式
|
|
|
/// 0,多选,1=单选.
|
|
|
/// </summary>
|
|
|
public PopValSelectModel PopValSelectModel
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return (PopValSelectModel)this.GetParaInt("PopValSelectModel");
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetPara("PopValSelectModel", (int)value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// PopVal工作模式
|
|
|
/// </summary>
|
|
|
public PopValWorkModel PopValWorkModel
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return (PopValWorkModel)this.GetParaInt("PopValWorkModel");
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetPara("PopValWorkModel", (int)value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 开窗的列中文名称.
|
|
|
/// </summary>
|
|
|
public string PopValColNames
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.Tag3;
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.Tag3 = value;
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 查询条件
|
|
|
/// </summary>
|
|
|
public string PopValSearchCond
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.Tag4;
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.Tag4 = value;
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 搜索提示关键字
|
|
|
/// </summary>
|
|
|
public string PopValSearchTip
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetParaString("PopValSearchTip", "请输入关键字");
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetPara("PopValSearchTip", value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 数据源
|
|
|
/// </summary>
|
|
|
public string DBSrcNo
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStrByKey(MapExtAttr.FK_DBSrc);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(MapExtAttr.FK_DBSrc, value);
|
|
|
}
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 属性
|
|
|
public string ExtDesc
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
string dec = "";
|
|
|
switch (this.ExtType)
|
|
|
{
|
|
|
case MapExtXmlList.ActiveDDL:
|
|
|
dec += "字段" + this.AttrOfOper;
|
|
|
break;
|
|
|
case MapExtXmlList.TBFullCtrl:
|
|
|
dec += this.AttrOfOper;
|
|
|
break;
|
|
|
case MapExtXmlList.DDLFullCtrl:
|
|
|
dec += "" + this.AttrOfOper;
|
|
|
break;
|
|
|
case MapExtXmlList.InputCheck:
|
|
|
dec += "字段：" + this.AttrOfOper + " 检查内容：" + this.Tag1;
|
|
|
break;
|
|
|
case MapExtXmlList.PopVal:
|
|
|
dec += "字段：" + this.AttrOfOper + " Url：" + this.Tag;
|
|
|
break;
|
|
|
default:
|
|
|
break;
|
|
|
}
|
|
|
return dec;
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 是否自适应大小
|
|
|
/// </summary>
|
|
|
public bool ItIsAutoSize
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValBooleanByKey(MapExtAttr.IsAutoSize);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(MapExtAttr.IsAutoSize, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 数据格式
|
|
|
/// </summary>
|
|
|
public string DBType
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStrByKey(MapExtAttr.DBType);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(MapExtAttr.DBType, value);
|
|
|
}
|
|
|
}
|
|
|
public string AtPara
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStrByKey(MapExtAttr.AtPara);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(MapExtAttr.AtPara, value);
|
|
|
}
|
|
|
}
|
|
|
|
|
|
public string ExtModel
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStrByKey(MapExtAttr.ExtModel);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(MapExtAttr.ExtModel, value);
|
|
|
}
|
|
|
}
|
|
|
public string ExtType
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStrByKey(MapExtAttr.ExtType);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(MapExtAttr.ExtType, value);
|
|
|
}
|
|
|
}
|
|
|
public string DoWay
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStrByKey(MapExtAttr.DoWay);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(MapExtAttr.DoWay, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 操作的attrs
|
|
|
/// </summary>
|
|
|
public string AttrOfOper
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStrByKey(MapExtAttr.AttrOfOper);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(MapExtAttr.AttrOfOper, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 激活的attrs
|
|
|
/// </summary>
|
|
|
public string AttrsOfActive
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
// return this.GetValStrByKey(MapExtAttr.AttrsOfActive).Replace("~", "'");
|
|
|
return this.GetValStrByKey(MapExtAttr.AttrsOfActive);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(MapExtAttr.AttrsOfActive, value);
|
|
|
}
|
|
|
}
|
|
|
public string FrmID
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStrByKey(MapExtAttr.FK_MapData);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(MapExtAttr.FK_MapData, value);
|
|
|
}
|
|
|
}
|
|
|
public void setFK_MapData(string val)
|
|
|
{
|
|
|
this.SetValByKey(MapExtAttr.FK_MapData, val);
|
|
|
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// Doc
|
|
|
/// </summary>
|
|
|
public string Doc
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
string str = this.GetValStrByKey("Doc").Replace("~", "'");
|
|
|
str = str.Replace("~", "'");
|
|
|
return str;
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
string str = value.Replace("'", "~");
|
|
|
this.SetValByKey("Doc", str);
|
|
|
}
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 处理自动填充SQL
|
|
|
/// </summary>
|
|
|
/// <param name="htMainEn"></param>
|
|
|
/// <param name="htDtlEn"></param>
|
|
|
/// <returns></returns>
|
|
|
public string AutoFullDLL_SQL_ForDtl(Hashtable htMainEn, Hashtable htDtlEn)
|
|
|
{
|
|
|
string fullSQL = this.Doc.Replace("@WebUser.No", WebUser.No);
|
|
|
fullSQL = fullSQL.Replace("@WebUser.Name", WebUser.Name);
|
|
|
fullSQL = fullSQL.Replace("@WebUser.FK_Dept", WebUser.DeptNo);
|
|
|
fullSQL = fullSQL.Replace("@WebUser.FK_DeptName", WebUser.DeptName);
|
|
|
|
|
|
if (fullSQL.Contains("@"))
|
|
|
{
|
|
|
foreach (string key in htDtlEn.Keys)
|
|
|
{
|
|
|
if (fullSQL.Contains("@") == false)
|
|
|
break;
|
|
|
if (fullSQL.Contains("@" + key + ";") == true)
|
|
|
{
|
|
|
fullSQL = fullSQL.Replace("@" + key + ";", htDtlEn[key] as string);
|
|
|
}
|
|
|
|
|
|
if (fullSQL.Contains("@" + key) == true)
|
|
|
{
|
|
|
fullSQL = fullSQL.Replace("@" + key, htDtlEn[key] as string);
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
|
|
|
if (fullSQL.Contains("@"))
|
|
|
{
|
|
|
foreach (string key in htMainEn.Keys)
|
|
|
{
|
|
|
if (fullSQL.Contains("@") == false)
|
|
|
break;
|
|
|
|
|
|
if (fullSQL.Contains("@" + key + ";") == true)
|
|
|
{
|
|
|
fullSQL = fullSQL.Replace("@" + key + ";", htMainEn[key] as string);
|
|
|
}
|
|
|
|
|
|
if (fullSQL.Contains("@" + key) == true)
|
|
|
{
|
|
|
fullSQL = fullSQL.Replace("@" + key, htMainEn[key] as string);
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
return fullSQL;
|
|
|
}
|
|
|
|
|
|
public string TagOfSQL_autoFullTB
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
if (DataType.IsNullOrEmpty(this.Tag))
|
|
|
return this.DocOfSQLDeal;
|
|
|
|
|
|
string sql = this.Tag;
|
|
|
sql = sql.Replace("@WebUser.No", BP.Web.WebUser.No);
|
|
|
sql = sql.Replace("@WebUser.Name", BP.Web.WebUser.Name);
|
|
|
sql = sql.Replace("@WebUser.FK_DeptNameOfFull", BP.Web.WebUser.DeptNameOfFull);
|
|
|
sql = sql.Replace("@WebUser.FK_DeptName", BP.Web.WebUser.DeptName);
|
|
|
sql = sql.Replace("@WebUser.FK_Dept", BP.Web.WebUser.DeptNo);
|
|
|
return sql;
|
|
|
}
|
|
|
}
|
|
|
|
|
|
public string DocOfSQLDeal
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
string sql = this.Doc;
|
|
|
sql = sql.Replace("@WebUser.No", BP.Web.WebUser.No);
|
|
|
sql = sql.Replace("@WebUser.Name", BP.Web.WebUser.Name);
|
|
|
sql = sql.Replace("@WebUser.FK_DeptNameOfFull", BP.Web.WebUser.DeptNameOfFull);
|
|
|
sql = sql.Replace("@WebUser.FK_DeptName", BP.Web.WebUser.DeptName);
|
|
|
sql = sql.Replace("@WebUser.FK_Dept", BP.Web.WebUser.DeptNo);
|
|
|
return sql;
|
|
|
}
|
|
|
}
|
|
|
public string Tag
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
string s = this.GetValStrByKey("Tag").Replace("~", "'");
|
|
|
|
|
|
s = s.Replace("\\\\", "/");
|
|
|
s = s.Replace("\\\\", "/");
|
|
|
|
|
|
s = s.Replace(@"CCFlow/Data/", @"CCFlow/WF/Data/");
|
|
|
|
|
|
return s;
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey("Tag", value);
|
|
|
}
|
|
|
}
|
|
|
public string Tag1
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStrByKey("Tag1").Replace("~", "'");
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey("Tag1", value);
|
|
|
}
|
|
|
}
|
|
|
public string Tag2
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStrByKey("Tag2").Replace("~", "'");
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey("Tag2", value);
|
|
|
}
|
|
|
}
|
|
|
public string Tag3
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStrByKey("Tag3").Replace("~", "'");
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey("Tag3", value);
|
|
|
}
|
|
|
}
|
|
|
public string Tag4
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStrByKey("Tag4").Replace("~", "'");
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey("Tag4", value);
|
|
|
}
|
|
|
}
|
|
|
public int H
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValIntByKey(MapExtAttr.H);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(MapExtAttr.H, value);
|
|
|
}
|
|
|
}
|
|
|
public int W
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValIntByKey(MapExtAttr.W);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(MapExtAttr.W, value);
|
|
|
}
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 构造方法
|
|
|
/// <summary>
|
|
|
/// 扩展
|
|
|
/// </summary>
|
|
|
public MapExt()
|
|
|
{
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 扩展
|
|
|
/// </summary>
|
|
|
/// <param name="mypk"></param>
|
|
|
public MapExt(string mypk)
|
|
|
{
|
|
|
this.setMyPK(mypk);
|
|
|
this.Retrieve();
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// EnMap
|
|
|
/// </summary>
|
|
|
public override Map EnMap
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
if (this._enMap != null)
|
|
|
return this._enMap;
|
|
|
|
|
|
Map map = new Map("Sys_MapExt", "业务逻辑");
|
|
|
|
|
|
map.IndexField = MapDtlAttr.FK_MapData;
|
|
|
map.AddMyPK();
|
|
|
map.AddTBString(MapExtAttr.FK_MapData, null, "表单ID", true, false, 0, 100, 20);
|
|
|
map.AddTBString(MapExtAttr.ExtModel, null, "类型1", true, false, 0, 30, 20);
|
|
|
map.AddTBString(MapExtAttr.ExtType, null, "类型2", true, false, 0, 30, 20);
|
|
|
|
|
|
//@hongyan. 修改类型.
|
|
|
// map.AddTBInt(MapExtAttr.DoWay, 0, "执行方式", true, false);
|
|
|
map.AddTBString(MapExtAttr.DoWay, null, "执行方式", true, false, 0, 50, 20);
|
|
|
|
|
|
map.AddTBString(MapExtAttr.AttrOfOper, null, "操作的Attr", true, false, 0, 30, 20);
|
|
|
map.AddTBString(MapExtAttr.AttrsOfActive, null, "激活的字段", true, false, 0, 900, 20);
|
|
|
|
|
|
map.AddTBStringDoc();
|
|
|
map.AddTBString(MapExtAttr.Tag, null, "Tag", true, false, 0, 2000, 20);
|
|
|
map.AddTBString(MapExtAttr.Tag1, null, "Tag1", true, false, 0, 2000, 20);
|
|
|
map.AddTBString(MapExtAttr.Tag2, null, "Tag2", true, false, 0, 2000, 20);
|
|
|
map.AddTBString(MapExtAttr.Tag3, null, "Tag3", true, false, 0, 2000, 20);
|
|
|
map.AddTBString(MapExtAttr.Tag4, null, "Tag4", true, false, 0, 2000, 20);
|
|
|
map.AddTBString(MapExtAttr.Tag5, null, "Tag5", true, false, 0, 2000, 20);
|
|
|
map.AddTBString(MapExtAttr.Tag6, null, "Tag5", true, false, 0, 2000, 20);
|
|
|
|
|
|
map.AddTBInt(MapExtAttr.H, 500, "高度", false, false);
|
|
|
map.AddTBInt(MapExtAttr.W, 400, "宽度", false, false);
|
|
|
|
|
|
// 数据类型 @0=SQL@1=URLJSON@2=FunctionJSON.
|
|
|
map.AddTBInt(MapExtAttr.DBType, 0, "数据类型", true, false);
|
|
|
map.AddTBString(MapExtAttr.FK_DBSrc, "local", "数据源", true, false, 0, 100, 20);
|
|
|
|
|
|
// add by zhoupeng 2013-12-21 计算的优先级,用于js的计算.
|
|
|
// 也可以用于 字段之间的计算 优先级.
|
|
|
map.AddTBInt(MapExtAttr.PRI, 0, "PRI/顺序号", false, false);
|
|
|
map.AddTBString(MapExtAttr.AtPara, null, "参数", true, false, 0, 3999, 20);
|
|
|
|
|
|
this._enMap = map;
|
|
|
return this._enMap;
|
|
|
}
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 其他方法.
|
|
|
/// <summary>
|
|
|
/// 统一生成主键的规则.
|
|
|
/// </summary>
|
|
|
public void InitPK()
|
|
|
{
|
|
|
if (DataType.IsNullOrEmpty(this.FrmID) == true)
|
|
|
return;
|
|
|
if (DataType.IsNullOrEmpty(this.MyPK) == false)
|
|
|
return;
|
|
|
|
|
|
switch (this.ExtType)
|
|
|
{
|
|
|
case MapExtXmlList.FullData:
|
|
|
case MapExtXmlList.FullDataDtl:
|
|
|
break;
|
|
|
case MapExtXmlList.ActiveDDL:
|
|
|
this.setMyPK(MapExtXmlList.ActiveDDL + "_" + this.FrmID + "_" + this.AttrOfOper);
|
|
|
break;
|
|
|
case MapExtXmlList.DDLFullCtrl:
|
|
|
this.setMyPK(MapExtXmlList.DDLFullCtrl + "_" + this.FrmID + "_" + this.AttrOfOper);
|
|
|
break;
|
|
|
case MapExtXmlList.PopVal:
|
|
|
this.setMyPK(MapExtXmlList.PopVal + "_" + this.FrmID + "_" + this.AttrOfOper);
|
|
|
break;
|
|
|
case MapExtXmlList.TBFullCtrl:
|
|
|
this.setMyPK(MapExtXmlList.TBFullCtrl + "_" + this.FrmID + "_" + this.AttrOfOper);
|
|
|
break;
|
|
|
case MapExtXmlList.PopFullCtrl:
|
|
|
this.setMyPK(MapExtXmlList.PopFullCtrl + "_" + this.FrmID + "_" + this.AttrOfOper);
|
|
|
break;
|
|
|
case MapExtXmlList.AutoFull:
|
|
|
this.setMyPK(MapExtXmlList.AutoFull + "_" + this.FrmID + "_" + this.AttrOfOper);
|
|
|
break;
|
|
|
case MapExtXmlList.AutoFullDLL:
|
|
|
this.setMyPK(MapExtXmlList.AutoFullDLL + "_" + this.FrmID + "_" + this.AttrOfOper);
|
|
|
break;
|
|
|
case MapExtXmlList.InputCheck:
|
|
|
this.setMyPK(MapExtXmlList.InputCheck + "_" + this.FrmID + "_" + this.AttrOfOper);
|
|
|
break;
|
|
|
case MapExtXmlList.PageLoadFull:
|
|
|
this.setMyPK(MapExtXmlList.PageLoadFull + "_" + this.FrmID);
|
|
|
break;
|
|
|
case MapExtXmlList.RegularExpression:
|
|
|
this.setMyPK(MapExtXmlList.RegularExpression + "_" + this.FrmID + "_" + this.AttrOfOper + "_" + this.Tag);
|
|
|
break;
|
|
|
case MapExtXmlList.BindFunction:
|
|
|
this.setMyPK(MapExtXmlList.BindFunction + "_" + this.FrmID + "_" + this.AttrOfOper + "_" + this.Tag);
|
|
|
break;
|
|
|
case MapExtXmlList.Link:
|
|
|
this.setMyPK(MapExtXmlList.Link + "_" + this.FrmID + "_" + this.AttrOfOper);
|
|
|
break;
|
|
|
default:
|
|
|
//这里要去掉，不然组合组主键，会带来错误.
|
|
|
if (DataType.IsNullOrEmpty(this.AttrOfOper) == true)
|
|
|
this.setMyPK(this.ExtType + "_" + this.FrmID);
|
|
|
else
|
|
|
this.setMyPK(this.ExtType + "_" + this.FrmID + "_" + this.AttrOfOper);
|
|
|
break;
|
|
|
}
|
|
|
}
|
|
|
|
|
|
protected override bool beforeInsert()
|
|
|
{
|
|
|
if (this.MyPK.Equals(""))
|
|
|
this.setMyPK(DBAccess.GenerGUID());
|
|
|
|
|
|
InitEtcFieldForTSEntity();
|
|
|
|
|
|
BP.Sys.Base.Glo.ClearMapDataAutoNum(this.FrmID);
|
|
|
|
|
|
return base.beforeInsert();
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 根据主键初始化其的字段.
|
|
|
/// </summary>
|
|
|
private void InitEtcFieldForTSEntity()
|
|
|
{
|
|
|
|
|
|
if (DataType.IsNullOrEmpty(this.FrmID) == true && this.MyPK.Contains("_") == true)
|
|
|
{
|
|
|
string[] strs = this.MyPK.Split('_');
|
|
|
//表单ID.
|
|
|
this.FrmID = strs[0];
|
|
|
|
|
|
//要操作的字段.
|
|
|
if (DataType.IsNullOrEmpty(this.AttrOfOper) == true && strs.Length > 2)
|
|
|
this.ExtType = strs[1];
|
|
|
|
|
|
//设置模式.
|
|
|
if (DataType.IsNullOrEmpty(this.ExtType) == true && strs.Length > 2)
|
|
|
this.ExtType = strs[2];
|
|
|
if (DataType.IsNullOrEmpty(this.ExtModel) == true && strs.Length > 2)
|
|
|
this.ExtType = strs[2];
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
protected override bool beforeUpdate()
|
|
|
{
|
|
|
this.InitPK();
|
|
|
|
|
|
#region 处理ts程序更新前的，补充填写其他的数据.
|
|
|
if (this.MyPK.Contains("_") == true)
|
|
|
{
|
|
|
string[] strs = this.MyPK.Split('_');
|
|
|
//对应的字段包含_
|
|
|
if (strs.Length > 3)
|
|
|
{
|
|
|
if (DataType.IsNullOrEmpty(this.FrmID) == true)
|
|
|
this.FrmID = strs[0];
|
|
|
|
|
|
if (DataType.IsNullOrEmpty(this.ExtModel) == true)
|
|
|
this.ExtModel = strs[strs.Length - 1];
|
|
|
if (DataType.IsNullOrEmpty(this.AttrOfOper) == true)
|
|
|
this.AttrOfOper = this.MyPK.Replace(this.FrmID + "_", "").Replace("_" + this.ExtModel, "");
|
|
|
}
|
|
|
if (strs.Length == 3)
|
|
|
{
|
|
|
if (DataType.IsNullOrEmpty(this.FrmID) == true)
|
|
|
this.FrmID = strs[0];
|
|
|
|
|
|
if (DataType.IsNullOrEmpty(this.AttrOfOper) == true)
|
|
|
this.AttrOfOper = strs[1];
|
|
|
|
|
|
if (DataType.IsNullOrEmpty(this.ExtModel) == true)
|
|
|
this.ExtModel = strs[2];
|
|
|
}
|
|
|
if (strs.Length == 2) //主表、从表的装载填充
|
|
|
{
|
|
|
if (DataType.IsNullOrEmpty(this.FrmID) == true)
|
|
|
this.FrmID = strs[0];
|
|
|
|
|
|
if (DataType.IsNullOrEmpty(this.ExtModel) == true)
|
|
|
this.ExtModel = strs[1];
|
|
|
}
|
|
|
}
|
|
|
#endregion 处理ts程序更新前的，补充填写其他的数据.
|
|
|
|
|
|
//根据主键初始化其的字段
|
|
|
InitEtcFieldForTSEntity();
|
|
|
|
|
|
switch (this.ExtType)
|
|
|
{
|
|
|
case MapExtXmlList.ActiveDDL:
|
|
|
case MapExtXmlList.DDLFullCtrl:
|
|
|
case MapExtXmlList.TBFullCtrl:
|
|
|
//if (this.Doc.Contains("@Key") == false)
|
|
|
// throw new Exception("@SQL表达式错误，您必须包含@Key ,这个关键字. ");
|
|
|
break;
|
|
|
case MapExtXmlList.AutoFullDLL:
|
|
|
//if (this.Doc.Length <= 3)
|
|
|
// throw new Exception("@必须填写SQL表达式. ");
|
|
|
break;
|
|
|
case MapExtXmlList.AutoFull:
|
|
|
//if (this.Doc.Length <= 3)
|
|
|
// throw new Exception("@必须填写表达式. 比如 @单价;*@数量; ");
|
|
|
break;
|
|
|
case MapExtXmlList.PopVal:
|
|
|
break;
|
|
|
default:
|
|
|
break;
|
|
|
}
|
|
|
|
|
|
return base.beforeUpdate();
|
|
|
}
|
|
|
|
|
|
protected override void afterInsertUpdateAction()
|
|
|
{
|
|
|
if (this.ExtType.Equals("MultipleChoiceSmall") == true || this.ExtType.Equals("SingleChoiceSmall") == true)
|
|
|
{
|
|
|
//给该字段增加一个KeyOfEnT
|
|
|
string mypk = this.FrmID + "_" + this.AttrOfOper + "T";
|
|
|
MapAttr attrH = new MapAttr();
|
|
|
attrH.setMyPK(mypk);
|
|
|
if (attrH.RetrieveFromDBSources() == 0)
|
|
|
{
|
|
|
MapAttr attr = new MapAttr(this.FrmID + "_" + this.AttrOfOper);
|
|
|
attrH.Copy(attr);
|
|
|
attrH.setKeyOfEn(attr.KeyOfEn + "T");
|
|
|
attrH.setName(attr.Name);
|
|
|
attrH.setUIContralType(UIContralType.TB);
|
|
|
attrH.setMinLen(0);
|
|
|
attrH.setMaxLen(500);
|
|
|
attrH.setMyDataType(DataType.AppString);
|
|
|
attrH.setUIVisible(false);
|
|
|
attrH.setUIIsEnable(true);
|
|
|
attrH.setMyPK(attrH.FrmID + "_" + attrH.KeyOfEn);
|
|
|
attrH.Save();
|
|
|
attr.SetPara("MultipleChoiceSmall", "1");
|
|
|
}
|
|
|
}
|
|
|
base.afterInsertUpdateAction();
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
/// <summary>
|
|
|
/// 删除垃圾数据.
|
|
|
/// </summary>
|
|
|
public static void DeleteDB()
|
|
|
{
|
|
|
MapExts exts = new MapExts();
|
|
|
exts.RetrieveAll();
|
|
|
return;
|
|
|
|
|
|
foreach (MapExt ext in exts)
|
|
|
{
|
|
|
if (ext.ExtType.Equals(MapExtXmlList.ActiveDDL))
|
|
|
{
|
|
|
if (ext.AttrOfOper.Trim().Length == 0)
|
|
|
{
|
|
|
ext.Delete();
|
|
|
continue;
|
|
|
}
|
|
|
|
|
|
MapAttr attr = new MapAttr();
|
|
|
attr.setMyPK(ext.AttrOfOper);
|
|
|
if (attr.IsExits == true)
|
|
|
{
|
|
|
ext.AttrOfOper = attr.KeyOfEn;
|
|
|
ext.Delete();
|
|
|
|
|
|
ext.setMyPK(ext.ExtType + "_" + ext.FrmID + "_" + ext.AttrOfOper + "_" + ext.AttrsOfActive);
|
|
|
ext.Save();
|
|
|
}
|
|
|
|
|
|
if (ext.MyPK.Equals(ext.ExtType + "_" + ext.FrmID + "_" + ext.FrmID + "_" + ext.AttrOfOper))
|
|
|
{
|
|
|
ext.Delete(); //直接删除.
|
|
|
|
|
|
ext.setMyPK(ext.ExtType + "_" + ext.FrmID + "_" + ext.AttrOfOper + "_" + ext.AttrsOfActive);
|
|
|
ext.Save();
|
|
|
continue;
|
|
|
}
|
|
|
|
|
|
if (ext.MyPK.Equals(ext.ExtType + "_" + ext.FrmID + "_" + ext.FrmID + "_" + ext.AttrOfOper + "_" + ext.AttrsOfActive))
|
|
|
{
|
|
|
ext.Delete(); //直接删除.
|
|
|
ext.setMyPK(ext.ExtType + "_" + ext.FrmID + "_" + ext.AttrOfOper + "_" + ext.AttrsOfActive);
|
|
|
ext.Save();
|
|
|
continue;
|
|
|
}
|
|
|
|
|
|
if (ext.MyPK.Equals(ext.ExtType + "_" + ext.FrmID + "_" + ext.FrmID + "_" + ext.AttrsOfActive + "_" + ext.AttrOfOper))
|
|
|
{
|
|
|
ext.Delete(); //直接删除.
|
|
|
ext.setMyPK(ext.ExtType + "_" + ext.FrmID + "_" + ext.AttrOfOper + "_" + ext.AttrsOfActive);
|
|
|
ext.Save();
|
|
|
continue;
|
|
|
}
|
|
|
|
|
|
|
|
|
//三个主键的情况.
|
|
|
if (ext.MyPK.Equals(ext.ExtType + "_" + ext.FrmID + "_" + ext.AttrOfOper))
|
|
|
{
|
|
|
ext.Delete();
|
|
|
ext.setMyPK(ext.ExtType + "_" + ext.FrmID + "_" + ext.AttrOfOper + "_" + ext.AttrsOfActive);
|
|
|
ext.Save();
|
|
|
continue;
|
|
|
}
|
|
|
|
|
|
//三个主键的情况.
|
|
|
if (ext.MyPK.Equals(ext.ExtType + "_" + ext.FrmID + "_" + ext.AttrsOfActive))
|
|
|
{
|
|
|
ext.Delete();
|
|
|
ext.setMyPK(ext.ExtType + "_" + ext.FrmID + "_" + ext.AttrOfOper + "_" + ext.AttrsOfActive);
|
|
|
ext.Save();
|
|
|
continue;
|
|
|
}
|
|
|
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
|
|
|
public string GetFullData(string paras, string oid)
|
|
|
{
|
|
|
string tag5 = this.GetValStringByKey(MapExtAttr.Tag5);
|
|
|
string tag6 = this.GetValStringByKey(MapExtAttr.Tag6);
|
|
|
if (tag5.Equals("SFTable"))
|
|
|
{
|
|
|
SFSearch sfs = new SFSearch(tag6);
|
|
|
return sfs.GenerDataOfJsonUesingSln(paras, this.MyPK);
|
|
|
}
|
|
|
if (tag5.Equals("Self"))
|
|
|
{
|
|
|
GEEntity en = null;
|
|
|
if (DataType.IsNullOrEmpty(oid) == false && oid.Contains("_") == false)
|
|
|
{
|
|
|
if (oid.Equals("0"))
|
|
|
en = new GEEntity(this.FrmID);
|
|
|
else
|
|
|
en = new GEEntity(this.FrmID, Int64.Parse(oid));
|
|
|
}
|
|
|
string sql = DealExp(tag6, paras, en);
|
|
|
SFDBSrc src = new SFDBSrc(this.DBSrcNo);
|
|
|
DataTable dt = src.RunSQLReturnTable(sql);
|
|
|
return BP.Tools.Json.ToJson(dt);
|
|
|
}
|
|
|
return "";
|
|
|
}
|
|
|
public string GetFullDataDtl(string paras, string oid)
|
|
|
{
|
|
|
if (DataType.IsNullOrEmpty(this.Tag1) == true)
|
|
|
return "err@关联填充的从表为空";
|
|
|
DataTable dt = null;
|
|
|
if (this.DoWay.Equals("SFTable"))
|
|
|
{
|
|
|
SFSearch sfs = new SFSearch(this.Doc);
|
|
|
string json = sfs.GenerDataOfJsonUesingSln(paras, this.MyPK);
|
|
|
dt = BP.Tools.Json.ToDataTable(json);
|
|
|
}
|
|
|
if (this.DoWay.Equals("Self"))
|
|
|
{
|
|
|
GEEntity en = null;
|
|
|
if (DataType.IsNullOrEmpty(oid) == false && oid.Contains("_") == false)
|
|
|
{
|
|
|
if (oid.Equals("0"))
|
|
|
en = new GEEntity(this.FrmID);
|
|
|
else
|
|
|
en = new GEEntity(this.FrmID, Int64.Parse(oid));
|
|
|
}
|
|
|
string sql = DealExp(this.Doc, paras, en);
|
|
|
SFDBSrc src = new SFDBSrc(this.DBSrcNo);
|
|
|
dt = src.RunSQLReturnTable(sql);
|
|
|
}
|
|
|
if (dt != null)
|
|
|
{
|
|
|
//删除从表数据
|
|
|
GEDtls dtls = new GEDtls(this.Tag1);
|
|
|
dtls.Delete(GEDtlAttr.RefPK, oid);
|
|
|
//结果值插入从表数据
|
|
|
foreach (DataRow dr in dt.Rows)
|
|
|
{
|
|
|
BP.Sys.GEDtl mydtl = new GEDtl(this.Tag1);
|
|
|
dtls.AddEntity(mydtl);
|
|
|
foreach (DataColumn dc in dt.Columns)
|
|
|
{
|
|
|
mydtl.SetValByKey(dc.ColumnName, dr[dc.ColumnName].ToString());
|
|
|
}
|
|
|
mydtl.RefPKInt = int.Parse(oid);
|
|
|
if (mydtl.OID > 100)
|
|
|
{
|
|
|
mydtl.InsertAsOID(mydtl.OID);
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
mydtl.OID = 0;
|
|
|
mydtl.Insert();
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
return "";
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 根据字段，参数返回查询数据的DataTable
|
|
|
/// </summary>
|
|
|
/// <param name="field">字段名</param>
|
|
|
/// <param name="paras">参数</param>
|
|
|
/// <param name="sqlWhere">增加的查询条件的SQL</param>
|
|
|
/// <returns></returns>
|
|
|
public string GetDataTableByField(string field, string paras, string sqlWhere, string oid, string type)
|
|
|
{
|
|
|
if (DataType.IsNullOrEmpty(field) == true)
|
|
|
return "err@" + this.MyPK + "中" + field + "传参不能为空";
|
|
|
|
|
|
string sql = this.GetValStringByKey(field); //获得SQL.
|
|
|
if (DataType.IsNullOrEmpty(sql) == true)
|
|
|
return "err@字段" + field + "执行的SQL为空,或者没有配置字典.";
|
|
|
|
|
|
//判断是不是使用字典表中的数据
|
|
|
if (sql.ToLower().Contains("select") == false && sql.ToLower().Contains("@") == false)
|
|
|
{
|
|
|
SFTable sf = new SFTable();
|
|
|
sf.No = sql;
|
|
|
if (sf.RetrieveFromDBSources() == 1)
|
|
|
return sf.GenerJsonByPara(paras);
|
|
|
else
|
|
|
throw new Exception("err@字典[" + sql + "]不存在.");
|
|
|
}
|
|
|
|
|
|
if (this.DBType.Equals("0") == false)
|
|
|
return "err@数据源类型不是按照SQL查询,DBType=" + this.DBType;
|
|
|
|
|
|
if (DBAccess.IsExitsTableCol("Sys_MapExt", field) == false)
|
|
|
return "err@传的参数不正确,Field=" + field + "在Sys_MapExt表中不存在";
|
|
|
|
|
|
|
|
|
//如果是SQL字典.
|
|
|
if (sql.ToLower().Contains("SELECT") == false)
|
|
|
{
|
|
|
if (this.DoWay.Equals("Self"))
|
|
|
{
|
|
|
sql = DealExp(sql, paras, null);
|
|
|
SFDBSrc dbSrc = new SFDBSrc(this.DBSrcNo);
|
|
|
return BP.Tools.Json.ToJson(dbSrc.RunSQLReturnTable(sql));
|
|
|
|
|
|
}
|
|
|
SFTable dict = new SFTable();
|
|
|
dict.No = sql;
|
|
|
if (dict.RetrieveFromDBSources() == 1)
|
|
|
return dict.GenerJsonByPara(paras);
|
|
|
}
|
|
|
|
|
|
//填充下拉框
|
|
|
GEEntity en = null;
|
|
|
if (DataType.IsNullOrEmpty(oid) == false && oid.Contains("_") == false && type.Contains("Dtl") == false)
|
|
|
{
|
|
|
if (oid.Equals("0"))
|
|
|
en = new GEEntity(this.FrmID);
|
|
|
else
|
|
|
en = new GEEntity(this.FrmID, Int64.Parse(oid));
|
|
|
}
|
|
|
if (this.ExtType == MapExtXmlList.FullData && field.Equals("Tag") == true)
|
|
|
{
|
|
|
string[] strs = sql.Split('$');
|
|
|
DataSet ds = new DataSet();
|
|
|
foreach (string str in strs)
|
|
|
{
|
|
|
if (DataType.IsNullOrEmpty(str) == true)
|
|
|
continue;
|
|
|
string[] ss = str.Split(':');
|
|
|
if (ss.Length == 2)
|
|
|
{
|
|
|
|
|
|
sql = DealExp(ss[1], paras, en);
|
|
|
DataTable dtt = null;
|
|
|
if (DataType.IsNullOrEmpty(this.DBSrcNo) == false && this.DBSrcNo.Equals("local") == false)
|
|
|
{
|
|
|
SFDBSrc sfdb = new SFDBSrc(this.DBSrcNo);
|
|
|
dtt = sfdb.RunSQLReturnTable(sql);
|
|
|
}
|
|
|
else
|
|
|
dtt = DBAccess.RunSQLReturnTable(sql);
|
|
|
if (BP.Difference.SystemConfig.AppCenterDBFieldCaseModel == FieldCaseModel.UpperCase)
|
|
|
{
|
|
|
dtt.Columns["NO"].ColumnName = "No";
|
|
|
dtt.Columns["NAME"].ColumnName = "Name";
|
|
|
|
|
|
//判断是否存在PARENTNO列，避免转换失败
|
|
|
if (dtt.Columns.Contains("PARENTNO") == true)
|
|
|
dtt.Columns["PARENTNO"].ColumnName = "ParentNo";
|
|
|
}
|
|
|
|
|
|
if (BP.Difference.SystemConfig.AppCenterDBFieldCaseModel == FieldCaseModel.Lowercase)
|
|
|
{
|
|
|
dtt.Columns["no"].ColumnName = "No";
|
|
|
dtt.Columns["name"].ColumnName = "Name";
|
|
|
|
|
|
//判断是否存在PARENTNO列，避免转换失败
|
|
|
if (dtt.Columns.Contains("parentno") == true)
|
|
|
dtt.Columns["parentno"].ColumnName = "ParentNo";
|
|
|
}
|
|
|
dtt.TableName = ss[0];
|
|
|
ds.Tables.Add(dtt);
|
|
|
}
|
|
|
}
|
|
|
return BP.Tools.Json.ToJson(ds);
|
|
|
}
|
|
|
|
|
|
if (DataType.IsNullOrEmpty(sqlWhere) == false)
|
|
|
{
|
|
|
if (sql.ToLower().IndexOf("where") == -1)
|
|
|
sql += "WHERE 1=1";
|
|
|
|
|
|
sql += sqlWhere;
|
|
|
}
|
|
|
|
|
|
sql = DealExp(sql, paras, en);
|
|
|
|
|
|
DataTable dt = null;
|
|
|
if (DataType.IsNullOrEmpty(this.DBSrcNo) == false && this.DBSrcNo.Equals("local") == false)
|
|
|
{
|
|
|
SFDBSrc sfdb = new SFDBSrc(this.DBSrcNo);
|
|
|
dt = sfdb.RunSQLReturnTable(sql);
|
|
|
}
|
|
|
else
|
|
|
dt = DBAccess.RunSQLReturnTable(sql);
|
|
|
|
|
|
if (BP.Difference.SystemConfig.AppCenterDBFieldCaseModel == FieldCaseModel.UpperCase)
|
|
|
{
|
|
|
if (dt.Columns.Contains("NO") == true)
|
|
|
dt.Columns["NO"].ColumnName = "No";
|
|
|
if (dt.Columns.Contains("NAME") == true)
|
|
|
dt.Columns["NAME"].ColumnName = "Name";
|
|
|
|
|
|
//判断是否存在PARENTNO列，避免转换失败
|
|
|
if (dt.Columns.Contains("PARENTNO") == true)
|
|
|
dt.Columns["PARENTNO"].ColumnName = "ParentNo";
|
|
|
}
|
|
|
|
|
|
if (BP.Difference.SystemConfig.AppCenterDBFieldCaseModel == FieldCaseModel.Lowercase)
|
|
|
{
|
|
|
if (dt.Columns.Contains("no") == true)
|
|
|
dt.Columns["no"].ColumnName = "No";
|
|
|
if (dt.Columns.Contains("name") == true)
|
|
|
dt.Columns["name"].ColumnName = "Name";
|
|
|
|
|
|
//判断是否存在PARENTNO列，避免转换失败
|
|
|
if (dt.Columns.Contains("parentno") == true)
|
|
|
dt.Columns["parentno"].ColumnName = "ParentNo";
|
|
|
}
|
|
|
|
|
|
return BP.Tools.Json.ToJson(dt);
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
public string GetDataTableByTag1(string key, string paras, string oid)
|
|
|
{
|
|
|
string sql = "";
|
|
|
if (DataType.IsNullOrEmpty(this.Tag1) == false)
|
|
|
{
|
|
|
string[] condition = this.Tag1.Split('$');
|
|
|
foreach (string para in condition)
|
|
|
{
|
|
|
if (para.Contains("Para=" + key + "#") == false)
|
|
|
continue;
|
|
|
if (para.Contains("ListSQL=") == false)
|
|
|
continue;
|
|
|
sql = para.Substring(para.IndexOf("ListSQL=") + 8);
|
|
|
break;
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
if (DataType.IsNullOrEmpty(sql) == true)
|
|
|
return "err@TableSearch设置的查询条件字段" + key + "的SQL查询语句为空";
|
|
|
|
|
|
GEEntity en = null;
|
|
|
if (DataType.IsNullOrEmpty(oid) == false)
|
|
|
en = new GEEntity(this.FrmID, Int64.Parse(oid));
|
|
|
sql = DealExp(sql, paras, en);
|
|
|
|
|
|
if (sql.Contains("@") == true)
|
|
|
return "err@执行的SQL中" + sql + " 有@符号没有被替换";
|
|
|
DataTable dt = null;
|
|
|
if (DataType.IsNullOrEmpty(this.DBSrcNo) == false && this.DBSrcNo.Equals("local") == false)
|
|
|
{
|
|
|
SFDBSrc sfdb = new SFDBSrc(this.DBSrcNo);
|
|
|
dt = sfdb.RunSQLReturnTable(sql);
|
|
|
}
|
|
|
else
|
|
|
dt = DBAccess.RunSQLReturnTable(sql);
|
|
|
|
|
|
return BP.Tools.Json.ToJson(dt);
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 表格查询
|
|
|
/// </summary>
|
|
|
/// <param name="paras"></param>
|
|
|
/// <returns></returns>
|
|
|
public string GetDataTableByTableSearch(string paras)
|
|
|
{
|
|
|
string sql = this.Tag2;
|
|
|
string sqlWhere = "";
|
|
|
if (sql.ToLower().IndexOf("where") == -1)
|
|
|
sql += "WHERE 1=1";
|
|
|
else
|
|
|
sqlWhere = sql.ToLower().Substring(sql.ToLower().IndexOf("where"));
|
|
|
if (DataType.IsNullOrEmpty(paras) == false)
|
|
|
{
|
|
|
Newtonsoft.Json.Linq.JObject json = Newtonsoft.Json.Linq.JObject.Parse(paras);
|
|
|
foreach (var item in json)
|
|
|
{
|
|
|
string val = item.Value != null ? item.Value.ToString() : "";
|
|
|
if (item.Key.Equals("Key"))
|
|
|
{
|
|
|
sql = sql.Replace("@Key", val);
|
|
|
continue;
|
|
|
}
|
|
|
|
|
|
if (item.Key.StartsWith("DTFrom_"))
|
|
|
{
|
|
|
string key = item.Key.Replace("DTFrom_", "");
|
|
|
if (sqlWhere.Contains(key) == false && DataType.IsNullOrEmpty(val) == false)
|
|
|
sql += " AND " + key + " >='" + val + "'";
|
|
|
else
|
|
|
sql = sql.Replace("@DTFrom_", val);
|
|
|
continue;
|
|
|
}
|
|
|
if (item.Key.StartsWith("DTTo_"))
|
|
|
{
|
|
|
string key = item.Key.Replace("DTTo_", "");
|
|
|
if (sqlWhere.Contains(key) == false && DataType.IsNullOrEmpty(val) == false)
|
|
|
sql += " AND " + key + " <='" + val + " 23:59'";
|
|
|
else
|
|
|
sql = sql.Replace("@DTFrom_", val);
|
|
|
continue;
|
|
|
}
|
|
|
if (sqlWhere.Contains(item.Key) == false)
|
|
|
{
|
|
|
if (DataType.IsNullOrEmpty(val) == false)
|
|
|
sql += " AND " + item.Key + "='" + val + "'";
|
|
|
else
|
|
|
sql = sql.Replace("@" + item.Key, val);
|
|
|
}
|
|
|
}
|
|
|
}
|
|
|
|
|
|
sql = DealExp(sql, "", null);
|
|
|
|
|
|
DataTable dt = null;
|
|
|
if (DataType.IsNullOrEmpty(this.DBSrcNo) == false && this.DBSrcNo.Equals("local") == false)
|
|
|
{
|
|
|
SFDBSrc sfdb = new SFDBSrc(this.DBSrcNo);
|
|
|
dt = sfdb.RunSQLReturnTable(sql);
|
|
|
}
|
|
|
else
|
|
|
dt = DBAccess.RunSQLReturnTable(sql);
|
|
|
|
|
|
if (BP.Difference.SystemConfig.AppCenterDBFieldCaseModel == FieldCaseModel.UpperCase)
|
|
|
{
|
|
|
dt.Columns["NO"].ColumnName = "No";
|
|
|
dt.Columns["NAME"].ColumnName = "Name";
|
|
|
|
|
|
//判断是否存在PARENTNO列，避免转换失败
|
|
|
if (dt.Columns.Contains("PARENTNO") == true)
|
|
|
dt.Columns["PARENTNO"].ColumnName = "ParentNo";
|
|
|
}
|
|
|
|
|
|
if (BP.Difference.SystemConfig.AppCenterDBFieldCaseModel == FieldCaseModel.Lowercase)
|
|
|
{
|
|
|
dt.Columns["no"].ColumnName = "No";
|
|
|
dt.Columns["name"].ColumnName = "Name";
|
|
|
|
|
|
//判断是否存在PARENTNO列，避免转换失败
|
|
|
if (dt.Columns.Contains("parentno") == true)
|
|
|
dt.Columns["parentno"].ColumnName = "ParentNo";
|
|
|
}
|
|
|
return BP.Tools.Json.ToJson(dt);
|
|
|
}
|
|
|
|
|
|
private string DealExp(string exp, string paras, Entity en)
|
|
|
{
|
|
|
//替换字符
|
|
|
exp = exp.Replace("~~", "\"");
|
|
|
exp = exp.Replace("~", "'");
|
|
|
|
|
|
if (exp.Contains("@") == false)
|
|
|
return exp;
|
|
|
|
|
|
//首先替换加; 的。
|
|
|
exp = exp.Replace("@WebUser.No;", WebUser.No);
|
|
|
exp = exp.Replace("@WebUser.Name;", WebUser.Name);
|
|
|
exp = exp.Replace("@WebUser.FK_DeptNameOfFull;", WebUser.DeptNameOfFull);
|
|
|
exp = exp.Replace("@WebUser.FK_DeptName;", WebUser.DeptName);
|
|
|
exp = exp.Replace("@WebUser.FK_Dept;", WebUser.DeptNo);
|
|
|
exp = exp.Replace("@WebUser.OrgNo;", WebUser.OrgNo);
|
|
|
exp = exp.Replace("@WebUser.OrgName;", WebUser.OrgName);
|
|
|
|
|
|
|
|
|
// 替换没有 ; 的 .
|
|
|
exp = exp.Replace("@WebUser.No", WebUser.No);
|
|
|
exp = exp.Replace("@WebUser.Name", WebUser.Name);
|
|
|
exp = exp.Replace("@WebUser.FK_DeptNameOfFull", WebUser.DeptNameOfFull);
|
|
|
exp = exp.Replace("@WebUser.FK_DeptName", WebUser.DeptName);
|
|
|
exp = exp.Replace("@WebUser.FK_Dept", WebUser.DeptNo);
|
|
|
exp = exp.Replace("@WebUser.OrgNo", WebUser.OrgNo);
|
|
|
exp = exp.Replace("@WebUser.OrgName", WebUser.OrgName);
|
|
|
|
|
|
if (exp.Contains("@") == false)
|
|
|
return exp;
|
|
|
|
|
|
if (DataType.IsNullOrEmpty(paras) == false && paras.Equals("undefined") == false)
|
|
|
{
|
|
|
if (paras.Contains("@") == true)
|
|
|
{
|
|
|
string[] strs = paras.Split('@');
|
|
|
foreach (string key in strs)
|
|
|
{
|
|
|
if (DataType.IsNullOrEmpty(key) == true)
|
|
|
continue;
|
|
|
string attrKeyOfEn = key.Split('=')[0];
|
|
|
string val = key.Split('=').Length == 1 ? "" : key.Split('=')[1];
|
|
|
exp = exp.Replace("@" + attrKeyOfEn, val);
|
|
|
if (exp.Contains("@") == false)
|
|
|
break;
|
|
|
|
|
|
}
|
|
|
}
|
|
|
else
|
|
|
{
|
|
|
exp = exp.Replace("@Key", paras);
|
|
|
exp = exp.Replace("@key", paras);
|
|
|
exp = exp.Replace("@KEY", paras);
|
|
|
}
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
if (exp.Contains("@") == false)
|
|
|
return exp;
|
|
|
|
|
|
//增加对新规则的支持. @MyField; 格式.
|
|
|
if (en != null)
|
|
|
{
|
|
|
Attrs attrs = en.EnMap.Attrs;
|
|
|
Row row = en.Row;
|
|
|
//特殊判断.
|
|
|
if (row.ContainsKey("OID") == true)
|
|
|
exp = exp.Replace("@WorkID", row["OID"].ToString());
|
|
|
|
|
|
if (exp.Contains("@") == false)
|
|
|
return exp;
|
|
|
|
|
|
foreach (string key in row.Keys)
|
|
|
{
|
|
|
//值为空或者null不替换
|
|
|
if (row[key] == null || row[key].Equals("") == true)
|
|
|
exp = exp.Replace("@" + key, "");
|
|
|
if (exp.Contains("@" + key))
|
|
|
exp = exp.Replace("@" + key, row[key].ToString());
|
|
|
|
|
|
//不包含@则返回SQL语句
|
|
|
if (exp.Contains("@") == false)
|
|
|
return exp;
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
if (exp.Contains("@") && BP.Difference.SystemConfig.isBSsystem == true)
|
|
|
{
|
|
|
/*如果是bs*/
|
|
|
foreach (string key in HttpContextHelper.RequestParamKeys)
|
|
|
{
|
|
|
if (string.IsNullOrEmpty(key))
|
|
|
continue;
|
|
|
exp = exp.Replace("@" + key, HttpContextHelper.RequestParams(key));
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
|
|
exp = exp.Replace("~", "'");
|
|
|
return exp;
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 保存大块html文本
|
|
|
/// </summary>
|
|
|
/// <returns></returns>
|
|
|
public string SaveBigNoteHtmlText(string text)
|
|
|
{
|
|
|
DBAccess.SaveBigTextToDB(text, "Sys_MapExt", "MyPK", this.MyPK, "HtmlText");
|
|
|
return "保存成功！";
|
|
|
}
|
|
|
|
|
|
public string ReadBigNoteHtmlText()
|
|
|
{
|
|
|
string doc = DBAccess.GetBigTextFromDB("Sys_MapExt", "MyPK", this.MyPK, "HtmlText");
|
|
|
return doc;
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 扩展s
|
|
|
/// </summary>
|
|
|
public class MapExts : Entities
|
|
|
{
|
|
|
#region 构造
|
|
|
/// <summary>
|
|
|
/// 扩展s
|
|
|
/// </summary>
|
|
|
public MapExts()
|
|
|
{
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 扩展s
|
|
|
/// </summary>
|
|
|
/// <param name="fk_mapdata">s</param>
|
|
|
public MapExts(string fk_mapdata)
|
|
|
{
|
|
|
this.Retrieve(MapExtAttr.FK_MapData, fk_mapdata, MapExtAttr.PRI);
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 得到它的 Entity
|
|
|
/// </summary>
|
|
|
public override Entity GetNewEntity
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return new MapExt();
|
|
|
}
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 为了适应自动翻译成java的需要,把实体转换成List.
|
|
|
/// <summary>
|
|
|
/// 转化成 java list,C#不能调用.
|
|
|
/// </summary>
|
|
|
/// <returns>List</returns>
|
|
|
public System.Collections.Generic.IList<MapExt> ToJavaList()
|
|
|
{
|
|
|
return (System.Collections.Generic.IList<MapExt>)this;
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 转化成list
|
|
|
/// </summary>
|
|
|
/// <returns>List</returns>
|
|
|
public System.Collections.Generic.List<MapExt> Tolist()
|
|
|
{
|
|
|
System.Collections.Generic.List<MapExt> list = new System.Collections.Generic.List<MapExt>();
|
|
|
for (int i = 0; i < this.Count; i++)
|
|
|
{
|
|
|
list.Add((MapExt)this[i]);
|
|
|
}
|
|
|
return list;
|
|
|
}
|
|
|
#endregion 为了适应自动翻译成java的需要,把实体转换成List.
|
|
|
}
|
|
|
}
|