public WlDealResponseBody SelectonegetWlProDealData(string wlDealId, int comid)
{
using (var helper = new SqlHelper())
{
WlDealResponseBody r = new InternalWlGetProInfoDealRequest(helper).SelectonegetWlProDeal(wlDealId, comid);
return(r);
}
}
public wl_order_model getWlOrderidData(string wlorderId)
{
using (var helper = new SqlHelper())
{
wl_order_model r = new InternalWlGetProInfoDealRequest(helper).getWlOrderidData(wlorderId);
return(r);
}
}
public List <wl_use_log_model> InterfaceUsePageList(int comid, int pageindex, int pagesize, out int totalcount, string key, string startime, string endtime)
{
using (var helper = new SqlHelper())
{
List <wl_use_log_model> r = new InternalWlGetProInfoDealRequest(helper).InterfaceUsePageList(comid, pageindex, pagesize, out totalcount, key, startime, endtime);
return(r);
}
}
public List <WlDealResponseBody> SelectallgetWlProDealData(string proID, int comid, out int totalcount)
{
using (var helper = new SqlHelper())
{
List <WlDealResponseBody> r = new InternalWlGetProInfoDealRequest(helper).SelectallgetWlProDeal(proID, comid, out totalcount);
return(r);
}
}
public int InsertWlUseLog(int comid, string wlorderid, int usedQuantity = 0, int partnerId = 0, int quantity = 0, int orderid = 0, int proid = 0)
{
using (var helper = new SqlHelper())
{
var r = new InternalWlGetProInfoDealRequest(helper).InsertWlUseLog(comid, wlorderid, usedQuantity, partnerId, quantity, orderid, proid);
return(r);
}
}
public int UpdateWlOrderPaySC(wl_order_model m)
{
using (var helper = new SqlHelper())
{
var r = new InternalWlGetProInfoDealRequest(helper).UpdateWlOrderPaySC(m);
return(r);
}
}
public wl_order_model SearchWlOrderData(int comid, int id, string wlorderid, int orderid)
{
using (var helper = new SqlHelper())
{
var r = new InternalWlGetProInfoDealRequest(helper).SearchWlOrder(comid, id, wlorderid, orderid);
return(r);
}
}
public List <WlDealResponseBody> WLProPageList(string comid, int pageindex, int pagesize, int prostate, out int totalcount, string key = "")
{
using (var helper = new SqlHelper())
{
var list = new InternalWlGetProInfoDealRequest(helper).WLProPageList(comid, pageindex, pagesize, prostate, out totalcount, key);
return(list);
}
}
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);
}
public ReturnResult ProductChangedNotify(WlGetProInfoDealRequest requestData, int comid)
{
string url = wl_url + "wl.trip.order.get";
#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 = "",
sendip = reqip,
orderid = "0",
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.get";
mlog.respstr = responseStr;
mlog.resptime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
new WL_reqlogData().EditReqlog(mlog);
WlDealResponse responseBody = (WlDealResponse)JsonConvert.DeserializeObject(responseStr, typeof(WlDealResponse));
if (responseBody.code == 200)
{
result.IsSuccess = true;
result.Message = JsonConvert.SerializeObject(responseBody);
//写入产品数据
using (var sql = new SqlHelper())
{
try
{
var internalData = new InternalWlGetProInfoDealRequest(sql);
//更新返回后先对所有产品线进行下线，对上线的产品进行标注
var closewlpro = internalData.UPCloseWlProDeal(comid);
////循环对所有下载的数据依次插入
for (int i = 0; i < responseBody.body.Count; i++)
{
responseBody.body[i].id = 0; //临时都做为新的记录进行插入
responseBody.body[i].comid = comid; //商户id
responseBody.body[i].state = 1; //商户id
//对已拉取过的产品进行更新而不是插入
var pro_temp = internalData.SelectproidgetWlProDeal(responseBody.body[i].proID, responseBody.body[i].comid);
if (pro_temp != null)
{
responseBody.body[i].id = pro_temp.id;
}
int wlpro_id = internalData.InsertorUpdateWlProDeal(responseBody.body[i]);//插入只插入主要数据，后期更新
}
}
catch
{
throw;
}
}
}
else
{
result.IsSuccess = false;
result.Message = responseBody.describe;
}
//记录在日志表
mlog.code = responseBody.code.ToString();
mlog.describe = responseBody.describe;
}
}
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);
}