/// <summary>
/// 查询
/// </summary>
private void DoSelect()
{
string where = string.Empty;
foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches)
{
if (!String.IsNullOrEmpty(item.Value.ToString()))
{
switch (item.PropertyName)
{
case "CreateTime":
where += " year(CreateTime)=" + item.Value + " ";
break;
}
}
}
SearchCriterion.RemoveSearch("CreateTime");
SearchCriterion.SetOrder(TravelMoneyConfig.Prop_Corp); //公司
SearchCriterion.SetOrder(TravelMoneyConfig.Prop_Indutydate, true); //日期
CommPowerSplit PS = new CommPowerSplit();
SysUser UsrEnt = SysUser.Find(UserInfo.UserID);
if (PS.TraveMoneyConfig(UserInfo.UserID, UserInfo.LoginName)) //总部HR权限 HR1
{
if (!string.IsNullOrEmpty(where))
{
ents = TravelMoneyConfig.FindAll(SearchCriterion, Expression.Sql(where));
this.PageState.Add("TravelMoneyConfigList", ents);
}
else
{
ents = TravelMoneyConfig.FindAll(SearchCriterion);
this.PageState.Add("TravelMoneyConfigList", ents);
}
}
else
{
//公司权限
UserContextInfo UC = new UserContextInfo();
SearchCriterion.SetSearch(TravelMoneyConfig.Prop_Corp, UC.GetUserCurrentCorpId(UserInfo.UserID));
if (!string.IsNullOrEmpty(where))
{
ents = TravelMoneyConfig.FindAll(SearchCriterion, Expression.Sql(where));
this.PageState.Add("TravelMoneyConfigList", ents);
}
else
{
ents = TravelMoneyConfig.FindAll(SearchCriterion);
this.PageState.Add("TravelMoneyConfigList", ents);
}
}
}
/// <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()
{
if (SearchCriterion.Orders.Count == 0)
{
if (!SearchCriterion.Orders.Exists(en => en.PropertyName == "CreateTime"))
{
SearchCriterion.Orders.Add(new OrderCriterionItem("CreateTime", false));
}
}
string type = "all";
foreach (CommonSearchCriterionItem sear in SearchCriterion.Searches.Searches)
{
if (sear.PropertyName == "Name" && sear.Value + "" != "")
{
type = "Logistic";
}
else if ((sear.PropertyName == "CName" && sear.Value + "" != "") || (sear.PropertyName == "Number" && sear.Value + "" != ""))
{
type = "Order";
}
}
string did = RequestData.Get <string>("did");
if (type == "all" || type == "Logistic" || !string.IsNullOrEmpty(did))
{
//if (!string.IsNullOrEmpty(did))
//{
// SearchCriterion.Searches.Clear();
//}
ents = Logistic.FindAll(SearchCriterion, Expression.Sql(" charindex('" + did + "',DeliveryId)>0 "));
//if (ents.Count == 0 && !string.IsNullOrEmpty(did))
//{
// DeliveryOrder doent = DeliveryOrder.TryFind(did);
// if (doent != null)
// {
// ents = Logistic.FindAll(SearchCriterion, Expression.Eq("CustomerId", doent.CId));
// }
//}
this.PageState.Add("LogisticList", ents);
}
if (type == "all" || type == "Order")
{
string wtype = RequestData.Get <string>("wtype");
ICriterion crit = null;
if (wtype == "1")
{
SearchCriterion.AddSearch("LogisticState", "已填写");
}
else
{
crit = Expression.Or(Expression.Sql(" LogisticState <> '已填写' "), Expression.IsNull("LogisticState"));
}
SearchCriterion.AddSearch("State", "已出库");
DeliveryOrder[] ents2 = DeliveryOrder.FindAll(SearchCriterion, crit);
this.PageState.Add("OrderList", ents2);
SearchCriterion.RemoveSearch("State");
}
}
