public void BindData()
{
if (nodeText != "")
{
if (nodeValue != "000000")
{
string tableName = "Sys_Area";
string showField = " top 1 ID";
string strWhere = " and AreaCode='" + nodeValue + "'";
DataTable dt = new BLL.Sys_Public().SelectData(showField, tableName, strWhere).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
nodeId = Utils.ToInt(dt.Rows[0]["ID"].ToString());
}
}
try
{
HoneyWell.Model.Sys_Area area = new HoneyWell.BLL.Sys_Area().GetModel(nodeId);
txt_ClassCode.Value = area.AreaCode;
txt_ClassName.Value = area.AreaName;
txt_ClassOrder.Value = area.AreaOrder.ToString();
txt_KeyWord.Value = area.KeyWord;
h_ParentCode.Value = area.ParentAreaCode;
h_ClassLevel.Value = area.AreaLevel.ToString();
}
catch (Exception e)
{
Response.Write(e.Message);
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
bool result = false;
HoneyWell.Model.Sys_Area area = SetObjectValue();
if (nodeValue != "")
{
//判断区域代码是否重复
DataSet ds = new HoneyWell.BLL.Sys_Public().SelectData("top 1 ID", "Sys_Area", " and AreaCode='" + txt_ClassCode.Value.Trim() + "' and AreaCode<>'" + nodeValue + "'");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
Response.Write("<script language='javascript'>alert('您输入的区域代码已存在，请重新输入!');location.href='sys_Area_Manage.aspx?nodeText=" + nodeText + "&nodeValue=" + nodeValue + "'</script>");
Response.End();
}
//判断区域名称是否重复
DataSet ds1 = new HoneyWell.BLL.Sys_Public().SelectData("top 1 ID", "Sys_Area", " and AreaName='" + txt_ClassName.Value.Trim() + "' and AreaCode<>'" + nodeValue + "'");
if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
{
Response.Write("<script language='javascript'>alert('您输入的区域名称已存在，请重新输入!');location.href='sys_Area_Manage.aspx?nodeText=" + nodeText + "&nodeValue=" + nodeValue + "'</script>");
Response.End();
}
result = new HoneyWell.BLL.Sys_Area().Update(area);
}
if (true)
{
ScriptManager.RegisterClientScriptBlock(btnSave, GetType(), "", "alert('操作成功!');location.href='sys_Area_Manage.aspx?nodeText=" + nodeText + "&nodeValue=" + nodeValue + "'", true);
}
}
public void BindData()
{
if (nodeValue != "000000")
{
string tableName = "Sys_Area";
string showField = " top 1 ID";
string strWhere = " and AreaCode='" + nodeValue + "'";
DataTable dt = new BLL.Sys_Public().SelectData(showField, tableName, strWhere).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
nodeId = Utils.ToInt(dt.Rows[0]["ID"].ToString());
}
}
if (nodeId > 0)
{
HoneyWell.Model.Sys_Area area = new HoneyWell.BLL.Sys_Area().GetModel(nodeId);
h_ClassLevel.Value = area.AreaLevel.ToString();
lab_ParentName.InnerHtml = area.AreaName;
}
else
{
h_ClassLevel.Value = "0";
lab_ParentName.InnerHtml = nodeText;
}
}
private void Tree_Data(DataTable dt, DataRow dr, string node, int level)
{
//构造菜单
if (level <= 3)
{
string SqlWhere = " and AreaLevel=" + level + " and ParentAreaCode='" + node + "' order by AreaOrder asc";
DataSet ds = new HoneyWell.BLL.Sys_Area().GetTypeTree("Sys_Area", SqlWhere);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
dr = dt.NewRow();
var node0 = dr[0] = ds.Tables[0].Rows[i]["AreaCode"].ToString();
dr[1] = node;//（子节点）属于根节点
dr[2] = ds.Tables[0].Rows[i]["AreaName"].ToString();
dt.Rows.Add(dr);
//递归回调
Tree_Data(dt, dr, node0.ToString(), level + 1);
}
}
}
}
protected void btnDel_Click(object sender, EventArgs e)
{
int result = 0;
string tableName = "Sys_Area";
string showField = " top 1 ID";
string strWhere = " and AreaCode='" + nodeValue + "'";
DataTable dt = new BLL.Sys_Public().SelectData(showField, tableName, strWhere).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
nodeId = Utils.ToInt(dt.Rows[0]["ID"].ToString());
}
if (nodeId > 0)
{
HoneyWell.Model.Sys_Area info = new HoneyWell.BLL.Sys_Area().GetModel(nodeId);
HoneyWell.Model.Sys_Logs logs = new HoneyWell.Model.Sys_Logs();
logs.ID = 0;
logs.DutyId = Utils.ToInt(GetDutyId());
logs.LoginName = GetUserName();
logs.TitleName = "区域管理";
logs.Depicts = "删除区域信息,名称为：" + info.AreaName + "";
logs.CreateTime = DateTime.Now;
logs.IpAddress = Request.UserHostAddress;
logs.MoreCol1 = "";
logs.MoreCol2 = "";
new HoneyWell.BLL.Sys_Logs().Add(logs);
result = new HoneyWell.BLL.Sys_Public().Delete("Sys_Area", " ID=" + nodeId + "");
}
if (result > 0)
{
ScriptManager.RegisterClientScriptBlock(btnSave, GetType(), "", "alert('操作成功!');parent.location='sys_Area_Tree.aspx'", true);
}
}
