Exemple #1
0
        /// <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);
        }
Exemple #2
0
        /// <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);
        }