public WindowInfoData GetRoleMainWindowInfo(string roleId)
{
SQL sql = SqlHelper.CreateSQL("查询角色主窗体信息", "select b.窗体ID,b.窗体名称,b.分组标记,b.版本,b.窗体信息 " +
" from 影像角色信息 a, 影像窗体信息 b " +
" where a.窗体id = b.窗体id and a.角色id =:角色ID");
sql.AddParameter("角色ID", DbType.String, roleId);
DataTable dtWindow = _dbHelper.ExecuteSQL(sql);
if (dtWindow == null || dtWindow.Rows.Count <= 0)
{
return(null);
}
WindowInfoData windowInfo = new WindowInfoData();
windowInfo.BindRowData(dtWindow.Rows[0]);
return(windowInfo);
}
/// <summary>
/// 根据名称获取窗体信息
/// </summary>
/// <param name="windowName"></param>
/// <param name="departmentId"></param>
/// <returns></returns>
public WindowInfoData GetWindowInfoByName(string windowName, string departmentId)
{
SQL sql = SqlHelper.CreateSQL("根据窗体名称查询窗体信息", "select 窗体ID,窗体名称,分组标记,版本,窗体信息 " +
" from 影像窗体信息" +
" where 科室id =:科室ID and 窗体名称=:窗体名称");
sql.AddParameter("科室id", DbType.String, departmentId);
sql.AddParameter("窗体名称", DbType.String, windowName);
DataTable dtWindow = _dbHelper.ExecuteSQL(sql);
if (dtWindow == null || dtWindow.Rows.Count <= 0)
{
return(null);
}
WindowInfoData windowInfo = new WindowInfoData();
windowInfo.BindRowData(dtWindow.Rows[0]);
return(windowInfo);
}