//根据同义词查词汇名称 public String getWordNameBySynonym(String synonymName) { if (String.IsNullOrWhiteSpace(synonymName)) { return(String.Empty); } if (!BaseInfo.synonymDic.ContainsKey(synonymName)) { return(synonymName); } t_synonym synonym = BaseInfo.synonymDic[synonymName]; if (String.IsNullOrWhiteSpace(synonym.code)) { return(synonymName); } t_word_synonym word_synonym = wsdao.getDataByCode(synonym.code); if (String.IsNullOrWhiteSpace(word_synonym.word_code)) { return(synonymName); } if (!BaseInfo.wordDic.ContainsKey(word_synonym.word_code)) { return(synonymName); } return(BaseInfo.wordDic[word_synonym.word_code].name); }
//根据活动名称查询活动 public t_activity getActivityByName(String activityName) { if (String.IsNullOrWhiteSpace(activityName)) { return(null); } if (!BaseInfo.synonymDic.ContainsKey(activityName)) { return(null); } t_synonym synonym = BaseInfo.synonymDic[activityName]; if (String.IsNullOrWhiteSpace(synonym.code)) { return(null); } t_word_synonym word_synonym = wsdao.getDataByCode(synonym.code); if (String.IsNullOrWhiteSpace(word_synonym.word_code)) { return(null); } if (!BaseInfo.activityDic.ContainsKey(word_synonym.word_code)) { return(null); } return(BaseInfo.activityDic[word_synonym.word_code]); }
//根据基础信息名称查询基础信息 public t_basic_info getBasicInfoByName(String basicInfoName) { if (String.IsNullOrWhiteSpace(basicInfoName)) { return(null); } if (!BaseInfo.synonymDic.ContainsKey(basicInfoName)) { return(null); } t_synonym synonym = BaseInfo.synonymDic[basicInfoName]; if (String.IsNullOrWhiteSpace(synonym.code)) { return(null); } t_word_synonym word_synonym = wsdao.getDataByCode(synonym.code); if (String.IsNullOrWhiteSpace(word_synonym.word_code)) { return(null); } if (!BaseInfo.basicInfoDic.ContainsKey(word_synonym.word_code)) { return(null); } return(BaseInfo.basicInfoDic[word_synonym.word_code]); }
public void ttt() { ReadProduct rf = new ReadProduct(); HashSet <string> set = new HashSet <string>(); foreach (string s in ReadProduct.list) { //Debug.WriteLine(s); set.Add(s.Split(',')[1]); } BaseInfo bi = new BaseInfo(); bi.init(); SearchService ss = new SearchService(); SynonymDao synonymDao = new SynonymDao(); WordDao wordDao = new WordDao(); WordSynonymDao wsDao = new WordSynonymDao(); int i = 50000; foreach (string s in set) { //Debug.WriteLine(s); t_word word = ss.getWordBySynonym(s); if (null == word) { Debug.WriteLine(s + "没有对应Word"); t_synonym t_synonym = new t_synonym() { code = i + "", name = s, remark = "" }; t_word t_word = new t_word() { code = i + "", type = "单品", name = s, remark = "" }; t_word_synonym t_word_synonym = new t_word_synonym() { word_code = i + "", synonym_code = i + "" }; synonymDao.add(t_synonym); wordDao.add(t_word); wsDao.add(t_word_synonym); Debug.WriteLine("添加成功"); i++; } else { Debug.WriteLine(s + "对应" + word.name + word.code); } } }
public void add(t_synonym po) { crm1Entities context = new crm1Entities(); //3.将改对象放入EF容器中,默认会为该对象加一个封装类对象(代理类对象) //用户对对象的操作,实际上是对代理类的操作 //DbEntityEntry保存着实体状态,当对象被加入时,EF默认为该对象设置State的属性为unchanged DbEntityEntry <t_synonym> entityEntry = context.Entry <t_synonym>(po); Debug.WriteLine(po.code + po.name); //4.设置对象的标志位Added entityEntry.State = EntityState.Added; //5.当调用SaveChanges()时,EF会遍历所有的代理类对象,并根据标志生成相应的sql语句 context.SaveChanges(); //Console.WriteLine("添加成功"); }
public void test1Test() { try { BaseInfo bi = new BaseInfo(); bi.init(); SearchService ss = new SearchService(); SynonymDao synonymDao = new SynonymDao(); WordDao wordDao = new WordDao(); WordSynonymDao wsDao = new WordSynonymDao(); ActivityDao activityDao = new ActivityDao(); ReadActivity rf = new ReadActivity(); if (null != ReadActivity.dic) { int i = 30000; foreach (Activity obj in ReadActivity.dic.Values) { Debug.WriteLine(obj.ToString()); t_synonym t_synonym = new t_synonym() { code = i + "", name = obj.Word, remark = "" }; t_word t_word = new t_word() { code = i + "", type = "活动", name = obj.Word, remark = "" }; t_word_synonym t_word_synonym = new t_word_synonym() { word_code = i + "", synonym_code = i + "" }; //t_brand t_brand = new t_brand { code = i + "", brand = i + "", floor = ss.getWordBySynonym(b.Floor).code, contract = b.BrandCode, house_number = b.UnitNumber, vip_flag = "特约商户".Equals(b.VipFee) ? 1 : 0 }; DateTimeFormatInfo dtFormat = new DateTimeFormatInfo(); dtFormat.ShortDatePattern = "MM/dd/yyyy"; t_activity t_activity = new t_activity { code = i + "", activity = i + "", floor = String.IsNullOrEmpty(obj.Floor)? "" : ss.getWordBySynonym(obj.Floor).code, basic_info = String.IsNullOrEmpty(obj.BasicInfo) ? "" : ss.getWordBySynonym(obj.BasicInfo).code, remark = obj.Remark, begin = Convert.ToDateTime(obj.Begin, dtFormat), end = Convert.ToDateTime(obj.End, dtFormat) }; synonymDao.add(t_synonym); wordDao.add(t_word); wsDao.add(t_word_synonym); activityDao.add(t_activity); Debug.WriteLine("添加成功"); i++; } } else { Debug.WriteLine("dic = null" + " ; path = " + ReadActivity.path); } } catch (DbEntityValidationException ex) { Debug.WriteLine(ex.ToString()); StringBuilder errors = new StringBuilder(); IEnumerable <DbEntityValidationResult> validationResult = ex.EntityValidationErrors; foreach (DbEntityValidationResult result in validationResult) { ICollection <DbValidationError> validationError = result.ValidationErrors; foreach (DbValidationError err in validationError) { errors.Append(err.PropertyName + ":" + err.ErrorMessage + "\r\n"); } } Debug.WriteLine(errors.ToString()); //简写 //var validerr = ex.EntityValidationErrors.First().ValidationErrors.First(); //Console.WriteLine(validerr.PropertyName + ":" + validerr.ErrorMessage); } catch (Exception ex) { Debug.WriteLine(ex.Message); } }
public void test1Test() { try { BaseInfo bi = new BaseInfo(); bi.init(); SearchService ss = new SearchService(); SynonymDao synonymDao = new SynonymDao(); WordDao wordDao = new WordDao(); WordSynonymDao wsDao = new WordSynonymDao(); BrandDao brandDao = new BrandDao(); ReadFile rf = new ReadFile(); if (null != ReadFile.brandDic) { int i = 20000; foreach (Brand b in ReadFile.brandDic.Values) { Debug.WriteLine(b.ToString()); t_synonym t_synonym = new t_synonym() { code = i + "", name = b.BrandName, remark = "" }; t_word t_word = new t_word() { code = i + "", type = "品牌", name = b.BrandName, remark = "" }; t_word_synonym t_word_synonym = new t_word_synonym() { word_code = i + "", synonym_code = i + "" }; t_brand t_brand = new t_brand { code = i + "", brand = i + "", floor = ss.getWordBySynonym(b.Floor).code, contract = b.BrandCode, house_number = b.UnitNumber, vip_flag = "特约商户".Equals(b.VipFee) ? 1 : 0 }; synonymDao.add(t_synonym); wordDao.add(t_word); wsDao.add(t_word_synonym); brandDao.add(t_brand); Debug.WriteLine("添加成功"); i++; } } else { Debug.WriteLine("brandDic = null" + " ; path = " + ReadFile.path); } } catch (DbEntityValidationException ex) { Debug.WriteLine(ex.ToString()); StringBuilder errors = new StringBuilder(); IEnumerable <DbEntityValidationResult> validationResult = ex.EntityValidationErrors; foreach (DbEntityValidationResult result in validationResult) { ICollection <DbValidationError> validationError = result.ValidationErrors; foreach (DbValidationError err in validationError) { errors.Append(err.PropertyName + ":" + err.ErrorMessage + "\r\n"); } } Debug.WriteLine(errors.ToString()); //简写 //var validerr = ex.EntityValidationErrors.First().ValidationErrors.First(); //Console.WriteLine(validerr.PropertyName + ":" + validerr.ErrorMessage); } }