private void SetOrderInfo(DataTable dtResult, string APIKey)
{
for (int j = 0; j < dtResult.Rows.Count; j++)
{
try
{
int orderID = Convert.ToInt32(dtResult.Rows[j]["WowmaOrderId"].ToString());
var webRequest = (HttpWebRequest)WebRequest.Create(string.Format("https://api.manager.wowma.jp/wmshopapi/searchTradeInfoProc?shopId={0}&orderId={1}", "39998948", orderID));
webRequest.ContentType = "application/x-www-form-urlencoded";
webRequest.Method = "GET";
webRequest.Headers.Add("Authorization", "Bearer " + APIKey);
HttpWebResponse response;
response = (HttpWebResponse)webRequest.GetResponse();
//Encoding ecoding = Encoding.GetEncoding(("UTF-16"));
XmlDocument resultXml = new XmlDocument();
using (StreamReader reader = new StreamReader(response.GetResponseStream()))
{
resultXml.Load(reader);
}
wowma_entity = new D_WowmaRequest_Entity();
wowma_entity.OrderListXml = resultXml.InnerXml;
wowma_entity.APIKey = dtResult.Rows[j]["APIKey"].ToString();
wowma_entity.StoreCD = dtResult.Rows[j]["StoreCD"].ToString();
wowma_entity.InportSEQRows = dtResult.Rows[j]["InportSEQ"].ToString();
CreateGetOrderData(resultXml, wowma_entity);
wowma_bl.InsertSelect_OrderDetail(be);
}
catch (WebException e)
{
using (WebResponse response1 = e.Response)
{
HttpWebResponse httpResponse = (HttpWebResponse)response1;
using (Stream data = response1.GetResponseStream())
using (var reader = new StreamReader(data))
{
string text = reader.ReadToEnd();
if (text.Contains("message"))
{
XmlDocument xd = new XmlDocument();
xd.LoadXml(text);
text = xd.InnerText;
}
}
}
}
}
}
public void SetOrderList(D_WowmaRequest_Entity wow_entity)
{
try
{
string sdate = s_date.ToString("yyyyMMdd");
string edate = e_date.ToString("yyyyMMdd");
string APIKey = wowma_entity.ApplicationID0;
var webRequest = (HttpWebRequest)WebRequest.Create(string.Format("https://api.manager.wowma.jp/wmshopapi/searchTradeInfoListProc?shopId={0}&totalCount={1}&startDate{2}&startDate={3}&endDate={4}", "39998948", "1000", "1", sdate, edate));
webRequest.ContentType = "application/x-www-form-urlencoded";
webRequest.Method = "GET";
webRequest.Headers.Add("Authorization", "Bearer " + APIKey);
HttpWebResponse response;
response = (HttpWebResponse)webRequest.GetResponse();
XmlDocument resultXml = new XmlDocument();
using (StreamReader reader = new StreamReader(response.GetResponseStream()))
{
resultXml.Load(reader);
}
dtResult = GetOrderIDData(resultXml);
wowma_entity.dtOrderList = dtResult;
DataTable dtData = wowma_bl.InsertSelect_OrderData(wowma_entity);
SetOrderInfo(dtData, APIKey); //OrderDetailList
}
catch (WebException e)
{
using (WebResponse response1 = e.Response)
{
HttpWebResponse httpResponse = (HttpWebResponse)response1;
using (Stream data = response1.GetResponseStream())
using (var reader = new StreamReader(data))
{
string text = reader.ReadToEnd();
if (text.Contains("message"))
{
XmlDocument xd = new XmlDocument();
xd.LoadXml(text);
text = xd.InnerText;
}
}
}
}
}
public DataTable InsertSelect_OrderData(D_WowmaRequest_Entity wowma_e)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@OrderListXml", new ValuePair {
value1 = SqlDbType.VarChar, value2 = wowma_e.OrderListXml
} },
{ "@APIKey", new ValuePair {
value1 = SqlDbType.TinyInt, value2 = wowma_e.APIKey
} },
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = wowma_e.StoreCD
} },
{ "@LastUpdatedBefore", new ValuePair {
value1 = SqlDbType.VarChar, value2 = wowma_e.LastUpdatedBefore
} },
{ "@LastUpdatedAfter", new ValuePair {
value1 = SqlDbType.VarChar, value2 = wowma_e.LastUpdatedAfter
} },
};
UseTransaction = true;
return(SelectData(dic, "WowmaOrder_InsertSelect"));
}
public DataTable InsertSelect_OrderData(D_WowmaRequest_Entity wowma_e)
{
wowma_e.OrderListXml = DataTableToXml(wowma_e.dtOrderList);
return(wowmadl.InsertSelect_OrderData(wowma_e));
}
private void CreateGetOrderData(XmlDocument Xml, D_WowmaRequest_Entity we)
{
CreateTable("JuChuu");
CreateTable("JuChuuDetail");
int row = 0, odrow = 1;
#region For JuChuu
XmlNodeList xnList = Xml.SelectNodes("/response/orderInfo");
foreach (XmlNode xn in xnList)
{
dtJuChuuList.Rows.Add();
dtJuChuuList.Rows[row]["InportSEQ"] = we.InportSEQRows;
dtJuChuuList.Rows[row]["StoreCD"] = we.StoreCD;
dtJuChuuList.Rows[row]["APIKey"] = we.APIKey;
dtJuChuuList.Rows[row]["InportSEQRows"] = seq++;
dtJuChuuList.Rows[row]["orderDate"] = xn["orderDate"] == null ? "" : xn["orderDate"].InnerText;
dtJuChuuList.Rows[row]["orderId"] = xn["orderId"] == null ? "" : xn["orderId"].InnerText;
dtJuChuuList.Rows[row]["sellMethodSegment"] = xn["sellMethodSegment"] == null ? "" : xn["sellMethodSegment"].InnerText;
dtJuChuuList.Rows[row]["releaseDate"] = xn["releaseDate"] == null ? "" : xn["releaseDate"].InnerText;
dtJuChuuList.Rows[row]["siteAndDevice"] = xn["siteAndDevice"] == null ? "" : xn["siteAndDevice"].InnerText;
dtJuChuuList.Rows[row]["mailAddress"] = xn["mailAddress"] == null ? "" : xn["mailAddress"].InnerText;
dtJuChuuList.Rows[row]["rawMailAddress"] = xn["rawMailAddress"] == null ? "" : xn["rawMailAddress"].InnerText;
dtJuChuuList.Rows[row]["ordererName"] = xn["ordererName"] == null ? "" : xn["ordererName"].InnerText;
dtJuChuuList.Rows[row]["ordererKana"] = xn["ordererKana"] == null ? "" : xn["ordererKana"].InnerText;
dtJuChuuList.Rows[row]["ordererZipCode"] = xn["ordererZipCode"] == null ? "" : xn["ordererZipCode"].InnerText;
dtJuChuuList.Rows[row]["ordererAddress"] = xn["ordererAddress"] == null ? "" : xn["ordererAddress"].InnerText;
dtJuChuuList.Rows[row]["ordererPhoneNumber1"] = xn["ordererPhoneNumber1"] == null ? "" : xn["ordererPhoneNumber1"].InnerText;
dtJuChuuList.Rows[row]["ordererPhoneNumber2"] = xn["ordererPhoneNumber2"] == null ? "NULL" : xn["ordererPhoneNumber2"].InnerText;
dtJuChuuList.Rows[row]["nickname"] = xn["nickname"] == null ? "" : xn["nickname"].InnerText;
dtJuChuuList.Rows[row]["senderName"] = xn["senderName"] == null ? "" : xn["senderName"].InnerText;
dtJuChuuList.Rows[row]["senderKana"] = xn["senderKana"] == null ? "" : xn["senderKana"].InnerText;
dtJuChuuList.Rows[row]["senderZipCode"] = xn["senderZipCode"] == null ? "" : xn["senderZipCode"].InnerText;
dtJuChuuList.Rows[row]["senderAddress"] = xn["senderAddress"] == null ? "" : xn["senderAddress"].InnerText;
dtJuChuuList.Rows[row]["senderPhoneNumber1"] = xn["senderPhoneNumber1"] == null ? "" : xn["senderPhoneNumber1"].InnerText;
dtJuChuuList.Rows[row]["senderPhoneNumber2"] = xn["senderPhoneNumber2"] == null ? "NULL" : xn["senderPhoneNumber2"].InnerText;
dtJuChuuList.Rows[row]["senderShopCD"] = xn["senderShopCD"] == null ? "" : xn["senderShopCD"].InnerText;
dtJuChuuList.Rows[row]["orderOption"] = xn["orderOption"] == null ? "" : xn["orderOption"].InnerText;
dtJuChuuList.Rows[row]["settlementName"] = xn["settlementName"] == null ? "" : xn["settlementName"].InnerText;
dtJuChuuList.Rows[row]["secureSegment"] = xn["secureSegment"] == null ? "" : xn["secureSegment"].InnerText;
dtJuChuuList.Rows[row]["userComment"] = xn["userComment"] == null ? "" : xn["userComment"].InnerText;
dtJuChuuList.Rows[row]["memo"] = xn["memo"] == null ? "" : xn["memo"].InnerText;
dtJuChuuList.Rows[row]["orderStatus"] = xn["orderStatus"] == null ? "" : xn["orderStatus"].InnerText;
dtJuChuuList.Rows[row]["contactStatus"] = xn["contactStatus"] == null ? "" : xn["contactStatus"].InnerText;
dtJuChuuList.Rows[row]["contactDate"] = xn["contactDate"] == null ? "" : xn["contactDate"].InnerText;
dtJuChuuList.Rows[row]["authorizationStatus"] = xn["authorizationStatus"] == null ? "" : xn["authorizationStatus"].InnerText;
dtJuChuuList.Rows[row]["authorizationDate"] = xn["authorizationDate"] == null ? "" : xn["authorizationDate"].InnerText;
dtJuChuuList.Rows[row]["paymentStatus"] = xn["paymentStatus"] == null ? "" : xn["paymentStatus"].InnerText;
dtJuChuuList.Rows[row]["paymentDate"] = xn["paymentDate"] == null ? "" : xn["paymentDate"].InnerText;
dtJuChuuList.Rows[row]["shipStatus"] = xn["shipStatus"] == null ? "" : xn["shipStatus"].InnerText;
dtJuChuuList.Rows[row]["shipDate"] = xn["shipDate"] == null ? "" : xn["shipDate"].InnerText;
dtJuChuuList.Rows[row]["printStatus"] = xn["printStatus"] == null ? "" : xn["printStatus"].InnerText;
dtJuChuuList.Rows[row]["printDate"] = xn["printDate"] == null ? "" : xn["printDate"].InnerText;
dtJuChuuList.Rows[row]["cancelStatus"] = xn["cancelStatus"] == null ? "" : xn["cancelStatus"].InnerText;
dtJuChuuList.Rows[row]["cancelReason"] = xn["cancelReason"] == null ? "" : xn["cancelReason"].InnerText;
dtJuChuuList.Rows[row]["cancelComment"] = xn["cancelComment"] == null ? "" : xn["cancelComment"].InnerText;
dtJuChuuList.Rows[row]["cancelDate"] = xn["cancelDate"] == null ? "" : xn["cancelDate"].InnerText;
dtJuChuuList.Rows[row]["totalSalePrice"] = xn["totalSalePrice"] == null ? "" : xn["totalSalePrice"].InnerText;
dtJuChuuList.Rows[row]["totalSalePriceNormalTax"] = xn["totalSalePriceNormalTax"] == null ? "" : xn["totalSalePriceNormalTax"].InnerText;
dtJuChuuList.Rows[row]["totalSalePriceReducedTax"] = xn["totalSalePriceReducedTax"] == null ? "" : xn["totalSalePriceReducedTax"].InnerText;
dtJuChuuList.Rows[row]["totalSalePriceNoTax"] = xn["totalSalePriceNoTax"] == null ? "" : xn["totalSalePriceNoTax"].InnerText;
dtJuChuuList.Rows[row]["totalSaleUnit"] = xn["totalSaleUnit"] == null ? "" : xn["totalSaleUnit"].InnerText;
dtJuChuuList.Rows[row]["postagePrice"] = xn["postagePrice"] == null ? "" : xn["postagePrice"].InnerText;
dtJuChuuList.Rows[row]["postagePriceTaxRate"] = xn["postagePriceTaxRate"] == null ? "" : xn["postagePriceTaxRate"].InnerText;
dtJuChuuList.Rows[row]["chargePrice"] = xn["chargePrice"] == null ? "" : xn["chargePrice"].InnerText;
dtJuChuuList.Rows[row]["chargePriceTaxRate"] = xn["chargePriceTaxRate"] == null ? "" : xn["chargePriceTaxRate"].InnerText;
dtJuChuuList.Rows[row]["totalItemOptionPrice"] = xn["totalItemOptionPrice"] == null ? "" : xn["totalItemOptionPrice"].InnerText;
dtJuChuuList.Rows[row]["totalItemOptionPriceTaxRate"] = xn["totalItemOptionPriceTaxRate"] == null ? "" : xn["totalItemOptionPriceTaxRate"].InnerText;
dtJuChuuList.Rows[row]["totalGiftWrappingPrice"] = xn["totalGiftWrappingPrice"] == null ? "" : xn["totalGiftWrappingPrice"].InnerText;
dtJuChuuList.Rows[row]["totalGiftWrappingPriceTaxRate"] = xn["totalGiftWrappingPriceTaxRate"] == null ? "" : xn["totalGiftWrappingPriceTaxRate"].InnerText;
dtJuChuuList.Rows[row]["totalPrice"] = xn["totalPrice"] == null ? "" : xn["totalPrice"].InnerText;
dtJuChuuList.Rows[row]["totalPriceNormalTax"] = xn["totalPriceNormalTax"] == null ? "" : xn["totalPriceNormalTax"].InnerText;
dtJuChuuList.Rows[row]["totalPriceReducedTax"] = xn["totalPriceReducedTax"] == null ? "" : xn["totalPriceReducedTax"].InnerText;
dtJuChuuList.Rows[row]["totalPriceNoTax"] = xn["totalPriceNoTax"] == null ? "" : xn["totalPriceNoTax"].InnerText;
dtJuChuuList.Rows[row]["premiumType"] = xn["premiumType"] == null ? "" : xn["premiumType"].InnerText;
dtJuChuuList.Rows[row]["premiumIssuePrice"] = xn["premiumIssuePrice"] == null ? "" : xn["premiumIssuePrice"].InnerText;
dtJuChuuList.Rows[row]["premiumMallPrice"] = xn["premiumMallPrice"] == null ? "" : xn["premiumMallPrice"].InnerText;
dtJuChuuList.Rows[row]["premiumShopPrice"] = xn["premiumShopPrice"] == null ? "" : xn["premiumShopPrice"].InnerText;
dtJuChuuList.Rows[row]["couponTotalPrice"] = xn["couponTotalPrice"] == null ? "" : xn["couponTotalPrice"].InnerText;
dtJuChuuList.Rows[row]["couponTotalPriceNormalTax"] = xn["couponTotalPriceNormalTax"] == null ? "" : xn["couponTotalPriceNormalTax"].InnerText;
dtJuChuuList.Rows[row]["couponTotalPriceReducedTax"] = xn["couponTotalPriceReducedTax"] == null ? "" : xn["couponTotalPriceReducedTax"].InnerText;
dtJuChuuList.Rows[row]["couponTotalPriceNoTax"] = xn["couponTotalPriceNoTax"] == null ? "" : xn["couponTotalPriceNoTax"].InnerText;
dtJuChuuList.Rows[row]["usePoint"] = xn["usePoint"] == null ? "" : xn["usePoint"].InnerText;
dtJuChuuList.Rows[row]["usePointNormalTax"] = xn["usePointNormalTax"] == null ? "" : xn["usePointNormalTax"].InnerText;
dtJuChuuList.Rows[row]["usePointReducedTax"] = xn["usePointReducedTax"] == null ? "" : xn["usePointReducedTax"].InnerText;
dtJuChuuList.Rows[row]["usePointNoTax"] = xn["usePointNoTax"] == null ? "" : xn["usePointNoTax"].InnerText;
dtJuChuuList.Rows[row]["usePointCancel"] = xn["usePointCancel"] == null ? "" : xn["usePointCancel"].InnerText;
dtJuChuuList.Rows[row]["useAuPointPrice"] = xn["useAuPointPrice"] == null ? "" : xn["useAuPointPrice"].InnerText;
dtJuChuuList.Rows[row]["useAuPointPriceNormalTax"] = xn["useAuPointPriceNormalTax"] == null ? "" : xn["useAuPointPriceNormalTax"].InnerText;
dtJuChuuList.Rows[row]["useAuPointPriceReducedTax"] = xn["useAuPointPriceReducedTax"] == null ? "" : xn["useAuPointPriceReducedTax"].InnerText;
dtJuChuuList.Rows[row]["useAuPointPriceNoTax"] = xn["useAuPointPriceNoTax"] == null ? "" : xn["useAuPointPriceNoTax"].InnerText;
dtJuChuuList.Rows[row]["useAuPoint"] = xn["useAuPoint"] == null ? "" : xn["useAuPoint"].InnerText;
dtJuChuuList.Rows[row]["useAuPointCancel"] = xn["useAuPointCancel"] == null ? "" : xn["useAuPointCancel"].InnerText;
dtJuChuuList.Rows[row]["requestPrice"] = xn["requestPrice"] == null ? "" : xn["requestPrice"].InnerText;
dtJuChuuList.Rows[row]["requestPriceNormalTax"] = xn["requestPriceNormalTax"] == null ? "" : xn["requestPriceNormalTax"].InnerText;
dtJuChuuList.Rows[row]["requestPriceReducedTax"] = xn["requestPriceReducedTax"] == null ? "" : xn["requestPriceReducedTax"].InnerText;
dtJuChuuList.Rows[row]["requestPriceNoTax"] = xn["requestPriceNoTax"] == null ? "" : xn["requestPriceNoTax"].InnerText;
dtJuChuuList.Rows[row]["pointFixedDate"] = xn["pointFixedDate"] == null ? "" : xn["pointFixedDate"].InnerText;
dtJuChuuList.Rows[row]["pointFixedStatus"] = xn["pointFixedStatus"] == null ? "" : xn["pointFixedStatus"].InnerText;
dtJuChuuList.Rows[row]["settleStatus"] = xn["settleStatus"] == null ? "" : xn["settleStatus"].InnerText;
dtJuChuuList.Rows[row]["authoriTimelimitDate"] = xn["authoriTimelimitDate"] == null ? "" : xn["authoriTimelimitDate"].InnerText;
dtJuChuuList.Rows[row]["pgResult"] = xn["pgResult"] == null ? "" : xn["pgResult"].InnerText;
dtJuChuuList.Rows[row]["pgResponseCode"] = xn["pgResponseCode"] == null ? "" : xn["pgResponseCode"].InnerText;
dtJuChuuList.Rows[row]["pgResponseDetail"] = xn["pgResponseDetail"] == null ? "" : xn["pgResponseDetail"].InnerText;
dtJuChuuList.Rows[row]["pgOrderId"] = xn["pgOrderId"] == null ? "" : xn["pgOrderId"].InnerText;
dtJuChuuList.Rows[row]["pgRequestPrice"] = xn["pgRequestPrice"] == null ? "" : xn["pgRequestPrice"].InnerText;
dtJuChuuList.Rows[row]["pgRequestPriceNormalTax"] = xn["pgRequestPriceNormalTax"] == null ? "" : xn["pgRequestPriceNormalTax"].InnerText;
dtJuChuuList.Rows[row]["pgRequestPriceReducedTax"] = xn["pgRequestPriceReducedTax"] == null ? "" : xn["pgRequestPriceReducedTax"].InnerText;
dtJuChuuList.Rows[row]["pgRequestPriceNoTax"] = xn["pgRequestPriceNoTax"] == null ? "" : xn["pgRequestPriceNoTax"].InnerText;
dtJuChuuList.Rows[row]["couponType"] = xn["couponType"] == null ? "" : xn["couponType"].InnerText;
dtJuChuuList.Rows[row]["couponKey"] = xn["couponKey"] == null ? "" : xn["couponKey"].InnerText;
dtJuChuuList.Rows[row]["cardJadgement"] = xn["cardJadgement"] == null ? "" : xn["cardJadgement"].InnerText;
dtJuChuuList.Rows[row]["deliveryName"] = xn["deliveryName"] == null ? "" : xn["deliveryName"].InnerText;
dtJuChuuList.Rows[row]["deliveryMethodId"] = xn["deliveryMethodId"] == null ? "" : xn["deliveryMethodId"].InnerText;
dtJuChuuList.Rows[row]["deliveryId"] = xn["deliveryId"] == null ? "" : xn["deliveryId"].InnerText;
dtJuChuuList.Rows[row]["deliveryRequestDay"] = xn["deliveryRequestDay"] == null ? "" : xn["deliveryRequestDay"].InnerText;
dtJuChuuList.Rows[row]["deliveryRequestTime"] = xn["deliveryRequestTime"] == null ? "" : xn["deliveryRequestTime"].InnerText;
dtJuChuuList.Rows[row]["shippingDate"] = xn["shippingDate"] == null ? "" : xn["shippingDate"].InnerText;
dtJuChuuList.Rows[row]["shippingCarrier"] = xn["shippingCarrier"] == null ? "" : xn["shippingCarrier"].InnerText;
dtJuChuuList.Rows[row]["shippingNumber"] = xn["shippingNumber"] == null ? "" : xn["shippingNumber"].InnerText;
dtJuChuuList.Rows[row]["yamatoLnkMgtNo"] = xn["yamatoLnkMgtNo"] == null ? "" : xn["yamatoLnkMgtNo"].InnerText;
row++;
}
#endregion
#region For JuChuuDetail
row = 0;
XmlNodeList xndetail = Xml.SelectNodes("/response/orderInfo/detail");
foreach (XmlNode xnn in xndetail)
{
//DteailList
dtJuChuuDetail.Rows.Add();
dtJuChuuDetail.Rows[row]["InportSEQ"] = we.InportSEQRows;
dtJuChuuDetail.Rows[row]["StoreCD"] = we.StoreCD;
dtJuChuuDetail.Rows[row]["APIKey"] = we.APIKey;
dtJuChuuDetail.Rows[row]["InportSEQRows"] = Deseq++;
dtJuChuuDetail.Rows[row]["orderId"] = dtJuChuuList.Rows[0]["orderId"].ToString();
dtJuChuuDetail.Rows[row]["orderRows"] = odrow++;
dtJuChuuDetail.Rows[row]["orderDetailId"] = xnn["orderDetailId"] == null ? "" : xnn["orderDetailId"].InnerText;
dtJuChuuDetail.Rows[row]["itemManagementId"] = xnn["itemManagementId"] == null ? "" : xnn["itemManagementId"].InnerText;
dtJuChuuDetail.Rows[row]["itemCode"] = xnn["itemCode"] == null ? "" : xnn["itemCode"].InnerText;
dtJuChuuDetail.Rows[row]["lotnumber"] = xnn["lotnumber"] == null ? "" : xnn["lotnumber"].InnerText;
dtJuChuuDetail.Rows[row]["itemName"] = xnn["itemName"] == null ? "" : xnn["itemName"].InnerText;
dtJuChuuDetail.Rows[row]["itemOption"] = xnn["itemOption"] == null ? "" : xnn["itemOption"].InnerText;
dtJuChuuDetail.Rows[row]["itemOptionCommission"] = xnn["itemOptionCommission"] == null ? "" : xnn["itemOptionCommission"].InnerText;
dtJuChuuDetail.Rows[row]["itemOptionPrice"] = xnn["itemOptionPrice"] == null ? "" : xnn["itemOptionPrice"].InnerText;
dtJuChuuDetail.Rows[row]["giftWrappingType"] = xnn["giftWrappingType"] == null ? "" : xnn["giftWrappingType"].InnerText;
dtJuChuuDetail.Rows[row]["giftWrappingPrice"] = xnn["giftWrappingPrice"] == null ? "" : xnn["giftWrappingPrice"].InnerText;
dtJuChuuDetail.Rows[row]["giftMessage"] = xnn["giftMessage"] == null ? "" : xnn["giftMessage"].InnerText;
dtJuChuuDetail.Rows[row]["noshiType"] = xnn["noshiType"] == null ? "" : xnn["noshiType"].InnerText;
dtJuChuuDetail.Rows[row]["noshiPresenterName1"] = xnn["noshiPresenterName1"] == null ? "" : xnn["noshiPresenterName1"].InnerText;
dtJuChuuDetail.Rows[row]["noshiPresenterName2"] = xnn["noshiPresenterName2"] == null ? "" : xnn["noshiPresenterName2"].InnerText;
dtJuChuuDetail.Rows[row]["noshiPresenterName3"] = xnn["noshiPresenterName3"] == null ? "" : xnn["noshiPresenterName3"].InnerText;
dtJuChuuDetail.Rows[row]["itemCancelStatus"] = xnn["itemCancelStatus"] == null ? "" : xnn["itemCancelStatus"].InnerText;
dtJuChuuDetail.Rows[row]["itemCancelDate"] = xnn["itemCancelDate"] == null ? "" : xnn["itemCancelDate"].InnerText;
dtJuChuuDetail.Rows[row]["beforeDiscount"] = xnn["beforeDiscount"] == null ? "" : xnn["beforeDiscount"].InnerText;
dtJuChuuDetail.Rows[row]["discount"] = xnn["discount"] == null ? "" : xnn["discount"].InnerText;
dtJuChuuDetail.Rows[row]["itemPrice"] = xnn["itemPrice"] == null ? "" : xnn["itemPrice"].InnerText;
dtJuChuuDetail.Rows[row]["unit"] = xnn["unit"] == null ? "" : xnn["unit"].InnerText;
dtJuChuuDetail.Rows[row]["totalItemPrice"] = xnn["totalItemPrice"] == null ? "" : xnn["totalItemPrice"].InnerText;
dtJuChuuDetail.Rows[row]["totalItemChargePrice"] = xnn["totalItemChargePrice"] == null ? "" : xnn["totalItemChargePrice"].InnerText;
dtJuChuuDetail.Rows[row]["taxType"] = xnn["taxType"] == null ? "" : xnn["taxType"].InnerText;
dtJuChuuDetail.Rows[row]["reducedTax"] = xnn["reducedTax"] == null ? "" : xnn["reducedTax"].InnerText;
dtJuChuuDetail.Rows[row]["taxRate"] = xnn["taxRate"] == null ? "" : xnn["taxRate"].InnerText;
dtJuChuuDetail.Rows[row]["giftPoint"] = xnn["giftPoint"] == null ? "" : xnn["giftPoint"].InnerText;
dtJuChuuDetail.Rows[row]["shippingDayDispText"] = xnn["shippingDayDispText"] == null ? "" : xnn["shippingDayDispText"].InnerText;
dtJuChuuDetail.Rows[row]["shippingTimelimitDate"] = xnn["shippingTimelimitDate"] == null ? "" : xnn["shippingTimelimitDate"].InnerText;
row++;
}
#endregion
be.dt1 = dtJuChuuList;
be.dt2 = dtJuChuuDetail;
}
