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 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; }
public void insertfile(int id,string title,string type,DateTime dt,int userid,string path) { DAL.DataBase db = new DAL.DataBase(); string sql = "insert into file(id,title,type,time,userid,path) values("+id+",'"+title+"','"+type+"','"+dt+"',"+userid+",'"+path+"')"; db.execute(sql); db.closeconn(); }