/// <summary> /// 获取代理快开厅用户 /// <param name="userCode">用户帐号</param> /// </summary> /// <returns>代理快开厅用户对象</returns> public TSAgentUser Get(string userId) { TSAgentUser tsAgentUser = null; try { string strSQL = "select * from TSAgentUser where userId=:userId"; Param param = new Param(); param.Clear(); param.Add(":userId", userId); db.Open(); ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param); if (dr.Read()) { tsAgentUser = ReadData(dr); } } catch (Exception e) { throw e; } finally { db.Close(); } return(tsAgentUser); }
/// <summary> /// 修改快开厅员工 /// <param name="tbStaff">快开厅员工</param> /// </summary> public void Edit(TBStaff tbStaff, TSAgentUser tsAgentUser) { TSAgentUserDAO tsAgentUserDAO = new TSAgentUserDAO(); tsAgentUser.userId = tbStaff.staffId; //判断是否帐号重复 List <TSAgentUser> list = tsAgentUserDAO.GetList("userCode", tsAgentUser.userCode); if (list.Count > 0 && !tsAgentUser.userId.Equals(list[0].userId)) { Message.error(context, "帐号重复请重新输入!"); return; } try { tbStaff.status = tbStaff.status == null ? "0" : "1"; tbStaffDAO.EditTrans(tbStaff, tsAgentUser); Message.success(context, "快开厅员工修改成功"); loginSession.Log(tbStaff.staffName + "快开厅员工修改成功"); } catch (Exception e) { Message.error(context, "快开厅员工修改失败"); loginSession.Log(e.Message); } }
/// <summary> /// 增加代理商信息 /// <param name="tbAgent">代理商信息</param> /// </summary> public void Add(TBAgent tbAgent, TSAgentUser tsAgentUser) { TSAgentUserDAO tsAgentUserDAO = new TSAgentUserDAO(); //判断是否名称重复 if (tbAgentDAO.Exist("agentName", tbAgent.agentName)) { Message.error(context, "名称重复请重新输入!"); return; } //判断是否帐号重复 if (tsAgentUserDAO.Exist("userCode", tsAgentUser.userCode)) { Message.error(context, "用户帐号重复请重新输入!"); return; } try { tbAgent.agentId = commonDao.GetMaxNo("TBAgent", "", 6); tbAgent.status = tbAgent.status == null ? "0" : "1"; tbAgentDAO.AddTrans(tbAgent, tsAgentUser); Message.success(context, "代理商信息增加成功,默认密码为帐号,登录后建议修改"); loginSession.Log(tbAgent.agentName + "代理商信息增加成功"); } catch (Exception e) { Message.error(context, "代理商信息增加失败"); loginSession.Log(e.Message); } }
/// <summary> /// 读取代理快开厅用户信息 /// <param name="dr">记录指针</param> /// </summary> /// <returns>代理快开厅用户对象</returns> private TSAgentUser ReadData(ComDataReader dr) { TSAgentUser tsAgentUser = new TSAgentUser(); tsAgentUser.userCode = dr["userCode"].ToString(); //用户帐号 tsAgentUser.userPwd = dr["userPwd"].ToString(); //用户密码 tsAgentUser.roleId = dr["roleId"].ToString(); //角色编号 tsAgentUser.userId = dr["userId"].ToString(); //关联用户编号 return(tsAgentUser); }
/// <summary> /// 加载指定代理快开厅用户 /// <param name="userCode">用户帐号</param> /// </summary> public void Load(string userCode) { try { TSAgentUser tsAgentUser = tsAgentUserDAO.Get(userCode); WebJson.ToJson(context, tsAgentUser); } catch (Exception e) { Message.error(context, e.Message); } }
/// <summary> /// 增加代理快开厅用户 /// <param name="data">数据库连接</param> /// <param name="tsAgentUser">代理快开厅用户</param> /// </summary> public void Add(DataAccess data, TSAgentUser tsAgentUser) { string strSQL = "insert into TSAgentUser (userCode,userPwd,roleId,userId) values (:userCode,:userPwd,:roleId,:userId)"; Param param = new Param(); param.Clear(); param.Add(":userCode", tsAgentUser.userCode); //用户帐号 param.Add(":userPwd", tsAgentUser.userPwd); //用户密码 param.Add(":roleId", tsAgentUser.roleId); //角色编号 param.Add(":userId", tsAgentUser.userId); //关联用户编号 data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 修改代理门店用户 /// </summary> /// <param name="data">数据库连接</param> /// <param name="tsAgentUser">代理门店用户</param> public virtual void Edit(DataAccess data, TSAgentUser tsAgentUser) { string strSQL = "update TSAgentUser set userPwd=@userPwd,roleId=@roleId,userId=@userId where userCode=@userCode"; Param param = new Param(); param.Clear(); param.Add("@userPwd", tsAgentUser.userPwd); //用户密码 param.Add("@roleId", tsAgentUser.roleId); //角色编号 param.Add("@userId", tsAgentUser.userId); //关联用户编号 param.Add("@userCode", tsAgentUser.userCode); //用户帐号 data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 增加代理快开厅用户 /// <param name="tsAgentUser">代理快开厅用户</param> /// </summary> public void Add(TSAgentUser tsAgentUser) { try { tsAgentUserDAO.Add(tsAgentUser); Message.success(context, "代理快开厅用户增加成功"); loginSession.Log("XXXXXX代理快开厅用户增加成功"); } catch (Exception e) { Message.error(context, "代理快开厅用户增加失败"); loginSession.Log(e.Message); } }
/// <summary> /// 增加代理快开厅用户 /// <param name="tsAgentUser">代理快开厅用户</param> /// </summary> public void Add(TSAgentUser tsAgentUser) { try { db.Open(); Add(db, tsAgentUser); } catch (Exception e) { throw e; } finally { db.Close(); } }
/// <summary> /// 修改代理门店用户 /// </summary> /// <param name="tsAgentUser">代理门店用户</param> public virtual void Edit(TSAgentUser tsAgentUser) { try { db.Open(); Edit(db, tsAgentUser); } catch (Exception e) { throw e; } finally { db.Close(); } }
/// <summary> /// 修改代理快开厅用户 /// <param name="tsAgentUser">代理快开厅用户</param> /// </summary> public void Edit(TSAgentUser tsAgentUser, string type) { try { db.Open(); Edit(db, tsAgentUser, type); } catch (Exception e) { throw e; } finally { db.Close(); } }
public void ProcessRequest(HttpContext context) { try { LoginUser loginUser = new LoginUser(context, "AgentUser"); if (!loginUser.Pass)//权限验证 { return; } //加载DataGrid if (context.Request["action"] == "gridLoad") { AgentUserBLL bll = new AgentUserBLL(context, loginUser); int page = int.Parse(context.Request["page"]); int rows = int.Parse(context.Request["rows"]); bll.LoadGrid(page, rows); return; } //加载信息 if (context.Request["action"] == "load") { AgentUserBLL bll = new AgentUserBLL(context, loginUser); string userCode = context.Request["userCode"];//用户帐号 bll.Load(userCode); return; } //增加 if (context.Request["action"] == "add") { AgentUserBLL bll = new AgentUserBLL(context, loginUser); TSAgentUser tsAgentUser = new TSAgentUser(); tsAgentUser.userCode = context.Request["userCode"]; //用户帐号 tsAgentUser.userPwd = context.Request["userPwd"]; //用户密码 tsAgentUser.roleId = context.Request["roleId"]; //角色编号 tsAgentUser.userId = context.Request["userId"]; //关联用户编号 bll.Add(tsAgentUser); return; } } catch (Exception e) { Message.error(context, e.Message); } }
/// <summary> /// 修改代理快开厅用户 /// <param name="data">数据库连接</param> /// <param name="tsAgentUser">代理快开厅用户</param> /// </summary> public void Edit(DataAccess data, TSAgentUser tsAgentUser, string type) { string strSQL = "update TSAgentUser set roleId=:roleId,userCode=:userCode where userId=:userId"; if (type == "0") { strSQL += " and roleId='001'"; } else { strSQL += " and roleId!='001'"; } Param param = new Param(); param.Clear(); param.Add(":roleId", tsAgentUser.roleId); //角色编号 param.Add(":userId", tsAgentUser.userId); //关联用户编号 param.Add(":userCode", tsAgentUser.userCode); //用户帐号 data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 重置员工密码 /// </summary> /// <param name="staffId"></param> /// <param name="roleType"></param> public void PawReset(string staffId, string roleType) { TSAgentUser tsAgentUser = new TSAgentUser(); string strSQL = "select * from tsAgentUser where userId=" + staffId + " and roleId!=001"; TSAgentUserDAO tsAgentUserDao = new TSAgentUserDAO(); Param param = new Param(); tsAgentUser = tsAgentUserDao.GetList(strSQL, param)[0]; try { string userPwd = Encrypt.ConvertPwd(tsAgentUser.userId, tsAgentUser.userCode); tsAgentUserDao.ChangePwd(tsAgentUser.userId, userPwd, roleType); Message.success(context, "员工密码重置成功"); loginSession.Log(staffId + "员工密码重置成功"); } catch (Exception e) { Message.error(context, "员工密码重置失败 "); loginSession.Log(e.Message); } }
/// <summary> /// 事务修改快开厅员工 /// <param name="tbStaff">快开厅员工</param> /// </summary> public void EditTrans(TBStaff tbStaff, TSAgentUser tsAgentUser) { ComTransaction trans = null; try { db.Open(); trans = db.BeginTransaction(); new TSAgentUserDAO().Edit(db, tsAgentUser, "1");//1为门店员工 Edit(db, tbStaff); trans.Commit(); } catch (Exception e) { trans.Rollback(); throw e; } finally { db.Close(); } }
/// <summary> /// 增加快开厅员工 /// <param name="tbStaff">快开厅员工</param> /// </summary> public void Add(TBStaff tbStaff, TSAgentUser tsAgentUser) { TSAgentUserDAO tsAgentUserDAO = new TSAgentUserDAO(); //判断是否帐号重复 if (tsAgentUserDAO.Exist("userCode", tsAgentUser.userCode)) { Message.error(context, "用户帐号重复请重新输入!"); return; } try { tbStaff.staffId = commonDao.GetMaxNo("TBStaff", "", 6); tbStaff.status = tbStaff.status == null ? "0" : "1"; tbStaffDAO.AddTrans(tbStaff, tsAgentUser); Message.success(context, "快开厅员工增加成功,默认密码为帐号,登录后建议修改!"); loginSession.Log(tbStaff.staffName + "快开厅员工增加成功"); } catch (Exception e) { Message.error(context, "快开厅员工增加失败"); loginSession.Log(e.Message); } }
/// <summary> /// 修改当前用户密码 /// </summary> /// <param name="oldPwd">旧密码</param> /// <param name="newPwd">新密码</param> public void ChangePwd(string oldPwd, string newPwd, string roleId, string roleType) { TSAgentUserDAO tsAgentUserDao = new TSAgentUserDAO(); TSAgentUser user = tsAgentUserDao.Get(loginAgentUser.UserId, roleId); if (user.userPwd.Equals(Encrypt.ConvertPwd(user.userId, oldPwd)) == false) { Message.error(context, "旧密码输入错误"); return; } user.userPwd = Encrypt.ConvertPwd(user.userId, newPwd); try { tsAgentUserDao.ChangePwd(user.userId, user.userPwd, roleType); Message.success(context, "密码修改成功"); loginAgentUser.Log("密码修改成功"); } catch (Exception e) { Message.error(context, "密码修改失败"); loginAgentUser.Log("密码修改失败,错误:" + e.Message); } }
private DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接 /// <summary> /// 事务增加快开厅员工 /// <param name="tbStaff">快开厅员工</param> /// </summary> public void AddTrans(TBStaff tbStaff, TSAgentUser tsAgentUser) { ComTransaction trans = null; try { db.Open(); trans = db.BeginTransaction(); Add(db, tbStaff); tsAgentUser.userId = tbStaff.staffId; tsAgentUser.userPwd = Encrypt.ConvertPwd(tsAgentUser.userId, tsAgentUser.userPwd); new TSAgentUserDAO().Add(db, tsAgentUser); trans.Commit(); } catch (Exception e) { trans.Rollback(); throw e; } finally { db.Close(); } }
///<summary> ///登录系统 ///</summary> /// <param name="context">HTTP请求上下文</param> /// <param name="userCode">用户名称</param> /// <param name="userPwd">用户密码</param> public void Login(System.Web.HttpContext context, string userCode, string userPwd) { //获取用户信息 List <TSAgentUser> tsAgentUserList = new TSAgentUserDAO().GetList("userCode", userCode); if (tsAgentUserList.Count != 1) { Message.error(context, "帐号错误"); return; } TSAgentUser tsAgentUser = tsAgentUserList[0]; if (!tsAgentUser.userPwd.Equals(Encrypt.ConvertPwd(tsAgentUser.userId, userPwd))) { Message.error(context, "密码错误"); return; } //获取代理商和执法文书类型信息 string roleType = new TSAgentRoleDAO().Get(tsAgentUser.roleId).type; if (roleType == "0") { TBAgent tbAgent = new TBAgentDAO().Get(tsAgentUser.userId); if (tbAgent.auditStatus != ((int)AuditStauts.AuditSucces).ToString()) { Message.error(context, "代理商未审核或审核失败"); return; } if (!tbAgent.status.Equals("1")) { Message.error(context, "代理商停用"); return; } } else { TBStaff tbStaff = new TBStaffDAO().Get(tsAgentUser.userId); TBAgent tbAgent = new TBAgentDAO().Get(tbStaff.agentId); if (tbAgent.auditStatus != ((int)AuditStauts.AuditSucces).ToString()) { Message.error(context, "代理商未审核或审核失败"); return; } if (!tbAgent.status.Equals("1")) { Message.error(context, "代理商停用"); return; } TBSite tbSite = new TBSiteDAO().Get(tbStaff.siteId); if (tbSite.auditStatus != ((int)AuditStauts.AuditSucces).ToString()) { Message.error(context, "执法文书类型未审核或审核失败"); return; } if (!tbSite.status.Equals("1")) { Message.error(context, "执法文书类型停用"); return; } } //设置登录信息 this.userId = tsAgentUser.userId; this.roleIds = tsAgentUser.roleId; if (roleType == "0")//代理商 { this.userName = new TBAgentDAO().Get(tsAgentUser.userId).agentName; } else //员工 { this.userName = new TBStaffDAO().Get(tsAgentUser.userId).staffName; } //会话保存登录用户信息 context.Session["clientUser"] = this; Message.success(context, "success");//成功返回 }
public void ProcessRequest(HttpContext context) { try { LoginAgentUser loginAgentUser = new LoginAgentUser(context, "Staff"); StaffBLL bll = new StaffBLL(context, loginAgentUser); AgentRoleBLL agentRoleBLL = new AgentRoleBLL(context, loginAgentUser); if (!loginAgentUser.Pass)//权限验证 { return; } string roleType = agentRoleBLL.GetRoleType(loginAgentUser.RoleIds); //加载DataGrid if (context.Request["action"] == "gridLoad") { int page = int.Parse(context.Request["page"]); int rows = int.Parse(context.Request["rows"]); if (roleType == "0") { bll.LoadGrid(page, rows, roleType, loginAgentUser.UserId); } else { bll.LoadGrid(page, rows, roleType, bll.Get(loginAgentUser.UserId).siteId); } return; } //加载门店 if (context.Request["action"] == "siteListLoad") { bll.SiteCombobox(loginAgentUser.UserId, roleType); return; } //加载角色 if (context.Request["action"] == "roleListLoad") { bll.RoleCombobox(); return; } //加载信息 if (context.Request["action"] == "load") { string staffId = context.Request["staffId"];//员工编号 bll.Load(staffId); return; } //增加 if (context.Request["action"] == "add") { TBStaff tbStaff = new TBStaff(); TSAgentUser tsAgentUser = new TSAgentUser(); tbStaff.staffId = context.Request["staffId"]; //员工编号 tbStaff.siteId = context.Request["siteId"]; //门店编号 tbStaff.staffName = context.Request["staffName"]; //员工姓名 tbStaff.status = context.Request["status"]; //使用状态 tbStaff.telephone = context.Request["telephone"]; //手机号码 tbStaff.IDNumber = context.Request["IDNumber"]; //身份证号 if (roleType == "0") //角色类型0:代理商 1:门店员工 { tbStaff.agentId = loginAgentUser.UserId; } else { tbStaff.agentId = bll.Get(loginAgentUser.UserId).agentId; } tbStaff.address = context.Request["address"]; //住址 tbStaff.remark = context.Request["remark"]; //备注 //添加到代理门店用户表 tsAgentUser.roleId = context.Request["roleId"]; //角色; tsAgentUser.userCode = context.Request["staffCode"]; //员工帐号 tsAgentUser.userPwd = tsAgentUser.userCode; //帐号密码 默认和帐号一致 bll.Add(tbStaff, tsAgentUser); return; } //修改 if (context.Request["action"] == "edit") { TBStaff tbStaff = new TBStaff(); TSAgentUser tsAgentUser = new TSAgentUser(); tbStaff.staffId = context.Request["staffId"]; //员工编号 tbStaff.siteId = context.Request["siteId"]; //门店编号 tbStaff.staffName = context.Request["staffName"]; //员工姓名 tbStaff.status = context.Request["status"]; //使用状态 tbStaff.telephone = context.Request["telephone"]; //手机号码 tbStaff.IDNumber = context.Request["IDNumber"]; //身份证号 if (roleType == "0") //角色类型0:代理商 1:门店员工 { tbStaff.agentId = loginAgentUser.UserId; } else { tbStaff.agentId = bll.Get(loginAgentUser.UserId).agentId; } tbStaff.address = context.Request["address"]; //住址 tbStaff.remark = context.Request["remark"]; //备注 //添加到代理门店用户表 tsAgentUser.roleId = context.Request["roleId"]; //角色; tsAgentUser.userCode = context.Request["staffCode"]; //员工帐号 bll.Edit(tbStaff, tsAgentUser); return; } //删除 if (context.Request["action"] == "delete") { string staffId = context.Request["staffId"];//员工编号 bll.Delete(staffId); return; } } catch (Exception e) { Message.error(context, e.Message); } }
public void ProcessRequest(HttpContext context) { try { LoginUser loginUser = new LoginUser(context, "AgentAdd"); if (!loginUser.Pass)//权限验证 { return; } AgentBLL bll = new AgentBLL(context, loginUser); if (context.Request["action"] == "gridLoad") { //加载DataGrid int page = int.Parse(context.Request["page"]); int rows = int.Parse(context.Request["rows"]); string agentName = context.Request["agentName"]; string agentId = context.Request["agentId"]; string auditStatus = context.Request["auditStatus"]; bll.LoadGrid(page, rows, agentName, agentId, "", auditStatus); } else if (context.Request["action"] == "areaListLoad") { //加载区域列表 Combobox com = new Combobox(context, loginUser); com.AreaCombobox(); } else if (context.Request["action"] == "auditListLoad") { //加载审核状态列表 Combobox com = new Combobox(context, loginUser); com.AuditCombobox(); } else if (context.Request["action"] == "load") { //加载信息 bll.Load(context.Request["agentId"]); } else if (context.Request["action"] == "add") { //增加 TBAgent agent = new TBAgent(); TSAgentUser tsAgentUser = new TSAgentUser(); agent.agentId = context.Request["agentId"]; agent.agentName = context.Request["agentName"]; agent.rebate = double.Parse(context.Request["rebate"]); agent.warnValue = double.Parse(context.Request["warnValue"]); agent.contact = context.Request["contact"]; agent.telephone = context.Request["telephone"]; agent.areaId = context.Request["areaId"]; agent.address = context.Request["address"]; agent.IDNumber = context.Request["IDNumber"]; agent.bankCardId = context.Request["bankCardId"]; agent.bankName = context.Request["bankName"]; agent.status = "0"; agent.fixedLine = context.Request["fixedLine"]; agent.remark = context.Request["remark"]; tsAgentUser.roleId = "001"; tsAgentUser.userCode = context.Request["agentUserCode"]; tsAgentUser.userPwd = tsAgentUser.userCode; bll.Add(agent, tsAgentUser); } else if (context.Request["action"] == "edit") { //修改 TBAgent agent = new TBAgent(); agent.agentId = context.Request["agentId"]; agent.agentName = context.Request["agentName"]; agent.rebate = double.Parse(context.Request["rebate"]); agent.contact = context.Request["contact"]; agent.telephone = context.Request["telephone"]; agent.areaId = context.Request["areaId"]; agent.address = context.Request["address"]; agent.IDNumber = context.Request["IDNumber"]; agent.bankCardId = context.Request["bankCardId"]; agent.bankName = context.Request["bankName"]; agent.status = context.Request["status"]; agent.warnValue = double.Parse(context.Request["warnValue"]); agent.auditStatus = "0"; agent.fixedLine = context.Request["fixedLine"]; agent.remark = context.Request["remark"]; bll.Edit(agent); } else if (context.Request["action"] == "delete") { //删除 string agentId = context.Request["agentId"]; bll.Delete(agentId); } } catch (Exception e) { Message.error(context, e.Message); } }