/// <summary> /// 获得列表 /// </summary> /// <returns></returns> public List<Model.Users> GetList() { string sql = "select * from users order by uname"; List<Users> list = null; DataTable dt = SqlHelper.GetDataSet(sql).Tables[0]; if (dt.Rows.Count > 0) { list = new List<Users>(); Users user = null; foreach (DataRow row in dt.Rows) { user = new Users(); LoadEntity(user, row); list.Add(user); } } return list; }
/// <summary> /// 删除按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDel_Click(object sender, EventArgs e) { if (MessageBox.Show(this, "您确定要删除选择的密码信息吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.No) return; UsersBLL bll = new UsersBLL(); Users userInfo = new Users(); try { for (int i = 0; i < dgvInfos.Rows.Count; i++) { if (dgvInfos.Rows[i].Cells["cb"].Value != null && dgvInfos.Rows[i].Cells["cb"].Value.ToString() == "1") { bll.Delete(Convert.ToInt32(dgvInfos.Rows[i].Cells["id"].Value)); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } ClearInput(); Search(); }
/// <summary> /// 保存按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { if (CheckData()) { UsersBLL ubll = new UsersBLL(); Users userInfo = new Users(); EncryptBLL ebll = new EncryptBLL(); try { userInfo.Key = txtKey.Text; userInfo.UName = txtName.Text; userInfo.Pw = ebll.GetEncryptStr(txtPw.Text); userInfo.Type = ebll.GetName(); if (txtID.Text == "") { ubll.Add(userInfo); } else { userInfo.ID = Convert.ToInt32(txtID.Text); ubll.Update(userInfo); } } catch (Exception ex) { MessageBox.Show(ex.Message); } ClearInput(); Search(); } }
private void LoadEntity(Users user, DataRow row) { if (row["ID"] != null) { user.ID = Convert.ToInt32(row["ID"]); } if (row["Key"] != null) { user.Key = row["Key"].ToString(); } if (row["UName"] != null) { user.UName = row["UName"].ToString(); } if (row["Pw"] != null) { user.Pw = row["Pw"].ToString(); } if (row["Type"] != null) { user.Type = row["Type"].ToString(); } if (row["RegTime"] != null) { user.RegTime = Convert.ToDateTime(row["RegTime"]); } }