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();
}
}