/// <summary>
/// 添加需要推送的订单信息到push表中
/// </summary>
/// <param name="out_trade_no"></param>
public void AddPushOrderInfo(String out_trade_no)
{
PushIBSOrderInfoEntity model = null;
int insertFlag = 0;
/// 创建推送IBS订单信息对象
model = new PushIBSOrderInfoEntity();
/// 根据支付宝响应信息的OrderCode获得订单的父订单号
OrderInfoEntity orderInfoEntity = GetOrderInfoByPay(out_trade_no);
string taxtypeStr = orderInfoEntity.TaxType.ToString();
/// 判断订单是否是综合税的
if (orderInfoEntity.TaxType == 1)
{
insertFlag = 1;
}
if (insertFlag == 1)
{
model.OrderCode = out_trade_no;
model.PushStatus = 0;
model.PushSuccTime = null;
model.GateWayCode = null;
model.TaxType = 1;
model.PayType = orderInfoEntity.PayPlatform;
model.CreateTime = DateTime.Now;
/// 增加推送IBS订单信息
CreatePushIBSOrderInfo(model);
}
}
public void Create(OrderInfoEntity orderInfo)
{
connection.Open();
MySqlCommand command = new MySqlCommand(addString);
MySqlParameter orderNumParam = new MySqlParameter("@orderNumber", orderInfo.OrderNumber);
MySqlParameter CountOfServicesRenderedParam = new MySqlParameter("@countOfServices", orderInfo.CountOfServicesRendered);
MySqlParameter ServiceIdParam = new MySqlParameter("@serviceId", orderInfo.ServiceId);
command.Parameters.Add(orderNumParam);
command.Parameters.Add(CountOfServicesRenderedParam);
command.Parameters.Add(ServiceIdParam);
command.Connection = connection;
object obj = null;
try
{
obj = command.ExecuteScalar();
}
finally
{
connection.Close();
}
int id = Convert.ToInt32(obj);
orderInfo.Id = id;
}
public decimal GetHuoLiByOrderIdBy(string orderId)
{
OrderInfoEntity model = new OrderInfoEntity();
model = GetOrderInfoHuoliByOrderCode(orderId);
return(model.Huoli);
}
public void SetOrderInfo(OrderInfoEntity orderInfoEntity)
{
orderInfoEntity.OrderStatus = 0;
orderInfoEntity.PaidAmount = 0;
orderInfoEntity.PayType = 1;
orderInfoEntity.ShippingMethod = 1;
orderInfoEntity.PayTime = null;
orderInfoEntity.DeliveryTime = null;
orderInfoEntity.ArrivalTime = null;
orderInfoEntity.OrderCompletionTime = null;
orderInfoEntity.CancelReason = "";
orderInfoEntity.Remark = "";
}
public void SetOrderAddress(OrderInfoEntity orderInfoEntity, int id, int DeliveryRegion)
{
var model = addressBll.GetAddressById(id);
orderInfoEntity.Receiver = model.Receiver;
orderInfoEntity.Phone = model.Phone;
orderInfoEntity.PassPortType = model.PapersType;
orderInfoEntity.PassPortNum = model.PapersCode;
orderInfoEntity.ReceiptAddress = model.Address;
orderInfoEntity.ReceiptPostalCode = model.PostCode;
orderInfoEntity.ReceiptRegion = model.AreaId;
orderInfoEntity.ReceiptCity = model.CityId;
orderInfoEntity.ReceiptProvince = model.ProvinceId;
orderInfoEntity.ReceiptCountry = DeliveryRegion.ToString();
}
/// <summary>
/// 获取支付二维码
/// </summary>
/// <param name="orderModel"></param>
/// <returns></returns>
public CodeResult WXPayRequest(OrderInfoEntity orderModel)
{
CodeResult result = new CodeResult();
string parameterString = @"version=1.0&merid=26100794&mername=北京联友创新科技发展有限公司&merorderid="
+ orderModel.OrderCode + "&paymoney=" + orderModel.TotalAmount + "&productname=" +
"&productdesc=&userid=" + orderModel.UserId + "&username="******"&email=&phone=&extra=&custom=";
string md5 = MD5Hash.GetMD5String(parameterString);//md5校验值
//发送支付请求
try
{
string url = "";
//微信支付
if (orderModel.PayType == 1)
{
url = ConfigHelper.GetAppConfigString("WXPayUrl") + @"?version=1.0&merid=26100794&mername=北京联友创新科技发展有限公司&merorderid="
+ orderModel.OrderCode + "&paymoney=" + orderModel.TotalAmount + "&productname=" +
"&productdesc=&userid=" + orderModel.UserId + "&username="******"&email=&phone=&extra=&custom=&md5=" + md5;
}
//支付宝支付
if (orderModel.PayType == 2)
{
url = ConfigHelper.GetAppConfigString("ZFBPayUrl") + @"?version=1.0&merid=26100794&mername=北京联友创新科技发展有限公司&merorderid="
+ orderModel.OrderCode + "&paymoney=" + orderModel.TotalAmount + "&productname=" +
"&productdesc=&userid=" + orderModel.UserId + "&username="******"&email=&phone=&extra=&custom=&md5=" + md5;
}
LogHelper.Info("url=" + url);
result = HttpClientHelper.GetResponse <CodeResult>(url);
}
catch (Exception ex)
{
//LogHelper.WriteLog(typeof(WXPayBLL), "WXPayRequest", Engineer.ggg, orderModel, ex);
LogHelper.WriteInfo(typeof(PayBll), ex.Message);
}
return(result);
}
public List <OrderInfoEntity> Read(
int minId = DefValInt,
int maxId = DefValInt,
int minCountOfServicesRendered = DefValInt,
int maxCountOfServicesRendered = DefValInt,
int minServiceId = DefValInt,
int maxServiceId = DefValInt,
int minOrderNumber = DefValInt,
int maxOrderNumber = DefValInt)
{
string stringWithWhere = CreateWherePartForReadQuery(minId, maxId, minCountOfServicesRendered, maxCountOfServicesRendered, minServiceId,
maxServiceId, minOrderNumber, maxOrderNumber);
MySqlCommand command = new MySqlCommand(readString + stringWithWhere);
command.Connection = connection;
List <OrderInfoEntity> result = new List <OrderInfoEntity>();
try
{
connection.Open();
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
object id = reader["id"];
object orderNumberFromDb = reader["OrderNumber"];
object countOfServicesRenderedFromDb = reader["CountOfServicesRendered"];
object serviceIdFromDb = reader["ServiceId"];
OrderInfoEntity orderInfo = new OrderInfoEntity
{
Id = System.Convert.ToInt32(id),
OrderNumber = System.Convert.ToInt32(orderNumberFromDb),
CountOfServicesRendered = System.Convert.ToInt32(countOfServicesRenderedFromDb),
ServiceId = Convert.ToInt32(serviceIdFromDb)
};
result.Add(orderInfo);
}
}
finally
{
connection.Close();
}
return(result);
}
public void Delete(OrderInfoEntity orderInfo)
{
connection.Open();
MySqlCommand command = new MySqlCommand(deleteString);
MySqlParameter parameter = new MySqlParameter("@id", orderInfo.Id.ToString());
command.Parameters.Add(parameter);
command.Connection = connection;
try
{
int delCount = command.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}
public void Update(OrderInfoEntity orderInfo, int orderNumber = DefValInt, int countOfServicesRendered = DefValInt, int serviceId = DefValInt)
{
connection.Open();
string setString = CreateSetPartForUpdateQuery(orderNumber, countOfServicesRendered, serviceId);
MySqlCommand command = new MySqlCommand(updateString + setString + $" where id = {orderInfo.Id};");
command.Connection = connection;
try
{
int updateCount = command.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}
public async Task <MessageModel <int> > PublishOrderInfo([FromBody] OrderInfoEntity orderInfoEntity)
{
var result = await orderInfoService.Add(orderInfoEntity);
if (result > 0)
{
return(new MessageModel <int>
{
success = true,
msg = "上传成功",
response = result
});
}
else
{
return(new MessageModel <int>
{
success = false,
msg = "上传失败",
response = result
});
}
}
public async Task <int> AddOrderInfo(OrderInfoEntity orderInfoEntity)
{
return(await orderInfoService.Add(orderInfoEntity));
}
