public int EditReqlog(WL_reqlog m)
{
using (var helper = new SqlHelper())
{
int id = new InternalWL_reqlog(helper).EditReqlog(m);
return(id);
}
}
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);
}
internal int EditReqlog(WL_reqlog m)
{
if (m.id == 0)
{
string sql = @"INSERT INTO [WL_reqlog]
([reqstr]
,[subtime]
,[respstr]
,[resptime]
,[code]
,[describe]
,[req_type]
,[sendip]
,orderid
,mtorderid
,ordernum
,issecond_req,stockagentcompanyid)
VALUES
(@reqstr
,@subtime
,@respstr
,@resptime
,@code
,@describe
,@req_type
,@sendip
,@orderid
,@mtorderid
,@ordernum
,@issecond_req,@stockagentcompanyid);select @@identity;";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@reqstr", m.reqstr);
cmd.AddParam("@subtime", m.subtime);
cmd.AddParam("@respstr", m.respstr);
cmd.AddParam("@resptime", m.resptime);
cmd.AddParam("@code", m.code);
cmd.AddParam("@describe", m.describe);
cmd.AddParam("@req_type", m.req_type);
cmd.AddParam("@sendip", m.sendip);
if (m.mtorderid == null)
{
m.mtorderid = "";
}
cmd.AddParam("@mtorderid", m.mtorderid);
if (m.orderid == null)
{
m.orderid = "";
}
cmd.AddParam("@orderid", m.orderid);
if (m.ordernum == null)
{
m.ordernum = "";
}
cmd.AddParam("@ordernum", m.ordernum);
if (m.issecond_req == null)
{
m.issecond_req = 0;
}
cmd.AddParam("@issecond_req", m.issecond_req);
if (m.stockagentcompanyid == null)
{
m.stockagentcompanyid = 0;
}
cmd.AddParam("@stockagentcompanyid", m.stockagentcompanyid);
object o = cmd.ExecuteScalar();
return(o == null ? 0 : int.Parse(o.ToString()));
}
else
{
string sql = @"UPDATE [WL_reqlog]
SET [reqstr] = @reqstr
,[subtime] = @subtime
,[respstr] = @respstr
,[resptime] = @resptime
,[code] = @code
,[describe] = @describe
,[req_type] = @req_type
,[sendip] = @sendip
,mtorderid=@mtorderid
,orderid=@orderid
,ordernum=@ordernum
,issecond_req=@issecond_req
,stockagentcompanyid=@stockagentcompanyid
WHERE id=@id";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@id", m.id);
cmd.AddParam("@reqstr", m.reqstr);
cmd.AddParam("@subtime", m.subtime);
if (m.respstr == null)
{
m.respstr = "";
}
cmd.AddParam("@respstr", m.respstr);
cmd.AddParam("@resptime", m.resptime);
cmd.AddParam("@code", m.code);
cmd.AddParam("@describe", m.describe);
cmd.AddParam("@req_type", m.req_type);
cmd.AddParam("@sendip", m.sendip);
if (m.mtorderid == null)
{
m.mtorderid = "";
}
cmd.AddParam("@mtorderid", m.mtorderid);
if (m.orderid == null)
{
m.orderid = "";
}
cmd.AddParam("@orderid", m.orderid);
if (m.ordernum == null)
{
m.ordernum = "";
}
cmd.AddParam("@ordernum", m.ordernum);
if (m.issecond_req == null)
{
m.issecond_req = 0;
}
cmd.AddParam("@issecond_req", m.issecond_req);
if (m.stockagentcompanyid == null)
{
m.stockagentcompanyid = 0;
}
cmd.AddParam("@stockagentcompanyid", m.stockagentcompanyid);
cmd.ExecuteNonQuery();
return(m.id);
}
}
