private void initStatsGrid() { { DataGridViewColumn col = new DataGridViewColumn(); DataGridViewTypedLinkCell cell = new DataGridViewTypedLinkCell(); cell.SystemType = EditorSystemType.Statistic; col.Name = "statistic_def_id"; col.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; col.FillWeight = 100; col.HeaderText = "Statistic"; col.CellTemplate = cell; gridStatistics.Columns.Add(col); } { DataGridViewNumericUpDownElements.DataGridViewNumericUpDownColumn col = new DataGridViewNumericUpDownElements.DataGridViewNumericUpDownColumn(); DataGridViewNumericUpDownElements.DataGridViewNumericUpDownCell cell = new DataGridViewNumericUpDownElements.DataGridViewNumericUpDownCell(); col.Name = "value"; col.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; col.Width = 50; col.HeaderText = "Starting Value"; col.CellTemplate = cell; col.Maximum = 99999; col.Minimum = -99999; gridStatistics.Columns.Add(col); } { DataGridViewCheckBoxColumn col = new DataGridViewCheckBoxColumn(); DataGridViewCheckBoxCell cell = new DataGridViewCheckBoxCell(); col.Name = "is_exempt"; col.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; col.FillWeight = 25; col.HeaderText = "Is Exempt"; col.CellTemplate = cell; gridStatistics.Columns.Add(col); } }
///******************************************************************************* ///NOMBRE DE LA FUNCIÓN: Habilita_Verticalmente ///DESCRIPCIÓN : Habilita o deshabilita los checkbox del grid verticalmente. ///PARAMENTROS : 1. Grid_Copia_Accesos, GridView del que se va habilitar o deshabilitar /// los checkbox. /// 2. Columna, Indice que indica la columna del grid. /// 3. Fila, Indice que indica la fila del grid. /// 4. Valor, Variable boleana que establece si se habilita o deshabilita /// el checkbox. /// 5. Condicion, Variable String que determina hasta donde avanzara /// verticalmente. ///CREO : Luis Alberto Salas Garcia ///FECHA_CREO : 07/Mar/2013 ///MODIFICO : ///FECHA_MODIFICO: ///CAUSA_MODIFICACIÓN: ///******************************************************************************* private void Habilita_Verticalmente(DataGridView Grid_Copia_Accesos, int Columna, int Fila, bool Valor, String Condicion) { DataGridViewCheckBoxCell Check_Box_Cell = new DataGridViewCheckBoxCell(); for (int i = Fila; i < Grid_Copia_Accesos.RowCount; i++) { if (Grid_Copia_Accesos.Rows[i].Cells[Columna] is DataGridViewCheckBoxCell) { Check_Box_Cell = Grid_Copia_Accesos.Rows[i].Cells[Columna] as DataGridViewCheckBoxCell; if (Grid_Copia_Accesos.Rows[i].Cells["TIPO"].Value.ToString().Equals(Condicion)) { break; } else { Check_Box_Cell.Value = Valor; if (Grid_Copia_Accesos.Columns[Columna].HeaderText.Equals("Habilitar")) { Habilita_Horizontalmente(Grid_Copia_Accesos, Columna + 1, i, Valor); } } } } }
private void btnSave_Click(object sender, EventArgs e) { try { List <Data_PaymentStaging> staging = new List <Data_PaymentStaging>(); foreach (DataGridViewRow i in grdSuppliers.Rows) { DataGridViewCheckBoxCell cell = i.Cells["Selected"] as DataGridViewCheckBoxCell; bool isSelected = Convert.ToBoolean(cell.Value); if (isSelected) { Data_Supplier supplier = i.DataBoundItem as Data_Supplier; if (supplier != null) { staging.Add(new Data_PaymentStaging() { Username = Global.Username, SuppplierId = supplier.SupplierID, Amount = amount }); } } } Data_PaymentStaging.SavePaymentStaging(Global.Username, staging); DialogResult = DialogResult.OK; } catch (Exception ex) { Utils.ShowException(ex); } }
private void initAbilitiesGrid() { { DataGridViewColumn col = new DataGridViewColumn(); DataGridViewTypedLinkCell cell = new DataGridViewTypedLinkCell(); cell.SystemType = EditorSystemType.Ability; col.Name = "ability_def_id"; col.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; col.FillWeight = 150; col.HeaderText = "Ability"; col.CellTemplate = cell; gridAbilities.Columns.Add(col); } { DataGridViewCheckBoxColumn col = new DataGridViewCheckBoxColumn(); DataGridViewCheckBoxCell cell = new DataGridViewCheckBoxCell(); col.Name = "is_exempt"; col.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; col.FillWeight = 25; col.HeaderText = "Is Exempt"; col.CellTemplate = cell; gridAbilities.Columns.Add(col); } }
private void SetupCells() { _poolCheckBoxCell = new DataGridViewCheckBoxCell { ThreeState = true }; _expansionCell = new DataGridViewImageCell(); if (Tag is Pool || (Tag is Host && !_hasPool)) { _poolIconHostCheckCell = new DataGridViewIconCell(); } else { _poolIconHostCheckCell = new DataGridViewCheckBoxCell(); } _nameCell = new DataGridViewNameCell(); _versionCell = new DataGridViewTextBoxCell(); Cells.AddRange(new[] { _expansionCell, _poolCheckBoxCell, _poolIconHostCheckCell, _nameCell, _versionCell }); this.UpdateDetails(); }
private void btnguardarrol_Click(object sender, EventArgs e) { SqlConnection unacon = new Conexiones().conectarse(); List <int> listaderoles; listaderoles = new Rolsql().obtenerRolescoleccion(unacon); if (listaderoles.Contains(int.Parse(txtidrol.Text))) { MessageBox.Show("el numero de rol ya existe"); } else { SqlCommand cmd = new SqlCommand("gdd_maxi.sp_insertarol", unacon); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@id", SqlDbType.Int).Value = txtidrol.Text; cmd.Parameters.Add("@nombre", SqlDbType.NVarChar).Value = txtnombrerol.Text; cmd.Parameters.Add("@estado", SqlDbType.Int).Value = checkBoxhabilitado.Checked; cmd.ExecuteNonQuery(); foreach (DataGridViewRow r in dgvfuncionalidades.Rows) { DataGridViewCheckBoxCell chk = r.Cells["habilitada"] as DataGridViewCheckBoxCell; if (Convert.ToBoolean(chk.Value) == true) { SqlCommand cmd2 = new SqlCommand("gdd_maxi.sp_insertarolxfuncionalidad", unacon); cmd2.CommandType = CommandType.StoredProcedure; cmd2.Parameters.Add("@idrol", SqlDbType.Int).Value = txtidrol.Text; cmd2.Parameters.Add("@idfuncionalidad", SqlDbType.Int).Value = r.Cells["idfuncionalidad"].Value; cmd2.ExecuteNonQuery(); } } } unacon.Close(); }
public DataSourceGridViewRow(DataSourceItem dataSourceItem, bool displayOnGraph) { this.dsi = dataSourceItem; DataGridViewCheckBoxCell displayOnGraphCell = new DataGridViewCheckBoxCell { Value = displayOnGraph }; Cells.Add(displayOnGraphCell); DataGridViewTextBoxCell datasourceCell = new DataGridViewTextBoxCell { Value = dsi.ToString() }; Cells.Add(datasourceCell); DataGridViewTextBoxCell typeCell = new DataGridViewTextBoxCell { Value = dsi.DataType.ToStringI18N() }; Cells.Add(typeCell); DataGridViewTextBoxCell colourCell = new DataGridViewTextBoxCell { Value = dsi.Color }; Cells.Add(colourCell); }
private void dgvView_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e) { if (e.RowIndex == -1) { return; } if (e.ColumnIndex == 0) { int num = 1; List <string> files = new List <string>(); foreach (DataGridViewRow row in dgvView.Rows) { DataGridViewCheckBoxCell cell = row.Cells[0] as DataGridViewCheckBoxCell; if (Convert.ToBoolean(cell.EditingCellFormattedValue) == true) { files.Add(row.Cells["FileColumn"].Value.ToString()); int n = Convert.ToInt32(row.Cells[2].Value); if (n == 1) { row.Cells[4].Value = num.ToString("00000000"); } else { row.Cells[4].Value = num.ToString("00000000") + "-" + (num + n - 1).ToString("00000000"); } num += n; } else { row.Cells[4].Value = ""; } } string info = FilesInfo.GetFilesInfo(files.ToArray()); lblInfo.Text = info; } }
private void DgvListado_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == DgvListado.Columns["Seleccionar"].Index) { DataGridViewCheckBoxCell chkEliminar = (DataGridViewCheckBoxCell) DgvListado.Rows[e.RowIndex].Cells["seleccionar"]; chkEliminar.Value = !Convert.ToBoolean(chkEliminar.Value); bool valor = Convert.ToBoolean(DgvListado.SelectedCells[10].Value); if (valor == true) { chkActivar.Value = true; } else { chkActivar.Value = false; } } //foreach (DataGridViewRow columna in DgvListado.Rows) // { // bool valor = Convert.ToBoolean(columna.Cells[4].Value); // } }
/// <summary> /// get selected row value /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvProcessCardModule_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 0 && e.RowIndex != -1) { DataGridViewCheckBoxCell chkcel = dgvProcessCardModule[e.ColumnIndex, e.RowIndex] as DataGridViewCheckBoxCell; DataGridViewTextBoxCell processProcedureNameCel = dgvProcessCardModule[e.ColumnIndex + 2, e.RowIndex] as DataGridViewTextBoxCell; DataGridViewTextBoxCell processProcedureIdCel = dgvProcessCardModule[e.ColumnIndex + 1, e.RowIndex] as DataGridViewTextBoxCell; string processProcedureName = processProcedureNameCel.Value.ToString(); string processProcedureId = processProcedureIdCel.Value.ToString(); bool isChecked = Convert.ToBoolean(chkcel.EditedFormattedValue); if (isChecked) { if (!selecedProcessCardModuleDic.ContainsKey(processProcedureId)) { selecedProcessCardModuleDic.Add(processProcedureId, processProcedureName); } } else { if (selecedProcessCardModuleDic.ContainsKey(processProcedureId)) { selecedProcessCardModuleDic.Remove(processProcedureId); } } } }
private void IsItemSelected() { bool FoundItem = false; foreach (DataGridViewRow row in dgvMain.Rows) { DataGridViewCheckBoxCell checkCell = (DataGridViewCheckBoxCell)row.Cells["ObjectSelected"]; checkCell.TrueValue = true; if (Convert.ToBoolean(checkCell.Value) == Convert.ToBoolean(checkCell.TrueValue)) { FoundItem = true; } } if (FoundItem) { cmdRestore.Enabled = true; } else { cmdRestore.Enabled = false; } }
private void allShopsDataGrid_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (allShopsDataGrid.Columns[e.ColumnIndex].Name == "Check" && e.RowIndex != -1) { DataGridViewCheckBoxCell checkCell = (DataGridViewCheckBoxCell)allShopsDataGrid.Rows[e.RowIndex].Cells["Check"]; int shopAddressId = -1; if (allShopsDataGrid.Rows[e.RowIndex].Cells["ShopAddressID"].Value != DBNull.Value) { shopAddressId = Convert.ToInt32(allShopsDataGrid.Rows[e.RowIndex].Cells["ShopAddressID"].Value); } bool check = Convert.ToBoolean(checkCell.Value); if (check && shopAddressId != -1) { shopsManager.AddNewShopAddressOrder(shopAddressId); } shopsManager.SaveShopAddressOrders(); shopsManager.SaveShopAddresses(); shopsManager.UpdatesTables(); } }
private void dataGridViewPedidos_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (e.ColumnIndex == (int)Col_Pedidos.RECIBIDO) { DataGridViewCheckBoxCell cellSelecion = dataGridViewPedidos.Rows[e.RowIndex].Cells[(int)Col_Pedidos.RECIBIDO] as DataGridViewCheckBoxCell; if (Convert.ToBoolean(cellSelecion.Value)) { dataGridViewPedidos.Rows[e.RowIndex].Cells[(int)Col_Pedidos.ESTADO].Value = 2; } if (Convert.ToBoolean(cellSelecion.Value) == false) { dataGridViewPedidos.Rows[e.RowIndex].Cells[(int)Col_Pedidos.ESTADO].Value = 1; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button2_Click(object sender, EventArgs e) { Camere camera1 = new Camere(); for (int i = 0; i < dataGridView2.Rows.Count; i++) { DataGridViewCheckBoxCell cell = dataGridView2.Rows[i].Cells[0] as DataGridViewCheckBoxCell; if (cell.Value == cell.TrueValue) { camera1.setDisponibilitate(1, Convert.ToInt32(dataGridView2.Rows[i].Cells[1].Value)); dataGridView2.Rows.RemoveAt(i); //DELETE DIN Facturi } } //preiau din baza de date string query = "SELECT ID_Camera,Tip_camera,Descriere_Facilitati,Nr_Locuri,Disponibilitate,Pret_camera FROM Camere WHERE Disponibilitate = 1;"; string connstring = "Data Source=(localDb)\\Databases;Initial Catalog=BD_Proiect;Integrated Security=True"; DataTable dt = new DataTable(); SqlDataAdapter adt = new SqlDataAdapter(query, connstring); adt.Fill(dt); dataGridView1.DataSource = dt; }
private void dataGridViewConsolidado_CellContentClick(object sender, DataGridViewCellEventArgs e) { try { if (e.ColumnIndex == (int)Col_GridDetalle.INCLUIR && e.RowIndex != -1) { dataGridViewConsolidado.CommitEdit(DataGridViewDataErrorContexts.Commit); //como no desea pediro.. SACO EL TILDE DataGridViewCheckBoxCell cellSelecion = dataGridViewConsolidado.Rows[e.RowIndex].Cells[(int)Col_GridDetalle.INCLUIR] as DataGridViewCheckBoxCell; if (Convert.ToBoolean(cellSelecion.Value)) { //VERIFICO SI ESTE ARTICULO QUE ESTA PIDIENDO TIENE PENDIENTE DE ENTREGA-.... BLL.Procedures.PEDIENTEENTREGAARTICULO _pendiente = new BLL.Procedures.PEDIENTEENTREGAARTICULO(); string _codEmp = Clases.Usuario.EmpresaLogeada.EmpresaIngresada.ToString().Trim(); string _articulo = dataGridViewConsolidado.Rows[e.RowIndex].Cells[(int)Col_GridDetalle.ARTICULO].Value.ToString(); _pendiente.Items(_codEmp, _articulo); if (_pendiente.Resultset[0].diferencia > 0) { DialogResult _result = MessageBox.Show("Este artículo tiene pendiente de entrega, desea pedir cotización de todos modos?", "Mensaje", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (_result == DialogResult.Cancel) { dataGridViewConsolidado.Rows[e.RowIndex].Cells[(int)Col_GridDetalle.INCLUIR].Value = false; //dataGridViewConsolidado.Rows[e.RowIndex].Cells[(int)Col_GridDetalle.INCLUIR].Selected = false; dataGridViewConsolidado.CommitEdit(DataGridViewDataErrorContexts.Commit); } } } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void LoadLgRecordsFromDb() { suspendCellVelueChangedEvent = true; //DataCzasStart,DataCzasKoniec,LiniaSMT,OperatorSMT,NrZlecenia,Model,IloscWykonana,NGIlosc,ScrapIlosc,Kontrola1szt,KoncowkiLED DataTable sqlTable = SqlOperations.GetLgSmtRecordsFromDb(22, smtLine); List <string> lotsList = new List <string>(); foreach (DataRow row in sqlTable.Rows) { lotsList.Add(row["NrZlecenia"].ToString().Trim()); } Dictionary <string, string[]> lotToRankABQty = SqlOperations.lotToRankABQty(lotsList.ToArray()); //dataGridView1.SuspendLayout(); foreach (DataRow row in sqlTable.Rows) { string model = row["Model"].ToString(); if (model[2] == '-') { if (lotToRankABQty.ContainsKey(row["NrZlecenia"].ToString())) { dataGridViewLg.Rows.Insert(0); string lotNo = row["NrZlecenia"].ToString().Trim(); string stencil = row["StencilQR"].ToString(); LedLeftovers ledLeft = CreateLedLeftovers(row["KoncowkiLED"].ToString(), lotNo, lotToRankABQty); DataGridViewCheckBoxCell chbCell = (DataGridViewCheckBoxCell)dataGridViewLg.Rows[0].Cells[0]; chbCell.Value = true; dataGridViewLg.Rows[0].Cells[1].Value = lotNo; string connQty = Tools.GetNumberOfConnectors(row["Model"].ToString().Trim()); dataGridViewLg.Rows[0].Cells[3].Value = connQty; if (connQty == "4") { dataGridViewLg.Rows[0].Cells[3].Style.ForeColor = Color.White; dataGridViewLg.Rows[0].Cells[3].Style.BackColor = Color.DarkCyan; } dataGridViewLg.Rows[0].Cells[2].Value = row["Model"].ToString().Trim(); //dataGridView1.Rows[0].Cells[4].Value = kontrola pierwszej dataGridViewLg.Rows[0].Cells[5].Value = lotToRankABQty[lotNo][2]; dataGridViewLg.Rows[0].Cells[6].Value = ledLeft.RankA[0].Nc12; dataGridViewLg.Rows[0].Cells[7].Value = lotToRankABQty[lotNo][0]; dataGridViewLg.Rows[0].Cells[8].Value = lotToRankABQty[lotNo][1]; dataGridViewLg.Rows[0].Cells[9].Value = row["IloscWykonana"].ToString().Trim(); dataGridViewLg.Rows[0].Cells[10].Value = row["NGIlosc"].ToString().Trim(); dataGridViewLg.Rows[0].Cells[11].Value = row["ScrapIlosc"].ToString().Trim(); dataGridViewLg.Rows[0].Cells[12].Tag = ledLeft; dataGridViewLg.Rows[0].Cells[12].Value = "OK"; dataGridViewLg.Rows[0].Cells[13].Value = DateTime.Parse(row["DataCzasStart"].ToString().Trim()); dataGridViewLg.Rows[0].Cells[14].Value = DateTime.Parse(row["DataCzasKoniec"].ToString().Trim()); Color cellColor = Tools.GetShiftColor((DateTime)row["DataCzasKoniec"]); dataGridViewLg.Rows[0].Cells[13].Style.BackColor = cellColor; dataGridViewLg.Rows[0].Cells[14].Style.BackColor = cellColor; dataGridViewLg.Rows[0].Cells[15].Style.BackColor = cellColor; dataGridViewLg.Rows[0].Cells[15].Value = row["OperatorSMT"].ToString().Trim(); dataGridViewLg.Rows[0].Cells[16].Value = stencil; } } } Tools.AutoSizeColumnsWidth(dataGridViewLg); //dataGridView1.ResumeLayout(); if (dataGridViewLg.Rows.Count > 0) { dataGridViewLg.CurrentCell = dataGridViewLg.Rows[0].Cells[0]; } suspendCellVelueChangedEvent = false; }
private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (!suspendCellVelueChangedEvent) { int ngIndex = dataGridViewLg.Columns.IndexOf(dataGridViewLg.Columns["Ng"]); int scrapIndex = dataGridViewLg.Columns.IndexOf(dataGridViewLg.Columns["Scrap"]); // Debug.WriteLine("Cell value changed: " + e.RowIndex + " " + e.ColumnIndex); //calculate good qty if (dataGridViewLg.Rows.Count > 0 & (e.ColumnIndex == ngIndex || e.ColumnIndex == scrapIndex)) { int rowIndex = e.RowIndex; DataGridViewCell ngCell = dataGridViewLg.Rows[rowIndex].Cells["Ng"]; DataGridViewCell scrapCell = dataGridViewLg.Rows[rowIndex].Cells["Scrap"]; double ngValue = -9999; double scrapValue = -9999; if (ngCell.Value != null) { if (!(double.TryParse(ngCell.Value.ToString(), out ngValue))) { dataGridViewLg.Rows[e.RowIndex].Cells[ngIndex].Value = null; ngValue = -9999; } else { //ng ,0 will be 0 dataGridViewLg.Rows[e.RowIndex].Cells[ngIndex].Value = ngValue; } } if (dataGridViewLg.Columns["Scrap"].Visible) { if (scrapCell.Value != null) { if (!(double.TryParse(scrapCell.Value.ToString(), out scrapValue))) { dataGridViewLg.Rows[e.RowIndex].Cells[scrapIndex].Value = null; scrapValue = -9999; } } } else { scrapValue = 0; } if (ngValue > -9999 & scrapValue > -9999 & dataGridViewLg.Rows[e.RowIndex].Cells["ColumnQty"].Value != null) { double orderedQty = double.Parse(dataGridViewLg.Rows[e.RowIndex].Cells["ColumnQty"].Value.ToString()); double goodQty = orderedQty - ngValue - scrapValue; dataGridViewLg.Rows[e.RowIndex].Cells["goodQty"].Value = goodQty; } else { dataGridViewLg.Rows[e.RowIndex].Cells["goodQty"].Value = ""; } } //saving finished LOT foreach (DataGridViewRow row in dataGridViewLg.Rows) { //Debug.WriteLine("Checking chkBox row:" + row.Index + " " + Convert.ToBoolean(row.Cells["ColumnSaved"].Value)); if (!Convert.ToBoolean(row.Cells["ColumnSaved"].Value)) { if (IsRowReadyToBeSaved(row)) { //Debug.WriteLine("Saving row:" + row.Index); DataGridViewCheckBoxCell ch = (DataGridViewCheckBoxCell)row.Cells["ColumnSaved"]; suspendCellVelueChangedEvent = true; lotFinished(ch, row.Index); suspendCellVelueChangedEvent = false; DateTime startDate = (DateTime)row.Cells["StartDate"].Value; DateTime endDate = (DateTime)row.Cells["EndDate"].Value; string firstPieceCheck = ""; string stencil = Tools.getCellValue(row.Cells["Stencil"]); LedLeftovers ledLeftovers = (LedLeftovers)row.Cells["ColumnButtonLed"].Tag; double totalLedsUsed = 0; string leftovers = ledLeftovers.RankA[0].ID + ":" + ledLeftovers.RankA[0].Nc12 + ":" + ledLeftovers.RankA[0].QtyLeft + "|" + ledLeftovers.RankB[0].ID + ":" + ledLeftovers.RankB[0].Nc12 + ":" + ledLeftovers.RankB[0].QtyLeft; for (int i = 0; i < ledLeftovers.RankA.Count; i++) { totalLedsUsed += ledLeftovers.RankA[i].StartQty - ledLeftovers.RankA[i].QtyLeft; totalLedsUsed += ledLeftovers.RankB[i].StartQty - ledLeftovers.RankB[i].QtyLeft; if (i > 0) { leftovers += "#" + ledLeftovers.RankA[i].ID + ":" + ledLeftovers.RankA[i].Nc12 + ":" + ledLeftovers.RankA[i].QtyLeft + "|" + ledLeftovers.RankB[i].ID + ":" + ledLeftovers.RankB[i].Nc12 + ":" + ledLeftovers.RankB[i].QtyLeft; } } if (row.Cells["ColumnQualityCheck"].Tag != null) { firstPieceCheck = row.Cells["ColumnQualityCheck"].Tag.ToString(); } string scrap = "0"; if (dataGridViewLg.Columns["Scrap"].Visible) { scrap = row.Cells["Scrap"].Value.ToString(); } SqlOperations.SaveRecordToDb( startDate, endDate, smtLine, row.Cells["Operator"].Value.ToString(), row.Cells["ColumnLot"].Value.ToString(), row.Cells["ColumnModel"].Value.ToString(), row.Cells["goodQty"].Value.ToString(), row.Cells["Ng"].Value.ToString(), scrap, firstPieceCheck, leftovers, stencil, "LG", totalLedsUsed); // Debug.WriteLine("Saved"); DgvTools.CleanUpLgiDgv(dataGridViewLg); } } } dataGridViewLg.HorizontalScrollingOffset = 0; } }
private void Dashboard_Shown(object sender, EventArgs e) { try { con.ConnectionString = "Data Source=DESKTOP-69MM1NJ\\SQLEXPRESS;Initial Catalog=NadhamniDB;Integrated Security=True;Pooling=False"; con.Open(); if (Home.NewUser == false) { SqlCommand cmd = new SqlCommand("select * from Tasks where UserName = '******'", con); SqlDataReader dr = cmd.ExecuteReader(); int i = 0; while (dr.Read()) { ViewTasks.Rows.Add(dr[0], dr[2], dr[1], Convert.ToDateTime(dr[3]).ToShortDateString(), dr[4], dr[5], dr[7], dr[8], dr[6], dr[9]); if (dr["Done"].ToString().Equals("yes")) { DataGridViewCheckBoxCell chkchecking = ViewTasks.Rows[i].Cells["Column10"] as DataGridViewCheckBoxCell; chkchecking.Value = true; i++; } } dr.Close(); } // Dashboard Notes if (!Home.Note) { SqlCommand cmd = new SqlCommand("select * from Notes where UserName = '******'", con); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { ViewNotes.Rows.Add(dr[1], dr[2]); } dr.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } try { con.Open(); string selectQuery = "select ProfilePic from Profile where UserName = '******'"; SqlCommand cmd = new SqlCommand(selectQuery, con); SqlDataReader dr = cmd.ExecuteReader(); dr.Read(); if (dr.HasRows) { Byte[] img = (Byte[])(dr[0]); if (img == null) { pictureBox7.Image = null; } else { MemoryStream ms = new MemoryStream(img); pictureBox7.Image = Image.FromStream(ms); } } else { MessageBox.Show("error img not found"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } try { //con.ConnectionString = "Data Source=DESKTOP-AU9FQ00\\SQLEXPRESS;Initial Catalog=NadhamniDB;Integrated Security=True;Pooling=False"; con.Open(); SqlCommand cmd = new SqlCommand("select * from Tasks where DateOfTask='" + (DateTime.Today.AddDays(1)).ToString("yyyy-MM-dd") + "'and UserName='******'", con); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { if (!Tasks.tvisited && !Settings.sevisited && !Statistics.svisited) { string planing = "Today you have to: \n"; string taskname; string statrttime; string location; while (dr.Read()) { taskname = dr[1].ToString(); planing += taskname + "at "; statrttime = dr[4].ToString(); planing += statrttime + "from "; location = dr[7].ToString(); planing += location + "\n"; } planing += "\n for more informations please check your planing"; notifyIcon1.ShowBalloonTip(5000, "Tommorow's planing", planing, ToolTipIcon.Info); notifyIcon1.ShowBalloonTip(5000, "Tommorow's planing", "for more informations,check your tasks", ToolTipIcon.Info); } } dr.Close(); //unusual noti SqlCommand cmd1 = new SqlCommand("select count(*) from Tasks where DateOfTask='" + (DateTime.Today).ToString("yyyy-MM-dd") + "' and TaskType='" + "unusual" + "' and UserName='******'", con); string nbrdays = Convert.ToString(cmd1.ExecuteScalar()); if (Convert.ToInt32(cmd1.ExecuteScalar()) > 0) { notifyIcon1.ShowBalloonTip(5000, "Don't forget", "you have " + nbrdays + " unusal task(s) for today check your planing for more details", ToolTipIcon.Info); } //urgent notif SqlCommand cmd2 = new SqlCommand("select count(*) from Tasks where DateOfTask='" + (DateTime.Today).ToString("yyyy-MM-dd") + "' and TaskType='" + "urgent" + "' and UserName='******'", con); nbrdays = Convert.ToString(cmd2.ExecuteScalar()); if (Convert.ToInt32(cmd2.ExecuteScalar()) > 0) { notifyIcon1.ShowBalloonTip(5000, "Don't forget", "you have " + nbrdays + " urgent task(s) for today check your planing for more details", ToolTipIcon.Info); } } //end try2 catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } //label: username shown try { con.Open(); SqlCommand cmd = new SqlCommand("select FirstName from Profile where UserName='******'", con); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { txt_firstName.Text = dr[0].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } }
private void datagrid1_cellcontent_click(object sender, DataGridViewCellEventArgs e) { string headerText = dataGridView1.Columns[e.ColumnIndex].HeaderText; //MessageBox.Show(headerText); if (headerText == "Select" && e.RowIndex >= 0) { int selindex = dataGridView1.Columns["Select"].Index; Boolean bb = true; //MessageBox.Show("here" + e.RowIndex + "c" + selindex); DataGridViewCheckBoxCell ckb = (DataGridViewCheckBoxCell)dataGridView1.Rows[e.RowIndex].Cells[0]; if ((bool)ckb.Value) { ckb.Value = false; } else { ckb.Value = true; } } if (headerText == "Delete" && e.RowIndex >= 0) { int usnindex = dataGridView1.Columns["EVENT_ID"].Index; String dusn = dataGridView1.Rows[e.RowIndex].Cells[usnindex].Value.ToString(); //MessageBox.Show(dusn); if (MessageBox.Show("Do you want to Delete " + dusn + "?", "DELETE", MessageBoxButtons.YesNo) == DialogResult.Yes) { int retval = delete_events(dusn); if (retval == 1) { MessageBox.Show("Deleted Successfully"); fetch_events(); } } } if (headerText == "Update" && e.RowIndex >= 0) { int eve_idindex = dataGridView1.Columns["EVENT_ID"].Index; int eve_nameindex = dataGridView1.Columns["EVENT_NAME"].Index; int typeindex = dataGridView1.Columns["TYPE"].Index; int descindex = dataGridView1.Columns["DESCRIPTION"].Index; int eve_dateindex = dataGridView1.Columns["EVENT_DATE"].Index; int eve_timeindex = dataGridView1.Columns["EVENT_TIME"].Index; int cateindex = dataGridView1.Columns["CATEGORY"].Index; String uusn = dataGridView1.Rows[e.RowIndex].Cells[eve_idindex].Value.ToString(); if (MessageBox.Show("Do you want to update " + uusn + "?", "UPDATE", MessageBoxButtons.YesNo) == DialogResult.Yes) { textBox1.Text = dataGridView1.Rows[e.RowIndex].Cells[eve_idindex].Value.ToString(); textBox2.Text = dataGridView1.Rows[e.RowIndex].Cells[eve_nameindex].Value.ToString(); string type = dataGridView1.Rows[e.RowIndex].Cells[typeindex].Value.ToString(); comboBox1.SelectedItem = type; string cate = dataGridView1.Rows[e.RowIndex].Cells[cateindex].Value.ToString(); comboBox2.SelectedItem = cate; textBox3.Text = dataGridView1.Rows[e.RowIndex].Cells[descindex].Value.ToString(); textBox4.Text = dataGridView1.Rows[e.RowIndex].Cells[eve_timeindex].Value.ToString(); string dob = dataGridView1.Rows[e.RowIndex].Cells[eve_dateindex].Value.ToString(); string[] dobparms = dob.Split('-'); int day = int.Parse(dobparms[0]); int mon = int.Parse(dobparms[1]); string[] yearparms = dobparms[2].Split(' '); int year = int.Parse(yearparms[0]); dateTimePicker1.Value = new DateTime(year, mon, day); button1.Text = "Update"; //chenge button Add to Update textBox1.Enabled = false; } } }
public void fetch_events() { if (!dataGridView1.Columns.Contains("select")) { dataGridView1.RowHeadersVisible = false; DataGridViewCheckBoxColumn dcol = new DataGridViewCheckBoxColumn(); //add select checkbox to all columns dcol.HeaderText = "Select"; dcol.Name = "select"; dcol.Width = 50; dcol.Frozen = false; dataGridView1.Columns.Add(dcol); } string sql = "select * from event"; // C# OracleCommand ncmd = new OracleCommand(sql, conn); using (OracleDataReader reader = ncmd.ExecuteReader()) { DataTable dataTable = new DataTable(); dataTable.Load(reader); dataGridView1.DataSource = dataTable; } dataGridView1.Columns["EVENT_ID"].Frozen = true; //makes data grid uneditable dataGridView1.Columns["EVENT_NAME"].Frozen = true; dataGridView1.Columns["TYPE"].Frozen = true; dataGridView1.Columns["DESCRIPTION"].Frozen = true; dataGridView1.Columns["EVENT_DATE"].Frozen = true; dataGridView1.Columns["EVENT_TIME"].Frozen = true; dataGridView1.Columns["CATEGORY"].Frozen = true; if (!dataGridView1.Columns.Contains("delete")) { dataGridView1.RowHeadersVisible = false; DataGridViewButtonColumn dcol = new DataGridViewButtonColumn(); //add delete button to all columns dcol.HeaderText = "Delete"; dcol.Text = "delete"; dcol.Name = "delete"; dcol.Width = 50; dcol.UseColumnTextForButtonValue = true; dataGridView1.Columns.Add(dcol); } if (!dataGridView1.Columns.Contains("update")) { DataGridViewButtonColumn ucol = new DataGridViewButtonColumn(); //add update button to all columns ucol.HeaderText = "Update"; ucol.Text = "update"; ucol.Name = "update"; ucol.Width = 50; ucol.UseColumnTextForButtonValue = true; dataGridView1.Columns.Add(ucol); } foreach (DataGridViewRow row in dataGridView1.Rows) { DataGridViewCheckBoxCell chk = (DataGridViewCheckBoxCell)row.Cells[0]; chk.Value = true; chk.Value = false; } }
public frmRegister() { InitializeComponent(); dgvListClass.Columns.Add(new DataGridViewCheckBoxColumn { Name = "choose", TrueValue = true, FalseValue = false, IndeterminateValue = false, Width = 20 }); loadcbTypeuser(); loadcbgrade(); loadcbclass(); loadcbSub(); LoaddgvListClass(); btnExit.Click += btnExit_Click_1; btnLogin.Click += BtnLogin_Click; cmbTypeUser.SelectedIndexChanged += (s, e) => { lblSub.Visible = false; txtClass.Visible = false; lblname.Visible = false; lblGrade.Visible = false; lblbirth.Visible = false; txtName.Visible = false; dtmDOB.Visible = false; cmbSubject.Visible = false; cmbClass.Visible = false; cmbGrade.Visible = false; dgvListClass.Visible = false; if (cmbTypeUser.SelectedValue.ToString() == "HS") { lblname.Visible = true; lblGrade.Visible = true; txtClass.Visible = true; lblbirth.Visible = true; cmbGrade.Visible = true; cmbClass.Visible = true; txtName.Visible = true; dtmDOB.Visible = true; } else if (cmbTypeUser.SelectedValue.ToString() == "GV") { lblSub.Visible = true; txtClass.Visible = true; lblname.Visible = true; lblbirth.Visible = true; cmbSubject.Visible = true; dgvListClass.Visible = true; txtName.Visible = true; dtmDOB.Visible = true; } else if (cmbTypeUser.SelectedValue.ToString() == "AD") { } }; cmbTypeUser.SelectedIndex = 2; btnSignUp.Click += (_, e) => { AccessData acc = new AccessData(); var ID = txtId.Text; var password = txtPass.Text; var sha1 = new SHA1CryptoServiceProvider(); var bytesPw = ASCIIEncoding.ASCII.GetBytes(password); var bytesPwHashed = sha1.ComputeHash(bytesPw); var sb = new StringBuilder(); foreach (byte b in bytesPwHashed) { sb.Append(arrHexa[b >> 4]); sb.Append(arrHexa[b & 15]); } using (var ttn = new QLTTNDataContext()) { ttn.NguoiDungs.InsertOnSubmit(new NguoiDung { maND = ID, maLND = cmbTypeUser.SelectedValue.ToString(), MatKhau = sb.ToString() }); if (cmbTypeUser.SelectedValue.ToString() == "HS") { ttn.HocSinhs.InsertOnSubmit(new HocSinh { maHS = ID, HoTen = txtName.Text, NgaySinh = dtmDOB.Value, maKhoi = cmbGrade.SelectedValue.ToString(), maLop = cmbClass.SelectedValue.ToString() }); } else if (cmbTypeUser.SelectedValue.ToString() == "GV") { ttn.GiaoViens.InsertOnSubmit(new GiaoVien { maGV = ID, HoTen = txtName.Text, NgaySinh = dtmDOB.Value, maMH = cmbSubject.SelectedValue.ToString() }); //Add teaching foreach (DataGridViewRow r in dgvListClass.Rows) { DataGridViewCheckBoxCell chkchecking = r.Cells[0] as DataGridViewCheckBoxCell; if (Convert.ToBoolean(chkchecking.Value)) { ttn.CT_GiangDays.InsertOnSubmit(new CT_GiangDay { maGV = ID, maKhoi = r.Cells[1].Value.ToString(), maLop = r.Cells[2].Value.ToString() }); ttn.SubmitChanges(); } } } ttn.SubmitChanges(); } MessageBox.Show("Đăng Ký Thành Công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); // Nếu đang ký thành công => Sẽ có thông báo Thành Công và đồng thời các TextBox sẽ mất giá trị do [B]ClearTextBox()[/B]. ClearTextBox(); this.Close(); }; }
private void AddContainerAccess(ContainerAccess containerAccess) { DataGridViewRow dr = new DataGridViewRow(); dr.HeaderCell.Value = containerAccess.ContainerAccessDescription; dr.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleLeft; ControlAccess container = containerAccess.GetContainerAccess(); DataGridViewTextBoxCell txtCell = new DataGridViewTextBoxCell(); dr.Cells.Add(txtCell); if (container == null) { MessageBox.Show("缺少窗体控件权限"); return; } dr.Tag = container; for (int i = 0; i < 3; i++) { DataGridViewCheckBoxCell ckbCell = new DataGridViewCheckBoxCell(); dr.Cells.Add(ckbCell); } if (container == null) { dr.Cells[1].Value = true; dr.Cells[2].Value = true; dr.Cells[3].Value = true; } else { dr.Cells[1].Value = (RoleEnums.Operator - container.RoleLevel) >= 0 ? true : false; dr.Cells[2].Value = (RoleEnums.Technician - container.RoleLevel) >= 0 ? true : false; dr.Cells[3].Value = (RoleEnums.Supervisor - container.RoleLevel) >= 0 ? true : false; } this.dgvAccess.Rows.Add(dr); foreach (ControlAccess item in containerAccess.ControlAccessList) { if (item.AccessDesrciption == containerAccess.ContainerAccessDescription) { continue; } dr = new DataGridViewRow(); dr.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleRight; dr.Tag = item; DataGridViewTextBoxCell txtCellChild = new DataGridViewTextBoxCell(); txtCellChild.Style.Alignment = DataGridViewContentAlignment.MiddleLeft; dr.Cells.Add(txtCellChild); for (int i = 0; i < 3; i++) { DataGridViewCheckBoxCell ckbCell = new DataGridViewCheckBoxCell(); dr.Cells.Add(ckbCell); } dr.Cells[0].Value = item.AccessDesrciption; dr.Cells[1].Value = (RoleEnums.Operator - item.RoleLevel) >= 0 ? true : false; dr.Cells[2].Value = (RoleEnums.Technician - item.RoleLevel) >= 0 ? true : false; dr.Cells[3].Value = (RoleEnums.Supervisor - item.RoleLevel) >= 0 ? true : false; this.dgvAccess.Rows.Add(dr); } }
private void Form1_Load(object sender, EventArgs e) { dbFileName = "racion.sqlite"; lbStatusText.Text = "Disconnected"; #region Connect if (!File.Exists(dbFileName)) { MessageBox.Show("Please, create DB and blank table (Push \"Create\" button)"); } try { m_dbConn = new SQLiteConnection("Data Source=" + dbFileName + ";Version=3;"); m_dbConn.Open(); m_sqlCmd.Connection = m_dbConn; lbStatusText.Text = "Connected"; } catch (SQLiteException ex) { lbStatusText.Text = "Disconnected"; MessageBox.Show("Error: " + ex.Message); } #endregion Connect string sql = "SELECT * FROM ingr_tbl"; // Создаем объект DataAdapter adapter = new SQLiteDataAdapter(sql, m_dbConn); // Создаем объект Dataset // Заполняем Dataset adapter.Fill(ds); //Очистка грида GridViewer.Rows.Clear(); GridViewer.Columns.Clear(); GridViewer.Refresh(); // Отображаем данные GridViewer.DataSource = ds.Tables[0]; int i = 0; GridViewer.AllowUserToOrderColumns = false; #region Стиль ячейки var cell = new DataGridViewCheckBoxCell() { TrueValue = "true", FalseValue = "false", }; cell.Style.NullValue = false; //this.dataGridView1.Rows[2].Cells[0] = cell; #endregion Стиль ячейки foreach (DataGridViewColumn col in GridViewer.Columns) { if (i > 3) { //addCheckBoxCell(GridViewer.Rows[0], GridViewer.Rows[0].Cells[i].Value.ToString(),i); //(GridViewer.Rows[0].Cells[i] as DataGridViewCheckBoxCell).Value = true; //(GridViewer[i, 1]. DataGridViewCheckBoxCell).Visible = true; } col.HeaderCell.Value = ds.Tables[0].Rows[1][i]; //заголовки col.SortMode = DataGridViewColumnSortMode.NotSortable; //Сортировка col.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; //Поджать ширину if (i == 0) { col.Visible = false; } i++; } }
public void LoadEditProdList() { int i; //getting first already included products in a transaction if (rent != null) { rent.GetProducts(); //productsSelected = new int[rent.DTable.Rows.Count]; DataRow rRow; for (i = 0; i < rent.DTable.Rows.Count; i++) { rRow = rent.DTable.Rows[i]; productsSelected[i] = Int32.Parse(rRow["ID"].ToString()); } } if (sales != null) { sales.GetProducts(); //productsSelected = new int[sales.DTable.Rows.Count]; DataRow sRow; for (i = 0; i < sales.DTable.Rows.Count; i++) { sRow = sales.DTable.Rows[i]; productsSelected[i] = Int32.Parse(sRow["ID"].ToString()); } } SelectList slist = new SelectList(); slist.GetAllProducts(); dtSelProdList.DataSource = slist.DTable; //inserting checkbox control DataGridViewCheckBoxColumn chkbox = new DataGridViewCheckBoxColumn() { Name = "Check", FalseValue = 0, TrueValue = 1, Visible = true }; dtSelProdList.Columns.Insert(0, chkbox); //initializing checkboxes be checked foreach (DataGridViewRow row in dtSelProdList.Rows) { DataGridViewCheckBoxCell chk = (DataGridViewCheckBoxCell)row.Cells[0]; if (row.Cells["ID"].Value != null) { for (i = 0; i < productsSelected.Length; i++) { if (Int32.Parse(row.Cells[1].Value.ToString()) == productsSelected[i]) { chk.Value = chk.TrueValue; break; } else { chk.Value = chk.FalseValue; } } } } }
private void btnSave_Click(object sender, EventArgs e) { //calculate first total amount Product p; double total = 0.00; if (rent != null) { foreach (DataGridViewRow row in dtSelProdList.Rows) { if (row.Cells["ID"].Value != null) { DataGridViewCheckBoxCell chk = (DataGridViewCheckBoxCell)row.Cells[0]; if (chk.Value == chk.TrueValue) { int prodid = Int32.Parse(row.Cells["ID"].Value.ToString()); p = new Product(); p.ProductId = prodid; p.GetProductInfo(); total += p.RentPrice; } } } rent.TotalAmount = total; //if EDITting products rented if (type == "edit") { //updates the total amount of the selected rent rent.UpdateTransaction(); //unlinks all products to the rent id TransactionProduct transprod = new TransactionProduct(); transprod.TransactionId = rent.TransactionId; transprod.UnLinkRentProducts(); } else //adding NEW rent transaction { //saves the transaction of new rental rent.SaveTransaction(); //gets the rent id SelectList slist = new SelectList(); slist.GetMaxRentalsID(); DataRow rRow = slist.DTable.Rows[0]; rent.TransactionId = Int32.Parse(rRow["Max"].ToString()); } //then links the products selected TransactionProduct tp; foreach (DataGridViewRow row in dtSelProdList.Rows) { if (row.Cells["ID"].Value != null) { DataGridViewCheckBoxCell chk = (DataGridViewCheckBoxCell)row.Cells[0]; if (chk.Value == chk.TrueValue) { tp = new TransactionProduct(); tp.TransactionId = rent.TransactionId; tp.ProductId = Int32.Parse(row.Cells["ID"].Value.ToString()); tp.LinkRentProduct(); } } } if (type == "add") { MessageBox.Show("Transaction Complete!"); } else { MessageBox.Show("Transaction Updated!"); } isDone = true; this.Close(); } if (sales != null) { foreach (DataGridViewRow row in dtSelProdList.Rows) { if (row.Cells["ID"].Value != null) { DataGridViewCheckBoxCell chk = (DataGridViewCheckBoxCell)row.Cells[0]; if (chk.Value == chk.TrueValue) { int prodid = Int32.Parse(row.Cells["ID"].Value.ToString()); p = new Product(); p.ProductId = prodid; p.GetProductInfo(); total += p.Amount; } } } sales.TotalAmount = total; //if EDITting products sold if (type == "edit") { //updates the total amount of the selected rent sales.UpdateTransaction(); //unlinks all products to the sales id TransactionProduct transprod = new TransactionProduct(); transprod.TransactionId = sales.TransactionId; transprod.UnLinkSalesProducts(); } else //adding NEW sales transaction { //saves the transaction of new sales sales.SaveTransaction(); //gets the rent id SelectList slist = new SelectList(); slist.GetMaxSalesID(); DataRow rRow = slist.DTable.Rows[0]; sales.TransactionId = Int32.Parse(rRow["Max"].ToString()); } //then links the products selected TransactionProduct tp; foreach (DataGridViewRow row in dtSelProdList.Rows) { if (row.Cells["ID"].Value != null) { DataGridViewCheckBoxCell chk = (DataGridViewCheckBoxCell)row.Cells[0]; if (chk.Value == chk.TrueValue) { tp = new TransactionProduct(); tp.TransactionId = sales.TransactionId; tp.ProductId = Int32.Parse(row.Cells["ID"].Value.ToString()); tp.LinkSalesProduct(); } } } if (type == "add") { MessageBox.Show("Transaction Complete!"); } else { MessageBox.Show("Transaction Updated!"); } isDone = true; this.Close(); } }
private void btnSubmitOrder_Click(object sender, EventArgs e) { if (ReasonableCheck() == false) { return; } SqlConnection conn = new SqlConnection(Properties.Settings.Default.connDateString); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; DialogResult result = DialogResult.Cancel; int successOrderCount = 0; for (int j = 0; j < deskDataView.Rows.Count; j++) { DataGridViewCheckBoxCell checkCell = (DataGridViewCheckBoxCell)deskDataView.Rows[j].Cells[2]; Boolean flag = Convert.ToBoolean(checkCell.Value); if (flag == true) { List <Dish> dish = new List <Dish>(); deskNum = deskDataView.Rows[j].Cells[0].Value.ToString(); orderNum = ControlOrderClass.GetNowOrderNum(); for (int k = 0; k < tempDish.Count; k++) { Dish temp = tempDish[k]; temp.deskID = deskNum; temp.orderNum = orderNum; dish.Add(temp); } //orderMsg是订单信息,构造这个订单信息的字符串并打印,用于确认订单信息。 StringBuilder orderMsg = new StringBuilder(); orderMsg.Append("\t\t请确认订单信息\n\n"); orderMsg.Append("订单号:" + orderNum + "\t" + "单位:人民币(元)\n"); orderMsg.Append("---------------------------------------------------------------\n"); orderMsg.Append("顾客:" + nowOrderDishCustomerName + "\t\t" + "联系方式:" + nowOrderDishCustomerID + "\n"); orderMsg.Append("---------------------------------------------------------------\n"); cmd.CommandText = string.Format("select Rname from Room where Rid in (select Droomid from Desk where Did = '{0}');", deskNum); string roomName = cmd.ExecuteScalar().ToString(); orderMsg.Append("房间:" + roomName + "\t\t" + "餐桌:" + deskNum + "\n"); orderMsg.Append("===================================\n"); orderMsg.Append("菜的编号\t菜的种类 \t 菜名\t\t菜价\n"); //以下是菜的具体信息 for (int i = 0; i < tempDish.Count; i++) { cmd.CommandText = string.Format("select Fname, Fprice from Menu where Fid = '{0}';", tempDish[i].foodID); SqlDataReader sdr = cmd.ExecuteReader(); string tempFoodNname = ""; float tempFoodPrice = 0; if (sdr.Read()) { tempFoodNname = sdr["Fname"].ToString(); tempFoodPrice = float.Parse(sdr["Fprice"].ToString()); } orderMsg.Append("---------------------------------------------------------------\n"); orderMsg.Append(string.Format("{0}\t {1}\t{2,-10}\t{3:f2}\n", tempDish[i].foodID, tempDish[i].foodType, tempFoodNname, tempFoodPrice)); sdr.Dispose(); sdr.Close(); } orderMsg.Append("===================================\n"); orderMsg.Append(string.Format("\t\t\t已选{0}道菜,总计{1:f2}元\n", count, orderMoney)); DateTime now = DateTime.Now; sqlDate = now.ToString("yyyy-MM-dd");//当天的 result = MessageBox.Show(orderMsg.ToString(), "确认提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (result == DialogResult.OK) { StringBuilder strSQLinsert = new StringBuilder(); strSQLinsert.Append("insert "); strSQLinsert.Append("into CustomerDesk(Ctellphone, Did, Ordernum, Orderdate, Ifcheckout, Ordermoney) "); strSQLinsert.Append( string.Format ("values('{0}','{1}','{2}','{3}','否',{4});", nowOrderDishCustomerID, deskNum, orderNum, sqlDate, orderMoney)); cmd.CommandText = strSQLinsert.ToString(); cmd.ExecuteNonQuery(); cmd.CommandText = string.Format("update Desk set Difuse = '是' where Did = '{0}';", deskNum); cmd.ExecuteNonQuery(); StringBuilder strUpdateRoom = new StringBuilder(); strUpdateRoom.Append("update Room "); strUpdateRoom.Append("set Rusedesks = Rusedesks + 1 "); strUpdateRoom.Append("where Rid in "); strUpdateRoom.Append(" (select Droomid "); strUpdateRoom.Append(" from Desk "); strUpdateRoom.Append(string.Format(" where Did = '{0}');", deskNum)); cmd.CommandText = strUpdateRoom.ToString(); cmd.ExecuteNonQuery(); for (int i = 0; i < dish.Count; i++) { ControlOrderClass.GetDish(dish[i]); StringBuilder strSQLinsertDeskMenu = new StringBuilder(); strSQLinsertDeskMenu.Append("insert "); strSQLinsertDeskMenu.Append("into DeskMenu(Did, Fid, Ordernum, Ifservedish) "); strSQLinsertDeskMenu.Append( string.Format("values('{0}', '{1}', '{2}', '否')" , dish[i].deskID, dish[i].foodID, dish[i].orderNum)); cmd.CommandText = strSQLinsertDeskMenu.ToString(); cmd.ExecuteNonQuery(); } successOrderCount++; } //END if 点击确认正式下单并更新后台数据库 } //END if 桌子为勾选状态 } //END for 每张桌子 MessageBox.Show("成功提交" + successOrderCount + "个订单,请耐心等候!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); orderDishListBox.Items.Clear(); orderDishListBox.Items.Add("菜编号 菜名 菜价"); count = 0; orderMoney = 0; summaryLabel.Text = string.Format("已选{0}道菜,共计:{1}元", count, orderMoney); cmd.Dispose(); conn.Dispose(); conn.Close(); tempDish.Clear(); this.Close(); }
public DataGridViewCell GetCell(PropertyInfo property) { var lockProperInfo = property as LockedByPropertyInfo; if (lockProperInfo != null) { var cell = new DataGridViewImageCell(); if (lockProperInfo.IsLocked) { cell.Value = Resources.img_locked; } if (!lockProperInfo.IsLockedByMe) { cell.Value = Resources.img_locked_else; } if (!lockProperInfo.IsLocked) { cell.Value = null; } return(cell); } if (property.DataType == PropertyDataType.Boolean) { var cell = new DataGridViewCheckBoxCell(); cell.Value = property.PropertyValue == "1"; return(cell); } if (property.DataType == PropertyDataType.Color) { var cell = new DataGridViewTextBoxCell(); var color = string.IsNullOrEmpty(property.PropertyValue) ? Color.White : System.Drawing.ColorTranslator.FromHtml(property.PropertyValue); cell.Style.BackColor = color; return(cell); } if (property.DataType == PropertyDataType.ColorList) { var colors = (property as ColorListPropertyInfo).ColorSource; var cell = new DataGridViewTextBoxCell(); string value = property.PropertyValue ?? string.Empty; string label; if (!colors.TryGetValue(value, out label)) { label = value; } var color = string.IsNullOrEmpty(value) ? Color.White : ColorTranslator.FromHtml(value); cell.Value = label; cell.Style.BackColor = color; return(cell); } if (property.DataType == PropertyDataType.Date) { var cell = new DataGridViewCalendarCell(); DateTime dt; if (DateTime.TryParse(property.PropertyValue, out dt)) { cell.Value = dt; } else { cell.Value = property.PropertyValue; } return(cell); } if (property.DataType == PropertyDataType.Item) { var cell = new DataGridViewTextBoxCell(); cell.Value = property.Label; return(cell); } var defaultCell = new DataGridViewTextBoxCell(); defaultCell.Value = property.PropertyValue; return(defaultCell); }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.Columns[e.ColumnIndex].Name == "计算" && e.RowIndex >= 0) { //获取DataGridView中CheckBox的Cell DataGridViewCheckBoxCell dgvCheck = (DataGridViewCheckBoxCell)(dataGridView1.Rows[this.dataGridView1.CurrentCell.RowIndex].Cells["计算"]); double score = 0; double credit = 0; double point = 0; //根据单击时,Cell的值进行处理。EditedFormattedValue和Value均可以 //若单击时,CheckBox没有被勾上 if (Convert.ToBoolean(dgvCheck.EditedFormattedValue) == false) { dgvCheck.Value = true; String numeber1 = dataGridView1.CurrentRow.Cells["score"].Value.ToString(); String numeber2 = dataGridView1.CurrentRow.Cells["credits"].Value.ToString(); score = double.Parse(numeber1); if (score > 89) { point = 4.0; } else if (score > 84) { point = 3.7; } else if (score > 81) { point = 3.3; } else if (score > 77) { point = 3.0; } else if (score > 74) { point = 2.7; } else if (score > 71) { point = 2.3; } else if (score > 67) { point = 2.0; } else if (score > 63) { point = 1.5; } else if (score > 59) { point = 1.0; } else { point = 0; } credit = double.Parse(numeber2); creditscore += score * credit; creditpoint += point * credit; countcredit += credit; } //若单击时,CheckBox已经被勾上 else { dgvCheck.Value = false; String numeber1 = dataGridView1.CurrentRow.Cells["成绩"].Value.ToString(); String numeber2 = dataGridView1.CurrentRow.Cells["学分"].Value.ToString(); score = double.Parse(numeber1); if (score > 89) { point = 4.0; } else if (score > 84) { point = 3.7; } else if (score > 81) { point = 3.3; } else if (score > 77) { point = 3.0; } else if (score > 74) { point = 2.7; } else if (score > 71) { point = 2.3; } else if (score > 67) { point = 2.0; } else if (score > 63) { point = 1.5; } else if (score > 59) { point = 1.0; } else { point = 0; } credit = double.Parse(numeber2); creditscore -= score * credit; creditpoint -= point * credit; countcredit -= credit; } } }
private void toolStripButtonSave_Click(object sender, EventArgs e) { try { Entities.Tables.COMORDENCOMPRA _OCCabecera = new Entities.Tables.COMORDENCOMPRA(); BLL.Tables.COMORDENCOMPRA _OCCab = new BLL.Tables.COMORDENCOMPRA(); Entities.Tables.COMORDENCOMPRAITEM _OCItem = new Entities.Tables.COMORDENCOMPRAITEM(); List <Entities.Tables.COMORDENCOMPRAITEM> _ItemsCab = new List <Entities.Tables.COMORDENCOMPRAITEM>(); Boolean _selecciono = false; if (this.dataGridViewDetalleReqCotizados.Rows.Count > 0) { //cabecera _OCCabecera.FECHA = Convert.ToDateTime(DateTime.Now.ToShortDateString()); //FECHA _OCCabecera.PROVEED_ID = dataGridViewProveedorCotizado.Rows[dataGridViewProveedorCotizado.CurrentRow.Index].Cells[(int)Col_Proveedores.PROVEEDOR_ID].Value.ToString(); // PROVEEDOR _OCCabecera.ESTADO_ID = 1; //Ojo ver que valor se envia despues //ESTADO _OCCabecera.TIPOOC_ID = 3; //OJO COLOCAR EL VALOR REAL DE ORDEN DE COMPRA SEGUN REQUERIMIENTO _OCCabecera.MODIFICACOSTO = 0; //MODIFICA COSTO string _codEmp = this.comboBoxEmpresa.SelectedValue.ToString(); _OCCabecera.CODEMP = _codEmp; _OCCabecera.CONDICIONPAGO_ID = "0"; // CONDICIOND DE PAGO _OCCabecera.OBS = this.textBoxObs.Text.Trim(); //OBS _OCCabecera.USUARIO = Clases.Usuario.UsuarioLogeado.usuario_Logeado; int _nroCotizacion = Convert.ToInt32(dataGridViewProveedorCotizado.Rows[dataGridViewProveedorCotizado.CurrentRow.Index].Cells[(int)Col_Proveedores.NROCOTIZACION].Value.ToString()); for (int i = 0; i < this.dataGridViewDetalleReqCotizados.Rows.Count; i++) { _OCItem = new Entities.Tables.COMORDENCOMPRAITEM(); //RECUPERO LOS ITEMS DE ESTA COTIZACION DataGridViewCheckBoxCell cellSelecion = dataGridViewDetalleReqCotizados.Rows[i].Cells[(int)Col_items.INCLUIR] as DataGridViewCheckBoxCell; if (Convert.ToBoolean(cellSelecion.Value)) { //VOY GUARDANSDO LOS ITEMS DE LA ORDEN DE COMPRA _selecciono = true; _OCItem.ARTICULO_ID = dataGridViewDetalleReqCotizados.Rows[i].Cells[(int)Col_items.ARTICULO_ID].Value.ToString(); _OCItem.UNIMED = dataGridViewDetalleReqCotizados.Rows[i].Cells[(int)Col_items.UNIMED].Value.ToString(); _OCItem.PRECIO = Convert.ToDecimal(dataGridViewDetalleReqCotizados.Rows[i].Cells[(int)Col_items.PRECIO].Value.ToString(), culture); _OCItem.CANTIDAD = Convert.ToDecimal(dataGridViewDetalleReqCotizados.Rows[i].Cells[(int)Col_items.CANTIDAD].Value.ToString(), culture); _OCItem.FECHAENTREGA = Convert.ToDateTime(this.dateTimePickerFechaEntrega.Value.ToShortDateString()); _OCItem.NIVELAUT_ID = 1; //ojo ver como se envia despues _OCItem.CODEMPREQUERIMIENTO = _codEmp; //VOY AGREGANDO A LA COLECCION _ItemsCab.Add(_OCItem); } } if (!_selecciono) { MessageBox.Show("Para generar una Orden de Compra, debe seleccionar al menos un artículo", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //LLAMO A LA FUNCION QUE GUARDA CABECERA E ITEMS int _NroOC; _NroOC = _OCCab.GeneraOrdenDeCompraSegunCotizacion(_OCCabecera, _ItemsCab, _nroCotizacion); if (_NroOC > 0) { MessageBox.Show("Se generó la orden de compra Nro:" + " " + _NroOC, "Mensaje", MessageBoxButtons.OK, MessageBoxIcon.Information); dataGridViewDetalleReqCotizados.Rows.Clear(); this.dateTimePickerFechaEntrega.Value = Convert.ToDateTime(DateTime.Now.ToShortDateString()); string _empresa = this.comboBoxEmpresa.SelectedValue.ToString(); TraeProveedoresCotizados(_empresa); } else { MessageBox.Show("Error al grabar Orden de Compra", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
internal bool HasDifferences() // find out whether there are differences, if not the dialog does not need to be shown { // at the same time prepare dialog (for the case that there are differences) // remove all 'questionable systems' (systems for which exchange-rate differs) from ratesGlobal // and put them into the data-grid (for further treatment by the user) // also add exchange-rates from ratesCountry which do not (yet) exist in ratesGlobal to the data-grid foreach (ExchangeRate rateCountry in ratesCountry) { foreach (string system in rateCountry.ValidForToList()) { ExchangeRate matchingGlobal = null; foreach (ExchangeRate rateGlobal in ratesGlobal) { if (rateCountry.Country.ToLower() != rateGlobal.Country.ToLower()) { continue; } if (!rateGlobal.ValidForToList().Contains(system)) { continue; } matchingGlobal = rateGlobal; break; } if (matchingGlobal != null && matchingGlobal.DefaultRate() == rateCountry.DefaultRate()) { continue; // exchange-rate exists and is equal } if (matchingGlobal == null) // exchange-rate does not (yet) exist in global table { if (rateCountry.DefaultRate() == 1) { continue; // euro-country } int iRow = dgvDiff.Rows.Add(rateCountry.Country, system, rateCountry.DefaultRate(), "n/a", true, false, ExchangeRate.JUNE30, "Rate does not (yet) exist in global table."); DataGridViewCheckBoxCell check = dgvDiff.Rows[iRow].Cells[colTakeGlobal.Index] as DataGridViewCheckBoxCell; check.ReadOnly = true; check.Style.BackColor = Color.LightGray; } else // exchange-rate exists, but is different { string hint = string.Empty; if (matchingGlobal.June30 == rateCountry.DefaultRate()) { hint = ExchangeRate.JUNE30; } else if (matchingGlobal.YearAverage == rateCountry.DefaultRate()) { hint = ExchangeRate.YEARAVERAGE; } else if (matchingGlobal.FirstSemester == rateCountry.DefaultRate()) { hint = ExchangeRate.FIRSTSEMESTER; } else if (matchingGlobal.SecondSemester == rateCountry.DefaultRate()) { hint = ExchangeRate.SECONDSEMESTER; } if (hint != string.Empty) { hint = string.Format("Country exchange rate matches with global table '{0}': consider changing 'Rate Type'.", hint); } int iRow = dgvDiff.Rows.Add(matchingGlobal.Country, system, rateCountry.DefaultRate(), matchingGlobal.DefaultRate(), false, true, matchingGlobal.Default, hint); dgvDiff.Rows[iRow].Tag = matchingGlobal; matchingGlobal.RemoveFromValidFor(system); // remove the system (to add on OK in the way user choses) } } } return(dgvDiff.Rows.Count > 0); }