/// <summary> /// 门店同步 /// </summary> /// <param name="req"></param> /// <returns></returns> public static dt_GetMd_res GetMd(dt_GetMd_req req) { try { si_GetMd_obService dyn = new si_GetMd_obService(); string reqStr = js.Serialize(req); DateTime timeStart = DateTime.Now; logger.Info("门店同步接口si_GetMd_obService请求信息:" + reqStr); dt_GetMd_res pis = dyn.si_GetMd_ob(req); string resStr = js.Serialize(pis); DateTime timeEnd = DateTime.Now; logger.Info("响应信息" + resStr + "\r\n"); datalog.DataInfo(reqStr, resStr, timeStart, timeEnd, 0, "si_GetMd_obService", "门店同步接口"); return(pis); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// 插入门店 /// </summary> /// <returns></returns> public int InsertStore() { try { dt_GetMd_req req = new dt_GetMd_req(); TVKO[] ko = new TVKO[] { new TVKO() { VKORG = "C004" }, new TVKO() { VKORG = "C024" } }; req.ZTVKO = ko; dt_GetMd_res resStore = WebApiHelp.GetMd(req); JavaScriptSerializer js = new JavaScriptSerializer(); foreach (ZSAL_MD stroeModel in resStore.INFO_MD) { Thread.Sleep(100); //如果门店是激活状态 if (stroeModel.VTWEG != "28" && stroeModel.VTWEG != "11") { int id = _repo.CheckStore(stroeModel.ZMD_ID); if (id < 1) { TenAPI api = null; if (!string.IsNullOrEmpty(stroeModel.STRAS)) { string json = NetHelper.HttpRequest("http://apis.map.qq.com/ws/geocoder/v1/?key=MYVBZ-AO3R3-KVS3G-3OBPF-VNHE5-7VF7M&address=" + stroeModel.STRAS + "", "", "GET", 2000, Encoding.UTF8, "application/json"); if (!json.Contains("查询无结果")) { api = js.Deserialize <TenAPI>(json); if (api.status != 0) { api = null; } } } BCJ_STORES model = new BCJ_STORES() { ADDRESS = stroeModel.STRAS, CITY = stroeModel.CITY_CODE, CITY_CATE = stroeModel.ZCITY_TYPE, NAME = stroeModel.ZMD_MC, POS_CODE = stroeModel.ZMD_ID, KUNNR_SH = stroeModel.ZKUNNR_SH, TEL = stroeModel.TELF1, STORE_TYPE = stroeModel.ZMD_TYPE, LONGITUDE = api == null ? "无" : api.result.location.lng, LATITUDE = api == null ? "无" : api.result.location.lat, STATUS = string.IsNullOrEmpty(stroeModel.ZSTATUS) ? -1 : int.Parse(stroeModel.ZSTATUS) }; _repo.Insert(model); } //更新门店信息 else { BCJ_STORES model = new BCJ_STORES() { ID = id, ADDRESS = stroeModel.STRAS, CITY = stroeModel.CITY_CODE, CITY_CATE = stroeModel.ZCITY_TYPE, NAME = stroeModel.ZMD_MC, POS_CODE = stroeModel.ZMD_ID, KUNNR_SH = stroeModel.ZKUNNR_SH, TEL = stroeModel.TELF1, STATUS = string.IsNullOrEmpty(stroeModel.ZSTATUS) ? -1 : int.Parse(stroeModel.ZSTATUS) }; _repo.Update(model); } } } return(1); } catch (Exception ex) { throw; } }