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