public int UpdateWlOrderPaySC(wl_order_model m)
{
using (var helper = new SqlHelper())
{
var r = new InternalWlGetProInfoDealRequest(helper).UpdateWlOrderPaySC(m);
return(r);
}
}
//查询单笔订单，合作商订单号或者万龙订单号或者id
internal wl_order_model getWlOrderidData(string wlorderid)
{
string sql = @"SELECT * FROM wl_OrderCreate where wlorderid=@wlorderid";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@wlorderid", wlorderid);
using (var reader = cmd.ExecuteReader())
{
wl_order_model m = null;
if (reader.Read())
{
m = new wl_order_model
{
id = reader.GetValue <int>("id"),
comid = reader.GetValue <int>("comid"),
subtime = reader.GetValue <DateTime>("subtime"),
orderid = reader.GetValue <int>("orderid"),
//partnerOrderId = reader.GetValue<int>("partnerOrderId"),
partnerId = reader.GetValue <string>("partnerId"),
partnerdealid = reader.GetValue <int>("partnerdealid"),
name = reader.GetValue <string>("name"),
mobile = reader.GetValue <string>("mobile"),
wldealid = reader.GetValue <string>("wldealid"),
buyprice = Convert.ToDouble(reader.GetValue <decimal>("buyprice")),
unitprice = Convert.ToDouble(reader.GetValue <decimal>("unitprice")),
totalprice = Convert.ToDouble(reader.GetValue <decimal>("totalprice")),
quantity = reader.GetValue <int>("quantity"),
usedQuantity = reader.GetValue <int>("usedQuantity"),
refundedQuantity = reader.GetValue <int>("refundedQuantity"),
traveldate = reader.GetValue <string>("traveldate"),
wlorderid = reader.GetValue <string>("wlorderid"),
code = reader.GetValue <int>("code"),
describe = reader.GetValue <string>("describe"),
pay_code = reader.GetValue <int>("pay_code"),
pay_describe = reader.GetValue <string>("pay_describe"),
voucherType = reader.GetValue <int>("voucherType"),
vouchers = reader.GetValue <string>("vouchers"),
voucherPics = reader.GetValue <string>("voucherPics"),
status = reader.GetValue <int>("status"),
partnerRefundId = reader.GetValue <string>("partnerRefundId"),
refundId = reader.GetValue <string>("refundId"),
requestTime = reader.GetValue <string>("requestTime"),
responeTime = reader.GetValue <string>("responeTime")
};
}
return(m);
}
}
//核销后修改订单使用数量
internal int UpdateWlOrderPaySC(wl_order_model m)
{
if (m != null)
{
string sql = @"UPDATE [wl_OrderCreate]
SET
usedQuantity=@usedQuantity,
refundedQuantity=@refundedQuantity
WHERE id=@id";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@id", m.id);
cmd.AddParam("@usedQuantity ", m.usedQuantity);
cmd.AddParam("@refundedQuantity ", m.refundedQuantity);
cmd.ExecuteNonQuery();
return(m.id);
}
else
{
return(0);
}
}
