/// <summary>
/// 刷新司机数据
/// </summary>
public static async void RefereshDriverInfo()
{
var queryParam = new BaseQueryParam()
{
IsAllowPagging = false
};
await NHttpClientDAL.PostAsync("api/QueryDriverInfoList", queryParam, new HttpResponseHandler((res, context) =>
{
res.ServerDataGetEntityListCommHandler(out ServerDriverinfoList);
}));
}
/*
* /// <summary>
* /// 获取DriverInfo列表
* /// </summary>
* /// <param name="param"></param>
* /// <returns></returns>
* public QueryResult<IList<DriverInfoEntity>> GetDriverInfoList(QueryDriverInfoParams param)
* {
* var session = NHibernateUtil.getSession();
*
* var query2 = session.QueryOver<DriverInfoEntity>();
*
* if (null != param.Fid) query2.And(c => c.Fid == param.Fid.Value);
* if (!string.IsNullOrEmpty(param.FName)) query2.And(Restrictions.Like("Fname", string.Format("%{0}%", param.FName)));
* if (!string.IsNullOrEmpty(param.Fphone)) query2.And(c => c.Fphone1 == param.Fphone);
* if (!string.IsNullOrEmpty(param.Fcert)) query2.And(c => c.FcertID == param.Fcert);
* if (!string.IsNullOrEmpty(param.FdriverNo)) query2.And(c => c.FDriverNo == param.FdriverNo);
* if (null != param.FworkState) query2.And(c => c.FworkState == param.FworkState.Value);
*
* int rawRowCont = query2.RowCount();
*
* QueryHelper.FixQueryTake(param, rawRowCont);
*
* if (null != param.Skip && param.Skip.Value > 0) query2.Skip(param.Skip.Value);
* if (null != param.Take && param.Take.Value > 0) query2.Take(param.Take.Value);
*
* var retList = query2.List();
*
* return new QueryResult<IList<DriverInfoEntity>>(retList, rawRowCont, retList.Count);
* }
*
*
* /// <summary>
* /// 增加DriverInfo
* /// </summary>
* /// <param name="entity"></param>
* public void AddDriverInfo(DriverInfoEntity entity)
* {
* var session = NHibernateUtil.getSession();
* var trans = session.BeginTransaction();
* session.Save(entity);
* trans.Commit();
* }
*
*
* /// <summary>
* /// 增加一个列表
* /// </summary>
* /// <param name="entityList"></param>
* public void AddDriverInfoList(List<DriverInfoEntity> entityList)
* {
* var session = NHibernateUtil.getSession();
* var trans = session.BeginTransaction();
* foreach(var e in entityList)
* {
* session.Save(e);
* }
* trans.Commit();
* }
*
*
* /// <summary>
* /// 更新DriverInfo
* /// </summary>
* /// <param name="entity"></param>
* public void UpdateDriverInfo(DriverInfoEntity entity)
* {
* var session = NHibernateUtil.getSession();
* var trans = session.BeginTransaction();
* session.Update(entity);
* trans.Commit();
* }
*
*
* /// <summary>
* /// 删除DriverInfo
* /// </summary>
* /// <param name="entity"></param>
* public void DelDriverInfo(int entityID)
* {
* SAssert.MustTrue((0 > entityID), string.Format("非法的EntityID={0},Method={1}", entityID, MethodBase.GetCurrentMethod().Name));
*
* var session = NHibernateUtil.getSession();
* var trans = session.BeginTransaction();
* session.Delete(new DriverInfoEntity(entityID));
* trans.Commit();
* }
*
*
* /// <summary>
* /// 软删除数据
* /// </summary>
* /// <param name="entityID"></param>
* public void SoftDelDriverInfo(int entityID)
* {
* var session = NHibernateUtil.getSession();
* var trans = session.BeginTransaction();
*
* var delEntity = session.Get<DriverInfoEntity>(entityID, NHibernate.LockMode.Write);
*
* SAssert.MustTrue((null != delEntity), string.Format("没有找到要修改的Entity,ID={0},Method={1}",entityID,MethodBase.GetCurrentMethod().Name));
*
* if (QueryHelper.IsDataSoftDeleted(delEntity.Fstate))
* {
* // 已经是软删除状态
* return;
* }
*
* delEntity.Fstate = QueryHelper.SOFT_DELETED_FSTATE;
*
* session.Update(delEntity);
*
* trans.Commit();
* }
*/
public override QueryResult <IList <DriverInfoEntity> > GetEntityList(BaseQueryParam param)
{
var queryParam = param as QueryDriverInfoParams;
SAssert.MustTrue((null != queryParam), string.Format("查询参数输入错误，在{0}", MethodBase.GetCurrentMethod().Name));
var session = NHibernateUtil.getSession();
var query2 = session.QueryOver <DriverInfoEntity>();
if (null != queryParam.Fid)
{
query2.And(c => c.Fid == queryParam.Fid.Value);
}
if (!string.IsNullOrEmpty(queryParam.FName))
{
query2.And(Restrictions.Like("Fname", string.Format("%{0}%", queryParam.FName)));
}
if (!string.IsNullOrEmpty(queryParam.Fphone))
{
query2.And(c => c.Fphone1 == queryParam.Fphone);
}
if (!string.IsNullOrEmpty(queryParam.Fcert))
{
query2.And(c => c.FcertID == queryParam.Fcert);
}
if (!string.IsNullOrEmpty(queryParam.FdriverNo))
{
query2.And(c => c.FDriverNo == queryParam.FdriverNo);
}
if (null != queryParam.FworkState)
{
query2.And(c => c.FworkState == queryParam.FworkState.Value);
}
int rawRowCont = query2.RowCount();
QueryHelper.FixQueryTake(param, rawRowCont);
if (null != param.Skip && param.Skip.Value > 0)
{
query2.Skip(param.Skip.Value);
}
if (null != param.Take && param.Take.Value > 0)
{
query2.Take(param.Take.Value);
}
var retList = query2.List();
return(new QueryResult <IList <DriverInfoEntity> >(retList, rawRowCont, retList.Count));
}
/*
* /// <summary>
* /// 获取WharfInfo列表
* /// </summary>
* /// <param name="param"></param>
* /// <returns></returns>
* public QueryResult<IList<WharfInfoEntity>> GetWharfInfoList(QueryWharfInfoParam param)
* {
* var session = NHibernateUtil.getSession();
*
* var query2 = session.QueryOver<WharfInfoEntity>();
*
* if (!string.IsNullOrEmpty(param.Area)) query2.And(Restrictions.Like("Fposition", string.Format("%{0}%", param.Area)));
* if (!string.IsNullOrEmpty(param.Mark)) query2.And(Restrictions.Like("Fmark", string.Format("%{0}%", param.Mark)));
* if (!string.IsNullOrEmpty(param.Alias)) query2.And(Restrictions.Like("Falias", string.Format("%{0}%", param.Alias)));
* if (!string.IsNullOrEmpty(param.WharfName)) query2.And(Restrictions.Like("Fposition", string.Format("%{0}%", param.WharfName)));
*
* int rawRowCont = query2.RowCount();
*
* QueryHelper.FixQueryTake(param, rawRowCont);
*
* if (null != param.Skip && param.Skip.Value > 0) query2.Skip(param.Skip.Value);
* if (null != param.Take && param.Take.Value > 0) query2.Take(param.Take.Value);
*
* var retList = query2.List();
*
* return new QueryResult<IList<WharfInfoEntity>>(retList, rawRowCont, retList.Count);
* }
*
*
* /// <summary>
* /// 增加Entity
* /// </summary>
* /// <param name="entity"></param>
* public void AddWharfInfo(WharfInfoEntity entity)
* {
* var session = NHibernateUtil.getSession();
* var trans = session.BeginTransaction();
* session.Save(entity);
* trans.Commit();
* }
*
*
* /// <summary>
* /// 增加一个列表
* /// </summary>
* /// <param name="entityList"></param>
* public void AddWharfInfoList(List<WharfInfoEntity> entityList)
* {
* var session = NHibernateUtil.getSession();
* var trans = session.BeginTransaction();
* foreach (var e in entityList)
* {
* session.Save(e);
* }
* trans.Commit();
* }
*
*
* /// <summary>
* /// 更新DriverInfo
* /// </summary>
* /// <param name="entity"></param>
* public void UpdateDriverInfo(GoodsInfoEntity entity)
* {
* var session = NHibernateUtil.getSession();
* var trans = session.BeginTransaction();
* session.Update(entity);
* trans.Commit();
* }
*
*
* /// <summary>
* /// 删除DriverInfo
* /// </summary>
* /// <param name="entity"></param>
* public void DelDriverInfo(GoodsInfoEntity entity)
* {
* var session = NHibernateUtil.getSession();
* var trans = session.BeginTransaction();
* session.Delete(entity);
* trans.Commit();
* }
*
* /// <summary>
* /// 删除DriverInfo
* /// </summary>
* /// <param name="entity"></param>
* public void DelDriverInfo(int entityID)
* {
* var session = NHibernateUtil.getSession();
* var trans = session.BeginTransaction();
* session.Delete(new GoodsInfoEntity(entityID));
* trans.Commit();
* }
*/
public override QueryResult <IList <WharfInfoEntity> > GetEntityList(BaseQueryParam param)
{
var queryParam = param as QueryWharfInfoParam;
SAssert.MustTrue((null != queryParam), string.Format("查询参数输入错误，在{0}", MethodBase.GetCurrentMethod().Name));
var session = NHibernateUtil.getSession();
var query2 = session.QueryOver <WharfInfoEntity>();
if (!string.IsNullOrEmpty(queryParam.Area))
{
query2.And(Restrictions.Like("Fposition", string.Format("%{0}%", queryParam.Area)));
}
if (!string.IsNullOrEmpty(queryParam.Mark))
{
query2.And(Restrictions.Like("Fmark", string.Format("%{0}%", queryParam.Mark)));
}
if (!string.IsNullOrEmpty(queryParam.Alias))
{
query2.And(Restrictions.Like("Falias", string.Format("%{0}%", queryParam.Alias)));
}
if (!string.IsNullOrEmpty(queryParam.WharfName))
{
query2.And(Restrictions.Like("Fposition", string.Format("%{0}%", queryParam.WharfName)));
}
int rawRowCont = query2.RowCount();
QueryHelper.FixQueryTake(param, rawRowCont);
if (null != param.Skip && param.Skip.Value > 0)
{
query2.Skip(param.Skip.Value);
}
if (null != param.Take && param.Take.Value > 0)
{
query2.Take(param.Take.Value);
}
var retList = query2.List();
return(new QueryResult <IList <WharfInfoEntity> >(retList, rawRowCont, retList.Count));
}
public IQueryable <UserGroup> LoadSearchData(BaseQueryParam param)
{
//首先第一步先进行过滤
short delNoarml = (short)SS.Platform.OA.Model.Enum.DelFlagEnum.Normal;
//过滤删除的
var temp = DbSession.UserGroupDal.LoadEntities(u => u.DelFlag == delNoarml);
//过滤用户组名搜索的
if (!string.IsNullOrEmpty(param.SName))
{
temp = temp.Where(u => u.Name.Contains(param.SName));
}
//设置总条数
param.Total = temp.Count();
//分页的处理
return(temp.OrderBy(u => u.ID).Skip(param.PageSize * (param.PageIndex - 1)).Take(param.PageSize).AsQueryable());
}
/// <summary>
/// 修正QueryTake参数，不能大于DEFAULT_PRE_QUERY_MAX_COUNT
/// </summary>
/// <param name="param"></param>
/// <param name="allRowCount"></param>
/// <returns></returns>
public static int FixQueryTake(BaseQueryParam param, int allRowCount)
{
int rawRowCont = allRowCount;
if (rawRowCont > QuerySettings.DEFAULT_PRE_QUERY_MAX_COUNT)
{
if (null != param.Skip && param.Skip.Value > 0)
{
if (rawRowCont - param.Skip > QuerySettings.DEFAULT_PRE_QUERY_MAX_COUNT)
{
param.Take = QuerySettings.DEFAULT_PRE_QUERY_MAX_COUNT;
}
}
else
{
param.Take = QuerySettings.DEFAULT_PRE_QUERY_MAX_COUNT;
}
return(param.Take.Value);
}
return(rawRowCont);
}
/// <summary> /// 根据参数查找实体列表 /// </summary> /// <param name="param"></param> /// <returns></returns> public abstract QueryResult <IList <T> > GetEntityList(BaseQueryParam param);
