private entity.CainzTrader GetTraaterByFactoryName(string factoryName)
{
factoryName = factoryName.Replace('C', ' ').Trim();
CainzTrader trader = new CainzTrader();
string traderName = FindTraderByFactory(factoryName, gGongChangDic);
using (var db = new DB())
{
if (traderName != "")
{
trader = db.CainzTrader.SingleOrDefault(item => item.TraderName == traderName);
}
else
{
trader = null;
using (StreamWriter w = new StreamWriter("log3.txt", true))
{
w.WriteLine(factoryName + "," + stringZip(factoryName));
}
}
}
return trader;
}
//导入 到新表 Trader
private void btnCainzMaoyis_Click(object sender, EventArgs e)
{
using (var db = PublicDB.getDB())
{
//遍历贸易商表列表,通过名称查找，如果不存在则添加
foreach (var Trader in gMaoYiShangDic)
{
string traderName = Trader.Key;
CainzTrader cusc = db.CainzTrader.FirstOrDefault(item => item.TraderName == traderName);
if (cusc == null)
{
CainzTrader cc = new CainzTrader();
cc.TraderID = Guid.NewGuid();
cc.TraderName = Trader.Key.ToString().Trim();
cc.TraderShortName = PublicTools.stringZip(cc.TraderName);
cc.CreateTime = DateTime.Now;
cc.IsDelete = 0;
db.CainzTrader.Add(cc);
}
}
db.SaveChanges();
}
}
