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); }