/// <summary>
/// 获取数据列表(明细)
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public DataTable GetItemGridJson(UserCostRequest request)
{
var data = Db.Context.From <TbUserCostItem>().Select(
TbUserCostItem._.ID,
TbUserCostItem._.MachinType,
TbUserCostItem._.MachinNumber,
TbUserCostItem._.Days,
TbUserCostItem._.Price,
TbUserCostItem._.TotalPrice)
.Where(p => p.CheckCode == request.CheckCode)
.ToDataTable();
return(data);
}
/// <summary>
/// 获取班组模板
/// </summary>
public DataTable GetUserCostDataList(UserCostRequest request)
{
var where = new Where <TbSysDictionaryData>();
if (!string.IsNullOrWhiteSpace(request.keyword))
{
where.And(d => d.DictionaryText.Like(request.keyword) || d.DictionaryOrder.Like(request.keyword));
}
where.And(p => p.FDictionaryCode == "UserCost");
try
{
var data = Db.Context.From <TbSysDictionaryData>()
.Select(
TbSysDictionaryData._.id
, TbSysDictionaryData._.DictionaryCode.As("MachinType")
, TbSysDictionaryData._.DictionaryText.As("Price"))
.Where(where)
.ToDataTable();
return(data);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获取班组模板
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetUserCostDataList(UserCostRequest request)
{
var data = _userCost.GetUserCostDataList(request);
return(Content(data.ToJson()));
}
/// <summary>
/// 获取分页列表数据（明细）
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetItemGridJson(UserCostRequest request)
{
var data = _userCost.GetItemGridJson(request);
return(Content(data.ToJson()));
}
/// <summary>
/// 获取分页列表数据
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetGridJson(UserCostRequest request)
{
var data = _userCost.GetDataListForPage(request);
return(Content(data.ToJson()));
}
/// <summary>
/// 获取数据列表(分页)
/// </summary>
public PageModel GetDataListForPage(UserCostRequest request)
{
#region 模糊搜索条件
var where = new Where <TbUserCost>();
if (!string.IsNullOrWhiteSpace(request.CheckCode))
{
where.And(d => d.CheckCode == request.CheckCode);
}
if (!string.IsNullOrWhiteSpace(request.ProcessFactoryCode))
{
where.And(d => d.ProcessFactoryCode == request.ProcessFactoryCode);
}
if (!string.IsNullOrWhiteSpace(request.SiteCode))
{
//where.And(d => d.SiteCode == request.SiteCode);
List <string> SiteList = _workOrderLogic.GetCompanyWorkAreaOrSiteList(request.SiteCode, 5);
where.And(p => p.SiteCode.In(SiteList));
}
#endregion
#region 数据权限
////数据权限
//var authorizaModel = new AuthorizeLogic().CheckAuthoriza(new AuthorizationParameterModel("UserCost"));
//if (authorizaModel.IsAuthorize)
//{
// if (authorizaModel.Ids.Count > 0 && authorizaModel.UserCodes.Count > 0)
// where.And(d => d.InsertUserCode.In(authorizaModel.UserCodes) || d.ID.In(authorizaModel.Ids));
// else if (authorizaModel.Ids.Count > 0)
// where.Or(d => d.ID.In(authorizaModel.Ids));
// else if (authorizaModel.UserCodes.Count > 0)
// where.And(d => d.InsertUserCode.In(authorizaModel.UserCodes));
//}
if (!string.IsNullOrEmpty(request.ProjectId))
{
where.And(p => p.ProjectId == request.ProjectId);
}
#endregion
try
{
var data = Db.Context.From <TbUserCost>()
.Select(
TbUserCost._.ID
, TbUserCost._.Examinestatus
, TbUserCost._.CheckCode
, TbUserCost._.OrderCode
, TbUserCost._.TypeCode
, TbUserCost._.TypeName
, TbUserCost._.UsePart
, TbUserCost._.TotalAmount
, TbUserCost._.InsertUserCode
, TbUserCost._.InsertTime
, TbUserCost._.ProjectId
, TbUser._.UserName
, TbCompany._.CompanyFullName.As("ProcessFactoryName"))
.AddSelect(Db.Context.From <TbCompany>()
.Select(p => p.CompanyFullName)
.Where(TbCompany._.CompanyCode == TbUserCost._.SiteCode), "SiteName")
.LeftJoin <TbUser>((a, c) => a.InsertUserCode == c.UserCode)
.LeftJoin <TbCompany>((a, c) => a.ProcessFactoryCode == c.CompanyCode)
.Where(where)
.OrderByDescending(p => p.ID)
.ToPageList(request.rows, request.page);
return(data);
}
catch (Exception)
{
throw;
}
}
