/// <summary>
/// 获取区域设置
/// <param name="areaId">区域编号</param>
/// </summary>
/// <returns>区域设置对象</returns>
public TBArea Get(string areaId)
{
TBArea tbArea = null;
try
{
string strSQL = "select * from TBArea where areaId=:areaId";
Param param = new Param();
param.Clear();
param.Add(":areaId", areaId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbArea = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbArea);
}
public void ProcessRequest(HttpContext context)
{
try
{
LoginUser loginUser = new LoginUser(context, "Area");
if (!loginUser.Pass)//权限验证
{
return;
}
AreaBLL bll = new AreaBLL(context, loginUser);
if (context.Request["action"] == "treeLoad")
{//加载树
bll.LoadTree();
}
else if (context.Request["action"] == "load")
{//加载信息
bll.Load(context.Request["areaId"]);
}
else if (context.Request["action"] == "add")
{//增加
TBArea area = new TBArea();
area.areaCode = context.Request.Form["areaCode"];
area.areaName = context.Request.Form["areaName"];
area.isUse = context.Request.Form["isUse"];
area.parentId = context.Request.Form["parentId"];
area.areaLayer = int.Parse(context.Request.Form["areaLayer"]);
area.areaIndex = int.Parse(context.Request.Form["areaIndex"]);
bll.Add(area);
}
else if (context.Request["action"] == "edit")
{//修改
TBArea area = new TBArea();
area.areaId = context.Request["areaId"];
area.areaCode = context.Request.Form["areaCode"];
area.areaName = context.Request.Form["areaName"];
area.parentId = context.Request.Form["parentId"];
area.isUse = context.Request.Form["isUse"];
area.areaIndex = int.Parse(context.Request.Form["areaIndex"]);
bll.Edit(area);
}
else if (context.Request["action"] == "delete")
{//删除
string areaId = context.Request["areaId"];
bll.Delete(areaId);
}
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 加载指定区域设置
/// <param name="areaId">区域编号</param>
/// </summary>
public void Load(string areaId)
{
try
{
TBArea tbArea = tbAreaDAO.Get(areaId);
tbArea.isUse = "1".Equals(tbArea.isUse) ? "on" : "off";
WebJson.ToJson(context, tbArea);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 读取区域设置信息
/// <param name="dr">记录指针</param>
/// </summary>
/// <returns>区域设置对象</returns>
private TBArea ReadData(ComDataReader dr)
{
TBArea tbArea = new TBArea();
tbArea.areaId = dr["areaId"].ToString(); //区域编号
tbArea.areaCode = dr["areaCode"].ToString(); //区域代码
tbArea.areaName = dr["areaName"].ToString(); //区域名称
tbArea.isUse = dr["isUse"].ToString(); //使用状态
tbArea.parentId = dr["parentId"].ToString(); //父区域编号
tbArea.areaLayer = int.Parse(dr["areaLayer"].ToString()); //所属层次
tbArea.areaIndex = int.Parse(dr["areaIndex"].ToString()); //排列顺序
return(tbArea);
}
/// <summary>
/// 获取指定区域信息
/// <param name="areaId">区域编号</param>
/// </summary>
public TBArea Get(string areaId)
{
TBArea tbArea = new TBArea();
try
{
tbArea = tbAreaDAO.Get(areaId);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
return(tbArea);
}
/// <summary>
/// 修改区域设置
/// <param name="tbArea">区域设置</param>
/// </summary>
public void Edit(TBArea tbArea)
{
try
{
tbArea.isUse = tbArea.isUse == null ? "0" : "1";
tbAreaDAO.Edit(tbArea);
Message.success(context, "区域设置修改成功");
loginSession.Log("XXXXXX区域设置修改成功");
}
catch (Exception e)
{
Message.error(context, "区域设置修改失败");
loginSession.Log(e.Message);
}
}
/// <summary>
/// 增加区域设置
/// <param name="data">数据库连接</param>
/// <param name="tbArea">区域设置</param>
/// </summary>
public void Add(DataAccess data, TBArea tbArea)
{
string strSQL = "insert into TBArea (areaId,areaCode,areaName,isUse,parentId,areaLayer,areaIndex) values (:areaId,:areaCode,:areaName,:isUse,:parentId,:areaLayer,:areaIndex)";
Param param = new Param();
param.Clear();
param.Add(":areaId", tbArea.areaId); //区域编号
param.Add(":areaCode", tbArea.areaCode); //区域代码
param.Add(":areaName", tbArea.areaName); //区域名称
param.Add(":isUse", tbArea.isUse); //使用状态
param.Add(":parentId", tbArea.parentId); //父区域编号
param.Add(":areaLayer", tbArea.areaLayer); //所属层次
param.Add(":areaIndex", tbArea.areaIndex); //排列顺序
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 修改区域设置
/// <param name="data">数据库连接</param>
/// <param name="tbArea">区域设置</param>
/// </summary>
public void Edit(DataAccess data, TBArea tbArea)
{
string strSQL = "update TBArea set areaCode=:areaCode,areaName=:areaName,isUse=:isUse,parentId=:parentId,areaLayer=:areaLayer,areaIndex=:areaIndex where areaId=:areaId";
Param param = new Param();
param.Clear();
param.Add(":areaCode", tbArea.areaCode); //区域代码
param.Add(":areaName", tbArea.areaName); //区域名称
param.Add(":isUse", tbArea.isUse); //使用状态
param.Add(":parentId", tbArea.parentId); //父区域编号
param.Add(":areaLayer", tbArea.areaLayer); //所属层次
param.Add(":areaIndex", tbArea.areaIndex); //排列顺序
param.Add(":areaId", tbArea.areaId); //区域编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 增加区域设置
/// <param name="tbArea">区域设置</param>
/// </summary>
public void Add(TBArea tbArea)
{
try
{
tbArea.areaId = commonDao.GetMaxNo("TBArea", "", 6);
tbArea.isUse = tbArea.isUse == null ? "0" : "1";
tbAreaDAO.Add(tbArea);
Message.success(context, "区域设置增加成功");
loginSession.Log("XXXXXX区域设置增加成功");
}
catch (Exception e)
{
Message.error(context, "区域设置增加失败");
loginSession.Log(e.Message);
}
}
/// <summary>
/// 修改区域设置
/// <param name="tbArea">区域设置</param>
/// </summary>
public void Edit(TBArea tbArea)
{
try
{
db.Open();
Edit(db, tbArea);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 增加区域设置
/// </summary>
/// <param name="tbArea">区域设置</param>
public virtual void Add(TBArea tbArea)
{
try
{
db.Open();
Add(db, tbArea);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 显示模块树
/// </summary>
public void LoadTree()
{
DataSet ds = tbAreaDAO.GetDataSet("select * from TBArea", null);
List <Tree <TBArea> > list = new List <Tree <TBArea> >(1);
Tree <TBArea> treeNode = new Tree <TBArea>();
treeNode.text = "系统区域";//节点名称
TBArea tsArea = new TBArea();
tsArea.areaId = "0";
tsArea.areaCode = "";
tsArea.areaName = "";
tsArea.parentId = "";
tsArea.isUse = "1";
tsArea.areaLayer = 0;
tsArea.areaIndex = 0;
treeNode.attributes = tsArea;
AddNode(treeNode, ds);//遍历子区域
list.Add(treeNode);
WebJson.ToJson(context, list);
}
/// <summary>
/// 遍历子模块
/// </summary>
/// <param name="parentNode">父模块节点</param>
/// <param name="ds">模块记录集</param>
/// <param name="roleRight">角色权限模块</param>
private void AddNode(Tree <TBArea> parentNode, DataSet ds)
{
DataView dv = new DataView();
dv.Table = ds.Tables[0];
dv.RowFilter = "parentId='" + parentNode.attributes.areaId + "'";
dv.Sort = "areaIndex desc";
for (int i = 0; i < dv.Count; i++)
{
Tree <TBArea> treeNode = new Tree <TBArea>();
treeNode.text = dv[i]["areaName"].ToString();//节点名称
TBArea tbArea = new TBArea();
tbArea.areaId = dv[i]["areaId"].ToString();
tbArea.areaCode = dv[i]["areaCode"].ToString();
tbArea.areaName = dv[i]["areaName"].ToString();
tbArea.isUse = dv[i]["isUse"].ToString();
tbArea.parentId = dv[i]["parentId"].ToString();
tbArea.areaLayer = int.Parse(dv[i]["areaLayer"].ToString());
tbArea.areaIndex = int.Parse(dv[i]["areaIndex"].ToString());
treeNode.attributes = tbArea;
AddNode(treeNode, ds); //遍历子模块
parentNode.children.Add(treeNode); //添加子模块节点
}
}
