public App() { CheckSingleThread(); CheckMode = 0; CurrentUser = null; dp = BarcodeDataProviderClass.Create(); appLog = dp.RefreshBarCodeTable("select * from AppLog where SN >", "AppLog"); }
public void WriteLogToDB(AppLogStruct logStruct) { AppLogStruct log = logStruct; string sql = "INSERT INTO AppLog(CName,UName,LogType,ClientTime,DBTime,Message)" + "VALUES ('" + log.CName + "','" + log.UName + "','" + log.LogType + "','" + log.ClientTime.ToString("yyyy-MM-dd HH:mm:ss") + "',getdate(),'" + log.Message + "')"; if (dp == null) { dp = BarcodeDataProviderClass.Create(); } //MessageBox.Show(sql); dp.InsertBySql(sql); }