public int maxid()
{
DAL.DataBase db = new DAL.DataBase();
string sql = "select max(id) from file";
DataTable dt = db.GetDataset(sql).Tables[0];
db.closeconn();
return (int)dt.Rows[0][0];
}
public DataSet basic()
{
DAL.DataBase db = new DAL.DataBase();
string sql = "select title,type,name,time from file,customer where userid=customer.id";
DataSet ds = db.GetDataset(sql);
db.closeconn();
return ds;
}
public DataTable getbasicfromtype(string type)
{
DAL.DataBase db = new DAL.DataBase();
String sql = "select title,type,name,time from file,customer where userid=customer.id and type='" + type + "'";
DataSet ds = db.GetDataset(sql);
DataTable dt = ds.Tables[0];
db.closeconn();
return dt;
}
public DataSet getbasicformuper(string uper)
{
DAL.DataBase db = new DAL.DataBase();
String sql = "select title,type,name,time from file,customer where userid=customer.id and name='" + uper + "'";
DataSet ds = db.GetDataset(sql);
DataTable dt = ds.Tables[0];
db.closeconn();
return ds;
}
public DataSet getbasicontime(DateTime tt)
{
DAL.DataBase db = new DAL.DataBase();
DateTime t = tt.Date;
DateTime t2 = t.AddDays(1);
string sqltime = "select title,type,name,time from file,customer where userid=customer.id and time>='" + t + "' and time<='" + t2 + "'";
DataSet ds = db.GetDataset(sqltime);
db.closeconn();
return ds;
}
public Form2()
{
InitializeComponent();
DAL.DataBase db = new DAL.DataBase();
String sql0 = "select distinct type from file";
DataSet ds0 = db.GetDataset(sql0);
ds0.Tables[0].Columns[0].ColumnName = "Type";
//bindingSource2.DataMember = ds0.Tables[0].ToString();
comboBox1.ValueMember = "Type";
comboBox1.DataSource = ds0.Tables[0];
String type = comboBox1.SelectedValue.ToString();
db.closeconn();
}
public string getpath(string title,string type,string uper)
{
DAL.DataBase db=new DAL.DataBase();
string sql;
DataTable dt;
if (uper == "未知")
{
if (type == "未知")
{
sql = "select path from file where title='" + title + "'";
}
else
{
sql = "select path from file where title='" + title + "' and type='" + type + "'";
}
}
else
{
if (type == "未知")
{
sql = "select path from file where title='" + title + "' and uper='" + uper + "'";
}
else
sql = "select path from file where title='" + title + "' and type='" + type + "' and uper='" + uper + "'";
}
dt = db.GetDataset(sql).Tables[0];
if (dt.Rows[0][0] != null)
return (string)dt.Rows[0][0];
else
return "";
}
public DataTable uperrestrictedbytype(string type)
{
DAL.DataBase db = new DAL.DataBase();
string sql = "select distinct name from file,customer where userid=customer.id and type='"+type+"'";
DataTable dt = db.GetDataset(sql).Tables[0];
db.closeconn();
return dt;
}
public DataTable titlerestrictedbytype(string type)
{
DAL.DataBase db = new DAL.DataBase();
string sql = "select distinct title from file where type='" + type + "'";
DataTable dt = db.GetDataset(sql).Tables[0];
db.closeconn();
return dt;
}
public DataTable showuper()
{
DAL.DataBase db = new DAL.DataBase();
string sql = "select distinct name from customer,file where userid=customer.id";
DataSet ds = db.GetDataset(sql);
DataTable dt = ds.Tables[0];
db.closeconn();
return dt;
}
public DataTable showtype()
{
DAL.DataBase db = new DAL.DataBase();
String sql0 = "select distinct type from file";
DataSet ds0 = db.GetDataset(sql0);
DataTable dt = ds0.Tables[0];
db.closeconn();
return dt;
}
public DataTable showtitle()
{
DAL.DataBase db = new DAL.DataBase();
string sql = "select distinct title from file";
DataTable dt = db.GetDataset(sql).Tables[0];
db.closeconn();
return dt;
}