/// <summary> /// Установление признака детали в бд /// </summary> public static void UpdateIsCalculate(bool isCalculate, DetailCalculate detailCalculate) { var dbFolder = Properties.Settings.Default.FoxProDbFolder_Foxpro_Trudnorm; const string update = "UPDATE [izd_rasc] SET pr_rasc = ? WHERE detal = ?"; try { using (var oleDbConnection = DbControl.GetConnection(dbFolder)) { oleDbConnection.TryConnectOpen(); using (var oleDbCommand = new OleDbCommand(update, oleDbConnection)) { oleDbCommand.Parameters.AddWithValue("@pr_rasc", isCalculate ? "+" : ""); oleDbCommand.Parameters.AddWithValue("@detal", detailCalculate.CodeDetail); oleDbCommand.ExecuteNonQuery(); } } } catch (OleDbException ex) { throw DbControl.HandleKnownDbFoxProAndMssqlServerExceptions(ex); } }
/// <summary> /// Получение коллекции [Продуктов расчета сводных трудовых нормативов] /// </summary> public static List <DetailCalculate> GetAll() { var dbFolder = Properties.Settings.Default.FoxProDbFolder_Foxpro_Trudnorm; const string query = "SELECT detal, naim, obozn, pr_rasc FROM [izd_rasc]"; var detailCalculates = new List <DetailCalculate>(); try { using (var oleDbConnection = DbControl.GetConnection(dbFolder)) { oleDbConnection.TryConnectOpen(); oleDbConnection.VerifyInstalledEncoding("izd_rasc"); using (var oleDbCommand = new OleDbCommand(query, oleDbConnection)) { using (var reader = oleDbCommand.ExecuteReader()) { while (reader != null && reader.Read()) { var codeDetail = reader.GetDecimal(0); var name = reader.GetString(1).Trim(); var mark = reader.GetString(2).Trim(); var isCalculate = reader.GetString(3).Trim() == "+"; var detailCalculate = new DetailCalculate { CodeDetail = codeDetail, Name = name, Mark = mark, IsCalculate = isCalculate }; detailCalculates.Add(detailCalculate); } } } } return(detailCalculates); } catch (OleDbException ex) { throw DbControl.HandleKnownDbFoxProAndMssqlServerExceptions(ex); } }
/// <summary> /// Установление признака детали в бд /// </summary> public static void UpdateIsCalculate(bool isCalculate, DetailCalculate detailCalculate) { DetailCalculatesStorage.UpdateIsCalculate(isCalculate, detailCalculate); }