/// <summary> /// 同步基础数据 /// </summary> /// <returns></returns> public int SyncBaseData() { int res = 0; LogHelper.Info("进入BaseDataService.SyncBaseData"); lock (lockobj) { LogHelper.Info("进入BaseDataService.SyncBaseData => lock"); var now = DateTime.Now; var channel = OpenApiChannelFactory.GetChannel(); var citys = channel.syncCity(); var hospitals = channel.syncHospital("0"); var listProvince = new List <P_PROVINCE>(); var listCity = new List <P_CITY>(); var listHospital = hospitals.result.Select(a => new P_HOSPITAL() { ID = Convert.ToInt32(a.hospitalId), CityId = Convert.ToInt32(a.cityId), GskHospital = string.IsNullOrEmpty(a.gskHospital) ? string.Empty : a.gskHospital, Name = a.hospitalName, FirstLetters = a.firstLetters, Address = a.address, Latitude = a.latitude, Longitude = a.longitude, Type = string.IsNullOrEmpty(a.type) ? string.Empty : a.type, External = a.External, CreateDate = now }).ToList(); foreach (var province in citys.result) { listProvince.Add(new P_PROVINCE() { ID = province.provinceId, Name = province.provinceName, PinYin = province.pinYin, CreateDate = now }); foreach (var city in province.citys) { listCity.Add(new P_CITY() { ID = city.cityId, ProvinceId = province.provinceId, Name = city.cityName, PinYin = city.pinYin, CreateDate = now }); } } res = baseDataDao.SyncBaseData(listProvince, listCity, listHospital); } LogHelper.Info("完成BaseDataService.SyncBaseData"); return(res); }
/// <summary> /// 获取医院数据变量报告接口 /// </summary> /// <returns></returns> public JsonResult SyncHospitalChangedBDS() { var time = DateTime.Now; var channel = OpenApiChannelFactory.GetChannel(); //// XMS 获取医院数据变量报告接口 //var resXMS = channel.SyncHospitalChangedXMS(); // BDS 获取医院数据变量报告接口 var resBDS = channel.SyncHospitalChanged(); return(Json(new { state = 1 })); }
private void button1_Click(object sender, EventArgs e) { var channel = OpenApiChannelFactory.GetChannel(); var endTime = DateTime.Now.ToString("yyyy-MM-dd"); var startTime = DateTime.Now.AddDays(-6).ToString("yyyy-MM-dd"); var report = channel.GetReport(startTime, endTime, "1"); var openApiChannel = OpenApiChannelFactory.GetChannel(); var res = openApiChannel.GetReport("2017-05-18", "2017-05-24", "0"); var appId = "1"; var secret = "Z3NrdGVzdA=="; //var little = ; var rel = little.getToken(appId, secret); //var rel0 = little.syncCity(rel.result.token, secret); //var rel2 = little.syncHospital(rel.result.token, secret, "0"); //var rel3 = little.queryRes(rel.result.token, secret, rel2.result[0].hospitalId, rel2.result[0].address, "0", "0"); //var rel4 = little.queryResFood(rel.result.token, secret, rel3.result[1].resId); //var foodlist = new FoodRequest[] //{ // new FoodRequest() // { // foodId = rel4.result.menuList[0].foods[2].foodId, // foodName = string.Empty, // count = "100" // } //}; //var rel5 = little.calculateFee(rel.result.token, secret, rel2.result[0].hospitalId, rel3.result[1].resId, foodlist); //var ID = Guid.NewGuid(); //var rel6 = little.createOrder(rel.result.token, secret, ID.ToString(), string.Empty, "0", "2017-04-20 13:00:00", // rel5.result.foodFee.ToString(), rel5.result.packageFee.ToString(), rel5.result.sendFee.ToString(), "0", rel5.result.allPrice.ToString(), // "上海途径信息技术有限公司大连分公司", "2017-04-19 13:54:00", // string.Empty, "xyz", "5", "100000", "1", "15641190204", "高新街腾讯大厦", rel3.result[1].resId, "", "0", "0", rel2.result[0].hospitalId, // "cn0000001", "500", "abcdefg", "xaujqj", foodlist); //var rel7 = little.cancleOrder(rel.result.token, secret, rel6.result.xmsOrderId, "xasdqwqwe"); //var rel8 = little.finishOrder(rel.result.token, secret, rel6.result.xmsOrderId, "0", "xxxxxxx"); var rel9 = little.OrderQuery(rel.result.token, secret, "2017-05-18", "2017-05-24", "0"); var rel10 = little.GetReport(rel.result.token, secret, "2017-05-18", "2017-05-24", "0"); var client = OpenApiChannelFactory.GetChannel(); //var _rel = client.calculateFee(rel2.result[0].hospitalId, rel3.result[1].resId, foodlist); }
private void button5_Click(object sender, EventArgs e) { var openApiChannel = OpenApiChannelFactory.GetChannel(); var res = openApiChannel.GetReport("2017-05-18", "2017-05-24", "0"); var appId = "1"; var secret = "Z3NrdGVzdA=="; //var little = ; var rel = little.getToken(appId, secret); }
public JsonResult ChoosedRestaurant(string resId) { var openApiChannel = OpenApiChannelFactory.GetChannel(); var res = openApiChannel.queryResFood(resId); if (res.code == "200") { WeChatOrderInfo.foods = new P_Food() { resId = resId, resName = res.result.resName, resAddress = res.result.address, resTel = res.result.resTel, resLogo = res.result.imagePath }; return(Json(new { state = 1 })); } return(Json(new { state = 0, txt = "网络接口错误,操作失败!", errCode = 9012 })); }
private void button4_Click(object sender, EventArgs e) { var openApiChannel = OpenApiChannelFactory.GetChannel(); var menu = openApiChannel.queryResFood("Delivery0028084"); var oponapiChannel = OpenApiChannelFactory.GetChannel(); var xmlres = oponapiChannel.orderDeliveryFailure("2017052015522374007", "饿死了"); var channel = MealAdminApiClient.EvaluateClientChannelFactory.GetChannel(); var res = channel.LoadByResId("Delivery0027612"); var channel1 = MealAdminApiClient.OrderApiClientChannelFactory.GetChannel(); Guid id = new Guid("E2B15FDA-8700-402A-9F0D-BCF5D3FDA998"); var res1 = channel1.MMCoEResult(id, 3, ""); }
/// <summary> /// 获取所有的可送餐列表 /// </summary> /// <param name="provice"></param> /// <param name="city"></param> /// <returns></returns> public JsonResult SyncHospitalRes(string provice, string city) { // 获取当前时间 var time = DateTime.Now; var channel = OpenApiChannelFactory.GetChannel(); // XMS 获取的可送餐列表 var res = channel.SyncHospitalRes(provice, city); // BDS 获取的可送餐列表 var resBDS = channel.SyncHospitalResBDS(provice, city); // 整理数据 var resList = new List <GetSyncHospitalResResult>(); if (res.result != null && res.result.Count > 0) { resList = res.result; } var resBDSList = new List <GetSyncHospitalResResult>(); if (resBDS.result != null && resBDS.result.Count > 0) { resBDSList = resBDS.result; } var hospitalRangeList = new List <P_HOSPITAL_RANGE_RESTAURANT>(); var hospitalRangeCount = new List <P_HOSPITAL_RANGE_RESTAURANTCOUNT>(); // 整理XMS返回的信息 foreach (var oneHospitalRange in resList) { var ID = Guid.NewGuid(); var dataSources = "XMS"; var gskHospitalTemp = oneHospitalRange.gskHospital; var resCount = oneHospitalRange.resCount; hospitalRangeCount.Add(new P_HOSPITAL_RANGE_RESTAURANTCOUNT { ID = Guid.NewGuid(), DataSources = dataSources, GskHospital = gskHospitalTemp, TotalCount = resCount.totalCount, BreakfastCount = resCount.breakfastCount, LunchCount = resCount.lunchCount, TeaCount = resCount.teaCount, CreateDate = time }); foreach (var oneRes in oneHospitalRange.resList) { hospitalRangeList.Add(new P_HOSPITAL_RANGE_RESTAURANT { ID = Guid.NewGuid(), DataSources = dataSources, GskHospital = gskHospitalTemp, ResId = oneRes.resId, ResName = oneRes.resName, CreateDate = time }); } } // 整理BDS返回的信息 foreach (var oneHospitalRange in resBDSList) { var ID = Guid.NewGuid(); var dataSources = "BDS"; var gskHospitalTemp = oneHospitalRange.gskHospital; var resCount = oneHospitalRange.resCount; hospitalRangeCount.Add(new P_HOSPITAL_RANGE_RESTAURANTCOUNT { ID = Guid.NewGuid(), DataSources = dataSources, GskHospital = gskHospitalTemp, TotalCount = resCount.totalCount, BreakfastCount = resCount.breakfastCount, LunchCount = resCount.lunchCount, TeaCount = resCount.teaCount, CreateDate = time }); foreach (var oneRes in oneHospitalRange.resList) { hospitalRangeList.Add(new P_HOSPITAL_RANGE_RESTAURANT { ID = Guid.NewGuid(), DataSources = dataSources, GskHospital = gskHospitalTemp, ResId = oneRes.resId, ResName = oneRes.resName, CreateDate = time }); } } // 写入数据 int succCount = restaurantService.ImportRangeRestaurant(hospitalRangeList, hospitalRangeCount); return(Json(new { state = 1, succCount })); }
/// <summary> /// 获取餐厅列表 /// </summary> /// <param name="provice"></param> /// <param name="city"></param> /// <returns></returns> public JsonResult SyncRes(string provice, string city) { var channel = OpenApiChannelFactory.GetChannel(); // 获取当前时间 var time = DateTime.Now; // XMS 获取的餐厅 var res = channel.SyncRes(provice, city); // BDS 获取的餐厅 var resBDS = channel.SyncResBDS(provice, city); var totleCount = 0; var resList = new List <GetSyncResResult>(); if (res.result != null && res.result.Count > 0) { totleCount = res.result.Count; resList = res.result; } var resBDSList = new List <GetSyncResResult>(); if (resBDS.result != null && resBDS.result.Count > 0) { totleCount = totleCount + resBDS.result.Count; resBDSList = resBDS.result; } var restaurantList = new List <P_RESTAURANT_LIST>(); // 整理XMS返回的信息 foreach (var oneRes in resList) { restaurantList.Add(new P_RESTAURANT_LIST { ID = Guid.NewGuid(), DataSources = "XMS", ResId = oneRes.resId, ResName = oneRes.resName, ResType = oneRes.resType, Province = oneRes.province, City = oneRes.city, CreateDate = time }); } // 整理BDS返回的信息 foreach (var oneRes in resBDSList) { restaurantList.Add(new P_RESTAURANT_LIST { ID = Guid.NewGuid(), DataSources = "BDS", ResId = oneRes.resId, ResName = oneRes.resName, ResType = oneRes.resType, Province = oneRes.province, City = oneRes.city, CreateDate = time }); } // 放入数据 int insCount = restaurantService.Import(restaurantList); return(Json(new { state = 1, successCount = insCount, totleCount })); }
static void Main(string[] args) { var now = DateTime.Now; var channel = OpenApiChannelFactory.GetChannel(); var connString = System.Configuration.ConfigurationManager.ConnectionStrings["db1"].ConnectionString; var citys = channel.syncCity(); var hospitals = channel.syncHospital("0"); var rel = citys.result; using (var connection = new SqlConnection(connString)) { connection.Open(); var tran = connection.BeginTransaction(); string sqlDelProvince = "delete P_PROVINCE"; SqlCommand comDelProvince = new SqlCommand(sqlDelProvince, connection); comDelProvince.Transaction = tran; comDelProvince.ExecuteNonQuery(); string sqlDelCity = "delete P_CITY"; SqlCommand comDelCity = new SqlCommand(sqlDelCity, connection); comDelCity.Transaction = tran; comDelCity.ExecuteNonQuery(); string sqlDelHospital = "delete P_HOSPITAL"; SqlCommand comDelHospital = new SqlCommand(sqlDelHospital, connection); comDelHospital.Transaction = tran; comDelHospital.ExecuteNonQuery(); foreach (var province in rel) { string sqlProvince = "INSERT INTO P_PROVINCE VALUES(@ID,@Name,@PinYin,@CreateDate)"; SqlCommand commandProvince = new SqlCommand(sqlProvince, connection); commandProvince.Transaction = tran; commandProvince.Parameters.AddRange(new SqlParameter[] { new SqlParameter("@ID", province.provinceId), new SqlParameter("@Name", province.provinceName), new SqlParameter("@PinYin", province.pinYin), new SqlParameter("@CreateDate", now) }); commandProvince.ExecuteNonQuery(); foreach (var city in province.citys) { string sqlCity = "INSERT INTO P_CITY VALUES(@ID,@ProvinceId,@Name,@PinYin,@CreateDate)"; SqlCommand commandCity = new SqlCommand(sqlCity, connection); commandCity.Transaction = tran; commandCity.Parameters.AddRange(new SqlParameter[] { new SqlParameter("@ID", city.cityId), new SqlParameter("@ProvinceId", province.provinceId), new SqlParameter("@Name", city.cityName), new SqlParameter("@PinYin", city.pinYin), new SqlParameter("@CreateDate", now) }); commandCity.ExecuteNonQuery(); } } foreach (var hospital in hospitals.result) { string sqlHospital = "INSERT INTO P_HOSPITAL(ID,CityId,GskHospital,Name,FirstLetters,Address,Latitude,Longitude,Type,[External],CreateDate) VALUES(@ID,@CityId,@GskHospital,@Name,@FirstLetters,@Address,@Latitude,@Longitude,@Type,@External,@CreateDate)"; SqlCommand commandHospital = new SqlCommand(sqlHospital, connection); commandHospital.Transaction = tran; var gskHospital = string.IsNullOrEmpty(hospital.gskHospital) ? "" : hospital.gskHospital; var type = string.IsNullOrEmpty(hospital.type) ? "" : hospital.type; commandHospital.Parameters.AddRange(new SqlParameter[] { new SqlParameter("@ID", hospital.hospitalId), new SqlParameter("@CityId", hospital.cityId), new SqlParameter("@GskHospital", gskHospital), new SqlParameter("@Name", hospital.hospitalName), new SqlParameter("@FirstLetters", hospital.firstLetters), new SqlParameter("@Address", hospital.address), new SqlParameter("@Latitude", hospital.latitude), new SqlParameter("@Longitude", hospital.longitude), new SqlParameter("@Type", type), new SqlParameter("@External", hospital.External), new SqlParameter("@CreateDate", now) }); commandHospital.ExecuteNonQuery(); } tran.Commit(); } }