void LoadUsers() { HandleData(() => { dataGridView1.DataSource = BLLOperate.GetItems <TB_User>().Where(p => p.Id != GlobalData.Current.CurrentUser.Id).ToList(); }, s => MessageBox.Show(this, s)); }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { var user = dataGridView1.Rows[e.RowIndex].DataBoundItem as TB_User; if (e.ColumnIndex < 0 || dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value == null) { return; } string buttonText = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); HandleData(() => { switch (buttonText) { case "重置密码": var succeed = BLLOperate.ModifyPassword(user.Id, "1"); MessageBox.Show(this, succeed ? "重置成功!" : "重置失败"); break; case "删除用户": var id = BLLOperate.DeleteItem <TB_User>(user.Id); MessageBox.Show(this, id > 0 ? "删除成功!" : "删除失败"); LoadUsers(); break; } }, s => MessageBox.Show(this, s)); }
private void btnOK_Click(object sender, EventArgs e) { if (VerifyRequired(txtName, lbMessage, "名称")) { return; } if (BLLOperate.IsExistContactPersonGroupName(ContactPersonGroup.Id, GlobalData.Current.CurrentUser.Id, txtName.Text) || txtName.Text.Trim().Equals("未分组")) { lbMessage.ForeColor = Color.Red; lbMessage.Text = "该联系人组已存在"; return; } HandleData(() => { ContactPersonGroup.Name = txtName.Text; ContactPersonGroup.Id = BLLOperate.AddOrModifyItem <TB_ContactPersonGroup>(ContactPersonGroup); DialogResult = DialogResult.OK; Close(); }, (s) => { lbMessage.ForeColor = Color.Red; lbMessage.Text = "操作失败"; }); }
/// <summary> /// 加载数据源 /// </summary> /// <param name="action"></param> private void LoadData(Action action = null) { HandleData(() => { _contactPersonGroups = BLLOperate.GetContactPersonGroupsByUId(GlobalData.Current.CurrentUser.Id); _contactPersons = BLLOperate.GetContactPersonsByUId(GlobalData.Current.CurrentUser.Id); if (action != null) { action(); } }, s => MessageBox.Show(this, s)); }
/// <summary> /// 删除照片 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void MIDeletePhoto_Click(object sender, EventArgs e) { HandleData(() => { foreach (ListViewItem item in listView1.SelectedItems) { var gallery = item.Tag as TB_Gallery; BLLOperate.DeleteItem <TB_Gallery>(gallery.Id); listView1.Items.Remove(listView1.SelectedItems[0]); } }, s => MessageBox.Show(this, s)); }
private void btnRegister_Click(object sender, EventArgs e) { var oldPassword = txtOldPassword.Text; var newPassword = txtNewPassword.Text; var affirmPassword = txtAffirmPassword.Text; if (VerifyRequired(txtOldPassword, lbMessage, "旧密码") || VerifyRequired(txtNewPassword, lbMessage, "新密码") || VerifyStringLength(txtNewPassword, 16, lbMessage, "新密码")) { return; } if (oldPassword.Trim() != GlobalData.Current.CurrentUser.Password) { lbMessage.ForeColor = Color.Red; lbMessage.Text = "旧密码不匹配"; txtOldPassword.Focus(); return; } if (oldPassword == newPassword) { lbMessage.ForeColor = Color.Red; lbMessage.Text = "新密码不能与旧密码相同"; txtNewPassword.Focus(); return; } if (affirmPassword != newPassword) { lbMessage.ForeColor = Color.Red; lbMessage.Text = "确认密码与新密码不符"; txtAffirmPassword.Focus(); return; } HandleData(() => { var succeed = BLLOperate.ModifyPassword(GlobalData.Current.CurrentUser.Id, newPassword); if (succeed) { GlobalData.Current.CurrentUser.Password = newPassword; MessageBox.Show(this, "修改成功!"); Close(); } else { lbMessage.ForeColor = Color.Red; lbMessage.Text = "修改失败"; } }, s => { lbMessage.ForeColor = Color.Red; lbMessage.Text = "修改失败"; }); }
/// <summary> /// 删除联系人 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DeleteContactPerson(object sender, EventArgs e) { if (tvItems.SelectedNode != null) { var contactPerson = tvItems.SelectedNode.Tag as TB_ContactPerson; HandleData(() => { BLLOperate.DeleteItem <TB_ContactPerson>(contactPerson.Id); tvItems.SelectedNode.Parent.Nodes.Remove(tvItems.SelectedNode); GetContactPersonsByUIdAndTypeId(contactPerson.UType); }, s => MessageBox.Show(this, s)); } }
/// <summary> /// 注册 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnRegister_Click(object sender, EventArgs e) { var uName = txtUName.Text; var password = txtPassword.Text; var affirmPassword = txtAffirmPassword.Text; if (VerifyRequired(txtUName, lbMessage, "用户名") || VerifyRequired(txtPassword, lbMessage, "密码") || VerifyStringLength(txtUName, 16, lbMessage, "用户名") || VerifyStringLength(txtPassword, 16, lbMessage, "密码")) { return; } if (affirmPassword != password) { lbMessage.ForeColor = Color.Red; lbMessage.Text = "确认密码与密码不符"; txtAffirmPassword.Focus(); return; } if (CheckUserName()) { return; } HandleData(() => { var user = BLLOperate.Register(new TB_User { UName = uName.Trim(), Name = "", Password = password.Trim() }); if (user != null) { GlobalData.Current.CurrentUser = user; MessageBox.Show(this, string.Format("注册成功,欢迎{0}登录!", user.UName.ToLower())); DialogResult = DialogResult.OK; Close(); } else { lbMessage.ForeColor = Color.Red; lbMessage.Text = "注册失败"; } }, s => { lbMessage.ForeColor = Color.Red; lbMessage.Text = "注册失败"; }); }
private void btnOK_Click(object sender, EventArgs e) { if (VerifyRequired(userInfo.TxtName, lbMessage, "名称") || VerifyStringLength(userInfo.TxtName, 20, lbMessage, "名称") || VerifyStringLength(userInfo.TxtEmail, 40, lbMessage, "邮箱") || VerifyStringLength(userInfo.TxtAddress, 80, lbMessage, "地址") || VerifyCallPhone(userInfo.TxtCallPhone, lbMessage, "手机") || VerifyTelePhone(userInfo.TxtTelephone, lbMessage, "电话") || VerifyEmail(userInfo.TxtEmail, lbMessage, "邮箱")) { return; } if (VerifyRequired(userInfo.TxtCallPhone, lbMessage, "手机") && VerifyRequired(userInfo.TxtTelephone, lbMessage, "电话")) { return; } if (DateTime.Compare(userInfo.DtBirthday.Value, DateTime.Now) > 0) { lbMessage.ForeColor = Color.Red; lbMessage.Text = "生日不得晚于今天"; userInfo.DtBirthday.Focus(); } if (BLLOperate.IsExistContactPersonName(ContactPerson.Id, GlobalData.Current.CurrentUser.Id, userInfo.TxtName.Text)) { lbMessage.ForeColor = Color.Red; lbMessage.Text = "该联系人已存在"; return; } HandleData(() => { ContactPerson.Name = userInfo.TxtName.Text; ContactPerson.Email = userInfo.TxtEmail.Text; ContactPerson.Address = userInfo.TxtAddress.Text; ContactPerson.Callphone = userInfo.TxtCallPhone.Text; ContactPerson.Telephone = userInfo.TxtTelephone.Text; ContactPerson.Birthday = userInfo.DtBirthday.Text; ContactPerson.Sex = (int)userInfo.CbSex.SelectedValue; ContactPerson.Favicon = userInfo.ImageData; ContactPerson.UType = (int)cbGroups.SelectedValue; ContactPerson.Id = BLLOperate.AddOrModifyItem <TB_ContactPerson>(ContactPerson); DialogResult = DialogResult.OK; Close(); }, (s) => { lbMessage.ForeColor = Color.Red; lbMessage.Text = "操作失败"; }); }
/// <summary> /// 获取联系人 /// </summary> private void GetContactPersonsByUIdAndTypeId(int type) { HandleData(() => { _gridViewContactPersons = new List <TB_ContactPerson>(); if (type == 0) { _gridViewContactPersons = BLLOperate.GetContactPersonsByUId(GlobalData.Current.CurrentUser.Id); } else { _gridViewContactPersons = BLLOperate.GetContactPersonsByUIdAndTypeId(GlobalData.Current.CurrentUser.Id, type); } cDataGridView.DataSource = _gridViewContactPersons; }, s => MessageBox.Show(this, s)); }
/// <summary> /// 删除联系人组 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DeleteGroup(object sender, EventArgs e) { if (tvItems.SelectedNode != null) { var contactPersonGroup = tvItems.SelectedNode.Tag as TB_ContactPersonGroup; HandleData(() => { BLLOperate.DeleteItem <TB_ContactPersonGroup>(contactPersonGroup.Id); if (tvItems.SelectedNode.Parent == null) { tvItems.Nodes.Remove(tvItems.SelectedNode); } else { tvItems.SelectedNode.Parent.Nodes.Remove(tvItems.SelectedNode); } }, s => MessageBox.Show(this, s)); } }
/// <summary> /// 添加照片 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void MIAddPhoto_Click(object sender, EventArgs e) { var openFileDialog = new OpenFileDialog { Filter = "图片|*.jpg;*.png;", Multiselect = true }; if (openFileDialog.ShowDialog(this) == DialogResult.OK) { if (openFileDialog.FileNames.Any()) { foreach (var fileName in openFileDialog.FileNames) { if (BLLOperate.IsExistGalleryName(0, GlobalData.Current.CurrentUser.Id, Path.GetFileName(fileName))) { continue; } using (var fs = new FileStream(fileName, FileMode.Open)) { var image = new byte[fs.Length]; fs.Read(image, 0, (int)fs.Length); if (image.Length != 0) { HandleData(() => { var photo = new TB_Gallery() { UId = GlobalData.Current.CurrentUser.Id, Name = Path.GetFileName(fileName), GImage = image }; BLLOperate.AddOrModifyItem <TB_Gallery>(photo); var myImage = Image.FromStream(fs); listView1.BeginUpdate(); listView1.LargeImageList.Images.Add(myImage); listView1.Items.Add(photo.Name, listView1.LargeImageList.Images.Count - 1).Tag = photo; listView1.EndUpdate(); }, s => MessageBox.Show(this, s)); } } } } } }
/// <summary> /// 登录 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnLogin_Click(object sender, EventArgs e) { BLLOperate.CreateAdminUser(); if (VerifyRequired(txtUName)) { lbMessage.ForeColor = Color.Red; lbMessage.Text = "用户名不能为空"; return; } if (VerifyRequired(txtPassword)) { lbMessage.ForeColor = Color.Red; lbMessage.Text = "密码不能为空"; return; } HandleData(() => { TB_User user = BLLOperate.UserLogin(txtUName.Text, txtPassword.Text); if (user != null) { GlobalData.Current.CurrentUser = user; GlobalData.Current.UserConfig.IsSaveName = cbRemindName.Checked; GlobalData.Current.UserConfig.IsSavePassword = cbRemindPassword.Checked; GlobalData.Current.UserConfig.UserName = txtUName.Text; GlobalData.Current.UserConfig.Password = txtPassword.Text; SQLiteOperate.ModifyUserConfig(GlobalData.Current.UserConfig); MessageBox.Show(this, string.Format("欢迎{0}登录!", string.IsNullOrEmpty(user.Name) ? user.UName : user.Name)); Hide(); var main = new Main(); main.Show(); } else { lbMessage.ForeColor = Color.Red; lbMessage.Text = "登录失败,用户名或密码错误"; } }, s => { lbMessage.ForeColor = Color.Red; lbMessage.Text = "登录失败,数据访问出错"; }); }
/// <summary> /// 删除选中 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDelSelected_Click(object sender, EventArgs e) { if (cDataGridView.SelectedRows.Count == 0) { return; } if (MessageBox.Show(this, "确定删除选中的联系人?", "删除联系人", MessageBoxButtons.OKCancel) == DialogResult.OK) { HandleData(() => { foreach (DataGridViewRow selectedRow in cDataGridView.SelectedRows) { var contactPerson = selectedRow.DataBoundItem as TB_ContactPerson; BLLOperate.DeleteItem <TB_ContactPerson>(contactPerson.Id); } MessageBox.Show(this, "删除成功!"); tvItems_AfterSelect(null, null); }, s => MessageBox.Show(this, s)); } }
private void btnOK_Click(object sender, EventArgs e) { if (VerifyRequired(userInfo.TxtName, lbMessage, "名称") || VerifyStringLength(userInfo.TxtName, 20, lbMessage, "名称") || VerifyStringLength(userInfo.TxtEmail, 40, lbMessage, "邮箱") || VerifyStringLength(userInfo.TxtAddress, 80, lbMessage, "地址") || VerifyCallPhone(userInfo.TxtCallPhone, lbMessage, "手机") || VerifyTelePhone(userInfo.TxtTelephone, lbMessage, "电话") || VerifyEmail(userInfo.TxtEmail, lbMessage, "邮箱")) { return; } HandleData(() => { var user = new TB_User { Id = GlobalData.Current.CurrentUser.Id, UName = GlobalData.Current.CurrentUser.UName, Password = GlobalData.Current.CurrentUser.Password, UType = GlobalData.Current.CurrentUser.UType, Name = userInfo.TxtName.Text, Email = userInfo.TxtEmail.Text, Address = userInfo.TxtAddress.Text, Callphone = userInfo.TxtCallPhone.Text, Telephone = userInfo.TxtTelephone.Text, Birthday = userInfo.DtBirthday.Text, Sex = (int)userInfo.CbSex.SelectedValue, Favicon = userInfo.ImageData }; user.Id = BLLOperate.AddOrModifyItem <TB_User>(user); GlobalData.Current.CurrentUser = user; DialogResult = DialogResult.OK; Close(); }, (s) => { lbMessage.ForeColor = Color.Red; lbMessage.Text = "操作失败"; }); }
private void cDataGridView_CellClick(object sender, DataGridViewCellEventArgs e) { var contactPerson = cDataGridView.Rows[e.RowIndex].DataBoundItem as TB_ContactPerson; if (e.ColumnIndex < 0 || cDataGridView.Rows[e.RowIndex].Cells[e.ColumnIndex].Value == null) { return; } string buttonText = cDataGridView.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); HandleData(() => { switch (buttonText) { case "修改": var g = new ContactPersonOperate() { Text = "修改联系人", ContactPerson = contactPerson }; if (g.ShowDialog(this) == DialogResult.OK) { tvItems_AfterSelect(null, null); } break; case "删除": if (MessageBox.Show(this, "确定删除联系人?", "删除联系人", MessageBoxButtons.OKCancel) == DialogResult.OK) { var id = BLLOperate.DeleteItem <TB_ContactPerson>(contactPerson.Id); MessageBox.Show(this, id > 0 ? "删除成功!" : "删除失败"); tvItems_AfterSelect(null, null); } break; } }, s => MessageBox.Show(this, s)); }
/// <summary> /// 检查用户名 /// </summary> /// <returns></returns> private bool CheckUserName() { bool isExist = false; HandleData(() => { if (BLLOperate.CheckUserName(txtUName.Text.Trim())) { lbMessage.ForeColor = Color.Red; lbMessage.Text = "该用户名已被占用"; txtUName.Focus(); isExist = true; return; } lbMessage.Text = "该用户名可用"; lbMessage.ForeColor = Color.Green; }, s => { lbMessage.ForeColor = Color.Red; lbMessage.Text = "检查用户名失败"; isExist = true; }); return(isExist); }
private void ContactPersonOperate_Load(object sender, EventArgs e) { userInfo.TxtName.Text = ContactPerson.Name; userInfo.TxtEmail.Text = ContactPerson.Email; userInfo.TxtAddress.Text = ContactPerson.Address; userInfo.TxtCallPhone.Text = ContactPerson.Callphone; userInfo.TxtTelephone.Text = ContactPerson.Telephone; userInfo.DtBirthday.Text = string.IsNullOrEmpty(ContactPerson.Birthday) ? DateTime.Now.Date.ToShortDateString() : ContactPerson.Birthday; if (ContactPerson.Favicon != null) { using (var myStream = new MemoryStream()) { foreach (byte a in ContactPerson.Favicon) { myStream.WriteByte(a); } var myImage = Image.FromStream(myStream); myStream.Close(); userInfo.PbFavicon.Image = myImage; } } userInfo.CbSex.SelectedValue = ContactPerson.Sex; HandleData(() => { var contactPersonGroups = new List <TB_ContactPersonGroup>(); contactPersonGroups.Add(new TB_ContactPersonGroup { Id = 0, Name = "未分组" }); var groups = BLLOperate.GetContactPersonGroupsByUId(GlobalData.Current.CurrentUser.Id); contactPersonGroups.AddRange(groups); cbGroups.DataSource = contactPersonGroups; cbGroups.DisplayMember = "Name"; cbGroups.ValueMember = "Id"; cbGroups.SelectedValue = ContactPerson.UType; }); }
/// <summary> /// 转移分组 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cbGroup_SelectedIndexChanged(object sender, EventArgs e) { if (cDataGridView.SelectedRows.Count == 0) { return; } var group = cbGroup.SelectedItem as TB_ContactPersonGroup; if (group == null) { return; } HandleData(() => { foreach (DataGridViewRow selectedRow in cDataGridView.SelectedRows) { var contactPerson = selectedRow.DataBoundItem as TB_ContactPerson; contactPerson.UType = group.Id; BLLOperate.AddOrModifyItem <TB_ContactPerson>(contactPerson); } MessageBox.Show(this, "转移成功!"); tvItems_AfterSelect(null, null); }, s => MessageBox.Show(this, s)); }
private void ReadData(string fileName) { using (var stream = new FileStream(fileName, FileMode.Open)) { // 把 Stream 转换成 byte[] var bytes = new byte[stream.Length]; stream.Read(bytes, 0, bytes.Length); // 设置当前流的位置为流的开始 stream.Seek(0, SeekOrigin.Begin); string content = System.Text.Encoding.Default.GetString(bytes, 0, bytes.Length); if (string.IsNullOrEmpty(content)) { return; } var coords = content.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries); var count = coords.Count(); if (count <= 1) { return; } var line = coords[0]; var values = line.Split(','); if (!values.Contains("姓名")) { return; } var nameIndex = Array.IndexOf(values, "姓名"); var utypeIndex = Array.IndexOf(values, "组类别"); var sexIndex = Array.IndexOf(values, "性别"); var birthdayIndex = Array.IndexOf(values, "生日"); var callphoneIndex = Array.IndexOf(values, "手机"); var telephoneIndex = Array.IndexOf(values, "电话"); var emailIndex = Array.IndexOf(values, "邮箱"); var addressIndex = Array.IndexOf(values, "地址"); var contactPersons = new List <TB_ContactPerson>(); for (int i = 1; i < count; i++) { var contact = new TB_ContactPerson(); string[] list = coords[i].Split(','); contact.Name = list[nameIndex]; var group = _contactPersonGroups.FirstOrDefault(p => p.Name.Equals(list[utypeIndex], StringComparison.CurrentCultureIgnoreCase)); contact.UType = group != null ? group.Id : 0; contact.Sex = (int)GlobalData.Current.GetSex(list[sexIndex]); contact.Birthday = list[birthdayIndex]; contact.Callphone = list[callphoneIndex]; contact.Telephone = list[telephoneIndex]; contact.Email = list[emailIndex]; contact.Address = list[addressIndex]; contact.UId = GlobalData.Current.CurrentUser.Id; contactPersons.Add(contact); } HandleData(() => { BLLOperate.AddContactPersonsByList(contactPersons); MessageBox.Show(this, "导入成功!"); tvItems_AfterSelect(null, null); }, s => MessageBox.Show(this, s)); } }