public static RecloserSettings SaveRecloserSettings(RecloserSettings mySettings) { RecloserSettings realSettings = mySettings; int realId; using (IQueryAdapter dbClient = Core.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("INSERT INTO ajustes_linha (creation_service, ftemp_pickup, ftemp_curve, ftemp_dial, ftemp_mrt, finst_pickup," + "ntemp_pickup, ntemp_curve, ntemp_dial, ntemp_mrt, ninst_pickup, class, num_op, temp_op_1, temp_op_2, temp_op_3, temp_rearm) VALUES " + "(@scres,@ftp,@ftc,@ftd,@ftm,@ftip,@ntp,@ntc,@ntd,@ntm,@ntip,@sclass,@snum,@top1,@top2,@top3,@tr);"); dbClient.AddParameter("scres", mySettings.CreationService); dbClient.AddParameter("ftp", mySettings.PhasePickUp); dbClient.AddParameter("ftc", mySettings.PhaseCurveId); dbClient.AddParameter("ftd", mySettings.PhaseDial); dbClient.AddParameter("ftm", mySettings.PhaseMRT); dbClient.AddParameter("ftip", mySettings.InstantPhasePickUp); dbClient.AddParameter("ntp", mySettings.NeutralPickUp); dbClient.AddParameter("ntc", mySettings.NeutralCurveId); dbClient.AddParameter("ntd", mySettings.NeutralDial); dbClient.AddParameter("ntm", mySettings.NeutralMRT); dbClient.AddParameter("ntip", mySettings.InstantNeutralPickUp); dbClient.AddParameter("sclass", mySettings.Class); dbClient.AddParameter("snum", mySettings.NumberOfOperations); dbClient.AddParameter("top1", mySettings.Operation1Time); dbClient.AddParameter("top2", mySettings.Operation2Time); dbClient.AddParameter("top3", mySettings.Operation3Time); dbClient.AddParameter("tr", mySettings.Rearm); realId = Convert.ToInt32(dbClient.InsertQuery()); } realSettings.Id = realId; return(realSettings); }
public static void LinkRecloserSettings(Recloser myRecloser, RecloserSettings mySettings) { if (mySettings.Status == 1) { List <RecloserSettings> disablabeList = myRecloser.Settings.Where(x => x.Status == 1).ToList(); foreach (RecloserSettings rs in disablabeList) { DisableSettings(myRecloser, rs); } } using (IQueryAdapter dbClient = Core.GetDatabaseManager().GetQueryReactor()) { if (!(mySettings == null) && !(myRecloser == null)) { dbClient.SetQuery("INSERT INTO link_ajustes_linha (settings_id,recloser_id,status,ts) VALUES (@sid,@rid,@st,@dt);"); dbClient.AddParameter("sid", mySettings.Id); dbClient.AddParameter("rid", myRecloser.Id); dbClient.AddParameter("st", mySettings.Status); dbClient.AddParameter("dt", mySettings.CreationDate); dbClient.RunQuery(); Core.GetRecloserManager().AddNewSettings(myRecloser.Number, mySettings); } } }
public static void DisableSettings(Recloser myRecloser, RecloserSettings mySettings) { if (mySettings.Status != 0) { using (IQueryAdapter dbClient = Core.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("UPDATE link_ajustes_linha SET status = 0 WHERE settings_id = @rsi;"); dbClient.AddParameter("rsi", mySettings.Id); dbClient.RunQuery(); } Core.GetRecloserManager().LoadedReclosers[Core.GetRecloserManager().GetRecloserIndex(myRecloser.Number)].DisableSettings(mySettings); } }