public bool Insert_GetOrderData(Base_Entity base_entity)
{
base_entity.xml1 = DataTableToXml(base_entity.dt1);
base_entity.xml2 = DataTableToXml(base_entity.dt2);
base_entity.xml3 = DataTableToXml(base_entity.dt3);
base_entity.xml4 = DataTableToXml(base_entity.dt4);
base_entity.xml5 = DataTableToXml(base_entity.dt5);
base_entity.xml6 = DataTableToXml(base_entity.dt6);
return(DRakutenJuChuu_dl.Insert_GetOrderData(base_entity));
}
public bool Insert_OrderDetailData(Base_Entity be)
{
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@JuChuuXml", new ValuePair {
value1 = SqlDbType.VarChar, value2 = be.xml1
} },
{ "@DetailXml", new ValuePair {
value1 = SqlDbType.VarChar, value2 = be.xml2
} }
};
UseTransaction = true;
return(InsertUpdateDeleteData(dic, "WowmaDetail_Insert"));
}
public static void Main(string[] args)
{
Console.Title = "PSKS0112B_SKS在庫連携";
M_MultiPorpose_Entity mmpData = new M_MultiPorpose_Entity();
PSKS0112B_BL psks0112bl = new PSKS0112B_BL();
DataTable dt = new DataTable();
string datetime = string.Empty;
dt = psks0112bl.M_MultiPorpose_Select();
while (dt.Rows[0]["Num1"].ToString().Equals("0"))
{
Thread.Sleep(Convert.ToInt32(dt.Rows[0]["Num2"]) * 1000);
dt = psks0112bl.M_MultiPorpose_Select();
}
Base_Entity be = new Base_Entity();
be.InsertDateTime = DateTime.Now.ToString();
dt = psks0112bl.PSKS0112B_Select(be);
string JS_result = datatableToJason(dt);
PostJS(JS_result);
}
public DataTable PSKS0112B_Select(Base_Entity be)
{
return(psks0112bdl.PSKS0112B_Select(be));
}
public static void CreateGetOrderDataInfo(JObject jObjectInfo, string inportSEQ, string seq)
{
base_entity = new Base_Entity();
CreateDataTable("JuChuu");
CreateDataTable("Shipping");
CreateDataTable("Coupon");
CreateDataTable("ChangeReason");
CreateDataTable("JuChuuDetail");
CreateDataTable("ShippingDetail");
JArray orderNoList = (JArray)jObjectInfo.SelectToken("OrderModelList");
int row = 0;
foreach (JToken order in orderNoList)
{
JObject orderModel = String.IsNullOrWhiteSpace(order.SelectToken("OrdererModel").ToString()) ? null : (JObject)order.SelectToken("OrdererModel");
JObject settlementModel = String.IsNullOrWhiteSpace(order.SelectToken("SettlementModel").ToString()) ? null : (JObject)order.SelectToken("SettlementModel");
JObject pointModel = String.IsNullOrWhiteSpace(order.SelectToken("PointModel").ToString()) ? null : (JObject)order.SelectToken("PointModel");
JObject deliveryModel = String.IsNullOrWhiteSpace(order.SelectToken("DeliveryModel").ToString()) ? null : (JObject)order.SelectToken("DeliveryModel");
JObject wrapModel1 = String.IsNullOrWhiteSpace(order.SelectToken("WrappingModel1").ToString()) ? null : (JObject)order.SelectToken("WrappingModel1");
JObject wrapModel2 = String.IsNullOrWhiteSpace(order.SelectToken("WrappingModel2").ToString()) ? null : (JObject)order.SelectToken("WrappingModel2");
#region For JuChuu
dtJuChuuList.Rows.Add();
dtJuChuuList.Rows[row]["InportSEQ"] = inportSEQ;
dtJuChuuList.Rows[row]["StoreCD"] = dtSecretKey.Rows[0]["StoreCD"].ToString();
dtJuChuuList.Rows[row]["APIKey"] = dtSecretKey.Rows[0]["APIKey"].ToString();
dtJuChuuList.Rows[row]["InportSEQRows"] = seq;
foreach (string jsonstr in arrlstJuChu)
{
SelectFromJSon(dtJuChuuList.Rows[row], order, jsonstr);
}
if (orderModel != null)
{
foreach (string jsonstr in arrlstOrderModel)
{
SelectFromJSon(dtJuChuuList.Rows[row], orderModel, jsonstr);
}
}
if (settlementModel != null)
{
foreach (string jsonstr in arrlstsettlementModel)
{
SelectFromJSon(dtJuChuuList.Rows[row], settlementModel, jsonstr);
}
}
if (pointModel != null)
{
foreach (string jsonstr in arrlstpointModel)
{
SelectFromJSon(dtJuChuuList.Rows[row], pointModel, jsonstr);
}
}
if (deliveryModel != null)
{
foreach (string jsonstr in arrlstdeliveryModel)
{
SelectFromJSon(dtJuChuuList.Rows[row], deliveryModel, jsonstr);
}
}
if (wrapModel1 != null)
{
foreach (string jsonstr in arrlstwrapModel1)
{
SelectFromJSon(dtJuChuuList.Rows[row], wrapModel1, jsonstr);
}
}
if (wrapModel2 != null)
{
foreach (string jsonstr in arrlstwrapModel2)
{
SelectFromJSon(dtJuChuuList.Rows[row], wrapModel2, jsonstr);
}
}
#endregion
#region For Shipping
JArray packageModelList = String.IsNullOrWhiteSpace(order.SelectToken("PackageModelList").ToString()) ? null : (JArray)order.SelectToken("PackageModelList");
int rowp = 0;
if (packageModelList != null)
{
foreach (JToken package in packageModelList)
{
JObject senderModel = String.IsNullOrWhiteSpace(package.SelectToken("SenderModel").ToString()) ? null : (JObject)package.SelectToken("SenderModel");
JObject deliveryCvsModel = String.IsNullOrWhiteSpace(package.SelectToken("DeliveryCvsModel").ToString()) ? null : (JObject)package.SelectToken("DeliveryCvsModel");
dtShippingList.Rows.Add();
dtShippingList.Rows[rowp]["InportSEQ"] = inportSEQ;
dtShippingList.Rows[rowp]["StoreCD"] = dtSecretKey.Rows[0]["StoreCD"].ToString();
dtShippingList.Rows[rowp]["APIKey"] = dtSecretKey.Rows[0]["APIKey"].ToString();
dtShippingList.Rows[rowp]["InportSEQRows"] = seq;
dtShippingList.Rows[rowp]["orderNumber"] = String.IsNullOrWhiteSpace(order.SelectToken("orderNumber").ToString()) ? "null" : order.SelectToken("orderNumber").ToString();
dtShippingList.Rows[rowp]["basketRows"] = rowp + 1;
foreach (string jsonstr in arrlstPackageModel)
{
SelectFromJSon(dtShippingList.Rows[rowp], package, jsonstr);
}
if (senderModel != null)
{
foreach (string jsonstr in arrlstSenderModel)
{
SelectFromJSon(dtShippingList.Rows[rowp], senderModel, jsonstr);
}
}
if (deliveryCvsModel != null)
{
foreach (string jsonstr in arrlstDeliveryCvsModel)
{
SelectFromJSon(dtShippingList.Rows[rowp], deliveryCvsModel, jsonstr);
}
}
#region For JuChuuDetails
JArray juChuuDetails = String.IsNullOrWhiteSpace(package.SelectToken("ItemModelList").ToString()) ? null : (JArray)package.SelectToken("ItemModelList");
int rowj = 0;
if (juChuuDetails != null)
{
foreach (JToken juchuu in juChuuDetails)
{
dtJuChuuDetail.Rows.Add();
dtJuChuuDetail.Rows[rowj]["InportSEQ"] = inportSEQ;
dtJuChuuDetail.Rows[rowj]["StoreCD"] = dtSecretKey.Rows[0]["StoreCD"].ToString();
dtJuChuuDetail.Rows[rowj]["APIKey"] = dtSecretKey.Rows[0]["APIKey"].ToString();
dtJuChuuDetail.Rows[rowj]["InportSEQRows"] = seq;
dtJuChuuDetail.Rows[rowj]["orderNumber"] = String.IsNullOrWhiteSpace(order.SelectToken("orderNumber").ToString()) ? "null" : order.SelectToken("orderNumber").ToString();
dtJuChuuDetail.Rows[rowj]["basketRows"] = rowp + 1;
dtJuChuuDetail.Rows[rowj]["itemRows"] = rowj + 1;
foreach (string jsonstr in arrlstJuChuuDetail)
{
SelectFromJSon(dtJuChuuDetail.Rows[rowj], juchuu, jsonstr);
}
rowj++;
}
}
#endregion
#region For Shipping Details
JArray shippingModelList = String.IsNullOrWhiteSpace(package.SelectToken("ShippingModelList").ToString()) ? null : (JArray)package.SelectToken("ShippingModelList");
int rows = 0;
if (shippingModelList != null)
{
foreach (JToken shipping in shippingModelList)
{
dtShippingDetail.Rows.Add();
dtShippingDetail.Rows[rows]["InportSEQ"] = inportSEQ;
dtShippingDetail.Rows[rows]["StoreCD"] = dtSecretKey.Rows[0]["StoreCD"].ToString();
dtShippingDetail.Rows[rows]["APIKey"] = dtSecretKey.Rows[0]["APIKey"].ToString();
dtShippingDetail.Rows[rows]["InportSEQRows"] = seq;
dtShippingDetail.Rows[rows]["orderNumber"] = String.IsNullOrWhiteSpace(order.SelectToken("orderNumber").ToString()) ? "null" : order.SelectToken("orderNumber").ToString();
dtShippingDetail.Rows[rows]["basketRows"] = rowp + 1;
dtShippingDetail.Rows[rows]["itemRows"] = rows + 1;
foreach (string jsonstr in arrlstShippingDetail)
{
SelectFromJSon(dtShippingDetail.Rows[rowj], shipping, jsonstr);
}
rows++;
}
}
rowp++;
#endregion
}
#endregion
#region For Coupon
JArray couponModelList = String.IsNullOrWhiteSpace(order.SelectToken("CouponModelList").ToString()) ? null : (JArray)order.SelectToken("CouponModelList");
int rowc = 0;
if (couponModelList != null)
{
foreach (JToken coupon in couponModelList)
{
dtCouponList.Rows.Add();
dtCouponList.Rows[rowc]["InportSEQ"] = inportSEQ;
dtCouponList.Rows[rowc]["StoreCD"] = dtSecretKey.Rows[0]["StoreCD"].ToString();
dtCouponList.Rows[rowc]["APIKey"] = dtSecretKey.Rows[0]["APIKey"].ToString();
dtCouponList.Rows[rowc]["InportSEQRows"] = seq;
dtCouponList.Rows[rowc]["orderNumber"] = String.IsNullOrWhiteSpace(order.SelectToken("orderNumber").ToString()) ? "null" : order.SelectToken("orderNumber").ToString();
dtCouponList.Rows[rowc]["couponRows"] = rowc + 1;
foreach (string jsonstr in arrlstCouponModelList)
{
SelectFromJSon(dtCouponList.Rows[rowc], coupon, jsonstr);
}
rowc++;
}
}
#endregion
#region For ChangeReason
JArray changeReasonModelList = String.IsNullOrWhiteSpace(order.SelectToken("ChangeReasonModelList").ToString()) ? null : (JArray)order.SelectToken("ChangeReasonModelList");
int rowr = 0;
if (changeReasonModelList != null)
{
foreach (JToken reason in changeReasonModelList)
{
dtChangeReason.Rows.Add();
dtChangeReason.Rows[rowr]["InportSEQ"] = inportSEQ;
dtChangeReason.Rows[rowr]["StoreCD"] = dtSecretKey.Rows[0]["StoreCD"].ToString();
dtChangeReason.Rows[rowr]["APIKey"] = dtSecretKey.Rows[0]["APIKey"].ToString();
dtChangeReason.Rows[rowr]["InportSEQRows"] = seq;
dtChangeReason.Rows[rowr]["orderNumber"] = String.IsNullOrWhiteSpace(order.SelectToken("orderNumber").ToString()) ? "null" : order.SelectToken("orderNumber").ToString();
dtChangeReason.Rows[rowr]["reasonRows"] = rowr + 1;
foreach (string jsonstr in arrlstChangeReason)
{
SelectFromJSon(dtChangeReason.Rows[rowc], reason, jsonstr);
}
rowr++;
}
}
#endregion
row++;
}
}
base_entity.dt1 = dtJuChuuList;
base_entity.dt2 = dtShippingList;
base_entity.dt3 = dtCouponList;
base_entity.dt4 = dtChangeReason;
base_entity.dt5 = dtJuChuuDetail;
base_entity.dt6 = dtShippingDetail;
base_entity.InsertOperator = "Console";
}
public bool Data_Insert(Base_Entity baseEntity)
{
return(thanbaishohin_dl.DataInsert(baseEntity));
}
