public NModel.WebPager <NModel.DB_Area> LoadData(string ipAddress, string pagename) { BLL.DB_WebConfig bllwebcfg = new BLL.DB_WebConfig(); BLL.DB_Area bllArea = new BLL.DB_Area(); NModel.DB_WebConfig modelwebcfg = bllwebcfg.GetCodeModel(pagename); NModel.WebPager <NModel.DB_Area> model_pager = new NModel.WebPager <NModel.DB_Area>(); // model_pager.OutStr = Tool.NWeb.GetAddresByIp(ipAddress); string gocityName = Tool.NTool.GetCookieValue("gocityName"); if (!string.IsNullOrEmpty(gocityName)) { model_pager.OutStr = this.Server.UrlDecode(gocityName); } if (string.IsNullOrEmpty(model_pager.OutStr)) { model_pager.OutStr = "广州"; } // model_pager.OutObj = bllArea.GetListByName(model_pager.OutStr + "%"); model_pager.OutWebConfig = modelwebcfg != null ? modelwebcfg : new NModel.DB_WebConfig(); BLL.DB_Link bll_link = new BLL.DB_Link(); IList <NModel.DB_Link> List_link = bll_link.GetListByNumAndTop("1", 20); model_pager.IDictLink.Add("招聘友情链接", List_link); bll_link.Close(); bllArea.Close(); bllwebcfg.Close(); return(model_pager); }
public ActionResult Data_DB_Area_Level() { string[] keys = this.Request.Form.AllKeys; string page = this.Request.Form["page"]; string rows = this.Request.Form["rows"]; string code = this.Request.QueryString["code"]; string where = " 1=1 "; string levelStr = this.Request.QueryString["level"]; int level = 0; int.TryParse(levelStr, out level); level = level <= 0 ? 1 : level; bool isNotEmpty = !string.IsNullOrEmpty(code); long?TotalPage = 0; int _page = 0, _rows = 0; int.TryParse(page, out _page); int.TryParse(rows, out _rows); if (_page == 0) { _page = 1; } if (_rows == 0) { _rows = 20; } BLL.DB_Area dal = new BLL.DB_Area(); List <NModel.DB_Area> inModel = new List <NModel.DB_Area>(); if (level == 1) { inModel = dal.GetListNextLevel(level); } else { if (isNotEmpty) { if (level == 2) { where += string.Format(" and len(Area_code)-len(replace(Area_code,''_'',''''))=2 and Area_code like ''%[_]0[_]{0}''", code); } else { where += string.Format(" and len(Area_code)-len(replace(Area_code,''_'',''''))=3 and Area_code like ''%[_]{0}''", code.Replace("_", "[_]")); } } inModel = dal.GetListByWhere(where); TotalPage = dal.GetWhereListTotal(where); } NModel.PageData <NModel.DB_Area> outModel = BLL.Fun.SetJsonData <NModel.DB_Area>(inModel); outModel.TotalPage = TotalPage; dal.Close(); return(View(outModel)); }
public ActionResult Area() { string dataJson = this.Request.Form["dataJson"]; JavaScriptSerializer jss = new JavaScriptSerializer(); object[] obj = (object[])jss.DeserializeObject(dataJson); BLL.DB_Area bll = new BLL.DB_Area(); List <NModel.DB_Area> nmodel = bll.GetList(); foreach (NModel.DB_Area n in nmodel) { n.Area_PinYin = Pinyin.GetPinyin(n.Area_Name); bll.Edit(n); } return(View()); }