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