public string GetUserList(string keywords, int page, int num) { var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var sql = @" select a.*,c.Name as POSITIONNAME,b.ROLENAME as LEADERName,d.NAME as DEPARTMENTName from PRIVS_USER a left join PRIVS_DEPARTMENT d on a.DEPARTMENTID=d.id left join PRIVS_LEADER b on a.ID=b.USERID left join PRIVS_POSITION c on a.POSITIONID=c.ID where 1=1 "; var sqlstringbuilder = new StringBuilder(sql); if (!string.IsNullOrEmpty(keywords)) { sqlstringbuilder.AppendFormat(" and( a.REALNAME like '%{0}%' or a.NAME like '%{0}%' or b.ROLENAME like '%{0}%' or d.NAME like '%{0}%' and c.Name LIKE '%{0}%')", keywords); } sqlstringbuilder.AppendFormat(" order by CJSJ desc"); var busness = new CommonBaseBusiness(); var pageModel = busness.Select(sqlstringbuilder.ToString(), (page - 1) * num, num); return(JsonHelper.SerializeObject(pageModel)); }
public virtual string SelectByWhere(string cols, string where, string orderBy, int pageSize, int pageIndex, bool bReturnSum) { var sqlTemplate = "select {0} from {1} where 1=1 {2} {3} limit {4},{5}"; var whereStr = string.IsNullOrEmpty(where) ? "" : where; //需要加入遗产地的默认条件 var orderByStr = string.IsNullOrEmpty(orderBy) ? "" : " order by " + orderBy; pageIndex = pageIndex <= 0 ? 1 : pageIndex; var limit = (pageIndex - 1) * pageSize; var sql = string.Format(sqlTemplate, string.IsNullOrEmpty(cols) ? "*" : cols, TableName, whereStr, orderByStr, limit, pageSize); var context = DBHelperPool.Instance.GetDbHelper(); if (context == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } DataTable datatable = context.getDataTableResult(sql); if (!bReturnSum) { return(JsonHelper.SerializeObject(ToolResult.Success(datatable))); } var sqlSum = $"select count(*) from {GetModelName(TableName)} where 1=1 {whereStr} {orderByStr}"; int count = 0; int.TryParse(context.executeScalar(sqlSum).ToString(), out count); return(JsonHelper.SerializeObject(ToolResult.Success(new { data = datatable, sum = count }))); }
public string GetFuncTree(string funID, string userID) { var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var sql = $@"select distinct b.NAME,b.ID,b.PID,ARGS from PRIVS_ROLE_FUNCPRIVS a left join PRIVS_FUNCPRIVS b on a.PRIVSID = b.id where a.roleID in ( select ifnull(RoleID,'-1') from PRIVS_USER_ROLE where UserID='{userID}') and ID is not null order by b.INDEXOFORDER"; var dt = dbContext.getDataTableResult(sql); if (dt == null || dt.Rows.Count == 0) { return(JsonHelper.SerializeObject(dt)); } var entList = dt.ToEntList <FuncTree>(); var el = entList.Where(e => e.ID == funID).ToList(); foreach (var item in el) { GetFunC(entList, item); } return(JsonHelper.SerializeObject(el)); }
public string VerifyBaseData(string jsonStr, string funId, string heritageId) { //判断传过来的json是否为空 if (string.IsNullOrEmpty(jsonStr) || jsonStr.Length < 10) { return(JsonHelper.SerializeObject(ToolResult.Failure("传输字符串为空,不能对接!"))); } //funid 找不到 返回错 return(""); }
public virtual string GetDetailByMainID(string mainId) { string sql = $"select * from {TableName} where id='{mainId}'"; var context = DBHelperPool.Instance.GetDbHelper(); if (context == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var datatable = context.getDataTableResult(sql); return(JsonHelper.SerializeObject(ToolResult.Success(datatable))); }
public string GetRoleInfo(string id) { var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var sql = $"select * from PRIVS_ROLE where ID = '{id}'"; var dt = dbContext.getDataTableResult(sql); return(JsonHelper.SerializeObject(dt)); }
public string CheckLoginName(string name) { var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var sql = $@"SELECT * from PRIVS_USER where NAME= '{name}'"; var bIsSuccess = (dbContext.getDataTableResult(sql) ?? new DataTable()).Rows.Count > 0; return(JsonHelper.SerializeObject(new ResultModel(bIsSuccess, bIsSuccess ? "用户名已经存在!":"可以正常使用!"))); }
public string GetPositionByDepartment(string departmentId) { var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var sql = $"select * from PRIVS_POSITION where DepartmentID='{departmentId}'"; var dt = dbContext.getDataTableResult(sql); return(JsonHelper.SerializeObject(dt)); }
public string GetFuncInfo(string id) { var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var funlistFunclist = new List <FuncTree>(); var sql = $"select * from PRIVS_FUNCPRIVS where id='{id}'"; var dt = dbContext.getDataTableResult(sql); return(JsonHelper.SerializeObject(dt)); }
public string LockUser(string id, string isLook) { var ids = id.Replace(",", "','"); var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var sql = $@"update PRIVS_USER set ISLOCKED='{isLook}' where id in ('{ids}')"; var bIsSuccess = dbContext.execute(sql) >= 0; return(JsonHelper.SerializeObject(new ResultModel(bIsSuccess, bIsSuccess ? "操作成功!" : "操作失败!"))); }
public virtual string GetDetailByMainID(string mainId, string cols, string keyField = "id") { string sql = $"select {(string.IsNullOrEmpty(cols) ? "*" : cols)} from {TableName} where {keyField}='{mainId}'"; var context = DBHelperPool.Instance.GetDbHelper(); if (context == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var datatable = context.getDataTableResult(sql); return(JsonHelper.SerializeObject(ToolResult.Success(datatable))); }
public virtual string ReceiveData() { var funModel = FindFunModel(HeritageId, FunId); if (funModel == null) { return(JsonHelper.SerializeObject(new ResultModel(false, "找不到该功能对应的配置信息"))); } //通过xml配置的表名 找到类的路径 反射成 list类 对象 var cListType = MethodHelper.GetTypeList(GetModelName(funModel.TableName)); //GCHeritagePlatform.Services.PublicMornitor.Model.HPF_RCXC_RCXCYCJL; var entList = JsonHelper.DeserializeJsonToObject(BusinessJsonStr, cListType) as IList; //遗产地发过来的字符串(json格式)的项与我们在model中建的功能类的属性是一一对应的,这里进行赋值 var listSqlStr = new List <string>(); //组织SQL 统一插入 var listYSJID = new List <string>(); //遗产地数据ID 验证对接 var context = DBHelperPool.Instance.GetDbHelper(); if (context == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } foreach (var item in entList)//因为要将接收过来的数据写到总平台数据库中,所以需要添加ID,以及进行遗产地数据ID进行检查,防止重复插入 { 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"].ToString() + ""; if (!string.IsNullOrEmpty(yscid)) { listYSJID.Add(yscid);//防止重复对接 } listSqlStr.Add(context.insertByParamsReturnSQL(GetModelName(funModel.TableName), nameToValue)); } if (!CheckIsDock(listSqlStr, listYSJID, funModel.TableName, context)) { return(JsonHelper.SerializeObject(new ResultModel(false, "已经存在对接的数据"))); } return(GetExeListSQL(context, listSqlStr)); }
public string GetRoleEx(string id) { var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var sql = $"select * from PRIVS_ROLE where ID = '{id}'"; var dt = dbContext.getDataTableResult(sql); DataTable dtFUN = dbContext.getDataTableResult($@"select a.*,b.NAME from PRIVS_ROLE_FUNCPRIVS a left join PRIVS_FUNCPRIVS b on a.PRIVSID=b.ID where a.ROLEID='{id}'"); return(JsonHelper.SerializeObject(new { Role = dt, Fun = dtFUN })); }
public string GetDepartmentInfo(string id) { var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var sql = $@"select b.Name as PARENTName,a.* from PRIVS_DEPARTMENT a left join PRIVS_DEPARTMENT b on a.PARENTID=b.ID where a.ID = '{id}'"; DataTable dt = dbContext.getDataTableResult(sql); return(JsonHelper.SerializeObject(dt)); }
public virtual string ReceiveFile(byte[] fileInfo, string fileNmae, string businessFunID, string heritageId) { //遗产地 + 大类+ 功能 +文件 //var ftpUserID = System.Configuration.ConfigurationManager.AppSettings["ftpUser"]; //var ftpPassword = System.Configuration.ConfigurationManager.AppSettings["ftpPassword"]; SystemLogger.getLogger().Info(DateTime.Now + "访问bug"); var ftpAddress = System.Configuration.ConfigurationManager.AppSettings["Address"]; var rPath = ""; var filePath = CommonBusiness.GetFileTempPath(businessFunID, heritageId, ftpAddress, out rPath); var fileNewGuid = Guid.NewGuid().ToString(); var filePathAll = Path.Combine(filePath, fileNewGuid + "." + fileNmae.GetExtensioName()); if (!System.IO.Directory.Exists(filePath)) { SystemLogger.getLogger().Info(DateTime.Now + "创建目录"); System.IO.Directory.CreateDirectory(filePath); } FileStream fstream = File.Create(filePathAll, fileInfo.Length); fstream.Write(fileInfo, 0, fileInfo.Length); // SystemLogger.getLogger().Info(DateTime.Now + "创建目录正常"); try { var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var sql = @"INSERT INTO `HPF_TEMP_FILE` (`ID`,`WJMC`,`WJLX`,`WJLJ`) VALUES ('{0}','{1}','{2}','{3}')"; SystemLogger.getLogger().Info(DateTime.Now + "访问bug1"); var iResult = dbContext.execute(string.Format(sql, fileNewGuid, fileNmae, fileNmae.GetExtensioName(), rPath + fileNewGuid + "." + fileNmae.GetExtensioName())); SystemLogger.getLogger().Info(DateTime.Now + "访问bug2"); SystemLogger.getLogger().Info("返回结果:" + iResult); return(iResult > 0 ? fileNewGuid : ""); } catch (Exception ex) { var strErr = string.Format("遗产地对接文件类数据错误,参数:{0}#{1}#{2},具体错误:{3}", fileNmae, businessFunID, heritageId, ex.Message); SystemLogger.getLogger().Error(strErr); } finally { fstream.Close(); } SystemLogger.getLogger().Info(DateTime.Now + "访问bug4"); return(fileNewGuid); }
public string GetDepartmentTree() { var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var sql = "select ID,NAME,PARENTID as PID from PRIVS_DEPARTMENT"; var dt = dbContext.getDataTableResult(sql); var entList = dt.ToEntList <FuncTree>(); var el = entList.Where(e => e.PID == null).ToList(); foreach (var item in el) { GetFunC(entList, item); } return(JsonHelper.SerializeObject(el)); }
public string GetUser(string id) { var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var sql = $@" select a.*,c.Name as POSITIONNAME,b.ROLENAME as LEADERName,d.NAME as DEPARTMENTName from PRIVS_USER a left join PRIVS_DEPARTMENT d on a.DEPARTMENTID=d.id left join PRIVS_LEADER b on a.ID=b.USERID left join PRIVS_POSITION c on a.POSITIONID=c.ID where a.ID = '{id}'"; DataTable dt = dbContext.getDataTableResult(sql); DataTable dtRole = dbContext.getDataTableResult($@"select a.*,b.Name from PRIVS_USER_ROLE a left Join PRIVS_ROLE b on a.ROLEID = b.ID where a.USERID ='{id}'"); return(JsonHelper.SerializeObject(new { User = dt, Role = dtRole })); }
public string ExportFuncTree(List <FuncTree> listFuncTree) { var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var listSql = new List <string>() { "delete from PRIVS_FUNCPRIVS" }; var sqlTemplate = @"insert into PRIVS_FUNCPRIVS(ID,NAME,PID,DESCRIPTION,INDEXOFORDER, ARGS,GROUPNAME,SYSTEMID,CJSJ)values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')"; SetFuncListSql(listFuncTree, listSql, sqlTemplate); var b = dbContext.executeTransactionSQLList(listSql); return(JsonHelper.SerializeObject(new ResultModel(b, b?"导入功能树成功":"导入功能树失败"))); }
public string GetDepartmentList(string keywords, int page, int num) { var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var sqlstringbuilder = new StringBuilder(@"select b.Name as PARENTNANE,a.* from PRIVS_DEPARTMENT a left join PRIVS_DEPARTMENT b on a.PARENTID=b.ID where 1=1"); if (!string.IsNullOrEmpty(keywords)) { sqlstringbuilder.AppendFormat(" and (a.NAME like '%{0}%' or a.ALIASNAME like '%{0}%') ", keywords); } sqlstringbuilder.AppendFormat(" order by a.CJSJ desc"); var busness = new CommonBaseBusiness(); var pageModel = busness.Select(sqlstringbuilder.ToString(), (page - 1) * num, num); return(JsonHelper.SerializeObject(pageModel)); }
public string GetRoleList(string keyword, int page, int num) { var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var sql = "select * from PRIVS_ROLE where 1=1 "; var sqlstringbuilder = new StringBuilder(sql); if (!string.IsNullOrEmpty(keyword)) { sqlstringbuilder.AppendFormat(" and (NAME like '%{0}%' or ALIASNAME like '%{0}%') ", keyword); } sqlstringbuilder.AppendFormat(" order by CJSJ desc"); var busness = new CommonBaseBusiness(); var pageModel = busness.Select(sqlstringbuilder.ToString(), (page - 1) * num, num); return(JsonHelper.SerializeObject(pageModel)); }
public string GetFuncTree() { var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var sql = "select ID,NAME,PID,ARGS from PRIVS_FUNCPRIVS order by INDEXOFORDER"; var dt = dbContext.getDataTableResult(sql); if (dt == null || dt.Rows.Count == 0) { return(JsonHelper.SerializeObject(dt)); } var entList = dt.ToEntList <FuncTree>(); var el = entList.Where(e => string.IsNullOrEmpty(e.PID)).ToList(); foreach (var item in el) { GetFunC(entList, item); } return(JsonHelper.SerializeObject(el)); }
public override string ReceiveData() { var funModel = this.FindFunModel(HeritageId, FunId); if (funModel == null) { return(JsonHelper.SerializeObject(new ResultModel(false, "找不到该功能对应的配置信息!"))); } var cListType = MethodHelper.GetTypeList(GetModelName(funModel.TableName), "HPF_KGFJ_KGFJJL_XGWD"); var ent = JsonHelper.DeserializeJsonToDynamicObject(BusinessJsonStr, cListType); var entData = ent.DATA as IList; var entDataDetail = ent.DATADETAIL as IList; var entPathList = ent.FILEPATHLIST as List <FileInfoEx>; //if (entData.Count != entPathList.Count) // return JsonHelper.SerializeObject(new ResultModel(false, "文件个数与记录条数不符!"));//这个地方不能判断,因为无已发表的简报的情况就附件为空。 var listSql = new List <string>(); var listYsjId = new List <string>(); var kgfjjlid = new Dictionary <string, string>(); var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据库连接异常!"))); } var receiveAllFileInfo = entPathList == null? null : CommonBusiness.GetFileListByFileID(entPathList.Select(e => e.FILEID)); foreach (var item in entData) { 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 ysjid = nameToValue["YCDSJID"] + ""; kgfjjlid.Add(ysjid, nameToValue["ID"] + ""); listYsjId.Add(ysjid); listSql.Add(dbContext.insertByParamsReturnSQL(GetModelName(funModel.TableName), nameToValue)); } if (entDataDetail != null) { foreach (var item in entDataDetail) { 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()); } if (nameToValue.ContainsKey("FJJLID")) { nameToValue["FJJLID"] = kgfjjlid["FJJLID"]; } else { nameToValue.Add("FJJLID", kgfjjlid["FJJLID"]); } var ysjid = nameToValue["YCDSJID"] + ""; if (string.IsNullOrEmpty(ysjid)) { return(JsonHelper.SerializeObject(new ResultModel(false, "YCDSJID不能为空!"))); } var fileIds = entPathList.Where(e => e.YCDSJID == ysjid).Select(e => e.FILEID).ToList(); var filePathList = receiveAllFileInfo.Where(e => fileIds.Contains(e.FILEID)).ToList(); var file = entPathList.FirstOrDefault(e => e.YCDSJID == ysjid); if (file != null) { var filePath = receiveAllFileInfo.FirstOrDefault(e => e.FILEID == file.FILEID); if (filePath != null) { nameToValue["WDMC"] = filePath.FILENAME; nameToValue["WDLX"] = filePath.FILETYPE; nameToValue["LJ"] = filePath.RELATIVEPATH; } } listSql.Add(dbContext.insertByParamsReturnSQL(GetModelName(funModel.TableName), nameToValue)); } } if (!CheckIsDock(listSql, listYsjId, funModel.TableName, dbContext)) { return(JsonHelper.SerializeObject(new ResultModel(false, "已经存在对接的数据"))); } return(GetExeListSQL(dbContext, listSql)); }
public override string ReceiveData() { var dockBTYZTBHStructInitClass = GetTableName(FunId); //根据传入两个表名来获取对应的数据结构模型的类型 var eType = MethodHelper.GetTypeList(dockBTYZTBHStructInitClass.MainTableName, dockBTYZTBHStructInitClass.SubordinateTableName); //将Json串按指定的类型进行反序列化为dynamic实体对象 var ent = JsonHelper.DeserializeJsonToDynamicObject(this.BusinessJsonStr, eType); var entBHList = ent.DATA as IList; var entBHJLList = 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 entBHList) { var nameToValue = item.GetNameToValueDic(); if (!nameToValue.ContainsKey("YCDSJID")) { return(JsonHelper.SerializeObject(new ResultModel(false, "元数据ID不存在,对接失败!"))); } if (nameToValue.ContainsKey("BHBH")) { string newBHBH; //代码限定,要求对方传来的病害编号是编号ID,而不是具体的编号内容,并且该ID必须是病害调查监测工作情况记录表中的主键 var bIsExistBHBH = GetBHBHByOldDataID(dbContext, nameToValue["BHBH"] + "", out newBHBH); if (!bIsExistBHBH) { return(JsonHelper.SerializeObject(new ResultModel(false, "请先对接病害的工作监测记录!"))); } nameToValue["BHBH"] = newBHBH; } var ysjid = nameToValue["YCDSJID"] + "";//元数据ID var guid = Guid.NewGuid(); //这里保存的是LF的ID 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(dockBTYZTBHStructInitClass.MainTableName, nameToValue)); } //明细 var dicFileRelatedID = new Dictionary <string, Guid>(); foreach (var item in entBHJLList) { var nameToValue = item.GetNameToValueDic(); if (!nameToValue.ContainsKey("YCDSJID")) { return(JsonHelper.SerializeObject(new ResultModel(false, "元数据ID不存在,对接失败!"))); } //将裂缝记录中的老外键ID记录下来,保存的裂缝中的ycdsjid var lfid = nameToValue[dockBTYZTBHStructInitClass.RelatedID] + ""; 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[dockBTYZTBHStructInitClass.RelatedID] = dicOldToNew[lfid]; var ysjid = nameToValue["YCDSJID"] + ""; //这里保存的是裂缝JL的ID dicFileRelatedID.Add(ysjid, guid); listSqlStr.Add(dbContext.insertByParamsReturnSQL(dockBTYZTBHStructInitClass.SubordinateTableName, nameToValue)); } //附件 if (entPathList != null && entPathList.Count > 0) { var fileIds = entPathList.Select(e => e.FILEID).ToList(); var fileInfoList = CommonBusiness.GetFileListByFileID(fileIds); if (fileInfoList == null || fileInfoList.Count != fileIds.Count) { return(JsonHelper.SerializeObject(new ResultModel(false, "文件信息不对应"))); } foreach (var item in fileInfoList) { var entFile = entPathList.FirstOrDefault(e => e.FILEID == item.FILEID); //public string sqlInsertTP = "insert into {0} (ID,MC,TPLJ,{1},TPGS,YCDSJID,RKSJ)values ('{2}','{3}','{4}','{5}','{6}','{7}','{8}')"; var sql = string.Format(this.sqlInsertTP, dockBTYZTBHStructInitClass.RelatedZPTableName, dockBTYZTBHStructInitClass.RelatedJLID, Guid.NewGuid(), item.FILENAME, item.RELATIVEPATH, dicFileRelatedID[entFile.YCDSJID], item.FILETYPE, entFile.YCDSJID, DateTime.Now.ToString()); ///JLID listSqlStr.Add(sql); } } if (!CheckIsDock(listSqlStr, listYSJID, dockBTYZTBHStructInitClass.MainTableName, dbContext)) { return(JsonHelper.SerializeObject(new ResultModel(false, "已经存在对接的数据"))); } return(GetExeListSQL(dbContext, listSqlStr)); }
public override string ReceiveData() { var funModel = this.FindFunModel(HeritageId, FunId); if (funModel == null) { return(JsonHelper.SerializeObject(new ResultModel(false, "找不到该功能对应的配置信息"))); } //通过xml配置的表名 找到类的路径 反射成 list类 对象 var cListType = MethodHelper.GetTypeList(GetModelName(funModel.TableName)); //GCHeritagePlatform.Services.PublicMornitor.Model.HPF_RCXC_RCXCYCJL; var entList = JsonHelper.DeserializeJsonToObject(BusinessJsonStr, cListType) as IList; //遗产地发过来的字符串(json格式)的项与我们在model中建的功能类的属性是一一对应的,这里进行赋值 var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var listSqlStr = new List <string>(); var listInsertCount = new Dictionary <string, string>(); foreach (var item in entList) { 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 {0} where GLYCBTID='{1}' and BHBH='{2}' ", ClassName, HeritageId, nameToValue[RelatedID]); var dtMain = dbContext.getDataTableResult(strSql); if (dtMain == null || dtMain.Rows.Count == 0) { var bhid = Guid.NewGuid(); var strBHSql = string.Format("insert into {4} (ID,YCDSJID,BHBH,GLYCBTID,RKSJ) values('{0}','{1}','{2}','{3}','{5}')", bhid, Guid.NewGuid(), nameToValue[RelatedID], HeritageId, this.ClassName, System.DateTime.Now); if (!listInsertCount.ContainsKey(nameToValue[RelatedID] + "")) { listInsertCount.Add(nameToValue[RelatedID] + "", bhid.ToString()); listSqlStr.Add(strBHSql); } nameToValue[RelatedID] = listInsertCount[nameToValue[RelatedID].ToString()]; } else { nameToValue[RelatedID] = dtMain.Rows[0][0].ToString(); } listSqlStr.Add(dbContext.insertByParamsReturnSQL(GetModelName(funModel.TableName), nameToValue)); } if (!CheckIsDock(listSqlStr, listSqlStr, ClassName, dbContext)) { return(JsonHelper.SerializeObject(new ResultModel(false, "已经存在对接的数据"))); } return(GetExeListSQL(dbContext, listSqlStr)); }
public override string ReceiveData() { var dockSYCNStructInitClass = GetTableName(FunId); var eType = MethodHelper.GetTypeListL(dockSYCNStructInitClass.MainTableName, dockSYCNStructInitClass.SubordinateTableName, dockSYCNStructInitClass.WDTableName); //将Json串按指定的类型进行反序列化为dynamic实体对象 var ent = JsonHelper.DeserializeJsonToDynamicObject(this.BusinessJsonStr, eType); var entCNSXList = ent.DATA as IList; //CNSX var entCNSXJZList = ent.DATADETAIL as IList; //CNSXJZ var entCNSXWDList = ent.DATADETAILSON as IList; //WD var entPathList = ent.FILEPATHLIST as List <FileInfoEx>; var listSqlStr = new List <string>(); var listYSJID = new List <string>(); var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var dicOldToNew = SetSYCNDic(dbContext); //CNSXJZ-CNSX var dicWDOldToNew = new Dictionary <string, Guid>(); //WD-CNSXJZ //主表 foreach (var item in entCNSXList) { var nameToValue = item.GetNameToValueDic(); if (!nameToValue.ContainsKey("YCDSJID")) { return(JsonHelper.SerializeObject(new ResultModel(false, "元数据ID不存在,对接失败!"))); } var ysjid = nameToValue["YCDSJID"] + "";//元数据ID var guid = Guid.NewGuid(); if (!dicOldToNew.ContainsKey(ysjid)) { 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("HPF_SYCN_CNSX", nameToValue)); } } //明细 var dicFileRelatedID = new Dictionary <string, Guid>(); foreach (var item in entCNSXJZList) { var nameToValue = item.GetNameToValueDic(); if (!nameToValue.ContainsKey("YCDSJID")) { return(JsonHelper.SerializeObject(new ResultModel(false, "元数据ID不存在,对接失败!"))); } var ysjid = nameToValue["YCDSJID"] + ""; var guid = Guid.NewGuid(); dicWDOldToNew.Add(ysjid, guid); if (nameToValue.ContainsKey("GLYCBTID")) { nameToValue["GLYCBTID"] = HeritageId; } if (nameToValue.ContainsKey("ID")) { nameToValue["ID"] = guid; } else { nameToValue.Add("ID", guid); } nameToValue["CNSXID"] = dicOldToNew[ysjid]; dicFileRelatedID.Add(ysjid, guid); listSqlStr.Add(dbContext.insertByParamsReturnSQL("HPF_SYCN_CNSXJZ", nameToValue)); } //文档 var fileIds = entPathList.Select(e => e.FILEID).ToList(); var fileInfoList = CommonBusiness.GetFileListByFileID(fileIds); if (fileInfoList != null && fileIds.Count != fileInfoList.Count) { return(JsonHelper.SerializeObject(new ResultModel(false, "文件信息在服务器中找不到,对接失败!"))); } foreach (var item in entCNSXWDList) { 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); } if (entPathList.Count > 0) { var firstOrDefault = entPathList.FirstOrDefault(e => e.YCDSJID == ysjid); if (firstOrDefault != null) { var fileID = firstOrDefault.FILEID; var fileInfo = fileInfoList.FirstOrDefault(e => e.FILEID == fileID); nameToValue["WDLJ"] = fileInfo.RELATIVEPATH; } nameToValue["CNSXJZID"] = dicWDOldToNew[ysjid]; listSqlStr.Add(dbContext.insertByParamsReturnSQL("HPF_SYCN_CNSXJZXGWD", nameToValue)); } } if (!CheckIsDock(listSqlStr, listYSJID, "HPF_SYCN_CNSX", dbContext)) { return(JsonHelper.SerializeObject(new ResultModel(false, "已经存在对接的数据"))); } var bIsResult = dbContext.executeTransactionSQLList(listSqlStr); return(JsonHelper.SerializeObject(new ResultModel(bIsResult, bIsResult ? "对接成功" : "对接失败"))); }
public override string ReceiveData() { var ent = JsonHelper.DeserializeJsonToObject <ResultBHGCDockModel>(BusinessJsonStr); var funModel = this.FindFunModel(HeritageId, FunId); if (funModel == null) { return(JsonHelper.SerializeObject(new ResultModel(false, "找不到该功能对应的配置信息"))); } var listSqlStr = new List <string>(); var listYSJID = new List <string>(); var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var dicMainOld2New = new Dictionary <string, Guid>(); foreach (var item in ent.DATA) { var nameToValue = item.GetNameToValueDic(); if (nameToValue.ContainsKey("GLYCBTID")) { nameToValue["GLYCBTID"] = HeritageId; } var guid = Guid.NewGuid(); if (nameToValue.ContainsKey("ID")) { nameToValue["ID"] = guid; } else { nameToValue.Add("ID", guid); } var yscid = nameToValue["YCDSJID"] + ""; listYSJID.Add(yscid); dicMainOld2New.Add(yscid, guid); listSqlStr.Add(dbContext.insertByParamsReturnSQL(GetModelName(funModel.TableName), nameToValue)); } var filePathList = ent.FILEPATHLIST; if (ent.DATADETAIL != null) { foreach (var item in ent.DATADETAIL) { 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()); } //如果有改变PID的属性信息 nameToValue["GCXMID"] = dicMainOld2New[nameToValue["GCXMID"] + ""]; if (filePathList != null && filePathList.Count > 0) {//如果有项目范围图的,具有图纸的文件,则对接图纸,如果使用的超擎的矢量图,则不对接。 var fileInfoList = CommonBusiness.GetFileListByFileID(filePathList.Select(e => e.FILEID)); foreach (var DtailSon in ent.FILEPATHLIST) { var ycdsjid = nameToValue["YCDSJID"] + ""; var fileId = filePathList.FirstOrDefault(e => e.YCDSJID == ycdsjid); FileInfoEx ReceiveFileInfo = fileInfoList.FirstOrDefault(e => e.FILEID == fileId.FILEID); nameToValue["TZMC"] = ReceiveFileInfo.FILENAME; nameToValue["LJ"] = ReceiveFileInfo.RELATIVEPATH; nameToValue["TZGS"] = ReceiveFileInfo.FILETYPE; } } listSqlStr.Add(dbContext.insertByParamsReturnSQL("HPF_BHGC_BHZSHHJZZGC_XMFWT", nameToValue)); } } //if (filePathList != null && filePathList.Count > 0) //{//文档上传失败 不对接文档 // var fileInfoList = CommonBusiness.GetFileListByFileID(filePathList.Select(e => e.FILEID)); // foreach (var item in ent.DataDetailSon) // { // var nameToValue = item.GetNameToValueDic(); // if (nameToValue.ContainsKey("GLYCBTID")) // { // nameToValue["GLYCBTID"] = this.HeritageId; // } // if (nameToValue.ContainsKey("ID")) // { // nameToValue["ID"] = Guid.NewGuid(); // } // else // { // nameToValue.Add("ID", Guid.NewGuid()); // } // nameToValue["GCXMID"] = dicMainOld2New[nameToValue["GCXMID"] + ""]; // var ycdsjid = nameToValue["YCDSJID"] + ""; // var fileID = filePathList.FirstOrDefault(e => e.YCDSJID == ycdsjid); // FileInfoEx ReceiveFileInfo = fileInfoList.FirstOrDefault(e => e.FILEID == fileID.FILEID); // 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("HPF_BHGC_XGWD", nameToValue)); // } //} if (!CheckIsDock(listSqlStr, listYSJID, funModel.TableName, dbContext)) { return(JsonHelper.SerializeObject(new ResultModel(false, "已经存在对接的数据"))); } return(GetExeListSQL(dbContext, listSqlStr)); }
public override string ReceiveData() { var funModel = FindFunModel(HeritageId, FunId); if (funModel == null) { return(JsonHelper.SerializeObject(new ResultModel(false, "找不到该功能对应的配置信息"))); } var CListType = MethodHelper.GetTypeList("HPF_BTYZTBH_TYJL", "HPF_BTYZTBH_TYSJ"); var ent = JsonHelper.DeserializeJsonToDynamicObject(BusinessJsonStr, CListType); var entList = ent.DATA as IList; var entDetailList = ent.DATADETAIL as IList; var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据库连接异常!"))); } var listSqlStr = new List <string>(); var listYsjId = new List <string>(); var listDicOldNew = new Dictionary <string, Guid>(); foreach (var item in entList) { var nameToValue = item.GetNameToValueDic(); if (nameToValue.ContainsKey("GLYCBTID")) { nameToValue["GLYCBTID"] = HeritageId; } var guid = Guid.NewGuid(); if (nameToValue.ContainsKey("ID")) { nameToValue["ID"] = guid; } else { nameToValue.Add("ID", guid); } var rksj = System.DateTime.Now; if (nameToValue.ContainsKey("RKSJ")) { nameToValue["RKSJ"] = rksj; } else { nameToValue.Add("RKSJ", rksj); } var ysjid = nameToValue["YCDSJID"] + ""; if (!string.IsNullOrEmpty(ysjid)) { listYsjId.Add(ysjid); } listDicOldNew.Add(ysjid, guid); listSqlStr.Add(dbContext.insertByParamsReturnSQL("HPF_BTYZTBH_TYJL", nameToValue)); } foreach (var item in entDetailList) { var nameToValue = item.GetNameToValueDic(); if (nameToValue.ContainsKey("ID")) { nameToValue["GLYCBTID"] = HeritageId; } if (nameToValue.ContainsKey("ID")) { nameToValue["ID"] = Guid.NewGuid(); } else { nameToValue.Add("ID", Guid.NewGuid()); } var rksj = System.DateTime.Now; if (nameToValue.ContainsKey("RKSJ")) { nameToValue["RKSJ"] = rksj; } else { nameToValue.Add("RKSJ", rksj); } var bhjlid = nameToValue["BHJLID"] + ""; nameToValue["BHJLID"] = listDicOldNew[bhjlid]; listSqlStr.Add(dbContext.insertByParamsReturnSQL("HPF_BTYZTBH_TYSJ", nameToValue)); } if (!CheckIsDock(listSqlStr, listYsjId, "HPF_BTYZTBH_TYJL", dbContext)) { return(JsonHelper.SerializeObject(new ResultModel(false, "已经存在对接的数据!"))); } return(GetExeListSQL(dbContext, listSqlStr)); }
public override string ReceiveData() { var funModel = FindFunModel(HeritageId, FunId); if (funModel == null) { return(JsonHelper.SerializeObject(new ResultModel(false, "找不到该功能对应的配置信息"))); } var CListType = MethodHelper.GetTypeList(GetModelName(funModel.TableName)); var entList = JsonHelper.DeserializeJsonToObject(BusinessJsonStr, CListType) as IList; 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 entList) { 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 rksj = System.DateTime.Now; if (nameToValue.ContainsKey("RKSJ")) { nameToValue["RKSJ"] = rksj; } else { nameToValue.Add("RKSJ", rksj); } var ysjid = nameToValue["YCDSJID"] + ""; if (!string.IsNullOrEmpty(ysjid)) { listYsjId.Add(ysjid); } string newBhdcjlId; var bIsExistBhjcjlId = GetBhdcjlId(dbContext, nameToValue["BHDCJLID"] + "", nameToValue["BHBH"] + "", out newBhdcjlId); if (!bIsExistBhjcjlId) { return(JsonHelper.SerializeObject(new ResultModel(false, "请先对接病害的工作监测记录"))); } nameToValue["BHDCJLID"] = newBhdcjlId; 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 funModel = FindFunModel(HeritageId, FunId); if (funModel == null) { return(JsonHelper.SerializeObject(new ResultModel(false, "找不到该功能对应的配置信息"))); } var cListType = MethodHelper.GetTypeListFileEx(GetModelName(funModel.TableName)); var ent = JsonHelper.DeserializeJsonToDynamicObject(BusinessJsonStr, cListType); var entDataList = ent.DATA as IList; var entPathList = ent.FILEPATHLIST as List <FileInfoEx>; var listSqlStr = new List <string>(); var listYsjId = new List <string>(); var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据库连接异常!"))); } var receiveAllFileInfo = CommonBusiness.GetFileListByFileID(entPathList.Select(e => e.FILEID)); if (receiveAllFileInfo.Count != entPathList.Count) { return(JsonHelper.SerializeObject(new ResultModel(false, "取得的文件与上传文件个数不匹配!"))); } foreach (var item in entDataList) { 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 rksj = System.DateTime.Now; if (nameToValue.ContainsKey("RKSJ")) { nameToValue["RKSJ"] = rksj; } else { nameToValue.Add("RKSJ", rksj); } var ysjid = nameToValue["YCDSJID"] + ""; if (!string.IsNullOrEmpty(ysjid)) { listYsjId.Add(ysjid); } var fileIDs = entPathList.Where(e => e.YCDSJID == ysjid).Select(e => e.FILEID).ToList(); var filePathList = receiveAllFileInfo.Where(e => fileIDs.Contains(e.FILEID)).ToList(); var newBhdcjlId = ""; var bIsExistBhjcjlId = GetBhdcjlId(dbContext, nameToValue["BHDCJLID"].ToString(), nameToValue["BHBH"].ToString(), out newBhdcjlId); if (!bIsExistBhjcjlId) { return(JsonHelper.SerializeObject(new ResultModel(false, "请先对接病害的工作监测记录!"))); } nameToValue["BHDCJLID"] = newBhdcjlId; var file = entPathList.Where(e => e.YCDSJID == ysjid).FirstOrDefault(); //下面的代码表示,如果没有相应的附件的时候,可以只插入记录 if (file != null) { var filepath = receiveAllFileInfo.FirstOrDefault(e => e.FILEID == file.FILEID); if (filepath != null) { nameToValue["TPLJ"] = filepath.RELATIVEPATH; nameToValue["TPMC"] = filepath.FILENAME; nameToValue["TPGS"] = filepath.FILETYPE; } } 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 funModel = this.FindFunModel(HeritageId, FunId); if (funModel == null) { return(JsonHelper.SerializeObject(new ResultModel(false, "找不到该功能对应的配置信息"))); } //根据传入两个表名来获取对应的数据结构模型的类型 var eType = MethodHelper.GetTypeList(funModel.TableName, "HPF_LYYYKGL_LYJD"); //将Json串按指定的类型进行反序列化为dynamic实体对象 var ent = JsonHelper.DeserializeJsonToDynamicObject(BusinessJsonStr, eType); var entJDMXList = ent.DATA as IList; var entJDLList = ent.DATADETAIL as IList;//var entList = JsonHelper.DeserializeJsonToObject<List<HPF_ZRHJ_TFLJXX>>(jsonStr) ; var dbContext = DBHelperPool.Instance.GetDbHelper(); if (dbContext == null) { return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!"))); } var listSqlStr = new List <string>(); var entJDDic = new Dictionary <string, string>(); var entExistJD = this.GetHeritageLYJD(dbContext); var listYSJID = new List <string>(); foreach (var item in entJDLList) { var nameToValue = item.GetNameToValueDic(); var ycdsjid = nameToValue["YCDSJID"] + ""; var entJD = entExistJD.FirstOrDefault(e => e.YCDSJID == ycdsjid); if (entJD != null) { continue; } if (nameToValue.ContainsKey("GLYCBTID")) { nameToValue["GLYCBTID"] = HeritageId; } var oldJDId = nameToValue["YCDSJID"]; var id = Guid.NewGuid().ToString(); nameToValue["ID"] = id; entJDDic.Add(ycdsjid, id); //如果有改变PID的属性信息 listSqlStr.Add(dbContext.insertByParamsReturnSQL("HPF_LYYYKGL_LYJD", nameToValue)); } foreach (var item in entJDMXList) { 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"].ToString() + ""; if (!string.IsNullOrEmpty(yscid)) //有可能对接过来就是 统计过得数据 例如景点日游客量 { listYSJID.Add(yscid); //防止重复对接 } var lyjdid = nameToValue["LYJDID"] + ""; if (entJDDic.ContainsKey(lyjdid)) { nameToValue["LYJDID"] = entJDDic[lyjdid]; } else { var entJD = entExistJD.FirstOrDefault(e => e.YCDSJID == lyjdid && e.GLYCBTID == HeritageId); if (entJD == null) { return(JsonHelper.SerializeObject(new ResultModel(false, "对接基础数据景点信息错误!"))); } nameToValue["LYJDID"] = entJD.ID; } listSqlStr.Add(dbContext.insertByParamsReturnSQL(GetModelName(funModel.TableName), nameToValue)); } if (!CheckIsDock(listSqlStr, listYSJID, ClassName, dbContext)) { return(JsonHelper.SerializeObject(new ResultModel(false, "已经存在对接的数据"))); } return(GetExeListSQL(dbContext, listSqlStr)); }