/// <summary>
/// 支付前下单通知信息记录
/// </summary>
/// <param name="createOrderForBeforePaySyncRequestBody"></param>
/// <param name="parterorderid"></param>
/// <param name="orderStatus"></param>
/// <param name="eticketNo"></param>
/// <returns></returns>
public int InsQunar_CreateOrderForBeforePaySync(CreateOrderForBeforePaySyncRequestBody createOrderForBeforePaySyncRequestBody)
{
using (var helper = new SqlHelper())
{
int id = new InternalQunar_CreateOrderForBeforePaySync(helper).InsQunar_CreateOrderForBeforePaySync(createOrderForBeforePaySyncRequestBody);
return(id);
}
}
internal int InsQunar_CreateOrderForBeforePaySync(CreateOrderForBeforePaySyncRequestBody createOrderForBeforePaySyncRequestBody)
{
CreateOrderForBeforePaySyncRequestBodyorderInfo createOrderForBeforePaySyncRequestBodyorderInfo = createOrderForBeforePaySyncRequestBody.orderInfo;
string qunar_orderId = createOrderForBeforePaySyncRequestBodyorderInfo.orderId;
string orderQuantity = createOrderForBeforePaySyncRequestBodyorderInfo.orderQuantity;
string orderPrice = createOrderForBeforePaySyncRequestBodyorderInfo.orderPrice;//总价
string orderCashBackMoney = createOrderForBeforePaySyncRequestBodyorderInfo.orderCashBackMoney;
string orderStatus = createOrderForBeforePaySyncRequestBodyorderInfo.orderStatus;
string orderRemark = createOrderForBeforePaySyncRequestBodyorderInfo.orderRemark;
string orderSource = createOrderForBeforePaySyncRequestBodyorderInfo.orderSource;
string eticketNo = createOrderForBeforePaySyncRequestBodyorderInfo.eticketNo;
if (eticketNo == null)
{
eticketNo = "";
}
CreateOrderForBeforePaySyncRequestBodyorderInfoproduct mproduct = createOrderForBeforePaySyncRequestBodyorderInfo.product;
string resourceId = mproduct.resourceId;
string productName = mproduct.productName;
string visitDate = mproduct.visitDate;
string sellPrice = mproduct.sellPrice;//单价
string cashBackMoney = mproduct.cashBackMoney;
CreateOrderForBeforePaySyncRequestBodyorderInfocontactPerson mcontactPerson = createOrderForBeforePaySyncRequestBodyorderInfo.contactPerson;
string name = mcontactPerson.name;
string namePinyin = mcontactPerson.namePinyin;
string mobile = mcontactPerson.mobile;
string email = mcontactPerson.email;
string address = mcontactPerson.address;
string zipCode = mcontactPerson.zipCode;
try
{
string sql = @"INSERT INTO [qunar_CreateOrderForBeforePaySync]
([qunar_orderId]
,[resourceId]
,[productName]
,[visitDate]
,[sellPrice]
,[cashBackMoney]
,[name]
,[namePinyin]
,[mobile]
,[email]
,[address]
,[zipCode]
,[orderQuantity]
,[orderPrice]
,[orderCashBackMoney]
,[orderStatus]
,[orderRemark]
,[orderSource]
,[eticketNo]
,[parterorderid]
,[orderStatus_ret]
,[eticketNo_ret]
,qunar_ret)
VALUES
(@qunar_orderId
,@resourceId
,@productName
,@visitDate
,@sellPrice
,@cashBackMoney
,@name
,@namePinyin
,@mobile
,@email
,@address
,@zipCode
,@orderQuantity
,@orderPrice
,@orderCashBackMoney
,@orderStatus
,@orderRemark
,@orderSource
,@eticketNo
,@parterorderid
,@orderStatus_ret
,@eticketNo_ret,@qunar_ret);select @@identity;";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@qunar_orderId", qunar_orderId);
cmd.AddParam("@resourceId", resourceId);
cmd.AddParam("@productName", productName);
cmd.AddParam("@visitDate", visitDate);
cmd.AddParam("@sellPrice", sellPrice);
cmd.AddParam("@cashBackMoney", cashBackMoney);
cmd.AddParam("@name", name);
cmd.AddParam("@namePinyin", namePinyin);
cmd.AddParam("@mobile", mobile);
cmd.AddParam("@email", email);
cmd.AddParam("@address", address);
cmd.AddParam("@zipCode", zipCode);
cmd.AddParam("@orderQuantity", orderQuantity);
cmd.AddParam("@orderPrice", orderPrice);
cmd.AddParam("@orderCashBackMoney", orderCashBackMoney);
cmd.AddParam("@orderStatus", orderStatus);
cmd.AddParam("@orderRemark", orderRemark);
cmd.AddParam("@orderSource", orderSource);
cmd.AddParam("@eticketNo", eticketNo);
cmd.AddParam("@parterorderid", 0);
cmd.AddParam("@orderStatus_ret", "");
cmd.AddParam("@eticketNo_ret", "");
cmd.AddParam("@qunar_ret", "");
object o = cmd.ExecuteScalar();
return(int.Parse(o.ToString()));
}
catch
{
return(0);
}
}
