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));
}
