private static void UpdateSystemDefineCache(PdmEntityBlClrDto entity) { int entityId = entity.EntityId; CLROutput.OutputDebug("UpdateSystemDefineCache start... ConnectInfo:" + entity.ConnectInfo); // CLROutput.OutputDebug("UpdateSystemDefineCache start..."); if (!string.IsNullOrEmpty(entity.ConnectInfo)) { //try //{ using (SqlConnection conn = new SqlConnection(entity.ConnectInfo)) { conn.Open(); string lastChange = PdmCacheEntityLookupItem.GetLastChangeCheckSum(conn, entity.SysTableName); // CLROutput.InsertException(conn, "entity.LastScanCheckSum: " + entity.LastScanCheckSum + "lastChange :" + lastChange); CLROutput.OutputDebug("entity.LastScanCheckSum: " + entity.LastScanCheckSum + "lastChange :" + lastChange); if (lastChange != entity.LastScanCheckSum) { if (DictEntityLookupCache.ContainsKey(entityId)) { CLROutput.OutputDebug(" lastChange sysdefine before DictEntityLookupCache " + "__" + entity.EntityCode + "__" + entity.LastScanCheckSum, conn); List <LookupItemDto> newLookupitem = PdmCacheEntityLookupItem.GetOneSystemDefinTableLookupItems(conn, PLMSEntityClrBL.GetSysDefineQueryIDAndDisplay(entity)); Dictionary <object, string> result = PdmCacheEntityLookupItem.ConvertLookItemToDictionaryItem(newLookupitem); DictEntityLookupCache.Remove(entityId); DictEntityLookupCache.Add(entityId, result); entity.LastScanCheckSum = lastChange; // CLROutput.InsertException(conn, " lastChange sysdefine after" + "__" + entity.EntityCode + "__" + entity.LastScanCheckSum); } } } //} //catch (Exception ex) //{ // //using (SqlConnection conn = new SqlConnection(PLMConstantString.PLM_APP_ConnectionString)) // //{ // // conn.Open(); // // CLROutput.InsertException(conn, " exception " + entity.EntityId + "__" + entity.EntityCode + ex.ToString()); // //} //} } }
private static Dictionary <int, List <LookupItemDto> > LoadSysDefineLookupItemFromDabaBase(List <PdmEntityBlClrDto> sysDefineEntityList, SqlConnection conn) { Dictionary <int, List <LookupItemDto> > toReturn = new Dictionary <int, List <LookupItemDto> >(); Dictionary <string, string> dictTableNameAndQuery = new Dictionary <string, string>(); foreach (var aPdmEntityDto in sysDefineEntityList) { string systemQueryTable = PLMSEntityClrBL.GetSysDefineQueryIDAndDisplay(aPdmEntityDto); // CLROutput.OutputDebug("aPdmEntityDto.SysTableName systemQueryTable" + aPdmEntityDto.EntityId + "=" + systemQueryTable); if (string.IsNullOrEmpty(systemQueryTable)) { continue; } // CLROutput.OutputDebug("aPdmEntityDto.SysTableName" + aPdmEntityDto.EntityId + "=" + aPdmEntityDto.EntityCode + aPdmEntityDto.SysTableName); if (!String.IsNullOrEmpty(aPdmEntityDto.SysTableName)) { if (!dictTableNameAndQuery.ContainsKey(aPdmEntityDto.SysTableName)) { dictTableNameAndQuery.Add(aPdmEntityDto.SysTableName, systemQueryTable); } } } foreach (string tablname in dictTableNameAndQuery.Keys) { string queryTAble = dictTableNameAndQuery[tablname]; List <LookupItemDto> listDto = GetOneSystemDefinTableLookupItems(conn, queryTAble); foreach (PdmEntityBlClrDto SysEntityDto in sysDefineEntityList) { string sysTableName = SysEntityDto.SysTableName; // CLROutput.SendDataTable(datatable); if (sysTableName == tablname) { toReturn.Add(SysEntityDto.EntityId, listDto); // CLROutput.OutputDebug("before EntityCode " + SysEntityDto.EntityCode + " tableName="+ sysTableName + "=" + " lastScaltime=" ); //Important //Important string lastScaltime = GetLastChangeCheckSum(conn, tablname); //F**k conn.ConnectionString will retur no password !!!! // SysEntityDto.ConnectInfo = conn.ConnectionString; CLROutput.OutputDebug("SysEntityDto.ConnectInfo = conn.ConnectionString" + SysEntityDto.ConnectInfo); SysEntityDto.LastScanCheckSum = lastScaltime; CLROutput.OutputDebug(sysTableName + " lastScaltime :" + lastScaltime); } } } return(toReturn); }