private void BuildTree2(string id) { if (id == "") { id = "1"; } List <SqlParameter> parameters = new List <SqlParameter>(); //sql参数存储对象 var parameter = new SqlParameter("@ParentId", DbType.AnsiString); parameter.Value = id; parameters.Add(parameter); DataSet dataset = proTypeDal.GetList("", parameters); //查询所有类别信息 _stringBuilder.Append("["); var i = 0; foreach (DataRow trow in dataset.Tables[0].Rows) { if (i != 0) { _stringBuilder.Append(","); } var text = trow["AreaName"].ToString().Trim(); var no = trow["AreaId"].ToString().Trim(); var pid = trow["ParentId"]; var href = "ProductSpecMain.aspx?AreaId=" + no; _stringBuilder.Append("{\"id\": " + no + ",\"pId\":" + pid + ",\"name\":\"" + text + "\"}"); i++; } _stringBuilder.Append("]"); }
/// <summary> /// 获取区域信息 /// </summary> /// <returns></returns> public DataSet GetArea() { DataSet dt = new DataSet(); List <SqlParameter> parameters = new List <SqlParameter>(); string sqlWhere = " ParentId =0 "; dt = orgAreaDal.GetList(sqlWhere, parameters); return(dt); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } try { if (string.IsNullOrEmpty(Request.Form["id"])) { return; } var id = Request.Form["id"]; if (string.IsNullOrEmpty(Request.Form["name"])) { return; } var pcname = Request.Form["name"]; var bll = new OrgArea(); var model = bll.GetModel(id); model.AreaName = pcname; List <SqlParameter> parameters = new List <SqlParameter>(); var parameter = new SqlParameter("@AreaName", DbType.AnsiString) { Value = pcname }; parameters.Add(parameter); var parameter1 = new SqlParameter("@AreaId", DbType.AnsiString) { Value = id }; parameters.Add(parameter1); var parameter2 = new SqlParameter("@ParentId", DbType.AnsiString) { Value = model.ParentId }; parameters.Add(parameter2); if (bll.GetList(" AreaName=@AreaName and Status=1 and AreaId!=@AreaId ", parameters).Tables[0].Rows.Count > 0) { Response.Write("区域名称已存在"); Response.End(); } Response.Write(bll.Update(model) ? "修改成功" : "修改失败"); Response.End(); } catch (System.Threading.ThreadAbortException ex) { } catch (Exception) { Response.Write("修改失败"); Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } try { if (string.IsNullOrEmpty(Request.Form["id"])) { return; } var id = Request.Form["id"]; if (string.IsNullOrEmpty(Request.Form["name"])) { return; } var pcname = Request.Form["name"]; var bll = new OrgArea(); List <SqlParameter> parameters = new List <SqlParameter>(); var parameter = new SqlParameter("@AreaName", DbType.AnsiString) { Value = pcname }; parameters.Add(parameter); if (bll.GetList(" AreaName=@AreaName and Status=1 ", parameters).Tables[0].Rows.Count > 0) { Response.Write("区域名称已存在"); Response.End(); } var model = new Admin.Model.OrgArea { AreaName = pcname, ParentId = id, AreaId = bll.MaxAreaId(), AreaLevel = 3, Status = 1 }; Response.Write(bll.Add(model) ? "保存成功" : "保存失败"); Response.End(); } catch (System.Threading.ThreadAbortException ex) { } catch (Exception) { Response.Write("保存失败"); Response.End(); } }
/// <summary> /// 构建栏目树 /// </summary> private void BuildTree(string id) { try { if (!string.IsNullOrEmpty(Request.QueryString["menu"])) { List <SqlParameter> parameters = new List <SqlParameter>(); //sql参数存储对象 DataSet myset = proTypeDal.GetList(" Status=1 ", parameters); //查询所有类别信息 if (id == "") { id = "1"; } foreach ( var iRow in myset.Tables[0].Rows.Cast <DataRow>().Where(iRow => iRow["AreaId"].ToString() == id)) { iRow["ParentId"] = DBNull.Value; } myset.Relations.Add("NodeRelation", myset.Tables[0].Columns["AreaId"], myset.Tables[0].Columns["ParentId"], false); _stringBuilder.Append("["); var i = 0; if (i != 0) { _stringBuilder.Append(","); } foreach (DataRow mRow in myset.Tables[0].Rows) { if (!mRow.IsNull("ParentId")) { continue; } var text = mRow["AreaName"].ToString().Trim(); var no = mRow["AreaId"].ToString().Trim(); var href = Request.QueryString["menu"] + "?AreaId=" + no; if (mRow.GetChildRows("NodeRelation").Length <= 0) { _stringBuilder.Append("{\"state\":\"open\",\"data\":{\"title\": \"" + text + "\",\"icon\": \"jstree-iconla\",\"attr\": { \"href\": \"" + href + "\", \"target\": \"center\" }},\"attr\": { \"id\": \"" + no + "\" }"); } else { _stringBuilder.Append("{\"state\":\"open\",\"data\":{\"title\": \"" + text + "\",\"attr\": { \"href\": \"" + href + "\", \"target\": \"center\" }},\"attr\": { \"id\": \"" + no + "\" }"); } //_stringBuilder.Append("{\"data\":{\"title\": \"" + text + "\",\"attr\": { \"href\": \"" + href + // "\", \"target\": \"center\" }},\"attr\": { \"id\": \"" + no + "\" }"); BuildSubTree(mRow); _stringBuilder.Append("}"); i++; } _stringBuilder.Append("]"); } } catch (Exception ex) { throw new Exception(ex.Message); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { if (!string.IsNullOrEmpty(Request.QueryString["ProvinceId"])) { string provinceId = Request.QueryString["ProvinceId"]; List <SqlParameter> parameters = new List <SqlParameter>(); DataTable dts = orgAreaDal.GetList(" ParentId=" + provinceId + " and [Status]=1 ", parameters).Tables[0]; var areaName = string.Empty; if (dts.Rows.Count > 0) { for (int i = 0; i < dts.Rows.Count; i++) { areaName += "," + dts.Rows[i]["AreaId"] + "|"; areaName += dts.Rows[i]["AreaName"] + " "; } } Response.Write(areaName); Response.End(); } if (!string.IsNullOrEmpty(Request.QueryString["CityId"])) { string cityId = Request.QueryString["CityId"]; List <SqlParameter> parameters = new List <SqlParameter>(); DataTable dts = orgAreaDal.GetList(" ParentId=" + cityId + " and [Status]=1 ", parameters).Tables[0]; var areaName = string.Empty; if (dts.Rows.Count > 0) { for (int i = 0; i < dts.Rows.Count; i++) { areaName += "," + dts.Rows[i]["AreaId"] + "|"; areaName += dts.Rows[i]["AreaName"] + " "; } } Response.Write(areaName); Response.End(); } if (!string.IsNullOrEmpty(Request.QueryString["OrgId"])) { Response.Write(orgOrgDal.DelOrgWorStaTran(Request.QueryString["OrgId"]) ? "删除成功" : "删除失败"); Response.End(); } else { Response.Write("删除失败"); Response.End(); } } catch (System.Threading.ThreadAbortException ex) { } catch (Exception) { Response.Write("删除失败"); Response.End(); } } }