基于构件的系办文件档案管理系统 第10页

    string sqlstr = @"select * from  Document_Details order by Document_ID desc";

            SqlConnection conn = new SqlConnection(SqlString.ConnectingString);
            try
            {
                SqlDataAdapter sqlda = new SqlDataAdapter(sqlstr, conn);
                DataSet ds = new DataSet();
                sqlda.Fill(ds);
                return ds论文网http://www.751com.cn/  ;
            }
            catch
            {
                return null;
            }
            finally
            {
                conn.Close();
                conn.Dispose();
                conn = null;
            }本文来自辣'文~论.文·网原文请找腾讯324.9114
        }

        /// <summary>
        /// 查询下载权限等级
        /// </summary>
        /// <param name="Document_ID">文档ID</param>
        /// <returns>返回等级</returns>
        public int Document_Leve(int Document_ID)
        {
            SqlConnection conn = new SqlConnection(SqlString.ConnectingString);
            string sqlstr = @"Select Permissions_ID from Document_Details where Document_ID=@Document_ID";
            try
            {
                SqlDataAdapter sqlda = new SqlDataAdapter(sqlstr, conn);
                SqlParameter p1 = new SqlParameter("@Document_ID", SqlDbType.Int, 4);
                p1.Value = Document_ID;
                sqlda.SelectCommand.Parameters.Add(p1);

                DataSet ds = new DataSet();
                sqlda.Fill(ds);
                if (ds != null)
                {
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        return Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
                    }
                    else
                    {
                        return 0;
                    }
                }
                else
                {
                    return 论文网http://www.751com.cn/  0;
                }
            }
            catch
            {
                return 0;
            }
            finally
            {
                conn.Close();
                conn.Dispose();
                conn = null;
            }
        }

        /// <summary>
        /// 查询文档上传人ID
        /// </summary>
        /// <param name="Document_ID">文档ID</param>
        /// <returns>返回上传人ID</returns>
        public int Document_UserID(int Document_ID)
        {本文来自辣'文~论.文·网原文请找腾讯3249,114
            SqlConnection conn = new SqlConnection(SqlString.ConnectingString);
            string sqlstr = @"Select User_ID from Document_Details where Document_ID=@Document_ID";
            try
            {
                SqlDataAdapter sqlda = new SqlDataAdapter(sqlstr, conn);
                SqlParameter p1 = new SqlParameter("@Document_ID", SqlDbType.Int, 4);
                p1.Value = Document_ID;
                sqlda.SelectCommand.Parameters.Add(p1);

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] 

基于构件的系办文件档案管理系统 第10页下载如图片无法显示或论文不完整，请联系qq752018766