// 1214|sign|orderid|CustomerCellPhone|Ucode|DriverName|ComplaintContent|7a31f99279327f8b75506acbf0503973 public string execute(string request) { int flag = 0; string[] req = request.Split('|'); var sign = EncodingUtil.GetMd5(req[2] + "aidaijia", "utf-8"); if (sign.ToLower() == req[7].ToLower()) { T_ParterEntity parter = new T_PartyDal().GetParterModelBySign(req[1].ToLower()); if (parter != null) { string orderCellPhone = ""; string orderUcode = ""; new D_OrderInfoDal().getOrderCellphone_Ucode(req[2], out orderCellPhone, out orderUcode); if (!orderCellPhone.ToLower().Equals(req[3].ToLower())) { throw new Exception("没有该用户"); } if (!orderUcode.ToLower().Equals(req[4].ToLower())) { throw new Exception("没有该司机"); } CustomerInfoEntity ci = new D_CustomerInfoDal().GetClientInfoByPhone(orderCellPhone); D_OrderComplaint dc = new D_OrderComplaint() { Cellphone = ci.Cellphone, OrderId = req[2], CustomerId = ci.CustomerId, CustomerName = ci.CustomerName, Ucode = req[4], ComplaintContent = req[6], DriverName = req[5], CreateUser = "******" }; flag = new ComplainDAL().addComplain(dc); } else { throw new Exception("商户标识错误"); } } else { throw new Exception("签名错误。"); } return flag.ToString(); }
/// <summary> /// 新增一条投诉记录 /// </summary> /// <param name="complain"></param> /// <returns></returns> public int addComplain(D_OrderComplaint complain) { AdjDBObject db = new AdjDBObject(); StringBuilder sb = new StringBuilder(); sb.AppendLine("insert into D_OrderComplaint "); sb.AppendLine("(OrderId ,CustomerId,CustomerName,Cellphone,Ucode,DriverName,ComplaintType,ComplaintContent,create_time,create_user,delete_flag)"); sb.AppendLine("values"); sb.AppendLine("(@OrderId ,@CustomerId,@CustomerName,@Cellphone,@Ucode,@DriverName,1,@ComplaintContent,getdate(),@create_user,0)"); db.GetSqlStringCommand(sb.ToString()); db.AddInParameter("@OrderId",System.Data.DbType.String,complain.OrderId); db.AddInParameter("@CustomerId", System.Data.DbType.String, complain.CustomerId); db.AddInParameter("@CustomerName", System.Data.DbType.String, complain.CustomerName); db.AddInParameter("@Cellphone", System.Data.DbType.String, complain.Cellphone); db.AddInParameter("@Ucode", System.Data.DbType.String, complain.Ucode); db.AddInParameter("@DriverName", System.Data.DbType.String, complain.DriverName); db.AddInParameter("@ComplaintContent", System.Data.DbType.String, complain.ComplaintContent); db.AddInParameter("@create_user", System.Data.DbType.String, complain.CreateUser); return db.Execute(); }