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