public static void SaveDbInfo(string conn, string dbtag, int dbversion, string outdbtag, int outdbversion)
{
TableMySQL sqltable = new TableMySQL(conn);
string sql = string.Format("delete from db_info ;\r\n insert into db_info values('{0}',{1},'{2}',{3})", new object[]
{
dbtag,
dbversion,
outdbtag,
outdbversion
});
sqltable.ExecuteNonQuery(sql);
}
public static string[] GetDbInfo(string conn)
{
TableMySQL sqltable = new TableMySQL(conn);
string sql = "CREATE TABLE if not exists `db_info` (\n `tag` VARCHAR(50) NOT NULL DEFAULT '' ,\n `version` INT NULL DEFAULT 0 ,\n `outtag` VARCHAR(50) NOT NULL DEFAULT '' ,\n `outversion` INT NULL DEFAULT 0 ,\n PRIMARY KEY (`tag`) );";
sqltable.ExecuteNonQuery(sql);
DataTable dt = sqltable.Get("select * from db_info");
string[] result = new string[]
{
"",
"0",
"",
"0"
};
if (dt.Rows.Count > 0)
{
result[0] = ((dt.Rows[0]["tag"] == DBNull.Value) ? "0" : dt.Rows[0]["tag"].ToString());
result[1] = ((dt.Rows[0]["version"] == DBNull.Value) ? "0" : dt.Rows[0]["version"].ToString());
result[2] = ((dt.Rows[0]["outtag"] == DBNull.Value) ? "" : dt.Rows[0]["outtag"].ToString());
result[3] = ((dt.Rows[0]["outversion"] == DBNull.Value) ? "0" : dt.Rows[0]["outversion"].ToString());
}
return(result);
}
