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