public async Task <IActionResult> AddUserAndRoleAsync(UserAndRoleDto model)
{
try
{
//获取到用户信息
IEnumerable <R_UserInfo> r_UserInfos = await dbContext.r_UserInfoRepository.GetAllInfoAsync();
//根据名称查找到这一条数据
R_UserInfo user = r_UserInfos.ToList().Where(s => s.UserName.Equals(model.User_Name)).FirstOrDefault();
if (user == null)
{
throw new Exception("没有找到这一条信息");
}
User_Role m = new User_Role()
{
RoleID = model.RoleId, UserID = user.UserID
};
dbContext.user_RoleRepository.CreateInfo(m);
if (await dbContext.user_RoleRepository.SaveAsync())
{
return(Ok(1));
}
_logger.LogInformation($"{DateTime.Now.ToString("yyyyMMddHHmmssfff")}同时添加用户和角色信息");
return(Ok("添加失败"));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <IActionResult> UpdateUserInfoAsync(R_UserInfo userInfo)
{
try
{
//判断穿过来的值是否存在
if (await dbContext.r_UserInfoRepository.IsExistAsync(userInfo.UserID))
{
//找到这条数据
R_UserInfo r_UserInfo = await dbContext.r_UserInfoRepository.GetFirstInfo(userInfo.UserID);
r_UserInfo.UserName = userInfo.UserName;
r_UserInfo.UserPassWord = userInfo.UserPassWord;
r_UserInfo.UserCode = userInfo.UserCode;
r_UserInfo.UserSex = userInfo.UserSex;
r_UserInfo.CreateDate = DateTime.Now;
r_UserInfo.Department_ID = userInfo.Department_ID;
r_UserInfo.E_Mail = userInfo.E_Mail;
dbContext.r_UserInfoRepository.UpdateInfo(r_UserInfo);
if (await dbContext.r_UserInfoRepository.SaveAsync())
{
return(Ok(1));
}
}
_logger.LogInformation($"{DateTime.Now.ToString("yyyyMMddmmssfff")}修改员工信息");
//如果不存在
return(NotFound());
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <IActionResult> LoginUserInfoAsync(R_UserInfo r_UserInfo)
{
try
{
//判断传过来的值是否存在
if (await dbContext.r_UserInfoRepository.IsExistAsync(r_UserInfo.UserID))
{
//找到这一条userInfo的数据
R_UserInfo userInfo = await dbContext.r_UserInfoRepository.GetFirstInfo(r_UserInfo.UserID);
//判断登录用户名和密码
if (r_UserInfo.UserName == userInfo.UserName && r_UserInfo.UserPassWord == userInfo.UserPassWord)
{
return(Ok(1));
}
}
_logger.LogInformation($"{DateTime.Now.ToString("yyyyMMddmmssfff")}登录员工信息");
//如果没有找到说明数据不存在
return(NotFound());
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <IActionResult> InsertUserInfoAsync(R_UserInfo r_UserInfo)
{
dbContext.r_UserInfoRepository.CreateInfo(r_UserInfo);
if (await dbContext.r_UserInfoRepository.SaveAsync())
{
return(Ok(1));
}
return(Ok("注册失败"));
}
public FirstPage(R_UserInfo _userInfo)
{
this.userInfo = _userInfo;
InitializeComponent();
this.BackgroundImage = Image.FromFile(@"\\192.168.1.9\CuiJ\SAICVolkswagenVehicleManagement\SAICVolkswagenVehicleManagementUI\SAICVolkswagenVehicleManagementUI\Images\图片1.jpg");
this.BackgroundImageLayout = ImageLayout.Zoom;
//this.datagrid_UserInfo.AutoGenerateColumns = false;
//this.datagrid_UserInfo.DataSource = GetUserInfo();
}
public UpdatePassWordPage(R_UserInfo _UserInfo)
{
this.userInfo = _UserInfo;
InitializeComponent();
this.lab_UserID.Hide();
this.BackgroundImage = Image.FromFile(@"Z:\SAICVolkswagenVehicleManagement\SAICVolkswagenVehicleManagementUI\SAICVolkswagenVehicleManagementUI\Images\图片1.jpg");
//this.BackColor = Color.DeepSkyBlue;
this.BackgroundImageLayout = ImageLayout.Zoom;
}
public async Task <IActionResult> GetFirstUserInfoAsync(Guid userId)
{
//判断传过来的值是否存在
if (await dbContext.r_UserInfoRepository.IsExistAsync(userId))
{
R_UserInfo r_UserInfo = await dbContext.r_UserInfoRepository.GetFirstInfo(userId);
return(Ok(r_UserInfo));
}
//如果没有说明数据不存在
return(NotFound());
}
/// <summary>
/// 跳转到修改密码页面
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void link_UpdatePassWord_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
//获取所有的用户信息
string strUserInfo = httpClient.Get("/UserInfo/GetUserInfo");
Data data = JsonConvert.DeserializeObject <Data>(strUserInfo);
List <R_UserInfo> listUserInfo = JsonConvert.DeserializeObject <List <R_UserInfo> >(data.Result.ToString());
//根据用户名和密码找到这一条数据
R_UserInfo model = listUserInfo.Where(s => s.UserName == txt_User.Text && s.UserPassWord == txt_PassWord.Text).FirstOrDefault();
UpdatePassWordPage updatePassWordPage = new UpdatePassWordPage(model);
updatePassWordPage.ShowDialog();
}
public async Task <IActionResult> UpdateUserInfoAsync(R_UserInfo r_UserInfo)
{
//判断穿过来的值是否存在
if (await dbContext.r_UserInfoRepository.IsExistAsync(r_UserInfo.UserID))
{
//找到这条数据
dbContext.r_UserInfoRepository.UpdateInfo(r_UserInfo);
if (await dbContext.r_UserInfoRepository.SaveAsync())
{
return(Ok(1));
}
}
//如果不存在
return(NotFound());
}
public async Task <IActionResult> DeleteUserInfoAsync(R_UserInfo r_UserInfo)
{
//判断传过来的值是否存在
if (await dbContext.r_UserInfoRepository.IsExistAsync(r_UserInfo.UserID))
{
//找到这条数据
R_UserInfo userInfo = await dbContext.r_UserInfoRepository.GetFirstInfo(r_UserInfo.UserID);
dbContext.r_UserInfoRepository.DeleteInfo(userInfo);
if (await dbContext.r_UserInfoRepository.SaveAsync())
{
return(Ok(1));
}
}
return(NotFound());
}
public async Task <IActionResult> LoginUserInfoAsync(R_UserInfo r_UserInfo)
{
//判断传过来的值是否存在
if (await dbContext.r_UserInfoRepository.IsExistAsync(r_UserInfo.UserID))
{
//找到这一条userInfo的数据
R_UserInfo userInfo = await dbContext.r_UserInfoRepository.GetFirstInfo(r_UserInfo.UserID);
//判断登录用户名和密码
if (r_UserInfo.UserName == userInfo.UserName && r_UserInfo.UserPassWord == userInfo.UserPassWord)
{
return(Ok(1));
}
}
//如果没有找到说明数据不存在
return(NotFound());
}
public async Task <IActionResult> InsertUserInfoAsync(R_UserInfo r_UserInfo)
{
try
{
dbContext.r_UserInfoRepository.CreateInfo(r_UserInfo);
if (await dbContext.r_UserInfoRepository.SaveAsync())
{
return(Ok(1));
}
_logger.LogInformation($"{DateTime.Now.ToString("yyyyMMddmmssfff")}注册员工信息");
return(Ok("注册失败"));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public async Task <IActionResult> GetFirstUserInfoAsync(int userId)
{
try
{
//判断传过来的值是否存在
if (await dbContext.r_UserInfoRepository.IsExistAsync(userId))
{
R_UserInfo r_UserInfo = await dbContext.r_UserInfoRepository.GetFirstInfo(userId);
return(Ok(r_UserInfo));
}
_logger.LogInformation($"{DateTime.Now.ToString("yyyyMMddmmssfff")}获取一条员工信息");
//如果没有说明数据不存在
return(NotFound());
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 点击修改事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_EditPassWord_Click(object sender, EventArgs e)
{
//获取所有的用户信息
string strUserInfo = httpClient.Get("/UserInfo/GetUserInfo");
Data data = JsonConvert.DeserializeObject <Data>(strUserInfo);
List <R_UserInfo> listUserInfo = JsonConvert.DeserializeObject <List <R_UserInfo> >(data.Result.ToString());
//根据用户名和密码找到这一条数据
R_UserInfo model = listUserInfo.Where(s => s.UserName == userInfo.UserName && s.UserPassWord == userInfo.UserPassWord).FirstOrDefault();
if (txt_oldPassWord.Text == model.UserPassWord)
{
if (txt_newPassWord.Text == txt_beginPassWord.Text)
{
model.UserPassWord = this.txt_newPassWord.Text;
//执行修改事件
string jsonData = httpClient.Put("/UserInfo/UpdateUserInfo", model);
Data strData = JsonConvert.DeserializeObject <Data>(jsonData);
if (strData.Result.ToString() == "1")
{
MessageBox.Show("修改成功", "恭喜", MessageBoxButtons.OK, MessageBoxIcon.Information);
LoginPage loginPage = new LoginPage();
this.Hide();
loginPage.Show();
}
else
{
MessageBox.Show("修改失败", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return;
}
}
else
{
MessageBox.Show("两次输入密码不正确", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return;
}
}
else
{
MessageBox.Show("用户不存在", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return;
}
}
public async Task <IActionResult> DeleteUserInfoAsync(int userId)
{
try
{
//判断传过来的值是否存在
if (await dbContext.r_UserInfoRepository.IsExistAsync(userId))
{
//找到这条数据
R_UserInfo userInfo = await dbContext.r_UserInfoRepository.GetFirstInfo(userId);
dbContext.r_UserInfoRepository.DeleteInfo(userInfo);
if (await dbContext.r_UserInfoRepository.SaveAsync())
{
return(Ok(1));
}
}
_logger.LogInformation($"{DateTime.Now.ToString("yyyyMMddmmssfff")}删除员工信息");
return(NotFound());
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
//#region 编辑验证码图片
///// <summary>
///// 编辑验证码图片
///// </summary>
///// <param name="sender"></param>
///// <param name="e"></param>
//string str = string.Empty;
//private void link_ReLoad_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
//{
// Random random = new Random();
// //随机产生5个字符串
// str = string.Empty;
// for (int i = 0; i < 5; i++)
// {
// int j = random.Next(64, 90);
// str = str + (char)j;
// }
// //创建图片
// Bitmap bmp = new Bitmap(120, 30);
// //创建GDI对象
// Graphics g = Graphics.FromImage(bmp);
// //循环画字符串
// for (int i = 0; i < str.Length; i++)
// {
// Point p = new Point(i * 20, 0);
// //随机字体
// string[] fonts = { "宋体", "黑体", "微软雅黑", "隶属", "仿宋" };
// //随机颜色
// Color[] colors = { Color.Red, Color.Aquamarine, Color.Blue, Color.Yellow, Color.Black, Color.Pink };
// //画字符串
// g.DrawString(str[i].ToString(), new Font(fonts[random.Next(0, fonts.Length)], 20, FontStyle.Bold), new SolidBrush(colors[random.Next(0, colors.Length)]), p);
// }
// //画线
// for (int i = 0; i < 10; i++)
// {
// Point p1 = new Point(random.Next(0, bmp.Width), random.Next(0, bmp.Height));
// Point p2 = new Point(random.Next(0, bmp.Width), random.Next(0, bmp.Height));
// g.DrawLine(new Pen(Color.Green), p1, p2);
// }
// //画像素点
// for (int i = 0; i < 200; i++)
// {
// Point p = new Point(random.Next(0, bmp.Width), random.Next(0, bmp.Height));
// bmp.SetPixel(p.X, p.Y, Color.Black);
// }
// //将图片镶嵌到picturebox
// this.Pic.Image = bmp;
//}
//#endregion
#region 点击登录事件
/// <summary>
/// 点击登录事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_Login_Click(object sender, EventArgs e)
{
//获取到所有员工信息
string strUserInfo = httpClient.Get("/UserInfo/GetUserInfo");
Data data = JsonConvert.DeserializeObject <Data>(strUserInfo);
List <R_UserInfo> userList = JsonConvert.DeserializeObject <List <R_UserInfo> >(data.Result.ToString());
R_UserInfo model = userList.Where(s => s.UserName == txt_User.Text && s.UserPassWord == txt_PassWord.Text).FirstOrDefault();
if (model == null)
{
MessageBox.Show("没有当前用户，请重新注册!!!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error);
HomePage homePage = new HomePage();
homePage.ShowDialog();
}
if (!string.IsNullOrEmpty(txt_User.Text))
{
if (txt_User.Text == model.UserName)
{
if (string.IsNullOrEmpty(txt_PassWord.Text))
{
MessageBox.Show("登录密码不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return;
}
else
{
#region 登录成功
if (txt_PassWord.Text == model.UserPassWord)
{
//记住账号密码 自动登录
Configuration cfa = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
cfa.AppSettings.Settings["userName"].Value = this.txt_User.Text; // 账号（默认记住）
if (this.loginCheckBoxIs.Checked)
{
cfa.AppSettings.Settings["autoLogin"].Value = "true";
cfa.AppSettings.Settings["rememberMe"].Value = "true";
cfa.AppSettings.Settings["passWord"].Value = this.txt_PassWord.Text;
}
else
{
if (this.loginCheckBoxUne.Checked)
{
cfa.AppSettings.Settings["autoLogin"].Value = "false"; // 自动登录
cfa.AppSettings.Settings["rememberMe"].Value = "true"; // 自动赋值
cfa.AppSettings.Settings["passWord"].Value = this.txt_PassWord.Text; // 密码
}
else
{
cfa.AppSettings.Settings["autoLogin"].Value = "false"; // 自动登录
cfa.AppSettings.Settings["rememberMe"].Value = "false"; // 自动赋值
cfa.AppSettings.Settings["passWord"].Value = this.txt_PassWord.Text; // 密码
}
}
cfa.Save();//保存数据
MessageBox.Show("登录成功", "恭喜", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Hide();
//登录成功进去首页
FirstPage firstPage = new FirstPage(model);
firstPage.Show();
}
else
{
MessageBox.Show("密码错误，请重新输入!!!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return;
}
#endregion
}
}
else
{
MessageBox.Show("没有当前用户，请重新注册!!!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Error); return;
}
}
else
{
MessageBox.Show("登录用户不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return;
}
}
