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