private int UpdateDatabase(int DBV)
{
string S_read = "", S_tmp;
int dbversion = 0;
string filename = Directory.GetCurrentDirectory() + "\\DatabaseUpdate.txt", sql;
StreamReader SR = new StreamReader(@filename);
SQLiteCommand sqlcomm = new SQLiteCommand(SQLConnect);
S_read = SR.ReadToEnd();
SR.Close();
S_read = S_read.Replace("\r\n", " ");
while (S_read.IndexOf("}") > 0)
{
S_tmp = S_read.Substring(0, S_read.IndexOf("}") + 1);
S_read = S_read.Substring(S_read.IndexOf("}") + 1);
try
{
dbversion = Convert.ToInt16(S_tmp.Substring(S_tmp.IndexOf("[") + 1, S_tmp.IndexOf("]") - S_tmp.IndexOf("[") - 1).Trim());
}
catch
{
return(-1);
}
if (dbversion <= DBV)
{
continue;
}
int s = S_tmp.IndexOf("{") + 1;
int e = S_tmp.IndexOf("}") - s - 1;
S_tmp = S_tmp.Substring(s, e);
while (S_tmp.IndexOf(";") > 0)
{
sql = S_tmp.Substring(0, S_tmp.IndexOf(";"));
S_tmp = S_tmp.Substring(S_tmp.IndexOf(";") + 1);
sqlcomm.CommandText = sql;
try
{
sqlcomm.ExecuteNonQuery();
}
catch (Exception ex)
{
GlobalValue.WriteLog(DateTime.Now.ToString() + ":SQL" + sql + ":" + ex.Message.ToString(), logfile);
continue;
}
}
}
sql = "update TAT_Dictonary set kvalue = '" + dbversion + "' where ktype='DBV' and Kname='DatabaseVersion'";
sqlcomm.CommandText = sql;
sqlcomm.ExecuteNonQuery();
return(0);
}
public SocketClient(string IpAddress, Int32 PortNo)
{
Ipadressport = IpAddress + ":" + PortNo;
this.ipendpoint = new IPEndPoint(IPAddress.Parse(IpAddress), PortNo);
this.clientthread = new Thread(new ThreadStart(ClientThread));
this.clientthread.IsBackground = true;
this.LogFolder = GlobalValue.LogPath + "\\CPORT" + PortNo + "\\";
GlobalValue.CreateFolder(this.LogFolder);
this.LogFile = LogFolder + DateTime.Today.ToString("yyyyMMdd", System.Globalization.DateTimeFormatInfo.InvariantInfo) + DateTime.Now.ToString("HHmmss", System.Globalization.DateTimeFormatInfo.InvariantInfo) + ".TXT";
clientthread.Start();
;
}
public int ExecuteSQL(string sql)
{
SQLiteCommand sqlcomm = new SQLiteCommand(SQLConnect);
try
{
sqlcomm.CommandText = sql;
sqlcomm.ExecuteNonQuery();
}
catch (Exception ex)
{
GlobalValue.WriteLog(DateTime.Now.ToString() + ":SQL" + sql + ":" + ex.Message.ToString(), logfile);
return(-1);
}
sqlcomm.Dispose();
return(0);
}
public Boolean initport(int port)
{
checkport(port);
if (!portinuse)
{
this.listener1 = new TcpListener(IPAddress.Any, port);
this.listenserthread1 = new Thread(new ThreadStart(openport));
this.listenserthread1.IsBackground = true;
this.LogFolder = GlobalValue.LogPath + "\\SPORT" + port + "\\";
GlobalValue.CreateFolder(this.LogFolder);
this.LogFile = LogFolder + DateTime.Today.ToString("yyyyMMdd", System.Globalization.DateTimeFormatInfo.InvariantInfo) + DateTime.Now.ToString("HHmmss", System.Globalization.DateTimeFormatInfo.InvariantInfo) + ".TXT";
listenserthread1.Start();
}
return(true);
}
public int GetSelectValue(string sql)
{
SQLiteCommand sqlcom = new SQLiteCommand(sql, SQLConnect);
SQLiteDataReader reader = sqlcom.ExecuteReader();
int count = 0;
reader.Read();
try
{
if (reader.HasRows)
{
count = reader.GetInt32(0);
}
}
catch (Exception ex)
{
GlobalValue.WriteLog(DateTime.Now.ToString() + ":SQL" + sql + ":" + ex.Message.ToString(), logfile);
count = 0;
}
reader.Close();
sqlcom.Dispose();
return(count);
}
public void LOG(string msg, string type)
{
msg = DateTime.Today.ToLongDateString() + " " + DateTime.Now.ToLongTimeString() + " " + type + " : " + msg;
GlobalValue.WriteLog(msg, LogFile);
this.log += GlobalValue.ReplaceASCII(msg) + GlobalValue.CR + GlobalValue.LF;
}