public virtual DockStructInitClass GetTableName(string funId) { var dockBTYZTBHStructInitClass = new DockStructInitClass(); switch (funId) { case "702": dockBTYZTBHStructInitClass = new DockStructInitClass("HPF_BTYZTBH_BHDCJCGZQKJLB", "HPF_BTYZTBH_BHDCJCGZQKJLFJ", "JLID"); break; case "70301": dockBTYZTBHStructInitClass = new DockStructInitClass("HPF_BTYZTBH_LF", "HPF_BTYZTBH_LFJL", "LFID", "HPF_BTYZTBH_LFZP", "JLID"); //裂缝_文档类 break; case "70303": dockBTYZTBHStructInitClass = new DockStructInitClass("HPF_BTYZTBH_CJ", "HPF_BTYZTBH_CJJL", "CJID", "HPF_BTYZTBH_CJZP", "CJJLID"); //沉降_文档类 break; case "70304": dockBTYZTBHStructInitClass = new DockStructInitClass("HPF_BTYZTBH_SPWY", "HPF_BTYZTBH_SPWYJL", "SPWYID", "HPF_BTYZTBH_SPWYZP", "JLID"); //变形 break; case "70307": dockBTYZTBHStructInitClass = new DockStructInitClass("HPF_BTYZTBH_ZX", "HPF_BTYZTBH_ZXJL", "ZXID", "HPF_BTYZTBH_ZXZP", "ZXJLID"); //糟朽 break; case "70308": dockBTYZTBHStructInitClass = new DockStructInitClass("HPF_BTYZTBH_BY", "HPF_BTYZTBH_BYJL", "BYID", "HPF_BTYZTBH_BYZP", "BYJLID"); //白蚁 break; case "70309": dockBTYZTBHStructInitClass = new DockStructInitClass("HPF_BTYZTBH_GJXS", "HPF_BTYZTBH_GJXSJL", "XSID", "HPF_BTYZTBH_GJXSZP", "XSJLID"); //钢筋锈蚀 break; case "70310": dockBTYZTBHStructInitClass = new DockStructInitClass("HPF_BTYZTBH_ZW", "HPF_BTYZTBH_ZWJL", "ZWID", "HPF_BTYZTBH_ZWZP", "ZWJLID"); //植物根系 break; case "70311": dockBTYZTBHStructInitClass = new DockStructInitClass("HPF_BTYZTBH_SL", "HPF_BTYZTBH_SLJL", "SLID", "HPF_BTYZTBH_SLZP", "SLJLID"); //渗漏水 break; case "70312": dockBTYZTBHStructInitClass = new DockStructInitClass("HPF_BTYZTBH_TL", "HPF_BTYZTBH_TLJL", "TLID", "HPF_BTYZTBH_TLZP", "TLJLID"); //脱落 break; } return(dockBTYZTBHStructInitClass); }
public DockStructInitClass GetTableName(string funId) { var dockJGJSStructInitClass = new DockStructInitClass(); switch (funId) { case "20101": //保护管理机构 dockJGJSStructInitClass = new DockStructInitClass("HPF_JGJS_BHGLJG", "HPF_JGJS_GLQYT", "BHGLJGID"); break; default: //专项保护管理法规、规章 安防消防-管理制度和应急预案记录 dockJGJSStructInitClass = new DockStructInitClass("HPF_JGJS_ZXBHGLFGGZ", "HPF_JGJS_ZXFGXGWD", "FGID"); break; } return(dockJGJSStructInitClass); }
/// <summary> /// 获取自定义结构的方法 /// </summary> /// <param name="funId">业务功能ID</param> /// <returns>返回自定义结构的对象</returns> public virtual DockStructInitClass GetTableName(string funId) { var dockYcysdtjcesj = new DockStructInitClass(); switch (funId) { case "601": dockYcysdtjcesj = new DockStructInitClass("HPF_YCJCXX_YCYSDTHJBCHJZT", "HPF_YCYSDT_YCYSDTHJBXZT", "YCYSDTHJBCHJZTID"); break; case "602": dockYcysdtjcesj = new DockStructInitClass("HPF_YCJCXX_YCYSDTHJBTP", "HPF_YCYSDT_YCYSDTHJBTP", "YCYSDTHJBTPID"); break; } return(dockYcysdtjcesj); }
public DockStructInitClass GetTableName(string funId) { var dockJGJSStructInitClass = new DockStructInitClass("HPF_BHGH_BHGLGH", "HPF_BHGH_BHGLGH_XGWD", "BHGLGHID"); return(dockJGJSStructInitClass); }
public override string ReceiveData() { var dockBHGLGHStructInitClass = new DockStructInitClass("HPF_BHGH_BHGLGH_XXZXQKJL", "HPF_BHGH_XXGHZXQKZHPJ", "BHGLGHID"); //根据传入两个表名来获取对应的数据结构模型的类型 var eType = MethodHelper.GetTypeList(dockBHGLGHStructInitClass.MainTableName, dockBHGLGHStructInitClass.SubordinateTableName); //将Json串按指定的类型进行反序列化为dynamic实体对象 var ent = JsonHelper.DeserializeJsonToDynamicObject(this.BusinessJsonStr, eType); var entZXQKJLList = ent.DATA as IList; var entZHPJList = ent.DATADETAIL as IList; var entPathList = ent.FILEPATHLIST as List <FileInfoEx>;/// var listSqlStr = new List <string>(); var listYSJID = new List <string>(); var dicOldToNew = new Dictionary <string, Guid>(); var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } //主表 foreach (var item in entZXQKJLList) { var nameToValue = item.GetNameToValueDic(); if (!nameToValue.ContainsKey("YCDSJID")) { return(JsonHelper.SerializeObject(new ResultModel(false, "元数据ID不存在,对接失败!"))); } if (nameToValue.ContainsKey("BHGLGHID")) { string newBhglghid; var bIsExistBHBH = GetBHGLGHIDByOldDataID(dbContext, nameToValue["BHGLGHID"] + "", out newBhglghid); if (!bIsExistBHBH) { return(JsonHelper.SerializeObject(new ResultModel(false, "请先对接保护管理规划!"))); } nameToValue["BHGLGHID"] = newBhglghid; } var ysjid = nameToValue["YCDSJID"] + "";//元数据ID var guid = Guid.NewGuid(); dicOldToNew.Add(ysjid, guid); if (nameToValue.ContainsKey("GLYCBTID")) { nameToValue["GLYCBTID"] = HeritageId; } if (nameToValue.ContainsKey("ID")) {//把ID字段赋一个guid nameToValue["ID"] = guid; } else {//没有的增加 nameToValue.Add("ID", guid); } if (!string.IsNullOrEmpty(ysjid)) //有可能对接过来就是 统计过得数据 例如景点日游客量 { listYSJID.Add(ysjid); //防止重复对接 } listSqlStr.Add(dbContext.insertByParamsReturnSQL(dockBHGLGHStructInitClass.MainTableName, nameToValue)); } //明细 //var dicFileRelatedID = new Dictionary<string, Guid>(); foreach (var item in entZHPJList) { var nameToValue = item.GetNameToValueDic(); if (!nameToValue.ContainsKey("YCDSJID")) { return(JsonHelper.SerializeObject(new ResultModel(false, "元数据ID不存在,对接失败!"))); } var ysjid = nameToValue["YCDSJID"] + ""; var guid = Guid.NewGuid(); if (nameToValue.ContainsKey("GLYCBTID")) { nameToValue["GLYCBTID"] = HeritageId; } if (nameToValue.ContainsKey("ID")) { nameToValue["ID"] = guid; } else { nameToValue.Add("ID", guid); } //将裂缝的ID值赋给裂缝记录表中的裂缝ID字段 //nameToValue[dockBHGLGHStructInitClass.RelatedID] = dicOldToNew[ysjid]; //dicFileRelatedID.Add(ysjid, guid); listSqlStr.Add(dbContext.insertByParamsReturnSQL(dockBHGLGHStructInitClass.SubordinateTableName, nameToValue)); } if (!CheckIsDock(listSqlStr, listYSJID, dockBHGLGHStructInitClass.MainTableName, dbContext)) { return(JsonHelper.SerializeObject(new ResultModel(false, "已经存在对接的数据"))); } return(GetExeListSQL(dbContext, listSqlStr)); }