/// <summary> ///根据用户微信号判断 其顾问是不是可以咨询 /// </summary> /// <param name="openid"></param> /// <param name="p"></param> /// <param name="comid"></param> /// <returns></returns> public int IsCanZixun(string openid, int comid) { B2b_company_manageuser manageruser = new B2bCompanyManagerUserData().GetGuwenByVipweixin(openid, comid); if (manageruser == null) { return(0); } else { string Workdays = manageruser.Workdays; //判断是否在工作日内,1为在,0为不在 int WorkdaysView = new B2bCrmData().WorkDay(Workdays); //判断顾问是否绑定了微信 0未绑定;1已绑定 int isbindweixin = 0; var crmmodel = new B2bCrmData().GetB2bCrmByPhone(manageruser.Com_id, manageruser.Tel); if (crmmodel != null) { if (crmmodel.Weixin != "") { isbindweixin = 1; } else { isbindweixin = 0; } } //顾问已经绑定微信并且在工作日内,则可以咨询 if (WorkdaysView == 1 && isbindweixin == 1) { return(1); } else { return(0); } } }
//计算渠道人/渠道人单位/渠道人公司 距离会员的距离 public double PeopleCoordinates(string openid, int channelcompanyid, int comid = 0, string usern = "", string usere = "") { var projdistance = ""; //根据会员微信获取顾问坐标;没有计算渠道单位/渠道公司的坐标 B2b_crm_location crmlocation = new B2bCrmData().GetGuwenLocationByVipweixin(openid, comid); if (crmlocation != null) { //纬度+经度 projdistance = crmlocation.Longitude + "," + crmlocation.Latitude; } else { if (channelcompanyid != 0) { projdistance = GetChannelDistanceByid(channelcompanyid); } else { if (comid != 0) { B2bCompanyData comdata = new B2bCompanyData(); var datainfo = B2bCompanyData.GetAllComMsg(comid); if (datainfo != null) { projdistance = datainfo.B2bcompanyinfo.Coordinate; } } } } if (projdistance == "") { return(0); } var crmdistance = GetB2bCrmDistanceByid(openid); var n1 = ""; var e1 = ""; var n2 = ""; var e2 = ""; if (projdistance != "") { var locatearr = projdistance.Split(','); if (locatearr.Length >= 2) { n1 = locatearr[1]; e1 = locatearr[0]; } if (usern != "" && usere != "" && usern != "0" && usere != "0") { n2 = usern; e2 = usere; } else { var crmlocatearr = crmdistance.Split(','); if (crmlocatearr.Length >= 2) { n2 = crmlocatearr[1]; e2 = crmlocatearr[0]; } } if (n1 == "" || n2 == "" || e1 == "" || e2 == "") { return(0); } using (var helper = new SqlHelper()) { var crm = new InternalB2bCrm(helper).CalculateTheCoordinates(n1, e1, n2, e2); return(crm); } } return(0); }