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); } }