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(); } }