Esempio n. 1
0
        public static bool NewUser(string login_name, string login_password, string name, string department)
        {
            string pw = GetMD5(login_password);
            User   u  = new User(0, login_name, pw, name, department);

            return(DBUserAdapter.Insert(u));
        }
Esempio n. 2
0
 public static bool ChangePassword(string name, string oldpassword, string newpassword)
 {
     if (ValidateUser(name, oldpassword))
     {
         User u = DBUserAdapter.LoadWithName(name);
         u.Login_password = GetMD5(newpassword);
         return(DBUserAdapter.Update(u));
     }
     else
     {
         return(false);
     }
 }
Esempio n. 3
0
        public static bool Exist(string name)
        {
            int res = DBUserAdapter.Exist(name);

            if (res != 1)
            {
                return(false);
            }
            else
            {
                return(true);
            }
        }
Esempio n. 4
0
 public static User LoginOn(string name, string password)
 {
     if (ValidateUser(name, password))
     {
         User u = DBUserAdapter.LoadWithName(name);
         DBUserAdapter.SetLastLoginTimeNow(u.Id);
         DBUserAdapter.IncLoginCount(u.Id);
         return(u);
     }
     else
     {
         return(null);
     }
 }
Esempio n. 5
0
        private void mi_delete_Click(object sender, EventArgs e)
        {
            DataGridViewSelectedRowCollection rows = dgv.SelectedRows;

            foreach (DataGridViewRow r in rows)
            {
                string id = r.Cells[0].Value.ToString();
                if (id != "")
                {
                    int i = int.Parse(id);
                    DBUserAdapter.Delete(i);
                }
            }
            RefreshDate();
        }
Esempio n. 6
0
 private bool RefreshDate()
 {
     dt = DBUserAdapter.LoadAll();
     if (dt == null)
     {
         MessageBox.Show("查询数据库错误");
         return(false);
     }
     dgv.DataSource          = dt;
     dgv.Columns[0].ReadOnly = true;
     dgv.Columns[2].ReadOnly = true;
     dgv.Columns.RemoveAt(5);
     dgv.Columns.RemoveAt(5);
     dgv.Columns.RemoveAt(5);
     return(true);
 }
Esempio n. 7
0
 private void mi_ok_Click(object sender, EventArgs e)
 {
     foreach (DataGridViewRow r in dgv.Rows)
     {
         if (!RowDataVerificate(r))
         {
             MessageBox.Show("请您填写完整的信息");
             r.Selected = true;
             return;
         }
     }
     foreach (DataGridViewRow r in dgv.Rows)
     {
         if (r.IsNewRow)
         {
             continue;
         }
         int id = 0;
         if (r.Cells[0].Value is Int32)
         {
             id = (int)(r.Cells[0].Value);
         }
         string lid        = (string)(r.Cells[1].Value);
         string lpass      = (string)(r.Cells[2].Value);
         string name       = (string)(r.Cells[3].Value);
         string department = (string)(r.Cells[4].Value);
         User   u          = new User(id, lid, lpass, name, department);
         if (id == 0)
         {
             if (UserManager.Exist(name))
             {
                 MessageBox.Show("用户" + "\"" + name + "\"已经存在");
                 continue;
             }
             DBUserAdapter.Insert(u);
         }
         else
         {
             User ou = DBUserAdapter.LoadWithId(id);
             u.Level = ou.Level;
             DBUserAdapter.Update(u);
         }
     }
 }
Esempio n. 8
0
        public static bool ValidateUser(string name, string password)
        {
            string md5pass = GetMD5(password);

            if (!Exist(name))
            {
                return(false);
            }
            User u = DBUserAdapter.LoadWithName(name);

            if (u == null)
            {
                return(false);
            }
            if (u.Login_password == md5pass)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }