/// <summary> /// 保存快件信息到本地 /// </summary> public ExpressInfo submitStoreExpress(JObject info) { if (info == null) { return(null); } var ps = string.Empty; var colstr = string.Empty; var param = new List <object>(); try { var i = 0; foreach (var item in info) { ps += "{" + (i++) + "},"; colstr += "`" + (item.Key.Length > 2 ? (item.Key.Substring(0, 2) + "_" + item.Key.Substring(2)) : item.Key) + "`,"; param.Add(item.Value); } ps = ps.Trim(','); colstr = colstr.Trim(','); var sql = @"REPLACE INTO `ebox_expresinfo` (" + colstr + @") VALUES (" + ps + ");"; db.ExecuteCommand(sql, param.ToArray()); db.SubmitChanges(); var newId = Convert.ToInt32(info.GetValue("eiId")); return(sqliteU.getExpressInfo("where EI_ID = " + newId)); } catch (Exception ex) { LogHelper.Log("保存终端快件信息异常", ex); return(null); } }