/// <summary>
/// 根据发放名、发放内容获取福利发放信息
/// </summary>
/// <param name="WelfareProvisionName">福利发放名</param>
/// <param name="strContent">发放内容</param>
/// <returns></returns>
public List <V_WelfareProvision> GetWelfareProvisionRoomInfosListBySearch(string WelfareProvisionName, string strContent)
{
try
{
WelfareProvision wp = new WelfareProvision();
var q = from p in dal.GetTable().ToList()
select new V_WelfareProvision {
welfareProvision = p
};
if (!string.IsNullOrEmpty(WelfareProvisionName))
{
q = q.Where(s => WelfareProvisionName.Contains(s.welfareProvision.WELFAREDISTRIBUTETITLE));
}
if (!string.IsNullOrEmpty(strContent))
{
q = q.Where(s => s.welfareProvision.CONTENT.Contains(strContent));
}
if (q.Count() > 0)
{
return(q.ToList());
}
return(null);
}
catch (Exception ex)
{
Tracer.Debug("福利标准WelfareProvisionBLL-GetWelfareProvisionRoomInfosListBySearch" + System.DateTime.Now.ToString() + " " + ex.ToString());
return(null);
}
}
/// <summary>
/// 根据发放ID获取福利发放信息
/// </summary>
/// <param name="WelfareID">申请ID</param>
/// <returns>返回结果</returns>
public T_OA_WELFAREDISTRIBUTEMASTER GetWelfareProvisionById(string WelfareProvisionID)
{
WelfareProvision wp = new WelfareProvision();
var ents = from a in dal.GetObjects()
where a.WELFAREDISTRIBUTEMASTERID == WelfareProvisionID
select a;
return(ents.Count() > 0 ? ents.FirstOrDefault() : null);
}
/// <summary>
/// 获取所有的福利发放信息
/// </summary>
/// <returns>返回结果</returns>
public IQueryable <T_OA_WELFAREDISTRIBUTEMASTER> GetWelfareProvisionStandard()
{
WelfareProvision wp = new WelfareProvision();
var entity = from p in wp.GetTable()
orderby p.CREATEDATE descending
select p;
return(entity.Count() > 0 ? entity : null);
}
/// <summary>
/// 获取福利发放信息
/// </summary>
/// <returns></returns>
public List <T_OA_WELFAREDISTRIBUTEMASTER> GetWelfareRooms()
{
WelfareProvision wp = new WelfareProvision();
var query = from p in wp.GetTable()
orderby p.CREATEDATE descending
select p;
return(query.ToList <T_OA_WELFAREDISTRIBUTEMASTER>());
}
public List <string> GetWelfareProvisionRoomNameInfos()
{
WelfareProvision wp = new WelfareProvision();
var query = from p in wp.GetTable()
orderby p.CREATEDATE descending
select p.WELFAREDISTRIBUTETITLE;
return(query.ToList <string>());
}
/// <summary>
/// 获取用户福利发放的申请记录
/// </summary>
/// <param name="userID">用户ID</param>
/// <param name="searchObj"></param>
/// <param name="flowInfoList"></param>
/// <param name="checkState">状态</param>
/// <returns></returns>
public List <V_WelfareProvision> GetWelfareProvisionInfo(int pageIndex, int pageSize, string sort, string filterString, IList <object> paras, ref int pageCount, List <V_FlowAPP> flowInfoList, string checkState, string userID)
{
try
{
WelfareProvision wp = new WelfareProvision();
var ents = from p in dal.GetObjects()
select new V_WelfareProvision
{
welfareProvision = p,
OWNERCOMPANYID = p.OWNERCOMPANYID,
OWNERID = p.OWNERID,
OWNERPOSTID = p.OWNERPOSTID,
OWNERDEPARTMENTID = p.OWNERDEPARTMENTID,
CREATEUSERID = p.CREATEUSERID
};
if (ents.Count() > 0)
{
if (flowInfoList != null)
{
ents = (from a in ents.ToList().AsQueryable()
join l in flowInfoList on a.welfareProvision.WELFAREDISTRIBUTEMASTERID equals l.FormID
select new V_WelfareProvision
{
welfareProvision = a.welfareProvision,
OWNERCOMPANYID = a.OWNERCOMPANYID,
OWNERID = a.OWNERID,
OWNERPOSTID = a.OWNERPOSTID,
OWNERDEPARTMENTID = a.OWNERDEPARTMENTID,
CREATEUSERID = a.CREATEUSERID
});
}
if (!string.IsNullOrEmpty(checkState))
{
ents = ents.Where(s => checkState == s.welfareProvision.CHECKSTATE);
}
List <object> queryParas = new List <object>();
queryParas.AddRange(paras);
UtilityClass.SetOrganizationFilter(ref filterString, ref queryParas, userID, "T_OA_WELFAREDISTRIBUTEMASTER");
if (!string.IsNullOrEmpty(filterString))
{
ents = ents.ToList().AsQueryable().Where(filterString, queryParas.ToArray());
}
ents = ents.AsQueryable().OrderBy(sort);
ents = Utility.Pager <V_WelfareProvision>(ents.AsQueryable(), pageIndex, pageSize, ref pageCount);
return(ents.ToList());
}
return(null);
}
catch (Exception ex)
{
return(null);
}
}
public IQueryable <V_WelfareProvision> GetWelfareProvisionInfoById(string lendingID)
{
WelfareProvision wp = new WelfareProvision();
var ents = from a in dal.GetObjects()
join b in dal.GetObjects <T_OA_WELFAREMASERT>() on a.WELFAREDISTRIBUTEMASTERID equals b.WELFAREID
where b.WELFAREID == lendingID
select new V_WelfareProvision {
welfareProvision = a
};
if (ents.Count() > 0)
{
return(ents);
}
return(null);
}
