Пример #1
0
        // find all by list
        public List<MyUser> findAll_List()
        {
            string sql = "select * from myuser";
            OleDbConnection con = getCon(null);
            OleDbCommand cmd = new OleDbCommand(sql, con);

            List<MyUser> list = new List<MyUser>();
            OleDbDataReader reader = cmd.ExecuteReader();
            while (reader.Read()) {
                MyUser bean = new MyUser();

                bean.Id = reader.GetInt32(0);
                bean.Uname = reader.GetString(1);
                bean.Upass = reader.GetString(2);
                bean.Userlevel = reader.GetInt32(3);
                bean.Dept_id = reader.GetInt32(4);

                list.Add(bean);
            }

            //close the con
            closeAll(con, null, null);

            if (list.Count <= 0)
            {
                return null;
            }
            else
            {

                return list;
            }
        }
Пример #2
0
        // add
        public void add(MyUser domain)
        {
            string sql = "insert into myuser(uname,upass,userlevel,dept_id) " +
                           "values(@uname,@upass,@userlevel,@dept_id) ";
            OleDbConnection con = getCon(null);
            OleDbCommand cmd = new OleDbCommand(sql, con);
            OleDbParameter[] param = {new OleDbParameter("@uname",domain.Uname),new OleDbParameter("@upass",domain.Upass),
                                     new OleDbParameter("@userlevel",domain.Userlevel),new OleDbParameter("@dept_id",domain.Dept_id)};
            cmd.Parameters.AddRange(param);

            cmd.ExecuteNonQuery();

            // close the con
            closeAll(con,cmd, null);
        }
Пример #3
0
 public static void test_MyUserDao()
 {
     MyUserDao dao = new MyUserDao();
     MyUser bean = new MyUser();
     // add
     //bean.Uname = "肖云"; bean.Upass = "******"; bean.Userlevel = 0; bean.Dept_id = 3;
      //   dao.add(bean);
     //  update
     //bean.Id = 3; bean.Uname = "阿曼达"; bean.Upass = "******"; bean.Userlevel = 0; bean.Dept_id = 3;
     //dao.update(bean);
     // load
        // bean = dao.load(3);
       //  Console.WriteLine("{0} {1} {2} {3} {4}",bean.Id,bean.Uname,bean.Upass,bean.Userlevel,bean.Dept_id);
       //  Console.Read();
         // find all
         //DataSet da = dao.findAll();
         //DataTableReader reader = da.CreateDataReader();
         //while(reader.Read())
         //Console.WriteLine("{0} {1} {2} {3} {4}", reader.GetInt32(0), reader.GetString(1), reader.GetString(2),reader.GetInt32(3),reader.GetInt32(4));
         //Console.Read();
     // load by name
       //  bean = dao.loadByName("阿曼达");
       //  Console.WriteLine("{0} {1} {2} {3} {4}", bean.Id, bean.Uname, bean.Upass, bean.Userlevel, bean.Dept_id);
       //  Console.Read();
     // delete
     dao.delete(5);
 }
Пример #4
0
        // update
        public void update(MyUser domain)
        {
            string sql = "update myuser set uname=@uname,upass=@upass,userlevel=@userlevel,dept_id=@dept_id where id=@id";
            OleDbConnection con = getCon(null);
            OleDbCommand cmd = new OleDbCommand(sql, con);
            OleDbParameter[] param = {new OleDbParameter("@uname",domain.Uname),new OleDbParameter("@upass",domain.Upass),
                                     new OleDbParameter("@userlevel",domain.Userlevel),new OleDbParameter("@dept_id",domain.Dept_id),
                                     new OleDbParameter("@id",domain.Id)};
            cmd.Parameters.AddRange(param);
            cmd.ExecuteNonQuery();

            // close the con
            closeAll(con,cmd,null);
        }
Пример #5
0
        // load by name
        public MyUser loadByName(string uname)
        {
            string sql = "select * from myuser where uname=@uname";
            OleDbConnection con = getCon(null);
            OleDbCommand cmd = new OleDbCommand(sql,con);
            OleDbParameter param = new OleDbParameter("@uname", uname);
            cmd.Parameters.Add(param);

            MyUser domain = null;
            OleDbDataReader reader = cmd.ExecuteReader();
            if (reader.Read()) {
                domain = new MyUser();

                domain.Id = reader.GetInt32(0);
                domain.Uname = reader.GetString(1);
                domain.Upass = reader.GetString(2);
                domain.Userlevel = reader.GetInt32(3);
                domain.Dept_id = reader.GetInt32(4);
            }

            // close the con
            closeAll(con,cmd,reader);

            return domain;
        }