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