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