public MySqlDataReader Selectinfo222(string str)
        {
            string          s9  = "SELECT * from fileprocess where getId = '" + str + "' and process != '归还'";
            MySqlDataReader sdr = DBhelper.ExecuteReader(s9);

            return(sdr);
        }
        public MySqlDataReader Selectinfo123(string str)
        {
            string          s9  = "select * from processing where pId = '" + str + "'";
            MySqlDataReader sdr = DBhelper.ExecuteReader(s9);

            return(sdr);
        }
        public MySqlDataReader Selectinfo111(string str)
        {
            string          s9  = "SELECT page FROM file1 WHERE dangId = '" + str + "' UNION SELECT page FROM file2 WHERE dangId = '" + str + "' UNION SELECT page FROM file3 WHERE dangId = '" + str + "'";
            MySqlDataReader sdr = DBhelper.ExecuteReader(s9);

            return(sdr);
        }
        public MySqlDataReader Selectinfo4(string str)
        {
            string          s9  = "SELECT * FROM fileprocess where process != '归还' and projectunit = '" + str + "'";
            MySqlDataReader sdr = DBhelper.ExecuteReader(s9);

            return(sdr);
        }
        //查找是否存在档号一样的档案
        public MySqlDataReader Selectinfo3(string str, string b)
        {
            string          s9  = "SELECT  * from fileprocess where bh = '" + str + "' and getId = '" + b + "'";
            MySqlDataReader sdr = DBhelper.ExecuteReader(s9);

            return(sdr);
        }
        public MySqlDataReader Selectinfo3(string str)
        {
            string          s9  = "select projectunit,filetype,gdmethod,year from project1 where pId = '" + str + "'";
            MySqlDataReader sdr = DBhelper.ExecuteReader(s9);

            return(sdr);
        }
        //获取加工流转单
        public MySqlDataReader Selectinfo2(string str)
        {
            string          s9  = "select year,gdmethod from project1 where pId = '" + str + "'";
            MySqlDataReader sdr = DBhelper.ExecuteReader(s9);

            return(sdr);
        }