/// <summary> /// 修改公司简介 /// </summary> /// <param name="companyContent">公司内容</param> /// <returns></returns> public string UpdateCompanyIntroduce(string companyContent) { string resultStr = ""; BLL.Common.Logger.Error("UpdateCompanyIntroduce方法修改公司简介接受到的参数companyContent:" + companyContent); JavaScriptSerializer js = new JavaScriptSerializer(); var info = js.Deserialize <Dictionary <string, object> >(companyContent); if (!string.IsNullOrEmpty(info["CompanyID"].ToString())) { string companyIDStr = info["CompanyID"].ToString(); string companyIntroduceStr = info["Introduce"].ToString(); CompanysEL companysEL = new CompanysEL(); companysEL.ID = long.Parse(companyIDStr); companysEL.Introduce = companyIntroduceStr; int ra; long updateIntro = companysEL.ExecNonQuery(3, out ra); BLL.Common.Logger.Error("UpdateCompanyIntroduce方法修改公司简介结果(大于0成功):" + updateIntro); if (ra > 0) { resultStr = "success"; } else { resultStr = "error"; } } return(resultStr); }
/// <summary> /// 添加公司或获取公司ID /// </summary> /// <param name="companyName">公司名称</param> /// <returns>返回值是公司ID</returns> public string AddOrSelectCompany(string companyName) { Common.Logger.Error("AddOrSelectCompany方法获取到的参数:" + companyName); string companyID = ""; //先查询公司表中是否有此公司 CompanysEL companyEL = new CompanysEL(); companyEL.CompanyName = companyName; companyEL.ExecuteEL(21); Common.Logger.Error("AddOrSelectCompany方法查询公司表结果:" + companyEL.ID); if (companyEL.ID > 0) { //如果数据库中有此公司,则返回公司ID companyID = companyEL.ID.ToString(); Common.Logger.Error("AddOrSelectCompany方法调用数据库中的" + companyName + "的ID为:" + companyID); } else { //调用天眼查接口,查询公司简介 string url_GetBriefIntroduction = "https://way.jd.com/qichacha/GetBriefIntroduction?key=736be44d18e011e6b4fb1051721d3b62&companyName=" + companyName + "&dtype=json&appkey=6831311b16156e8775fff0364cb69d67"; string getIntroduceResult = GetResponse(url_GetBriefIntroduction); HF.Cloud.BLL.Common.Logger.Error("第一次天眼查查询公司简介GetBriefIntroduction接口结果:" + getIntroduceResult); JObject objIntro = JObject.Parse(getIntroduceResult); //公司头像 string companyIcon = ""; //公司简介 string introduce = companyName; try { companyIcon = objIntro["result"]["Result"]["Logo"].ToString(); Common.Logger.Error("AddOrSelectCompany方法查询公司头像结果:" + objIntro["result"]["Result"]["Logo"].ToString()); } catch { Common.Logger.Error("AddOrSelectCompany方法该公司没有logo:"); } try { //删除掉特殊字符 string contentStr = objIntro["result"]["Result"]["Content"].ToString(); string contentStr_Change = contentStr.Replace("\"", ""); introduce = Regex.Replace(contentStr_Change, @"[<>abcdefghijklmnopqrstuvwxyzABCDEFJHIJKLMNOPQRSTUVWXYZ/\=]", string.Empty, RegexOptions.Compiled); Common.Logger.Error("AddOrSelectCompany方法首次查询公司简介结果:" + objIntro["result"]["Result"]["Content"].ToString()); } catch { //说明此接口没有公司简介或公司简介为空,那么调用另外一个接口 string url_detail_info = "https://way.jd.com/jindidata/detail_info?name=" + companyName + "&appkey=6831311b16156e8775fff0364cb69d67"; string getdetail_info = GetResponse(url_detail_info); Common.Logger.Error("第二次天眼查,公司简介没查到然后查询公司工商信息getdetail_info接口结果:" + url_detail_info); JObject obj_detail_info = JObject.Parse(getdetail_info); try { //删除掉特殊字符 string businessScopeStr = obj_detail_info["result"]["result"]["baseInfo"]["businessScope"].ToString(); string businessScopeStr_Change = businessScopeStr.Replace("\"", ""); introduce = Regex.Replace(businessScopeStr_Change, @"[<>abcdefghijklmnopqrstuvwxyzABCDEFJHIJKLMNOPQRSTUVWXYZ/\=]", string.Empty, RegexOptions.Compiled); Common.Logger.Error("第二次查询公司简介结果:" + obj_detail_info["result"]["result"]["baseInfo"]["businessScope"].ToString()); } catch { //如果调用2个接口都查不到公司简介,内容的话就直接显示公司名称 introduce = companyName; } } companyEL.CompanyIcon = companyIcon; companyEL.Introduce = introduce; companyEL.CreateTime = DateTime.Now.ToString(); companyEL.Valid = 1; int outValue; long addCompanyRes = companyEL.ExecNonQuery(1, out outValue); Common.Logger.Error("AddOrSelectCompany方法添加公司结果(大于0说明成功):" + addCompanyRes); if (addCompanyRes > 0) { companyID = addCompanyRes.ToString(); } else { companyID = "0"; } } return(companyID); }