public void addUser()
{
if (tb_new_user.Text.Trim() != "" && tb_new_password.Text.Trim() != "" && tb_company.Text.Trim() != "")
{
hailyEntities db = new hailyEntities();
user _user_add = new user();
_user_add.username = tb_new_user.Text;
_user_add.password = EncodeMD5.getMD5(tb_new_password.Text.Trim());//tb_new_password.Text;
_user_add.permission = cb_new_permission.SelectedIndex;
_user_add.company = tb_company.Text;
db.user.Add(_user_add);
db.SaveChanges();
MessageBox.Show("用户创建成功！");
FormMain formMain = new FormMain("userControlPage");
formMain.Show();
this.Close();
}
else if (tb_new_user.Text.Trim() == "")
{
MessageBox.Show("请输入用户名！", "缺少参数", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (tb_new_password.Text.Trim() == "" && tb_new_user.Text.Trim() != "")
{
MessageBox.Show("请输入密码！", "缺少参数", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (tb_new_user.Text.Trim() != "" && tb_new_password.Text.Trim() != "" && tb_company.Text.Trim() == "")
{
MessageBox.Show("请输入公司名！", "缺少参数", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void addSoftware()
{
if (tb_new_soft.Text.Trim() != "" && tb_new_model.Text.Trim() != "" && tb_new_version.Text.Trim() != "")
{
hailyEntities db = new hailyEntities();
software _software_add = new software();
_software_add.name = tb_new_soft.Text;
_software_add.model = tb_new_model.Text; //默认授予新用户的软件模块使用
_software_add.version = tb_new_version.Text;
db.software.Add(_software_add);
db.SaveChanges();
MessageBox.Show("软件添加成功！");
FormMain formMain = new FormMain("softwareControlPage");
formMain.Show();
this.Close();
}
else if (tb_new_soft.Text.Trim() == "")
{
MessageBox.Show("请输入软件名！", "缺少参数", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (tb_new_model.Text.Trim() == "" && tb_new_soft.Text.Trim() != "")
{
MessageBox.Show("请输入模块名！", "缺少参数", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (tb_new_soft.Text.Trim() != "" && tb_new_model.Text.Trim() != "" && tb_new_version.Text.Trim() == "")
{
MessageBox.Show("请输入版本号！", "缺少参数", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public void updateUserInfo(String userName)
{
if (tb_username.Text != null && tb_up_password.Text != null && tb_company.Text != null)
{
hailyEntities db = new hailyEntities();
//查询要获取的对象
var userInfo = from u in db.user
where u.username == userName
select u;
//获得具体对象
var userInfoObject = userInfo.FirstOrDefault();
//修改密码
userInfoObject.password = EncodeMD5.getMD5(tb_up_password.Text.Trim());
////如果用户名与原始用户名不同，则修改用户名
//if (userName != tb_username.Text)
//{
// //用户信息表中的用户名
// userInfoObject.username = tb_username.Text;
// //软件授权记录表中的用户名，也应修改
// var permissionInfo = from u in db.permission
// where u.username == userName
// select u;
// var softwareInfoObject = permissionInfo.FirstOrDefault();
// softwareInfoObject.username = tb_username.Text;
// db.Entry<permission>(softwareInfoObject).State = System.Data.Entity.EntityState.Modified;
//}
userInfoObject.company = tb_company.Text;
userInfoObject.permission = cb_new_permission.SelectedIndex;
//指定状态。
db.Entry <user>(userInfoObject).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
MessageBox.Show("用户信息已更新！");
FormMain formMain = new FormMain("userControlPage");
formMain.Show();
this.Hide();
}
else if (tb_username.Text == null)
{
MessageBox.Show("请输入用户名！", "缺少参数", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (tb_up_password == null && tb_username != null)
{
MessageBox.Show("请输入密码！", "缺少参数", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
MessageBox.Show("请重新输入用户信息！", "缺少参数", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
void DataGridViewX1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int column = dgv_user_control.CurrentCell.ColumnIndex;
int row = dgv_user_control.CurrentCell.RowIndex;
String _userName = list_user_control[row].username;
//修改密码
if (column == 2)
{
FormUpdateUserInfo formUpdateUserInfo = new FormUpdateUserInfo(list_user_control[row]);
formUpdateUserInfo.ShowDialog();
this.Hide();
}
//注销用户
if (column == 3)
{
////从数据库中删除用户,包括 用户表
var userInfoList = from u in db.user
where u.username == _userName
select u;
user _userInfo = userInfoList.FirstOrDefault();
if (_userInfo != null)
{
DialogResult result = MessageBox.Show("确定注销用户用户“" + _userName + "”？", "提示窗口", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (result == DialogResult.Yes)
{
db.user.Remove(_userInfo);
db.SaveChanges();
MessageBox.Show("已移除用户" + _userName);
dgv_user_control.Rows.Clear();
list_user_control.Clear();
//刷新 用户管理页面
data_user_initialize();
}
else if (result == DialogResult.No)
{
//不进行操作，关闭提示窗即可
}
}
else
{
MessageBox.Show("移除用户失败！");
}
}
}
public void updateSoftwareInfo()
{
if (tb_up_software.Text != null && tb_up_model.Text != null && tb_up_version.Text != null)
{
hailyEntities db = new hailyEntities();
//查询要获取的对象
var softwareInfo = from u in db.software
where (u.name == soft_main.name && u.model == soft_main.model && u.version == soft_main.version)
select u;
//获得具体对象
var softwareInfoObject = softwareInfo.FirstOrDefault();
//修改软件名
softwareInfoObject.name = tb_up_software.Text.Trim();
softwareInfoObject.model = tb_up_model.Text.Trim();
softwareInfoObject.version = tb_up_version.Text.Trim();
//指定状态。
db.Entry <software>(softwareInfoObject).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
MessageBox.Show("软件信息已更新！");
this.Close();
}
else if (tb_up_software.Text == null)
{
MessageBox.Show("请输入软件名！", "缺少参数", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (tb_up_model == null && tb_up_software != null)
{
MessageBox.Show("请输入模块名！", "缺少参数", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (tb_up_software.Text != null && tb_up_model.Text != null && tb_up_version.Text == null)
{
MessageBox.Show("请输入软件版本号！", "缺少参数", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
