//根据Grid每页显示多少条记录返回所有角色信息
public DataTable GetAllRole(int sCount, int eCount)
{
DataTable dt = null;
string[] cName = new string[] { "ID_KEY", "T_GRPID", "T_GRPDESC" };
dt = dl.GetS2Enotes("T_SYS_GROUP", cName, "ID_KEY", sCount, eCount);
return(dt);
}
/// <summary>
/// 根据每页显示多少条数据返回角色信息
/// 创建：李东峰 日期：2014-03-11
/// </summary>
/// <param name="sCount">起始条数</param>
/// <param name="eCount">结束条数</param>
/// <returns>返回查询结果集</returns>
public DataTable GetRoleByStartToEnd(int sCount, int eCount)
{
DataTable _dt = null;
string[] cName = new string[] { "ID_KEY", "T_GRPID", "T_GRPDESC" };
_dt = dl.GetS2Enotes("T_SYS_GROUP", cName, "ID_KEY", sCount, eCount);
return(_dt);
}
/// <summary>
/// 根据起始条数和结束条数显示班次信息
/// 创建：李东峰 日期：2014-03-13
/// </summary>
/// <param name="sCount">起始条数</param>
/// <param name="eCount">结束条数</param>
/// <returns>返回查询结果集</returns>
public DataTable GetShiftByStartToEnd(int sCount, int eCount)
{
string[] cName = new string[] { "ID_KEY", "T_SHIFTNAME", "T_SHIFTID", "D_STARTTIME", "D_ENDTIME" };
DataTable _dt = null;
try
{
_dt = dl.GetS2Enotes("T_SYS_SHIFTINFO", cName, "ID_KEY", sCount, eCount);
}
catch (Exception ex)
{
LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间：" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息：" + ex.Message);
}
return(_dt);
}