public ProjectBasedata GetProjectBasedata(int id)
{
using (var dbContext = new ProjectDbContext())
{
return dbContext.Find<ProjectBasedata>(id);
}
}
public BudgetInfo GetBudget(int id)
{
using (var dbContext = new ProjectDbContext())
{
return dbContext.Find<BudgetInfo>(id);
}
}
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 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);
}
}
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 Accounting GetAccounting(int id)
{
using (var dbContext = new ProjectDbContext())
{
return dbContext.Find<Accounting>(id);
}
}
public Overhead GetOverhead(int id)
{
using (var dbContext = new ProjectDbContext())
{
return dbContext.Find<Overhead>(id);
}
}
//-----------------------------------财务管理--------------------------------------------
#region Incomes CURD
public Income GetIncome(int id)
{
using (var dbContext = new ProjectDbContext())
{
return dbContext.Find<Income>(id);
}
}
public MachineryCost GetMachineryCost(int id)
{
using (var dbContext = new ProjectDbContext())
{
return dbContext.Find<MachineryCost>(id);
}
}
public LaborCost GetLaborCost(int id)
{
using (var dbContext = new ProjectDbContext())
{
return dbContext.Find<LaborCost>(id);
}
}
public OfficeCtrl GetOfficeCtrl(int id)
{
using (var dbContext = new ProjectDbContext())
{
return dbContext.Find<OfficeCtrl>(id);
}
}
public ProjectCtrl GetProjectCtrl(int id)
{
using (var dbContext = new ProjectDbContext())
{
return dbContext.Find<ProjectCtrl>(id);
}
}
public Payables GetPayables(int id)
{
using (var dbContext = new ProjectDbContext())
{
return dbContext.Find<Payables>(id);
}
}
//--------------------------资产管理-----------------------------------
#region Files CURD
public Files GetFile(int id)
{
using (var dbContext = new ProjectDbContext())
{
return dbContext.Find<Files>(id);
}
}
public Measure GetMeasure(int id)
{
using (var dbContext = new ProjectDbContext())
{
return dbContext.Find<Measure>(id);
}
}
public Oddments GetOddments(int id)
{
using (var dbContext = new ProjectDbContext())
{
return dbContext.Find<Oddments>(id);
}
}
public Odder GetOdder(int id)
{
using (var dbContext = new ProjectDbContext())
{
return dbContext.Find<Odder>(id);
}
}
