private void xsbSync_Click(object sender, EventArgs e) { ConfigHelper.BeginDate = xdeBeginDate.DateTime; var dtBegin = DateTime.Now; _syncResultInfoSet.Clear(); _syncResultInfoSet.AddInfo($"同步时间段为:{ConfigHelper.BeginDate}至{ConfigHelper.NextDate}"); xsbSync.Enabled = false; xbbiConnectionConfig.Enabled = false; xbiCommonConfig.Enabled = false; new Thread(() => { new SyncClientList { SyncResultInfoSet = _syncResultInfoSet }.DataSync(); //同步客户信息 new SyncApplicantList { SyncResultInfoSet = _syncResultInfoSet }.DataSync(); //同步申请人 new SyncAgencyList { SyncResultInfoSet = _syncResultInfoSet }.DataSync(); //同步外所 new SyncPatentList { SyncResultInfoSet = _syncResultInfoSet }.DataSync(); //同步国内专利 new SyncPatentAbroadList { SyncResultInfoSet = _syncResultInfoSet }.DataSync(); //同步国外专利 new SyncPatentHKList { SyncResultInfoSet = _syncResultInfoSet }.DataSync(); //同步香港专利 new SyncDemandList { SyncResultInfoSet = _syncResultInfoSet }.DataSync(); //同步要求 new SyncInFileList { SyncResultInfoSet = _syncResultInfoSet }.DataSync(); //同步来文(官方、客户) new SyncAnnualFeeList { SyncResultInfoSet = _syncResultInfoSet }.DataSync(); //同步年费 new SyncCustomFieldList { SyncResultInfoSet = _syncResultInfoSet }.DataSync(); //同步自定义属性 new SyncOAList { SyncResultInfoSet = _syncResultInfoSet }.DataSync(); //同步OA _syncResultInfoSet.AddInfo("同步完成!"); Invoke(new Action(() => { CalcNewSyncDate(dtBegin); GetSyncDate(); _syncResultInfoSet.SendEmailByCondition(); xsbSync.Enabled = true; xbbiConnectionConfig.Enabled = true; xbiCommonConfig.Enabled = true; })); }).Start(); }
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 List <SyncData <HongKongApplication, EX_HKCASE> > GetListSyncData() { SyncResultInfoSet?.AddInfo("筛选需同步的香港专利数据..."); return (new XPQuery <HongKongApplication>(new UnitOfWork()).Where( c => c.dt_CreateDate >= ConfigHelper.BeginDate && c.dt_CreateDate < ConfigHelper.NextDate || c.dt_EditDate >= ConfigHelper.BeginDate && c.dt_EditDate < ConfigHelper.NextDate).Select(c => c.n_CaseID).ToList() .Select(i => new SyncPatentHKData(i) { SyncResultInfoSet = SyncResultInfoSet }) .Cast <SyncData <HongKongApplication, EX_HKCASE> >() .ToList()); }
public override List <SyncData <ExtendedPatent, FCASE> > GetListSyncData() { SyncResultInfoSet?.AddInfo("筛选需同步的国外专利数据..."); return (new XPQuery <ExtendedPatent>(new UnitOfWork()).Where( c => (c.dt_CreateDate >= ConfigHelper.BeginDate && c.dt_CreateDate < ConfigHelper.NextDate || c.dt_EditDate >= ConfigHelper.BeginDate && c.dt_EditDate < ConfigHelper.NextDate) && CommonFunction.GetAbroadPatentBusinessType().Contains(c.n_BusinessTypeID)).Select(c => c.n_CaseID).ToList() .Select(i => new SyncPatentAbroadData(i) { SyncResultInfoSet = SyncResultInfoSet }).Cast <SyncData <ExtendedPatent, FCASE> >() .ToList()); }
public override List <SyncData <CustomField, CASEOTHERINFO> > GetListSyncData() { SyncResultInfoSet?.AddInfo("筛选需同步的自定义属性数据..."); return (new XPQuery <BasicCase>(new UnitOfWork()).Where( c => c.dt_CreateDate >= ConfigHelper.BeginDate && c.dt_CreateDate < ConfigHelper.NextDate || c.dt_EditDate >= ConfigHelper.BeginDate && c.dt_EditDate < ConfigHelper.NextDate).ToList() .SelectMany(c => c.CustomFields.Cast <CustomField>().Select(d => d.n_ID).ToList()) .ToList() .Select(c => new SyncCustomFieldData(c) { SyncResultInfoSet = SyncResultInfoSet }) .Cast <SyncData <CustomField, CASEOTHERINFO> >() .ToList()); }
public override List <SyncData <Agency, CLIENTDB> > GetListSyncData() { SyncResultInfoSet?.AddInfo("筛选需同步的代理机构数据..."); return(new XPQuery <Agency>(new UnitOfWork()).Where( c => c.dt_CreateDate >= ConfigHelper.BeginDate && c.dt_CreateDate < ConfigHelper.NextDate || c.dt_EditDate >= ConfigHelper.BeginDate && c.dt_EditDate < ConfigHelper.NextDate) .Select(c => c.n_AgencyID) .ToList() .Select(c => new SyncAgencyData(c) { SyncResultInfoSet = SyncResultInfoSet }) .Cast <SyncData <Agency, CLIENTDB> >() .ToList()); }
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 List <SyncData <InFile, RECEIVINGLOG> > GetListSyncData() { SyncResultInfoSet?.AddInfo("筛选需同步的来文数据..."); return (new XPQuery <InFile>(new UnitOfWork()).Where( c => c.dt_CreateDate >= ConfigHelper.BeginDate && c.dt_CreateDate < ConfigHelper.NextDate || c.dt_EditDate >= ConfigHelper.BeginDate && c.dt_EditDate < ConfigHelper.NextDate) .Select(c => c.n_FileID) .ToList() .Select(c => new SyncInFileData(c) { SyncResultInfoSet = SyncResultInfoSet }) .Cast <SyncData <InFile, RECEIVINGLOG> >() .ToList()); }
public override List <SyncData <AnnualFee, GENERALALERT> > GetListSyncData() { SyncResultInfoSet?.AddInfo("筛选需同步的年费数据..."); return (new XPQuery <AnnualFee>(new UnitOfWork()).Where( c => c.dt_CreateDate >= ConfigHelper.BeginDate && c.dt_CreateDate < ConfigHelper.NextDate || c.dt_EditDate >= ConfigHelper.BeginDate && c.dt_EditDate < ConfigHelper.NextDate || c.dt_OfficialPayDate >= ConfigHelper.BeginDate && c.dt_OfficialPayDate < ConfigHelper.NextDate) .Select(c => c.n_AnnualFeeID) .ToList() .Select(c => new SyncAnnualFeeData(c) { SyncResultInfoSet = SyncResultInfoSet }) .Cast <SyncData <AnnualFee, GENERALALERT> >() .ToList()); }
public override List <SyncData <Demand, GENERAL_INSTRUCTION> > GetListSyncData() { SyncResultInfoSet?.AddInfo("筛选需同步的要求数据..."); return (new XPQuery <Demand>(new UnitOfWork()).Where( c => (c.dt_CreateDate >= ConfigHelper.BeginDate && c.dt_CreateDate < ConfigHelper.NextDate || c.dt_EditDate >= ConfigHelper.BeginDate && c.dt_EditDate < ConfigHelper.NextDate) && (c.TheClient != null || c.TheApplicant != null || c.TheAgency != null)) .Select(c => c.n_ID) .ToList() .Select(c => new SyncDemandData(c) { SyncResultInfoSet = SyncResultInfoSet }) .Cast <SyncData <Demand, GENERAL_INSTRUCTION> >() .ToList()); }
public override List <SyncData <TFTaskChain, GENERALALERT> > GetListSyncData() { SyncResultInfoSet?.AddInfo("筛选需同步的OA数据..."); return (new XPQuery <TFTask>(new UnitOfWork()).Where( c => c.dt_CreateTime >= ConfigHelper.BeginDate && c.dt_CreateTime < ConfigHelper.NextDate || c.dt_EditTime >= ConfigHelper.BeginDate && c.dt_EditTime < ConfigHelper.NextDate || c.dt_FinishTime >= ConfigHelper.BeginDate && c.dt_FinishTime < ConfigHelper.NextDate).ToList() .Select(c => c.GetTheTaskChain().g_ID).Distinct() .ToList() .Select(c => new SyncOAData(c) { SyncResultInfoSet = SyncResultInfoSet }) .Cast <SyncData <TFTaskChain, GENERALALERT> >() .ToList()); }
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); }