/// <summary> /// 判断用户是否存在 /// </summary> /// <param name="username">用户名</param> /// <returns></returns> public bool SelectUser(string username) { DAL.Users user = new DAL.Users(); bool result = user.SelectUser(username); return(result); }
/// <summary> /// 用户登录,http://mobile.huobi3j.com/user/login /// </summary> /// <param name="username">用户名</param> /// <param name="password">密码(不加密)</param> /// <returns></returns> public ActionResult Login(string username,string password) { if (string.IsNullOrWhiteSpace(username) || string.IsNullOrWhiteSpace(password)) { return GetJson(new JsonResponse { status = false, message = "参数有误!" }); } string pwdMd5 = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(password, "md5"); DAL.Users dal = new DAL.Users(); Model.Users user = null; if (Regex.IsMatch(username, @"^\d+$"))//通讯号码 { user = dal.GetEntity(new string[] { "CheckState", "UIN", "LoginPwd" }, 1, username, pwdMd5); } else if (Regex.IsMatch(username, Validator.EmailPattern)) { user = dal.GetEntity(new string[] { "CheckState", "Email", "LoginPwd" }, 1, username, pwdMd5); } else if (Regex.IsMatch(username, @"\w+") /*&& Regex.IsMatch(loginKey, @"\d+")*/ )//自定义登陆帐号 { user = dal.GetEntity(new string[] { "CheckState", "LoginName", "LoginPwd" }, 1, username, pwdMd5); } else { return null; } if (user == null) { return GetJson(new JsonResponse { status = false, message = "用户不存在!" }); } return GetJson(new { status = true, data = user }); }
/// <summary> /// 用户删除操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnUdelete2_Click(object sender, EventArgs e) { BLL.UsersBLL objUB = new BLL.UsersBLL(); if (dataGridView2.SelectedRows.Count > 0) { if (MessageBox.Show("确认要删除该行数据吗?", "删除确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { int rst = dataGridView2.SelectedRows.Count; foreach (DataGridViewRow dr in dataGridView2.SelectedRows) { DAL.Users objU = new DAL.Users(); objU.uid = (int)dr.Cells["uid"].Value; rst -= objUB.Delete(objU); } if (rst == 0) { MessageBox.Show("删除成功"); BLL.UsersBLL objU = new BLL.UsersBLL(); dataGridView2.DataSource = objU.GetList(x => true); dataGridView2.Refresh(); } else { MessageBox.Show("删除失败"); } } } else { MessageBox.Show("请先选中要删除的数据"); } }
private void LoadData() { var savePath = @"d:\"; var userDAL = new DAL.Users(); var poiBLL = new PoiBLL(); var users = userDAL.Select("RegTime > '2005-05-30'", ""); if (!Directory.Exists(Path.Combine(savePath, "poi"))) Directory.CreateDirectory(Path.Combine(savePath, "poi")); foreach (DataRow row in users.Rows) { var userid = row["id"].ToInt(); if (userid <= 0) continue; var index = 0; while (true) { var searchResults = GetGeoSearchResult(userid, index); if (searchResults.IsNull() || searchResults.size <= 0) break; //File.AppendAllText(Path.Combine(savePath, "poi", string.Format("{0}_{1}.txt", userid, index)), JsonConvert.SerializeObject(searchResults)); File.WriteAllText(Path.Combine(savePath, "poi", string.Format("{0}_{1}.txt", userid, index)), JsonConvert.SerializeObject(searchResults)); index++; Thread.Sleep(100); } } }
public static UserDto ToDtoUser(DAL.Users e) { Common.DTO.UserDto ev = new Common.DTO.UserDto(); ev.user_email = e.user_email; ev.user_password = e.user_password; return(ev); }
/// <summary> /// 删除子用户 /// </summary> /// <param name="arg"></param> /// <returns></returns> public Task <IApiResult> DelUserInfo(P_Users.P_DelUser arg) { return(Task.Run(() => { IApiResult ar = new IApiResult(); try { using (DAL.CarRentEntities db = new DAL.CarRentEntities()) { DAL.Users us = new DAL.Users(); var res = db.Users.First(u => u.UserID == arg.userid); res.Deleted = true; int count = db.SaveChanges(); ar.message = $"delete{count}a data success!"; ar.result = new { url = "" }; } } catch (Exception ex) { Log.Error(this, ex); ar.code = StatusCode.error; ar.message = ex.Message; } return ar; })); }
public static string GetNowUserType() { string ID = AuthenHelper.GetLoginUserData(); DBA.DAL.Users dale = new DAL.Users(); return(dale.GetModel(Convert.ToInt32(ID)).Usertype.Trim()); }
public static DAL.Users ToDalUser(UserDto e) { DAL.Users ev = new DAL.Users(); ev.user_email = e.user_email; ev.user_password = e.user_password; return(ev); }
private void LoadUsers() { try { DAL.Users dalUser = new DAL.Users(); dalUser.connectionstring = objDAL.connectionstring; DataTable dt = dalUser.getRecord(" AND Isnull(IsSuperAdmin,0)=0"); DataRow dr = dt.NewRow(); dr["UserID"] = "0"; dr["UserName"] = "******"; dt.Rows.Add(dr); if (dt.Rows.Count > 0) { cboUsers.DisplayMember = "UserName"; cboUsers.ValueMember = "UserID"; cboUsers.DataSource = dt; } cboUsers.SelectedValue = 0; cboUsers.SelectedText = "ALL"; //cboUsers.SelectedIndex = -1; } catch (Exception exc) { MessageBox.Show(exc.Message.ToString(), "Error"); } }
//记录注销日志 protected void HeadLoginStatus_LoggingOut(object sender, LoginCancelEventArgs e) { if (Session["UserInfo"] != null) { DAL.Users userInfo = Session["UserInfo"] as DAL.Users; string userID = userInfo == null ? "" : (userInfo.UserId == null ? "" : userInfo.UserId); Utility.LogHelper.WriteLog(Utility.LogHelper.LogLevel.Info, "用户[" + userID + "]退出系统!"); } }
protected void NavigationMenu_DataBound(object sender, EventArgs e) { if (Session["UserInfo"] == null) { return; } if (this.IsPostBack) { return; } DAL.Users userInfo = Session["UserInfo"] as DAL.Users; string userID = userInfo == null ? "" : userInfo.UserId; //获取sitemap中的所有节点 SiteMapNodeCollection list = SiteMap.RootNode.GetAllNodes(); //获取该用户下拥有的所有角色 string[] roleNameList = Roles.GetRolesForUser(userID); //该用户各个角色拥有的菜单功能项 List <string[]> menuItemTitleHas = new List <string[]>(); //取出拥有的菜单后,将List中各个String[]取并集,显示给页面 foreach (string role in roleNameList) { List <string> strTheRoleHasMenu = new List <string>(); GetItem(NavigationMenu, list, role, out strTheRoleHasMenu);//遍历每个角色下拥有的菜单项 if (strTheRoleHasMenu.Count > 0) { menuItemTitleHas.Add(strTheRoleHasMenu.ToArray()); } } //合并权限菜单并集 List <string> theUserHasMenu = new List <string>(); foreach (string[] strList in menuItemTitleHas) { foreach (string str in strList) { if (theUserHasMenu.Contains(str) == false) { theUserHasMenu.Add(str); } } } //设置菜单显示 SetMenuItemShow(ref this.NavigationMenu, theUserHasMenu); }
private void btnSave_Click(object sender, EventArgs e) { int er = 0; ep.Clear(); if (txtName.Text == "") { er++; ep.SetError(txtName, "Name is requird"); } if (txtEmail.Text == "") { er++; ep.SetError(txtEmail, "Email Required"); } if (txtPassword.Text == "") { er++; ep.SetError(txtPassword, "Required"); } if (er == 0) { DAL.Users usr = new DAL.Users(); usr.Name = txtName.Text; usr.Email = txtEmail.Text; //usr.Password = Cryptography.Encryption.Encrypt(txtPassword.Text, "1234"); usr.Password = txtPassword.Text; usr.Type = comboBox1.Text; usr.CreateIP = "127.0.0.1"; // usr.CreateDate = DateTime.Now; if (usr.Insert()) { MessageBox.Show("Data Saved"); txtName.Text = ""; txtEmail.Text = ""; txtPassword.Text = ""; comboBox1.SelectedIndex = 0; txtName.Focus(); } else { MessageBox.Show(usr.Error); } } }
public bool LoginCheck() { Users usr = new DAL.Users(); usr.Email = Email; usr.Password = Password; if (usr.SelectByOthers()) { this.Email = usr.Email; this.LoginId = usr.Id; this.Name = usr.Name; this.Type = usr.Type; return(true); } return(false); }
/// <summary> /// 根据模型数据,完成表格的插入 /// </summary> /// <param name="Data"></param> /// <returns></returns> public int Add(DAL.Users Data) { try { //向数据上下文数据表中增加一个 模型对象(实体) objDAL.Users.InsertOnSubmit(Data); //更新数据上下文改变到数据库 objDAL.SubmitChanges(); return(1); } catch (Exception) { return(0); } //return objDAL.Add(Data); }
private void frmUserUpdate_Load(object sender, EventArgs e) { DAL.Users objU = objUB.GetModel(ID); txtId.Text = (objU.uid).ToString(); txtName.Text = objU.uname; txtPwd.Text = objU.upwd; txtSchool.Text = objU.uschool; if (objU.usex == '男'.ToString()) { rbMale.Checked = true; } else { rbFemale.Checked = true; } }
/// <summary> /// 根据模型中的uid删除指定行 /// </summary> /// <param name="Data"></param> /// <returns></returns> public int Delete(DAL.Users Data) { try { //找到数据上下文中,满足条件的记录 DAL.Users objT = objDAL.Users.First(x => x.uid == Data.uid); //删除该记录 objDAL.Users.DeleteOnSubmit(objT); //更新数据上下文改变到数据库 objDAL.SubmitChanges(); return(1); } catch (Exception) { return(0); } }
private void btnUmodify_Click(object sender, EventArgs e) { DAL.Users objU = new DAL.Users(); objU.uid = int.Parse(txtId.Text); objU.uname = txtName.Text; objU.upwd = txtPwd.Text; objU.uschool = txtSchool.Text; objU.usex = (rbMale.Checked ? '男' : '女').ToString(); if (objUB.Update(objU) > 0) { MessageBox.Show("修改成功"); } else { MessageBox.Show("修改失败"); } }
protected void btnSubmit_OnClick(object sender, EventArgs e) { long uin = ADeeWu.HuoBi3J.Libary.Utility.GetInt(this.txtUIN.Text, 0); string notes = ADeeWu.HuoBi3J.Libary.WebUtility.GetTextAreaContent(this.txtNotes.Text).Trim(); int coins = ADeeWu.HuoBi3J.Libary.Utility.GetInt(this.txtMoney.Text, 0); if (uin <= 0) { ADeeWu.HuoBi3J.Libary.WebUtility.ShowMsg("UIN号码必须为纯数字!"); return; } if (coins <= 0) { ADeeWu.HuoBi3J.Libary.WebUtility.ShowMsg("请填写正确货币数量!"); return; } Model.Users user = new DAL.Users().GetEntity(string.Format("uin = '{0}'", uin)); if (user == null || user.ID == 0) { WebUtility.ShowMsg("不存在此UIN号码!"); return; } db.Parameters.Append("@UserID", user.ID); db.Parameters.Append("@Coins", coins); db.Parameters.Append("@IsUseCoin", false); db.Parameters.Append("@Notes", notes); db.Parameters.Append("@ErrorMessage", "", ParameterDirection.Output, DbType.String).Size = 1000; db.AutoClearParameters = false; if (ADeeWu.HuoBi3J.Libary.Utility.GetInt(db.RunProc("SP_User_DoCoinsTrans"), -1) == 0) { ADeeWu.HuoBi3J.Libary.WebUtility.ShowPageSelector(this, "操作成功!选择\"是\"继续操作", "Add.aspx", "list.aspx"); } else { ADeeWu.HuoBi3J.Libary.WebUtility.ShowMsg("操作失败!错误原因:\r\n" + db.Parameters["@ErrorMessage"].Value.ToString()); } db.Parameters.Clear(); db.AutoClearParameters = true; }
/// <summary> /// 根据uid指定要删除的行,其余字段用于表示要修改的数据值 /// </summary> /// <param name="Data"></param> /// <returns></returns> public int Update(DAL.Users Data) { try { //找到数据上下文中,满足条件的记录 DAL.Users objT = objDAL.Users.First(x => x.uid == Data.uid); //修改数据记录 objT.uname = Data.uname; objT.usex = Data.usex; objT.upwd = Data.upwd; objT.uschool = Data.uschool; //更新数据上下文改变到数据库 objDAL.SubmitChanges(); return(1); } catch (Exception) { return(0); } }
/// <summary> /// 添加子用户 /// </summary> /// <param name="arg"></param> /// <returns></returns> public Task <IApiResult> AddUsers(P_Users.P_AddUsers arg) { return(Task.Run(() => { IApiResult ar = new IApiResult(); try { using (DAL.CarRentEntities db = new DAL.CarRentEntities()) { DAL.Users us = new DAL.Users(); us.UserName = arg.username; us.LoginName = arg.account; us.FirstName = arg.contact; us.CellPhone = arg.phone; us.Password = "******"; us.Address1 = arg.address; us.Deleted = false; us.PrimaryEmail = arg.email; us.Created = DateTime.Now; us.UpdateTime = DateTime.Now; us.AllDeviceCount = 0; us.ActivationCount = arg.price * 100; us.MoneyCount = 0; us.ParentID = 1; us.SuperAdmin = 0; db.Users.Add(us); db.SaveChanges(); ar.message = "Add successfu!"; ar.result = new { url = "reload" }; } } catch (Exception ex) { Log.Error(this, ex); ar.code = StatusCode.error; ar.message = ex.Message; } return ar; })); }
/// <summary> /// 注册用户信息 /// </summary> /// <param name="arg"></param> /// <returns></returns> public async Task <IApiResult> Register(Mgoo.CarRent.Models.Parameter.PRegister arg) { return(await Task.Run(() => { var ar = new IApiResult(); try { DAL.Users user = new DAL.Users(); user.Created = DateTime.Now; user.UpdateTime = DateTime.Now; user.UserName = arg.username; user.Password = arg.password; user.LoginName = arg.phone; user.UserType = 2; user.ParentID = 1; user.CellPhone = arg.phone; user.TimeZone = "China Standard Time"; user.Deleted = false; user.SuperAdmin = 0; user.Gender = false; user.MoneyCount = 0; using (DAL.CarRentEntities db = new DAL.CarRentEntities()) { db.Users.Add(user); db.SaveChanges(); } ar.message = "success!"; } catch (Exception ex) { Log.Error(this, ex); ar.message = ex.Message; ar.code = StatusCode.error; } return ar; })); }
/// <summary> /// 添加新用户 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button2_Click(object sender, EventArgs e) { BLL.UsersBLL objRB = new BLL.UsersBLL(); DAL.Users objR = new DAL.Users(); objR.uschool = txtSchool.Text; objR.uid = Convert.ToInt32(txtId.Text); objR.uname = txtName.Text; objR.upwd = txtPwd.Text; objR.usex = (rbMale.Checked ? '男' : '女').ToString(); if (objRB.Add(objR) > 0) { MessageBox.Show("用户注册成功"); } else { MessageBox.Show("添加失败,用户ID已存在,已经返回主窗体并请重新进入"); frmMain frmMain = new frmMain(); this.Hide(); frmMain.ShowDialog(); Application.ExitThread(); } }
private void DeleteData() { var userDAL = new DAL.Users(); var poiBLL = new PoiBLL(); var users = userDAL.Select("RegTime > '2014-05-30'", ""); foreach (DataRow row in users.Rows) { var userid = row["id"].ToInt(); if (userid <= 0) continue; while (true) { var searchResults = GetGeoSearchResult(userid, 0); if (searchResults.IsNull() || searchResults.size <= 0) break; searchResults.pois.ForEach(poi => { poiBLL.Delete(new List<string> { poi.id }, ADee.Project.LBS.Common.ConfigHelper.GeoProductTableID); }); Thread.Sleep(10); } } }
public Users(DbContext context) { _dalUsers = new DAL.Users(context); }
public void AddNewUser(DAL.Users user) { BLL.UserLogic.AddNewUser(user); }
public async Task<ActionResult> CreateAdmin(CreateAdminModel model) { if(adminMgt==null) { adminMgt = new AdministratorManagement(User.Identity.GetUserId<int>()); } if (!adminMgt.CurrentLoginUser.IsSuperAdmin && !adminMgt.CurrentLoginUser.IsWebMaster) { ViewBag.Message = "只有超级管理员和站长才能新建管理员"; return View("Error"); } if (ModelState.IsValid) { KMBit.DAL.Users newUser = new DAL.Users() { Enabled = true, Email = model.Email, Name = model.Name, PasswordHash = "123456789" }; newUser = await adminMgt.CreateAdministrator(newUser); if(newUser.Id>0) { return Redirect("/Admin/Administrators"); } } return View(model); }
public Users() { dal = new DAL.Users("mb_"); }
public async Task<ActionResult> UpdateAgency(CreateAgencyModel model) { if (agentAdminMgt == null) agentAdminMgt = new AgentAdminMenagement(User.Identity.GetUserId<int>()); bool result = false; try { if (ModelState.IsValid) { KMBit.DAL.Users dbUser = new DAL.Users(); dbUser.Address = model.Address; dbUser.City_id = model.City ; dbUser.Province_id = model.Province ; dbUser.Description = model.Description; dbUser.Enabled = model.Enabled; dbUser.Pay_type = model.PayType; dbUser.Type = model.Type; dbUser.PhoneNumber = model.Phone; if (model.Id > 0) { dbUser.Id = model.Id; dbUser.Update_time = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now); result = agentAdminMgt.UpdateAgency(dbUser); } else { dbUser.Email = model.Email; dbUser.PasswordHash = "111111"; dbUser.Name = model.Name; dbUser.CreatedBy = User.Identity.GetUserId<int>(); dbUser.Regtime = DateTimeUtil.ConvertDateTimeToInt(DateTime.Now); result = await agentAdminMgt.CreateAgency(dbUser); } if(result) { return RedirectToAction("Agencies"); }else { ViewBag.Exception = new KMBitException("创建失败"); } } } catch (KMBitException ex) { ViewBag.Exception = ex; } List<KMBit.DAL.User_type> userTypes = agentAdminMgt.GetUserTypes(); List<KMBit.DAL.Area> provinces = agentAdminMgt.GetAreas(0); List<KMBit.DAL.PayType> payTypes = agentAdminMgt.GetPayTypes(); ViewBag.UserTypes = new SelectList(userTypes, "Id", "Name"); ViewBag.PayTypes = new SelectList(payTypes, "Id", "Name"); ViewBag.Provinces = new SelectList(provinces, "Id", "Name"); if (model.Province >0) { ViewBag.Cities = new SelectList(agentAdminMgt.GetAreas((int)model.Province), "Id", "Name"); } else { ViewBag.Cities = new SelectList(new List<KMBit.DAL.Area>(), "Id", "Name"); } return View("CreateAgency",model); }
/// <summary> /// 判断用户是否存在 /// </summary> /// <param name="username">用户名</param> /// <returns></returns> public bool JudgePassword(Entity.Users user) { DAL.Users users = new DAL.Users(); return(users.JudgePassword(user)); }
private void btnSearch_Click(object sender, EventArgs e) { DAL.Users usr = new DAL.Users(); grvData.DataSource = usr.Select().Tables[0]; }
protected void btnSubmit_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtName.Text)) { WebUtility.ShowMsg("联系人不能为空!"); return; } if (!Utility.IsNumeric(txtPhone.Text)) { WebUtility.ShowMsg("联系方式只能为数字!"); return; } if (string.IsNullOrWhiteSpace(txtCompanyName.Text)) { WebUtility.ShowMsg("公司名称不能为空!"); return; } if (string.IsNullOrWhiteSpace(txtCompanyAddress.Text)) { WebUtility.ShowMsg("公司地址不能为空!"); return; } if (string.IsNullOrWhiteSpace(hfPosition.Value)) { WebUtility.ShowMsg("请在地图中选择准确位置!"); return; } bool isAdd = false; Model.Key_CircleSaleMan entApplication = circleSaleMan.GetEntity(new string[] { "UserID" }, this.LoginUser.UserID); if (entApplication == null) { entApplication = new ADeeWu.HuoBi3J.Model.Key_CircleSaleMan(); entApplication.CreateTime = DateTime.Now; entApplication.ModifyTime = DateTime.Now; isAdd = true; } entApplication.CheckState = (int)UserSessionCheckState.NotAudit; entApplication.ModifyTime = DateTime.Now; entApplication.Phone = txtPhone.Text; entApplication.UserID = this.LoginUser.UserID; entApplication.Memo = txtMemo.Value; entApplication.QQ = txtQQ.Text; entApplication.CompanyAddress = txtCompanyAddress.Text; entApplication.CompanyName = txtCompanyName.Text; entApplication.Job = txtJob.Text; entApplication.Name = txtName.Text; var position = hfPosition.Value.Split(new char[] { '|' }); entApplication.PositionX = Utility.GetFloat(position[0], 0); entApplication.PositionY = Utility.GetFloat(position[1], 0); if (isAdd) { var user = new DAL.Users().GetEntity(LoginUser.UserID); if (user.Money <= 50) { WebUtility.ShowMsg(string.Format("你的余额为:{0},申请货比三家业务员余额大于50元!", user.Money)); return; } if (circleSaleMan.Add(entApplication) > 0) { WebUtility.ShowMsg(this, "提交申请成功!我们将尽快为您处理!"); } else { WebUtility.ShowMsg(this, "操作失败!请与我们联系!"); } } else { if (circleSaleMan.Update(entApplication) > 0) { WebUtility.ShowMsg(this, "提交申请成功!我们将尽快为您处理!"); } else { WebUtility.ShowMsg(this, "操作失败!请与我们联系!"); } } }
//בעת רישום הוספת המשתמש לטבלה public static void AddNewUser(DAL.Users user) { db.Users.Add(user); db.SaveChanges(); }