/// <summary>
///BLL方法：分页查找数据库中的数据(首页数据为第1页)not in select top...子查询方法[说明：strAccord为数据库列名，strASCorDESC请填写"ASC"或"DESC"]------>返回IEnumerable<T_HR_JCQK>接口数据
/// </summary>
/// <returns></returns>
public IEnumerable <T_HR_JCQK> SelectT_HR_JCQKByPageUsingAdapter(int pageIndex, int pageSize, string strAccord, string strASCorDESC)
{
T_HR_JCQKDAL Td = new T_HR_JCQKDAL();
IEnumerable <T_HR_JCQK> i = Td.SelectT_HR_JCQKByPageUsingAdapter(pageIndex, pageSize, strAccord, strASCorDESC);
return(i);
}
/// <summary>
///BLL方法：模糊查找数据库中符合条件的全部数据------>返回IEnumerable<T_HR_JCQK>接口数据
/// </summary>
/// <returns></returns>
public IEnumerable <T_HR_JCQK> FuzzyQueryByAdapter(bool JCQK_IDIsChecked, string JCQK_ID, bool RIDIsChecked, string RID, bool JCQKIsChecked, string JCQK, bool JCDJIsChecked, string JCDJ, bool JCDWIsChecked, string JCDW, bool JCSJIsChecked, string JCSJ, bool GXRIDIsChecked, string GXRID, bool GXRXMIsChecked, string GXRXM, bool GXLXIsChecked, string GXLX, bool GXYYIsChecked, string GXYY, bool GXSJIsChecked, string GXSJ)
{
T_HR_JCQKDAL Td = new T_HR_JCQKDAL();
IEnumerable <T_HR_JCQK> i = Td.FuzzyQueryByAdapter(JCQK_IDIsChecked, JCQK_ID, RIDIsChecked, RID, JCQKIsChecked, JCQK, JCDJIsChecked, JCDJ, JCDWIsChecked, JCDW, JCSJIsChecked, JCSJ, GXRIDIsChecked, GXRID, GXRXMIsChecked, GXRXM, GXLXIsChecked, GXLX, GXYYIsChecked, GXYY, GXSJIsChecked, GXSJ);
return(i);
}
/// <summary>
///BLL方法：向数据库中增加新一条新的T_HR_JCQK对象数据------>请传入对象，返回首行首列
/// </summary>
/// <returns></returns>
public object Add(T_HR_JCQK model)
{
T_HR_JCQKDAL td = new T_HR_JCQKDAL();
object a = td.Add(model);
return(a);
}
/// <summary>
///BLL方法：查找数据库中的数据条数([例如：select Count(*) from... where "XXX"="YYY"],查询整体数据条数Count(*)请传入"1","1"-->sql语句拼接"where 1=1")------>请传入数据库的列名，数据库的值，返回首行首列
/// </summary>
/// <returns></returns>
public int GetCount(string strDBColumnName, string strSelValue)
{
T_HR_JCQKDAL Td = new T_HR_JCQKDAL();
int c = Td.GetCount(strDBColumnName, strSelValue);
return(c);
}
/// <summary>
///BLL方法：查找数据库中的全部数据------>返回IEnumerable<T_HR_JCQK>接口数据
/// </summary>
/// <returns></returns>
public IEnumerable <T_HR_JCQK> SelectAllByAdapter()
{
T_HR_JCQKDAL Td = new T_HR_JCQKDAL();
IEnumerable <T_HR_JCQK> i = Td.SelectAllByAdapter();
return(i);
}
/// <summary>
///BLL方法：分页查找数据库中的数据(首页数据为第1页)Row_Number开窗函数方法------>根据传入的参数分页查找数据,请传入查找排序的具体依据[说明：strAccord为数据库列名，strASCorDESC请填写"ASC"或"DESC"],返回IEnumerable<T_HR_JCQK>接口数据
/// </summary>
/// <returns></returns>
public IEnumerable <T_HR_JCQK> SelectT_HR_JCQKByPageRow_NumberUsingReader(int pageIndex, int pageSize, string strAccord, string strASCorDESC)
{
T_HR_JCQKDAL Td = new T_HR_JCQKDAL();
return(Td.SelectT_HR_JCQKByPageRow_NumberUsingReader(pageIndex, pageSize, strAccord, strASCorDESC));
}
