/// <summary>
/// 获取部门
/// </summary>
/// <param name="deptId">部门编号</param>
/// <returns>部门对象</returns>
public virtual TSDept Get(string deptId)
{
TSDept tsDept = null;
try
{
string strSQL = "select * from TSDept where deptId=@deptId";
Param param = new Param();
param.Clear();
param.Add("@deptId", deptId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tsDept = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tsDept);
}
/// <summary>
/// 读取部门信息
/// </summary>
/// <param name="dr">记录指针</param>
/// <returns>部门对象</returns>
protected virtual TSDept ReadData(ComDataReader dr)
{
TSDept tsDept = new TSDept();
tsDept.deptId = dr["deptId"].ToString(); //部门编号
tsDept.status = dr["status"].ToString(); //使用状态
tsDept.deptName = dr["deptName"].ToString(); //部门名称
tsDept.telephone = dr["telephone"].ToString(); //联系电话
return(tsDept);
}
/// <summary>
/// 修改部门
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tsDept">部门</param>
public virtual void Edit(DataAccess data, TSDept tsDept)
{
string strSQL = "update TSDept set status=@status,deptName=@deptName,telephone=@telephone where deptId=@deptId";
Param param = new Param();
param.Clear();
param.Add("@status", tsDept.status); //使用状态
param.Add("@deptName", tsDept.deptName); //部门名称
param.Add("@telephone", tsDept.telephone); //联系电话
param.Add("@deptId", tsDept.deptId); //部门编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
protected DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接
#region 代码生成器自动生成
/// <summary>
/// 增加部门
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tsDept">部门</param>
public virtual void Add(DataAccess data, TSDept tsDept)
{
string strSQL = "insert into TSDept (deptId,status,deptName,telephone) values (@deptId,@status,@deptName,@telephone)";
Param param = new Param();
param.Clear();
param.Add("@deptId", tsDept.deptId); //部门编号
param.Add("@status", tsDept.status); //使用状态
param.Add("@deptName", tsDept.deptName); //部门名称
param.Add("@telephone", tsDept.telephone); //联系电话
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 加载指定部门
/// <param name="deptId">部门编号</param>
/// </summary>
public void Load(string deptId)
{
try
{
TSDept tsDept = tsDeptDAO.Get(deptId);
tsDept.status = "1".Equals(tsDept.status) ? "on" : "off";
WebJson.ToJson(context, tsDept);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 修改部门
/// <param name="tsDept">部门</param>
/// </summary>
public void Edit(TSDept tsDept)
{
try
{
tsDept.status = tsDept.status == null ? "0" : "1";
tsDeptDAO.Edit(tsDept);
Message.success(context, "部门修改成功");
loginSession.Log(tsDept.deptName + "[" + tsDept.deptId + "]部门修改成功");
}
catch (Exception e)
{
Message.error(context, "部门修改失败");
loginSession.Log(e.Message);
}
}
/// <summary>
/// 修改部门
/// </summary>
/// <param name="tsDept">部门</param>
public virtual void Edit(TSDept tsDept)
{
try
{
db.Open();
Edit(db, tsDept);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 增加部门
/// <param name="tsDept">部门</param>
/// </summary>
public void Add(TSDept tsDept)
{
try
{
db.Open();
Add(db, tsDept);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 增加部门
/// <param name="tsDept">部门</param>
/// </summary>
public void Add(TSDept tsDept)
{
try
{
tsDept.deptId = commonDao.GetMaxNo("TSDept", "", 6);
tsDept.status = tsDept.status == null ? "0" : "1";
tsDeptDAO.Add(tsDept);
Message.success(context, "部门增加成功");
loginSession.Log(tsDept.deptName + "部门增加成功");
}
catch (Exception e)
{
Message.error(context, "部门增加失败");
loginSession.Log(e.Message);
}
}
public void ProcessRequest(HttpContext context)
{
try
{
LoginUser loginUser = new LoginUser(context, "Dept");
if (!loginUser.Pass)//权限验证
{
return;
}
//加载DataGrid
if (context.Request["action"] == "gridLoad")
{
DeptBLL bll = new DeptBLL(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")
{
DeptBLL bll = new DeptBLL(context, loginUser);
string deptId = context.Request["deptId"];//部门编号
bll.Load(deptId);
return;
}
//增加
if (context.Request["action"] == "add")
{
DeptBLL bll = new DeptBLL(context, loginUser);
TSDept tsDept = new TSDept();
//tsDept.deptId= context.Request["deptId"];//部门编号
tsDept.status = context.Request["status"]; //使用状态
tsDept.deptName = context.Request["deptName"]; //部门名称
tsDept.telephone = context.Request["telephone"]; //联系电话
bll.Add(tsDept);
return;
}
//修改
if (context.Request["action"] == "edit")
{
DeptBLL bll = new DeptBLL(context, loginUser);
TSDept tsDept = new TSDept();
tsDept.deptId = context.Request["deptId"]; //部门编号
tsDept.status = context.Request["status"]; //使用状态
tsDept.deptName = context.Request["deptName"]; //部门名称
tsDept.telephone = context.Request["telephone"]; //联系电话
bll.Edit(tsDept);
return;
}
//删除
if (context.Request["action"] == "delete")
{
DeptBLL bll = new DeptBLL(context, loginUser);
string deptId = context.Request["deptId"];//部门编号
bll.Delete(deptId);
return;
}
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
