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));
}
