public static ObservableCollection <NomenclatureClass> GetAllNomenclaturesBack(ref Guid GroupID, ref Guid ID) { ObservableCollection <NomenclatureClass> list = new ObservableCollection <NomenclatureClass>(); using (SqlConnection connect = new SqlConnection(Cryption.Decrypt(XmlClass.GetSelectedConnectionString()))) { try { connect.Open(); SqlCommand command = new SqlCommand("GetAllNomenclaturesBack", connect); command.CommandType = CommandType.StoredProcedure; SqlParameter Param0 = new SqlParameter { ParameterName = "@GroupID", Value = GroupID }; //---Передаваемый параметр command.Parameters.Add(Param0); SqlDataReader reading = command.ExecuteReader(); while (reading.Read()) { NomenclatureClass NC = new NomenclatureClass(); NC.ID = (Guid)reading.GetValue(0); NC.GroupID = (Guid)reading.GetValue(1); NC.GroupNomen = (bool)reading.GetValue(2); NC.Name = reading.GetValue(4).ToString(); if (NC.GroupNomen == true) { NC.Article = reading.GetValue(3).ToString(); NC.BaseUnit = reading.GetValue(5).ToString(); NC.WeightBaseUnit = Convert.ToDouble(reading.GetValue(6)); NC.BarcodeType = reading.GetValue(7).ToString(); NC.Barcode = reading.GetValue(8).ToString(); NC.CountryOfOrigin = reading.GetValue(9).ToString(); NC.Description = reading.GetValue(10).ToString(); NC.Aksia = (bool)reading.GetValue(11); NC.Focus = (bool)reading.GetValue(12); NC.New = (bool)reading.GetValue(13); } list.Add(NC); GroupID = (Guid)reading.GetValue(14); ID = (Guid)reading.GetValue(15); } } catch (Exception ex) { MessageBox.Show("Ошибка в методе: DataBaseRequest.GetAllNomenclatures" + "\n" + ex.Message, "Хуёво!"); } } return(list); }
//---Метод: Создание новой номенклатуры (ХП)--------------------------------------------------------------------- public static bool UpdateTagNew(NomenclatureClass Nomen) { bool ok = false; using (SqlConnection connect = new SqlConnection(Cryption.Decrypt(XmlClass.GetSelectedConnectionString()))) { try { connect.Open(); SqlCommand command = new SqlCommand("UpdateTagNew", connect); command.CommandType = CommandType.StoredProcedure; SqlParameter Param0 = new SqlParameter { ParameterName = "@NomenID", Value = Nomen.ID }; // Новый ID //---Передаваемый параметр command.Parameters.Add(Param0); SqlParameter Param1 = new SqlParameter { ParameterName = "@Checked", Value = Nomen.New }; //---Передаваемый параметр command.Parameters.Add(Param1); command.Parameters.Add("@Result", SqlDbType.Bit).Direction = ParameterDirection.Output; // Выходной параметр command.ExecuteNonQuery(); ok = (bool)command.Parameters["@Result"].Value; } catch (Exception ex) { MessageBox.Show(ex.Message, "DataBaseRequest.UpdateTagAksia"); } return(ok); } }
// Конструктор (2-Перегрузка: Для изменения ------------------------------------------------------------------------------------------ public NewNomenGroup(ref Guid GroupID, AfterItemCreationDelegate AfterCreationDelegate, NomenclatureClass EditableGroup) { this.GroupID = GroupID; this.AfterCreationDelegate = AfterCreationDelegate; this.EditableGroup = EditableGroup; CreateMode = false; InitializeComponent(); ButtonCreateEnabled = true; }