protected void InserPonpareEnclose(GetOrderInfoWsvcRspBean o)
{
try
{
int k = 0;
foreach (var olist in o.orderList)
{
if (olist == null)
{
break;
}
//if (olist.encloseChildOrderList != null)
//{
k++;
int j = 0;
foreach (var elist in olist.encloseChildOrderList)
{
j++;
if (elist != null)
{
Enclose.Rows.Add(new object[]
{
StoreCD,
API_Key,
k.ToString(),
elist.encloseOrderNo,
j.ToString(),
elist.orderNo,
});
}
else
{
Enclose.Rows.Add(new object[]
{
StoreCD,
API_Key,
k.ToString(),
null,
j.ToString(),
null,
});
}
}
//}
}
}
catch (Exception ex)
{
var smsg = ex.Message;
}
}
protected void InsertJuchuu(GetOrderInfoWsvcRspBean orderinfo)
{
try
{
int i = 0;
foreach (OrderBean obean in orderinfo.orderList)
{
if (obean == null)
{
break;
}
i++;
// var f = obean.orderPymnt.creditCard.cardBrand;
Juchuu.Rows.Add(new object[] {
StoreCD,
API_Key,
i.ToString(),
obean.orderNo,
obean.orderDateTime,
obean.orderSts,
obean.pymntSts,
obean.depositDate,
obean.sendDate,
obean.dlvKind,
obean.dlvDesiredDate,
obean.dlvDesiredTimeZoneKind,
obean.dlvDesiredTimeZoneFrom,
obean.dlvDesiredTimeZoneTo,
obean.shopUserNameInCharge,
obean.orderMemo,
obean.messageToCustomer,
obean.useTerminal,
obean.mailcarrierCode,
IsTrue(obean.giftApplyFlg),
obean.orderNote,
obean.taxRate,
IsTrue(obean.dlvAddrCautionFlg),
IsTrue(obean.yellowUserFlg),
obean.memberKind,
IsTrue(obean.enclosableFlg),
obean.itemAmount,
obean.taxAmount,
obean.dlvFee,
obean.pymntFee,
obean.totalAmount,
obean.usePointAmount,
obean.useCouponTotalAmount,
obean.useCouponShopAmount,
obean.useCouponOtherAmount,
obean.useCouponTotalCnt,
obean.useCouponShopCnt,
obean.useCouponOtherCnt,
IsMoney(obean.totalPymntAmount),
IsMoney(obean.totalPymntAmountInit),
obean.orderCustomer.customerZip1,
obean.orderCustomer.customerZip2,
obean.orderCustomer.customerPref,
obean.orderCustomer.customerAddress,
obean.orderCustomer.customerLastName,
obean.orderCustomer.customerFirstName,
obean.orderCustomer.customerLastNameKana,
obean.orderCustomer.customerFirstNameKana,
obean.orderCustomer.customerTel,
obean.orderCustomer.customerEmail,
obean.orderPymnt.pymntMethodId,
obean.orderPymnt.pymntMethodName,
IsCreditCard(obean.orderPymnt.creditCard, "1"),
IsCreditCard(obean.orderPymnt.creditCard, "2"),
IsCreditCard(obean.orderPymnt.creditCard, "3"),
IsCreditCard(obean.orderPymnt.creditCard, "4"),
IsCreditCard(obean.orderPymnt.creditCard, "5"),
obean.orderDlv == null ? null:obean.orderDlv.dlvMethodId,
obean.orderDlv == null ? null:obean.orderDlv.dlvMethodName,
obean.orderDlvAddr == null? null:obean.orderDlvAddr.dlvAddrZip1,
obean.orderDlvAddr == null? null: obean.orderDlvAddr.dlvAddrZip2,
obean.orderDlvAddr == null? null:obean.orderDlvAddr.dlvAddrPref,
obean.orderDlvAddr == null? null:obean.orderDlvAddr.dlvAddrAddress,
obean.orderDlvAddr == null? null:obean.orderDlvAddr.dlvAddrLastName,
obean.orderDlvAddr == null? null:obean.orderDlvAddr.dlvAddrFirstName,
obean.orderDlvAddr == null? null:obean.orderDlvAddr.dlvAddrLastNameKana,
obean.orderDlvAddr == null? null:obean.orderDlvAddr.dlvAddrFirstNameKana,
obean.orderDlvAddr == null? null:obean.orderDlvAddr.dlvAddrTel,
obean.orderDlvAddr == null? null:obean.orderDlvAddr.slipNo,
obean.noshi,
obean.wrapping1 == null ? null:obean.wrapping1.wrappingKind,
obean.wrapping1 == null ? null:obean.wrapping1.wrappingName,
IsMoney(obean.wrapping1 == null ? null:obean.wrapping1.wrappingPrice),
obean.wrapping1 == null ? null:obean.wrapping1.wrappingTaxKind,
IsTrue(obean.wrapping1 == null ? null:obean.wrapping1.wrappingDelFlg),
obean.wrapping2 == null ? null:obean.wrapping2.wrappingKind,
obean.wrapping2 == null ? null:obean.wrapping2.wrappingName,
IsMoney(obean.wrapping2 == null ? null:obean.wrapping2.wrappingPrice),
obean.wrapping2 == null ? null:obean.wrapping2.wrappingTaxKind,
IsTrue(obean.wrapping2 == null ? null:obean.wrapping2.wrappingDelFlg),
obean.encloseKind,
obean.encloseOrderNo,
IsMoney(obean.encloseItemAmount),
IsMoney(obean.encloseTaxAmount),
IsMoney(obean.encloseDlvFee),
IsMoney(obean.enclosePymntFee),
IsMoney(obean.encloseTotalAmount),
IsMoney(obean.encloseUsePointAmount),
IsMoney(obean.encloseUseCouponAmount),
IsMoney(obean.encloseTotalPymntAmount),
IsTrue(obean.cardUpdatingIconFlg),
IsTrue(obean.cardUpdatedIconFlg),
obean.fraudOrderAlert,
IsTrue(obean.nxDayDlvFlg)
});
}
}
catch (Exception ex)
{
var msg = ex.Message;
return;
}
}
protected void InsertJuchuuDetails(GetOrderInfoWsvcRspBean O)
{
try
{
int j = 0;
foreach (var olis in O.orderList)
{
if (olis == null)
{
break;
}
j++;
int k = 0;
foreach (var ilist in olis.orderItemList)
{
k++;
if (ilist != null)
{
JuchuuDetails.Rows.Add(new object[] {
StoreCD,
API_Key,
k.ToString(),
olis.orderNo,
j.ToString(),
ilist.orderItemSubNo == null? null:ilist.orderItemSubNo.ToString(),
ilist.itemName,
ilist.itemId,
ilist.itemManageId,
ilist.HSkuItemId,
ilist.VSkuItemId,
IsMoney(ilist.salePrice),
ilist.itemCnt == null ? null: ilist.itemCnt.ToString(),
IsTrue(ilist.incShippingFlg),
ilist.taxKind,
ilist.itemTaxRateKbn,
ilist.itemTaxRate,
IsTrue(ilist.incCodFeeFlg),
ilist.getPointRate == null ? null: ilist.getPointRate.ToString(),
ilist.getPoint == null ? null: ilist.getPoint.ToString(),
ilist.purchaseOption,
ilist.invKind,
IsTrue(ilist.itemDelFlg),
});
}
else
{
JuchuuDetails.Rows.Add(new object[] {
StoreCD,
API_Key,
k.ToString(),
olis.orderNo,
j.ToString(),
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
null,
});
}
}
}
}
catch (Exception ex)
{
var msmg = ex.Message;
}
}
protected void InsertCouopon(GetOrderInfoWsvcRspBean o)
{
try {
int k = 0;
foreach (var olist in o.orderList)
{
if (olist == null)
{
break;
}
k++;
int j = 0;
if (olist.useCouponList != null)
{
foreach (var clist in olist.useCouponList)
{
j++;
if (clist != null)
{
Coupon.Rows.Add(new object[] {
StoreCD,
API_Key,
k.ToString(),
olist.orderNo,
j.ToString(),
clist.couponCode,
clist.orderItemSubNo == null? null:clist.orderItemSubNo,
clist.itemManageId,
clist.couponName,
clist.couponCnt == null? null: clist.couponCnt,
clist.couponCapitalKind == null?null:clist.couponCapitalKind,
clist.discountType == null? null: clist.discountType,
clist.expiryDate,
IsMoney(clist.couponAmount),
});
}
else
{
Coupon.Rows.Add(new object[] {
StoreCD,
API_Key,
k.ToString(),
olist.orderNo,
j.ToString(),
null,
null,
null,
null,
null,
null,
null,
null,
null,
});
}
}
}
else
{
j++;
Coupon.Rows.Add(new object[] {
StoreCD,
API_Key,
k.ToString(),
olist.orderNo,
j.ToString(),
null,
null,
null,
null,
null,
null,
null,
null,
null,
});
}
}
}
catch (Exception ex)
{
var mdg = ex.Message;
}
}
