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