private void cbFarm_SelectedIndexChanged(object sender, EventArgs e) { tbPassword.Enabled = npLogin.Enabled = false; if (cbFarm.SelectedIndex < 0) { return; } cbUser.Focus(); try { Application.DoEvents(); RabnetConfig.rabDataSource xs = null; foreach (RabnetConfig.rabDataSource d in RabnetConfig.DataSources) { if (d.Name == cbFarm.Text) { xs = d; } } if (xs == null) { return; } if (!DBproc.Connect(xs.Params.ToString())) { throw new Exception("Не удалось подключиться к Базе Данных"); } cbUser.Items.Clear(); List <sUser> usrs = DBproc.GetUsers();//Получаем список юзеров if (usrs != null && usrs.Count > 0) { foreach (sUser s in usrs) { cbUser.Items.Add(s.Name); if (xs.DefUser != "" && xs.DefUser == s.Name) { cbUser.SelectedIndex = cbUser.Items.Count - 1; if (xs.DefPassword != "") { tbPassword.Text = xs.DefPassword; } tbPassword.Focus(); tbPassword.SelectAll(); } } } /*else * { * npLogin.OkButtonEnable = false; * }*/ } catch (Exception ex) { cbUser.SelectedIndex = cbFarm.SelectedIndex = -1; cbFarm.Text = cbUser.Text = tbPassword.Text = ""; cbFarm.Focus(); lbError_TextChange("Ошибка подключения " + ex.GetType().ToString() + ": " + ex.Message); } }
private void npButcher_OkButtonClick(object sender, EventArgs e) { DBproc.AddMeat((int)dataGridView1.SelectedCells[0].Tag, float.Parse(tbAmount.Text)); tbAmount.Clear(); updateLogs(); //dataGridView1.SelectedCells[0].Selected = false; //tbAmount.Enabled = npButcher.Enabled = false; }
public void FillProducts() { dataGridView1.Rows.Clear(); List <sProductType> products = DBproc.GetProducts(); for (int i = 0; i < products.Count; i++) { int cellInt = 0; if (i % 2 != 0) { cellInt = 1; } if (cellInt == 0)//если новая строка { DataGridViewRow row = new DataGridViewRow(); dataGridView1.Rows.Add(row); } if (products[i].Image.Length != 0)//если имеется изображение { Image img = getImage(products[i].Image); dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[cellInt].Value = img; dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[cellInt].Tag = products[i].Id; if (cellInt == 0) { dataGridView1.Rows[dataGridView1.Rows.Count - 1].Height = img.Height; } } else// делает картинку с надписью { string product = products[i].Name; Bitmap bmp = new Bitmap(300, 200); Graphics gr = Graphics.FromImage(bmp); Font fnt = new Font("Arial", 24); //int pointH = bmp.Height/2 - fnt.Height/2; //int strLen = (int)((float)fnt.Size * (float)product.Length); //int pointW = (int)(Math.Abs(((float)bmp.Width - (float)strLen)) / 2); gr.DrawString(products[i].Name, fnt, new SolidBrush(Color.Black), new Rectangle(0, 0, 300, 200)); //gr.DrawString(product, fnt, new SolidBrush(Color.Black), pointW, pointH); dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[cellInt].Value = bmp; if (cellInt == 0) { dataGridView1.Rows[dataGridView1.Rows.Count - 1].Height = bmp.Height; } dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[cellInt].Tag = products[i].Id; } } if (dataGridView1.Rows.Count > 4)//если не помещается продукция в область { btDown.Enabled = true; } }
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.SelectedCells[0].Tag == null) { lbProductName.Text = lbUnit.Text = ""; dataGridView1.SelectedCells[0].Selected = false; tbAmount.Enabled = npButcher.Enabled = false; return; } sProductType prod = DBproc.GetProduct((int)dataGridView1.SelectedCells[0].Tag); lbProductName.Text = prod.Name; lbUnit.Text = prod.Units; tbAmount.Enabled = npButcher.Enabled = true; }
private void npLogin_OkButtonClick(object sender, EventArgs e) { if (DBproc.CheckUser(cbUser.Text, tbPassword.Text)) { this.Hide(); RabnetConfig.DataSources[cbFarm.SelectedIndex].setDefault(cbUser.Text, tbPassword.Text); SuccessfulLogin(sender, e); } else { gbMessage.Show(); lbError_TextChange("Не удалось выполнить вход." + Environment.NewLine + "Возможно не правильно введен пароль."); //tError.Start(); } tbPassword.Clear(); }
/// <summary> /// обновляет поле Логов /// </summary> private void updateLogs() { lvLogs.Items.Clear(); List <sMeat> logs = DBproc.GetMeats(); foreach (sMeat l in logs) { ListViewItem lvi = new ListViewItem(l.Date.ToString()); if (l.Today) { lvi.SubItems[0].Font = new Font("Arial", lvLogs.Font.Size, FontStyle.Bold); } lvi.Tag = l.Id; lvi.SubItems.Add(l.ProductType); lvi.SubItems.Add(l.Amount.ToString() + " " + l.Units); lvi.SubItems.Add(l.User); lvLogs.Items.Add(lvi); } }