• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

C# DAL.ProjectDbContext类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了C#中GMS.Project.DAL.ProjectDbContext的典型用法代码示例。如果您正苦于以下问题:C# ProjectDbContext类的具体用法?C# ProjectDbContext怎么用?C# ProjectDbContext使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



ProjectDbContext类属于GMS.Project.DAL命名空间,在下文中一共展示了ProjectDbContext类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: DeleteProjectBasedata

 public void DeleteProjectBasedata(List<int> ids)
 {
     using (var dbContext = new ProjectDbContext())
     {
         dbContext.ProjectBasedatas.Where(u => ids.Contains(u.ID)).Delete();
     }
 }
开发者ID:addy002,项目名称:HaoTang,代码行数:7,代码来源:ProjectService.cs


示例2: GetBudget

 public BudgetInfo GetBudget(int id)
 {
     using (var dbContext = new ProjectDbContext())
     {
         return dbContext.Find<BudgetInfo>(id);
     }
 }
开发者ID:addy002,项目名称:HaoTang,代码行数:7,代码来源:ProjectService.cs


示例3: GetProjectBasedata

 public ProjectBasedata GetProjectBasedata(int id)
 {
     using (var dbContext = new ProjectDbContext())
     {
         return dbContext.Find<ProjectBasedata>(id);
     }
 }
开发者ID:addy002,项目名称:HaoTang,代码行数:7,代码来源:ProjectService.cs


示例4: GetBudgetList

 public IEnumerable<BudgetInfo> GetBudgetList(BudgetRequest request = null)
 {
     request = request ?? new BudgetRequest();
     using (var dbContext = new ProjectDbContext())
     {
         IQueryable<BudgetInfo> Budgets = dbContext.Budgets.Include("LaborCost").Include("Overhead").Include("MachineryCost").Include("MaterialCost").Include("Measure");              
         if (!string.IsNullOrEmpty(request.ProjectName))
             Budgets = Budgets.Where(u => u.ProjectName.Contains(request.ProjectName));                  
         return Budgets.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize);
     }
 }
开发者ID:addy002,项目名称:HaoTang,代码行数:11,代码来源:ProjectService.cs


示例5: SaveProjectBasedata

        public void SaveProjectBasedata(ProjectBasedata project)
        {
            using (var dbContext = new ProjectDbContext())
            {

                if (project.ID>0)
                {
                    dbContext.Update<ProjectBasedata>(project);
                }
                else
                {
                    dbContext.Insert<ProjectBasedata>(project);
                }
            }
        }
开发者ID:addy002,项目名称:HaoTang,代码行数:15,代码来源:ProjectService.cs


示例6: GetProjectBasedataList

        public IEnumerable<ProjectBasedata> GetProjectBasedataList(ProjectRequest request = null)
        {
            request = request ?? new ProjectRequest();
            using (var dbContext = new ProjectDbContext())
            {
                IQueryable<ProjectBasedata> ProjectBasedatas = dbContext.ProjectBasedatas;

                if (!string.IsNullOrEmpty(request.PName))
                    ProjectBasedatas = ProjectBasedatas.Where(u => u.PName.Contains(request.PName));
                if (!string.IsNullOrEmpty(request.Status))
                    ProjectBasedatas = ProjectBasedatas.Where(u => u.Status.Contains(request.Status));
                if (!string.IsNullOrEmpty(request.Fund))
                    ProjectBasedatas = ProjectBasedatas.Where(u => u.Fund.Contains(request.Fund));
                return ProjectBasedatas.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize);


            }
        }
开发者ID:addy002,项目名称:HaoTang,代码行数:18,代码来源:ProjectService.cs


示例7: GetInsOverheadList

        public IEnumerable<InsOverhead> GetInsOverheadList(InsOverheadRequest request = null)
        {
            request = request ?? new InsOverheadRequest();
            using (var dbContext = new ProjectDbContext())
            {
                IQueryable<InsOverhead> InsOverhead = dbContext.InsOverheads.Include("ProjectBasedata");

                if (request.ProjectBasedataID > 0)
                    InsOverhead = InsOverhead.Where(d => d.ProjectBasedataID == request.ProjectBasedataID);

                return InsOverhead.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize);
            }
        }
