Beispiel #1
0
        public static int AddImportLog(Guid OrgId, int DepartmentId, int ImportedBy, System.Collections.Generic.List<int> ImportedAssteId)
        {
            if(ImportedAssteId==null || ImportedAssteId.Count<1) return 0;
            DateTime DTUpdated = DateTime.UtcNow;
            lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext dc = new lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext(OrgId, DepartmentId);

            int? ExistId = (from i in dc.AssetImports where i.DepartmentId==DepartmentId select (int?)i.ImportId).Max();
            int ImportId = 1;
            if(ExistId!=null && (int)ExistId>0) ImportId=((int)ExistId)+1;

            foreach (int id in ImportedAssteId)
            {
                lib.bwa.bigWebDesk.LinqBll.Context.AssetImports imp = new lib.bwa.bigWebDesk.LinqBll.Context.AssetImports()
                {
                    AssetId = id,
                    DepartmentId = DepartmentId,
                    DtUpdated = DTUpdated,
                    ImportId = ImportId,
                    UpdatedBy = ImportedBy
                };
                dc.AssetImports.InsertOnSubmit(imp);
            }
            dc.SubmitChanges();
            return ImportId;
        }
Beispiel #2
0
        static public int AddImportLog(Guid OrgId, int DepartmentId, int ImportedBy, System.Collections.Generic.List <int> ImportedAssteId)
        {
            if (ImportedAssteId == null || ImportedAssteId.Count < 1)
            {
                return(0);
            }
            DateTime DTUpdated = DateTime.UtcNow;

            lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext dc = new lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext(OrgId, DepartmentId);

            int?ExistId  = (from i in dc.AssetImports where i.DepartmentId == DepartmentId select(int?) i.ImportId).Max();
            int ImportId = 1;

            if (ExistId != null && (int)ExistId > 0)
            {
                ImportId = ((int)ExistId) + 1;
            }

            foreach (int id in ImportedAssteId)
            {
                lib.bwa.bigWebDesk.LinqBll.Context.AssetImports imp = new lib.bwa.bigWebDesk.LinqBll.Context.AssetImports()
                {
                    AssetId      = id,
                    DepartmentId = DepartmentId,
                    DtUpdated    = DTUpdated,
                    ImportId     = ImportId,
                    UpdatedBy    = ImportedBy
                };
                dc.AssetImports.InsertOnSubmit(imp);
            }
            dc.SubmitChanges();
            return(ImportId);
        }