public override string ReceiveData()
{
var funModel = this.FindFunModel(HeritageId, FunId);
if (funModel == null)
{
return(JsonHelper.SerializeObject(new ResultModel(false, "找不到该功能对应的配置信息")));
}
//通过xml配置的表名 找到类的路径 反射成 list类 对象
var cListType = MethodHelper.GetTypeListFileEx(GetModelName(funModel.TableName));//GCHeritagePlatform.Services.PublicMornitor.Model.HPF_RCXC_RCXCYCJL;
var ent = JsonHelper.DeserializeJsonToObject <ResultBHGC_XCZPDockModel>(BusinessJsonStr);
var dbContext = DBHelperPool.Instance.GetDbHelper();
if (dbContext == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var listSqlStr = new List <string>();
var listYSJID = new List <string>();
foreach (var item in ent.DATA)
{
var nameToValue = item.GetNameToValueDic();
if (nameToValue.ContainsKey("GLYCBTID"))
{
nameToValue["GLYCBTID"] = HeritageId;
}
if (nameToValue.ContainsKey("ID"))
{
nameToValue["ID"] = Guid.NewGuid();
}
else
{
nameToValue.Add("ID", Guid.NewGuid());
}
//保护工程和对接数据有关联
var strSql = string.Format("select ID from HPF_BHGC where YCDSJID='{0}' and GLYCBTID='{1}' ", nameToValue["GCXMID"], HeritageId);
var dtMain = dbContext.getDataTableResult(strSql);
if (dtMain == null || dtMain.Rows.Count == 0)
{
return(JsonHelper.SerializeObject(new ResultModel(false, "请先对接【保护展示与环境整治工程记录数据】！")));
}
//如果有改变PID的属性信息
nameToValue["GCXMID"] = dtMain.Rows[0][0].ToString();
var yscid = nameToValue["YCDSJID"] + "";
listYSJID.Add(yscid);
foreach (var fitem in ent.FILEPATHLIST)
{
var fnameToValue = fitem.GetNameToValueDic();
if (fnameToValue.ContainsKey("YCDSJID") == nameToValue.ContainsKey("YCDSJID"))
{
FileInfoEx ReceiveFileInfo = CommonBusiness.GetFileNameByFileID(fnameToValue["FILEID"] as string);
switch (FunId)
{
case "150103": //工程方案的文档
{
if (nameToValue.ContainsKey("WDMC"))
{
nameToValue["WDMC"] = ReceiveFileInfo.FILENAME;
}
else
{
nameToValue.Add("WDMC", ReceiveFileInfo.FILENAME);
}
if (nameToValue.ContainsKey("LJ"))
{
nameToValue["LJ"] = ReceiveFileInfo.RELATIVEPATH;
}
else
{
nameToValue.Add("LJ", ReceiveFileInfo.RELATIVEPATH);
}
if (nameToValue.ContainsKey("WDLX"))
{
nameToValue["WDLX"] = ReceiveFileInfo.FILETYPE;
}
else
{
nameToValue.Add("WDLX", ReceiveFileInfo.FILETYPE);
}
}
break;
case "1503": //保护展示的现场照片
{
if (nameToValue.ContainsKey("TPMC"))
{
nameToValue["TPMC"] = ReceiveFileInfo.FILENAME;
}
else
{
nameToValue.Add("TPMC", ReceiveFileInfo.FILENAME);
}
if (nameToValue.ContainsKey("TPLJ"))
{
nameToValue["TPLJ"] = ReceiveFileInfo.RELATIVEPATH;
}
else
{
nameToValue.Add("TPLJ", ReceiveFileInfo.RELATIVEPATH);
}
if (nameToValue.ContainsKey("TPGS"))
{
nameToValue["TPGS"] = ReceiveFileInfo.FILETYPE;
}
else
{
nameToValue.Add("TPGS", ReceiveFileInfo.FILETYPE);
}
}
break;
}
listSqlStr.Add(dbContext.insertByParamsReturnSQL(GetModelName(funModel.TableName), nameToValue));
}
}
}
if (!CheckIsDock(listSqlStr, listYSJID, funModel.TableName, dbContext))
{
return(JsonHelper.SerializeObject(new ResultModel(false, "已经存在对接的数据")));
}
return(GetExeListSQL(dbContext, listSqlStr));
}
public override string ReceiveData()
{
var heritageId = this.HeritageId;
var funId = this.FunId;
var jsonStr = this.BusinessJsonStr;
try
{
var xmlConfig = CommonBusiness.GetMornitorConfig(heritageId);
var funList = xmlConfig.GetFunctionalModules();
var ent = JsonHelper.DeserializeJsonToObject <ResultYCYSDT2DockModel>(jsonStr);
var dbContext = DBHelperPool.Instance.GetDbHelper();
var funModel = funList.FirstOrDefault(e => e.ID == funId);
var listSqlStr = new List <string>();
var listYSJID = new List <string>();
foreach (var item in ent.DATA)
{
var nameToValue = item.GetNameToValueDic();
if (nameToValue.ContainsKey("GLYCBTID"))
{
nameToValue["GLYCBTID"] = heritageId;
}
if (nameToValue.ContainsKey("ID"))
{
nameToValue["ID"] = Guid.NewGuid();
}
else
{
nameToValue.Add("ID", Guid.NewGuid());
}
var yscid = nameToValue["YCDSJID"] + "";
listYSJID.Add(yscid);
foreach (var fitem in ent.FILEPATHLIST)
{
var fnameToValue = fitem.GetNameToValueDic();
if (fnameToValue.ContainsKey("YCDSJID") == nameToValue.ContainsKey("YCDSJID"))
{
FileInfoEx ReceiveFileInfo = CommonBusiness.GetFileNameByFileID(fnameToValue["FileID"] as string);
if (!string.IsNullOrEmpty(yscid))//有可能对接过来就是 统计过得数据 例如景点日游客量
{
}
}
}
////if (nameToValue.ContainsKey("TPMC"))
////{
//// nameToValue["TPMC"] = ReceiveFileInfo.FILENAME;
////}
////else
////{
//// nameToValue.Add("TPMC", ReceiveFileInfo.FILENAME);
////}
//if (nameToValue.ContainsKey("TPLJ"))
//{
// nameToValue["TPLJ"] = ReceiveFileInfo.RELATIVEPATH;
//}
//else
//{
// nameToValue.Add("TPLJ", ReceiveFileInfo.RELATIVEPATH);
//}
//if (nameToValue.ContainsKey("TPLX"))
//{
// nameToValue["TPLX"] = ReceiveFileInfo.FILETYPE;
//}
//else
//{
// nameToValue.Add("TPLX", ReceiveFileInfo.FILETYPE);
//}
listSqlStr.Add(dbContext.insertByParamsReturnSQL(funModel.TableName, nameToValue));
// }
//}
//}
//listSqlStr.Add(dbContext.insertByParamsReturnSQL(funModel.TableName, nameToValue)); //HPF_YSDT_YCYSDTHJBCHTJLB
}
if (!CheckIsDock(listSqlStr, listYSJID, funModel.TableName, dbContext))
{
return(JsonHelper.SerializeObject(new ResultModel(false, "已经存在对接的数据")));
}
else
{
if (dbContext.executeTransactionSQLList(listSqlStr))
{
return(JsonHelper.SerializeObject(new ResultModel(true, "对接成功")));
}
else
{
return(JsonHelper.SerializeObject(new ResultModel(false, "对接失败")));
}
}
}
catch (Exception ex)
{
var strErr = string.Format("遗产地对接数据类【遗产要素单体或局部影像及遗产要素现状记录】数据错误,参数：{0}#{1}#{2},具体错误：{3}", jsonStr, funId, heritageId, ex.Message);
SystemLogger.getLogger().Error(strErr);
return(JsonHelper.SerializeObject(new ResultModel(false, ex.Message)));
}
}
public override string ReceiveData()
{
var funModel = FindFunModel(HeritageId, FunId);
var dbContext = DBHelperPool.Instance.GetDbHelper();
var ent = JsonHelper.DeserializeJsonToObject <ResultYCYSDT1DockModel>(BusinessJsonStr);
var listSqlStr = new List <string>();
var listYSJID = new List <string>();
foreach (var item in ent.DATA)
{
var nameToValue = item.GetNameToValueDic();
if (nameToValue.ContainsKey("GLYCBTID"))
{
nameToValue["GLYCBTID"] = HeritageId;
}
if (nameToValue.ContainsKey("ID"))
{
nameToValue["ID"] = Guid.NewGuid();
}
else
{
nameToValue.Add("ID", Guid.NewGuid());
}
var yscid = nameToValue["YCDSJID"] + "";
if (!string.IsNullOrEmpty(yscid)) //有可能对接过来就是 统计过得数据 例如景点日游客量
{
listYSJID.Add(yscid);
foreach (var fitem in ent.FILEPATHLIST)
{
var fnameToValue = fitem.GetNameToValueDic();
if (fnameToValue.ContainsKey("YCDSJID") == nameToValue.ContainsKey("YCDSJID"))
{
FileInfoEx ReceiveFileInfo = CommonBusiness.GetFileNameByFileID(fnameToValue["FileID"] as string);
if (nameToValue.ContainsKey("TZMC"))
{
nameToValue["TZMC"] = ReceiveFileInfo.FILENAME;
}
else
{
nameToValue.Add("TZMC", ReceiveFileInfo.FILENAME);
}
if (nameToValue.ContainsKey("TZLJ"))
{
nameToValue["TZLJ"] = ReceiveFileInfo.RELATIVEPATH;
}
else
{
nameToValue.Add("TZLJ", ReceiveFileInfo.RELATIVEPATH);
}
if (nameToValue.ContainsKey("TZLX"))
{
nameToValue["TZLX"] = ReceiveFileInfo.FILETYPE;
}
else
{
nameToValue.Add("TZLX", ReceiveFileInfo.FILETYPE);
}
listSqlStr.Add(dbContext.insertByParamsReturnSQL(funModel.TableName, nameToValue));
}
}
}
}
if (!CheckIsDock(listSqlStr, listYSJID, funModel.TableName, dbContext))
{
return(JsonHelper.SerializeObject(new ResultModel(false, "已经存在对接的数据")));
}
return(GetExeListSQL(dbContext, listSqlStr));
}