/// <summary> /// 添加快递查询到数据库 /// </summary> /// <param name="mailNo"></param> /// <param name="expSpellName"></param> /// <param name="expTextName"></param> /// <param name="update"></param> /// <param name="updateStr"></param> /// <param name="dataList"></param> private string InserExpressSearch(string mailNo, string expSpellName, string expTextName, string update, string updateStr, bool flag, int status, string tel, JsonData dataList) { //是否已经查询 Models.SysExpressSearch searchModel = FindEntity("{\"MailNo\":\"" + mailNo + "\",\"ExpSpellName\":\"" + expSpellName + "\"}"); if (searchModel == null)//第一次查询 { //添加查询记录 searchModel = new Models.SysExpressSearch(); searchModel.MailNo = mailNo; searchModel.ExpSpellName = expSpellName; searchModel.ExpTextName = expTextName; searchModel.Tel = tel; searchModel.LastQueryTime = update; searchModel.UpdateStr = updateStr; searchModel.Flag = flag; searchModel.Status = status; Insert(searchModel); } else //修改 { searchModel.Flag = flag; searchModel.Status = status; searchModel.LastQueryTime = update; searchModel.UpdateStr = updateStr; UpdateForm(searchModel); } List <Models.SysExpressSearchInfo> infoList = GetListInfo("{\"MailNo\":\"" + mailNo + "\"}"); //添加详细信息 for (int i = 0; i < dataList.Count; i++) { int x = 0; foreach (Models.SysExpressSearchInfo info in infoList) { if (info.mailNo == mailNo && info.AddTime == Utils.ObjectToDateTime(dataList[i]["time"]) && info.context == Utils.ObjectToStr(dataList[i]["context"])) { x++; break; } } if (x == 0) { Models.SysExpressSearchInfo infoModel = new Models.SysExpressSearchInfo(); infoModel.mailNo = mailNo; infoModel.AddTime = Utils.ObjectToDateTime(dataList[i]["time"]); infoModel.context = Utils.ObjectToStr(dataList[i]["context"]); infoModel.SysExpressSearchId = searchModel.SysExpressSearchId; InsertInfo(infoModel); infoList.Add(infoModel); } x = 0; } searchModel.InfoList = infoList; return(SearchDataBase(searchModel)); }
/// <summary> /// 新增 /// </summary> public int InsertInfo(Models.SysExpressSearchInfo model) { Models.ApplicationDbContext dbContext = new Models.ApplicationDbContext(); dbContext.expressSearchInfo.Add(model); return(dbContext.SaveChanges()); }