//public int SetCylinderLoaded() //{ // DateTime unload = sql.ExecuteScalar<DateTime>("SELECT LastUnload FROM Cylinder WHERE Cylinder_Id=@0", Cylinder_ID); // DateTime now = DateTime.Now; // if (unload.Year != 2001) // { // if (now > unload) // { // TimeSpan t = now - unload; // double min = t.Minutes; // sql.Execute("UPDATE Cylinder SET Runtime = Runtime + @0 WHERE Cylinder_Id=@1", min, Cylinder_ID); // } // } // return sql.Execute("UPDATE Cylinder SET LastLoad=GETDATE() WHERE Cylinder_Id=@0", Cylinder_ID); //} //public int SetCylinderUnloaded() //{ // IncCylinderCycles(); // return sql.Execute("UPDATE Cylinder SET LastUnload=GETDATE() WHERE Cylinder_Id=" + Cylinder_ID); //} //public int SetCylinderMoved() //{ // IncCylinderCycles(); // return sql.Execute("UPDATE Cylinder SET LastMoved=GETDATE() WHERE Cylinder_Id=" + Cylinder_ID); //} //public int IncCylinderCycles() //{ // return sql.Execute("UPDATE Cylinder SET Cycles=Cycles+1 WHERE Cylinder_Id=" + Cylinder_ID); //} public static Dictionary <int, string> GetCylinderStates() { Dictionary <int, string> dic = new Dictionary <int, string>(); DataTable dt = MainDb.GetDataTable("SELECT * FROM CylinderStates ORDER BY ID"); foreach (DataRow row in dt.Rows) { dic.Add((int)row["ID"], (string)row["Name"]); } return(dic); }
private void BtnCopyData_Click(object sender, EventArgs e) { try { AddBackupLogText("start making backup copy"); DatabasePrepare(Registry.BackupDestinationConnection, Registry.BackupDestinationProvider); var srcdb = new BauerSql.MainDb(Registry.BackupSourceConnection, Registry.BackupSourceProvider); var destdb = new BauerSql.MainDb(Registry.BackupDestinationConnection, Registry.BackupDestinationProvider); destdb.BeginTransaction(); DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbAGVLocation)).TableName, destdb); foreach (var item in srcdb.Fetch <SqlDbAGVLocation>("")) { ReplaceWrongDate(item); destdb.Insert(item); } destdb.CompleteTransaction(); destdb.BeginTransaction(); DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbAlarm)).TableName, destdb); foreach (var item in srcdb.Fetch <SqlDbAlarm>("")) { ReplaceWrongDate(item); destdb.Insert(item); } destdb.CompleteTransaction(); destdb.BeginTransaction(); DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbCylinder)).TableName, destdb); foreach (var item in srcdb.Fetch <SqlDbCylinder>("")) { ReplaceWrongDate(item); destdb.Insert(item); if (chkCopyPictures.Checked) { if (srcdb.ExecuteScalar <int>("SELECT COUNT(*) FROM Cylinder WHERE Cylinder_ID=@0 AND NOT picture1 IS NULL", item.Cylinder_ID) == 1) { byte[] img = srcdb.ExecuteScalar <byte[]>("SELECT picture1 FROM Cylinder WHERE Cylinder_ID=@0", item.Cylinder_ID); destdb.Execute("UPDATE Cylinder SET picture1=@0 WHERE Cylinder_ID=@1", img, item.Cylinder_ID); } if (srcdb.ExecuteScalar <int>("SELECT COUNT(*) FROM Cylinder WHERE Cylinder_ID=@0 AND NOT picture2 IS NULL", item.Cylinder_ID) == 1) { byte[] img = srcdb.ExecuteScalar <byte[]>("SELECT picture2 FROM Cylinder WHERE Cylinder_ID=@0", item.Cylinder_ID); destdb.Execute("UPDATE Cylinder SET picture2=@0 WHERE Cylinder_ID=@1", img, item.Cylinder_ID); } } } destdb.CompleteTransaction(); if (chkCylinderMovement.Checked) { destdb.BeginTransaction(); DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbCylinderMovement)).TableName, destdb); foreach (var item in srcdb.Fetch <SqlDbCylinderMovement>("")) { ReplaceWrongDate(item); destdb.Insert(item); } destdb.CompleteTransaction(); } destdb.BeginTransaction(); DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbCylinderState)).TableName, destdb); foreach (var item in srcdb.Fetch <SqlDbCylinderState>("")) { ReplaceWrongDate(item); destdb.Insert(item); } destdb.CompleteTransaction(); if (chkCopyLog4Net.Checked) { destdb.BeginTransaction(); DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDblog4net)).TableName, destdb); foreach (var item in srcdb.Fetch <SqlDblog4net>("")) { ReplaceWrongDate(item); destdb.Insert(item); } destdb.CompleteTransaction(); } destdb.BeginTransaction(); DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbMachineInformation)).TableName, destdb); foreach (var item in srcdb.Fetch <SqlDbMachineInformation>("")) { ReplaceWrongDate(item); destdb.Insert(item); } destdb.CompleteTransaction(); destdb.BeginTransaction(); DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbMonitor)).TableName, destdb); foreach (var item in srcdb.Fetch <SqlDbMonitor>("")) { ReplaceWrongDate(item); destdb.Insert(item); } destdb.CompleteTransaction(); destdb.BeginTransaction(); DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbRack)).TableName, destdb); foreach (var item in srcdb.Fetch <SqlDbRack>("")) { ReplaceWrongDate(item); destdb.Insert(item); } destdb.CompleteTransaction(); destdb.BeginTransaction(); DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbRackUser)).TableName, destdb); foreach (var item in srcdb.Fetch <SqlDbRackUser>("")) { ReplaceWrongDate(item); destdb.Insert(item); } destdb.CompleteTransaction(); if (chkOrders.Checked) { destdb.BeginTransaction(); DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbStorageOrder)).TableName, destdb); foreach (var item in srcdb.Fetch <SqlDbStorageOrder>("")) { ReplaceWrongDate(item); destdb.Insert(item); } destdb.CompleteTransaction(); } destdb.BeginTransaction(); DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbUnit)).TableName, destdb); foreach (var item in srcdb.Fetch <SqlDbUnit>("")) { ReplaceWrongDate(item); destdb.Insert(item); } destdb.CompleteTransaction(); if (chkUnitFlow.Checked) { destdb.BeginTransaction(); DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbUnitFlow)).TableName, destdb); foreach (var item in srcdb.Fetch <SqlDbUnitFlow>("")) { ReplaceWrongDate(item); destdb.Insert(item); } destdb.CompleteTransaction(); } if (chkUnitMoves.Checked) { destdb.BeginTransaction(); DeleteFrom(destdb.DefaultMapper.GetTableInfo(typeof(SqlDbUnitMove)).TableName, destdb); foreach (var item in srcdb.Fetch <SqlDbUnitMove>("")) { ReplaceWrongDate(item); destdb.Insert(item); } destdb.CompleteTransaction(); } srcdb.CloseSharedConnection(); destdb.CloseSharedConnection(); if (Registry.BackupDestinationProvider.ToLowerInvariant() == "sqlite") { string fname = Registry.BackupDestinationConnection.ToLower().Trim().Replace("data source=", "").Replace(";", ""); if (File.Exists(fname)) { string new_name = fname.Replace(".sqlite", DateTime.Now.ToString("_yyyy_MM_dd__HH_mm_ss") + ".sqlite"); File.Move(fname, new_name); } } AddBackupLogText("ready making backup copy"); } catch (Exception ex) { AddBackupLogText("exception making backup copy " + ex.Message); } }