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