/// <summary>Завершення заміни</summary> private void finishingReplaceLamps() { object[] result = null; using ( SqlCeCommand query = dbWorker.NewQuery( @"SELECT Map, Register, Position, Status, SyncRef FROM Cases WHERE RTRIM(BarCode)=RTRIM(@Old)")) { query.AddParameter("Old", ExistLampBarCode); result = query.SelectArray(); } if (result != null) { int map = Convert.ToInt32(result[0]); int register = Convert.ToInt32(result[1]); int position = Convert.ToInt32(result[2]); Cases.ChangeLighterState(NewLampBarCode, TypesOfLampsStatus.IsWorking, false, map, register, position); Cases.ChangeLighterState(ExistLampBarCode, TypesOfLampsStatus.Storage, true); //Внесение записи в "Перемещение" string newLampRef = BarcodeWorker.GetRefByBarcode(typeof(Cases), NewLampBarCode); Movement.RegisterLighter(ExistLampBarCode, result[4].ToString(), OperationsWithLighters.Removing, map, register, position); Movement.RegisterLighter(NewLampBarCode, newLampRef, OperationsWithLighters.Installing, map, register, position); } }
/// <summary>Сохранение размещения светильника</summary> public void FinishedInstaling() { Cases.ChangeLighterState(LightBarcode, TypesOfLampsStatus.IsWorking, false); using (SqlCeCommand query = dbWorker.NewQuery( "UPDATE Cases SET Map=@Map,Register=@Register,Position=@Position,DateOfActuality=@DateOfActuality WHERE RTRIM(Barcode)=RTRIM(@Barcode)") ) { query.AddParameter("Map", MapId); query.AddParameter("Register", ResultParameters[1]); query.AddParameter("Position", ResultParameters[2]); query.AddParameter("Barcode", LightBarcode); query.AddParameter("DateOfActuality", DateTime.Now); query.ExecuteNonQuery(); } object syncRefObj = null; using (SqlCeCommand query = dbWorker.NewQuery("SELECT SyncRef FROM Cases WHERE RTRIM(Barcode)=RTRIM(@Barcode)")) { query.AddParameter("Barcode", LightBarcode); syncRefObj = query.ExecuteScalar(); } string syncRef = syncRefObj == null ? string.Empty : syncRefObj.ToString(); //Внесение записи в "Перемещение" Movement.RegisterLighter(LightBarcode, syncRef, OperationsWithLighters.Installing, (int)MapId, Convert.ToInt32(ResultParameters[1]), Convert.ToInt32(ResultParameters[2])); }
/// <summary>Завершение (Сохранение)</summary> private void finish() { Cases.ChangeLighterState(LightBarcode, TypesOfLampsStatus.Storage, true); string syncRef = null; using ( SqlCeCommand query = dbWorker.NewQuery("SELECT SyncRef FROM Cases WHERE RTRIM(Barcode)=RTRIM(@Barcode)") ) { query.AddParameter("Barcode", LightBarcode); object syncRefObj = query.ExecuteScalar(); syncRef = syncRefObj == null ? string.Empty : syncRefObj.ToString(); } //Внесение записи в "Перемещение" Movement.RegisterLighter(LightBarcode, syncRef, OperationsWithLighters.Removing, map, register, position); }