コード例 #1
0
ファイル: formSync.cs プロジェクト: ObcianskySpolok/ErasmDB
        private List <ChangesInfo> GetChangedData(tableChanges <modelProjectVariationOrganization> changes)
        {
            var changeInfos = new List <ChangesInfo>();

            foreach (long changedid in changes.changedIDs)
            {
                var objacc = local_dataProject.getProjectVariationOrganization(changedid);
                var objsql = sql_dataProject.getProjectVariationOrganization(changedid);

                var orgacc = local_dataOrganization.getOrganization(objacc.Organization);
                var orgsql = sql_dataOrganization.getOrganization(objsql.Organization);

                var varacc = local_dataProject.getProjectVariation(objacc.ProjectVariation);
                var varsql = sql_dataProject.getProjectVariation(objsql.ProjectVariation);
                var prjacc = local_dataProject.getProject(varacc.ProjectID);
                var prjsql = sql_dataProject.getProject(varsql.ProjectID);

                string acc_desc = prjacc.GetTitleInfo() + " / " + varacc.Title + " / " + orgacc.FriendlyName + " - " + objacc.OrganizationOrder;
                string sql_desc = prjsql.GetTitleInfo() + " / " + varsql.Title + " / " + orgsql.FriendlyName + " - " + objsql.OrganizationOrder;

                var inf = new ChangesInfo(changedid, "Project Activity Variation Organization", acc_desc, sql_desc, objacc.UpdatedDate, objsql.UpdatedDate, objacc.UpdatedDate > objsql.UpdatedDate, false, false);
                changeInfos.Add(inf);
            }
            return(changeInfos);
        }
コード例 #2
0
ファイル: formSync.cs プロジェクト: ObcianskySpolok/ErasmDB
        private List <ChangesInfo> GetChangedData(tableChanges <modelMobility> changes)
        {
            var changeInfos = new List <ChangesInfo>();

            foreach (long changedid in changes.changedIDs)
            {
                var objacc = local_dataActivity.getMobility(changedid);
                var objsql = sql_dataActivity.getMobility(changedid);

                var varactacc = local_dataProject.getProjectActivityVariation(objacc.ActivityVariation);
                var varactsql = sql_dataProject.getProjectActivityVariation(objsql.ActivityVariation);

                var varacc = local_dataProject.getProjectVariation(varactacc.ProjectVariation);
                var varsql = sql_dataProject.getProjectVariation(varactsql.ProjectVariation);
                var actacc = local_dataProject.getProjectActivity(varactacc.ProjectActivity);
                var actsql = sql_dataProject.getProjectActivity(varactsql.ProjectActivity);
                var prjacc = local_dataProject.getProject(varacc.ProjectID);
                var prjsql = sql_dataProject.getProject(varsql.ProjectID);

                var ctracc = local_dataLOV.getCountry(objacc.CountryOfOrigin);
                var ctrsql = sql_dataLOV.getCountry(objsql.CountryOfOrigin);

                string acc_desc = prjacc.GetTitleInfo() + " / " + actacc.Title + " / " + varacc.Title + " / " + varactacc.CityOfDestination + " - " + varactacc.StudyVisit + " / " + ctracc.Country;
                string sql_desc = prjsql.GetTitleInfo() + " / " + actsql.Title + " / " + varsql.Title + " / " + varactsql.CityOfDestination + " - " + varactsql.StudyVisit + " / " + ctrsql.Country;

                var inf = new ChangesInfo(changedid, "Project Activity Variation Mobility", acc_desc, sql_desc, objacc.UpdatedDate, objsql.UpdatedDate, objacc.UpdatedDate > objsql.UpdatedDate, false, false);
                changeInfos.Add(inf);
            }
            return(changeInfos);
        }
コード例 #3
0
ファイル: formSync.cs プロジェクト: ObcianskySpolok/ErasmDB
        private List <ChangesInfo> GetChangedData(tableChanges <modelProjectVariation> changes)
        {
            var changeInfos = new List <ChangesInfo>();

            foreach (long changedid in changes.changedIDs)
            {
                var objacc = local_dataProject.getProjectVariation(changedid);
                var objsql = sql_dataProject.getProjectVariation(changedid);

                var prjacc = local_dataProject.getProject(objacc.ProjectID);
                var prjsql = sql_dataProject.getProject(objsql.ProjectID);

                string acc_desc = prjacc.GetTitleInfo() + " / " + objacc.Title;
                string sql_desc = prjsql.GetTitleInfo() + " / " + objsql.Title;

                var inf = new ChangesInfo(changedid, "Project Variation", acc_desc, sql_desc, objacc.UpdatedDate, objsql.UpdatedDate, objacc.UpdatedDate > objsql.UpdatedDate, false, false);
                changeInfos.Add(inf);
            }
            return(changeInfos);
        }