/// <summary> /// Update into XMConsultation /// </summary> /// <param name="xmconsultation">XMConsultation</param> public void UpdateXMConsultation(XMConsultation xmconsultation) { if (xmconsultation == null) { return; } if (this._context.IsAttached(xmconsultation)) { this._context.XMConsultations.Attach(xmconsultation); } this._context.SaveChanges(); }
/// <summary> /// Insert into XMConsultation /// </summary> /// <param name="xmconsultation">XMConsultation</param> public void InsertXMConsultation(XMConsultation xmconsultation) { if (xmconsultation == null) { return; } if (!this._context.IsAttached(xmconsultation)) { this._context.XMConsultations.AddObject(xmconsultation); } this._context.SaveChanges(); }
public void getSessionList(DateTime start_date, DateTime end_date, List <XMOrderInfoApp> XMOrderInfoAppList) { try { var XMConsultationList = new List <XMConsultation>(); foreach (var elem in XMOrderInfoAppList) { JdSdk.DefaultJdClient client = new DefaultJdClient("http://gw.api.360buy.com/routerjson", elem.AppKey, elem.AppSecret); JdSdk.Request.JingdongImPopSessionlistGetRequest request = new JdSdk.Request.JingdongImPopSessionlistGetRequest(); request.StartTime = start_date; request.EndTime = end_date; request.AddedParam.Add("page", 1); request.AddedParam.Add("pageSize", 50); JdSdk.Response.JingdongImPopSessionlistGetResponse response = client.Execute(request, elem.AccessToken); var body = JsonConvert.DeserializeObject <JingdongImPopSessionlistGetResponse>(response.Body); //首次默认返回50条 var totalrow = body.jingdong_im_pop_sessionlist_get_responce.ChatSessionPage.totalRecord; //总行数 if (totalrow > 50) { JdSdk.Request.JingdongImPopSessionlistGetRequest request1 = new JdSdk.Request.JingdongImPopSessionlistGetRequest(); request1.StartTime = start_date; request1.EndTime = end_date; request1.AddedParam.Add("page", 2); request1.AddedParam.Add("pageSize", 50); JdSdk.Response.JingdongImPopSessionlistGetResponse response1 = client.Execute(request, elem.AccessToken); var body1 = JsonConvert.DeserializeObject <JingdongImPopSessionlistGetResponse>(response1.Body);//首次默认返回50条 } foreach (var ele in body.jingdong_im_pop_sessionlist_get_responce.ChatSessionPage.chatSessionList) { var XMConsultationEntity = new XMConsultation(); XMConsultationEntity.CustomerID = ele.customer; XMConsultationEntity.NickId = elem.NickId; XMConsultationEntity.PlatformTypeId = elem.PlatformTypeId; XMConsultationEntity.ReceptionDate = Convert.ToDateTime(ele.replyTime); XMConsultationEntity.ManufacturersCode = ele.skuId.ToString();//暂时存储为商品ID XMConsultationList.Add(XMConsultationEntity); }//获取客户旺旺信息 } } catch (Exception ex) { throw new Exception(ex.Message); } }