/// <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);
}
