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