private SqlParamInfo[] GetWindowInfoPars(WindowInfoData roleWindowInfo) { return(new SqlParamInfo[] { new SqlParamInfo("窗体ID", DbType.String, roleWindowInfo.窗体ID), new SqlParamInfo("科室ID", DbType.String, roleWindowInfo.科室ID), new SqlParamInfo("窗体名称", DbType.String, roleWindowInfo.窗体名称), new SqlParamInfo("分组标记", DbType.String, roleWindowInfo.分组标记), new SqlParamInfo("窗体信息", DbType.String, roleWindowInfo.窗体信息.ToString()) }); }
/// <summary> /// 更新窗体 /// </summary> /// <param name="hisServerData"></param> public void UpdateWindowInfo(WindowInfoData roleWindowInfo) { SQL sql = SqlHelper.CreateSQL("更新窗体信息", "Update 影像窗体信息 " + " Set 窗体名称=:窗体名称, 分组标记=:分组标记, 版本=:版本, 窗体信息=:窗体信息 where 窗体ID=:窗体ID"); SqlParamInfo[] sqlPars = new SqlParamInfo[] { new SqlParamInfo("窗体名称", DbType.String, roleWindowInfo.窗体名称), new SqlParamInfo("分组标记", DbType.String, roleWindowInfo.分组标记), new SqlParamInfo("版本", DbType.Int32, roleWindowInfo.版本), new SqlParamInfo("窗体信息", DbType.String, roleWindowInfo.窗体信息.ToString()), new SqlParamInfo("窗体ID", DbType.String, roleWindowInfo.窗体ID) }; sql.AddParameterRange(sqlPars); _dbHelper.ExecuteSQL(sql); }
/// <summary> /// 新增窗体信息 /// </summary> /// <param name="hisServerData"></param> /// <returns></returns> public bool NewWindow(WindowInfoData roleWindowInfo) { SQL sql = SqlHelper.CreateSQL("插入窗体信息", "insert into " + " 影像窗体信息(窗体ID,科室ID,窗体名称, 分组标记, 窗体信息) " + " values " + " (:窗体ID,:科室ID,:窗体名称, :分组标记, :窗体信息)"); SqlParamInfo[] sqlPars = GetWindowInfoPars(roleWindowInfo); sql.AddParameterRange(sqlPars); DataTable dtResult = _dbHelper.ExecuteSQL(sql); return(true); }
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); }