//根据同义词查词汇名称
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);
}
}
