public void DeleteProjectBasedata(List<int> ids) { using (var dbContext = new ProjectDbContext()) { dbContext.ProjectBasedatas.Where(u => ids.Contains(u.ID)).Delete(); } }
public BudgetInfo GetBudget(int id) { using (var dbContext = new ProjectDbContext()) { return dbContext.Find<BudgetInfo>(id); } }
public ProjectBasedata GetProjectBasedata(int id) { using (var dbContext = new ProjectDbContext()) { return dbContext.Find<ProjectBasedata>(id); } }
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); } }
public void SaveProjectBasedata(ProjectBasedata project) { using (var dbContext = new ProjectDbContext()) { if (project.ID>0) { dbContext.Update<ProjectBasedata>(project); } else { dbContext.Insert<ProjectBasedata>(project); } } }
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); } }
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); } }
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); } }
public Accounting GetAccounting(int id) { using (var dbContext = new ProjectDbContext()) { return dbContext.Find<Accounting>(id); } }
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); } }
public void DeleteFile(List<int> ids) { using (var dbContext = new ProjectDbContext()) { dbContext.Files.Where(u => ids.Contains(u.ID)).Delete(); } }
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); } }
public void DeleteInsOverhead(List<int> ids) { using (var dbContext = new ProjectDbContext()) { dbContext.InsOverheads.Where(u => ids.Contains(u.ID)).Delete(); } }
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); } } }
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); } }
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; } }
public void SaveInsBudget(InsBudgetInfo insbudget) { using (var dbContext = new ProjectDbContext()) { if (insbudget.ID > 0) { dbContext.Update<InsBudgetInfo>(insbudget); } else { dbContext.Insert<InsBudgetInfo>(insbudget); } } }
public void SaveAccounting(Accounting accounting) { using (var dbContext = new ProjectDbContext()) { if (accounting.ID > 0) { dbContext.Update<Accounting>(accounting); } else { dbContext.Insert<Accounting>(accounting); } } }
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); } }
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); } } }
public void SaveBudget(BudgetInfo budget) { using (var dbContext = new ProjectDbContext()) { if (budget.ID >0) { dbContext.Update<BudgetInfo>(budget); } else { dbContext.Insert<BudgetInfo>(budget); } } }
public InsMachineryCost GetInsMachineryCost(int id) { using (var dbContext = new ProjectDbContext()) { var model = dbContext.Find<InsMachineryCost>(id); model.ProjectBasedata = GetProjectBasedata(model.ProjectBasedataID); return model; //return dbContext.Find<InsMachineryCost>(id); } }
//--------------------------资产管理----------------------------------- #region Files CURD public Files GetFile(int id) { using (var dbContext = new ProjectDbContext()) { return dbContext.Find<Files>(id); } }
public void SaveInsMachineryCost(InsMachineryCost insmachinerycost) { using (var dbContext = new ProjectDbContext()) { if (insmachinerycost.ID > 0) { //var budgets = dbContext.Budgets.ToList(); //if (machinerycost.MachineryTotal > 0) //{ // foreach (var budget in budgets) // { // if (budget.ProjectID == machinerycost.ProjectID) // { // budget.MachineryCostID = machinerycost.ID; // dbContext.Update<BudgetInfo>(budget); // } // } //} dbContext.Update<InsMachineryCost>(insmachinerycost); } else { dbContext.Insert<InsMachineryCost>(insmachinerycost); } } }
public void SaveFile(Files file) { using (var dbContext = new ProjectDbContext()) { if (file.ID > 0) { dbContext.Update<Files>(file); } else { dbContext.Insert<Files>(file); } } }
public void DeleteInsMachineryCost(List<int> ids) { using (var dbContext = new ProjectDbContext()) { dbContext.InsMachineryCosts.Where(u => ids.Contains(u.ID)).Delete(); } }
public Oddments GetOddments(int id) { using (var dbContext = new ProjectDbContext()) { return dbContext.Find<Oddments>(id); } }
public void SaveInsMeasure(InsMeasure insmeasure) { using (var dbContext = new ProjectDbContext()) { if (insmeasure.ID > 0) { //var budgets = dbContext.Budgets.ToList(); //if (measure.MeasureTotal > 0) //{ // foreach (var budget in budgets) // { // if (budget.ProjectID == measure.ProjectID) // { // budget.MeasureID = measure.ID; // dbContext.Update<BudgetInfo>(budget); // } // } //} dbContext.Update<InsMeasure>(insmeasure); } else { dbContext.Insert<InsMeasure>(insmeasure); } } }
public void SaveOddments(Oddments oddments) { using (var dbContext = new ProjectDbContext()) { if (oddments.ID > 0) { dbContext.Update<Oddments>(oddments); } else { dbContext.Insert<Oddments>(oddments); } } }
public void DeleteAccountant(List<int> ids) { using (var dbContext = new ProjectDbContext()) { dbContext.Accountants.Where(u => ids.Contains(u.ID)).Delete(); } }