/// <summary>
/// 获得数据List
/// </summary>
public LeaveTypeArray GetLeaveTypesDataList()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * FROM VIEW_LeaveMgr_AllLeaveTypes");
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString()).Tables[0];
LeaveTypeArray list = new LeaveTypeArray();
foreach (DataRow dr in dt.Rows)
{
LeaveType _LeaveMgr_LeaveType = new LeaveType();
LeaveTypeDataRowToModel(_LeaveMgr_LeaveType, dr);
list.Add(_LeaveMgr_LeaveType);
}
return(list);
}
/// <summary>
/// 获得数据List
/// </summary>
public LeaveTypeArray GetLeaveTypeDataList(string strTypeName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * FROM VIEW_LeaveMgr_AllLeaveTypes where strTypeName like @strTypeName");
SqlParameter[] sqlParams =
{
new SqlParameter("strTypeName", "%" + strTypeName + "%")
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
LeaveTypeArray list = new LeaveTypeArray();
if (dt.Rows.Count > 0)
{
LeaveType _LeaveMgr_LeaveType = new LeaveType();
LeaveTypeDataRowToModel(_LeaveMgr_LeaveType, dt.Rows[0]);
list.Add(_LeaveMgr_LeaveType);
}
return(list);
}