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);
}
}
}
private void setSynonymDic()
{
//因为是顾客说的，所以要用name做KEY
SynonymDao dao = new SynonymDao();
List <t_synonym> list = dao.getAllData();
foreach (t_synonym po in list)
{
if (String.IsNullOrWhiteSpace(po.name))
{
continue;
}
if (synonymDic.ContainsKey(po.name))
{
synonymDic[po.name] = po;
}
else
{
synonymDic.Add(po.name, po);
}
}
}
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);
}
}
