static async Task AddOrUpdateAsync(BiblioCacheContext context,
EntityItem item)
{
try
{
// 保存到本地数据库
context.Entities.Add(item);
await context.SaveChangesAsync();
}
catch (Exception ex)
{
SqliteException sqlite_exception = ex.InnerException as SqliteException;
if (sqlite_exception != null && sqlite_exception.SqliteErrorCode == 19)
{
// PII 发生重复了
goto UPDATE;
}
else
{
throw ex;
}
}
UPDATE:
// 更新到本地数据库
context.Entities.Update(item);
await context.SaveChangesAsync();
}
// result.Value
// 0 没有找到记录。没有发生更新
// 1 成功更新
public static async Task <NormalResult> UpdateEntityXmlAsync(string pii,
string item_xml,
byte[] timestamp)
{
try
{
using (BiblioCacheContext context = new BiblioCacheContext())
{
if (_cacheDbCreated == false)
{
context.Database.EnsureCreated();
_cacheDbCreated = true;
}
// 先尝试从本地实体库中获得原记录
var entity_record = context.Entities.Where(o => o.PII == pii).FirstOrDefault();
if (entity_record == null)
{
return new NormalResult {
Value = 0
}
}
;
entity_record.Xml = item_xml;
entity_record.Timestamp = timestamp;
// 保存到本地数据库
context.Entities.Update(entity_record);
await context.SaveChangesAsync();
return(new NormalResult {
Value = 1
});
}
}
catch (Exception ex)
{
WpfClientInfo.WriteErrorLog($"UpdateEntityXmlAsync() 出现异常: {ExceptionUtil.GetDebugText(ex)}");
return(new NormalResult
{
Value = -1,
ErrorInfo = $"UpdateEntityXmlAsync() 出现异常: {ex.Message}"
});
}
}
// 获得册记录信息和书目摘要信息
// parameters:
// style 风格。network 表示只从网络获取册记录；否则优先从本地获取，本地没有再从网络获取册记录。无论如何，书目摘要都是尽量从本地获取
// .Value
// 0 没有找到
// 1 找到
public static async Task <GetEntityDataResult> GetEntityDataAsync(string pii,
string style)
{
bool network = StringUtil.IsInList("network", style);
try
{
using (var releaser = await _channelLimit.EnterAsync())
using (BiblioCacheContext context = new BiblioCacheContext())
{
if (_cacheDbCreated == false)
{
context.Database.EnsureCreated();
_cacheDbCreated = true;
}
LibraryChannel channel = App.CurrentApp.GetChannel();
TimeSpan old_timeout = channel.Timeout;
channel.Timeout = TimeSpan.FromSeconds(10);
try
{
GetEntityDataResult result = null;
List <NormalResult> errors = new List <NormalResult>();
EntityItem entity_record = null;
// ***
// 第一步：获取册记录
if (network == false)
{
// 先尝试从本地实体库中获得记录
entity_record = context.Entities.Where(o => o.PII == pii).FirstOrDefault();
// EntityItem entity_record = null; // testing
}
if (entity_record != null)
{
result = new GetEntityDataResult
{
Value = 1,
ItemXml = entity_record.Xml,
ItemRecPath = entity_record.RecPath,
Title = "",
}
}
;
else
{
// 再尝试从 dp2library 服务器获取
// TODO: ItemXml 和 BiblioSummary 可以考虑在本地缓存一段时间
int nRedoCount = 0;
REDO_GETITEMINFO:
long lRet = channel.GetItemInfo(null,
"item",
pii,
"",
"xml",
out string item_xml,
out string item_recpath,
out byte[] timestamp,
"",
out _,
out _,
out string strError);
if (lRet == -1)
{
if ((channel.ErrorCode == ErrorCode.RequestError ||
channel.ErrorCode == ErrorCode.RequestTimeOut) &&
nRedoCount < 2)
{
nRedoCount++;
goto REDO_GETITEMINFO;
}
// TODO: 这里不着急返回，还需要尝试获得书目摘要
errors.Add(new NormalResult
{
Value = -1,
ErrorInfo = strError,
ErrorCode = channel.ErrorCode.ToString()
});
/*
* return new GetEntityDataResult
* {
* Value = -1,
* ErrorInfo = strError,
* ErrorCode = channel.ErrorCode.ToString()
* };
*/
}
else
{
result = new GetEntityDataResult
{
Value = 1,
ItemXml = item_xml,
ItemRecPath = item_recpath,
Title = "",
};
// 保存到本地数据库
await AddOrUpdateAsync(context, new EntityItem
{
PII = pii,
Xml = item_xml,
RecPath = item_recpath,
Timestamp = timestamp,
});
#if NO
context.Entities.Add(new EntityItem
{
PII = pii,
Xml = item_xml,
RecPath = item_recpath,
Timestamp = timestamp,
});
try
{
await context.SaveChangesAsync();
}
catch (Exception ex)
{
SqliteException sqlite_exception = ex.InnerException as SqliteException;
if (sqlite_exception != null && sqlite_exception.SqliteErrorCode == 19)
{
// PII 发生重复了
}
else
{
throw ex;
}
}
#endif
}
}
// ***
/// 第二步：获取书目摘要
// 先尝试从本地书目库中获取书目摘要
var item = context.BiblioSummaries.Where(o => o.PII == pii).FirstOrDefault();
if (item != null &&
string.IsNullOrEmpty(item.BiblioSummary) == false)
{
if (result == null)
{
result = new GetEntityDataResult();
}
result.Title = item.BiblioSummary;
}
else
{
// 从 dp2library 服务器获取书目摘要
int nRedoCount = 0;
REDO_GETBIBLIOSUMMARY:
long lRet = channel.GetBiblioSummary(
null,
pii,
"", // strConfirmItemRecPath,
null,
out _,
out string strSummary,
out string strError);
if (lRet == -1)
{
if ((channel.ErrorCode == ErrorCode.RequestError ||
channel.ErrorCode == ErrorCode.RequestTimeOut) &&
nRedoCount < 2)
{
nRedoCount++;
goto REDO_GETBIBLIOSUMMARY;
}
errors.Add(new NormalResult
{
Value = -1,
ErrorInfo = strError,
ErrorCode = channel.ErrorCode.ToString()
});
/*
* return new GetEntityDataResult
* {
* Value = -1,
* ErrorInfo = strError,
* ErrorCode = channel.ErrorCode.ToString(),
* };
*/
}
else
{
strSummary = strSummary?.Replace(". -- ", "\r\n"); // .Replace("/", "\r\n");
if (result == null)
{
result = new GetEntityDataResult();
}
result.Title = strSummary;
// 存入数据库备用
if (lRet == 1 && string.IsNullOrEmpty(strSummary) == false)
{
try
{
var exist_item = context.BiblioSummaries.Where(o => o.PII == pii).FirstOrDefault();
if (exist_item != null)
{
if (exist_item.BiblioSummary != strSummary)
{
exist_item.BiblioSummary = strSummary;
context.BiblioSummaries.Update(exist_item);
}
}
else
{
context.BiblioSummaries.Add(new BiblioSummaryItem
{
PII = pii,
BiblioSummary = strSummary
});
}
await context.SaveChangesAsync();
}
catch (Exception ex)
{
WpfClientInfo.WriteErrorLog($"GetEntityDataAsync() 中保存 summary 时(PII 为 '{pii}')出现异常:{ExceptionUtil.GetDebugText(ex)}");
}
}
}
/*
* return new GetEntityDataResult
* {
* Value = (int)lRet,
* ItemXml = item_xml,
* ItemRecPath = item_recpath,
* Title = strSummary,
* ErrorInfo = strError,
* ErrorCode = channel.ErrorCode.ToString()
* };
*/
}
// 完全成功
if (result != null && errors.Count == 0)
{
return(result);
}
if (result == null)
{
return new GetEntityDataResult
{
Value = errors[0].Value,
ErrorInfo = errors[0].ErrorInfo,
ErrorCode = errors[0].ErrorCode
}
}
;
result.ErrorInfo = errors[0].ErrorInfo;
result.ErrorCode = errors[0].ErrorCode;
return(result);
}
finally
{
channel.Timeout = old_timeout;
App.CurrentApp.ReturnChannel(channel);
}
}
}
catch (Exception ex)
{
WpfClientInfo.WriteErrorLog($"GetEntityDataAsync() 出现异常: {ExceptionUtil.GetDebugText(ex)}");
return(new GetEntityDataResult
{
Value = -1,
ErrorInfo = $"GetEntityDataAsync() 出现异常: {ex.Message}",
ErrorCode = ex.GetType().ToString()
});
}
}