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