///// <summary> ///// 导入 城市-ID对 ///// </summary> ///// <param name="request"></param> ///// <returns></returns> //public WebApiResult<string> Any(ImportCityIdRequest request) //{ // if (request.City == null || request.Id == null) // return null; // Angels.Application.Data.MySqlHelper mysqlHelper = new Angels.Application.Data.MySqlHelper(Config.GetValue("DataMySql")); // //String ConnectionString = String.Format("server={0};user id={1};password={2};database={3};CharSet=utf8", "localhost", "root", "123456", "webmap"); // //mysqlHelper = new Angels.Application.Data.MySqlHelper(ConnectionString); // try // { // List<MySqlParameter> listParam = new List<MySqlParameter>(); // listParam.Add(new MySqlParameter(@"Id", request.Id)); // listParam.Add(new MySqlParameter(@"Name", request.City)); // listParam.Add(new MySqlParameter(@"pId", request.pId)); // if (request.maptype == 0)//百度 // { // String sqlcommand = "insert into baidu_cityid(baiduId, Name,baidupId) values(@Id, @Name,@pId)"; ; // var a = mysqlHelper.ExecuteDataTable("SELECT * FROM baidu_cityid WHERE Name = " + "'" + request.City + "'"); // if (a.Rows.Count != 0) // { // sqlcommand = "update baidu_cityid SET baiduId=@Id,baidupId=@pId WHERE Name=@Name"; // } // mysqlHelper.ExecuteNonQuery(sqlcommand, listParam.ToArray()); // return new WebApiResult<string>() { success = 1, msg = "更新成功" }; // } // else if (request.maptype == 1)//高德 // { // string sqlcommand = "insert into gaode_cityid(gaodeId, Name,gaodepId) values(@Id, @Name,@pId)"; // var a = mysqlHelper.ExecuteDataTable("SELECT * FROM gaode_cityid WHERE Name = " + "'" + request.City + "'"); // if (a.Rows.Count != 0) // { // sqlcommand = "update gaode_cityid SET gaodeId=@Id,gaodepId=@pId WHERE Name=@Name"; // } // mysqlHelper.ExecuteNonQuery(sqlcommand, listParam.ToArray()); // return new WebApiResult<string>() { success = 1, msg = "更新成功" }; // } // else // return new WebApiResult<string>() { success = 0, msg = "输入参数错误"}; // } // catch (Exception ex) // { // return new WebApiResult<string>() { success = 0, msg = "错误: " + ex.ToString() }; // } //} ///// <summary> ///// 导入 城市-拼音对 ///// </summary> ///// <param name="request"></param> ///// <returns></returns> //public WebApiResult<string> Any(ImportCityNameRequest request) //{ // if (request.City == null || request.Name == null) // return null; // Angels.Application.Data.MySqlHelper mysqlHelper = new Angels.Application.Data.MySqlHelper(Config.GetValue("DataMySql")); // //String ConnectionString = String.Format("server={0};user id={1};password={2};database={3};CharSet=utf8", "localhost", "root", "123456", "webmap"); // //mysqlHelper = new Angels.Application.Data.MySqlHelper(ConnectionString); // try // { // var a = mysqlHelper.ExecuteDataTable("SELECT * FROM mapbar_cityname WHERE City = " + "'" + request.City + "'"); // List<MySqlParameter> listParam = new List<MySqlParameter>(); // listParam.Add(new MySqlParameter(@"City", request.City)); // listParam.Add(new MySqlParameter(@"Name", request.Name)); // if (a.Rows.Count == 0) // { // //插入数据库 // String sqlcommand = "insert into mapbar_cityname(City, Name) values(@City, @Name)"; // mysqlHelper.ExecuteNonQuery(sqlcommand, listParam.ToArray()); // } // else // { // //更新数据库 // String sqlcommand = "update mapbar_cityname SET Name=@Name WHERE City=@City"; // mysqlHelper.ExecuteNonQuery(sqlcommand, listParam.ToArray()); // } // return new WebApiResult<string>() { success = 1, msg = "更新成功" }; // } // catch (Exception ex) // { // return new WebApiResult<string>() { success = 0, msg = "错误: " + ex.ToString() }; // } //} /// <summary> /// 导入城市ID、拼音信息 /// </summary> /// <param name="request"></param> /// <returns></returns> public WebApiResult <string> Any(ImportCityInformRequest request) { if (request.Name == null || request.baiduId == null || request.baidupId == null || request.gaodeId == null || request.pinyin == null) { return new WebApiResult <string>() { success = 0, msg = "参数不全" } } ; Angels.Application.Data.MySqlHelper mysqlHelper = new Angels.Application.Data.MySqlHelper(Config.GetValue("DataMySql")); //String ConnectionString = String.Format("server={0};user id={1};password={2};database={3};CharSet=utf8", "localhost", "root", "123456", "webmap"); //mysqlHelper = new Angels.Application.Data.MySqlHelper(ConnectionString); try { DataTable dt = mysqlHelper.ExecuteDataTable("SELECT * FROM cityinform WHERE Name = " + "'" + request.Name + "'"); List <MySqlParameter> listParam = new List <MySqlParameter>(); listParam.Add(new MySqlParameter(@"Name", request.Name)); listParam.Add(new MySqlParameter(@"baiduId", request.baiduId)); listParam.Add(new MySqlParameter(@"baidupId", request.baidupId)); listParam.Add(new MySqlParameter(@"gaodeId", request.gaodeId)); listParam.Add(new MySqlParameter(@"pinyin", request.pinyin)); if (dt.Rows.Count == 0) { //插入数据库 String sqlcommand = "insert into cityinform(Name, baiduId, baidupId, gaodeId, pinyin) values(@Name, @baiduId, @baidupId, @gaodeId, @pinyin)"; mysqlHelper.ExecuteNonQuery(sqlcommand, listParam.ToArray()); } else { //更新数据库 String sqlcommand = "update cityinform SET baiduId=@baiduId,baidupId=@baidupId,gaodeId=@gaodeId,pinyin=@pinyin WHERE Name=@Name"; mysqlHelper.ExecuteNonQuery(sqlcommand, listParam.ToArray()); } return(new WebApiResult <string>() { success = 1, msg = "更新成功" }); } catch (Exception ex) { return(new WebApiResult <string>() { success = 0, msg = "错误: " + ex.ToString() }); } }
/// <summary> /// 删除城市ID、拼音信息 /// </summary> /// <param name="request"></param> /// <returns></returns> public WebApiResult <string> Any(DeleteCityInformRequest request) { //string[] Ids = request.Ids; try { // foreach (string Id in Ids) // { // if (Id == "0") continue; // Angels.Application.Data.MySqlHelper mysqlHelper = new Angels.Application.Data.MySqlHelper(Config.GetValue("DataMySql")); // //String ConnectionString = String.Format("server={0};user id={1};password={2};database={3};CharSet=utf8", "localhost", "root", "123456", "webmap"); // //mysqlHelper = new Angels.Application.Data.MySqlHelper(ConnectionString); // if (request.type == 0) // { // int a = mysqlHelper.ExecuteNonQuery("DELETE FROM baidu_cityid WHERE baiduId=@Id", new MySqlParameter(@"Id", int.Parse(Id))); // } // else if (request.type == 1) // { // int a = mysqlHelper.ExecuteNonQuery("DELETE FROM gaode_cityid WHERE gaodeId=@Id", new MySqlParameter(@"Id", int.Parse(Id))); // } // else if (request.type == 2) // { // int a = mysqlHelper.ExecuteNonQuery("DELETE FROM mapbar_cityname WHERE City=@Id", new MySqlParameter(@"Id", Id));//城市中文名 // } // else // return new WebApiResult<string>() { success = 0, msg = "输入参数错误" }; // } foreach (string Name in request.Names) { Angels.Application.Data.MySqlHelper mysqlHelper = new Angels.Application.Data.MySqlHelper(Config.GetValue("DataMySql")); //String ConnectionString = String.Format("server={0};user id={1};password={2};database={3};CharSet=utf8", "localhost", "root", "123456", "webmap"); //mysqlHelper = new Angels.Application.Data.MySqlHelper(ConnectionString); int a = mysqlHelper.ExecuteNonQuery("DELETE FROM cityinform WHERE Name=@Name", new MySqlParameter(@"Name", Name)); } return(new WebApiResult <string>() { success = 1, msg = "删除成功" }); } catch (Exception ex) { return(new WebApiResult <string>() { success = 0, msg = "错误: " + ex.ToString() }); } }