public static int GetExpUploadCount() { int re = 0; string sql = string.Format("SELECT count(*) FROM UploadData where IsUpload = 1 order by CreateTime"); int.TryParse(SqliteDBHelp.GetValue(sql).ToString(), out re); return(re); }
public static int GetUploadDataCount() { try { string sql = string.Format("SELECT COUNT(*) FROM UploadData"); return(Convert.ToInt32(SqliteDBHelp.GetValue(sql))); } catch (Exception) { return(0); } }
public static bool CreateHuListTable() { string sql = string.Format("SELECT COUNT(*) FROM sqlite_master where type='table' and name='HuList'"); if (Convert.ToInt32(SqliteDBHelp.GetValue(sql)) == 0) { //创建HuList表 sql = "create table HuList(Hu VARCHAR primary key,QTY INT,Result VARCHAR,Timestamp DATETIME)"; SqliteDBHelp.ExecuteSql(sql); } return(true); }
public static int GetUnUploadCountFromSqlite() { try { string sql = string.Format("SELECT count(*) FROM UploadData where IsUpload=0"); object re = SqliteDBHelp.GetValue(sql); if (re != null) { int reint = 0; int.TryParse(re.ToString(), out reint); return(reint); } } catch (Exception e) { Log4netHelper.LogError(e); } return(0); }