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