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