public IList <vCustomer> SearchListByAutoName(string keyword, int limit, Guid wId) { var szServices = new DbHelperEfSql <vCustomer>(); var iTotalRecord = 0; if (!string.IsNullOrEmpty(keyword)) { return(szServices.SearchByPageCondition(c => c.CustomerName.Contains(keyword) && c.IsValid == 1 && c.WelfareCentreID == wId, true, c => c.CustomerName, 0, limit, ref iTotalRecord)); } else { return(szServices.SearchByPageCondition(c => c.IsValid == 1 && c.WelfareCentreID == wId, true, c => c.CustomerName, 0, limit, ref iTotalRecord)); } }
public IList <vCustomer> SearchListByAuto(string keyword, int limit, int isStage) { var szServices = new DbHelperEfSql <vCustomer>(); var iTotalRecord = 0; if (!string.IsNullOrEmpty(keyword)) { return(szServices.SearchByPageCondition(c => c.CustomerName.Contains(keyword) && c.Stage == isStage && c.IsValid == 1, true, c => c.CustomerName, 0, limit, ref iTotalRecord)); } else { return(szServices.SearchByPageCondition(c => c.Stage == isStage && c.IsValid == 1, true, c => c.CustomerName, 0, limit, ref iTotalRecord)); } }
//姓名下拉 public IList <tbOrgTLJGCongYe> SearchListByAuto(string keyword, int limit) { var szServices = new DbHelperEfSql <tbOrgTLJGCongYe>(); var iTotalRecord = 0; if (!string.IsNullOrEmpty(keyword)) { return(szServices.SearchByPageCondition(c => c.StaffName.Contains(keyword) && c.IsValid == 1, true, c => c.StaffName, 0, limit, ref iTotalRecord)); } else { return(szServices.SearchByPageCondition(c => c.IsValid == 1, true, c => c.StaffName, 0, limit, ref iTotalRecord)); } }
public IList <tbOrganization> SearchByPageCondition(int iPageIndex, int iPageSize, ref int iTotalRecord, ConditionModel conditionModel) { var szSrevices = new DbHelperEfSql <tbOrganization>(); return(szSrevices.SearchByPageCondition(iPageIndex, iPageSize, ref iTotalRecord, conditionModel)); }
public IList <AuthNodeButton> SearchByPageCondition(int iPageIndex, int iPageSize, ref int iTotalRecord, ConditionModel conditionModel) { var szServices = new DbHelperEfSql <AuthNodeButton>(); return(szServices.SearchByPageCondition(iPageIndex, iPageSize, ref iTotalRecord, conditionModel)); }
public IList <Log4net> SearchChargeSituationInfoByPageCondition(int iPageIndex, int iPageSize, ref int iTotalRecord, ConditionModel conditionModel) { var szServices = new DbHelperEfSql <Log4net>(); return(szServices.SearchByPageCondition(iPageIndex, iPageSize, ref iTotalRecord, conditionModel)); }
/// <summary> /// 根据查询对象分页获取记录 /// </summary> /// <param name="iPageIndex"></param> /// <param name="iPageSize"></param> /// <param name="iTotalRecord"></param> /// <param name="conditionItem"></param> /// <returns></returns> public IList <V_ConstructionProject_Dept> GetPageListByCondition(int iPageIndex, int iPageSize, ref int iTotalRecord, ConditionModel conditionItem) { var service = new DbHelperEfSql <V_ConstructionProject_Dept>(); return(service.SearchByPageCondition(iPageIndex, iPageSize, ref iTotalRecord, conditionItem)); }
/// <summary> /// 根据查询对象分页获取记录td_Network_1 /// </summary> /// <param name="iPageIndex"></param> /// <param name="iPageSize"></param> /// <param name="iTotalRecord"></param> /// <param name="conditionItem"></param> /// <returns></returns> public IList <td_Network_1> GetPageListByCondition1(int iPageIndex, int iPageSize, ref int iTotalRecord, ConditionModel conditionItem) { var service = new DbHelperEfSql <td_Network_1>(); return(service.SearchByPageCondition(iPageIndex, iPageSize, ref iTotalRecord, conditionItem)); }
public IList <vCustomer> GetCustomerByInfo(int iPageIndex, int iPageSize, ref int iTotalRecord, ConditionModel conditionModel) { var szSrevices = new DbHelperEfSql <vCustomer>(); return(szSrevices.SearchByPageCondition(iPageIndex, iPageSize, ref iTotalRecord, conditionModel)); }
public IList <Nodes> SearchByPageCondition(int iPageIndex, int iPageSize, ref int iTotalRecord) { var szServices = new DbHelperEfSql <Nodes>(); return(szServices.SearchByPageCondition(true, c => c.NodeId, iPageIndex, iPageSize, ref iTotalRecord)); }
public IList <Roles> SearchByPageCondition(int iPageIndex, int iPageSize, ref int iTotalRecord) { var szServices = new DbHelperEfSql <Roles>(); return(szServices.SearchByPageCondition(false, c => c.OperateDate, iPageIndex, iPageSize, ref iTotalRecord)); }