public override RECEIVINGLOG GetExistDataPC(InFile dataIPSP)
{
if (dataIPSP.dt_ReceiveDate < new DateTime(1900, 1, 1))
{
SyncResultInfoSet.AddWarning(InfoString.ToSkipInfo("收文日", dataIPSP.n_FileID,
dataIPSP.sMainCaseSerial + "----" + dataIPSP.s_Name));
return(null);
}
if (string.IsNullOrWhiteSpace(dataIPSP.s_Name))
{
SyncResultInfoSet.AddWarning(InfoString.ToSkipInfo("文件名", dataIPSP.n_FileID, dataIPSP.sMainCaseSerial));
return(null);
}
if (string.IsNullOrWhiteSpace(dataIPSP.sCaseName))
{
SyncResultInfoSet.AddWarning(InfoString.ToSkipInfo("案件", dataIPSP.n_FileID, dataIPSP.s_Name));
return(null);
}
var sCondition = $"RECEIVED = to_date('{dataIPSP.dt_ReceiveDate:yyyy/MM/dd}','yyyy/MM/dd') and OURNO = '{dataIPSP.sMainCaseSerial}' and COMMENTS like '%{dataIPSP.s_Name}%'";
var existInFile = new PC.BLL.RECEIVINGLOG().GetModelList(sCondition);
IsExistDataPC = existInFile.Count > 0;
SyncResultInfoSet.AddInfo(InfoString.ToSyncInfo("来文", IsExistDataPC.Value, dataIPSP.n_FileID, dataIPSP.sMainCaseSerial + " " + dataIPSP.s_Name),
dataIPSP.ClassInfo.TableName, typeof(RECEIVINGLOG).Name);
return(existInFile.Count > 0 ? existInFile[0] : null);
}
public override GENERALALERT GetExistDataPC(AnnualFee dataIPSP)
{
var sCondition = $"TYPEID = 'annualfee' and ITEMNUMBER = '{dataIPSP.n_YearNo}' and OURNO = '{dataIPSP.TheBasicPatent?.s_CaseSerial}'";
var existAlert = new PC.BLL.GENERALALERT().GetModelList(sCondition);
IsExistDataPC = existAlert.Count > 0;
SyncResultInfoSet.AddInfo(InfoString.ToSyncInfo("年费", IsExistDataPC.Value, dataIPSP.n_AnnualFeeID, dataIPSP.TheBasicPatent?.s_CaseSerial + " 第" + dataIPSP.n_YearNo + "年"),
dataIPSP.ClassInfo.TableName, typeof(GENERALALERT).Name);
return(existAlert.Count > 0 ? existAlert[0] : null);
}
public override CLIENTDB GetExistDataPC(Client dataIPSP)
{
if (string.IsNullOrWhiteSpace(dataIPSP.s_ClientCode))
{
SyncResultInfoSet.AddWarning($"{dataIPSP.n_ClientID}未填写客户代码，跳过导入。");
IsExistDataPC = null;
return(null);
}
var existClient = new PC.BLL.CLIENTDB().GetModel(dataIPSP.s_ClientCode);
IsExistDataPC = existClient != null;
SyncResultInfoSet.AddInfo(InfoString.ToSyncInfo("客户", IsExistDataPC.Value, dataIPSP.n_ClientID, dataIPSP.s_ClientCode),
dataIPSP.ClassInfo.TableName, typeof(CLIENTDB).Name);
return(existClient);
}
public override PATENTCASE GetExistDataPC(ExtendedPatent dataIPSP)
{
if (string.IsNullOrWhiteSpace(dataIPSP.s_CaseSerial))
{
SyncResultInfoSet.AddWarning($"{dataIPSP.n_CaseID}未填写我方卷号，跳过导入。");
IsExistDataPC = null;
return(null);
}
var existPatent = new PC.BLL.PATENTCASE().GetModel(dataIPSP.s_CaseSerial);
IsExistDataPC = existPatent != null;
SyncResultInfoSet.AddInfo(
InfoString.ToSyncInfo("国内专利", IsExistDataPC.Value, dataIPSP.n_CaseID, dataIPSP.s_CaseSerial),
dataIPSP.ClassInfo.TableName, typeof(PATENTCASE).Name);
return(existPatent);
}
public override GENERAL_INSTRUCTION GetExistDataPC(Demand dataIPSP)
{
var sCode = GetCode(dataIPSP);
var sCondition = $"CONTENT_CN =:p AND CLIENT_NO = '{sCode}'";
var pid = new PC.BLL.GENERAL_INSTRUCTION().GetSingle(sCondition, dataIPSP.s_Description ?? string.Empty);
if (pid == null)
{
return(null);
}
IsExistDataPC = true;
var instruction = new PC.BLL.GENERAL_INSTRUCTION().GetModel(pid.ToString());
SyncResultInfoSet.AddInfo(InfoString.ToSyncInfo("要求", IsExistDataPC.Value, dataIPSP.n_ID, sCode + " " + dataIPSP.s_Description),
dataIPSP.ClassInfo.TableName, typeof(GENERAL_INSTRUCTION).Name);
return(instruction);
}
public override CASEOTHERINFO GetExistDataPC(CustomField dataIPSP)
{
if (CommonFunction.GetIdTextFieldType(dataIPSP.sFieldName) == string.Empty)
{
SyncResultInfoSet.AddInfo(
InfoString.ToSkipInfo("自定义属性", dataIPSP.BasicCase?.s_CaseSerial, dataIPSP.sFieldName),
dataIPSP.ClassInfo.TableName, typeof(CASEOTHERINFO).Name);
return(null);
}
var sCondition =
$"CASENO = '{dataIPSP.BasicCase?.s_CaseSerial}' AND INFOTYPE = '{CommonFunction.GetIdTextFieldType(dataIPSP.sFieldName)}'";
var existCaseOtherInfo = new PC.BLL.CASEOTHERINFO().GetModelList(sCondition);
IsExistDataPC = existCaseOtherInfo.Count > 0;
SyncResultInfoSet.AddInfo(
InfoString.ToSyncInfo("自定义属性", IsExistDataPC.Value, dataIPSP.BasicCase?.s_CaseSerial,
dataIPSP.sFieldName),
dataIPSP.ClassInfo.TableName, typeof(CASEOTHERINFO).Name);
return(existCaseOtherInfo.Count > 0 ? existCaseOtherInfo[0] : null);
}
public override GENERALALERT GetExistDataPC(TFTaskChain dataIPSP)
{
var sOAType = GetOATypeByTaskChainCode(dataIPSP.GetTheCodeTaskChain().s_Code);
if (string.IsNullOrWhiteSpace(sOAType) || !dataIPSP.dt_CreateTime.HasValue)
{
SyncResultInfoSet.AddInfo(
InfoString.ToSkipInfo("OA", dataIPSP.g_ID, dataIPSP.n_Num + " " + dataIPSP.s_Name),
dataIPSP.ClassInfo.TableName, typeof(GENERALALERT).Name);
return(null);
}
var sCondition =
$"OATYPE = '{GetOATypeByTaskChainCode(dataIPSP.GetTheCodeTaskChain().s_Code)}' and OURNO = '{dataIPSP.GetRelatedCase()?.s_CaseSerial}' and TRIGERDATE1 =TO_DATE('{dataIPSP.dt_CreateTime.Value:yyyy/MM/dd}','yyyy/mm/dd')";
var existOA = new PC.BLL.GENERALALERT().GetModelList(sCondition);
IsExistDataPC = existOA.Count > 0;
SyncResultInfoSet.AddInfo(
InfoString.ToSyncInfo("OA", IsExistDataPC.Value, dataIPSP.g_ID, dataIPSP.n_Num + " " + dataIPSP.s_Name),
dataIPSP.ClassInfo.TableName, typeof(GENERALALERT).Name);
return(existOA.Count > 0 ? existOA[0] : null);
}
