/// <summary>
/// 获取指列的DataTable结果集
/// </summary>
/// <param name="top">前top条记录</param>
/// <param name="strWhere">过滤条件</param>
/// <param name="columList">列</param>
/// <returns></returns>
public DataTable GetDataTable(int top, string strWhere, params string[] columList)
{
//StringBuilder sb = new StringBuilder();
//sb.Append("SELECT checkItemId,HolesIndex,IsShowOnData,IsDouble FROM tHolesSetting ");
//if (strWhere != null && strWhere.Length > 0)
//{
// sb.Append(" WHERE ");
// sb.Append(strWhere);
//}
return(DataBase.GetColumnList("tHolesSetting", top, strWhere, columList));
}
/// <summary>
/// 通过用户名设置各用户所能操作的菜单
/// </summary>
/// <param name="userName">用户登记名</param>
/// <returns></returns>
public System.Collections.Hashtable IsMenuRight()//, string assetCode
{
System.Collections.Hashtable htbl = new System.Collections.Hashtable();
DataTable dtbl = DataBase.GetColumnList("tMachine", 0, "IsShow=true", "SysCode,IsShow");
//List<NDYLib.Model.Sys_Right> list = GetModelList(string.Format("UserName='******'", userName));
if (dtbl != null && dtbl.Rows.Count > 0)
{
for (int i = 0; i < dtbl.Rows.Count; i++)
{
//v = Convert.ToBoolean(dtbl.Rows[i]["IsShow"]);
htbl.Add(dtbl.Rows[i]["SysCode"], dtbl.Rows[i]["IsShow"]);
}
dtbl.Dispose();
dtbl = null;
}
return(htbl);
}
/// <summary>
/// 获取指定列指定结果集结果集
/// 作者：
/// </summary>
/// <param name="top">表示前N个记录，小于等于0表示"*"</param>
/// <param name="strWhere">过滤条件组合串，输入字符串中不能包含where关键字，需要排序时在条件后加 order by</param>
/// <param name="columns">表示1个或者多个字段字符串，多个字段之间用","隔开如： "ID,Name,Value,...."</param>
/// <returns>返回结果集</returns>
public DataTable GetColumnDataTable(int top, string strWhere, params string[] columns)
{
return(DataBase.GetColumnList("tMachine", top, strWhere, columns));
}
