/// <summary>
/// 获取快开厅员工
/// <param name="staffId">员工编号</param>
/// </summary>
/// <returns>快开厅员工对象</returns>
public TBStaff Get(string staffId)
{
TBStaff tbStaff = null;
try
{
string strSQL = "select * from TBStaff where staffId=:staffId";
Param param = new Param();
param.Clear();
param.Add(":staffId", staffId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbStaff = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbStaff);
}
/// <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="staffId">员工编号</param>
/// </summary>
public TBStaff Get(string staffId)
{
TBStaff tbStaff = new TBStaff();
try
{
tbStaff = tbStaffDAO.Get(staffId);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
return(tbStaff);
}
/// <summary>
/// 读取快开厅员工信息
/// <param name="dr">记录指针</param>
/// </summary>
/// <returns>快开厅员工对象</returns>
private TBStaff ReadData(ComDataReader dr)
{
TBStaff tbStaff = new TBStaff();
tbStaff.staffId = dr["staffId"].ToString(); //员工编号
tbStaff.siteId = dr["siteId"].ToString(); //快开厅编号
tbStaff.agentId = dr["agentId"].ToString(); //代理商编号
tbStaff.staffName = dr["staffName"].ToString(); //员工姓名
tbStaff.status = dr["status"].ToString(); //使用状态
tbStaff.telephone = dr["telephone"].ToString(); //手机号码
tbStaff.IDNumber = dr["IDNumber"].ToString(); //身份证号
tbStaff.address = dr["address"].ToString(); //住址
tbStaff.remark = dr["remark"].ToString(); //备注
return(tbStaff);
}
/// <summary>
/// 修改快开厅员工
/// <param name="tbStaff">快开厅员工</param>
/// </summary>
public void Edit(TBStaff tbStaff)
{
try
{
db.Open();
Edit(db, tbStaff);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 修改快开厅员工
/// <param name="data">数据库连接</param>
/// <param name="tbStaff">快开厅员工</param>
/// </summary>
public void Edit(DataAccess data, TBStaff tbStaff)
{
string strSQL = "update TBStaff set siteId=:siteId,staffName=:staffName,status=:status,telephone=:telephone,IDNumber=:IDNumber,address=:address,remark=:remark where staffId=:staffId";
Param param = new Param();
param.Clear();
param.Add(":siteId", tbStaff.siteId); //快开厅编号
param.Add(":staffName", tbStaff.staffName); //员工姓名
param.Add(":status", tbStaff.status); //使用状态
param.Add(":telephone", tbStaff.telephone); //手机号码
param.Add(":IDNumber", tbStaff.IDNumber); //身份证号
param.Add(":address", tbStaff.address); //住址
param.Add(":remark", tbStaff.remark); //备注
param.Add(":staffId", tbStaff.staffId); //员工编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 增加门店员工
/// </summary>
/// <param name="tbStaff">门店员工</param>
public virtual void Add(TBStaff tbStaff)
{
try
{
db.Open();
Add(db, tbStaff);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 增加快开厅员工
/// <param name="data">数据库连接</param>
/// <param name="tbStaff">快开厅员工</param>
/// </summary>
public void Add(DataAccess data, TBStaff tbStaff)
{
string strSQL = "insert into TBStaff (staffId,siteId,agentId,staffName,status,telephone,IDNumber,address,remark) values (:staffId,:siteId,:agentId,:staffName,:status,:telephone,:IDNumber,:address,:remark)";
Param param = new Param();
param.Clear();
param.Add(":staffId", tbStaff.staffId); //员工编号
param.Add(":siteId", tbStaff.siteId); //快开厅编号
param.Add(":agentId", tbStaff.agentId); //代理商编号
param.Add(":staffName", tbStaff.staffName); //员工姓名
param.Add(":status", tbStaff.status); //使用状态
param.Add(":telephone", tbStaff.telephone); //手机号码
param.Add(":IDNumber", tbStaff.IDNumber); //身份证号
param.Add(":address", tbStaff.address); //住址
param.Add(":remark", tbStaff.remark); //备注
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 修改门店员工
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tbStaff">门店员工</param>
public virtual void Edit(DataAccess data, TBStaff tbStaff)
{
string strSQL = "update TBStaff set siteId=@siteId,agentId=@agentId,staffName=@staffName,status=@status,telephone=@telephone,IDNumber=@IDNumber,address=@address,remark=@remark where staffId=@staffId";
Param param = new Param();
param.Clear();
param.Add("@siteId", tbStaff.siteId); //门店编号
param.Add("@agentId", tbStaff.agentId); //代理商编号
param.Add("@staffName", tbStaff.staffName); //员工姓名
param.Add("@status", tbStaff.status); //使用状态
param.Add("@telephone", tbStaff.telephone); //手机号码
param.Add("@IDNumber", tbStaff.IDNumber); //身份证号
param.Add("@address", tbStaff.address); //住址
param.Add("@remark", tbStaff.remark); //备注
param.Add("@staffId", tbStaff.staffId); //员工编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <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);
}
}
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();
}
}
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);
}
}
