private void dgvvibor_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == 32)
{
int i = dgvvibor.CurrentRow.Index;
switch (Sform.ownerFormName)
{
case "Pform":
CallBackMy.callbackEventHandlerPform(dgvvibor.Rows[i].Cells["Kod"].Value.ToString());
break;
case "Tform":
CallBackMy.callbackEventHandlerTform(dgvvibor.Rows[i].Cells["Kod"].Value.ToString());
break;
case "Pereocenkaform":
CallBackMy.callbackEventHandlerPereocenkaform(dgvvibor.Rows[i].Cells["Kod"].Value.ToString());
break;
case "Rform":
CallBackMy.callbackEventHandlerRform(dgvvibor.Rows[i].Cells["Kod"].Value.ToString());
break;
default:
break;
}
this.Close();
}
}
private void ImportToolStripMenuItem_Click(object sender, EventArgs e)
{
string formactive = ActiveForm.Text;
if (formactive.IndexOf("Расходная накладная") >= 0)
{
//Создаем новый экземпляр
List <ImportExport> CSV_Struct = new List <ImportExport>();
CSV_Struct = ImportExport.ImportToCsv();
string message = "Загружено: " + CSV_Struct.Count + " позиций";
int countmess = 5;
if (CSV_Struct.Count <= 5)
{
countmess = CSV_Struct.Count;
}
for (int i = 0; i <= countmess - 1; i++)
{
message += Environment.NewLine + CSV_Struct[i].kod + " -- " + CSV_Struct[i].qty;
}
DialogResult result = MessageBox.Show(message, "Загрузить данные?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
//Заполняем listView из нашей структуры
for (int i = 0; i <= CSV_Struct.Count - 1; i++)
{
CallBackMy.callbackEventHandlerRform(CSV_Struct[i].kod);
CallBackMy.callbackEventHandlerRformImport(CSV_Struct[i].kod, Convert.ToDouble(CSV_Struct[i].qty));
}
}
}
}
private void dgvFindT_KeyPress(object sender, KeyPressEventArgs e)
{
if (dgvFindT.RowCount > 0)
{
if (e.KeyChar == 32)
{
int irow = dgvFindT.CurrentRow.Index;
switch (Sform.ownerFormName)
{
case "Pform":
CallBackMy.callbackEventHandlerPform(dgvFindT.Rows[irow].Cells[0].Value.ToString());
exitfrm = "func";
this.Close();
break;
case "Tform":
CallBackMy.callbackEventHandlerTform(dgvFindT.Rows[irow].Cells[0].Value.ToString());
this.Close();
break;
case "Pereocenkaform":
CallBackMy.callbackEventHandlerPereocenkaform(dgvFindT.Rows[irow].Cells[0].Value.ToString());
exitfrm = "func";
this.Close();
break;
case "Rform":
CallBackMy.callbackEventHandlerRform(dgvFindT.Rows[irow].Cells[0].Value.ToString());
this.Close();
break;
case "ReportMoveGoodsform":
CallBackMy.callbackEventHandlerReportMoveGoodsform(dgvFindT.Rows[irow].Cells[0].Value.ToString(), dgvFindT.Rows[irow].Cells[1].Value.ToString());
break;
default:
break;
}
}
}
}
private void tsbtnadd_Click(object sender, EventArgs e)
{
// проверяем не запущена ли форма
for (int x = 0; x < this.MdiParent.MdiChildren.Length; x++)
{
if (this.MdiParent.MdiChildren[x].Name == "Pform")
{
this.MdiParent.MdiChildren[x].Focus();
return;
}
}
// Запускаем форму если она не запущена
Form Pform = new Pform();
Pform.StartPosition = FormStartPosition.CenterScreen;
Pform.WindowState = FormWindowState.Maximized;
//указываем владельца для формы
Pform.MdiParent = this.MdiParent; // где containerInstance - это экземпляр контейнера или указатель на MainForm
Pform.Show();
CallBackMy.callbackEventHandlerFormOpen(Pform);
}
private void ReportSalesAll()
{
dgvRepSales.Rows.Clear();
dgvRepSales.Update();
string periodN = func.replace_date_sql(Convert.ToString(dtpSalesN.Value));
string periodE = func.replace_date_sql(Convert.ToString(dtpSalesE.Value.AddDays(1)));
string QueryReportSales = "";
string QueryDbase = "";
if (cmbGruptSales.Text != "")
{
QueryReportSales = "Select kod,rcena,count,zcena from Sales where date >'" + periodN + "' and date <'" + periodE + "' order by kod";
QueryDbase = "Select kod,name,(Select name from groupt where id= id_group) as groupt,quantity,zcena,rcena,(Select name from suppliers where id= id_suppliers) as sup from dbase where id_group=" + cmbGruptSales.SelectedValue + " order by kod";
}
else
{
QueryReportSales = "Select kod,rcena,count,zcena from Sales where date >'" + periodN + "' and date <'" + periodE + "' order by kod";
QueryDbase = "Select kod,name,(Select name from groupt where id= id_group) as groupt,quantity,zcena,rcena,(Select name from suppliers where id= id_suppliers) as sup from dbase order by kod";
}
DataTable ReportSalesTable = _SQl.ExecuteSQL(QueryReportSales);
DataTable QueryDbaseTable = _SQl.ExecuteSQL(QueryDbase);
double coutnsrednee = 0;
double summZsrednee = 0;
double summRsrednee = 0;
for (int l = 0; l < QueryDbaseTable.Rows.Count; l++)
{
string kod = QueryDbaseTable.Rows[l][0].ToString();
string namet = QueryDbaseTable.Rows[l][1].ToString();
string groupt = QueryDbaseTable.Rows[l][2].ToString();
double zcenanow = Convert.ToDouble(QueryDbaseTable.Rows[l][4].ToString());
double rcenanow = Convert.ToDouble(QueryDbaseTable.Rows[l][5].ToString());
double ostatok = Convert.ToDouble(QueryDbaseTable.Rows[l][3].ToString());
string suppliers = QueryDbaseTable.Rows[l][6].ToString();
CallBackMy.callbackEventHandlerProgressBar(QueryDbaseTable.Rows.Count, l, namet);
for (int irow = 0; irow < ReportSalesTable.Rows.Count; irow++)
{
if (kod == ReportSalesTable.Rows[irow][0].ToString())
{
coutnsrednee = coutnsrednee + Convert.ToDouble(ReportSalesTable.Rows[irow][2].ToString());
summZsrednee = summZsrednee + (Convert.ToDouble(ReportSalesTable.Rows[irow][2].ToString()) * Convert.ToDouble(ReportSalesTable.Rows[irow][3].ToString()));
summRsrednee = summRsrednee + Math.Round((Convert.ToDouble(ReportSalesTable.Rows[irow][2].ToString()) * Convert.ToDouble(ReportSalesTable.Rows[irow][1].ToString())), 0);
}
if (irow == ReportSalesTable.Rows.Count - 1)
{
dgvRepSales.Rows.Add(kod, namet, zcenanow, rcenanow, coutnsrednee, ostatok, summZsrednee, Math.Round(summRsrednee, 0), Math.Round((((rcenanow / zcenanow) - 1) * 100), 2), groupt, Math.Round(summZsrednee / coutnsrednee, 2), Math.Round(summRsrednee / coutnsrednee, 2), Math.Round(((((Math.Round((summRsrednee / coutnsrednee), 2) / Math.Round((summZsrednee / coutnsrednee), 2)) - 1)) * 100), 2), suppliers);
coutnsrednee = 0;
summZsrednee = 0;
summRsrednee = 0;
}
}
}
double itogZsumm = 0;
double itogRsumm = 0;
//double itogMargin = 0;
double itogSRMargin = 0;
double itogQty = 0;
for (int irowItog = 0; irowItog < dgvRepSales.Rows.Count; irowItog++)
{
itogQty = itogQty + Convert.ToDouble(dgvRepSales.Rows[irowItog].Cells[4].Value);
itogZsumm = itogZsumm + Convert.ToDouble(dgvRepSales.Rows[irowItog].Cells[6].Value);
itogRsumm = itogRsumm + Convert.ToDouble(dgvRepSales.Rows[irowItog].Cells[7].Value);
//itogMargin = itogMargin + Convert.ToDouble(dgvRepSales.Rows[irowItog].Cells[7].Value);
itogSRMargin = itogSRMargin + Convert.ToDouble(dgvRepSales.Rows[irowItog].Cells[12].Value);
if (irowItog == dgvRepSales.Rows.Count - 1)
{
dgvRepSales.Rows.Add("", "", "", "Итоги", Math.Round(Convert.ToDouble(itogQty), 3), "", Math.Round(Convert.ToDouble(itogZsumm), 2), Math.Round(Convert.ToDouble(itogRsumm), 2), Math.Round((((itogRsumm / itogZsumm) - 1) * 100), 2), "", "", "", (itogSRMargin / dgvRepSales.Rows.Count));
return;
}
dgvRepSales.Rows[irowItog].Cells["Ostatok"].Style.BackColor = Color.LightYellow;
}
}
