/// <summary> /// 关闭订单 /// </summary> /// <param name="or_id">订单id</param> /// <param name="us_id">用户id</param> /// <returns></returns> public static bool OrderClose(string or_id, string us_id) { JObject or_json = OrderDAL.GetInfo(or_id); string cmd; int flag = -1; if (or_json["us_id"].ToString() == us_id) { cmd = @"update [OrderDetails] set or_state=30 where or_id=@or_id"; flag = 0; } else { cmd = @"update [OrderDetails] set or_state=30 where or_id=@or_id and us_id=@us_id"; flag = 1; } bool result = DBHelper.Exec(cmd, "@or_id", or_id) > 0; if (flag == 0) { string cmd2 = @"update [Order] set or_state=30 where or_id=@or_id and us_id=@us_id"; return(DBHelper.Exec(cmd2, "@or_id", or_id, "@us_id", us_id) > 0); } return(false); }
/// <summary> /// 作为司机邀请乘客 /// </summary> /// <param name="or_id">乘客订单id</param> /// <param name="us_id">司机用户id</param> /// <returns></returns> public static bool InviteOrder(string or_id, string us_id) { CheckAvailability(); JObject or_json = OrderDAL.GetInfo(or_id); JObject ods_json = OrderDAL.GetOrderDetailsInfo(or_id, or_json["us_id"].ToString()); if (or_json == null) { return(false); } string cmd = @"insert [OrderDetails](or_id, us_id, price, or_state, [identity]) values(@or_id, @us_id, @price, @or_state, @identity)"; bool result = DBHelper.Exec(cmd, "@or_id", or_id, "@us_id", us_id, "@or_state", 15, "@price", ods_json["price"].ToString(), "@identity", "1") > 0; return(result); }