/// <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);
}
}
