using System;
using BP.DA;
using BP.En;
using BP.Sys;
using BP.Sys.Base;

namespace BP.WF.Template.Frm
{
    /// <summary>
    /// 明细
    /// </summary>
    public class MapDtlExt : EntityNoName
    {
        #region 导入导出属性.
        /// <summary>
        /// 用户访问.
        /// </summary>
        public override UAC HisUAC
        {
            get
            {

                UAC uac = new UAC();
                /* uac.OpenForAppAdmin();
                 uac.IsInsert = false;*/

                if (BP.Web.WebUser.IsAdmin == false)
                    throw new Exception("err@管理员登录用户信息丢失,当前会话[" + BP.Web.WebUser.No + "," + BP.Web.WebUser.Name + "]");

                uac.IsUpdate = true;
                uac.IsDelete = true;
                uac.IsInsert = false;
                return uac;
            }
        }
        /// <summary>
        /// 是否可以导出
        /// </summary>
        public bool ItIsImp
        {
            get
            {
                return this.GetValBooleanByKey(MapDtlAttr.IsImp);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.IsImp, value);
            }
        }
        /// <summary>
        /// 是否可以导入
        /// </summary>
        public bool ItIsExp
        {
            get
            {
                return this.GetValBooleanByKey(MapDtlAttr.IsExp);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.IsExp, value);
            }
        }
        /// <summary>
        /// 查询sql
        /// </summary>
        public string ImpSQLInit
        {
            get
            {
                return this.GetValStringByKey(MapDtlAttr.ImpSQLInit).Replace("~", "'");
            }
            set
            {
                this.SetValByKey(MapDtlAttr.ImpSQLInit, value);
            }
        }
        /// <summary>
        /// 搜索sql
        /// </summary>
        public string ImpSQLSearch
        {
            get
            {
                return this.GetValStringByKey(MapDtlAttr.ImpSQLSearch).Replace("~", "'");
            }
            set
            {
                this.SetValByKey(MapDtlAttr.ImpSQLSearch, value);
            }
        }
        /// <summary>
        /// 填充数据一行数据
        /// </summary>
        public string ImpSQLFullOneRow
        {
            get
            {
                return this.GetValStringByKey(MapDtlAttr.ImpSQLFullOneRow).Replace("~", "'");
            }
            set
            {
                this.SetValByKey(MapDtlAttr.ImpSQLFullOneRow, value);
            }
        }
        #endregion

        #region 基本设置
        /// <summary>
        /// 工作模式
        /// </summary>
        public DtlModel DtlModel
        {
            get
            {
                return (DtlModel)this.GetValIntByKey(MapDtlAttr.Model);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.Model, (int)value);
            }
        }
        /// <summary>
        /// 是否启用行锁定.
        /// </summary>
        public bool ItIsRowLock
        {
            get
            {
                return this.GetParaBoolen(MapDtlAttr.IsRowLock, false);
            }
            set
            {
                this.SetPara(MapDtlAttr.IsRowLock, value);
            }
        }
        #endregion 基本设置

        #region 参数属性
        /// <summary>
        /// 记录增加模式
        /// </summary>
        public DtlAddRecModel DtlAddRecModel
        {
            get
            {
                return (DtlAddRecModel)this.GetParaInt(MapDtlAttr.DtlAddRecModel);
            }
            set
            {
                this.SetPara(MapDtlAttr.DtlAddRecModel, (int)value);
            }
        }
        /// <summary>
        /// 保存方式
        /// </summary>
        public DtlSaveModel DtlSaveModel
        {
            get
            {
                return (DtlSaveModel)this.GetParaInt(MapDtlAttr.DtlSaveModel);
            }
            set
            {
                this.SetPara(MapDtlAttr.DtlSaveModel, (int)value);
            }
        }
        /// <summary>
        /// 是否启用Link,在记录的右边.
        /// </summary>
        public bool ItIsEnableLink
        {
            get
            {
                return this.GetValBooleanByKey(MapDtlAttr.IsEnableLink, false);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.IsEnableLink, value);
                this.SetPara(MapDtlAttr.IsEnableLink, value);
            }
        }
        public string LinkLabel
        {
            get
            {
                string s = this.GetValStrByKey(MapDtlAttr.LinkLabel);
                if (DataType.IsNullOrEmpty(s))
                    return "详细";
                return s;
            }
            set
            {
                this.SetValByKey(MapDtlAttr.LinkLabel, value);
                this.SetPara(MapDtlAttr.LinkLabel, value);
            }
        }
        public string LinkUrl
        {
            get
            {
                string s = this.GetValStrByKey(MapDtlAttr.LinkUrl);
                if (DataType.IsNullOrEmpty(s))
                    return "http://ccport.org";

                s = s.Replace("*", "@");
                return s;
            }
            set
            {
                string val = value;
                val = val.Replace("@", "*");
                this.SetValByKey(MapDtlAttr.LinkUrl, val);
                this.SetPara(MapDtlAttr.LinkUrl, val);
            }
        }
        public string LinkTarget
        {
            get
            {
                string s = this.GetValStrByKey(MapDtlAttr.LinkTarget);
                if (DataType.IsNullOrEmpty(s))
                    return "_blank";
                return s;
            }
            set
            {
                this.SetValByKey(MapDtlAttr.LinkTarget, value);
                this.SetPara(MapDtlAttr.LinkTarget, value);
            }
        }
        /// <summary>
        /// 子线程处理人字段(用于分流节点的明细表分配子线程任务).
        /// </summary>
        public string SubThreadWorker
        {
            get
            {
                string s = this.GetParaString(MapDtlAttr.SubThreadWorker);
                if (DataType.IsNullOrEmpty(s))
                    return "";
                return s;
            }
            set
            {
                this.SetPara(MapDtlAttr.SubThreadWorker, value);
            }
        }
        /// <summary>
        /// 子线程分组字段(用于分流节点的明细表分配子线程任务)
        /// </summary>
        public string SubThreadGroupMark
        {
            get
            {
                string s = this.GetParaString(MapDtlAttr.SubThreadGroupMark);
                if (DataType.IsNullOrEmpty(s))
                    return "";
                return s;
            }
            set
            {
                this.SetPara(MapDtlAttr.SubThreadGroupMark, value);
            }
        }
        /// <summary>
        /// 节点ID
        /// </summary>
        public int NodeID
        {
            get
            {
                return this.GetValIntByKey(MapDtlAttr.FK_Node);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.FK_Node, value);
            }
        }
        #endregion 参数属性

        #region 外键属性
        /// <summary>
        /// 框架
        /// </summary>
        public MapFrames MapFrames
        {
            get
            {
                MapFrames obj = this.GetRefObject("MapFrames") as MapFrames;
                if (obj == null)
                {
                    obj = new MapFrames(this.No);
                    this.SetRefObject("MapFrames", obj);
                }
                return obj;
            }
        }
        /// <summary>
        /// 分组字段
        /// </summary>
        public GroupFields GroupFields_del
        {
            get
            {
                GroupFields obj = this.GetRefObject("GroupFields") as GroupFields;
                if (obj == null)
                {
                    obj = new GroupFields(this.No);
                    this.SetRefObject("GroupFields", obj);
                }
                return obj;
            }
        }
        /// <summary>
        /// 逻辑扩展
        /// </summary>
        public MapExts MapExts
        {
            get
            {
                MapExts obj = this.GetRefObject("MapExts") as MapExts;
                if (obj == null)
                {
                    obj = new MapExts(this.No);
                    this.SetRefObject("MapExts", obj);
                }
                return obj;
            }
        }
        /// <summary>
        /// 事件
        /// </summary>
        public FrmEvents FrmEvents
        {
            get
            {
                FrmEvents obj = this.GetRefObject("FrmEvents") as FrmEvents;
                if (obj == null)
                {
                    obj = new FrmEvents(this.No);
                    this.SetRefObject("FrmEvents", obj);
                }
                return obj;
            }
        }
        /// <summary>
        /// 从表
        /// </summary>
        public MapDtls MapDtls
        {
            get
            {
                MapDtls obj = this.GetRefObject("MapDtls") as MapDtls;
                if (obj == null)
                {
                    obj = new MapDtls(this.No);
                    this.SetRefObject("MapDtls", obj);
                }
                return obj;
            }
        }

        /// <summary>
        /// 图片
        /// </summary>
        public FrmImgs FrmImgs
        {
            get
            {
                FrmImgs obj = this.GetRefObject("FrmLabs") as FrmImgs;
                if (obj == null)
                {
                    obj = new FrmImgs(this.No);
                    this.SetRefObject("FrmLabs", obj);
                }
                return obj;
            }
        }
        /// <summary>
        /// 附件
        /// </summary>
        public FrmAttachments FrmAttachments
        {
            get
            {
                FrmAttachments obj = this.GetRefObject("FrmAttachments") as FrmAttachments;
                if (obj == null)
                {
                    obj = new FrmAttachments(this.No);
                    this.SetRefObject("FrmAttachments", obj);
                }
                return obj;
            }
        }
        /// <summary>
        /// 图片附件
        /// </summary>
        public FrmImgAths FrmImgAths
        {
            get
            {
                FrmImgAths obj = this.GetRefObject("FrmImgAths") as FrmImgAths;
                if (obj == null)
                {
                    obj = new FrmImgAths(this.No);
                    this.SetRefObject("FrmImgAths", obj);
                }
                return obj;
            }
        }
        /// <summary>
        /// 单选按钮
        /// </summary>
        public FrmRBs FrmRBs
        {
            get
            {
                FrmRBs obj = this.GetRefObject("FrmRBs") as FrmRBs;
                if (obj == null)
                {
                    obj = new FrmRBs(this.No);
                    this.SetRefObject("FrmRBs", obj);
                }
                return obj;
            }
        }
        /// <summary>
        /// 属性
        /// </summary>
        public MapAttrs MapAttrs
        {
            get
            {
                MapAttrs obj = this.GetRefObject("MapAttrs") as MapAttrs;
                if (obj == null)
                {
                    obj = new MapAttrs(this.No);
                    this.SetRefObject("MapAttrs", obj);
                }
                return obj;
            }
        }
        #endregion

        #region 属性
        public GEDtls HisGEDtls_temp = null;
        /// <summary>
        /// 是否显示数量
        /// </summary>
        public bool ItIsShowSum
        {
            get
            {
                return this.GetValBooleanByKey(MapDtlAttr.IsShowSum);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.IsShowSum, value);
            }
        }
        /// <summary>
        /// 是否显示Idx
        /// </summary>
        public bool ItIsShowIdx
        {
            get
            {
                return this.GetValBooleanByKey(MapDtlAttr.IsShowIdx);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.IsShowIdx, value);
            }
        }
        /// <summary>
        /// 是否显示标题
        /// </summary>
        public bool ItIsShowTitle
        {
            get
            {
                return this.GetValBooleanByKey(MapDtlAttr.IsShowTitle);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.IsShowTitle, value);
            }
        }
        /// <summary>
        /// 是否是合流汇总数据
        /// </summary>
        public bool ItIsHLDtl
        {
            get
            {
                return this.GetValBooleanByKey(MapDtlAttr.IsHLDtl);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.IsHLDtl, value);
            }
        }
        /// <summary>
        /// 是否是分流
        /// </summary>
        public bool ItIsFLDtl
        {
            get
            {
                return this.GetParaBoolen(MapDtlAttr.IsFLDtl);
            }
            set
            {
                this.SetPara(MapDtlAttr.IsFLDtl, value);
            }
        }
        public int _IsReadonly = 2;
        public bool ItIsReadonly
        {
            get
            {
                if (_IsReadonly != 2)
                {
                    if (_IsReadonly == 1)
                        return true;
                    else
                        return false;
                }

                if (this.ItIsDelete || this.ItIsInsert || this.ItIsUpdate)
                {
                    _IsReadonly = 0;
                    return false;
                }
                _IsReadonly = 1;
                return true;
            }
        }
        /// <summary>
        /// 是否可以删除？
        /// </summary>
        public bool ItIsDelete
        {
            get
            {
                return this.GetValBooleanByKey(MapDtlAttr.IsDelete);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.IsDelete, value);
            }
        }
        /// <summary>
        /// 是否可以新增？
        /// </summary>
        public bool ItIsInsert
        {
            get
            {
                return this.GetValBooleanByKey(MapDtlAttr.IsInsert);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.IsInsert, value);
            }
        }
        /// <summary>
        /// 是否可见
        /// </summary>
        public bool ItIsView
        {
            get
            {
                return this.GetValBooleanByKey(MapDtlAttr.IsView);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.IsView, value);
            }
        }
        /// <summary>
        /// 是否可以更新？
        /// </summary>
        public bool ItIsUpdate
        {
            get
            {
                return this.GetValBooleanByKey(MapDtlAttr.IsUpdate);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.IsUpdate, value);
            }
        }
        /// <summary>
        /// 是否启用多附件
        /// </summary>
        public bool ItIsEnableAthM
        {
            get
            {
                return this.GetValBooleanByKey(MapDtlAttr.IsEnableAthM);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.IsEnableAthM, value);
            }
        }
        /// <summary>
        /// 是否启用分组字段
        /// </summary>
        public bool ItIsEnableGroupField
        {
            get
            {
                return this.GetValBooleanByKey(MapDtlAttr.IsEnableGroupField);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.IsEnableGroupField, value);
            }
        }
        /// <summary>
        /// 是否起用审核连接
        /// </summary>
        public bool ItIsEnablePass
        {
            get
            {
                return this.GetValBooleanByKey(MapDtlAttr.IsEnablePass);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.IsEnablePass, value);
            }
        }

        /// <summary>
        /// 是否copy数据？
        /// </summary>
        public bool ItIsCopyNDData
        {
            get
            {
                return this.GetValBooleanByKey(MapDtlAttr.IsCopyNDData);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.IsCopyNDData, value);
            }
        }
      
        /// <summary>
        /// 是否启用一对多多
        /// </summary>
    
        public bool ItIsUse = false;
        /// <summary>
        /// 是否检查人员的权限
        /// </summary>
        public DtlOpenType DtlOpenType
        {
            get
            {
                return (DtlOpenType)this.GetValIntByKey(MapDtlAttr.DtlOpenType);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.DtlOpenType, (int)value);
            }
        }
        /// <summary>
        /// 分组字段
        /// </summary>
        public string GroupField
        {
            get
            {
                return this.GetValStrByKey(MapDtlAttr.GroupField);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.GroupField, value);
            }
        }
        /// <summary>
        /// 表单ID
        /// </summary>
        public string FrmID
        {
            get
            {
                return this.GetValStrByKey(MapDtlAttr.FK_MapData);
            }
        }
        /// <summary>
        /// 事件类.
        /// </summary>
        public string FEBD
        {
            get
            {
                return this.GetValStrByKey(MapDtlAttr.FEBD);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.FEBD, value);
            }
        }

        /// <summary>
        /// 数量
        /// </summary>
        public int RowsOfList
        {
            get
            {
                //如果不可以插入，就让其返回0.
                if (this.ItIsInsert == false)
                    return 0;

                return this.GetValIntByKey(MapDtlAttr.RowsOfList);
            }
            set
            {
                this.SetValByKey(MapDtlAttr.RowsOfList, value);
            }
        }
        /// <summary>
        /// 物理表
        /// </summary>
        public string PTable
        {
            get
            {
                string s = this.GetValStrByKey(MapDtlAttr.PTable);
                if (DataType.IsNullOrEmpty(s) == true)
                {
                    s = this.No;
                    if (s.Substring(0, 1) == "0")
                    {
                        return "T" + this.No;
                    }
                    else
                        return s;
                }
                else
                {
                    if (s.Substring(0, 1) == "0")
                    {
                        return "T" + this.No;
                    }
                    else
                        return s;
                }
            }
            set
            {
                this.SetValByKey(MapDtlAttr.PTable, value);
            }
        }
        /// <summary>
        /// 多表头
        /// </summary>
        //public string MTR
        //{
        //    get
        //    {
        //        string s = this.GetValStrByKey(MapDtlAttr.MTR);
        //        s = s.Replace("《", "<");
        //        s = s.Replace("》", ">");
        //        s = s.Replace("‘", "'");
        //        return s;
        //    }
        //    set
        //    {
        //        string s = value;
        //        s = s.Replace("<", "《");
        //        s = s.Replace(">", "》");
        //        s = s.Replace("'", "‘");
        //        this.SetValByKey(MapDtlAttr.MTR, value);
        //    }
        //}
        #endregion

        #region 构造方法
        /// <summary>
        /// 明细
        /// </summary>
        public MapDtlExt()
        {
        }
        public MapDtlExt(string mypk)
        {
            this.No = mypk;
            this._IsReadonly = 2;
            this.Retrieve();
        }
        /// <summary>
        /// EnMap
        /// </summary>
        public override Map EnMap
        {
            get
            {
                if (this._enMap != null)
                    return this._enMap;
                Map map = new Map("Sys_MapDtl", "明细");

                map.DepositaryOfEntity = Depositary.Application;
                map.IndexField = MapDtlAttr.FK_MapData;

                #region 基础信息.
                map.AddGroupAttr("基本属性");
                map.AddTBStringPK(MapDtlAttr.No, null, "编号", true, false, 1, 100, 20);
                map.AddTBString(MapDtlAttr.Name, null, "名称", true, false, 1, 200, 20);
                map.AddTBString(MapDtlAttr.Alias, null, "别名", true, false, 0, 100, 20, false);
                map.SetHelperAlert(MapDtlAttr.Alias, "用于Excel表单有效.");

                map.AddTBString(MapDtlAttr.FK_MapData, null, "表单ID", true, true, 0, 100, 20);
                map.AddTBString(MapDtlAttr.PTable, null, "存储表", true, false, 0, 200, 20);
                map.SetHelperAlert(MapDtlAttr.PTable, "默认与编号为同一个存储表.");

                map.AddTBString(MapDtlAttr.FEBD, null, "事件类实体类", true, true, 0, 100, 20, false);

                map.AddDDLSysEnum(MapDtlAttr.Model, 0, "工作模式", true, true, MapDtlAttr.Model, "@0=普通@1=固定行");
                map.AddDDLSysEnum(MapDtlAttr.DtlVer, 0, "使用版本", true, true, MapDtlAttr.DtlVer, "@0=2017传统版");


                //map.AddTBString(MapDtlAttr.ImpFixTreeSql, null, "固定列树形SQL", true, false, 0, 500, 20);
                //map.AddTBString(MapDtlAttr.ImpFixDataSql, null, "固定列数据SQL", true, false, 0, 500, 20);

                map.AddTBInt(MapDtlAttr.RowsOfList, 0, "初始化行数", true, false);
                //map.SetHelperAlert(MapDtlAttr.RowsOfList, "对第1个版本有效.");

                map.AddBoolean(MapDtlAttr.IsEnableGroupField, false, "是否启用分组字段", true, true);

                map.AddBoolean(MapDtlAttr.IsShowSum, true, "是否显示合计？", true, true);
                map.AddBoolean(MapDtlAttr.IsShowIdx, true, "是否显示序号？", true, true);

                map.AddBoolean(MapDtlAttr.IsReadonly, false, "是否只读？", true, true);
                map.AddBoolean(MapDtlAttr.IsShowTitle, true, "是否显示标题？", true, true);
                map.AddBoolean(MapDtlAttr.IsView, true, "是否可见？", true, true);

                map.AddBoolean(MapDtlAttr.IsInsert, true, "是否可以插入行？", true, true);
                map.AddBoolean(MapDtlAttr.IsDelete, true, "是否可以删除行？", true, true);
                map.AddBoolean(MapDtlAttr.IsUpdate, true, "是否可以更新？", true, true);
                map.AddBoolean(MapDtlAttr.IsEnableAthM, false, "是否启用多附件", true, true);
                map.AddBoolean(MapDtlAttr.IsImp, false, "是否可以导出？", true, true);
                map.AddBoolean(MapDtlAttr.IsCopyFirstData, false, "是否复制第一行数据？", true, true);


                map.AddTBString(MapDtlAttr.InitDBAttrs, null, "行初始化字段", true, false, 0, 40, 20, false);
                map.SetHelperAlert(MapDtlAttr.InitDBAttrs, "格式为:F1,F2,按照枚举外键字段的合集初始化行数据，一般用于不让其新增行。比如：为每个房间都要初始化一笔观测数据。.");


                map.AddDDLSysEnum(MapDtlAttr.WhenOverSize, 0, "超出行数", true, true, MapDtlAttr.WhenOverSize, "@0=不处理@1=向下顺增行@2=次页显示");

                // 为浙商银行设置从表打开.翻译.
                map.AddDDLSysEnum(MapDtlAttr.ListShowModel, 0, "列表数据显示格式", true, true, MapDtlAttr.ListShowModel, "@0=表格@1=卡片@2=自定义Url");

                map.AddDDLSysEnum(MapDtlAttr.EditModel, 0, "编辑数据方式", true, true, MapDtlAttr.EditModel, "@0=表格模式@1=傻瓜表单@2=开发者表单");
                map.SetHelperAlert(MapDtlAttr.EditModel, "格式为:第1种类型就要新建行,其他类型新建的时候弹出卡片.");
                map.AddTBString(MapDtlAttr.UrlDtl, null, "自定义Url", true, false, 0, 200, 20, true);

                map.AddTBString(MapDtlAttr.ColAutoExp, null, "列字段计算", true, false, 0, 200, 20, true);
                map.SetHelperAlert(MapDtlAttr.ColAutoExp, "用于计算指定列字段求和/求平均例如：@ShuLiang=Sum@DanJia=Sum@XiaoJi=Sum");

                map.AddTBInt(MapDtlAttr.NumOfDtl, 0, "最小从表集合", true, false);
                map.SetHelperAlert(MapDtlAttr.NumOfDtl, "用于控制输入的行数据最小值，比如：从表不能为空，就是用这个模式。");

                //用于控制傻瓜表单.
                map.AddTBFloat(MapDtlAttr.H, 350, "高度", true, false);
                map.SetHelperAlert(MapDtlAttr.H, "对傻瓜表单有效");

                //移动端数据显示方式
                map.AddDDLSysEnum(MapDtlAttr.MobileShowModel, 0, "移动端数据显示方式", true, true, MapDtlAttr.MobileShowModel, "@0=新页面显示模式@1=列表模式@2=主页面平铺模式");
                map.AddTBString(MapDtlAttr.MobileShowField, null, "移动端列表显示字段", true, false, 0, 100, 20, false);

                //map.AddTBFloat(MapDtlAttr.X, 5, "距左", false, false);
                //map.AddTBFloat(MapDtlAttr.Y, 5, "距上", false, false);
                //map.AddTBFloat(MapDtlAttr.W, 200, "宽度", true, false);

                //map.AddTBFloat(MapDtlAttr.FrmW, 900, "表单宽度", true, true);
                //map.AddTBFloat(MapDtlAttr.FrmH, 1200, "表单高度", true, true);

                //对显示的结果要做一定的限制.
                map.AddTBString(MapDtlAttr.FilterSQLExp, null, "过滤数据SQL表达式", true, false, 0, 200, 20, true);
                map.SetHelperUrl(MapDtlAttr.FilterSQLExp, "https://gitee.com/opencc/JFlow/wikis/pages/preview?sort_id=4711478&doc_id=31094");
                // map.SetHelperAlert(MapDtlAttr.FilterSQLExp, "格式为:WFState=1 过滤WFState=1的数据");

                //对显示的结果要做一定的限制.
                map.AddTBString(MapDtlAttr.OrderBySQLExp, null, "排序字段", true, false, 0, 200, 20, true);
                map.SetHelperAlert(MapDtlAttr.OrderBySQLExp, "格式1: MyFile1,MyField2 ,格式2: MyFile1 DESC  就是SQL语句的 Ordery By 后面的字符串，默认按照 OID (输入的顺序)排序.");

               
                //要显示的列.
                map.AddTBString(MapDtlAttr.ShowCols, null, "显示的列", true, false, 0, 500, 20, true);
                map.SetHelperAlert(MapDtlAttr.ShowCols, "默认为空,全部显示,如果配置了就按照配置的计算,格式为:field1,field2");

                map.AddTBString(MapDtlAttr.GUID, null, "GUID", false, false, 0, 128, 20);
                #endregion 基础信息.

                #region 导入导出填充. 此部分的功能 
                // 2014-07-17 for xinchang bank.
                map.AddBoolean(MapDtlAttr.IsExp, true, "是否可以导入？", false, true);

                //导入模式.
                map.AddDDLSysEnum(MapDtlAttr.ImpModel, 0, "导入方式", false, false, MapDtlAttr.ImpModel,
                    "@0=不导入@1=按配置模式导入@2=按照xls文件模版导入");
                //string strs = "如果是按照xls导入,请做一个从表ID.xls的模版文件放在:/DataUser/DtlTemplate/ 下面. 目前仅仅支持xls文件.";
                // map.SetHelperAlert(MapDtlAttr.ImpModel, strs);

                map.AddTBStringDoc(MapDtlAttr.ImpSQLInit, null, "初始化SQL(初始化表格的时候的SQL数据,可以为空)", false, false, true);
                map.AddTBStringDoc(MapDtlAttr.ImpSQLSearch, null, "查询SQL(SQL里必须包含@Key关键字.)", false, false, true);
                map.AddTBStringDoc(MapDtlAttr.ImpSQLFullOneRow, null, "数据填充一行数据的SQL(必须包含@Key关键字,为选择的主键)", false, false, true);
                map.AddTBString(MapDtlAttr.ImpSQLNames, null, "列的中文名称", false, false, 0, 900, 20, true);

                #endregion 导入导出填充.

                #region 超链接.
                map.AddGroupAttr("超链接");
                map.AddBoolean(MapDtlAttr.IsEnableLink, false, "相关功能1", true, true);
                map.AddTBString(MapDtlAttr.LinkLabel, "", "超连接/功能标签", true, false, 0, 50, 100);
                map.AddDDLSysEnum(MapDtlAttr.ExcType, 0, "执行类型", true, true, "ExcType",
                    "@0=超链接@1=函数");
                map.AddTBString(MapDtlAttr.LinkTarget, null, "LinkTarget", true, false, 0, 10, 100);
                map.AddTBString(MapDtlAttr.LinkUrl, null, "连接/函数", true, false, 0, 200, 200, true);


                map.AddBoolean(MapDtlAttr.IsEnableLink2, false, "相关功能2", true, true);
                map.AddTBString(MapDtlAttr.LinkLabel2, "", "超连接/功能标签", true, false, 0, 50, 100);
                map.AddDDLSysEnum(MapDtlAttr.ExcType2, 0, "执行类型", true, true, "ExcType",
                    "@0=超链接@1=函数");
                map.AddTBString(MapDtlAttr.LinkTarget2, null, "LinkTarget", true, false, 0, 10, 100);
                map.AddTBString(MapDtlAttr.LinkUrl2, null, "连接/函数", true, false, 0, 200, 200, true);
                #endregion 超链接.

                #region 工作流相关.
                map.AddGroupAttr("工作流相关");
                //add 2014-02-21.
                map.AddBoolean(MapDtlAttr.IsCopyNDData, true, "是否允许copy节点数据", true, true);
                map.AddTBInt(MapDtlAttr.FK_Node, 0, "节点(用户独立表单权限控制)", false, false);
                map.AddBoolean(MapDtlAttr.IsHLDtl, false, "是否是合流汇总", true, true);
                string sql = "SELECT KeyOfEn as No, Name FROM Sys_MapAttr WHERE FK_MapData='@No' AND  ( (MyDataType =1 and UIVisible=1 ) or (UIContralType=1))";
                map.AddDDLSQL(MapDtlAttr.SubThreadWorker, null, "子线程处理人字段", sql, true);
                map.AddBoolean(MapDtlAttr.IsEnablePass, false, "是否启用通过审核功能?", true, true);
                map.AddDDLSysEnum(MapDtlAttr.DtlOpenType, 1, "数据开放类型", true, true, MapDtlAttr.DtlOpenType, "@0=操作员@1=WorkID-流程ID@2=FID-干流程ID@3=PWorkID-父流程WorkID");
                #endregion 工作流相关.

                #region 相关方法.
                map.AddGroupMethod("基本功能");
                RefMethod rm = new RefMethod();
                rm = new RefMethod();
                rm.Title = "隐藏字段"; // "设计表单";
                rm.ClassMethodName = this.ToString() + ".HidAttr";
                //rm.Icon = "../Img/Setting.png";
                rm.Icon = "icon-ghost";

                rm.Visable = true;
                rm.RefMethodType = RefMethodType.RightFrameOpen;
                rm.Target = "_blank";
                map.AddRefMethod(rm);

                rm = new RefMethod();
                rm.Title = "导入其它数据源字段"; // "设计表单";
                rm.Warning = "导入后系统不会自动刷新，请手工刷新。";
                rm.ClassMethodName = this.ToString() + ".ImpFields";
                rm.RefMethodType = RefMethodType.LinkeWinOpen;
                rm.Icon = "icon-arrow-down-circle";
                map.AddRefMethod(rm);

                rm = new RefMethod();
                rm.Icon = "icon-arrow-down-circle";
                rm.Title = "导入其它从表字段"; // "设计表单";
                rm.Warning = "导入后系统不会自动刷新，请手工刷新。";
                rm.ClassMethodName = this.ToString() + ".ImpFromDtlID";
                rm.HisAttrs.AddTBString("ID", null, "请输入要导入的从表ID", true, false, 0, 100, 100);
                rm.RefMethodType = RefMethodType.Func;
                map.AddRefMethod(rm);

                rm = new RefMethod();
                rm.Icon = "icon-credit-card";
                rm.Title = "多表头"; // "设计表单";
                rm.ClassMethodName = this.ToString() + ".DoMultiTitle";
                // rm.Icon = "../Img/AttachmentM.png";
                rm.Visable = true;
                rm.RefMethodType = RefMethodType.RightFrameOpen;
                rm.Target = "_blank";
                map.AddRefMethod(rm);

                rm = new RefMethod();
                rm.Title = "设计傻瓜表单"; // "设计表单";
                rm.ClassMethodName = this.ToString() + ".DFoolFrm";
                //  rm.Icon = "../Img/Setting.png";
                rm.Icon = "icon-screen-desktop";

                rm.Visable = true;
                rm.RefMethodType = RefMethodType.LinkeWinOpen;
                rm.Target = "_blank";
                map.AddRefMethod(rm);


                rm = new RefMethod();
                rm.Title = "从表附件"; // "设计表单";
                rm.ClassMethodName = this.ToString() + ".OpenAthAttr";
                //  rm.Icon = "../Img/AttachmentM.png";
                rm.Icon = "icon-paper-clip";

                rm.Visable = true;
                rm.RefMethodType = RefMethodType.LinkeWinOpen;
                rm.Target = "_blank";
                map.AddRefMethod(rm);

                rm = new RefMethod();
                rm.Title = "生成英文字段"; // "设计表单";
                rm.ClassMethodName = this.ToString() + ".GenerAttrs";
                rm.RefMethodType = RefMethodType.Func;
                rm.Warning = "生成英文字段列，方便字段数据copy使用.";
                rm.Icon = "icon-heart";
                map.AddRefMethod(rm);

                rm = new RefMethod();
                rm.Icon = "icon-credit-card";
                rm.Title = "分组属性"; // "设计表单";
                rm.ClassMethodName = this.ToString() + ".DoGroup";
                // rm.Icon = "../Img/AttachmentM.png";
                rm.Visable = true;
                rm.RefMethodType = RefMethodType.RightFrameOpen;
                rm.Target = "_blank";
                map.AddRefMethod(rm);
                #endregion 相关方法.

                #region 实验中的功能.
                map.AddGroupMethod("实验中的功能");
                rm = new RefMethod();
               // rm.GroupName = "实验中的功能";
                rm.Title = "列自动计算"; // "设计表单";
                rm.ClassMethodName = this.ToString() + ".ColAutoExp";
                // rm.Icon = "../Img/Setting.png";
                rm.Icon = "icon-pin";

                rm.Visable = true;
                rm.RefMethodType = RefMethodType.RightFrameOpen;
                rm.Target = "_blank";
                map.AddRefMethod(rm);

                rm = new RefMethod();
              //  rm.GroupName = "实验中的功能";
                rm.Title = "数据导入"; // "设计表单";
                rm.ClassMethodName = this.ToString() + ".DtlImp";
                //rm.Icon = "../Img/Setting.png";
                rm.Icon = "icon-action-redo";

                rm.Visable = true;
                rm.RefMethodType = RefMethodType.RightFrameOpen;
                rm.Target = "_blank";
                map.AddRefMethod(rm);

                rm = new RefMethod();
              ///  rm.GroupName = "实验中的功能";
                rm.Title = "数据导入v2019"; // "设计表单";
                rm.ClassMethodName = this.ToString() + ".DtlImpV2019";
                //rm.Icon = "../Img/Setting.png";
                rm.Icon = "icon-action-redo";

                rm.Visable = true;
                rm.RefMethodType = RefMethodType.RightFrameOpen;
                rm.Target = "_blank";
                map.AddRefMethod(rm);


                rm = new RefMethod();
               // rm.GroupName = "实验中的功能";
                rm.Title = "事件"; // "设计表单";
                rm.ClassMethodName = this.ToString() + ".DoAction";
                //  rm.Icon = "../Img/Setting.png";
                rm.Icon = "icon-energy";

                rm.Visable = true;
                rm.RefMethodType = RefMethodType.RightFrameOpen;
                rm.Target = "_blank";
                map.AddRefMethod(rm);
                #endregion 实验中的功能.

                this._enMap = map;
                return this._enMap;
            }
        }

        protected override void afterInsertUpdateAction()
        {
            //调用frmEditAction, 完成其他的操作.
            BP.Sys.CCFormAPI.AfterFrmEditAction(this.FrmID);

            base.afterInsertUpdateAction();
        }
        /// <summary>
        /// 导入其他从表字段
        /// </summary>
        /// <returns></returns>
        public string ImpFromDtlID(string dtlId)
        {
            MapDtl dtl = new MapDtl();
            dtl.No = dtlId;
            if (dtl.RetrieveFromDBSources() == 0)
                return "err@" + dtlId + "输入错误.";

            //MapDtl dtlOfThis = new MapDtl(this.No);
            //dtlOfThis.Copy(dtl);
            //dtlOfThis.FrmID =this.FrmID;
            //dtlOfThis.Update();

            //删除当前从表Attrs.
            MapAttrs attrs = new MapAttrs();
            attrs.Delete(MapAttrAttr.FK_MapData, this.No);

            //查询出来要导入的.
            attrs.Retrieve(MapAttrAttr.FK_MapData, dtlId);

            //执行字段导入.
            foreach (MapAttr item in attrs)
            {
                item.FrmID =this.No;
                item.Save();
            }

            //删除当前从表 exts .
            MapExts exts = new MapExts();
            exts.Delete(MapAttrAttr.FK_MapData, this.No);

            //查询出来要导入的.
            exts.Retrieve(MapAttrAttr.FK_MapData, dtlId);

            //执行字段导入.
            foreach (MapExt item in exts)
            {
                item.FrmID =this.No;
                item.Save();
            }

            return "导入成功.";
        }
        /// <summary>
        /// 编辑分组属性
        /// </summary>
        /// <returns></returns>
        public string DoGroup()
        {
            GroupField gf = new GroupField();
            int i = gf.Retrieve(GroupFieldAttr.FrmID, this.FrmID, GroupFieldAttr.CtrlID, this.No);
            if (i == 0)
            {
                gf.Lab = this.Name;
                gf.FrmID = this.FrmID;
                gf.CtrlType = "Dtl";
                gf.CtrlID = this.No;
                gf.Idx = 10;
                gf.Insert();
            }
            string url = "../../Comm/EnOnly.htm?EnName=BP.Sys.GroupField&PKVal=" + gf.OID + "&Token=" + Web.WebUser.Token + "&AppCenterDBType=" + DBAccess.AppCenterDBType + "&CustomerNo=" + BP.Difference.SystemConfig.CustomerNo;
            return url;
        }
        /// <summary>
        /// 打开从表附件属性.
        /// </summary>
        /// <returns></returns>
        public string OpenAthAttr()
        {
            string url = "../../Admin/FoolFormDesigner/DtlSetting/AthMDtl.htm?FK_MapData=" + this.No + "&FromDtl=1&IsFirst=1&UserNo=" + BP.Web.WebUser.No + "&Token=" + Web.WebUser.Token + "&AppCenterDBType=" + DBAccess.AppCenterDBType + "&CustomerNo=" + BP.Difference.SystemConfig.CustomerNo;

            // string url = "../../Comm/RefFunc/En.htm?EnName=BP.Sys.FrmUI.FrmAttachmentExt&PKVal=" + this.No + "_AthMDtl";
            // string url = "../../Admin/FoolFormDesigner/DtlSetting/DtlImp.htm?FK_MapData=" + this.No + "&FromDtl=1&IsFirst=1&UserNo=" + BP.Web.WebUser.No + "&Token=" + Web.WebUser.SID + "&AppCenterDBType=" + DBAccess.AppCenterDBType + "&CustomerNo=" + BP.Difference.SystemConfig.CustomerNo;
            return url;
        }

        /// <summary>
        /// 导入
        /// </summary>
        /// <returns></returns>
        public string DtlImp()
        {
            string url = "../../Admin/FoolFormDesigner/DtlSetting/DtlImp.htm?FK_MapData=" + this.No + "&FromDtl=1&IsFirst=1&UserNo=" + BP.Web.WebUser.No + "&Token=" + Web.WebUser.Token + "&AppCenterDBType=" + DBAccess.AppCenterDBType + "&CustomerNo=" + BP.Difference.SystemConfig.CustomerNo;
            // string url = "../../Admin/FoolFormDesigner/DtlSetting/DtlImp/Default.htm?FK_MapDtl=" + this.No + "&FromDtl=1";
            return url;
        }
        /// <summary>
        /// 导入V2019
        /// </summary>
        /// <returns></returns>
        public string DtlImpV2019()
        {
            //string url = "../../Admin/FoolFormDesigner/DtlSetting/DtlImp.htm?FK_MapData=" + this.No + "&FromDtl=1&IsFirst=1&UserNo=" + BP.Web.WebUser.No + "&Token=" + Web.WebUser.SID + "&AppCenterDBType=" + DBAccess.AppCenterDBType + "&CustomerNo=" + BP.Difference.SystemConfig.CustomerNo;
            string url = "../../Admin/FoolFormDesigner/DtlSetting/DtlImp/Default.htm?FK_MapDtl=" + this.No + "&FromDtl=1";
            return url;
        }
        /// <summary>
        /// 列自动计算
        /// </summary>
        /// <returns></returns>
        public string ColAutoExp()
        {
            string url = "../../Admin/FoolFormDesigner/DtlSetting/ColAutoExp.htm?FK_MapData=" + this.No;
            return url;
        }
        /// <summary>
        /// 导入其他表字段
        /// </summary>
        /// <returns></returns>
        public string ImpFields()
        {

            //  http://localhost:18272/WF/Admin/FoolFormDesigner/ImpTableField.htm?FK_MapData=CCFrm_CZBankBXDtl1&reset=true
            string url = "../../Admin/FoolFormDesigner/ImpTableField.htm?FK_MapData=" + this.No + "&FromDtl=1&IsFirst=1&UserNo=" + BP.Web.WebUser.No + "&Token=" + Web.WebUser.Token + "&AppCenterDBType=" + DBAccess.AppCenterDBType + "&CustomerNo=" + BP.Difference.SystemConfig.CustomerNo;
            return url;
        }
        /// <summary>
        /// 设计傻瓜表单
        /// </summary>
        /// <returns></returns>
        public string DFoolFrm()
        {
            string url = "../../Admin/FoolFormDesigner/Designer.htm?FK_MapData=" + this.No + "&FromDtl=1&IsFirst=1&UserNo=" + BP.Web.WebUser.No + "&Token=" + Web.WebUser.Token + "&AppCenterDBType=" + DBAccess.AppCenterDBType + "&CustomerNo=" + BP.Difference.SystemConfig.CustomerNo;
            return url;
        }
        /// <summary>
        /// 多表头
        /// </summary>
        /// <returns></returns>
        public string DoMultiTitle()
        {
            return "../../Comm/Sys/MultiTitle.htm?EnsName=" + this.No + "&DoType=Dtl";
        }


        public string GenerAttrs()
        {
            string strs = "";
            MapAttrs attrs = new MapAttrs(this.No);
            foreach (MapAttr item in attrs)
            {
                strs += "\t\n " + item.KeyOfEn + ",";
            }
            return strs;
        }
        public string DoAction()
        {
            return "../../Admin/FoolFormDesigner/ActionForDtl.htm?DoType=Edit&FK_MapData=" + this.No + "&t=" + DataType.CurrentDateTime;
        }

        public string HidAttr()
        {
            return "../../Admin/FoolFormDesigner/HidAttr.htm?DoType=Edit&FK_MapData=" + this.No + "&t=" + DataType.CurrentDateTime;
        }

        #region 基本属性.
        
        public float H
        {
            get
            {
                return this.GetValFloatByKey(MapDtlAttr.H);
            }
        }
        public float FrmW
        {
            get
            {
                return this.GetValFloatByKey(MapDtlAttr.FrmW);
            }
        }
        public float FrmH
        {
            get
            {
                return this.GetValFloatByKey(MapDtlAttr.FrmH);
            }
        }
        #endregion 基本属性.


        /// <summary>
        /// 初始化自定义字段属性
        /// </summary>
        /// <returns>返回执行结果</returns>
        public string InitAttrsOfSelf()
        {
            if (this.NodeID == 0)
                return "err@该从表属性不是自定义属性.";

            if (this.No.Contains("_" + this.NodeID) == false)
                return "err@该从表属性不是自定义属性.";

            //求从表ID.
            string refDtl = this.No.Replace("_" + this.NodeID, "");

            //处理属性问题.
            MapAttrs attrs = new MapAttrs();
            attrs.Delete(MapAttrAttr.FK_MapData, this.No);
            attrs.Retrieve(MapAttrAttr.FK_MapData, refDtl);
            foreach (MapAttr attr in attrs)
            {
                string oldMyPK = attr.MyPK;
                attr.setMyPK(this.No + "_" + attr.KeyOfEn);
                attr.FrmID =this.No;
                attr.Insert();
                //存在字段附件
                if(attr.UIContralType == UIContralType.AthShow)
                {
                    BP.Sys.FrmAttachment athDesc = new BP.Sys.FrmAttachment(oldMyPK);
                    athDesc.MyPK = attr.MyPK;
                    athDesc.FrmID =this.No;
                    athDesc.NodeID = this.NodeID;
                    athDesc.DirectInsert();
                }
            }

            //处理mapExt 的问题.
            MapExts exts = new MapExts();
            exts.Delete(MapAttrAttr.FK_MapData, this.No);//先删除，后查询.
            exts.Retrieve(MapAttrAttr.FK_MapData, refDtl);
            MapExt mapExt = null;
            foreach (MapExt ext in exts)
            {
                mapExt = new MapExt();
                mapExt = ext;
                mapExt.setMyPK(ext.ExtType + "_" + this.No + "_" + ext.AttrOfOper);
                mapExt.FrmID =this.No;
                mapExt.Insert();
            }

            //处理附件问题
            /* 如果启用了多附件*/
            if (this.ItIsEnableAthM == true)
            {
                BP.Sys.FrmAttachment athDesc = new BP.Sys.FrmAttachment();
                //获取原始附件的属性

                athDesc.setMyPK(this.No + "_AthMDtl");
                if (athDesc.RetrieveFromDBSources() == 0)
                {
                    //获取原来附件的属性
                    BP.Sys.FrmAttachment oldAthDesc = new BP.Sys.FrmAttachment();
                    oldAthDesc.setMyPK(refDtl + "_AthMDtl");
                    if (oldAthDesc.RetrieveFromDBSources() == 0)
                        return "原始从表的附件属性不存在，请联系管理员";
                    athDesc = oldAthDesc;
                    athDesc.setMyPK(this.No + "_AthMDtl");
                    athDesc.FrmID =this.No;
                    athDesc.NoOfObj = "AthMDtl";
                    athDesc.Name = this.Name;
                    athDesc.ItIsVisable = false;
                    athDesc.DirectInsert();
                    //增加分组
                    GroupField group = new GroupField();
                    group.Lab = athDesc.Name;
                    group.FrmID = this.FrmID;
                    group.CtrlType = "Ath";
                    group.CtrlID = athDesc.MyPK;
                    group.Idx = 10;
                    group.Insert();
                }

                //判断是否有隐藏的AthNum 字段
                MapAttr attr = new MapAttr();
                attr.setMyPK(this.No + "_AthNum");
                int count = attr.RetrieveFromDBSources();
                if (count == 0)
                {
                    attr.FrmID =this.No;
                    attr.setKeyOfEn("AthNum");
                    attr.setName("附件数量");
                    attr.DefVal = "0";
                    attr.setUIContralType(UIContralType.TB);
                    attr.setMyDataType(DataType.AppInt);
                    attr.setUIVisible(false);
                    attr.setUIIsEnable(false);
                    attr.DirectInsert();
                }


            }

            return "执行成功";
        }

        protected override bool beforeUpdate()
        {
            MapDtl dtl = new MapDtl(this.No);
            //启用审核
            dtl.ItIsEnablePass = this.ItIsEnablePass;
            //超链接
            dtl.ItIsEnableLink = this.ItIsEnableLink;
            dtl.LinkLabel = this.LinkLabel;
            dtl.LinkUrl = this.LinkUrl;
            dtl.LinkTarget = this.LinkTarget;
            dtl.Update();

            //判断是否启用多附件
            if (this.ItIsEnableAthM == true)
            {
                BP.Sys.FrmAttachment athDesc = new BP.Sys.FrmAttachment();
                athDesc.setMyPK(this.No + "_AthMDtl");
                if (athDesc.RetrieveFromDBSources() == 0)
                {
                    athDesc.FrmID =this.No;
                    athDesc.NoOfObj = "AthMDtl";
                    athDesc.Name = this.Name;
                    athDesc.ItIsVisable = false;
                    athDesc.DirectInsert();
                    //增加分组
                    GroupField group = new GroupField();
                    group.Lab = athDesc.Name;
                    group.FrmID = this.No;
                    group.CtrlType = "Ath";
                    group.CtrlID = athDesc.MyPK;
                    group.Idx = 10;
                    group.Insert();
                }

                //判断是否有隐藏的AthNum 字段
                MapAttr attr = new MapAttr();
                attr.setMyPK(this.No + "_AthNum");
                int count = attr.RetrieveFromDBSources();
                if (count == 0)
                {
                    attr.FrmID =this.No;
                    attr.setKeyOfEn("AthNum");
                    attr.setName("附件数量");
                    attr.DefVal = "0";
                    attr.setUIContralType(UIContralType.TB);
                    attr.setMyDataType(DataType.AppInt);
                    attr.setUIVisible(false);
                    attr.setUIIsEnable(false);
                    attr.DirectInsert();
                    string a = "13";
                }
            }

            //获得事件实体.
            FormEventBaseDtl febd = BP.Sys.Base.Glo.GetFormDtlEventBaseByEnName(this.No);
            if (febd == null)
                this.FEBD = "";
            else
                this.FEBD = febd.ToString();


            #region 检查填充的SQL是否符合要求.
            #endregion

            //更新分组标签.  @fanleiwei. 代码有变化.
            BP.Sys.GroupField gf = new GroupField();
            int i = gf.Retrieve(GroupFieldAttr.CtrlType, "Dtl", GroupFieldAttr.CtrlID, this.No);
            if (i == 0 && this.NodeID == 0)
            {
                gf.CtrlID = this.No;
                gf.CtrlType = "Dtl";
                gf.FrmID = this.FrmID;
                gf.Insert();
            }

            if (i > 1)
            {
                gf.Delete();
                i = gf.Retrieve(GroupFieldAttr.CtrlType, "Dtl", GroupFieldAttr.CtrlID, this.No);
            }

            if (i == 1 && gf.Lab.Equals(this.Name) == false)
            {
                gf.Lab = this.Name;
                gf.Update();
            }

            return base.beforeUpdate();
        }

        protected override void afterDelete()
        {
            MapDtl dtl = new MapDtl();
            dtl.No = this.No;
            dtl.SetValByKey(MapDtlAttr.FK_MapData,this.FrmID);
            dtl.SetValByKey(MapDtlAttr.PTable, this.PTable);
            dtl.Delete();

            //删除分组
            GroupFields gfs = new GroupFields();
            gfs.RetrieveByLike(GroupFieldAttr.CtrlID, this.No + "%");
            gfs.Delete();

            
            FrmAttachment ath = new FrmAttachment();
            ath.Delete(FrmAttachmentAttr.FK_MapData, this.No);
           


            //执行清空缓存到的AutoNum.
            MapData md = new MapData(this.FrmID);
            md.ClearAutoNumCache(true); //更新缓存.

            base.afterDelete();
        }
        /// <summary>
        /// 获取个数
        /// </summary>
        /// <param name="fk_val"></param>
        /// <returns></returns>
        public int GetCountByFK(int workID)
        {
            return DBAccess.RunSQLReturnValInt("select COUNT(OID) from " + this.PTable + " WHERE WorkID=" + workID);
        }
        public int GetCountByFK(string field, string val)
        {
            return DBAccess.RunSQLReturnValInt("select COUNT(OID) from " + this.PTable + " WHERE " + field + "='" + val + "'");
        }
        public int GetCountByFK(string field, Int64 val)
        {
            return DBAccess.RunSQLReturnValInt("select COUNT(OID) from " + this.PTable + " WHERE " + field + "=" + val);
        }
        public int GetCountByFK(string f1, Int64 val1, string f2, string val2)
        {
            return DBAccess.RunSQLReturnValInt("SELECT COUNT(OID) from " + this.PTable + " WHERE " + f1 + "=" + val1 + " AND " + f2 + "='" + val2 + "'");
        }
        #endregion

    }
    /// <summary>
    /// 明细s
    /// </summary>
    public class MapDtlExts : EntitiesNoName
    {
        #region 构造
        /// <summary>
        /// 明细s
        /// </summary>
        public MapDtlExts()
        {
        }
        /// <summary>
        /// 明细s
        /// </summary>
        /// <param name="fk_mapdata">s</param>
        public MapDtlExts(string fk_mapdata)
        {
            this.Retrieve(MapDtlAttr.FK_MapData, fk_mapdata, MapDtlAttr.FK_Node, 0, MapDtlAttr.No);
        }
        /// <summary>
        /// 得到它的 Entity
        /// </summary>
        public override Entity GetNewEntity
        {
            get
            {
                return new MapDtlExt();
            }
        }

        #endregion

        #region 为了适应自动翻译成java的需要,把实体转换成List.
        /// <summary>
        /// 转化成 java list,C#不能调用.
        /// </summary>
        /// <returns>List</returns>
        public System.Collections.Generic.IList<MapDtlExt> ToJavaList()
        {
            return (System.Collections.Generic.IList<MapDtlExt>)this;
        }
        /// <summary>
        /// 转化成list
        /// </summary>
        /// <returns>List</returns>
        public System.Collections.Generic.List<MapDtlExt> Tolist()
        {
            System.Collections.Generic.List<MapDtlExt> list = new System.Collections.Generic.List<MapDtlExt>();
            for (int i = 0; i < this.Count; i++)
            {
                list.Add((MapDtlExt)this[i]);
            }
            return list;
        }
        #endregion 为了适应自动翻译成java的需要,把实体转换成List.
    }
}