private string GetInherit(int model_id, string page_type) { string result = ""; BLL.sys_model bll = new BLL.sys_model(); Model.sys_model model = bll.GetModel(model_id); if (model != null) { switch (page_type) { case "index": result = model.inherit_index; break; case "list": result = model.inherit_list; break; case "detail": result = model.inherit_detail; break; } } return(result); }
private void ShowInfo(int _id) { BLL.sys_model bll = new BLL.sys_model(); Model.sys_model model = bll.GetModel(_id); txtTitle.Text = model.title; txtSortId.Text = model.sort_id.ToString(); txtInheritIndex.Text = model.inherit_index; txtInheritList.Text = model.inherit_list; txtInheritDetail.Text = model.inherit_detail; rptNavList.DataSource = model.sys_model_navs; rptNavList.DataBind(); }
private void ShowInfo(int _id) { BLL.sys_model bll = new BLL.sys_model(); Model.sys_model model = bll.GetModel(_id); txtTitle.Text = model.title; txtSortId.Text = model.sort_id.ToString(); ddlTypleID.SelectedValue = model.inherit_index; txtInheritList.Text = model.inherit_list; txtInheritDetail.Text = model.inherit_detail; checkTuijian.Checked = model.is_sys == 1 ? true : false; rptNavList.DataSource = model.sys_model_navs; rptNavList.DataBind(); }
private void sys_channel_load(HttpContext context) { StringBuilder strTxt = new StringBuilder(); BLL.sys_channel bll = new BLL.sys_channel(); DataTable dt = bll.GetList("").Tables[0]; strTxt.Append("["); int i = 1; foreach (DataRow dr in dt.Rows) { Model.manager admin_info = new ManagePage().GetAdminInfo(); if (!new BLL.manager_role().Exists(admin_info.role_id, Convert.ToInt32(dr["id"]), ManagePage.ActionEnum.View.ToString())) { continue; } BLL.sys_model bll2 = new BLL.sys_model(); Model.sys_model model2 = bll2.GetModel(Convert.ToInt32(dr["model_id"])); strTxt.Append("{"); strTxt.Append("\"text\":\"" + dr["title"] + "\","); strTxt.Append("\"isexpand\":\"false\","); strTxt.Append("\"children\":["); if (model2.sys_model_navs != null) { int j = 1; foreach (Model.sys_model_nav nav in model2.sys_model_navs) { strTxt.Append("{"); strTxt.Append("\"text\":\"" + nav.title + "\","); strTxt.Append("\"url\":\"" + nav.nav_url + "?channel_id=" + dr["id"] + "\""); //此处要优化,加上nav.nav_url网站目录标签替换 strTxt.Append("}"); if (j < model2.sys_model_navs.Count) { strTxt.Append(","); } j++; } } strTxt.Append("]"); strTxt.Append("}"); strTxt.Append(","); i++; } string newTxt = Utils.DelLastChar(strTxt.ToString(), ",") + "]"; context.Response.Write(newTxt); return; }
public string GetNameByID(string ItemId) { string HtmlValue = "20"; if (!string.IsNullOrEmpty(ItemId)) { int id = Convert.ToInt32(ItemId); BLL.sys_model bll = new BLL.sys_model(); Model.sys_model model = bll.GetModel(id); if (model != null) { HtmlValue = model.title; } } return(HtmlValue); }
private bool DoEdit(int _id) { bool result = true; BLL.sys_model bll = new BLL.sys_model(); Model.sys_model model = bll.GetModel(_id); string nav_id = Request.Form["nav_id"]; string nav_title = Request.Form["nav_title"]; string nav_url = Request.Form["nav_url"]; string nav_sort = Request.Form["nav_sort"]; if (!string.IsNullOrEmpty(nav_id) && !string.IsNullOrEmpty(nav_title) && !string.IsNullOrEmpty(nav_url) && !string.IsNullOrEmpty(nav_sort)) { try { string[] idArr = nav_id.Split(','); string[] titleArr = nav_title.Split(','); string[] urlArr = nav_url.Split(','); string[] sortArr = nav_sort.Split(','); List <DTcms.Model.sys_model_nav> ls = new List <Model.sys_model_nav>(); for (int i = 0; i < titleArr.Length; i++) { ls.Add(new DTcms.Model.sys_model_nav { id = int.Parse(idArr[i]), model_id = model.id, title = titleArr[i], nav_url = urlArr[i], sort_id = int.Parse(sortArr[i].Trim()) }); } model.sys_model_navs = ls; } catch { result = false; } } model.title = txtTitle.Text.Trim(); model.sort_id = int.Parse(txtSortId.Text.Trim()); model.inherit_index = ddlTypleID.SelectedValue.Trim(); model.inherit_list = txtInheritList.Text.Trim(); model.inherit_detail = txtInheritDetail.Text.Trim(); model.is_sys = checkTuijian.Checked ? 1 : 0; if (!bll.Update(model)) { result = false; } return(result); }
private bool DoAdd() { bool result = true; Model.sys_model model = new Model.sys_model(); BLL.sys_model bll = new BLL.sys_model(); string nav_title = Request.Form["nav_title"]; string nav_url = Request.Form["nav_url"]; string nav_sort = Request.Form["nav_sort"]; if (!string.IsNullOrEmpty(nav_title) && !string.IsNullOrEmpty(nav_url) && !string.IsNullOrEmpty(nav_sort)) { try { string[] titleArr = nav_title.Split(','); string[] urlArr = nav_url.Split(','); string[] sortArr = nav_sort.Split(','); List <DTcms.Model.sys_model_nav> ls = new List <Model.sys_model_nav>(); for (int i = 0; i < titleArr.Length; i++) { ls.Add(new DTcms.Model.sys_model_nav { title = titleArr[i], nav_url = urlArr[i], sort_id = int.Parse(sortArr[i].Trim()) }); } model.sys_model_navs = ls; } catch { result = false; } } model.title = txtTitle.Text.Trim(); model.sort_id = int.Parse(txtSortId.Text.Trim()); model.inherit_index = txtInheritIndex.Text.Trim(); model.inherit_list = txtInheritList.Text.Trim(); model.inherit_detail = txtInheritDetail.Text.Trim(); model.is_sys = 0; if (bll.Add(model) < 1) { result = false; } return(result); }
private bool DoAdd() { bool result = true; Model.sys_model model = new Model.sys_model(); BLL.sys_model bll = new BLL.sys_model(); string nav_title = Request.Form["nav_title"]; string nav_url = Request.Form["nav_url"]; string nav_sort = Request.Form["nav_sort"]; if (!string.IsNullOrEmpty(nav_title) && !string.IsNullOrEmpty(nav_url) && !string.IsNullOrEmpty(nav_sort)) { try { string[] titleArr = nav_title.Split(','); string[] urlArr = nav_url.Split(','); string[] sortArr = nav_sort.Split(','); List<DTcms.Model.sys_model_nav> ls = new List<Model.sys_model_nav>(); for (int i = 0; i < titleArr.Length; i++) { ls.Add(new DTcms.Model.sys_model_nav { title = titleArr[i], nav_url = urlArr[i], sort_id = int.Parse(sortArr[i].Trim()) }); } model.sys_model_navs = ls; } catch { result = false; } } model.title = txtTitle.Text.Trim(); model.sort_id = int.Parse(txtSortId.Text.Trim()); model.inherit_index = txtInheritIndex.Text.Trim(); model.inherit_list = txtInheritList.Text.Trim(); model.inherit_detail = txtInheritDetail.Text.Trim(); model.is_sys = 0; if (bll.Add(model) < 1) { result = false; } return result; }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.sys_model GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,title,sort_id,inherit_index,inherit_list,inherit_detail,is_sys from dt_sys_model "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; Model.sys_model model = new Model.sys_model(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { #region 父表信息 if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "") { model.title = ds.Tables[0].Rows[0]["title"].ToString(); } if (ds.Tables[0].Rows[0]["sort_id"] != null && ds.Tables[0].Rows[0]["sort_id"].ToString() != "") { model.sort_id = int.Parse(ds.Tables[0].Rows[0]["sort_id"].ToString()); } if (ds.Tables[0].Rows[0]["inherit_index"] != null && ds.Tables[0].Rows[0]["inherit_index"].ToString() != "") { model.inherit_index = ds.Tables[0].Rows[0]["inherit_index"].ToString(); } if (ds.Tables[0].Rows[0]["inherit_list"] != null && ds.Tables[0].Rows[0]["inherit_list"].ToString() != "") { model.inherit_list = ds.Tables[0].Rows[0]["inherit_list"].ToString(); } if (ds.Tables[0].Rows[0]["inherit_detail"] != null && ds.Tables[0].Rows[0]["inherit_detail"].ToString() != "") { model.inherit_detail = ds.Tables[0].Rows[0]["inherit_detail"].ToString(); } if (ds.Tables[0].Rows[0]["is_sys"] != null && ds.Tables[0].Rows[0]["is_sys"].ToString() != "") { model.is_sys = int.Parse(ds.Tables[0].Rows[0]["is_sys"].ToString()); } #endregion 父表信息end #region 子表信息 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("select id,model_id,title,nav_url,sort_id from dt_sys_model_nav "); strSql2.Append(" where model_id=@model_id "); SqlParameter[] parameters2 = { new SqlParameter("@model_id", SqlDbType.Int,4)}; parameters2[0].Value = id; DataSet ds2 = DbHelperSQL.Query(strSql2.ToString(), parameters2); if (ds2.Tables[0].Rows.Count > 0) { #region 子表字段信息 int i = ds2.Tables[0].Rows.Count; List<Model.sys_model_nav> models = new List<Model.sys_model_nav>(); Model.sys_model_nav modelt; for (int n = 0; n < i; n++) { modelt = new Model.sys_model_nav(); if (ds2.Tables[0].Rows[n]["id"] != null && ds2.Tables[0].Rows[n]["id"].ToString() != "") { modelt.id = int.Parse(ds2.Tables[0].Rows[n]["id"].ToString()); } if (ds2.Tables[0].Rows[n]["model_id"] != null && ds2.Tables[0].Rows[n]["model_id"].ToString() != "") { modelt.model_id = int.Parse(ds2.Tables[0].Rows[n]["model_id"].ToString()); } if (ds2.Tables[0].Rows[n]["title"] != null && ds2.Tables[0].Rows[n]["title"].ToString() != "") { modelt.title = ds2.Tables[0].Rows[n]["title"].ToString(); } if (ds2.Tables[0].Rows[n]["nav_url"] != null && ds2.Tables[0].Rows[n]["nav_url"].ToString() != "") { modelt.nav_url = ds2.Tables[0].Rows[n]["nav_url"].ToString(); } if (ds2.Tables[0].Rows[n]["sort_id"] != null && ds2.Tables[0].Rows[n]["sort_id"].ToString() != "") { modelt.sort_id = int.Parse(ds2.Tables[0].Rows[n]["sort_id"].ToString()); } models.Add(modelt); } model.sys_model_navs = models; #endregion 子表字段信息end } #endregion 子表信息end return model; } else { return null; } }
/// <summary> /// 增加一条数据,及其子表数据 /// </summary> public int Add(Model.sys_model model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_sys_model("); strSql.Append("title,sort_id,inherit_index,inherit_list,inherit_detail,is_sys)"); strSql.Append(" values ("); strSql.Append("@title,@sort_id,@inherit_index,@inherit_list,@inherit_detail,@is_sys)"); strSql.Append(";set @ReturnValue= @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@sort_id", SqlDbType.Int, 4), new SqlParameter("@inherit_index", SqlDbType.NVarChar, 255), new SqlParameter("@inherit_list", SqlDbType.NVarChar, 255), new SqlParameter("@inherit_detail", SqlDbType.NVarChar, 255), new SqlParameter("@is_sys", SqlDbType.TinyInt, 1), new SqlParameter("@ReturnValue", SqlDbType.Int) }; parameters[0].Value = model.title; parameters[1].Value = model.sort_id; parameters[2].Value = model.inherit_index; parameters[3].Value = model.inherit_list; parameters[4].Value = model.inherit_detail; parameters[5].Value = model.is_sys; parameters[6].Direction = ParameterDirection.Output; List <CommandInfo> sqllist = new List <CommandInfo>(); CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); //模型菜单 if (model.sys_model_navs != null) { StringBuilder strSql2; foreach (Model.sys_model_nav models in model.sys_model_navs) { strSql2 = new StringBuilder(); strSql2.Append("insert into dt_sys_model_nav("); strSql2.Append("model_id,title,nav_url,sort_id)"); strSql2.Append(" values ("); strSql2.Append("@model_id,@title,@nav_url,@sort_id)"); SqlParameter[] parameters2 = { new SqlParameter("@model_id", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@nav_url", SqlDbType.NVarChar, 255), new SqlParameter("@sort_id", SqlDbType.Int, 4) }; parameters2[0].Direction = ParameterDirection.InputOutput; parameters2[1].Value = models.title; parameters2[2].Value = models.nav_url; parameters2[3].Value = models.sort_id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); } } DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist); return((int)parameters[6].Value); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.sys_model GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,title,sort_id,inherit_index,inherit_list,inherit_detail,is_sys from dt_sys_model "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.sys_model model = new Model.sys_model(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { #region 父表信息 if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "") { model.title = ds.Tables[0].Rows[0]["title"].ToString(); } if (ds.Tables[0].Rows[0]["sort_id"] != null && ds.Tables[0].Rows[0]["sort_id"].ToString() != "") { model.sort_id = int.Parse(ds.Tables[0].Rows[0]["sort_id"].ToString()); } if (ds.Tables[0].Rows[0]["inherit_index"] != null && ds.Tables[0].Rows[0]["inherit_index"].ToString() != "") { model.inherit_index = ds.Tables[0].Rows[0]["inherit_index"].ToString(); } if (ds.Tables[0].Rows[0]["inherit_list"] != null && ds.Tables[0].Rows[0]["inherit_list"].ToString() != "") { model.inherit_list = ds.Tables[0].Rows[0]["inherit_list"].ToString(); } if (ds.Tables[0].Rows[0]["inherit_detail"] != null && ds.Tables[0].Rows[0]["inherit_detail"].ToString() != "") { model.inherit_detail = ds.Tables[0].Rows[0]["inherit_detail"].ToString(); } if (ds.Tables[0].Rows[0]["is_sys"] != null && ds.Tables[0].Rows[0]["is_sys"].ToString() != "") { model.is_sys = int.Parse(ds.Tables[0].Rows[0]["is_sys"].ToString()); } #endregion 父表信息end #region 子表信息 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("select id,model_id,title,nav_url,sort_id from dt_sys_model_nav "); strSql2.Append(" where model_id=@model_id "); SqlParameter[] parameters2 = { new SqlParameter("@model_id", SqlDbType.Int, 4) }; parameters2[0].Value = id; DataSet ds2 = DbHelperSQL.Query(strSql2.ToString(), parameters2); if (ds2.Tables[0].Rows.Count > 0) { #region 子表字段信息 int i = ds2.Tables[0].Rows.Count; List <Model.sys_model_nav> models = new List <Model.sys_model_nav>(); Model.sys_model_nav modelt; for (int n = 0; n < i; n++) { modelt = new Model.sys_model_nav(); if (ds2.Tables[0].Rows[n]["id"] != null && ds2.Tables[0].Rows[n]["id"].ToString() != "") { modelt.id = int.Parse(ds2.Tables[0].Rows[n]["id"].ToString()); } if (ds2.Tables[0].Rows[n]["model_id"] != null && ds2.Tables[0].Rows[n]["model_id"].ToString() != "") { modelt.model_id = int.Parse(ds2.Tables[0].Rows[n]["model_id"].ToString()); } if (ds2.Tables[0].Rows[n]["title"] != null && ds2.Tables[0].Rows[n]["title"].ToString() != "") { modelt.title = ds2.Tables[0].Rows[n]["title"].ToString(); } if (ds2.Tables[0].Rows[n]["nav_url"] != null && ds2.Tables[0].Rows[n]["nav_url"].ToString() != "") { modelt.nav_url = ds2.Tables[0].Rows[n]["nav_url"].ToString(); } if (ds2.Tables[0].Rows[n]["sort_id"] != null && ds2.Tables[0].Rows[n]["sort_id"].ToString() != "") { modelt.sort_id = int.Parse(ds2.Tables[0].Rows[n]["sort_id"].ToString()); } models.Add(modelt); } model.sys_model_navs = models; #endregion 子表字段信息end } #endregion 子表信息end return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.sys_model model) { using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { conn.Open(); using (SqlTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_sys_model set "); strSql.Append("title=@title,"); strSql.Append("sort_id=@sort_id,"); strSql.Append("inherit_index=@inherit_index,"); strSql.Append("inherit_list=@inherit_list,"); strSql.Append("inherit_detail=@inherit_detail,"); strSql.Append("is_sys=@is_sys"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@sort_id", SqlDbType.Int, 4), new SqlParameter("@inherit_index", SqlDbType.NVarChar, 255), new SqlParameter("@inherit_list", SqlDbType.NVarChar, 255), new SqlParameter("@inherit_detail", SqlDbType.NVarChar, 255), new SqlParameter("@is_sys", SqlDbType.TinyInt, 1), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.title; parameters[1].Value = model.sort_id; parameters[2].Value = model.inherit_index; parameters[3].Value = model.inherit_list; parameters[4].Value = model.inherit_detail; parameters[5].Value = model.is_sys; parameters[6].Value = model.id; DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters); //删除已删除的菜单 new DAL.sys_model_nav().DeleteList(conn, trans, model.sys_model_navs, model.id); //添加/修改菜单 if (model.sys_model_navs != null) { StringBuilder strSql2; foreach (Model.sys_model_nav models in model.sys_model_navs) { strSql2 = new StringBuilder(); if (models.id > 0) { strSql2.Append("update dt_sys_model_nav set "); strSql2.Append("model_id=@model_id,"); strSql2.Append("title=@title,"); strSql2.Append("nav_url=@nav_url,"); strSql2.Append("sort_id=@sort_id"); strSql2.Append(" where id=@id"); SqlParameter[] parameters2 = { new SqlParameter("@model_id", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@nav_url", SqlDbType.NVarChar, 255), new SqlParameter("@sort_id", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters2[0].Value = models.model_id; parameters2[1].Value = models.title; parameters2[2].Value = models.nav_url; parameters2[3].Value = models.sort_id; parameters2[4].Value = models.id; DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString(), parameters2); } else { strSql2.Append("insert into dt_sys_model_nav("); strSql2.Append("model_id,title,nav_url,sort_id)"); strSql2.Append(" values ("); strSql2.Append("@model_id,@title,@nav_url,@sort_id)"); SqlParameter[] parameters2 = { new SqlParameter("@model_id", SqlDbType.Int, 4), new SqlParameter("@title", SqlDbType.NVarChar, 100), new SqlParameter("@nav_url", SqlDbType.NVarChar, 255), new SqlParameter("@sort_id", SqlDbType.Int, 4) }; parameters2[0].Value = models.model_id; parameters2[1].Value = models.title; parameters2[2].Value = models.nav_url; parameters2[3].Value = models.sort_id; DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString(), parameters2); } } } trans.Commit(); } catch { trans.Rollback(); return(false); } } } return(true); }
private void sys_channel_load(HttpContext context) { StringBuilder strTxt = new StringBuilder(); BLL.sys_channel bll = new BLL.sys_channel(); DataTable dt = bll.GetList("").Tables[0]; strTxt.Append("["); int i = 1; int jj = 0; foreach (DataRow dr in dt.Rows) { jj++; Model.manager admin_info = new ManagePage().GetAdminInfo(); if (!new BLL.manager_role().Exists(admin_info.role_id, Convert.ToInt32(dr["id"]), DTEnums.ActionEnum.View.ToString())) { continue; } BLL.sys_model bll2 = new BLL.sys_model(); Model.sys_model model2 = bll2.GetModel(Convert.ToInt32(dr["model_id"])); if (jj == 1) { strTxt.Append("{"); strTxt.Append("\"text\":\"基礎設置\","); strTxt.Append("\"isexpand\":\"false\","); strTxt.Append("\"children\":["); strTxt.Append("{"); strTxt.Append("\"text\":\"房屋類型\","); strTxt.Append("\"url\":\"settings/sys_model_list.aspx\""); //此處要優化,加上nav.nav_url網站目錄標籤替換 strTxt.Append("}"); strTxt.Append(","); strTxt.Append("{"); strTxt.Append("\"text\":\"縣市鄉鎮\","); strTxt.Append("\"url\":\"Area_list.aspx\""); //此處要優化,加上nav.nav_url網站目錄標籤替換 strTxt.Append("}"); strTxt.Append(","); strTxt.Append("]"); strTxt.Append("}"); strTxt.Append(","); } strTxt.Append("{"); strTxt.Append("\"text\":\"" + dr["title"] + "\","); strTxt.Append("\"isexpand\":\"false\","); strTxt.Append("\"children\":["); if (model2.sys_model_navs != null) { int j = 1; foreach (Model.sys_model_nav nav in model2.sys_model_navs) { strTxt.Append("{"); strTxt.Append("\"text\":\"" + nav.title + "\","); switch (dr["name"].ToString()) { case "kongjian": //空間規劃 if (!nav.title.Contains("類別")) { nav.nav_url = "goods/list_kj.aspx"; } break; case "diguangjingpin": //帝光精品 if (!nav.title.Contains("類別")) { nav.nav_url = "goods/list_dg.aspx"; } break; case "banjia": //搬家幫手 if (!nav.title.Contains("類別")) { nav.nav_url = "goods/list_bj.aspx"; } break; case "VIP": //搬家幫手 if (!nav.title.Contains("類別")) { nav.nav_url = "download/list.aspx"; } break; case "土地": //土地 if (!nav.title.Contains("類別")) { nav.nav_url = "goods/list_td.aspx"; } break; default: break; } strTxt.Append("\"url\":\"" + nav.nav_url + "?channel_id=" + dr["id"] + "\""); //此處要優化,加上nav.nav_url網站目錄標籤替換 strTxt.Append("}"); if (j < model2.sys_model_navs.Count) { strTxt.Append(","); } j++; } } strTxt.Append("]"); strTxt.Append("}"); strTxt.Append(","); i++; } string newTxt = Utils.DelLastChar(strTxt.ToString(), ",") + "]"; context.Response.Write(newTxt); return; }