private void grdInventories_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
RFMDataGridView grd = (RFMDataGridView)sender; // grdInventories
if (grd.DataSource == null)
{
return;
}
if (grd.IsStatusRow(e.RowIndex))
{
if (grd.Columns[e.ColumnIndex].Name.Contains("Image"))
{
e.Value = Properties.Resources.Empty;
}
return;
}
DataRow r = ((DataRowView)grd.Rows[e.RowIndex].DataBoundItem).Row;
switch (grd.Columns[e.ColumnIndex].Name)
{
case "grcInventories_IsConfirmedImage":
if (Convert.ToBoolean(r["IsConfirmed"]))
{
e.Value = Properties.Resources.Check;
}
else
{
e.Value = Properties.Resources.Empty;
}
break;
}
}
private void dgvJobs_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
RFMDataGridView grd = (RFMDataGridView)sender;
if (grd.DataSource == null || grd.Rows.Count == 0)
{
return;
}
// строка данных
DataRow r = ((DataRowView)((DataGridViewRow)grd.Rows[e.RowIndex]).DataBoundItem).Row;
DataGridViewColumn c = grd.Columns[e.ColumnIndex];
string sColumnName = c.Name.ToUpper();
if (sColumnName.Equals("dgvcUnitsQnt".ToUpper()) || sColumnName.Equals("dgvcPrice".ToUpper()))
{
decimal nUnitsQnt, nPrice;
try
{
nUnitsQnt = Decimal.Parse(r["UnitsQnt"].ToString());
nPrice = Decimal.Parse(r["Price"].ToString());
}
catch
{
nUnitsQnt = nPrice = 0;
}
r["TaskAmount"] = nUnitsQnt * nPrice;
grd.Refresh();
}
}
private void grdFrames_CellValidated(object sender, DataGridViewCellEventArgs e)
{
if (!bIsLoaded || grdFrames.IsRestoring)
{
return;
}
RFMDataGridView grd = grdFrames;
string sColName = grd.Columns[e.ColumnIndex].Name;
DataGridViewRow grdr = grd.Rows[e.RowIndex];
if (sColName == "grcQntForMove")
{
if (grdr.Cells["grcQntForMove"].Value == DBNull.Value)
{
grdr.Cells["grcQntForMove"].Value =
grdr.Cells["grcBoxQntForMove"].Value =
0;
grdr.Cells["grcIsForMove"].Value = false;
grdr.Cells["grcIsSelected"].Value = false;
}
}
if (sColName == "grcBoxQntForMove")
{
if (grdr.Cells["grcBoxQntForMove"].Value == DBNull.Value)
{
grdr.Cells["grcQntForMove"].Value =
grdr.Cells["grcBoxQntForMove"].Value =
0;
grdr.Cells["grcIsForMove"].Value = false;
grdr.Cells["grcIsSelected"].Value = false;
}
}
}
private void grdData_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
RFMDataGridView grd = (RFMDataGridView)sender;
if (grd.DataSource == null)
{
return;
}
if (grd.Rows[e.RowIndex] == null)
{
return;
}
if (grd.IsStatusRow(e.RowIndex))
{
if (grd.Columns[e.ColumnIndex].Name.ToUpper().Contains("IMAGE"))
{
e.Value = Properties.Resources.Empty;
}
return;
}
if (grd.Name.ToUpper().Contains("GRD"))
{
if (grd.Columns[e.ColumnIndex].DefaultCellStyle.Format.Contains("N"))
{
if (Convert.IsDBNull(e.Value) || Convert.ToDecimal(e.Value) == 0)
{
e.Value = "";
}
}
}
}
private void tmrRestore_Tick(object sender, EventArgs e)
{
tmrRestore.Enabled = false;
RFMDataGridView grd = grdOutputsDocuments;
if (grd.CurrentRow == null || grd.CurrentRow.Index < 0)
{
return;
}
int rowIndex = grd.CurrentRow.Index;
btnOutputsDocumentBring.Enabled =
btnOutputsDocumentBringZero.Enabled =
false;
if (grd.IsStatusRow(rowIndex))
{
oOutputDocumentCur.ClearOne();
}
else
{
// заполнение объекта по текущей строке
DataRow r = ((DataRowView)((DataGridViewRow)grdOutputsDocuments.Rows[rowIndex]).DataBoundItem).Row;
oOutputDocumentCur.FillOne(r);
btnOutputsDocumentBring.Enabled =
btnOutputsDocumentBringZero.Enabled =
oOutputDocumentCur.IsConfirmed && !oOutputDocumentCur.IsBrought;
}
tcOutputsDocumentsGoods.SetAllNeedRestore(true);
}
private void grdData_CurrentRowChanged(object sender)
{
RFMDataGridView grd = (RFMDataGridView)sender;
if (grd.CurrentRow == null || grd.CurrentRow.Index < 0)
{
return;
}
int rowIndex = grd.CurrentRow.Index;
if (grd.IsStatusRow(rowIndex))
{
oWarrantCur.ClearOne();
btnPrint.Enabled =
btnService.Enabled =
false;
}
else
{
DataRow r = ((DataRowView)((DataGridViewRow)grd.Rows[rowIndex]).DataBoundItem).Row;
oWarrantCur.FillOne(r);
SetButtonStatus(r);
}
}
private void grdData_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
RFMDataGridView grd = grdData;
if (grd.DataSource == null || grd.CurrentRow == null || grd.RowCount == 0 || grd.Rows[e.RowIndex] == null)
{
return;
}
string sColName = grd.Columns[e.ColumnIndex].Name;
DataGridViewRow grdR = grd.Rows[e.RowIndex];
DataRow dr = ((DataRowView)grdR.DataBoundItem).Row;
if (sColName == "grcRestQnt_After" || sColName == "grcRestBox_After")
{
if (dr != null)
{
decimal nInBox = 0, nRestQnt = 0; int nRestBox = 0;
if (!Convert.IsDBNull(grdR.Cells["grcRestBox_After"].Value) && grdR.Cells["grcRestBox_After"].Value != null)
{
nRestBox = Convert.ToInt32(grdR.Cells["grcRestBox_After"].Value);
}
if (!Convert.IsDBNull(grdR.Cells["grcRestQnt_After"].Value) && grdR.Cells["grcRestQnt_After"].Value != null)
{
nRestQnt = Convert.ToDecimal(grdR.Cells["grcRestQnt_After"].Value);
}
nInBox = Convert.ToDecimal(dr["InBox"]);
dr["RestQnt_After"] = nRestQnt;
dr["RestBox_After"] = nRestBox;
dr["Qnt_After"] = nRestBox * nInBox + nRestQnt;
dr["Box_After"] = nRestQnt / nInBox;
//grdData.CommitChanges();
}
}
}
private void grdFrames_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (!bIsLoaded)
{
return;
}
RFMDataGridView grd = grdFrames;
if (grd.DataSource == null || grd.CurrentRow == null || grd.RowCount == 0)
{
return;
}
string sColName = grd.Columns[e.ColumnIndex].Name;
DataGridViewRow grdr = grd.Rows[e.RowIndex];
if (sColName.Contains("ForMove"))
{
if ((decimal)grdr.Cells["grcQntForMove"].Value > 0)
{
e.CellStyle.BackColor = Color.FromArgb(250, 200, 200);
}
}
if (sColName.Contains("FrameID"))
{
if ((decimal)grdr.Cells["grcQntInTrafficsGoods"].Value != 0)
{
e.CellStyle.BackColor = Color.FromArgb(200, 250, 250);
}
}
}
private void btnCalc_Click(object sender, EventArgs e)
{
RFMDataGridView dgv = dgvWeightGoods;
if (dgv.Rows.Count == 0 || dgv.CurrentRow == null)
{
return;
}
DataGridViewRow dgrv = dgv.CurrentRow;
if (StartProgram.ParamStore != null)
{
for (int i = 0; i < StartProgram.ParamStore.GetLength(0); i++)
{
StartProgram.ParamStore.SetValue(null, i);
}
}
if (new frmCounter(false, 3, dgrv.Cells["dgvcGoodAlias2"].Value.ToString(), "").ShowDialog() == DialogResult.Yes)
{
if (StartProgram.ParamStore.GetValue(1) == null)
{
StartProgram.ParamStore.SetValue(0, 1);
}
// само значение
decimal nQnt = 0;
bool bResult = decimal.TryParse(StartProgram.ParamStore.GetValue(1).ToString(), out nQnt);
if (bResult) // && nQnt > 0
{
decimal nInBox = (decimal)dgrv.Cells["dgvcInBox2"].Value;
dgrv.Cells["dgvcQntConfirmed2"].Value = nQnt;
dgrv.Cells["dgvcBoxConfirmed2"].Value = nQnt / nInBox;
DataRow dr = oOutput.TableOutputsGoods.Rows.Find(dgrv.Cells["dgvcID2"].Value);
if (dr != null)
{
dr["BoxConfirmed"] = dgrv.Cells["dgvcBoxConfirmed2"].Value;
dr["QntConfirmed"] = dgrv.Cells["dgvcQntConfirmed2"].Value;
}
ShowHumanStrikes();
}
if (StartProgram.ParamStore.GetValue(0) == null)
{
StartProgram.ParamStore.SetValue("", 0);
}
dgvWeightGoods.Select();
}
if (StartProgram.ParamStore != null)
{
for (int i = 0; i < StartProgram.ParamStore.GetLength(0); i++)
{
StartProgram.ParamStore.SetValue(null, i);
}
}
}
private void grdData_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
RFMDataGridView grd = grdData;
if (grd.Rows[e.RowIndex] == null)
{
return;
}
if (grd.IsStatusRow(e.RowIndex))
{
e.CellStyle.BackColor = Color.Silver;
e.CellStyle.Font = new Font(e.CellStyle.Font, FontStyle.Bold);
switch (grd.Columns[e.ColumnIndex].Name)
{
case "grcRestQnt_After":
case "grcRestQnt_Before":
case "grcInBox":
e.CellStyle.Format = "### ### ### ###";
break;
}
return;
}
DataGridViewRow r = grd.Rows[e.RowIndex];
switch (grd.Columns[e.ColumnIndex].Name)
{
case "grcRestQnt_After":
case "grcRestQnt_Before":
case "grcInBox":
if (!Convert.IsDBNull(r.Cells["grcWeighting"].Value) &&
Convert.ToBoolean(r.Cells["grcWeighting"].Value) ||
!Convert.IsDBNull(e.Value) && Convert.ToDecimal(e.Value) != Convert.ToInt32(e.Value))
{
e.CellStyle.Format = "### ### ### ##0.000";
}
else
{
e.CellStyle.Format = "### ### ### ###";
}
//if (Convert.IsDBNull(e.Value) || e.Value == null || (decimal)e.Value == 0)
// e.Value = "";
break;
}
if (!Convert.ToBoolean(r.Cells["grcActual"].Value))
{
e.CellStyle.Font = new Font(e.CellStyle.Font, FontStyle.Italic);
}
if (Convert.ToDecimal(r.Cells["grcQnt_After"].Value) != Convert.ToDecimal(r.Cells["grcQnt_Before"].Value))
{
grd.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.LightPink;
}
else
{
grd.Rows[e.RowIndex].DefaultCellStyle.BackColor = cDefaultBackColor;
}
}
private void grdInputsDocuments_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
RFMDataGridView grd = (RFMDataGridView)sender;
if (grd.DataSource == null)
{
return;
}
string sGridName = grd.Name.ToUpper();
DataGridViewColumn c = grd.Columns[e.ColumnIndex];
string sColumnName = c.Name.ToUpper();
// статусная строка
if (grd.IsStatusRow(e.RowIndex))
{
if (sColumnName.Contains("RESULT") ||
sColumnName.Contains("IMAGE"))
{
e.Value = Properties.Resources.Empty;
}
return;
}
// строка данных
DataRow r = ((DataRowView)grd.Rows[e.RowIndex].DataBoundItem).Row;
// подтверждение отгрузки и доставки клиенту
if (sColumnName.Contains("IsConfirmedImage".ToUpper()))
{
if ((bool)r["IsConfirmed"])
{
e.Value = Properties.Resources.Check;
}
else
{
e.Value = Properties.Resources.Empty;
}
}
// нетто-брутто
if ((sColumnName.Contains("TTO") || sColumnName.Contains("AMOUNT")) &&
c.DefaultCellStyle.Format.Contains("N"))
{
if (Convert.IsDBNull(e.Value) || Convert.ToDecimal(e.Value) == 0)
{
e.Value = "";
}
}
// перенос
if ((bool)r["IsCarried"] || !Convert.IsDBNull(r["CopiedFromInputDocumentID"]))
{
e.CellStyle.Font = new Font(e.CellStyle.Font, FontStyle.Bold);
}
// скопированные из задания
// ...
}
private void grdTrafficsFrames_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
RFMDataGridView grd = grdTrafficsFrames;
if (grd.DataSource == null)
{
return;
}
if (grd.Rows[e.RowIndex] == null)
{
return;
}
if (grd.IsStatusRow(e.RowIndex))
{
switch (grd.Columns[e.ColumnIndex].Name)
{
case "grcStatusImage":
e.Value = Properties.Resources.Empty;
break;
}
return;
}
switch (grd.Columns[e.ColumnIndex].Name)
{
case "grcStatusImage":
if (grd.Rows[e.RowIndex].Cells["grcDateConfirm"].Value.ToString().Length == 0)
{
e.Value = Properties.Resources.Empty;
}
else
if (Convert.ToBoolean(grd.Rows[e.RowIndex].Cells["grcSuccess"].Value))
{
e.Value = Properties.Resources.Check;
}
else
{
e.Value = Properties.Resources.CheckRed;
}
break;
case "grcTrafficsFramesInBox":
DataGridViewRow r = grd.Rows[e.RowIndex];
if (!Convert.IsDBNull(r.Cells["grcTrafficsFramesWeighting"].Value) &&
Convert.ToBoolean(r.Cells["grcTrafficsFramesWeighting"].Value) ||
!Convert.IsDBNull(e.Value) && Convert.ToDecimal(e.Value) != Convert.ToInt32(e.Value))
{
e.CellStyle.Format = "### ### ### ###.000";
}
else
{
e.CellStyle.Format = "### ### ### ###";
}
break;
}
}
private void grdCellsContents_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
RFMDataGridView grd = grdCellsContents;
if (grd.Rows[e.RowIndex] == null)
{
return;
}
if (grd.IsStatusRow(e.RowIndex))
{
e.CellStyle.BackColor = Color.Silver;
e.CellStyle.Font = new Font(e.CellStyle.Font, FontStyle.Bold);
switch (grd.Columns[e.ColumnIndex].Name)
{
case "grcQnt":
case "grcQntCollect":
case "grcInBox":
e.CellStyle.Format = "### ### ### ###";
break;
case "grcBoxCollect":
e.CellStyle.Format = "### ### ### ###.#";
break;
case "grcChangesImage":
e.Value = Properties.Resources.Empty;
break;
}
return;
}
DataGridViewRow r = grd.Rows[e.RowIndex];
switch (grd.Columns[e.ColumnIndex].Name)
{
case "grcQnt":
case "grcQntCollect":
case "grcInBox":
if (!Convert.IsDBNull(r.Cells["grcWeighting"].Value) &&
Convert.ToBoolean(r.Cells["grcWeighting"].Value) ||
!Convert.IsDBNull(e.Value) && Convert.ToDecimal(e.Value) != Convert.ToInt32(e.Value))
{
e.CellStyle.Format = "### ### ### ###.000";
}
else
{
e.CellStyle.Format = "### ### ### ###";
}
break;
case "grcBoxCollect":
e.CellStyle.Format = "### ### ### ###.#";
break;
}
}
private void dgvOutputsDocuments_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
// используется для OutputsDocuments и InputsDocuments
RFMDataGridView grd = (RFMDataGridView)sender;
if (grd.DataSource == null || grd.Rows.Count == 0)
{
return;
}
string sGridName = grd.Name.ToUpper();
DataGridViewColumn c = grd.Columns[e.ColumnIndex];
string sColumnName = c.Name.ToUpper();
// статусная строка
if (grd.IsStatusRow(e.RowIndex))
{
if (sColumnName.Contains("IMAGE"))
{
e.Value = Properties.Resources.Empty;
}
return;
}
// строка данных
DataRow r = ((DataRowView)((DataGridViewRow)grd.Rows[e.RowIndex]).DataBoundItem).Row;
if (sColumnName.Contains("Image".ToUpper()))
{
if ((bool)r["IsBrought"])
{
if ((bool)r["SuccessBrought"])
{
e.Value = Properties.Resources.Check;
}
else
{
e.Value = Properties.Resources.CheckRed;
}
}
else
{
e.Value = Properties.Resources.Empty;
}
}
// нетто-брутто
if (sColumnName.Contains("TTO") &&
c.DefaultCellStyle.Format.Contains("N"))
{
if (Convert.IsDBNull(e.Value) || Convert.ToDecimal(e.Value) == 0)
{
e.Value = "";
}
}
}
private void grdTrips_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (grdTrips.DataSource == null)
{
return;
}
RFMDataGridView grd = grdTrips;
// статусная строка
if (grd.IsStatusRow(e.RowIndex))
{
if (grd.Columns[e.ColumnIndex].Name.ToUpper().Contains("IMAGE"))
{
e.Value = Properties.Resources.Empty;
}
return;
}
// строка данных
DataRow r = ((DataRowView)((DataGridViewRow)grd.Rows[e.RowIndex]).DataBoundItem).Row;
DataGridViewColumn c = grd.Columns[e.ColumnIndex];
oTripTemp.FillOne(r);
switch (c.Name)
{
case "grcTrip_TripStatusImage":
switch ((int)r["TripStatus"])
{
case 0:
e.Value = Properties.Resources.DotGreen;
break;
case 1:
e.Value = Properties.Resources.DotYellow;
break;
case 2:
e.Value = Properties.Resources.DotRed;
break;
default:
e.Value = Properties.Resources.Empty;
break;
}
break;
}
if (c.Name.Contains("tto") &&
c.DefaultCellStyle.Format.Contains("N"))
{
if (Convert.IsDBNull(e.Value) || Convert.ToDecimal(e.Value) == 0)
{
e.Value = "";
}
}
}
private void grdFramesContents_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
RFMDataGridView grd = ((RFMDataGridView)sender);
if (grd.DataSource == null)
{
return;
}
if (grd.IsStatusRow(e.RowIndex))
{
e.CellStyle.BackColor = Color.Silver;
e.CellStyle.Font = new Font(e.CellStyle.Font, FontStyle.Bold);
switch (grd.Columns[e.ColumnIndex].Name)
{
case "grcQntFramesContents":
case "grcInBox":
e.CellStyle.Format = "### ### ### ###";
break;
}
return;
}
DataGridViewRow r = grd.Rows[e.RowIndex];
switch (grd.Columns[e.ColumnIndex].Name)
{
case "grcQntFramesContents":
case "grcInBox":
if (!Convert.IsDBNull(r.Cells["grcFramesContentsWeighting"].Value) &&
Convert.ToBoolean(r.Cells["grcFramesContentsWeighting"].Value) ||
!Convert.IsDBNull(e.Value) && Convert.ToDecimal(e.Value) != Convert.ToInt32(e.Value))
{
e.CellStyle.Format = "### ### ### ###.000";
}
else
{
e.CellStyle.Format = "### ### ### ###";
}
break;
}
if ((grd.Columns[e.ColumnIndex].Name.Contains("Qnt") ||
grd.Columns[e.ColumnIndex].Name.Contains("Box") ||
grd.Columns[e.ColumnIndex].Name.Contains("Pal")) &&
grd.Columns[e.ColumnIndex].DefaultCellStyle.Format.Contains("N"))
{
if (Convert.IsDBNull(e.Value) || Convert.ToDecimal(e.Value) == 0)
{
e.Value = "";
}
}
}
private void dgvWeightGoods_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
if (!bWeightEnter)
{
return;
}
RFMDataGridView dgv = dgvWeightGoods;
if (dgv.DataSource == null || dgv.CurrentRow == null || dgv.RowCount == 0 || e.ColumnIndex < 0)
{
return;
}
string ColName = dgv.Columns[e.ColumnIndex].Name;
if (ColName == "dgvcQntConfirmed2" || ColName == "dgvcBoxConfirmed2")
{
DataGridViewRow dgrv = dgv.Rows[e.RowIndex];
decimal nInBox = (decimal)dgrv.Cells["dgvcInBox2"].Value;
// Проверка ошибочного ввода (вместо точки ввели запятую - стандартная ошибка)
decimal nQntWished, nQntConfirmed;
nQntWished = Convert.ToDecimal(dgv.Rows[e.RowIndex].Cells["dgvcQntWished2"].Value);
nQntConfirmed = Convert.ToDecimal(dgv.Rows[e.RowIndex].Cells["dgvcQntConfirmed2"].Value);
if (nQntConfirmed > nQntWished * 10)
{
if (RFMMessage.MessageBoxYesNo("Фактическое количество существенно превышает заказанное. Продолжить?", false) == DialogResult.No)
{
dgrv.Cells["dgvcQntConfirmed2"].Value = (decimal)dgrv.Cells["dgvcQntPicked2"].Value; //dgvcQntSelected2
dgrv.Cells["dgvcBoxConfirmed2"].Value = (decimal)dgrv.Cells["dgvcQntPicked2"].Value / nInBox; // dgvcQntSelected2
return;
}
}
// Конец проверки
if (ColName == "dgvcQntConfirmed2")
{
dgrv.Cells["dgvcBoxConfirmed2"].Value = (decimal)dgrv.Cells["dgvcQntConfirmed2"].Value / nInBox;
}
else
{
dgrv.Cells["dgvcQntConfirmed2"].Value = (decimal)dgrv.Cells["dgvcBoxConfirmed2"].Value * nInBox;
}
DataRow dr = oOutput.TableOutputsGoods.Rows.Find(dgrv.Cells["dgvcID2"].Value);
if (dr != null)
{
dr["BoxConfirmed"] = dgrv.Cells["dgvcBoxConfirmed2"].Value;
dr["QntConfirmed"] = dgrv.Cells["dgvcQntConfirmed2"].Value;
}
ShowHumanStrikes();
}
}
private void grdData_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
RFMDataGridView grd = grdData;
if (grd.Rows[e.RowIndex] == null)
{
return;
}
if (grd.IsStatusRow(e.RowIndex))
{
e.CellStyle.BackColor = Color.Silver;
e.CellStyle.Font = new Font(e.CellStyle.Font, FontStyle.Bold);
switch (grd.Columns[e.ColumnIndex].Name)
{
case "grcTypeImage":
e.Value = Properties.Resources.Empty;
break;
}
return;
}
DataGridViewRow r = grd.Rows[e.RowIndex];
switch (grd.Columns[e.ColumnIndex].Name)
{
case "grcQntPlus":
case "grcQntMinus":
if (bWeighting && Convert.ToDecimal(e.Value) == 0)
{
e.Value = "";
}
break;
case "grcTypeImage":
switch (r.Cells["grcOperType"].Value.ToString())
{
case "I":
e.Value = Properties.Resources.Plus;
break;
case "O":
e.Value = Properties.Resources.Minus;
break;
default:
e.Value = Properties.Resources.Empty;
break;
}
break;
}
}
private void dgvPieceGoods_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
RFMDataGridView dgv = dgvPieceGoods;
if (dgv.DataSource == null || dgv.CurrentRow == null || dgv.RowCount == 0)
{
return;
}
string ColName = dgv.Columns[e.ColumnIndex].Name;
DataGridViewRow dgvr = dgv.Rows[e.RowIndex];
bool lDecimalFormat = ((bool)dgvr.Cells["dgvcWeighting1"].Value ||
(Convert.ToDecimal(dgvr.Cells["dgvcInBox1"].Value) != Convert.ToInt32(dgvr.Cells["dgvcInBox1"].Value)));
switch (ColName.ToLower())
{
case "dgvcqntwished1":
case "dgvcqntconfirmed1":
case "dgvcinbox1":
if (lDecimalFormat)
{
e.CellStyle.Format = "### ### ### ###.000";
}
else
{
e.CellStyle.Format = "### ### ### ###";
}
break;
}
if ((decimal)dgvr.Cells["dgvcQntConfirmed1"].Value < (decimal)dgvr.Cells["dgvcQntWished1"].Value)
{
if (ColName == "dgvcQntConfirmed1" || ColName == "dgvcBoxConfirmed1")
{
if ((decimal)dgvr.Cells["dgvcQntConfirmed1"].Value == 0)
{
dgvr.Cells["dgvcGoodAlias1"].Style.Font = new Font(e.CellStyle.Font, FontStyle.Strikeout);
e.CellStyle.BackColor = Color.FromArgb(250, 200, 200);
}
else
{
if ((decimal)dgvr.Cells["dgvcQntConfirmed1"].Value != (decimal)dgvr.Cells["dgvcQntWished1"].Value)
{
e.CellStyle.BackColor = Color.FromArgb(250, 200, 200);
}
if ((decimal)dgvr.Cells["dgvcQntConfirmed1"].Value != (decimal)dgvr.Cells["dgvcQntSelected1"].Value)
{
e.CellStyle.BackColor = Color.FromArgb(255, 255, 128);
}
}
}
}
}
private void grdData_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
RFMDataGridView grd = (RFMDataGridView)sender;
string sGridName = grd.Name.ToUpper();
if (grd.DataSource == null)
{
return;
}
// статусная строка
// здесь - не исп.
/*
* if (grd.IsStatusRow(e.RowIndex))
* {
* if (grd.Columns[e.ColumnIndex].Name.ToUpper().Contains("IMAGE"))
* {
* e.Value = Properties.Resources.Empty;
* }
* return;
* }
*/
// строка данных
// здесь - не исп.
/*
* DataRow r = ((DataRowView)grd.Rows[e.RowIndex].DataBoundItem).Row;
* DataGridViewColumn c = grd.Columns[e.ColumnIndex];
* string sColumnName = c.Name.ToUpper();
* if (sColumnName.Contains("IsMoney".ToUpper()))
* {
* if ((bool)r["IsMoney"])
* {
* e.Value = Properties.Resources.Edit_coin;
* }
* else
* {
* e.Value = Properties.Resources.Box_full;
* }
* }
* if (c.DefaultCellStyle.Format.Contains("N"))
* {
* if (Convert.IsDBNull(e.Value) || Convert.ToDecimal(e.Value) == 0)
* {
* e.Value = "";
* }
* }
*/
}
private void grdFramesTraffics_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
RFMDataGridView grd = ((RFMDataGridView)sender);
if (grd.DataSource == null)
{
return;
}
if (grd.IsStatusRow(e.RowIndex))
{
switch (grd.Columns[e.ColumnIndex].Name)
{
case "grcTrafficsConfirmedImage":
e.Value = Properties.Resources.Empty;
break;
}
return;
}
DataGridViewRow r = grd.Rows[e.RowIndex];
switch (grd.Columns[e.ColumnIndex].Name)
{
case "grcTrafficsConfirmedImage":
if (grd.Rows[e.RowIndex].Cells["grcTrafficsDateConfirm"].Value.ToString().Length == 0)
{
e.Value = Properties.Resources.Empty;
}
else
if ((bool)grd.Rows[e.RowIndex].Cells["grcTrafficsSuccess"].Value)
{
e.Value = Properties.Resources.Check;
}
else
{
e.Value = Properties.Resources.CheckRed;
}
break;
}
if ((grd.Columns[e.ColumnIndex].Name.Contains("Height") ||
grd.Columns[e.ColumnIndex].Name.Contains("Weight")) &&
grd.Columns[e.ColumnIndex].DefaultCellStyle.Format.Contains("N"))
{
if (Convert.IsDBNull(e.Value) || Convert.ToDecimal(e.Value) == 0)
{
e.Value = "";
}
}
}
private void grdInputsDocumentsGoods_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
RFMDataGridView grd = (RFMDataGridView)sender;
if (grd.DataSource == null)
{
return;
}
DataGridViewColumn c = grd.Columns[e.ColumnIndex];
string sColumnName = c.Name.ToUpper();
// статусная строка
if (grd.IsStatusRow(e.RowIndex))
{
if (sColumnName.Contains("RESULT") ||
sColumnName.Contains("IMAGE"))
{
e.Value = Properties.Resources.Empty;
}
return;
}
// строка данных
DataRow r = ((DataRowView)grd.Rows[e.RowIndex].DataBoundItem).Row;
if (sColumnName.Contains("QNT") ||
sColumnName.Contains("INBOX"))
{
if (!Convert.IsDBNull(r["Weighting"]) && (bool)r["Weighting"] &&
!Convert.IsDBNull(e.Value) && Convert.ToDecimal(e.Value) != Convert.ToInt32(e.Value))
{
e.CellStyle.Format = "### ###.000";
}
else
{
e.CellStyle.Format = "### ###";
}
}
if ((sColumnName.Contains("QNT") || sColumnName.Contains("BOX") || sColumnName.Contains("PAL")) &&
c.DefaultCellStyle.Format.Contains("N"))
{
if (Convert.IsDBNull(e.Value) || Convert.ToDecimal(e.Value) == 0)
{
e.Value = "";
}
}
}
private void grdOddmentsSaved_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (grdOddmentsSaved.DataSource == null)
{
return;
}
RFMDataGridView grd = grdOddmentsSaved;
if (grd.IsStatusRow(e.RowIndex))
{
e.CellStyle.BackColor = Color.Silver;
e.CellStyle.Font = new Font(e.CellStyle.Font, FontStyle.Bold);
}
}
private void dgvTrips_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
RFMDataGridView grd = (RFMDataGridView)sender;
if (grd.DataSource == null || grd.Rows.Count == 0)
{
return;
}
string sGridName = grd.Name.ToUpper();
DataGridViewColumn c = grd.Columns[e.ColumnIndex];
string sColumnName = c.Name.ToUpper();
// статусная строка
if (grd.IsStatusRow(e.RowIndex))
{
if (sColumnName.Contains("IMAGE"))
{
e.Value = Properties.Resources.Empty;
}
return;
}
// строка данных
DataRow r = ((DataRowView)((DataGridViewRow)grd.Rows[e.RowIndex]).DataBoundItem).Row;
if (sColumnName.Contains("Image".ToUpper()))
{
if ((bool)r["IsConfirmed"])
{
e.Value = Properties.Resources.Check;
}
else
{
e.Value = Properties.Resources.Empty;
}
}
// себестоимость
if (sColumnName.Contains("Cost".ToUpper()))
{
if (Convert.IsDBNull(e.Value) || Convert.ToDecimal(e.Value) == 0)
{
e.Value = "";
}
}
}
private void grdInputsDocuments_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
RFMDataGridView grd = (RFMDataGridView)sender;
string sGridName = grd.Name.ToUpper();
if (grd.DataSource == null)
{
return;
}
// статусная строка
if (grd.IsStatusRow(e.RowIndex))
{
if (grd.Columns[e.ColumnIndex].Name.ToUpper().Contains("RESULT") ||
grd.Columns[e.ColumnIndex].Name.ToUpper().Contains("IMAGE"))
{
e.Value = Properties.Resources.Empty;
}
return;
}
// строка данных
DataRow r = ((DataRowView)grd.Rows[e.RowIndex].DataBoundItem).Row;
DataGridViewColumn c = grd.Columns[e.ColumnIndex];
string sColumnName = c.Name.ToUpper();
if (sColumnName.Contains("IsConfirmedImage".ToUpper()))
{
if ((bool)r["IsConfirmed"])
{
e.Value = Properties.Resources.Check;
}
else
{
e.Value = Properties.Resources.Empty;
}
}
if (sColumnName.Contains("TTO") &&
c.DefaultCellStyle.Format.Contains("N"))
{
if (Convert.IsDBNull(e.Value) || Convert.ToDecimal(e.Value) == 0)
{
e.Value = "";
}
}
}
private void grdWayBills_Trips_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if (grdWayBills_Trips.DataSource == null)
{
return;
}
RFMDataGridView grd = grdWayBills_Trips;
// статусная строка
if (grd.IsStatusRow(e.RowIndex))
{
if (grd.Columns[e.ColumnIndex].Name.Contains("Image"))
{
e.Value = Properties.Resources.Empty;
}
return;
}
// строка данных
DataRow r = ((DataRowView)((DataGridViewRow)grd.Rows[e.RowIndex]).DataBoundItem).Row;
DataGridViewColumn c = grd.Columns[e.ColumnIndex];
oTripTemp.FillOne(r);
switch (c.Name)
{
case "grcWayBill_Trip_TripConfirmImage":
if ((bool)r["IsConfirmed"])
{
e.Value = Properties.Resources.Check;
}
else
{
e.Value = Properties.Resources.Empty;
}
break;
}
if (c.Name.Contains("tto") &&
c.DefaultCellStyle.Format.Contains("N"))
{
if (Convert.IsDBNull(e.Value) || Convert.ToDecimal(e.Value) == 0)
{
e.Value = "";
}
}
}
private void dgvPieceGoods_CellValidated(object sender, DataGridViewCellEventArgs e)
{
if (dgvPieceGoods.IsRestoring)
{
return;
}
RFMDataGridView dgv = dgvPieceGoods;
string ColName = dgv.Columns[e.ColumnIndex].Name;
DataGridViewRow dgvr = dgv.Rows[e.RowIndex];
if (ColName == "dgvcQntConfirmed1" &&
!(bool)dgvr.Cells["dgvcHalfStuff1"].Value &&
!(bool)dgvr.Cells["dgvcWeighting1"].Value &&
(dgvr.Cells["dgvcQntConfirmed1"].Value == DBNull.Value ||
((decimal)dgvr.Cells["dgvcQntConfirmed1"].Value > (decimal)dgvr.Cells["dgvcQntWished1"].Value)))
{
if (dgvr.Cells["dgvcQntConfirmed1"].Value == DBNull.Value)
{
dgvr.Cells["dgvcQntConfirmed1"].Value = 0;
}
else
{
RFMMessage.MessageBoxError("Введено число больше допустимого!");
dgvr.Cells["dgvcQntConfirmed1"].Value = dgvr.Cells["dgvcQntWished1"].Value;
}
bValidOK = false;
}
if (ColName == "dgvcBoxConfirmed1" &&
!(bool)dgvr.Cells["dgvcHalfStuff1"].Value &&
!(bool)dgvr.Cells["dgvcWeighting1"].Value && (
dgvr.Cells["dgvcBoxConfirmed1"].Value == DBNull.Value ||
((decimal)dgvr.Cells["dgvcBoxConfirmed1"].Value > (decimal)dgvr.Cells["dgvcBoxWished1"].Value)))
{
if (dgvr.Cells["dgvcBoxConfirmed1"].Value == DBNull.Value)
{
dgvr.Cells["dgvcBoxConfirmed1"].Value = 0;
}
else
{
RFMMessage.MessageBoxError("Введено число больше допустимого!");
dgvr.Cells["dgvcBoxConfirmed1"].Value = dgvr.Cells["dgvcBoxWished1"].Value;
}
bValidOK = false;
}
}
private void dgvPieceGoods_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
if (dgvPieceGoods.IsRestoring)
{
return;
}
RFMDataGridView dgv = dgvPieceGoods;
if (dgv.DataSource == null || dgv.CurrentRow == null || dgv.RowCount == 0)
{
return;
}
string ColName = dgv.Columns[e.ColumnIndex].Name;
if (ColName == "dgvcQntConfirmed1" || ColName == "dgvcBoxConfirmed1")
{
DataGridViewRow dgrv = dgv.Rows[e.RowIndex];
decimal nInBox = (decimal)dgrv.Cells["dgvcInBox1"].Value;
if (ColName == "dgvcQntConfirmed1")
{
dgrv.Cells["dgvcBoxConfirmed1"].Value = (decimal)dgrv.Cells["dgvcQntConfirmed1"].Value / nInBox;
}
else
{
if (nInBox == (int)nInBox)
{
dgrv.Cells["dgvcQntConfirmed1"].Value = decimal.Ceiling(decimal.Round((decimal)dgrv.Cells["dgvcBoxConfirmed1"].Value * nInBox, 1));
}
else
{
dgrv.Cells["dgvcQntConfirmed1"].Value = (decimal)dgrv.Cells["dgvcBoxConfirmed1"].Value * nInBox;
}
}
DataRow dr = oOutput.TableOutputsGoods.Rows.Find(dgrv.Cells["dgvcID1"].Value);
if (dr != null)
{
dr["BoxConfirmed"] = dgrv.Cells["dgvcBoxConfirmed1"].Value;
dr["QntConfirmed"] = dgrv.Cells["dgvcQntConfirmed1"].Value;
}
ShowHumanStrikes();
}
}
private void grdData_CurrentRowChanged(object sender)
{
RFMDataGridView grd = (RFMDataGridView)sender;
if (grd.CurrentRow == null || grd.CurrentRow.Index < 0)
{
return;
}
int rowIndex = grd.CurrentRow.Index;
if (grd.IsStatusRow(rowIndex))
{
btnPrint.Enabled =
btnService.Enabled =
false;
}
}
private void dgvTrips_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
RFMDataGridView grd = (RFMDataGridView)sender;
if (grd.DataSource == null || grd.Rows.Count == 0)
{
return;
}
DataGridViewColumn c = grd.Columns[e.ColumnIndex];
string sColumnName = c.Name.ToUpper();
// статусна¤ строка
if (grd.IsStatusRow(e.RowIndex))
{
if (sColumnName.Contains("IMAGE"))
{
e.Value = Properties.Resources.Empty;
}
return;
}
// строка данных
DataRow r = ((DataRowView)((DataGridViewRow)grd.Rows[e.RowIndex]).DataBoundItem).Row;
if (sColumnName.Contains("IMAGE"))
{
String sType = r["Type"].ToString();
switch (sType)
{
case "O":
e.Value = Properties.Resources.Minus;
break;
case "I":
e.Value = Properties.Resources.Plus;
break;
case "$":
e.Value = Properties.Resources.Car_Red;
break;
}
}
}
