public void WriteLogToFile(AppLogStruct logStruct) { //using (StreamWriter errorLog = new StreamWriter("C:\\MiX.txt",true)) //{ // errorLog.WriteLine(logStruct.ClientTime.ToString()); // errorLog.WriteLine(logStruct.CName); // errorLog.WriteLine(logStruct.UName); // errorLog.WriteLine(logStruct.LogType); // errorLog.WriteLine(logStruct.Message); // errorLog.WriteLine("=================================="); //} }
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); }