开发者ID:addy002,项目名称:HaoTang,代码行数:13,代码来源:ProjectService.cs


示例8: GetInsOverhead

 public InsOverhead GetInsOverhead(int id)
 {
     using (var dbContext = new ProjectDbContext())
     {
         var model = dbContext.Find<InsOverhead>(id);
         model.ProjectBasedata = GetProjectBasedata(model.ProjectBasedataID);
         return model;
         //return dbContext.Find<InsOverhead>(id);
     }
 }
开发者ID:addy002,项目名称:HaoTang,代码行数:10,代码来源:ProjectService.cs


示例9: GetAccounting

 public Accounting GetAccounting(int id)
 {
     using (var dbContext = new ProjectDbContext())
     {
         return dbContext.Find<Accounting>(id);
     }
 }
开发者ID:addy002,项目名称:HaoTang,代码行数:7,代码来源:ProjectService.cs


示例10: GetOddmentsList

        public IEnumerable<Oddments> GetOddmentsList(OddmentsRequest request = null)
        {
            request = request ?? new OddmentsRequest();
            using (var dbContext = new ProjectDbContext())
            {
                IQueryable<Oddments> oddments = dbContext.Oddments;


                if (!string.IsNullOrEmpty(request.Name))

                    oddments = oddments.Where(u => u.Name.Contains(request.Name));

                //if (!string.IsNullOrEmpty(request.Toolname))
                //    oddments = oddments.Where(u => u.Toolname.Contains(request.Toolname));

                //if (!string.IsNullOrEmpty(request.obb))
                //    oddments = oddments.Where(u => u.obb.Contains(request.obb));

                //if (!string.IsNullOrEmpty(request.Way))
                //    oddments = oddments.Where(u => u.Way.Contains(request.Way));

                return oddments.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize);
            }
        }
开发者ID:addy002,项目名称:HaoTang,代码行数:24,代码来源:ProjectService.cs


示例11: DeleteFile

 public void DeleteFile(List<int> ids)
 {
     using (var dbContext = new ProjectDbContext())
     {
         dbContext.Files.Where(u => ids.Contains(u.ID)).Delete();
     }
 }
开发者ID:addy002,项目名称:HaoTang,代码行数:7,代码来源:ProjectService.cs


示例12: GetFileList

        public IEnumerable<Files> GetFileList(FileRequest request = null)
        {
            request = request ?? new FileRequest();
            using (var dbContext = new ProjectDbContext())
            {
                IQueryable<Files> files = dbContext.Files;


                if (!string.IsNullOrEmpty(request.Name))
                    files = files.Where(u => u.Name.Contains(request.Name));

               
                if (!string.IsNullOrEmpty(request.Type))
                    files = files.Where(u => u.Type.Contains(request.Type));

                return files.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize);
            }
        }
开发者ID:addy002,项目名称:HaoTang,代码行数:18,代码来源:ProjectService.cs


示例13: DeleteInsOverhead

 public void DeleteInsOverhead(List<int> ids)
 {
     using (var dbContext = new ProjectDbContext())
     {
         dbContext.InsOverheads.Where(u => ids.Contains(u.ID)).Delete();
     }
 }
开发者ID:addy002,项目名称:HaoTang,代码行数:7,代码来源:ProjectService.cs


示例14: SaveOverhead

        public void SaveOverhead(Overhead overhead)
        {
            using (var dbContext = new ProjectDbContext())
            {
                var budgets = dbContext.Budgets.ToList();

                if (overhead.ID>0)
                {
                    if (overhead.OverheadTotal > 0)
                    {
                        foreach (var budget in budgets)
                        {
                            if (budget.ProjectID == overhead.ProjectID)
                            {
                                budget.OverheadID = overhead.ID;
                                dbContext.Update<BudgetInfo>(budget);
                            }
                        }
                    }
                    dbContext.Update<Overhead>(overhead);
                }
                else
                {
                    dbContext.Insert<Overhead>(overhead);
                }
            }
        }
开发者ID:addy002,项目名称:HaoTang,代码行数:27,代码来源:ProjectService.cs


