private static void TestShopDownware()
{
EnterpriseDisWithDBInfoEntity enterInfo = new Ruanal.Job.ImpDispatchs.Entity.EnterpriseDisWithDBInfoEntity()
{
dbtype = 0,
dbserver = "conn0894z4r7.sqlserver.rds.aliyuncs.com,3433",
dbuser = "******",
dbpass = "******",
rdssl = "ins_0894z4r7",
zzid = 1,
qyid = 2,
qybm = "uoou",
qymc = "杭州淘萌",
dbserverid = 2,
dbname = "zhuidian_uoou"
};
try
{
Console.WriteLine("开始...");
using (K8erp.Lib.Db.DbConn qyconn = K8erp.Lib.Db.DbConn.CreateConn(
(K8erp.Lib.Db.DbType)enterInfo.dbtype, enterInfo.dbserver, enterInfo.dbname, enterInfo.dbuser, enterInfo.dbpass))
{
qyconn.Open();
List <K8erp.Platform.Domain.Store> shops = K8erp.Platform.Dal.Bll.GetQyStores(qyconn);
var shop = shops.FirstOrDefault(x => x.Dpid == 43);
if (shop == null)
{
Console.WriteLine("没有找到店铺");
return;
}
Console.WriteLine("开始...");
K8erp.Platform.Dal.BllWare2.DownWare(qyconn, shop);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace);
var innex = ex.InnerException;
while (innex != null)
{
Console.WriteLine(innex.Message);
Console.WriteLine(innex.StackTrace);
innex = innex.InnerException;
}
}
finally
{
Console.WriteLine("结束");
}
}
private static void TestPddTrade()
{
var store = new K8erp.Platform.Domain.Store()
{
Dpid = 8,
Dplx = K8erp.Platform.Domain.StoreTypeEmun.Pinduoduo,
Key1 = "74390",
Key2 = "pinduoduo",
Session = "aaa",
Expires = "",
Dpmc = "拼多多-煜炬皮具专营店",
Re_Expires = "",
Key3 = "",
SellerId = ""
};
K8erp.Platform.Open.PinduoduoOpen2 pdd = new K8erp.Platform.Open.PinduoduoOpen2(store.Key1, store.Key2);
pdd.OpenStatus = K8erp.Platform.Domain.OpenStatus.Regular;
var ttt = pdd.Trade(new K8erp.Platform.ApiRequest.TradeRequest()
{
PageNo = 1, Status = -9, ServerDate = DateTime.Now
});
int kkkkk = 0;
return;
EnterpriseDisWithDBInfoEntity enterInfo = new Ruanal.Job.ImpDispatchs.Entity.EnterpriseDisWithDBInfoEntity()
{
dbtype = 0,
dbserver = "rm-vy11h8bio01g37y53.sqlserver.rds.aliyuncs.com,3433",
dbuser = "******",
dbpass = "******",
rdssl = "rm-vy11h8bio01g37y53",
zzid = 1,
qyid = 21,
qybm = "daolang",
qymc = "稻浪电子商务",
dbserverid = 5,
dbname = "zhuidian_daolang"
};
using (K8erp.Lib.Db.DbConn qyconn = K8erp.Lib.Db.DbConn.CreateConn(
(K8erp.Lib.Db.DbType)enterInfo.dbtype, enterInfo.dbserver, enterInfo.dbname, enterInfo.dbuser, enterInfo.dbpass))
{
qyconn.Open();
K8erp.Platform.Dal.BllTrade.DownFullTradeV2(qyconn, enterInfo.qyid, store, (x, y) =>
{
Console.WriteLine("ok={0} msg={1}", x, y);
});
}
}
private static void TestRdsTrade()
{
var store = new K8erp.Platform.Domain.Store()
{
Dpid = 9990,
Dplx = K8erp.Platform.Domain.StoreTypeEmun.Tmall,
Key1 = "",
Key2 = "",
Key3 = "ttt",
Key4 = "",
SellerId = "妞妞家族旗舰店",
Session = "6201a204451c0dfdea83a9ec2506ZZc3efh0a2540fd5bf51776287027",
Expires = "",
Re_Expires = ""
};
EnterpriseDisWithDBInfoEntity enterInfo = new Ruanal.Job.ImpDispatchs.Entity.EnterpriseDisWithDBInfoEntity()
{
dbtype = 0,
dbserver = "jconntkgxcygg.sqlserver.rds.aliyuncs.com,3433",
dbuser = "******",
dbpass = "******",
rdssl = "jrdsmhcfizqj",
zzid = 1,
qyid = 21,
qybm = "nnjz",
qymc = "家族",
dbserverid = 3,
dbname = "zhuidian_nnjz"
};
using (K8erp.Lib.Db.DbConn qyconn = K8erp.Lib.Db.DbConn.CreateConn(
(K8erp.Lib.Db.DbType)enterInfo.dbtype, enterInfo.dbserver, enterInfo.dbname, enterInfo.dbuser, enterInfo.dbpass))
{
qyconn.Open();
K8erp.Platform.Dal.TaoBaoRdsOpen rdsopen = new K8erp.Platform.Dal.TaoBaoRdsOpen(qyconn, store);
var trademodel = rdsopen.PartTrade(new K8erp.Platform.ApiRequest.PartTradeRequest()
{
Tid = "24216943691019110", ServerDate = DateTime.Now
});
var sss = Newtonsoft.Json.JsonConvert.SerializeObject(trademodel, Formatting.Indented);
Console.WriteLine(sss);
}
}
private static void TestMogujieTrade()
{
var store = new K8erp.Platform.Domain.Store()
{
Dpid = 128,
Dplx = K8erp.Platform.Domain.StoreTypeEmun.Meilishuo,
Key1 = "",
Key2 = "",
Key4 = "",
Session = "517BAD1B9AF60730CB665135B812F292",
Expires = "",
Dpmc = "淘气麦兜店",
Re_Expires = "",
Key3 = "",
SellerId = ""
};
EnterpriseDisWithDBInfoEntity enterInfo = new Ruanal.Job.ImpDispatchs.Entity.EnterpriseDisWithDBInfoEntity()
{
dbtype = 0,
dbserver = "conn0894z4r7.sqlserver.rds.aliyuncs.com,3433",
dbuser = "******",
dbpass = "******",
rdssl = "rm-vy11h8bio01g37y53",
zzid = 1,
qyid = 21,
qybm = "md",
qymc = "淘气麦兜",
dbserverid = 5,
dbname = "zhuidian_md"
};
using (K8erp.Lib.Db.DbConn qyconn = K8erp.Lib.Db.DbConn.CreateConn(
(K8erp.Lib.Db.DbType)enterInfo.dbtype, enterInfo.dbserver, enterInfo.dbname, enterInfo.dbuser, enterInfo.dbpass))
{
qyconn.Open();
K8erp.Platform.Dal.BllTrade.DownFullTradeV2(qyconn, enterInfo.qyid, store, (x, y) =>
{
Console.WriteLine("ok={0} msg={1}", x, y);
});
}
}
private static void TestBeibeiWare()
{
var store = new K8erp.Platform.Domain.Store()
{
Dpid = 9990,
Dplx = K8erp.Platform.Domain.StoreTypeEmun.Mogujie,
Key1 = "",
Key2 = "",
Key3 = "ttt",
Key4 = "",
SellerId = "ttt",
Session = "517BAD1B9AF60730CB665135B812F292",
};
//EnterpriseDisWithDBInfoEntity enterInfo = new Ruanal.Job.ImpDispatchs.Entity.EnterpriseDisWithDBInfoEntity()
//{
// dbtype = 0,
// dbserver = "conn0894z4r7.sqlserver.rds.aliyuncs.com,3433",
// dbuser = "******",
// dbpass = "******",
// rdssl = "ins_0894z4r7",
// zzid = 1,
// qyid = 2,
// qybm = "test2",
// qymc = "test2",
// dbserverid = 2,
// dbname = "zhuidian_test2"
//};
EnterpriseDisWithDBInfoEntity enterInfo = new Ruanal.Job.ImpDispatchs.Entity.EnterpriseDisWithDBInfoEntity()
{
dbtype = 0,
dbserver = ".",
dbuser = "******",
dbpass = "******",
rdssl = "ins_0894z4r7",
zzid = 1,
qyid = 2,
qybm = "test2",
qymc = "test2",
dbserverid = 2,
dbname = "zhuidian_testqy1"
};
try
{
Console.WriteLine("开始...");
using (K8erp.Lib.Db.DbConn qyconn = K8erp.Lib.Db.DbConn.CreateConn(
(K8erp.Lib.Db.DbType)enterInfo.dbtype, enterInfo.dbserver, enterInfo.dbname, enterInfo.dbuser, enterInfo.dbpass))
{
qyconn.Open();
K8erp.Platform.Dal.BllWare2.DownloadWares(2, qyconn, store);
Console.WriteLine("完成全量！");
Console.ReadLine();
//K8erp.Platform.Dal.BllWare2.DownloadWares(0, qyconn, store);
//Console.WriteLine("完成online！");
//Console.ReadLine();
//K8erp.Platform.Dal.BllWare2.DownloadWares(1, qyconn, store);
//Console.WriteLine("完成stock！");
//Console.ReadLine();
//K8erp.Platform.Dal.BllWare2.DownloadWares(3, qyconn, store);
//Console.WriteLine("完成增量！");
//Console.ReadLine();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine(ex.StackTrace);
}
finally
{
Console.WriteLine("结束");
}
}
private static void CompareJsonStru()
{
Dictionary <string, KeyItem> aa = new Dictionary <string, KeyItem>();
var runConfig = new Ruanal.Job.ImpDispatchs.Entity.EnterpriseDisWithDBInfoEntity()
{
dbtype = 0,
dbserver = "conn0894z4r7.sqlserver.rds.aliyuncs.com",
dbuser = "******",
dbpass = "******",
rdssl = "ins_0894z4r7",
zzid = 1,
qyid = 3,
qybm = "yaoyao",
qymc = "要要童装",
dbserverid = 2,
dbname = "zhuidian_yaoyao"
};
int allcount = 0;
using (var db = RLib.DB.DbConn.CreateConn(RLib.DB.DbType.SQLSERVER,
"conn0894z4r7.sqlserver.rds.aliyuncs.com",
"3433", "sys_info", "zd_main", "Zdmain123456"))
{
db.Open();
string sql = "select jdp_response from [sys_info].[dbo].[jdp_tb_item]";
var jsons = db.SqlToModel <string>(sql, null);
allcount = jsons.Count;
foreach (string j in jsons)
{
var jobj = JObject.Parse(j);
List <string> result = GetJsonStruct("", jobj);
result = result.Distinct().ToList();
result.Sort();
var skey = string.Join("\r\n", result);
var key = skey.GetHashCode().ToString();
if (aa.ContainsKey(key))
{
aa[key].count++;
}
else
{
aa.Add(key, new KeyItem()
{
count = 1,
ps = result
});
}
}
}
Dictionary <string, ItemItem> bbb = new Dictionary <string, ItemItem>();
foreach (var a in aa)
{
foreach (var b in a.Value.ps)
{
if (bbb.ContainsKey(b))
{
bbb[b].containtcount += a.Value.count;
}
else
{
bbb.Add(b, new ItemItem()
{
containtcount = a.Value.count, item = b
});
}
}
}
var ccc = new
{
allcount = allcount,
items = bbb.Select(x => x.Value).Where(x => x.containtcount != allcount).OrderBy(x => x.containtcount).ToList()
};
System.IO.File.WriteAllText("E:\\result.com.result2.txt", RLib.Utils.DataSerialize.SerializeJsonBeauty(ccc),
System.Text.Encoding.GetEncoding("utf-8"));
System.IO.File.WriteAllText("E:\\result.com.result.txt", string.Join("\r\n\r\nr\n\r\n", aa.Select(x => string.Format("{0}\t{1}\r\n{2}", x.Key, x.Value.count, string.Join("\r\n", x.Value.ps)))),
System.Text.Encoding.GetEncoding("utf-8"));
}
