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);
}