public Result Kayit(Entity.Users user)
{
Result result = new Result();
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
}
SqlCommand cmd = new SqlCommand("Insert Into Users (UserName, Password, Name, Surname) Values (@UserName, @Password, @Name, @Surname)", cnn);
cmd.Parameters.AddWithValue("@UserName", user.UserName);
cmd.Parameters.AddWithValue("@Password", user.Password);
cmd.Parameters.AddWithValue("@Name", user.Name);
cmd.Parameters.AddWithValue("@Surname", user.Surname);
// cmd.Parameters.AddWithValue("@Email", user.Email);
int sonuc = cmd.ExecuteNonQuery();
if (sonuc > 0)
{
result.IsSucceeded = true;
}
cnn.Close();
//reader.Close();
return(result);
}
private void button6_Click(object sender, EventArgs e)
{
Entity.Users users = new Entity.Users();
try
{
users.uID = int.Parse(this.textBox1.Text);
if (users.uID == 10000)
{
Msg.Box.Show("最高权限账户，禁止删除！", "系统警告", Msg.Box.Ico.Warining);
return;
}
bool isDel = Msg.Box.RShow("是否确认删除改账户？", "删除提示", Msg.Box.Ico.Question);
if (isDel == true)
{
if (BLL.quanli.TeDelete(users) == true)
{
Msg.Box.Show("恭喜您，删除成功！", "成功提示", Msg.Box.Ico.Info);
}
}
}
catch (Entity.HrmException he)
{
Msg.Box.Show(he.Message);
}
this.dataGridView1.DataSource = BLL.quanli.ADm();
}
/// <summary>
/// 获取用户信息
/// </summary>
public static int UserInfo(Entity.Users users, out string msg)
{
//成功登录帐号
System.Data.DataTable dt = DAL.LoginDAL.UserInfo(users);
users.uID = int.Parse(dt.Rows[0][0].ToString());
users.sex = char.Parse(dt.Rows[0][4].ToString());
users.age = int.Parse(dt.Rows[0][5].ToString());
users.logo = dt.Rows[0][6].ToString();
users.state = dt.Rows[0][7].ToString();
users.lastTime = DateTime.Parse(dt.Rows[0][8].ToString());
users.uMail = dt.Rows[0][2].ToString();
msg = "";
int i = -1;
if (users.state == "待审核")
{
msg = "您的账号还未启用！";
i = 0;
}
else if (users.state == "禁用")
{
msg = "抱歉，您的账号已被禁用！";
i = 0;
}
else if (users.state == "启用")
{
i = 1;
}
return(i);
}
public UserLogo(Main m, Entity.Users u)
{
this.ma = m;
this.users = u;
InitializeComponent();
string path = @"Source\User\" + users.logo + ".png";
this.pic_logo.Image = Image.FromFile(path);
}
public Main(Entity.Users u)
{
InitializeComponent();
startTime = System.DateTime.Now;
this.lbl_nowTime.Text = startTime.ToString();
users = u;
this.lbl_userID.Text = users.uID.ToString();
this.lbl_userName.Text = users.uName.ToString();
this.lbl_lastTime.Text = users.lastTime.ToString();
LoadUserLogo();
}
public static void UpLastTime(Entity.Users user)
{
if (DAL.LoginDAL.UpLastTime(user) > 0)
{
// throw new Exception("时间更新成功！");
}
else
{
// throw new Exception("时间更新失败！");
}
}
/// <summary>
/// 验证账户名称
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
public static bool CheckName(Entity.Users u)
{
if (DAL.Users.CheckName(u) > 0)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// 更新用户头像
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
public static bool UpLogo(Entity.Users u)
{
if (DAL.Users.UpLogo(u) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 修改用户密码
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public static bool PassChange(Entity.Users users)
{
if (DAL.Users.PassChange(users) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 注册账户
/// </summary>
/// <param name="users"></param>
/// <returns></returns>
public static bool RegUsers(Entity.Users users)
{
if (DAL.LoginDAL.RegUser(users) > 0)
{
return(true);
}
else
{
return(false);
}
}
//登录功能
private void btn_login_Click(object sender, EventArgs e)
{
//判断是否为空
if (this.txt_id.Text == "" || this.txt_pass.Text == "")
{
this.pic_tip.Visible = true;
this.lbl_tip.Visible = true;
this.lbl_tip.Text = "帐号或密码不能为空！";
return;
}
Entity.Users users = new Entity.Users();
users.uName = this.txt_id.Text;
users.uPwd = this.txt_pass.Text;
//声明变量接收登陆情况
bool IsTrue;
try
{
IsTrue = BLL.LoginBLL.TestLogin(users);
}
catch (Exception)
{
Msg.Box.Show("请先将软件连接至数据库！", "警告信息", Msg.Box.Ico.Warining);
return;
}
//错误提示
if (IsTrue == false)
{
this.pic_tip.Visible = true;
this.lbl_tip.Visible = true;
this.lbl_tip.Text = "帐号或密码错误！";
return;
}
else
{
string msg;
if (BLL.LoginBLL.UserInfo(users, out msg) == 0)
{
this.pic_tip.Visible = true;
this.lbl_tip.Visible = true;
this.lbl_tip.Text = msg;
}
else
{
(new Main(users)).Show(this);
this.Hide();
this.ico_all.Visible = false;
}
}
}
private void BtnLogin_Click(object sender, RoutedEventArgs e)
{
Entity.Users CurrentUser = AppData.Context.Users.ToList().Where(user => user.Login == TBoxLogin.Text && user.Password == PBoxPasswod.Password).FirstOrDefault();
if (CurrentUser == null)
{
MessageBox.Show(Properties.Resources.WrongPass);
if (CountEnter == 3)
{
_startDate = DateTime.Now;
_dispatchertimer.Start();
CountEnter = 0;
BtnLogin.IsEnabled = false;
}
else
{
CountEnter += 1;
}
}
else
{
if (_capchaText != TBCapt.Text)
{
MessageBox.Show("Неверный текст капчи!", Properties.Resources.CaptionError, MessageBoxButton.OK, MessageBoxImage.Error);
ImgCapcha.Source = Drawing(Convert.ToInt32(ImgCapcha.Width), Convert.ToInt32(ImgCapcha.Height));
return;
}
AppData.currentUser = CurrentUser;
switch (CurrentUser.RoleId)
{
case 0:
{
AppData.MainFrame.Navigate(new Pages.AdminPagesMenu());
break;
}
case 1:
{
AppData.MainFrame.Navigate(new Pages.SellerPagesMenu());
break;
}
case 2:
{
AppData.MainFrame.Navigate(new Pages.ManagerPagesMenu());
break;
}
default:
break;
}
}
ImgCapcha.Source = Drawing(Convert.ToInt32(ImgCapcha.Width), Convert.ToInt32(ImgCapcha.Height));
}
private void button2_Click(object sender, EventArgs e)
{
Entity.Users entity = new Entity.Users();
entity.Name = "hyilmaz";
entity.BirthDate = new DateTime(1991, 06, 13);
entity.DateCreated = DateTime.Now;
entity.DateModifed = DateTime.Now.AddDays(-5);
entity.UserIDCreated = -1;
entity.UserIDModified = 5;
new Business.UserManager().Update(entity);
}
private void button1_Click(object sender, EventArgs e)
{
Entity.Users entity = new Entity.Users();
entity.Name = "hyilmaz";
entity.BirthDate = new DateTime(1991, 06, 13);
entity.DateCreated = DateTime.Now;
entity.DateModifed = DateTime.Now.AddDays(-5);
entity.UserIDCreated = -1;
entity.UserIDModified = 5;
MessageBox.Show(new Business.UserManager().Add(entity).ToString());
}
private void button8_Click(object sender, EventArgs e)
{
Entity.Users entity = new Entity.Users();
entity.Name = "hyilmaz";
entity.BirthDate = new DateTime(1991, 06, 13);
entity.DateCreated = DateTime.Now;
entity.DateModifed = DateTime.Now.AddDays(-5);
entity.UserIDCreated = -1;
entity.UserIDModified = 5;
Entity.Users entityNew = Helper.Object.Clone <Entity.Users>(entity);
entityNew.BirthDate = DateTime.Now;
bool IsChanged = Helper.Object.IsChanged(entity, entityNew);
new Business.UserManager().Update(entity, entityNew);
}
public ActionResult AddTestAccount()
{
InitInfo.Instance.SetCurrentModule("Admin", "User", "AddTestAccount");
Entity.Users editUser = null;
//有ID说明是编辑状态
if (Request["ID"] != null && !string.IsNullOrWhiteSpace(Request["ID"].ToString()))
{
IUsersService usersService = ServiceFactory.Create <IUsersService>();
editUser = usersService.GetEntity(Convert.ToInt32(Request["ID"]));
//如果不是管理员，也不是内部销售，也不是本店的员工，则无权限修改
if (!CurrentInfo.IsAdministrator && CurrentInfo.CurrentUser.Remark != "B4内部销售" && editUser.DefaultStoreID != CurrentInfo.CurrentStore.ID)
{
return(RedirectToAction("Error403", "Home", new { area = "Admin" }));
}
}
//editUser为null的时候说明是添加
int?shopID = editUser == null ? CurrentInfo.CurrentShop.ID : editUser.ShopsID;
int?storeID = editUser == null ? CurrentInfo.CurrentStore.ID : editUser.DefaultStoreID;
IStoresService storesService = ServiceFactory.Create <IStoresService>();
List <Stores> allStores = storesService.GetEntities(t => t.ShopId == shopID && t.Disabled == false).ToList(); // CurrentInfo.CurrentShop.ID
SelectList allStoresSelect = new SelectList(allStores, "ID", "StoreName", storeID); // CurrentInfo.CurrentStore.ID
ViewData["allStoresSelect"] = allStoresSelect;
//在添加测试账号的时候则默认不显示，只允许添加到测试门店里面
ViewData["showStores"] = false;
ViewBag.IsIntention = true;
//账号版本，测试账号开户用得到，其他无用
List <SelectListItem> listShopType = new List <SelectListItem>();
foreach (var item in Enum.GetValues(typeof(ShopTypeEnum)))
{
listShopType.Add(new SelectListItem
{
Text = item.ToString(),
Value = ((int)item).ToString()
});
}
//InventoryDetailsType.Insert(0, new SelectListItem { Text = "所有类别", Value = "0" });
//InventoryDetailsType[6].Selected = true;
ViewData["ListShopType"] = new SelectList(listShopType, "Value", "Text", "1");
ViewBag.BackUrl = "/Admin/IntentionUser/Index";
return(View("ShowAddUser"));
}
public ActionResult ShowAddUser()
{
InitInfo.Instance.SetCurrentModule("Admin", "User", "Index");
Entity.Users editUser = null;
//有ID说明是编辑状态
if (Request["ID"] != null)
{
IUsersService usersService = ServiceFactory.Create <IUsersService>();
editUser = usersService.GetEntity(Convert.ToInt32(Request["ID"]));
//如果不是管理员，并且不是店铺内部人员，禁止修改改员工信息
if (!CurrentInfo.IsAdministrator && CurrentInfo.CurrentUser.Remark != "B4内部销售" && editUser.Stores.ShopId != CurrentInfo.CurrentShop.ID)
{
return(RedirectToAction("Error403", "Home", new { area = "Admin" }));
}
}
//editUser为null的时候说明是添加
int?shopID = editUser == null ? CurrentInfo.CurrentShop.ID : editUser.ShopsID;
int?storeID = editUser == null ? CurrentInfo.CurrentStore.ID : editUser.DefaultStoreID;
IStoresService storesService = ServiceFactory.Create <IStoresService>();
List <Stores> allStores = storesService.GetEntities(t => t.ShopId == shopID && t.Disabled == false).ToList(); // CurrentInfo.CurrentShop.ID
SelectList allStoresSelect = new SelectList(allStores, "ID", "StoreName", storeID); // CurrentInfo.CurrentStore.ID
ViewData["allStoresSelect"] = allStoresSelect;
//只有管理员才能给所有店铺添加人员
ViewData["showStores"] = CurrentInfo.IsShopAdmin;
ViewBag.IsIntention = false;
//账号版本，测试账号开户用得到，其他无用
List <SelectListItem> listShopType = new List <SelectListItem>();
foreach (var item in Enum.GetValues(typeof(ShopTypeEnum)))
{
listShopType.Add(new SelectListItem
{
Text = item.ToString(),
Value = ((int)item).ToString()
});
}
//InventoryDetailsType.Insert(0, new SelectListItem { Text = "所有类别", Value = "0" });
//InventoryDetailsType[6].Selected = true;
ViewData["ListShopType"] = new SelectList(listShopType, "Value", "Text", "1");
return(View());
}
private void button5_Click(object sender, EventArgs e)
{
Entity.Users users = new Entity.Users();
int i = -1;
int a = -1;
try
{
i = int.Parse(this.textBox1.Text);
a = int.Parse(this.textBox4.Text);
}
catch
{
Msg.Box.Show("请输入正确的格式！");
return;
}
try
{
users.uID = i;
users.uName = this.textBox2.Text;
users.uPwd = this.textBox3.Text;
char sex;
if (this.radioButton1.Checked)
{
sex = char.Parse(this.radioButton1.Text);
}
else
{
sex = char.Parse(this.radioButton2.Text);
}
users.sex = sex;
users.age = a;
users.state = this.comboBox1.Text;
bool IsTrue = BLL.quanli.Testusers(users);
if (IsTrue == true)
{
Msg.Box.Show("修改成功！", "成功提示", Msg.Box.Ico.Info);
}
}
catch (Entity.HrmException he)
{
Msg.Box.Show(he.Message);
}
this.dataGridView1.DataSource = BLL.quanli.ADm();
}
public ChangeInfo(Entity.Users u)
{
this.users = u;
InitializeComponent();
this.txt_uid.Text = users.uID.ToString();
this.txt_uname.Text = users.uName;
this.txt_mail.Text = users.uMail.ToString();
this.txt_age.Text = users.age.ToString();
if (users.sex == '男')
{
this.rad_man.Checked = true;
}
else
{
this.rad_wowen.Checked = true;
}
this.cmb_state.Text = users.state;
}
public ActionResult ModifyPasswordAjax(string oldPassword, string newPassword, string confirmPassword)
{
IUsersService usersService = ServiceFactory.Create <IUsersService>();
if (string.IsNullOrWhiteSpace(newPassword))
{
return(Json(new Result(false, "密码不能为空"), JsonRequestBehavior.AllowGet));
}
if (newPassword != confirmPassword)
{
return(Json(new Result(false, "两次输入的新密码不一致"), JsonRequestBehavior.AllowGet));
}
Entity.Users dbUser = usersService.GetEntity(CurrentInfo.CurrentUser.ID);
string oldPasswordMd5 = Common.SecureHelper.MD5(oldPassword + dbUser.PasswordSalt);
if (oldPasswordMd5 != dbUser.Password)
{
return(Json(new Result(false, "原始密码错误，修改失败"), JsonRequestBehavior.AllowGet));
}
else
{
//修改账号PasswordSalt要判断是否是管理员
dbUser.PasswordSalt = Common.TextFilter.GetPasswordSalt(UserIsAdministrator(dbUser));//.Substring(Guid.NewGuid().ToString("N"), 10, false);
string endPassword = newPassword + dbUser.PasswordSalt;
//计算密码
dbUser.Password = Common.SecureHelper.MD5(endPassword);
}
bool success = usersService.UpdateEntity(dbUser);
if (success)
{
return(Json(new Result(true, "修改成功，请使用新密码登录系统"), JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new Result(false, "修改失败"), JsonRequestBehavior.AllowGet));
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
string username = txtUserName.Text.Trim(); //获取界面输入的用户名
string password = txtPassword.Text.Trim(); //获取界面输入的密码
Entity.Users users = new Entity.Users();
users.username = username;
users.password = password;
if (username == "") //判断用户名是否为空
{
MessageBox.Show("请输入用户名！", "温馨提示");
}
else if (password == "")
{
MessageBox.Show("请输入密码！", "温馨提示");
}
else
{
Facade.Users user = new Facade.Users();
bool result = user.username(username);
if (result == false) //判断用户是否存在
{
MessageBox.Show("您输入的用户名不存在！", "温馨提示");
}
else
{
//判断密码是否正确？
Facade.Users pwd = new Facade.Users();
bool result2 = pwd.Password(users);
if (result2 == true)
{
this.DialogResult = DialogResult.OK; //上面的执行成功则显示主窗体
}
else
{
MessageBox.Show("密码错误，请重新输入！", "温馨提示");
}
}
}
}
public int AddUser(PharmaBusinessObjects.Master.UserMaster p)
{
using (PharmaDBEntities context = new PharmaDBEntities())
{
Entity.Users table = new Entity.Users()
{
Username = p.Username,
Password = p.Password,
FirstName = p.FirstName,
LastName = p.LastName,
RoleID = p.RoleID,
IsSysAdmin = p.IsSystemAdmin,
CreatedBy = this.LoggedInUser.Username,
CreatedOn = System.DateTime.Now,
Status = p.Status
};
context.Users.Add(table);
return(context.SaveChanges());
}
}
private void btn_add_Click(object sender, EventArgs e)
{
Entity.Users users = new Entity.Users();
try
{
users.uName = this.textBox2.Text;
users.uPwd = this.textBox3.Text;
char sex;
if (this.radioButton1.Checked)
{
sex = char.Parse(this.radioButton1.Text);
}
else
{
sex = char.Parse(this.radioButton2.Text);
}
users.sex = sex;
users.age = int.Parse(this.textBox4.Text);
users.state = this.comboBox1.Text;
users.uMail = "请及时修改为您的邮箱账号！";
}
catch (Entity.HrmException he)
{
Msg.Box.Show(he.Message);
return;
}
if (BLL.quanli.CheckName(users) == false)
{
Msg.Box.Show("此账户名已存在，请勿重复添加！");
return;
}
bool IsAdd = BLL.quanli.TeAdd(users);
if (IsAdd == true)
{
Msg.Box.Show("新增管理员" + users.uName + "成功！", "成功提示", Msg.Box.Ico.Info);
}
this.dataGridView1.DataSource = BLL.quanli.ADm();
}
private int CheckData(Entity.Users user)
{
if (user.Fullname.Length == 0)
{
return(0);
}
else if (user.Username.Length == 0)
{
return(0);
}
else if (user.Password.Length == 0)
{
return(0);
}
else if (user.Phone.Length == 0)
{
return(0);
}
else if (user.Address.Length == 0)
{
return(0);
}
else if (user.Email.Length == 0)
{
return(0);
}
else if (user.Gender.Length == 0)
{
return(0);
}
else
{
return(1);
}
}
public MessageTo(Entity.Users u)
{
this.user = u;
InitializeComponent();
}
public AppraiseBySelf(Entity.Users u)
{
this.users = u;
InitializeComponent();
}
public static bool IsHave(Entity.Users users)
{
return(DAL.Users.IsHave(users));
}
public MoneyPanle(Entity.Users u)
{
this.users = u;
InitializeComponent();
}
public MoneyAdd(Entity.Users u)
{
this.users = u;
InitializeComponent();
this.textBox4.Text = users.uName;
}
public AppraiseForm(Entity.Users u)
{
this.users = u;
InitializeComponent();
this.textBox2.Text = users.uName;
}
