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