public string execute(string request) { //1201|31.118725|121.376808|12312aasdas12312|IMEI|7a31f99279327f8b75506acbf0503973 string[] req = request.Split('|'); var sign = EncodingUtil.GetMd5(req[1] + req[2] + "aidaijia", "utf-8"); if (sign.ToLower() == req[5].ToLower()) { T_ParterEntity parter = new T_PartyDal().GetParterModelBySign(req[3].ToLower()); if (parter != null) { string lat = req[1].Trim(); string lng = req[2].Trim(); if (parter.Id == 11)//判断是博泰,对坐标进行转换 { ChangeCoords.ChangeCoordinate(ref lat, ref lng, 3, 5); } int countsum = new T_PDLoginLogDal().GetcountBysign(req[3].ToLower()); //计算使用次数 if (parter.Daycount > countsum) { //添加 double latNear = Convert.ToDouble(req[1]); double lngNear = Convert.ToDouble(req[2]); CoordinateHelper.BaiduToScott(ref lngNear, ref latNear); req[1] = latNear.ToString(); req[2] = lngNear.ToString(); List<sjinfo> users = new D_DriverInfoDal().GetNewUserByLatlng(req[1], req[2],parter.Sign); if (users.Count != 0) { //添加数据 T_ParterDyLog TPL = new T_ParterDyLog(); TPL.sign = req[3].ToLower(); TPL.lat = lat; TPL.lng = lng; TPL.imei = req[4]; TPL.addtime = DateTime.Now; //1:获取司机2:上传通话3:上传预约 TPL.typeid = 1; new T_ParterDyLogDal().AddParterDyLog(TPL); } return JsonConvert.SerializeObject(users); } else { throw new Exception("当天次数已经使用完毕!"); } } else { throw new Exception("商户标识错误"); } } else { throw new Exception("签名错误。"); } }
public string execute(string request) { // 1205|12312aasdas12312|上海| IMEI |7a31f99279327f8b75506acbf0503973 string[] req = request.Split('|'); var sign = EncodingUtil.GetMd5(req[2] + "aidaijia", "utf-8"); if (sign.ToLower() == req[4].ToLower()) { T_ParterEntity parter = new T_PartyDal().GetParterModelBySign(req[1].ToLower()); if (parter != null) { int countsum = new T_ParterDyLogDal().GetcountBysign(req[1].ToLower()); //计算使用次数 if (parter.Daycount > countsum) { //添加数据 T_ParterDyLog TPL = new T_ParterDyLog(); TPL.sign = req[1].ToLower(); TPL.lat = "0"; TPL.lng = "0"; TPL.imei = req[3]; TPL.addtime = DateTime.Now; //1:获取司机2:上传通话3:上传预约4:获取评价5:获取城市信息 TPL.typeid = 5; new T_ParterDyLogDal().AddParterDyLog(TPL); ChengShiModel cs = new D_CityPriceDal().GetChengShiInfo(req[2].ToLower()); if (cs.Name != null) { return JsonConvert.SerializeObject(cs); } else { IList<ChengShiName> csn = new D_CityPriceDal().GetChengShiName(req[2].ToLower()); return JsonConvert.SerializeObject(csn); } } else { throw new Exception("当天次数已经使用完毕!"); } } else { throw new Exception("商户标识错误"); } } else { throw new Exception("签名错误。"); } }
public bool AddParterDyLog(T_ParterDyLog model) { AdjDBObject adjDbObject = new AdjDBObject(); bool isok = true; try { adjDbObject.GetStoredProcCommand("sp3_T_ParterDyLog_i"); adjDbObject.AddOutParameter("@id", DbType.Int32, 4); adjDbObject.AddInParameter("@sign", DbType.String, model.sign); adjDbObject.AddInParameter("@typeid", DbType.Int32, model.typeid); adjDbObject.AddInParameter("@imei", DbType.String, model.imei); adjDbObject.AddInParameter("@lat", DbType.String, model.lat); adjDbObject.AddInParameter("@lng", DbType.String, model.lng); adjDbObject.AddInParameter("@addtime", DbType.DateTime, model.addtime); adjDbObject.Execute(); } catch (Exception ex) { isok = false; } return isok; }
public string execute(string request) { // 1207|12312aasdas12312|ucode| IMEI |7a31f99279327f8b75506acbf0503973 string[] req = request.Split('|'); var sign = EncodingUtil.GetMd5(req[2] + "aidaijia", "utf-8"); if (sign.ToLower() == req[4].ToLower()) { T_ParterEntity parter = new T_PartyDal().GetParterModelBySign(req[1].ToLower()); if (parter != null) { int countsum = new T_PDLoginLogDal().GetcountBysign(req[1].ToLower()); //计算使用次数 if (parter.Daycount > countsum) { //添加数据 T_ParterDyLog TPL = new T_ParterDyLog(); TPL.sign = req[1].ToLower(); TPL.lat = "0"; TPL.lng = "0"; TPL.imei = req[3]; TPL.addtime = DateTime.Now; //1:获取司机2:上传通话3:上传预约4:获取评价 TPL.typeid = 4; new T_ParterDyLogDal().AddParterDyLog(TPL); List<SjComment> tdpl = new D_DriverCommentDal().GetPingLuns(req[2]); List<SjComment> tdpl2 = new List<SjComment>(); if (tdpl != null) { for (int i = 0; i < tdpl.Count; i++) { SjComment temp = new SjComment(); temp.Create_time = tdpl[i].Create_time; if (tdpl[i].Cellphone.Length > 8) // Regex.IsMatch(tdpl[i].Cellphone, "^1[3-9]{1}[0-9*]{9}") temp.Cellphone = tdpl[i].Cellphone.Substring(0, 4) + "****" + tdpl[i].Cellphone.Substring(8); else temp.Cellphone = "1000****000"; //电话号码长度不匹配处理 temp.Comment = tdpl[i].Comment; temp.CustomerName = tdpl[i].CustomerName; temp.Evaluate = tdpl[i].Evaluate; temp.Ucode = tdpl[i].Ucode; tdpl2.Add(temp); } } return JsonConvert.SerializeObject(tdpl2); } else { throw new Exception("当天次数已经使用完毕!"); } } else { throw new Exception("商户标识错误"); } } else { throw new Exception("签名错误。"); } }
public string execute(string request) { //1206|1姓名|2客户手机号|3地址|4司机工号|5lat|6lng|7from|8sign|9IMEI|10MD5串 string result = "0"; string[] req = request.Split('|'); var sign = EncodingUtil.GetMd5(req[2] + "aidaijia", "utf-8"); if (sign.ToLower() == req[10].ToLower()) { //判断T_ClentInfo是否有此手机号相关信息 //如果用户不存在,创建一个新用户 CustomerInfoEntity cinfo = new D_CustomerInfoDal().GetClientInfoByPhone(req[2].Trim()); string cusid = string.Empty; int CustomerType = 1; int AccountType = 2; T_ParterEntity parter = new T_PartyDal().GetParterModelBySign(req[8].ToLower()); if (parter != null) { #region 用户不存在则创建 if (cinfo == null) { int clentnum = new D_CustomerInfoDal().SelectSeqClent(); if (clentnum != 0) { string num = string.Empty; for (int i = 0; i < 8 - clentnum.ToString().Length; i++) { num += @"0"; } num = "U" + num + clentnum; cusid = num; CustomerInfoEntity customerEn = new CustomerInfoEntity() { AccountType = 2, Amount = 0, BusinessmanId = 0, Cellphone = req[2].Trim(), ParentPhone = req[2].Trim(), CustomerId = num, CustomerName = req[1].Trim(), CustomerType = 1, Email = string.Empty, HomeAddress = string.Empty, IsNewCustomer = true, LastAppointmentTime = null, LastCalledAddress = string.Empty, RecommendCode = new D_CustomerInfoDal().GenerateCustomerRecommendCode( new D_CustomerInfoDal().SelectSeqClent()), RegisterFrom = 5, //第三方API RegisterVersion = "" }; bool isture = new D_CustomerInfoDal().AddCustomerInfo(customerEn); if (!isture) { return "0"; } } else { return "0"; } } else { cusid = cinfo.CustomerId; CustomerType = cinfo.CustomerType; AccountType = cinfo.AccountType; } #endregion #region 创建指定司机派单信息 DriverInfoEntity driverInfo = new D_DriverInfoDal().GetDriverInfoByUcode(req[4].Trim()); if (driverInfo == null) { throw new Exception("指定司机不存在!"); } if (driverInfo.Online == 0) { throw new Exception("该司机已经下线,不能接受您指派的任务!"); } else if (driverInfo.OnService == 1 || driverInfo.OnDOService == 1) { throw new Exception("该司机已经在服务中了,不能接受您指派的任务!"); } else { //直接派单 string distributeOrderId = new DistributeOrderInfoDAL().GenerateDistributeOrderId(new DistributeOrderInfoDAL().SelectSeqOrder()); string lat = req[5].Trim(); string lng = req[6].Trim(); if (parter.Id == 11)//判断是博泰,对坐标进行转换 { ChangeCoords.ChangeCoordinate(ref lat, ref lng, 3, 5); } DistributeOrderInfoEntity model = new DistributeOrderInfoEntity() { Address = req[3].Trim(), AppointOrderId = null, BusinessType = 10, //10酒后代驾 Cellphone = req[2].Trim(), //客户手机号 CustomerId = cusid, CustomerName = req[1].Trim(), CustomerType = CustomerType, AccountType = AccountType, AppointmentTime = DateTime.Now, DistributeOrderId = distributeOrderId, DistributeUser = cusid, DistributeUserType = 3, Fromcellphone = req[2].Trim(), Lat = float.Parse(lat), Lng = float.Parse(lng), OrderFrom = 5,//由8改为5 OrderId = null, OrderType = 1, Status = 11, Create_user = "******", Create_time = DateTime.Now, Remark = "", Ucode = req[4].Trim(), PartyId = parter.Id }; bool istrue = new DistributeOrderInfoDAL().AddDistributeOrderInfo(model); //修改派单状态:派单中 bool isupdate = new DistributeOrderInfoDAL().UpdateOnDoService(1, req[4].Trim()); DistributeOrderDetailEntity detail = new DistributeOrderDetailEntity() { DistributeOrderId = distributeOrderId, Status = 0, Ucode = req[4].Trim(), Create_user = "******" }; bool OrderDetail = new D_DistributeOrderDetailDal().CreateDistributeOrderDetail(detail); DistributeOrderStatusChangeLogEntity log = new DistributeOrderStatusChangeLogEntity() { DistributeOrderId = distributeOrderId, Status = 11, StatusText = "派单已由第三方合作商接口分配给指定司机工号" + req[4].Trim(), Create_user = "******" }; bool OrderStatusChangeLog = new D_DistributeOrderStatusChangeLogDal().CreateDistributeOrderStatusChangeLog(log); if (!istrue || !isupdate) { return "0"; } else { //添加数据 T_ParterDyLog tpl = new T_ParterDyLog(); tpl.sign = req[8]; tpl.lat = "0"; tpl.lng = "0"; tpl.imei = req[9]; tpl.addtime = DateTime.Now; //1:获取司机2:上传通话3:上传预约 tpl.typeid = 3; new T_ParterDyLogDal().AddParterDyLog(tpl); result = "1"; } } #endregion } else { throw new Exception("商户标识错误。"); } } else { throw new Exception("签名错误。"); } return result; }
public string execute(string request) { // 1204|12312aasdas12312|uid| IMEI |7a31f99279327f8b75506acbf0503973 string[] req = request.Split('|'); var sign = EncodingUtil.GetMd5(req[2] + "aidaijia", "utf-8"); if (sign.ToLower() == req[4].ToLower()) { #region old代码 //T_Parter parter = new ParterDal().GetParterModelBySign(req[1].ToLower()); //if (parter != null) //{ // int countsum = new ParterDyLogDal().GetcountBysign(req[1].ToLower()); // //计算使用次数 // if (parter.daycount > countsum) // { // //添加数据 // T_ParterDyLog TPL = new T_ParterDyLog(); // TPL.sign = req[1].ToLower(); // TPL.lat = "0"; // TPL.lng = "0"; // TPL.imei = req[3]; // TPL.addtime = DateTime.Now; // //1:获取司机2:上传通话3:上传预约4:获取评价 // TPL.typeid = 4; // new ParterDyLogDal().AddParterDyLog(TPL); // List<Pinglun> tdpl = new PingJiaDal().GetPingLuns(req[2]); // return JsonConvert.SerializeObject(tdpl); // } // else // { // throw new Exception("当天次数已经使用完毕!"); // } //} //else //{ // throw new Exception("商户标识错误"); //} #endregion T_ParterEntity parter = new T_PartyDal().GetParterModelBySign(req[1].ToLower()); if (parter != null) { int countsum = new T_PDLoginLogDal().GetcountBysign(req[1].ToLower()); //计算使用次数 if (parter.Daycount > countsum) { //添加数据 T_ParterDyLog TPL = new T_ParterDyLog(); TPL.sign = req[1].ToLower(); TPL.lat = "0"; TPL.lng = "0"; TPL.imei = req[3]; TPL.addtime = DateTime.Now; //1:获取司机2:上传通话3:上传预约4:获取评价 TPL.typeid = 4; new T_ParterDyLogDal().AddParterDyLog(TPL); List<Pinglun> tdpl2 = new List<Pinglun>(); string sjucode = new D_DriverInfoDal().GetUcodeById(req[2]); if (sjucode != "") { List<SjComment> tdpl = new D_DriverCommentDal().GetPingLuns(sjucode); if (tdpl != null) { for (int i = 0; i < tdpl.Count; i++) { Pinglun temp = new Pinglun(); temp.addtime = Convert.ToDateTime(tdpl[i].Create_time); temp.Info = tdpl[i].Comment; temp.name = tdpl[i].CustomerName; if (tdpl[i].Evaluate == 3) { temp.plstate = 0; } else if (tdpl[i].Evaluate == 2) { temp.plstate = 1; } else { temp.plstate = 2; } // 0差评1中评2好评 //新版(1,好评;2,中评;3,差评) temp.uid = Convert.ToInt32(req[2].Trim()); tdpl2.Add(temp); } } return JsonConvert.SerializeObject(tdpl2); } else { return JsonConvert.SerializeObject(tdpl2); } } else { throw new Exception("当天次数已经使用完毕!"); } } else { throw new Exception("商户标识错误"); } } else { throw new Exception("签名错误。"); } }
public string execute(string request) { //1202|1张三|21381234567|3莘凌路211号(小锦江酒店)|421:00|5asdfas1231asd|6IMEI|7MD5串|8lat|9lng string result = "0"; string[] req = request.Split('|'); var sign = EncodingUtil.GetMd5(req[2] + "aidaijia", "utf-8"); if (sign.ToLower() == req[7].ToLower()) { //判断T_ClentInfo是否有此手机号相关信息 //如果用户不存在,创建一个新用户 CustomerInfoEntity cinfo = new D_CustomerInfoDal().GetClientInfoByPhone(req[2].Trim()); string cusid = string.Empty; int CustomerType = 1; int AccountType = 2; T_ParterEntity parter = new T_PartyDal().GetParterModelBySign(req[5].ToLower()); if (parter != null) { #region 用户不存在则创建 if (cinfo == null) { int clentnum = new D_CustomerInfoDal().SelectSeqClent(); if (clentnum != 0) { string num = string.Empty; for (int i = 0; i < 8 - clentnum.ToString().Length; i++) { num += @"0"; } num = "U" + num + clentnum; cusid = num; CustomerInfoEntity customerEn = new CustomerInfoEntity() { AccountType = 2, Amount = 0, BusinessmanId = 0, Cellphone = req[2].Trim(), ParentPhone = req[2].Trim(), CustomerId = num, CustomerName = req[1].Trim(), CustomerType = 1, Email = string.Empty, HomeAddress = string.Empty, IsNewCustomer = true, LastAppointmentTime = null, LastCalledAddress = string.Empty, RecommendCode = new D_CustomerInfoDal().GenerateCustomerRecommendCode( new D_CustomerInfoDal().SelectSeqClent()), RegisterFrom = 8, //第三方API RegisterVersion = "" }; bool isture = new D_CustomerInfoDal().AddCustomerInfo(customerEn); if (!isture) { return "0"; } } else { return "0"; } } else { cusid = cinfo.CustomerId; CustomerType = cinfo.CustomerType; AccountType = cinfo.AccountType; } #endregion #region 优惠码操作 string couponCode = ""; if (req.Length == 12 && parter.url != null) { ThirdPartyCoupon cc = new ThirdPartyCoupon(); if (!cc.check(req[10], req[11], parter.url)) { throw new Exception("优惠码无效"); } couponCode = cc.addCoupon(parter.Id.ToString(), req[10], req[11], cinfo); } #endregion #region 创建预约订单 int zz = new D_AppointmentOrderInfoDA().SelectSeqOrder(); if (zz != 0) { string ordernum = string.Empty; for (int i = 0; i < 8 - zz.ToString().Length; i++) { ordernum += @"0"; } ordernum = "Party" + ordernum + zz; string lat = req[8].Trim(); string lng = req[9].Trim(); if (parter.Id == 11)//判断是博泰,对坐标进行转换 { ChangeCoords.ChangeCoordinate(ref lat, ref lng, 3, 5); } AppointmentOrderInfoEntity orderEn = new AppointmentOrderInfoEntity() { AppointAddress = req[3].ToLower(), AppointOrderId = ordernum, AppointOrderFrom = 5, // 第三方合作用户,由8改为5 AppointOrderSign = "1", AppointOrderState = 10, AppointOrderType = 1, // 1自己叫 AppointTime = Convert.ToDateTime(req[4].Trim()), AppointTimeStr = DateTime.Now.ToString("yyyy-MM-dd-HH-mm"), Cellphone = req[2].Trim(), FromCellphone = req[2].Trim(), CustomerId = cusid, CustomerName = req[1].Trim(), Create_time = DateTime.Now, Create_user = "******", BusinessType = 1, CustomerType = CustomerType, AccountType = AccountType, PartyId = parter.Id }; if (req.Length > 8) { orderEn.Lat = Convert.ToDecimal(lat); orderEn.Lng = Convert.ToDecimal(lng); } bool istrue = new D_AppointmentOrderInfoDA().AddAppointmentOrderInfo(orderEn); if (!istrue) { result = "0"; } else { //添加数据 T_ParterDyLog tpl = new T_ParterDyLog(); tpl.sign = req[5]; tpl.lat = "0"; tpl.lng = "0"; tpl.imei = req[6]; tpl.addtime = DateTime.Now; //1:获取司机2:上传通话3:上传预约 tpl.typeid = 3; new T_ParterDyLogDal().AddParterDyLog(tpl); result = "1"; } } else { throw new Exception("预约订单失败!"); } #endregion } else { throw new Exception("商户标识错误。"); } } else { throw new Exception("签名错误。"); } return result; }