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 void delOldData(int day = 3)
{
try
{
string sql = string.Format("delete from UploadData where CreateTime < date('now', '-{0} day')", day);
SqliteDBHelp.ExecuteSql(sql);
}
catch (Exception)
{
}
}
public static void saveToSqlite(CUploadData d)
{
string sql = string.Format("INSERT INTO UploadData(Guid,Data,IsUpload,CreateTime,HU) VALUES('{0}','{1}',0,'{2}')", d.Guid
, JsonConvert.SerializeObject(d.Data), d.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"), d.HU);
int result = SqliteDBHelp.ExecuteSql(sql);
if (result <= 0)
{
Log4netHelper.LogInfo(JsonConvert.SerializeObject(d.Data));
}
}
public static bool delUploadFromSqlite(string guid)
{
string sql = string.Format("DELETE FROM UploadData WHERE Guid='{0}'", guid);
int result = SqliteDBHelp.ExecuteSql(sql);
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
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);
}
public static List <CUploadData> GetExpUploadFromSqlite <T>()
{
List <CUploadData> result = new List <CUploadData>();
string sql = string.Format("SELECT * FROM UploadData where IsUpload = 1 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.HU = row["HU"].ToString();
ud.MSG = row["MSG"].ToString();
result.Add(ud);
}
return(result);
}
return(result);
}
public static void updateMsgToSqlite(string guid, string msg)
{
string sql = string.Format("update UploadData set MSG='{0}',IsUpload=1 WHERE GUID='{1}'", msg, guid);
SqliteDBHelp.ExecuteSql(sql);
}
