// load by id public PurviewTable load(string dbName, int id) { string sql = "select * from purviewtable where id=@id"; OleDbConnection con = getCon(dbName); OleDbCommand cmd = new OleDbCommand(sql, con); OleDbParameter param = new OleDbParameter("@id", id); cmd.Parameters.Add(param); OleDbDataReader reader = cmd.ExecuteReader(); PurviewTable bean = null; if (reader.Read()) { bean = new PurviewTable(); bean.Id = reader.GetInt32(0); bean.Dept_userid = reader.GetInt32(1); bean.Dept_table = reader.GetString(2); bean.Purview = reader.GetInt32(3); } // close the con closeAll(con, cmd, null); return(bean); }
// load by dept_table public List <PurviewTable> loadByTable(string dbName, string dept_table) { string sql = "select * from purviewtable where dept_table=@dept_table"; OleDbConnection con = getCon(dbName); OleDbCommand cmd = new OleDbCommand(sql, con); OleDbParameter param = new OleDbParameter("@dept_table", dept_table); cmd.Parameters.Add(param); OleDbDataReader reader = cmd.ExecuteReader(); List <PurviewTable> list = new List <PurviewTable>(); while (reader.Read()) { PurviewTable bean = new PurviewTable(); bean.Id = reader.GetInt32(0); bean.Dept_userid = reader.GetInt32(1); bean.Dept_table = reader.GetString(2); bean.Purview = reader.GetInt32(3); list.Add(bean); } // close the con closeAll(con, cmd, reader); if (list.Count() <= 0) { return(null); } return(list); }
// update public void update(string dbName, PurviewTable form) { string sql = "update purviewtable set dept_userid=@dept_userid,dept_table=@dept_table,purview=@purview where id=@id"; OleDbConnection con = getCon(dbName); OleDbCommand cmd = new OleDbCommand(sql, con); OleDbParameter[] param = { new OleDbParameter("@dept_userid", form.Dept_userid), new OleDbParameter("@dept_table", form.Dept_table), new OleDbParameter("@purview", form.Purview), new OleDbParameter("@id", form.Id) }; cmd.Parameters.AddRange(param); cmd.ExecuteNonQuery(); // close the con closeAll(con, cmd, null); }
// add public void add(string dbName, PurviewTable form) { string sql = "insert into purviewtable(dept_userid,dept_table,purview) values(@dept_userid,@dept_table,@purview)"; OleDbConnection con = getCon(dbName); OleDbCommand cmd = new OleDbCommand(sql, con); OleDbParameter[] param = { new OleDbParameter("@dept_userid", form.Dept_userid), new OleDbParameter("@dept_table", form.Dept_table), new OleDbParameter("@purview", form.Purview) }; cmd.Parameters.AddRange(param); cmd.ExecuteNonQuery(); // close the con closeAll(con, cmd, null); }