public List <ProvinceModel> Get() { MySqlConnection con = WebApiConfig.conn(); MySqlCommand cm = con.CreateCommand(); cm.CommandText = "SELECT * from province order by PROVINCE_NAME ASC"; try { con.Open(); } catch (MySqlException ex) { throw ex; } var Province = new List <ProvinceModel>(); MySqlDataReader mySQLReader = cm.ExecuteReader(); while (mySQLReader.Read()) { ProvinceModel p = new ProvinceModel(); p.province_id = mySQLReader.GetInt32(0); p.province_code = mySQLReader.GetString(1); p.province_name = mySQLReader.GetString(2); p.geo_id = mySQLReader.GetInt32(3); Province.Add(p); } return(Province); }
public ActionResult Create() { if (!_permissionService.Authorize(StandardPermissionProvider.ManageFareTemplate)) { return(AccessDeniedView()); } var area = new AreaModel(); var provinces = _stateprovinceservice.GetStateProvincesByCountryId(area.Id); if (provinces.Count > 0) { foreach (var pro in provinces) { var p = new ProvinceModel(); p.Id = pro.Id; p.Name = pro.Name; foreach (var city in pro.Cities) { var c = new Models.FareTemplates.CityModel(); c.Id = city.Id; c.Name = city.Name; foreach (var street in city.Streets) { var s = new Models.FareTemplates.StreetModel(); s.Id = street.Id; s.Name = street.Name; c.Streets.Add(s); } p.Citys.Add(c); } area.Provinces.Add(p); } } return(View(area)); }
public int CreateOrUpdate(ProvinceModel model) { string msgError = ""; try { var result = _dbHelper.ExecuteScalarSProcedureWithTransaction(out msgError, "PROVINCE_INSERT_OR_UPDATE", "@id", model.Id, "@province_code", model.Province_Code, "@province_name", model.Province_Name, "@description", model.Description, "@active", model.Active); if ((result != null && !string.IsNullOrEmpty(result.ToString())) || !string.IsNullOrEmpty(msgError)) { throw new Exception(Convert.ToString(result) + msgError); } else { return(Constant.ReturnExcuteFunction.Success); } } catch (Exception ex) { throw ex; } }
public async Task <IActionResult> Delete(RequestDataModel request) { var settings = new JsonSerializerSettings(); var searchObject = new ProvinceModel { }; settings.DateFormatString = "dd/MM/yyyy"; searchObject = JsonConvert.DeserializeObject <ProvinceModel>(request.model, settings); var province = new ProvinceModel(); province = searchObject; province.LastModifyDate = DateTime.Now; var hostAPI = "https://localhost:44322"; var rs = await ApiProvider.PostAsync <int>(hostAPI, ApiConstant.DeleteProvince, province); if (rs == Constant.ReturnExcuteFunction.Success) { return(Json(new { messege = "Thành công !" })); } else { return(Json(new { messege = "Thất bại!" })); } }
public async Task <ResponseModel> Delete(ProvinceModel model) { ResponseModel response = new ResponseModel(); try { Province md = await _context.ProvinceRepository.FirstOrDefaultAsync(m => m.Id == model.Id); if (!md.RowVersion.SequenceEqual(model.RowVersion)) { response.ResponseStatus = Core.CommonModel.Enums.ResponseStatus.OutOfDateData; return(response); } md.Deleted = true; md.UpdateBy = base.UserId; md.UpdateDate = DateTime.Now; _context.ProvinceRepository.Update(md); await _context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } return(response); }
/// <summary> /// 获取所有省份信息 /// </summary> /// <param name="method">kaola.common.provinces.get</param> /// <param name="time"></param> /// <returns></returns> public string kaola_common_provinces_get(string method, string time) { StringBuilder sb = new StringBuilder(200); sb.Append("access_token" + str_access_tokenli[2]); //令牌 sb.Append("app_key" + str_app_keyli[2]); //密钥 sb.Append(str_method + method); //调用接口 sb.Append(str_timestamp + time); //时间戳 string s = string.Empty; string app_secret = app_secretli[2]; s = app_secret + sb.ToString() + app_secret; //使用MD5进行加密,再转化成大写 string sign = kaola_sign.To32Md5(s).ToUpper(); //string sign = kaola_sign.signValues(sb.ToString()); //签名 string url = kaola_sign.kaola_Invok_URL(str_access_tokenli[2], str_app_keyli[2], method, sign, time); WebRequest request = (WebRequest)HttpWebRequest.Create(url); //调用接口 WebResponse response = request.GetResponse(); Stream stream = response.GetResponseStream(); StreamReader read = new StreamReader(stream, Encoding.UTF8); string data = read.ReadToEnd(); List <Province> li = new List <Province>(); ProvinceModel pvmd = new ProvinceModel(); pvmd = kaola_seralia.ScriptDeserialize <ProvinceModel>(data); li = pvmd.kaola_common_provinces_get_response; return(data); }
public async Task <ResponseModel> Insert(ProvinceModel model) { ResponseModel response = new ResponseModel(); try { Province md = new Province(); md.Name = model.Name; md.Precedence = model.Precedence; md.IsActive = model.IsActive; md.CreateBy = base.UserId; md.CreateDate = DateTime.Now; md.Deleted = false; await _context.ProvinceRepository.AddAsync(md).ConfigureAwait(true); await _context.SaveChangesAsync(); } catch (Exception ex) { throw ex; } return(response); }
/// <summary> /// 选择景点列表中的节点之后,设置信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void treeView1_AfterSelect(object sender, TreeViewEventArgs e) { if (!_isSelect) { _isSelect = true; return; } var node = this.treeView1.SelectedNode; var tag = node.Tag; ProvinceModel pro = tag as ProvinceModel; if (pro != null) { this.webBrowser1.Document.InvokeScript("SetCity", new object[] { pro.Name }); return; } CityModel city = tag as CityModel; if (city != null) { this.webBrowser1.Document.InvokeScript("SetCity", new object[] { city.Name }); return; } AttractionModel attra = tag as AttractionModel; if (attra != null) { SetAttraction(attra); return; } }
/// <summary> /// Load tỉnh thành /// </summary> /// <returns></returns> public JsonResult LoadProvince() { // lấy ra nội dung xml var xmlDoc = XDocument.Load(Server.MapPath(@"~\Assets\client\data\Provinces_Data.xml")); // lấy ra các phần tử có giá trị của attribute là province var xElements = xmlDoc.Descendants("Item").Where(x => x.Attribute("type").Value == "province"); var lstProvince = new List <ProvinceModel>(); foreach (var item in xElements) { ProvinceModel p = new ProvinceModel(); p.ID = int.Parse(item.Attribute("id").Value); p.Name = item.Attribute("value").Value; lstProvince.Add(p); } return(Json(new { // trả về 1 data chứa ds các tỉnh thành data = lstProvince, status = true })); }
public ActionResult Edit(ProvinceModel provinceModel) { var result = provinceService.UpdateSingleProvince(provinceModel); var flag = result.Status == MessageStatus.Success ? true : false; var msg = result.Message; return(Json(new { flag = flag, msg = msg })); }
public static Province Map(ProvinceModel objModel) { return(new Province { Id = objModel.Id, NAME_1 = objModel.Name }); }
private void AddProvince() { ProvinceModel data = new ProvinceModel(); data.AreaID = 1; data.ProvinceCode = "test"; data.ProvinceName = "test"; IProvinceService cs = new ProvinceService(); var result = cs.InsertSingleProvince(data); }
public MessageModel InsertSingleEntity(ProvinceModel model) { Func <IEntityContext, string> operation = delegate(IEntityContext context) { context.Province.Add(model); context.SaveChanges(); return(string.Empty); }; return(base.DbOperation(operation)); }
public IActionResult Create(ProvinceModel model) { User currentUser = HttpContext.Session.Get <User>(WebUtil.CURRENT_USER); if (!(currentUser?.Role?.Id == WebUtil.ADMIN)) { return(RedirectToAction("login", "users", new { Controller = "Provinces", Action = "addProvinces" })); } new LocationsHandler().AddProvince(model.ToEntity()); return(RedirectToAction("addProvinces")); }
///<summary> ///根据城市名获取城市id ///</summary> ///<param name="Model"></param> /// <returns></returns> public string getCityIdByCityName(string id = null) { ProvinceModel model = new ProvinceModel(); List <Province> List = model.getCityIdByCityName(id); if (List.Count > 0) { string id1 = List.First().Id.ToString(); return(id1); } return("510100"); }
/// <summary> /// 设置省份 /// </summary> /// <param name="pros"></param> private void SetProvince(ProvinceModel pros) { if (pros == null) { this.txtboxAttractionInfo.Text = ""; this.listView1.Items.Clear(); return; } this.webBrowser1.Document.InvokeScript("SetCity", new object[] { pros.Name }); this.txtboxAttractionInfo.Text = ""; SetImages(null); }
/// <summary> ///得到省信息 /// </summary> /// <param name="ProvinceId"></param> /// <param name="Count"></param> /// <returns></returns> public List <ProvinceModel> GetProvince(int?ProvinceId, out int Count) { List <ProvinceModel> olist = new List <ProvinceModel>(); Count = 0; SqlConnection sqlConnection = new SqlConnection(Config.ConnectionString); SqlCommand sqlcommand = new SqlCommand("sp_Province_City_Car", sqlConnection); sqlcommand.CommandType = CommandType.StoredProcedure; SqlParameter _op = new SqlParameter("@op", "GetProvice"); _op.Direction = ParameterDirection.Input; sqlcommand.Parameters.Add(_op); SqlParameter _ItemId = new SqlParameter("@ItemId", ProvinceId == null?(Object)DBNull.Value :ProvinceId.Value); _ItemId.Direction = ParameterDirection.Input; sqlcommand.Parameters.Add(_ItemId); SqlParameter _result = new SqlParameter("@result", SqlDbType.Int); _result.Direction = ParameterDirection.Output; sqlcommand.Parameters.Add(_result); try { sqlConnection.Open(); using (IDataReader idr = sqlcommand.ExecuteReader()) { while (idr.Read()) { ProvinceModel oCModel = new ProvinceModel(); oCModel.ProvinceId = (int)idr["ProvinceId"]; if (idr["ProvinceName"] != DBNull.Value) { oCModel.ProvinceName = (string)idr["ProvinceName"]; } olist.Add(oCModel); } } Count = int.Parse(_result.Value.ToString()); } catch (Exception ex) { throw ex; } finally { sqlConnection.Close(); } return(olist); }
/// <summary> /// 更新城市列表 /// </summary> /// <param name="citys"></param> /// <param name="currentPro"></param> private void ChangeCityList(List <CityModel> citys, ProvinceModel currentPro) { List <CityModel> currentCitys = citys.FindAll(p => p.ProvinceId == currentPro.ProvinceId); if (currentCitys == null || currentCitys.Count == 0) { this.cmboxCity.DataSource = null; return; } this.cmboxCity.DataSource = currentCitys; this.cmboxCity.DisplayMember = "Name"; this.cmboxCity.SelectedIndex = 0; }
public IActionResult Update(ProvinceModel model) { try { new ProvinceHandler().UpdateProvince(model.ToProvinceEntity(), model.Id); TempData.Set <AlertModel>("Alert", new AlertModel($"{model.Name} is updated successfully", AlertModel.AlertType.Success)); } catch (Exception ex) { TempData.Set <AlertModel>("Alert", new AlertModel($"failed to update {model.Name}", AlertModel.AlertType.Error)); } return(RedirectToAction("manage")); }
public ActionResult GetListOfProvinces() { var provinceModel = new ProvinceModel(); var provinceList = provinceModel.GetListOfProvinces(); var result = (from x in provinceList select new { id = x.Province_Id, name = x.Description }).ToList(); return(Json(result, JsonRequestBehavior.AllowGet)); }
public static DataCountry LoadCitiesXmlData(string appDirectory) { DataCountry data = new DataCountry(); XDocument xDoc = XDocument.Load(appDirectory); // XDocument xDoc = XDocument.Parse(appDirectory); var regions = xDoc.Descendants("table").Where(n => n.Attribute("name").Value == "regions") .Select(b => new { Field = b.Elements().Select(x => new { Attribute = CapitalizeFirstLetter(x.FirstAttribute.Value), Value = x.Value.Trim() }) }).Distinct().ToList(); var subregions = xDoc.Descendants("table").Where(n => n.Attribute("name").Value == "subregions") .Select(b => new { Field = b.Elements().Select(x => new { Attribute = CapitalizeFirstLetter(x.FirstAttribute.Value), Value = x.Value.Trim() }) }).Distinct().ToList(); var countries = new List <CountryModel>(); var cities = new List <ProvinceModel>(); foreach (var region in regions) { var country = new CountryModel(); foreach (var fl in region.Field.ToList()) { country[fl.Attribute] = fl.Value; } countries.Add(country); } foreach (var region in subregions) { var city = new ProvinceModel(); foreach (var fl in region.Field.ToList()) { city[fl.Attribute] = fl.Value; } city.Country = countries.FirstOrDefault(c => c.Id == city.CountryId); cities.Add(city); } data.CountryModels = countries; data.ProvinceModels = cities; return(data); }
public IActionResult Delete(Province model) { ProvinceModel entity = null; try { new ProvinceHandler().DeleteProvince(model); TempData.Set <AlertModel>("Alert", new AlertModel($"{model.Name} is deleted successfully", AlertModel.AlertType.Success)); } catch (Exception ex) { TempData.Set <AlertModel>("Alert", new AlertModel($"failed to delete {model.Name}", AlertModel.AlertType.Error)); } return(RedirectToAction("manage")); }
public ActionResult ProvinceIndex() { var model = new ProvinceModel { Id = GetParams <int>("id"), Name = GetParams <string>("name"), Ename = GetParams <string>("ename"), CountryId = GetParams <int>("countryid"), Status = GetParams <int>("status"), Createtime = GetParams <DateTime>("createtime"), Updatetime = GetParams <DateTime>("updatetime"), }; return(View(model)); }
///<summary> ///显示省、城市 ///</summary> ///<param name="Model"></param> /// <returns></returns> public string Get_Province_By_Province(string id = null) { Province p = new Province(); ProvinceModel model = new ProvinceModel(); if (string.IsNullOrEmpty(id)) { p.ParentId = "###"; } else { p.ParentId = id; } p.IsUse = true; return(model.Get_Province_By_Province(p, id)); }
public static ProvincePO ToPO(this ProvinceModel item) { if (item == null) { return(null); } return(new ProvincePO { Id = item.Id, Name = item.Name, Ename = item.Ename, CountryId = item.CountryId, Status = item.Status, Createtime = item.Createtime, Updatetime = item.Updatetime, }); }
public JsonResult LoadProvince() { var xmlDoc = XDocument.Load(Server.MapPath(@"~/Design/client/data/Provinces_Data.xml")); var xElements = xmlDoc.Element("Root").Elements("Item").Where(x => x.Attribute("type").Value == "province"); var list = new List <ProvinceModel>(); ProvinceModel province = null; foreach (var item in xElements) { province = new ProvinceModel(); province.id = int.Parse(item.Attribute("id").Value); province.name = item.Attribute("value").Value; list.Add(province); } return(Json(new { data = list, status = true })); }
public JsonResult LoadProvince() { var xmlDoc = XDocument.Load(Server.MapPath(@"~/Data/Provinces_Data.xml")); var xElements = xmlDoc.Element("Root").Elements("Item").Where(x => x.Attribute("type").Value == "province"); var list = new List <ProvinceModel>(); ProvinceModel province = null; foreach (var item in xElements) { province = new ProvinceModel(); province.ID = int.Parse(item.Attribute("id").Value); province.Name = item.Attribute("value").Value; list.Add(province); } return(Json(list, JsonRequestBehavior.AllowGet)); }
public List <Model.ProvinceModel> getListModel() { List <Model.ProvinceModel> list = new List <ProvinceModel>(); string sql = string.Format("select * from GP_Province "); DataTable dt = db.RunDataTable(sql); foreach (DataRow dr in dt.Rows) { Model.ProvinceModel model = new ProvinceModel(); model.id = Convert.ToInt32(dr["id"]); model.provinceid = dr["provinceid"].ToString(); model.province = dr["province"].ToString(); list.Add(model); } return(list); }
/// <summary> /// 显示省份 /// </summary> /// <returns>省份模型集合</returns> public IList <ProvinceModel> DisplayProvinces() { IList <ProvinceModel> targets = new List <ProvinceModel>(); IXmlRepository rep = Factory.Factory <IXmlRepository> .GetConcrete(); var x = rep.FindAll(); foreach (Province p in x) { ProvinceModel instance = new ProvinceModel(); instance.ProvinceName = p.Name; instance.ProvinceID = p.ID; targets.Add(instance); } return(targets); }
public MessageModel UpdateSingleEntity(ProvinceModel model) { Func <IEntityContext, string> operation = delegate(IEntityContext context) { var data = context.Province.FirstOrDefault(m => m.ProvinceID == model.ProvinceID); if (data == null) { return("当前数据不存在或被更新,请刷新后再次操作!"); } data.ProvinceCode = model.ProvinceCode; data.AreaID = model.AreaID; data.ProvinceName = model.ProvinceName; context.SaveChanges(); return(string.Empty); }; return(base.DbOperation(operation)); }