//退款或关闭订单
internal int UpdateWlOrderBack(wlOrderRefundResponse m, int orderStatus, wlOrderRefundRequest p)
{
if (m.body.partnerOrderId != "")
{
string sql = @"UPDATE [wl_OrderCreate]
SET
status=@status,
partnerRefundId=@partnerRefundId,
requestTime=@requestTime,
responeTime=@responeTime,
refundQuantity =@refundQuantity
WHERE orderid=@partnerOrderId and wlorderid=@wlorderid";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@partnerOrderId", int.Parse(p.body.partnerOrderId));
cmd.AddParam("@wlorderid", m.body.wlOrderId);
cmd.AddParam("@status", orderStatus);
cmd.AddParam("@refundQuantity", p.body.refundQuantity);
cmd.AddParam("@partnerRefundId", p.body.partnerRefundId);
cmd.AddParam("@requestTime", m.body.requestTime);
cmd.AddParam("@responeTime", m.body.responeTime);
cmd.ExecuteNonQuery();
return(int.Parse(m.body.partnerOrderId));
}
else
{
return(0);
}
}
public ReturnResult wlOrderRefundRequest_data(wlOrderRefundRequest requestData, int comid, int orderStatus)
{
string url = wl_url + "wl.trip.order.refund";
#region 记入日志表
string reqip = CommonFunc.GetRealIP();
WL_reqlog mlog = new WL_reqlog
{
id = 0,
reqstr = JsonConvert.SerializeObject(requestData),
subtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
respstr = "",
resptime = "",
code = "",
describe = "",
req_type = "",
orderid = requestData.body.partnerOrderId,
sendip = reqip,
stockagentcompanyid = comid
};
int logid = new WL_reqlogData().EditReqlog(mlog);
mlog.id = logid;
#endregion
ReturnResult result = new ReturnResult
{
IsSuccess = false,
};
try
{
var responseStr = DoRequest(url, JsonConvert.SerializeObject(requestData));
if (string.IsNullOrEmpty(responseStr))
{
result.Message = "返回数据为空";
}
else
{
mlog.req_type = "wl.trip.order.refund";
mlog.respstr = responseStr;
mlog.resptime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
new WL_reqlogData().EditReqlog(mlog);
wlOrderRefundResponse wlOrderRefundResponse = (wlOrderRefundResponse)JsonConvert.DeserializeObject(responseStr, typeof(wlOrderRefundResponse));
if (wlOrderRefundResponse.code == 200)
{
result.IsSuccess = true;
result.Message = "退款返回";
//完成支付
using (var sql = new SqlHelper())
{
try
{
var internalData = new InternalWlGetProInfoDealRequest(sql);
int wl_id = internalData.UpdateWlOrderBack(wlOrderRefundResponse, orderStatus, requestData);//一次性插入万龙id
}
catch
{
throw;
}
}
}
else
{
result.IsSuccess = false;
result.Message = wlOrderRefundResponse.describe;
}
//记录在日志表
mlog.code = wlOrderRefundResponse.code.ToString();
mlog.describe = wlOrderRefundResponse.describe;
mlog.mtorderid = wlOrderRefundResponse.body.wlOrderId;
}
}
catch (Exception ex)
{
result.Message = "异常" + ex.Message;
}
#region 记录在日志表
//mlog.req_type = "wl.trip.order.get";
//mlog.respstr = result.Message;
//mlog.resptime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
new WL_reqlogData().EditReqlog(mlog);
#endregion
return(result);
}