/// <summary> /// 案卷目录数据信息获取 /// </summary> /// <param name="TopClassID">类目ID</param> /// <returns>DataSet</returns> public DataSet getData(int TopClassID) { strSql = new StringBuilder(); strSql.Append("select 目录ID,一级类目ID,目录号,保管期限,科室代号,说明 from 案卷目录 where 一级类目ID = @TopClassID order by 目录号"); SqlParameter[] parameter = { new SqlParameter("@TopClassID", SqlDbType.Int, 4) }; parameter[0].Value = TopClassID; return(DataSql.Query(strSql.ToString(), parameter)); }
/// <summary> /// 案卷目录数据信息获取 /// </summary> /// <param name="TopClassID">类目ID</param> /// <returns>DataSet</returns> public DataSet getCheckData(int TopClassID, int UserID) { strSql = new StringBuilder(); strSql.Append("select c.目录ID,c.一级类目ID,c.目录号,c.保管期限,c.科室代号,c.说明 from (案卷目录 as c INNER JOIN"); strSql.Append(" SYS_科室 AS t ON c.科室代号 = t.科室代号) INNER JOIN"); strSql.Append(" 角色目录权限 AS p ON t.ID = p.科室ID"); strSql.Append(" where c.一级类目ID = @TopClassID and p.查看 = 1"); strSql.Append(" and p.角色ID in (select 角色ID from 用户角色 where 用户ID = @UserID)"); strSql.Append(" order by 目录号"); SqlParameter[] parameter = { new SqlParameter("@TopClassID", SqlDbType.Int, 4), new SqlParameter("@UserID", SqlDbType.Int, 4) }; parameter[0].Value = TopClassID; parameter[1].Value = UserID; return(DataSql.Query(strSql.ToString(), parameter)); }
/// <summary> /// 获取最大柜架号 /// </summary> /// <param name="AreaNum"></param> /// <param name="ColumnNum"></param> /// <param name="LineNum"></param> /// <param name="FloorNum"></param> public static void getMaxGJH(out int AreaNum, out int ColumnNum, out int LineNum, out int FloorNum) { string strSql = "select * from SYS_最大柜架号"; DataSet ds = DataSql.Query(strSql); if (ds != null && ds.Tables[0].Rows.Count > 0) { AreaNum = Convert.ToInt32(ds.Tables[0].Rows[0]["最大区号"]); ColumnNum = Convert.ToInt32(ds.Tables[0].Rows[0]["最大列号"]); LineNum = Convert.ToInt32(ds.Tables[0].Rows[0]["最大节号"]); FloorNum = Convert.ToInt32(ds.Tables[0].Rows[0]["最大层号"]); } else { AreaNum = 1; ColumnNum = 1; LineNum = 1; FloorNum = 1; } }