/// <summary>
/// 查询
/// </summary>
private void DoSelect()
{
string CorpId = string.Empty;
string where = string.Empty;
var UsrEnt = SysUser.Find(UserInfo.UserID);
CommPowerSplit ps = new CommPowerSplit();
if (ps.IsNoticeRole(UserInfo.UserID, UserInfo.LoginName))
{
where += " (WorkFlowState='1' or WorkFlowState='2' or WorkFlowState='-1') ";
if (!string.IsNullOrEmpty(SearchCriterion.GetSearchValue("Year") + ""))
{
where += " and year(ApplyTime)= " + SearchCriterion.GetSearchValue("Year") + " ";
}
SearchCriterion.RemoveSearch("Year");
ents = UsrTravelWelfare.FindAll(SearchCriterion, Expression.Sql(where));
this.PageState.Add("UsrTravelWelfareList", ents);
}
else
{
// 判断公司登陆
UserContextInfo UC = new UserContextInfo();
CorpId = UC.GetUserCurrentCorpId(UserInfo.UserID);
//SearchCriterion.AddSearch("CompanyId", CorpId);
where += " (WorkFlowState='1' or WorkFlowState='2' or WorkFlowState='-1') " + AppealUsrAuth();
if (!string.IsNullOrEmpty(SearchCriterion.GetSearchValue("Year") + ""))
{
where += " and year(ApplyTime)= " + SearchCriterion.GetSearchValue("Year") + " ";
}
SearchCriterion.RemoveSearch("Year");
SearchCriterion.SetOrder("CompanyId", true);
ents = UsrTravelWelfare.FindAll(SearchCriterion, Expression.Sql(where));
this.PageState.Add("UsrTravelWelfareList", ents);
}
}
/// <summary>
/// 查询
/// </summary>
private void DoSelect()
{
SearchCriterion.AddSearch("UserId", UserInfo.UserID);
ents = UsrTravelWelfare.FindAll(SearchCriterion);
this.PageState.Add("UsrTravelWelfareList", ents);
}