protected void btnDel_Click(object sender, EventArgs e)
{
int result = 0;
if (Utils.ToInt(nodeValue) > 0)
{
HoneyWell.Model.Sys_Type info = new HoneyWell.BLL.Sys_Type().GetModel(Convert.ToInt32(nodeValue));
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.TName + "";
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_Type", " ID=" + Utils.ToInt(nodeValue) + "");
}
if (result > 0)
{
ScriptManager.RegisterClientScriptBlock(btnSave, GetType(), "", "alert('操作成功!');parent.location='Sys_Type_Tree.aspx'", true);
}
}
public void BindData()
{
if (nodeText != "")
{
HoneyWell.Model.Sys_Type sys_Model = new HoneyWell.BLL.Sys_Type().GetModel(Utils.ToInt(nodeValue));
txtCCode.Value = sys_Model.TCode;
txtCName.Value = sys_Model.TName;
txtCOrder.Value = sys_Model.TOrder.ToString();
TPic = sys_Model.TSmallPic;
if (TPic != "")
{
string[] sArray = TPic.Split(',');
foreach (string j in sArray)
{
TPic_List += "<li>";
TPic_List += "<input type=\"hidden\" name=\"ImgName\" value=\"" + j.ToString() + "\" />";
TPic_List += "<div class=\"img-box\">";
TPic_List += "<img src=\"" + GetImgUrl() + "/upload/product/" + j.ToString() + "\" onclick=\"setOpenImg(this.src);\" bigsrc=\"" + GetImgUrl() + "/upload/product/" + j.ToString() + "\" />";
TPic_List += "</div>";
TPic_List += "<a href=\"javascript:;\" onclick=\"delImg(this);\">删除</a>";
TPic_List += "</li>";
}
}
}
}
public void BindData()
{
if (Utils.ToInt(nodeValue) > 0)
{
HoneyWell.Model.Sys_Type menu = new HoneyWell.BLL.Sys_Type().GetModel(Utils.ToInt(nodeValue));
menuLevel = menu.TLevel.ToString();
lab_ParentName.InnerHtml = menu.TName;
}
else
{
menuLevel = "0";
lab_ParentName.InnerHtml = nodeText;
}
}
private DataTable Tree_Table()
{
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add(new DataColumn("id", typeof(string))); //id列 类型int
dt.Columns.Add(new DataColumn("parent_id", typeof(string))); //父id列 类型int
dt.Columns.Add(new DataColumn("name", typeof(string))); //名称列 类型string
//构造根节点
dr = dt.NewRow();
var node0 = dr[0] = "0";
dr[1] = DBNull.Value;
dr[2] = "根目录";
dt.Rows.Add(dr);
//构造一级菜单
string TableName = "Sys_Type";
string SqlWhere = " and TLevel=1 order by TOrder asc";
DataSet ds = new HoneyWell.BLL.Sys_Type().GetTypeTree(TableName, 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 node1 = dr[0] = ds.Tables[0].Rows[i]["ID"].ToString();
dr[1] = node0;//（子节点）属于根节点
dr[2] = ds.Tables[0].Rows[i]["TName"].ToString();
dt.Rows.Add(dr);
//构造二级菜单
string SqlWhere1 = " and TLevel=2 and ParentId=" + Utils.ToInt(node1) + " order by TOrder asc";
DataSet ds1 = new HoneyWell.BLL.Sys_Type().GetTypeTree(TableName, SqlWhere1);
if (ds1 != null && ds1.Tables[0].Rows.Count > 0)
{
for (int j = 0; j < ds1.Tables[0].Rows.Count; j++)
{
dr = dt.NewRow();
var node2 = dr[0] = ds1.Tables[0].Rows[j]["ID"].ToString();
dr[1] = node1;
dr[2] = ds1.Tables[0].Rows[j]["TName"].ToString();
dt.Rows.Add(dr);
//构造三级菜单
string SqlWhere2 = " and TLevel=3 and ParentID=" + Utils.ToInt(node2) + " order by TOrder asc";
DataSet ds2 = new HoneyWell.BLL.Sys_Type().GetTypeTree(TableName, SqlWhere2);
if (ds2 != null && ds2.Tables[0].Rows.Count > 0)
{
for (int k = 0; k < ds2.Tables[0].Rows.Count; k++)
{
dr = dt.NewRow();
var node3 = dr[0] = ds2.Tables[0].Rows[k]["ID"].ToString();
dr[1] = node2;
dr[2] = ds2.Tables[0].Rows[k]["TName"].ToString();
dt.Rows.Add(dr);
}
}
}
}
}
}
return(dt);
}
