//--------------------------资产管理-----------------------------------
#region Files CURD
public Files GetFile(int id)
{
using (var dbContext = new ProjectDbContext())
{
return(dbContext.Find <Files>(id));
}
}
public Payables GetPayables(int id)
{
using (var dbContext = new ProjectDbContext())
{
return(dbContext.Find <Payables>(id));
}
}
public BudgetInfo GetBudget(int id)
{
using (var dbContext = new ProjectDbContext())
{
return(dbContext.Find <BudgetInfo>(id));
}
}
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 Measure GetMeasure(int id)
{
using (var dbContext = new ProjectDbContext())
{
return(dbContext.Find <Measure>(id));
}
}
public ProjectBasedata GetProjectBasedata(int id)
{
using (var dbContext = new ProjectDbContext())
{
return(dbContext.Find <ProjectBasedata>(id));
}
}
public OfficeCtrl GetOfficeCtrl(int id)
{
using (var dbContext = new ProjectDbContext())
{
return(dbContext.Find <OfficeCtrl>(id));
}
}
public LaborCost GetLaborCost(int id)
{
using (var dbContext = new ProjectDbContext())
{
return(dbContext.Find <LaborCost>(id));
}
}
//#region ProjectCtrl CURD
//public ProjectCtrl GetProjectCtrl(int id)
//{
// using (var dbContext = new ProjectDbContext())
// {
// return dbContext.Find<ProjectCtrl>(id);
// }
//}
//public IEnumerable<ProjectCtrl> GetProjectCtrlList(ProjectCtrlRequest request = null)
//{
// request = request ?? new ProjectCtrlRequest();
// using (var dbContext = new ProjectDbContext())
// {
// IQueryable<ProjectCtrl> projects = dbContext.ProjectCtrls;
// if (!string.IsNullOrEmpty(request.Name))
// projects = projects.Where(u => u.Name.Contains(request.Name));
// //if (!string.IsNullOrEmpty(request.Stuffname))
// // projects = projects.Where(u => u.Stuffname.Contains(request.Stuffname));
// //if (!string.IsNullOrEmpty(request.obb))
// // projects = projects.Where(u => u.obb.Contains(request.obb));
// //if (!string.IsNullOrEmpty(request.Way))
// // projects = projects.Where(u => u.Way.Contains(request.Way));
// return projects.OrderByDescending(u => u.ID).ToPagedList(request.PageIndex, request.PageSize);
// }
//}
//public void SaveProjectCtrl(ProjectCtrl project)
//{
// using (var dbContext = new ProjectDbContext())
// {
// if (project.ID > 0)
// {
// dbContext.Update<ProjectCtrl>(project);
// }
// else
// {
// dbContext.Insert<ProjectCtrl>(project);
// }
// }
//}
//public void DeleteProjectCtrl(List<int> ids)
//{
// using (var dbContext = new ProjectDbContext())
// {
// dbContext.ProjectCtrls.Where(u => ids.Contains(u.ID)).Delete();
// }
//}
//#endregion
#region ProjectCtrl CURD
public ProjectCtrl GetProjectCtrl(int id)
{
using (var dbContext = new ProjectDbContext())
{
return(dbContext.Find <ProjectCtrl>(id));
}
}
public Oddments GetOddments(int id)
{
using (var dbContext = new ProjectDbContext())
{
return(dbContext.Find <Oddments>(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);
}
}
