private void button1_Click(object sender, RoutedEventArgs e)
{
if (!string.IsNullOrEmpty(passwordBox1.Password.Trim()) && !string.IsNullOrEmpty(passwordBox2.Password.Trim()) &&
!string.IsNullOrEmpty(passwordBox3.Password.Trim()))
{
if (passwordBox1.Password.Trim() == myuser.UserPassword)
{
if (passwordBox2.Password.Trim() != passwordBox3.Password.Trim())
{
showDialog("提示", "确认密码不一致，请检查");
}
else
{
using (financepersonalEntities dbEntity = new financepersonalEntities())
{
user u = dbEntity.user.Where(m => m.UserId == myuser.UserId).FirstOrDefault();
u.UserPassword = passwordBox2.Password;
dbEntity.ObjectStateManager.ChangeObjectState(u, EntityState.Modified);
dbEntity.SaveChanges();
showDialog("提示", "恭喜，修改成功！");
}
}
}
else
{
showDialog("提示", "原密码有误，请检查");
}
}
else
{
showDialog("提示", "必填项不可为空，请检查");
}
}
private void button1_Click(object sender, RoutedEventArgs e)
{
if (!string.IsNullOrEmpty(textBox1.Text.Trim()) && !string.IsNullOrEmpty(passwordBox1.Password.Trim()))
{
using (financepersonalEntities dbEntity = new financepersonalEntities())
{
user u = dbEntity.user.Where(m => (m.UserName == textBox1.Text.Trim() && m.UserPassword == passwordBox1.Password.Trim())).FirstOrDefault();
if (u != null)
{
MainWindow mwin = new MainWindow(u);
Application.Current.MainWindow = mwin;
this.Close();
mwin.Show();
}
else
{
Dialog.DialogWindow.CreateAlertWindow("提示", "账户和口令不正确!", null).Show();
}
}
}
else
{
Dialog.DialogWindow.CreateAlertWindow("提示", "账户和口令不可为空!", null).Show();
}
}
public void DataBinding()
{
string userid = myuser.UserId.ToString();
using (financepersonalEntities dbEntity = new financepersonalEntities())
{
IQueryable <mycheck> list = dbEntity.action.Join(
dbEntity.user, p => p.ActionUserId, m => m.UserId, (p, m) =>
new mycheck
{
ActionUser = m.UserName,
ActionId = p.ActionId,
ActionTime = p.ActionTime,
ActionRole = p.ActionRole,
ActionName = p.ActionName,
ActionMoney = p.ActionMoney,
ActionCommet = p.ActionCommet,
IsChecked = false
});
List <role> r = dbEntity.role.Select(m => m).ToList();
mylist = list.ToList();
mylist = SetSum(mylist, r);
this.listView1.ItemsSource = mylist;
}
}
/// <summary>
/// 删除一个用户
/// </summary>
/// <param name="uid"></param>
private void DeleteUser(int uid)
{
using (financepersonalEntities dbEntity = new financepersonalEntities())
{
action a = dbEntity.action.Where(m => m.ActionId == uid).FirstOrDefault();
dbEntity.DeleteObject(a);
dbEntity.SaveChanges();
}
}
private void BindCombox(string index)
{
comboBox1.Items.Clear();
using (financepersonalEntities dbEntity = new financepersonalEntities())
{
var Role = dbEntity.role.Where(m => m.RoleAttr == index).ToList();
for (int i = 0; i < Role.Count; i++)
{
DisplayFieldListItem item2 = new DisplayFieldListItem(Role[i].RoleId.ToString(), Role[i].RoleDefine1);
this.comboBox1.Items.Add(item2);
}
}
this.comboBox1.SelectedIndex = 0;
}
public MainWindow(user custom)
{
InitializeComponent();
u = custom;
this.WindowState = WindowState.Maximized;
this.Title += " 当前账户：" + custom.UserName;
AccountName.Text += custom.UserName;
using (financepersonalEntities dbEntity = new financepersonalEntities())
{
acount ac = dbEntity.acount.Where(m => m.AcountDefine1 == custom.UserName).FirstOrDefault();
AccountBalance.Text += ac.AcountTotal + " 元";
}
Application.Current.MainWindow = this;
}
/// <summary>
/// 批量删除用户
/// </summary>
private void DeleteUsers(List <int> selectUid)
{
if (selectUid.Count > 0)
{
using (financepersonalEntities dbEntity = new financepersonalEntities())
{
foreach (int uid in selectUid)
{
action a = dbEntity.action.Where(m => m.ActionId == uid).FirstOrDefault();
dbEntity.DeleteObject(a);
}
dbEntity.SaveChanges();
}
}
}
private void button1_Click(object sender, RoutedEventArgs e)
{
if (!string.IsNullOrEmpty(textBox1.Text.Trim()) && !string.IsNullOrEmpty(textBox2.Text.Trim()))
{
using (financepersonalEntities dbEntity = new financepersonalEntities())
{
var u = dbEntity.user.Where(m => m.UserName == textBox1.Text.Trim() && m.UserEmail == textBox2.Text.Trim())
.FirstOrDefault();
Dialog.DialogWindow.CreateAlertWindow("密码", u.UserPassword, null).Show();
}
}
else
{
Dialog.DialogWindow.CreateAlertWindow("提示", "必填项不能为空!", null).Show();
}
}
private void button1_Click(object sender, RoutedEventArgs e)
{
DisplayFieldListItem DFL = (DisplayFieldListItem)this.comboBox2.SelectedItem;
DisplayFieldListItem DFL1 = (DisplayFieldListItem)this.comboBox1.SelectedItem;
int ActionUserID = AddUser.UserId;
string ActionName = DFL.ID;
string ActionMoney = textBox1.Text.Trim();
string ActionRole = DFL1.ID;
string ActionTime = datePicker1.Text.Trim();
string ActionComment = textBox6.Text.Trim();
if (!validForm(ActionMoney, ActionTime))
{
Dialog.DialogWindow.CreateAlertWindow("提示", "时间及金额不可为空!", null).Show();
return;
}
if (DFL.ID == "2")
{
ActionMoney = "-" + ActionMoney;
}
using (financepersonalEntities dbEntity = new financepersonalEntities())
{
acount ac = dbEntity.acount.Where(m => m.AcountDefine1 == AddUser.UserName).FirstOrDefault();
ac.AcountTotal = (double.Parse(ActionMoney) + double.Parse(ac.AcountTotal)).ToString();
dbEntity.ObjectStateManager.ChangeObjectState(ac, EntityState.Modified);
action myAction = new action();
myAction.ActionUserId = ActionUserID;
myAction.ActionCountId = ac.AcountId;
myAction.ActionName = ActionName;
myAction.ActionRole = ActionRole;
myAction.ActionTime = DateTime.Parse(ActionTime);
myAction.ActionCommet = ActionComment;
myAction.ActionMoney = ActionMoney;
myAction.ActionDefine3 = "";
dbEntity.action.AddObject(myAction);
dbEntity.SaveChanges();
}
Dialog.DialogWindow.CreateAlertWindow("提示", "保存成功!", null).Show();
}
public void bindData()
{
string userid = myuser.UserId.ToString();
using (financepersonalEntities dbEntity = new financepersonalEntities())
{
IQueryable <myaction> list = dbEntity.action.Join(
dbEntity.user, p => p.ActionUserId, m => m.UserId, (p, m) =>
new myaction {
ActionUser = m.UserName,
ActionId = p.ActionId,
ActionTime = p.ActionTime,
ActionRole = p.ActionRole,
ActionMoney = p.ActionMoney,
ActionCommet = p.ActionCommet
});
List <myaction> mylist = list.ToList();
myGrid.DataContext = mylist;
}
}
private void button1_Click(object sender, RoutedEventArgs e)
{
if (IsNull(textBox1.Text) && IsNull(passwordBox1.Password) && IsNull(textBox3.Text) && IsNull(passwordBox2.Password))
{
if (passwordBox1.Password == passwordBox2.Password)
{
using (financepersonalEntities dbEntity = new financepersonalEntities())
{
user u = new user();
u.UserName = textBox1.Text.Trim();
u.UserPassword = passwordBox1.Password.Trim();
u.UserEmail = textBox3.Text.Trim();
acount ac = new acount();
ac.AcountTotal = "0";
ac.AcountUserId = "xxx";
ac.AcountDefine1 = u.UserName;
dbEntity.user.AddObject(u);
dbEntity.acount.AddObject(ac);
dbEntity.SaveChanges();
Dialog.DialogWindow.CreateAlertWindow("提示", "注册成功!", null).Show();
Login login = new Login();
this.Close();
login.Show();
}
}
else
{
Dialog.DialogWindow.CreateAlertWindow("提示", "两次密码必须一致!", null).Show();
}
}
else
{
Dialog.DialogWindow.CreateAlertWindow("提示", "必填项不能为空!", null).Show();
}
}
/// <summary>
/// 全选
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void CheckBox_Click_1(object sender, RoutedEventArgs e)
{
CheckBox cb = sender as CheckBox;
if (cb.IsChecked == true)
{
using (financepersonalEntities dbEntity = new financepersonalEntities())
{
allUid = dbEntity.action.Select(l => l.ActionId).ToList();
}
for (int i = 0; i < mylist.Count; i++)
{
mylist[i].IsChecked = true;
}
}
else
{
allUid.Clear();
for (int i = 0; i < mylist.Count; i++)
{
mylist[i].IsChecked = false;
}
}
}
