using System; using BP.DA; using BP.En; using BP.Sys; namespace BP.WF.Template.Frm { /// /// 明细 /// public class MapDtlExt : EntityNoName { #region 导入导出属性. /// /// 用户访问. /// 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; } } /// /// 是否可以导出 /// public bool IsImp { get { return this.GetValBooleanByKey(MapDtlAttr.IsImp); } set { this.SetValByKey(MapDtlAttr.IsImp, value); } } /// /// 是否可以导入 /// public bool IsExp { get { return this.GetValBooleanByKey(MapDtlAttr.IsExp); } set { this.SetValByKey(MapDtlAttr.IsExp, value); } } /// /// 查询sql /// public string ImpSQLInit { get { return this.GetValStringByKey(MapDtlAttr.ImpSQLInit).Replace("~", "'"); } set { this.SetValByKey(MapDtlAttr.ImpSQLInit, value); } } /// /// 搜索sql /// public string ImpSQLSearch { get { return this.GetValStringByKey(MapDtlAttr.ImpSQLSearch).Replace("~", "'"); } set { this.SetValByKey(MapDtlAttr.ImpSQLSearch, value); } } /// /// 填充数据一行数据 /// public string ImpSQLFullOneRow { get { return this.GetValStringByKey(MapDtlAttr.ImpSQLFullOneRow).Replace("~", "'"); } set { this.SetValByKey(MapDtlAttr.ImpSQLFullOneRow, value); } } #endregion #region 基本设置 /// /// 工作模式 /// public DtlModel DtlModel { get { return (DtlModel)this.GetValIntByKey(MapDtlAttr.Model); } set { this.SetValByKey(MapDtlAttr.Model, (int)value); } } /// /// 是否启用行锁定. /// public bool IsRowLock { get { return this.GetParaBoolen(MapDtlAttr.IsRowLock, false); } set { this.SetPara(MapDtlAttr.IsRowLock, value); } } #endregion 基本设置 #region 参数属性 /// /// 记录增加模式 /// public DtlAddRecModel DtlAddRecModel { get { return (DtlAddRecModel)this.GetParaInt(MapDtlAttr.DtlAddRecModel); } set { this.SetPara(MapDtlAttr.DtlAddRecModel, (int)value); } } /// /// 保存方式 /// public DtlSaveModel DtlSaveModel { get { return (DtlSaveModel)this.GetParaInt(MapDtlAttr.DtlSaveModel); } set { this.SetPara(MapDtlAttr.DtlSaveModel, (int)value); } } /// /// 是否启用Link,在记录的右边. /// public bool IsEnableLink { 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); } } /// /// 子线程处理人字段(用于分流节点的明细表分配子线程任务). /// public string SubThreadWorker { get { string s = this.GetParaString(MapDtlAttr.SubThreadWorker); if (DataType.IsNullOrEmpty(s)) return ""; return s; } set { this.SetPara(MapDtlAttr.SubThreadWorker, value); } } /// /// 子线程分组字段(用于分流节点的明细表分配子线程任务) /// public string SubThreadGroupMark { get { string s = this.GetParaString(MapDtlAttr.SubThreadGroupMark); if (DataType.IsNullOrEmpty(s)) return ""; return s; } set { this.SetPara(MapDtlAttr.SubThreadGroupMark, value); } } /// /// 节点ID /// public int FK_Node { get { return this.GetValIntByKey(MapDtlAttr.FK_Node); } set { this.SetValByKey(MapDtlAttr.FK_Node, value); } } #endregion 参数属性 #region 外键属性 /// /// 框架 /// 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; } } /// /// 分组字段 /// 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; } } /// /// 逻辑扩展 /// 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; } } /// /// 事件 /// 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; } } /// /// 从表 /// 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; } } /// /// 图片 /// 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; } } /// /// 附件 /// 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; } } /// /// 图片附件 /// 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; } } /// /// 单选按钮 /// 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; } } /// /// 属性 /// 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; /// /// 是否显示数量 /// public bool IsShowSum { get { return this.GetValBooleanByKey(MapDtlAttr.IsShowSum); } set { this.SetValByKey(MapDtlAttr.IsShowSum, value); } } /// /// 是否显示Idx /// public bool IsShowIdx { get { return this.GetValBooleanByKey(MapDtlAttr.IsShowIdx); } set { this.SetValByKey(MapDtlAttr.IsShowIdx, value); } } /// /// 是否显示标题 /// public bool IsShowTitle { get { return this.GetValBooleanByKey(MapDtlAttr.IsShowTitle); } set { this.SetValByKey(MapDtlAttr.IsShowTitle, value); } } /// /// 是否是合流汇总数据 /// public bool IsHLDtl { get { return this.GetValBooleanByKey(MapDtlAttr.IsHLDtl); } set { this.SetValByKey(MapDtlAttr.IsHLDtl, value); } } /// /// 是否是分流 /// public bool IsFLDtl { get { return this.GetParaBoolen(MapDtlAttr.IsFLDtl); } set { this.SetPara(MapDtlAttr.IsFLDtl, value); } } public int _IsReadonly = 2; public bool IsReadonly { get { if (_IsReadonly != 2) { if (_IsReadonly == 1) return true; else return false; } if (this.IsDelete || this.IsInsert || this.IsUpdate) { _IsReadonly = 0; return false; } _IsReadonly = 1; return true; } } /// /// 是否可以删除? /// public bool IsDelete { get { return this.GetValBooleanByKey(MapDtlAttr.IsDelete); } set { this.SetValByKey(MapDtlAttr.IsDelete, value); } } /// /// 是否可以新增? /// public bool IsInsert { get { return this.GetValBooleanByKey(MapDtlAttr.IsInsert); } set { this.SetValByKey(MapDtlAttr.IsInsert, value); } } /// /// 是否可见 /// public bool IsView { get { return this.GetValBooleanByKey(MapDtlAttr.IsView); } set { this.SetValByKey(MapDtlAttr.IsView, value); } } /// /// 是否可以更新? /// public bool IsUpdate { get { return this.GetValBooleanByKey(MapDtlAttr.IsUpdate); } set { this.SetValByKey(MapDtlAttr.IsUpdate, value); } } /// /// 是否启用多附件 /// public bool IsEnableAthM { get { return this.GetValBooleanByKey(MapDtlAttr.IsEnableAthM); } set { this.SetValByKey(MapDtlAttr.IsEnableAthM, value); } } /// /// 是否启用分组字段 /// public bool IsEnableGroupField { get { return this.GetValBooleanByKey(MapDtlAttr.IsEnableGroupField); } set { this.SetValByKey(MapDtlAttr.IsEnableGroupField, value); } } /// /// 是否起用审核连接 /// public bool IsEnablePass { get { return this.GetValBooleanByKey(MapDtlAttr.IsEnablePass); } set { this.SetValByKey(MapDtlAttr.IsEnablePass, value); } } /// /// 是否copy数据? /// public bool IsCopyNDData { get { return this.GetValBooleanByKey(MapDtlAttr.IsCopyNDData); } set { this.SetValByKey(MapDtlAttr.IsCopyNDData, value); } } /// /// 是否启用一对多多 /// public bool IsUse = false; /// /// 是否检查人员的权限 /// public DtlOpenType DtlOpenType { get { return (DtlOpenType)this.GetValIntByKey(MapDtlAttr.DtlOpenType); } set { this.SetValByKey(MapDtlAttr.DtlOpenType, (int)value); } } /// /// 分组字段 /// public string GroupField { get { return this.GetValStrByKey(MapDtlAttr.GroupField); } set { this.SetValByKey(MapDtlAttr.GroupField, value); } } /// /// 表单ID /// public string FK_MapData { get { return this.GetValStrByKey(MapDtlAttr.FK_MapData); } } /// /// 事件类. /// public string FEBD { get { return this.GetValStrByKey(MapDtlAttr.FEBD); } set { this.SetValByKey(MapDtlAttr.FEBD, value); } } /// /// 数量 /// public int RowsOfList { get { //如果不可以插入,就让其返回0. if (this.IsInsert == false) return 0; return this.GetValIntByKey(MapDtlAttr.RowsOfList); } set { this.SetValByKey(MapDtlAttr.RowsOfList, value); } } /// /// 物理表 /// 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); } } /// /// 多表头 /// //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 构造方法 /// /// 明细 /// public MapDtlExt() { } public MapDtlExt(string mypk) { this.No = mypk; this._IsReadonly = 2; this.Retrieve(); } /// /// EnMap /// 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, 6, "初始化行数", 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); #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.FK_MapData); base.afterInsertUpdateAction(); } /// /// 导入其他从表字段 /// /// 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.setFK_MapData(this.FK_MapData); //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.setFK_MapData(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.setFK_MapData(this.No); item.Save(); } return "导入成功."; } /// /// 打开从表附件属性. /// /// 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; } /// /// 导入 /// /// 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; } /// /// 导入V2019 /// /// 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; } /// /// 列自动计算 /// /// public string ColAutoExp() { string url = "../../Admin/FoolFormDesigner/DtlSetting/ColAutoExp.htm?FK_MapData=" + this.No; return url; } /// /// 导入其他表字段 /// /// 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; } /// /// 设计傻瓜表单 /// /// 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; } /// /// 多表头 /// /// 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 基本属性. /// /// 初始化自定义字段属性 /// /// 返回执行结果 public string InitAttrsOfSelf() { if (this.FK_Node == 0) return "err@该从表属性不是自定义属性."; if (this.No.Contains("_" + this.FK_Node) == false) return "err@该从表属性不是自定义属性."; //求从表ID. string refDtl = this.No.Replace("_" + this.FK_Node, ""); //处理属性问题. 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.setFK_MapData(this.No); attr.Insert(); //存在字段附件 if(attr.UIContralType == UIContralType.AthShow) { BP.Sys.FrmAttachment athDesc = new BP.Sys.FrmAttachment(oldMyPK); athDesc.MyPK = attr.MyPK; athDesc.setFK_MapData(this.No); athDesc.FK_Node = this.FK_Node; 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.setFK_MapData(this.No); mapExt.Insert(); } //处理附件问题 /* 如果启用了多附件*/ if (this.IsEnableAthM == 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.setFK_MapData(this.No); athDesc.NoOfObj = "AthMDtl"; athDesc.Name = this.Name; athDesc.IsVisable = false; athDesc.DirectInsert(); //增加分组 GroupField group = new GroupField(); group.Lab = athDesc.Name; group.FrmID = this.FK_MapData; 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.setFK_MapData(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.IsEnablePass = this.IsEnablePass; //超链接 dtl.IsEnableLink = this.IsEnableLink; dtl.LinkLabel = this.LinkLabel; dtl.LinkUrl = this.LinkUrl; dtl.LinkTarget = this.LinkTarget; dtl.Update(); //判断是否启用多附件 if (this.IsEnableAthM == true) { BP.Sys.FrmAttachment athDesc = new BP.Sys.FrmAttachment(); athDesc.setMyPK(this.No + "_AthMDtl"); if (athDesc.RetrieveFromDBSources() == 0) { athDesc.setFK_MapData(this.No); athDesc.NoOfObj = "AthMDtl"; athDesc.Name = this.Name; athDesc.IsVisable = 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.setFK_MapData(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"; } } //获得事件实体. var 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.FK_Node == 0) { gf.CtrlID = this.No; gf.CtrlType = "Dtl"; gf.FrmID = this.FK_MapData; 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.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.FK_MapData); md.ClearAutoNumCash(true); //更新缓存. base.afterDelete(); } /// /// 获取个数 /// /// /// 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 } /// /// 明细s /// public class MapDtlExts : EntitiesNoName { #region 构造 /// /// 明细s /// public MapDtlExts() { } /// /// 明细s /// /// s public MapDtlExts(string fk_mapdata) { this.Retrieve(MapDtlAttr.FK_MapData, fk_mapdata, MapDtlAttr.FK_Node, 0, MapDtlAttr.No); } /// /// 得到它的 Entity /// public override Entity GetNewEntity { get { return new MapDtlExt(); } } #endregion #region 为了适应自动翻译成java的需要,把实体转换成List. /// /// 转化成 java list,C#不能调用. /// /// List public System.Collections.Generic.IList ToJavaList() { return (System.Collections.Generic.IList)this; } /// /// 转化成list /// /// List public System.Collections.Generic.List Tolist() { System.Collections.Generic.List list = new System.Collections.Generic.List(); for (int i = 0; i < this.Count; i++) { list.Add((MapDtlExt)this[i]); } return list; } #endregion 为了适应自动翻译成java的需要,把实体转换成List. } }