示例15: GetInsLaborCostList

 public IEnumerable<InsLaborCost> GetInsLaborCostList(InsLaborCostRequest request = null)
 {
     request = request ?? new InsLaborCostRequest();
     using (var dbContext = new ProjectDbContext())
     {
         IQueryable<InsLaborCost> InsLaborCost = dbContext.InsLaborCosts.Include("ProjectBasedata") ;
        
         //if (!string.IsNullOrEmpty(request.ProjectBasedataID))
             if (request.ProjectBasedataID>0)
             InsLaborCost = InsLaborCost.Where(d => d.ProjectBasedataID == request.ProjectBasedataID);
         
         return InsLaborCost.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize);
     }
 }
开发者ID:addy002,项目名称:HaoTang,代码行数:14,代码来源:ProjectService.cs


示例16: GetInsLaborCost

        public InsLaborCost GetInsLaborCost(int id)
        {
            using (var dbContext = new ProjectDbContext())
            {
                  //dbContext.Find.InsLaborCosts.Where((d => d.ID == id);
                //var q = from L in dbContext.InsLaborCosts
                //        join P in dbContext.ProjectBasedatas on L.ProjectBasedataID equals P.ID
                //        //orderby n.AddTime descending
                //        select L;
                       
                //return q.ToList();
                var model = dbContext.Find<InsLaborCost>(id);
                model.ProjectBasedata = GetProjectBasedata(model.ProjectBasedataID);
                return model;

               
              
            }
        }
开发者ID:addy002,项目名称:HaoTang,代码行数:19,代码来源:ProjectService.cs


示例17: SaveInsBudget

        public void SaveInsBudget(InsBudgetInfo insbudget)
        {
            using (var dbContext = new ProjectDbContext())
            {

                if (insbudget.ID > 0)
                {
                    dbContext.Update<InsBudgetInfo>(insbudget);
                }
                else
                {
                    dbContext.Insert<InsBudgetInfo>(insbudget);
                }
            }
        }
开发者ID:addy002,项目名称:HaoTang,代码行数:15,代码来源:ProjectService.cs


示例18: SaveAccounting

        public void SaveAccounting(Accounting accounting)
        {
            using (var dbContext = new ProjectDbContext())
            {

                if (accounting.ID > 0)
                {

                    dbContext.Update<Accounting>(accounting);
                }
                else
                {
                    dbContext.Insert<Accounting>(accounting);
                }
            }
        }
开发者ID:addy002,项目名称:HaoTang,代码行数:16,代码来源:ProjectService.cs


示例19: GetAccountingList

        public IEnumerable<Accounting> GetAccountingList(AccountingRequest request = null)
        {
            request = request ?? new AccountingRequest();
            using (var dbContext = new ProjectDbContext())
            {
                IQueryable<Accounting> Accounting = dbContext.Accountings;

                if (!string.IsNullOrEmpty(request.Name))
                    Accounting = Accounting.Where(u => u.Name.Contains(request.Name));

                return Accounting.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize);
            }
        }
开发者ID:addy002,项目名称:HaoTang,代码行数:13,代码来源:ProjectService.cs


示例20: SaveInsOverhead

        public void SaveInsOverhead(InsOverhead insoverhead)
        {
            using (var dbContext = new ProjectDbContext())
            {
                //var budgets = dbContext.Budgets.ToList();

                if (insoverhead.ID > 0)
                {
                //    if (overhead.OverheadTotal > 0)
                //    {
                //        foreach (var budget in budgets)
                //        {
                //            if (budget.ProjectID == overhead.ProjectID)
                //            {
                //                budget.OverheadID = overhead.ID;
                //                dbContext.Update<BudgetInfo>(budget);
                //            }
                //        }
                //    }
                    dbContext.Update<InsOverhead>(insoverhead);
                }
                else
                {
                    dbContext.Insert<InsOverhead>(insoverhead);
                }
            }
        }
开发者ID:addy002,项目名称:HaoTang,代码行数:27,代码来源:ProjectService.cs



注:本文中的GMS.Project.DAL.ProjectDbContext类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# NET.GPoint类代码示例发布时间:2022-05-26
下一篇:
C# Repositories.Skill类代码示例发布时间:2022-05-26
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap