/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DistrictInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dt_District set ");
strSql.Append("DistrictName=@DistrictName,");
strSql.Append("CityID=@CityID");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@DistrictName", SqlDbType.NVarChar, 50),
new SqlParameter("@CityID", SqlDbType.BigInt, 8),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.DistrictName;
parameters[1].Value = model.CityID;
parameters[2].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 创建一个区域信息
/// </summary>
/// <param name="dist">区域信息</param>
/// <param name="superior">上级区域信息</param>
/// <returns>区域ID</returns>
public AreaInfo CreateDist(DistrictInfo dist, AreaInfo superior = null)
{
AreaInfo areaInfo = new AreaInfo
{
Name = dist.Name,
ShortName = GetShortName(dist.Name),
Code = dist.CityCodeString,
Zip = dist.Adcode,
TelephoneCode = string.Empty,
AreaType = GetAreaType(dist.Level),
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now
};
areaInfo.NameEn = GetNameEn(areaInfo);
if (superior != null)
{
areaInfo.SuperiorId = superior.IdString;
areaInfo.SuperiorCode = superior.Code;
areaInfo.SuperiorName = superior.Name;
areaInfo.SuperiorIds = superior.SuperiorIds.ToJson().JsonToObject <List <string> >();
areaInfo.SuperiorIds.Add(superior.Id.ToString());
areaInfo.SuperiorNames = superior.SuperiorNames.ToJson().JsonToObject <List <string> >();
areaInfo.SuperiorNames.Add(superior.Name.ToString());
}
_Dal.InsertObject(areaInfo);
return(areaInfo);
}
public HttpResponseMessage GetDistrictInfoById(HttpRequestMessage reqObject)
{
string AccountStatusId = string.Empty;
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
if (_requestedDataObject != null && _requestedDataObject.BusinessData != null)
{
_DistrictInfo = JsonConvert.DeserializeObject <DistrictInfo>(_requestedDataObject.BusinessData);
AccountStatusId = _DistrictInfo.DistrictId;
}
if (!string.IsNullOrWhiteSpace(AccountStatusId))
{
_DistrictInfo = new DistrictInfo();
_DistrictInfo = _IDistrictInfoService.GetDistrictInfoById(AccountStatusId);
}
if (_DistrictInfo != null)
{
_serviceResponse = _IDataManipulation.SetResponseObject(_DistrictInfo, "information has been fetched successfully");
}
else
{
_serviceResponse = _IDataManipulation.SetResponseObject(_DistrictInfo, "Account Status Setup Not Found...");
}
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DistrictInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update pre_common_district set ");
strSql.Append("name=@name,");
strSql.Append("level=@level,");
strSql.Append("upid=@upid");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@name", SqlDbType.NVarChar, 255),
new SqlParameter("@level", SqlDbType.Int, 4),
new SqlParameter("@upid", SqlDbType.Int, 4),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.name;
parameters[1].Value = model.level;
parameters[2].Value = model.upid;
parameters[3].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(DistrictInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into pre_common_district(");
strSql.Append("id,name,level,upid)");
strSql.Append(" values (");
strSql.Append("@id,@name,@level,@upid)");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@name", SqlDbType.NVarChar, 255),
new SqlParameter("@level", SqlDbType.Int, 4),
new SqlParameter("@upid", SqlDbType.Int, 4)
};
parameters[0].Value = model.id;
parameters[1].Value = model.name;
parameters[2].Value = model.level;
parameters[3].Value = model.upid;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private WeatherInfo GetWeatherByDistrict(DistrictInfo District)
{
if (District == null)
{
return(null);
}
FormatDistrict(District);
if (District.Nation == Root.Name)
{
if (Root.Childs.ContainsKey(District.AmapCityCode))
{
Node city = Root.Childs[District.AmapCityCode];
if (city.Childs.ContainsKey(District.District))
{
Node district = city.Childs[District.District];
return(district.Weather);
}
else
{
return(city.Weather);
}
}
else
{
return(Root.Weather);
}
}
else
{
return(null);
}
}
public async Task <IActionResult> PutDistrictInfo([FromRoute] int id, [FromBody] DistrictInfo districtInfo)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != districtInfo.IdDw)
{
return(BadRequest());
}
_context.Entry(districtInfo).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DistrictInfoExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
private void InsertIntoTree(DistrictInfo info, Node root)
{
root.Name = info.Nation;
if (root.Childs == null)
{
root.Childs = new Dictionary <string, Node>();
}
if (!root.Childs.ContainsKey(info.AmapCityCode))
{
root.Childs.Add(info.AmapCityCode, new Node()
{
Id = info.AmapCityCode, Name = info.City, Parent = root
});
}
if (root.Childs[info.AmapCityCode].Childs == null)
{
root.Childs[info.AmapCityCode].Childs = new Dictionary <string, Node>();
}
if (!root.Childs[info.AmapCityCode].Childs.ContainsKey(info.District))
{
root.Childs[info.AmapCityCode].Childs.Add(info.District, new Node()
{
Id = info.AreaId, Name = info.District, Parent = root.Childs[info.AmapCityCode]
});
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DistrictInfo DataRowToModel(DataRow row)
{
var model = new DistrictInfo();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["name"] != null)
{
model.name = row["name"].ToString();
}
if (row["level"] != null && row["level"].ToString() != "")
{
model.level = int.Parse(row["level"].ToString());
}
if (row["upid"] != null && row["upid"].ToString() != "")
{
model.upid = int.Parse(row["upid"].ToString());
}
}
return(model);
}
public override bool SaveUpdated()
{
DistrictInfo info = new DistrictInfo();
if (info != null)
{
SetInfo(info);
try
{
#region 更新数据
bool succeed = BLLFactory <District> .Instance.Update(info, ID);
if (succeed)
{
//可添加其他关联操作
return(true);
}
#endregion
}
catch (Exception ex)
{
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmEditCity));
MessageDxUtil.ShowError(ex.Message);
}
}
return(false);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DistrictInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dt_District(");
strSql.Append("DistrictName,CityID)");
strSql.Append(" values (");
strSql.Append("@DistrictName,@CityID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@DistrictName", SqlDbType.NVarChar, 50),
new SqlParameter("@CityID", SqlDbType.BigInt, 8)
};
parameters[0].Value = model.DistrictName;
parameters[1].Value = model.CityID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void FormatDistrict(DistrictInfo dist)
{
if (!string.IsNullOrEmpty(dist.District))
{
if (dist.District.Equals("浦东新区") || dist.District.Equals("滨海新区") || dist.District.Equals("呼市郊区") ||
dist.District.Equals("尖草坪区") || dist.District.Equals("小店区") ||
dist.District.Equals("淮阴区") || dist.District.Equals("淮安区") ||
dist.District.Equals("黄山区") || dist.District.Equals("黄山风景区") ||
dist.District.Equals("赫山区") ||
dist.District.Equals("通化县") || dist.District.Equals("本溪县") ||
dist.District.Equals("辽阳县") || dist.District.Equals("建平县") ||
dist.District.Equals("承德县") || dist.District.Equals("大同县") ||
dist.District.Equals("五台县") || dist.District.Equals("伊宁县") ||
dist.District.Equals("芜湖县") || dist.District.Equals("南昌县") ||
dist.District.Equals("上饶县") || dist.District.Equals("吉安县") ||
dist.District.Equals("衡阳县") || dist.District.Equals("邵阳县") ||
dist.District.Equals("遵义县") || dist.District.Equals("宜宾县")) //含同名区，特定县不做转换
{
}
else
{
int smallestLength = dist.District.Length;
if (smallestLength == 2 && dist.District[smallestLength - 1].Equals('县'))//两字县不做转换
{
}
else if (dist.District[smallestLength - 1].Equals('市') || dist.District[smallestLength - 1].Equals('区') || dist.District[smallestLength - 1].Equals('县'))
{
dist.District = dist.District.Remove(smallestLength - 1);
}
}
}
}
public HttpResponseMessage DeleteDistrictInfo(HttpRequestMessage reqObject)
{
int result = 0;
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
if (_requestedDataObject != null && _requestedDataObject.BusinessData != null)
{
_DistrictInfo = JsonConvert.DeserializeObject <DistrictInfo>(_requestedDataObject.BusinessData);
}
if (_DistrictInfo == null || string.IsNullOrWhiteSpace(_DistrictInfo.DistrictId))
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "Account Status Setup Id Not Found...");
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
result = _IDistrictInfoService.DeleteDistrictInfo(_DistrictInfo);
if (result == 1)
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "information has been deleted successfully");
}
else
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "information hasn't been deleted");
}
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
private void SetInfo(DistrictInfo info)
{
info.DistrictName = this.txtDistrict.Text;
info.CityID = Convert.ToInt32(this.txtCity.Tag);
info.CurrentLoginUserId = LoginUserInfo.ID;
}
public int AddDistrictInfo(DistrictInfo _DistrictInfo)
{
try
{
var _max = _IUoW.Repository <DistrictInfo>().GetMaxValue(x => x.DistrictId) + 1;
_DistrictInfo.DistrictId = _max.ToString().PadLeft(3, '0');
_DistrictInfo.AuthStatusId = "A";
_DistrictInfo.LastAction = "ADD";
_DistrictInfo.MakeDT = System.DateTime.Now;
_DistrictInfo.MakeBy = "mtaka";
var result = _IUoW.Repository <DistrictInfo>().Add(_DistrictInfo);
#region Auth Log
if (result == 1)
{
_IAuthLogService = new AuthLogService();
long _outMaxSlAuthLogDtl = 0;
result = _IAuthLogService.AddAuthLog(_IUoW, null, _DistrictInfo, "ADD", "0001", "090101005", 1, "DistrictInfo", "MTK_CP_DISTRICT_INFO", "DistrictId", _DistrictInfo.DistrictId, "mtaka", _outMaxSlAuthLogDtl, out _outMaxSlAuthLogDtl);
}
#endregion
if (result == 1)
{
_IUoW.Commit();
}
return(result);
}
catch (Exception ex)
{
_ObjErrorLogService = new ErrorLogService();
_ObjErrorLogService.AddErrorLog(ex, string.Empty, "AddDistrictInfo(obj)", string.Empty);
return(0);
}
}
public async Task <IActionResult> PostDistrictInfo([FromBody] DistrictInfo districtInfo)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.DistrictInfo.Add(districtInfo);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (DistrictInfoExists(districtInfo.IdDw))
{
return(new StatusCodeResult(StatusCodes.Status409Conflict));
}
else
{
throw;
}
}
return(CreatedAtAction("GetDistrictInfo", new { id = districtInfo.IdDw }, districtInfo));
}
private void FormatDistrict(DistrictInfo dist)
{
if (!string.IsNullOrEmpty(dist.District))
{
if (dist.District.Equals("浦东新区") || dist.District.Equals("滨海新区") || dist.District.Equals("呼市郊区")
|| dist.District.Equals("尖草坪区") || dist.District.Equals("小店区")
|| dist.District.Equals("淮阴区") || dist.District.Equals("淮安区")
|| dist.District.Equals("黄山区") || dist.District.Equals("黄山风景区")
|| dist.District.Equals("赫山区")
|| dist.District.Equals("通化县") || dist.District.Equals("本溪县")
|| dist.District.Equals("辽阳县") || dist.District.Equals("建平县")
|| dist.District.Equals("承德县") || dist.District.Equals("大同县")
|| dist.District.Equals("五台县") || dist.District.Equals("伊宁县")
|| dist.District.Equals("芜湖县") || dist.District.Equals("南昌县")
|| dist.District.Equals("上饶县") || dist.District.Equals("吉安县")
|| dist.District.Equals("衡阳县") || dist.District.Equals("邵阳县")
|| dist.District.Equals("遵义县") || dist.District.Equals("宜宾县"))//含同名区，特定县不做转换
{
}
else
{
int smallestLength = dist.District.Length;
if (smallestLength == 2 && dist.District[smallestLength - 1].Equals('县'))//两字县不做转换
{
}
else if (dist.District[smallestLength - 1].Equals('市') || dist.District[smallestLength - 1].Equals('区') || dist.District[smallestLength - 1].Equals('县'))
{
dist.District = dist.District.Remove(smallestLength - 1);
}
}
}
}
public HttpResponseMessage UpdateDistrictInfo(HttpRequestMessage reqObject)
{
int result = 0;
_requestedDataObject = _IDataManipulation.GetRequestedDataObject(reqObject);
if (_requestedDataObject != null && _requestedDataObject.BusinessData != null)
{
_DistrictInfo = JsonConvert.DeserializeObject <DistrictInfo>(_requestedDataObject.BusinessData);
bool IsValid = ModelValidation.TryValidateModel(_DistrictInfo, out _modelErrorMsg);
if (IsValid)
{
result = _IDistrictInfoService.UpdateDistrictInfo(_DistrictInfo);
}
}
if (!string.IsNullOrWhiteSpace(_modelErrorMsg))
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, _modelErrorMsg);
}
else if (result == 1)
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "information has been updated successfully");
}
else
{
_serviceResponse = _IDataManipulation.SetResponseObject(result, "information hasn't been updated");
}
_response = _IDataManipulation.CreateResponse(_serviceResponse, reqObject);
return(_response);
}
/// <summary>
/// 高德逆地理编码，根据经纬度获取位置描述
/// Post
/// http://restapi.amap.com/v3/geocode/regeo?key=b34d6e34c5ab8bab7ff3075d2a12ca5c&location=113.921076,22.499654&radius=10&extensions=all&coordsys=gps
/// </summary>
/// <param name="lat">纬度</param>
/// <param name="lon">经度</param>
/// <param name="radius">精确度</param>
/// <returns></returns>
private DistrictInfo GetDistrictByGeo(double longitude, double latitude, double radius)
{
///TEMP
///return new DistrictInfo() { AreaId = "101191004", Name = "灌云", District = "连云港", Province = "江苏", Nation = "中国" };
try
{
string url = string.Format("http://restapi.amap.com/v3/geocode/regeo?key={0}&location={1},{2}&radius={3}&extensions=all&coordsys=autonavi", SysConfig.AmapWebApiGeocodeKey, longitude, latitude, radius);
WebRequest request = WebRequest.Create(url);
request.Method = "GET";
var responeStream = request.GetResponse();
StreamReader reader = new StreamReader(responeStream.GetResponseStream());
string jsonStr = reader.ReadToEnd();
JObject jobject = (JObject)JsonConvert.DeserializeObject(jsonStr);
DistrictInfo district = new DistrictInfo();
district.Nation = "中国";
district.Province = jobject["regeocode"]["addressComponent"]["province"].ToString();
district.City = jobject["regeocode"]["addressComponent"]["city"].ToString();
district.AmapCityCode = jobject["regeocode"]["addressComponent"]["citycode"].ToString();
district.District = jobject["regeocode"]["addressComponent"]["district"].ToString();
return(district);
}
catch
{
return(null);
}
}
public override bool SaveAddNew()
{
DistrictInfo info = new DistrictInfo();
SetInfo(info);
try
{
#region 新增数据
bool succeed = BLLFactory <District> .Instance.Insert(info);
if (succeed)
{
//可添加其他关联操作
return(true);
}
#endregion
}
catch (Exception ex)
{
LogHelper.WriteLog(LogLevel.LOG_LEVEL_CRIT, ex, typeof(FrmEditDistrict));
MessageDxUtil.ShowError(ex.Message);
}
return(false);
}
private PP_PersonInfo CreatePersonInfoSource(DeptMember dm)
{
PP_PersonInfo tempPersonInfo = new PP_PersonInfo();
tempPersonInfo.GUID = dm.UserID;
tempPersonInfo.DISTRICT_CODE = dm.DistrictCode;
tempPersonInfo.NAME = dm.RealName;
tempPersonInfo.SEX = dm.UserSex;
tempPersonInfo.DUTY = dm.UserDuty;
DistrictInfo rootDistrict = PT.Profile.Business.DistrictHelper.DistrictInfos.FindItemByCode(dm.DistrictCode);
if (rootDistrict != null)
{
tempPersonInfo.UNIT = rootDistrict.Name + "无委";
}
tempPersonInfo.DEPT = dm.DeptName;
tempPersonInfo.DEPT_ID = dm.DeptID;
//tempPersonInfo.TASK = dm.UserID;
//tempPersonInfo.PERSON_TYPE = dm.UserID;
tempPersonInfo.ADD_TYPE = 3;//选择加入
try
{
var organizationChannel = PT_BS_Service.Client.Framework.BeOperationInvoker.GetInterface <PT.Profile.Interface.IOrganization>();
var userInfo = this.userInfoList.Find(item => item.UserID.Equals(dm.UserID));
if (userInfo != null)
{
tempPersonInfo.PHONE = userInfo.UserPhone;
tempPersonInfo.PHOTO = organizationChannel.GetUserPicture(dm.UserID);
}
//PT.Profile.Types.UserInfo ui = new PT.Profile.Types.UserInfo();
//PT_BS_Service.Client.Framework.BeOperationInvoker.Invoke<PT.Profile.Interface.IOrganization, PT.Profile.Types.UserInfo>(p =>
//{
// ui = p.GetUser(dm.UserID);
// return ui;
//});
//if (ui != null)
//{
// tempPersonInfo.PHONE = ui.UserPhone;
// //tempPersonInfo.PHOTO = ui.UserPicture;
// PT_BS_Service.Client.Framework.BeOperationInvoker.Invoke<PT.Profile.Interface.IOrganization>(p =>
// {
// tempPersonInfo.PHOTO = p.GetUserPicture(dm.UserID);
// });
//}
}
catch
{ }
return(tempPersonInfo);
}
public void UpdateInfo(DistrictInfo dInfo)
{
Population -= Random.Range((MaxPopPerTile / 4) * 3, MaxPopPerTile);
Population += dInfo.Population;
Income = CalculateIncome();
GameObject.Find("Sidebar").GetComponent <SidebarController>().UpdateTownInfo(this);
}
public List <Customer> DistrictCombo()
{
//List<Customer> customers = new List<Customer>();
List <DistrictInfo> districts = new List <DistrictInfo>();
//Connection
string connectionString = @"Server=DESKTOP-LQ035EB; Database=CustomerInfo; Integrated Security=True";
SqlConnection sqlConnection = new SqlConnection(connectionString);
//Command
//INSERT INTO Items (Name, Price) Values ('Black', 120)
string commandString = @"SELECT * FROM District";
SqlCommand sqlCommand = new SqlCommand(commandString, sqlConnection);
//Open
sqlConnection.Open();
//Show
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
DistrictInfo district = new DistrictInfo();
district.District = sqlDataReader["District"].ToString();
//Customer customer = new Customer();
//customer.Code = sqlDataReader["Code"].ToString();
//customer.Did = Convert.ToInt32(sqlDataReader["Did"]);
//customer.Name = sqlDataReader["Name"].ToString();
//customer.Address = sqlDataReader["Address"].ToString();
//customer.Contact = Convert.ToDouble(sqlDataReader["Contact"]);
//customers.Add(customer);
}
//SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
//DataTable dataTable = new DataTable();
//sqlDataAdapter.Fill(dataTable);
//if (dataTable.Rows.Count > 0)
//{
// return dataTable;
// //showDataGridView.DataSource = dataTable;
//}
//else
//{
// MessageBox.Show("No Data Found");
//}
//Close
sqlConnection.Close();
return(districts);
}
private void SetInfo(DistrictInfo info)
{
info.DistrictName = this.txtDistrict.Text;
info.CityId = Convert.ToInt32(this.txtCity.Tag);
info.CurrentLoginUserId = LoginUserInfo.Id;
if (0 == info.Id)
{
info.Id = BLLFactory <District> .Instance.GetMaxId() + 1;
}
}
public int SaveDistrictName(DistrictInfo aDistrictInfo)
{
int rowAffected = 0;
string query = "INSERT INTO DistrictInfo VALUES('" + aDistrictInfo.DistrictName + "','" + aDistrictInfo.DivisionInfoId + "',GETDATE() )";
Connection.Open();
Command = new SqlCommand(query, Connection);
rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
/// <summary>
/// 使用事务参数，插入数据，最后统一提交事务处理
/// </summary>
/// <param name="dictData">字典数据</param>
/// <param name="seq">排序</param>
/// <param name="trans">事务对象</param>
private void InsertDictData(string dictData, DbTransaction trans)
{
if (!string.IsNullOrWhiteSpace(dictData))
{
DistrictInfo info = new DistrictInfo();
info.DistrictName = dictData;
info.CityID = Convert.ToInt32(this.txtCity.Tag.ToString());
bool succeed = BLLFactory <District> .Instance.Insert(info, trans);
}
}
private void FrmEditCityDistrict_Load(object sender, EventArgs e)
{
if (Id > 0)
{
DistrictInfo info = BLLFactory <District> .Instance.FindById(Id);
if (info != null)
{
this.txtDistrict.Text = info.DistrictName;
}
}
}
private void FrmEditCityDistrict_Load(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(ID))
{
DistrictInfo info = BLLFactory <District> .Instance.FindByID(ID);
if (info != null)
{
this.txtDistrict.Text = info.DistrictName;
}
}
}
public override void DisplayData()
{
if (Id > 0)
{
DistrictInfo info = BLLFactory <District> .Instance.FindById(Id);
if (info != null)
{
this.txtDistrict.Text = info.DistrictName;
}
}
this.txtCity.Focus();
}
public override void DisplayData()
{
if (!string.IsNullOrEmpty(ID))
{
DistrictInfo info = BLLFactory <District> .Instance.FindByID(ID);
if (info != null)
{
this.txtDistrict.Text = info.DistrictName;
}
}
this.txtCity.Focus();
}
protected void bind()
{
if (id > 0 && parentid > 0)
{
Response.Write("<script>alert('参数错误');history.go(-1);</script>");
Response.End();
}
if (id > 0)
{
hfid.Value = id.ToString();
DistrictInfo info = BLL.DistrictBLL.GetModel(id);
if (info == null || info.DistId != id)
{
Response.Write("<script>alert('不存在对应的数据');history.go(-1);</script>");
Response.End();
}
this.txbName.Text = info.Name;
txbcall_index.Text = info.call_index;
txbSort.Text = info.Sort.ToString();
parentid = info.ParentId;
if (parentid == 0)
{
title = "修改省份";
}
}
else
{
if (parentid == 0)
{
title = "添加省份";
}
else
{
DistrictInfo model = BLL.DistrictBLL.GetModel(parentid);
if (model == null || model.DistId != parentid)
{
Response.Write("<script>alert('参数parentid错误');history.go(-1);</script>");
Response.End();
}
if (model.ParentId == 0)
{
title = "添加城市";
}
else
{
title = "添加(区、县)";
}
}
}
}
private WeatherInfo GetWeatherByDistrict(DistrictInfo District)
{
if (District == null)
{
return null;
}
FormatDistrict(District);
if (District.Nation == Root.Name)
{
if (Root.Childs.ContainsKey(District.AmapCityCode))
{
Node city = Root.Childs[District.AmapCityCode];
if (city.Childs.ContainsKey(District.District))
{
Node district = city.Childs[District.District];
return district.Weather;
}
else
{
return city.Weather;
}
}
else
{
return Root.Weather;
}
}
else
{
return null;
}
}
private void InsertIntoTree(DistrictInfo info, Node root)
{
root.Name = info.Nation;
if (root.Childs == null)
{
root.Childs = new Dictionary<string, Node>();
}
if (!root.Childs.ContainsKey(info.AmapCityCode))
{
root.Childs.Add(info.AmapCityCode, new Node() { Id = info.AmapCityCode, Name = info.City, Parent = root });
}
if (root.Childs[info.AmapCityCode].Childs == null)
{
root.Childs[info.AmapCityCode].Childs = new Dictionary<string, Node>();
}
if (!root.Childs[info.AmapCityCode].Childs.ContainsKey(info.District))
{
root.Childs[info.AmapCityCode].Childs.Add(info.District, new Node() { Id = info.AreaId, Name = info.District, Parent = root.Childs[info.AmapCityCode] });
}
}
private void ReadDistrictData()
{
using (FileStream fs = File.OpenRead(HttpContext.Current.Server.MapPath("~/App_Data/NormalDistrictData.xlsx")))
{
XSSFWorkbook wk = new XSSFWorkbook(fs);
ISheet sheet = wk.GetSheetAt(0);
for (int i = 1; i < sheet.LastRowNum; i++)
{
IRow row = sheet.GetRow(i);
if (row != null)
{
DistrictInfo info = new DistrictInfo();
info.AreaId = row.GetCell(0).ToString();
info.District = row.GetCell(2).ToString();
info.City = row.GetCell(4).ToString();
info.Province = row.GetCell(6).ToString();
info.Nation = row.GetCell(8).ToString();
info.AmapCityCode = row.GetCell(9).ToString();
InsertIntoTree(info, Root);
}
}
}
}
/// <summary>
/// 高德逆地理编码，根据经纬度获取位置描述
/// Post
/// http://restapi.amap.com/v3/geocode/regeo?key=b34d6e34c5ab8bab7ff3075d2a12ca5c&location=113.921076,22.499654&radius=10&extensions=all&coordsys=gps
/// </summary>
/// <param name="lat">纬度</param>
/// <param name="lon">经度</param>
/// <param name="radius">精确度</param>
/// <returns></returns>
private DistrictInfo GetDistrictByGeo(double longitude, double latitude, double radius)
{
///TEMP
///return new DistrictInfo() { AreaId = "101191004", Name = "灌云", District = "连云港", Province = "江苏", Nation = "中国" };
try
{
string url = string.Format("http://restapi.amap.com/v3/geocode/regeo?key={0}&location={1},{2}&radius={3}&extensions=all&coordsys=autonavi", SysConfig.AmapWebApiGeocodeKey, longitude, latitude, radius);
WebRequest request = WebRequest.Create(url);
request.Method = "GET";
var responeStream = request.GetResponse();
StreamReader reader = new StreamReader(responeStream.GetResponseStream());
string jsonStr = reader.ReadToEnd();
JObject jobject = (JObject)JsonConvert.DeserializeObject(jsonStr);
DistrictInfo district = new DistrictInfo();
district.Nation = "中国";
district.Province = jobject["regeocode"]["addressComponent"]["province"].ToString();
district.City = jobject["regeocode"]["addressComponent"]["city"].ToString();
district.AmapCityCode = jobject["regeocode"]["addressComponent"]["citycode"].ToString();
district.District = jobject["regeocode"]["addressComponent"]["district"].ToString();
return district;
}
catch
{
return null;
}
}
