using Ant.Service.Common; using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using MES.Production.Service.IService; using ChangFa.Machinery.WebPage.Controllers; using Ant.ORM; using Ant.Data; using MES.Production.Entity; using JsonHelper = Ant.Service.Common.JsonHelper; namespace ChangFa.Machinery.WebPage.Areas.SysManage.Controllers { /// /// 省市县镇级联控制器 /// add 作者: 季健国 QQ:181589805 by 2016-06-16 /// public class CodeAreaController : BaseController { ICodeAreaManage CodeAreaManage { get; set; } /// /// 获取省份 /// public ActionResult Prov() { var json = new JsonHelper() { Status = "y", Msg = "Success" }; using (AntORM orm = new AntORM()) { orm.db = DataAccessFactory.CreateDataConnection("CyclingItem"); RequestModel res = new RequestModel { newSt = new SqlNote() { Author = "季健国", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "获取公告信息" } }; var reslut = orm.Queryable().Where(p => p.Id > 0).ToList(res); if (reslut.IsSuccess) { var data = reslut.ResultModel; json.Data = JsonConverter.Serialize(data); } } return Json(json); } /// /// 根据省份获取城市信息 /// /// 省份ID /// public ActionResult City(string id) { var json = new JsonHelper() { Status = "y", Msg = "Success" }; if (string.IsNullOrEmpty(id)) { json.Msg = "Error"; json.Status = "n"; } else { using (AntORM orm = new AntORM()) { orm.db = DataAccessFactory.CreateDataConnection("CyclingItem"); RequestModel res = new RequestModel { newSt = new SqlNote() { Author = "季健国", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "获取公告信息" } }; var reslut = orm.Queryable().Where(p => p.ParentCode == id).ToList(res); if (reslut.IsSuccess) { var data = reslut.ResultModel; json.Data = JsonConverter.Serialize(data); } } } return Json(json); } /// /// 根据城市获取县级市信息 /// /// 城市ID /// public ActionResult Country(string id) { var json = new JsonHelper() { Status = "y", Msg = "Success" }; if (string.IsNullOrEmpty(id)) { json.Msg = "Error"; json.Status = "n"; } else { using (AntORM orm = new AntORM()) { orm.db = DataAccessFactory.CreateDataConnection("CyclingItem"); RequestModel res = new RequestModel { newSt = new SqlNote() { Author = "季健国", NewSt = new System.Diagnostics.StackTrace(true), SqlDesc = "获取公告信息" } }; var reslut = orm.Queryable().Where(p => p.ParentCode == id).ToList(res); if (reslut.IsSuccess) { var data = reslut.ResultModel; json.Data = JsonConverter.Serialize(data); } } } return Json(json); } } }