public static List <HuInfo> GetAllHuInfo() { List <HuInfo> result = null; string sql = "select HU,QTY,Result,Timestamp from HuList"; DataTable dt = SqliteDBHelp.GetTable(sql); if (dt != null && dt.Rows.Count > 0) { result = new List <HuInfo>(); foreach (DataRow row in dt.Rows) { HuInfo hu = new HuInfo() { HU = row["HU"].ToString(), QTY = (int)row["QTY"], Result = row["Result"].ToString(), Timestamp = DateTime.Parse(row["Timestamp"].ToString()) }; if (!result.Exists(i => i.HU == hu.HU)) { result.Add(hu); } } } return(result); }
/// <summary> /// 获取本地sqlite未上传sap发运箱信息列表 /// </summary> /// <returns></returns> public static List <UploadPKBoxInfo> GetUnUploadPKBox() { string sql = string.Format("SELECT Guid,Data,IsUpload,CreateTime FROM UploadData"); DataTable dt = SqliteDBHelp.GetTable(sql); if (dt != null && dt.Rows.Count > 0) { List <UploadPKBoxInfo> result = new List <UploadPKBoxInfo>(); foreach (DataRow row in dt.Rows) { result.Add((JsonConvert.DeserializeObject <UploadPKBoxInfo>(row["Data"].ToString()))); } return(result); } return(null); }
public static List <UploadData> GetUnUploadDataList() { //string sql = string.Format("DELETE FROM UploadData WHERE IsUpload=1;SELECT Guid,Data,IsUpload,CreateTime FROM UploadData WHERE IsUpload = 0"); string sql = string.Format("SELECT Guid,Data,IsUpload,CreateTime FROM UploadData"); DataTable dt = SqliteDBHelp.GetTable(sql); if (dt != null && dt.Rows.Count > 0) { List <UploadData> result = new List <UploadData>(); foreach (DataRow row in dt.Rows) { UploadData ud = new UploadData(); ud.Guid = row["Guid"].ToString(); ud.Data = JsonConvert.DeserializeObject <ResultDataInfo>(row["Data"].ToString()); ud.IsUpload = uint.Parse(row["IsUpload"].ToString()); ud.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); result.Add(ud); } return(result); } return(null); }
public static List <CUploadData> GetAllUploadFromSqlite <T>() { List <CUploadData> result = new List <CUploadData>(); string sql = string.Format("SELECT Guid,Data,IsUpload,CreateTime,MSG FROM UploadData order by CreateTime"); DataTable dt = SqliteDBHelp.GetTable(sql); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { CUploadData ud = new CUploadData(); ud.Guid = row["Guid"].ToString(); ud.Data = JsonConvert.DeserializeObject <T>(row["Data"].ToString()); ud.IsUpload = uint.Parse(row["IsUpload"].ToString()); ud.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); ud.MSG = row["MSG"].ToString(); result.Add(ud); } return(result); } return(result); }