public bool UpdateLimits(ReferenceModel reference) { if (reference == null) { throw new Exception("Unable To Update Reference, Current Reference null"); } using (OleDbConnection myConnection = new OleDbConnection()) { myConnection.ConnectionString = _databaseConnection; var queryString = "update LAD8N SET Weighing_Nominal= @a,Weighing_Minimum=@b,Weighing_Maximum=@c where Reference=@d"; try { OleDbCommand command = new OleDbCommand(queryString, myConnection); command.Parameters.AddWithValue("@a", reference.WeighingNominal); command.Parameters.AddWithValue("@b", reference.WeighingMinimal); command.Parameters.AddWithValue("@c", reference.WeighingMaximal); command.Parameters.AddWithValue("@d", reference.Reference); command.Connection.Open(); var exec = command.ExecuteNonQuery(); command.Connection.Close(); command.Dispose(); return(true); } catch (Exception e) {// ignored MessageBox.Show(e.ToString()); } } return(false); }
public CodeSoftLabel(LabelType labelType, Settings settings, ReferenceModel reference) { InitializeComponent(); _referenceModel = reference; _labelType = labelType; _setting = settings; switch (labelType) { case LabelType.Individual: _topOffset = settings.LabelIndividualOffsetTop; _leftOffset = settings.LabelIndividualOffsetLeft; _printer = settings.IndividualPrinter; _fileLabelTemplatePath = settings.LabelLocation + @"\" + reference.LabelTempate + ".lab"; break; case LabelType.Group: _topOffset = settings.LabelGroupOffsetTop; _leftOffset = settings.LabelGroupOffsetLeft; _printer = settings.IndividualPrinter; _fileLabelTemplatePath = settings.LabelLocation + @"\" + reference.GroupingLabelTempate + ".lab"; break; default: throw new ArgumentOutOfRangeException(nameof(labelType), labelType, null); } }
public Weighing(Settings settings, ReferenceModel reference) { InitializeComponent(); _settings = settings; _referenceModel = reference; LoadAll(); try { WeighingDataUpdated -= OnWeighingDataUpdated; WeighingDataInRange -= OnWeighingDataInRange; WeighingDataOutRange -= OnWeighingDataOutRange; } catch { // ignored } WeighingDataUpdated += OnWeighingDataUpdated; WeighingDataInRange += OnWeighingDataInRange; WeighingDataOutRange += OnWeighingDataOutRange; }
private void ReferenceDataOnReferenceDataIsLoaded(ReferenceModel model) { lblGroupSize.Text = model.QuantityGroup.ToString("000"); txtArticle.Text = model.ArticleNumber; txtEan13.Text = Ean13.CalculateChecksumDigit(model.ArticleNumber); _groupingLabel = new CodeSoftLabel(LabelType.Group, Settings, _referenceData.Reference); _groupingLabel.InitMine(); _individualLabel = new CodeSoftLabel(LabelType.Individual, Settings, _referenceData.Reference); _individualLabel.InitMine(); docGroupPrev.Image = _groupingLabel.ResizeIfNeeded(_groupingLabel.RealSizeImage, docGroupPrev.Width, docGroupPrev.Height); docIndiPrev.Image = _individualLabel.ResizeIfNeeded(_individualLabel.RealSizeImage, docIndiPrev.Width, docIndiPrev.Height); try { if (_weighingStation != null) { _weighingStation.WeighingDataUpdated -= WeighingStationOnWeighingDataUpdated; _weighingStation.WeighingDataInRange -= WeighingStationOnWeighingDataInRange; _weighingStation.WeighingDataOutRange -= WeighingStationOnWeighingDataOutRange; _weighingStation.WeighingBoxRemoved -= WeighingStationOnWeighingBoxRemoved; } } finally { _weighingStation = new Weighing(Settings, _referenceData.Reference); _weighingStation.WeighingDataUpdated += WeighingStationOnWeighingDataUpdated; _weighingStation.WeighingDataInRange += WeighingStationOnWeighingDataInRange; _weighingStation.WeighingDataOutRange += WeighingStationOnWeighingDataOutRange; _weighingStation.WeighingBoxRemoved += WeighingStationOnWeighingBoxRemoved; lblHighLimit.Text = _weighingStation.UpperWeightPerBox.ToString("00000"); lblLowLimit.Text = _weighingStation.LowerWeightPerBox.ToString("00000"); } }
public bool LoadByReferenceName(string reference) { if (Reference != null) { throw new Exception("Unable To Load Reference, Current Reference Is not Closed!"); } if (reference == "") { return(false); } using (OleDbConnection myConnection = new OleDbConnection()) { myConnection.ConnectionString = _databaseConnection; var queryString = "select * from LAD8N where Reference='" + reference + "'"; OleDbCommand command = new OleDbCommand(queryString, myConnection); try { command.Connection.Open(); } catch { MessageBox.Show(@"Error Loading Database"); } OleDbDataReader reader = command.ExecuteReader(); if (reader == null) { return(false); } if (reader.Read()) { Reference = new ReferenceModel { ArticleNumber = reader[0].ToString(), Reference = reader[1].ToString(), Pokayoke = reader[10].ToString(), QuantityGroup = Convert.ToInt32(reader[9].ToString().Trim() == "" ? "0" : reader[9].ToString().Trim()), QuantityIndividual = Convert.ToInt32(reader[8].ToString().Trim() == "" ? "0" : reader[8].ToString().Trim()), QuantityLot = Convert.ToInt32(reader[11].ToString().Trim() == "" ? "0" : reader[11].ToString().Trim()), Bitmap = reader[2].ToString(), English = reader[3].ToString(), France = reader[4].ToString(), German = reader[5].ToString(), Spain = reader[6].ToString(), LabelTempate = reader[7].ToString(), GroupingLabelTempate = reader[15].ToString(), WeighingNominal = Convert.ToInt32(reader[12].ToString().Trim() == "" ? "0" : reader[12].ToString().Trim()), WeighingMinimal = Convert.ToInt32(reader[13].ToString().Trim() == "" ? "0" : reader[13].ToString().Trim()), WeighingMaximal = Convert.ToInt32(reader[14].ToString().Trim() == "" ? "0" : reader[14].ToString().Trim()) }; } else { return(false); } } IsLoaded = true; ReferenceDataIsLoaded?.Invoke(Reference); return(true); }