private void gvProjView_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { DataRowView drv = e.Row as DataRowView; if (drv != null) { DataRow dr = drv.Row; if (dr != null) { SqlCommand cmd = daInsertUpdate.SelectCommand; object oID = dr["id"]; if (oID == null || oID.Equals(0)) { oID = DBNull.Value; } cmd.Parameters["@id"].Value = oID; cmd.Parameters["@supplier_id"].Value = dr["supplier_id"]; cmd.Parameters["@insur_type_id"].Value = dr["insur_type_id"]; cmd.Parameters["@expiry_date"].Value = dr["expiry_date"]; cmd.Parameters["@rule_warning"].Value = dr["rule_warning"]; cmd.Parameters["@rule_restrict"].Value = dr["rule_restrict"]; cmd.Parameters["@rule_accrual"].Value = dr["rule_accrual"]; cmd.Parameters["@rule_payment"].Value = dr["rule_payment"]; cmd.Parameters["@rule_holdback_release"].Value = dr["rule_holdback_release"]; cmd.Parameters["@rule_po"].Value = dr["rule_po"]; cmd.Parameters["@webrule_internal_alert"].Value = dr["webrule_internal_alert"]; cmd.Parameters["@webrule_warn_contractor"].Value = dr["webrule_warn_contractor"]; cmd.Parameters["@webrule_restrict_payment_req"].Value = dr["webrule_restrict_payment_req"]; cmd.Parameters["@pri_id"].Value = dr["pri_id"]; cmd.Parameters["@active"].Value = dr["active"]; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); try { da.Fill(dt); if (dt != null) { if (dt.Rows.Count > 0) { DataRow dtdr = dt.Rows[0]; if (dtdr != null) { dr.BeginEdit(); dr["id"] = dtdr["id"]; dr.AcceptChanges(); } } } } catch (SqlException) { Popup.ShowPopup("Error saving record."); } finally { if (cmd.Connection.State == System.Data.ConnectionState.Open) { cmd.Connection.Close(); } da.Dispose(); } } } }
private void gridView2_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { try { int id; string cspot; string cspot2; string address; double?ypeni; double?y0; double?yakt; double?y1; double?y2; double?y3; double?y4; double?y5; double?y6; double?y7; double?y8; var rowHandle = gridView2.FocusedRowHandle; id = (int)gridView2.GetRowCellValue(rowHandle, "id"); if (gridView2.GetRowCellValue(rowHandle, "cspot") is DBNull || gridView2.GetRowCellValue(rowHandle, "cspot") == "") { cspot = null; } else { cspot = (string)gridView2.GetRowCellValue(rowHandle, "cspot"); } if (gridView2.GetRowCellValue(rowHandle, "cspot2") is DBNull || gridView2.GetRowCellValue(rowHandle, "cspot2") == "") { cspot2 = null; } else { cspot2 = (string)gridView2.GetRowCellValue(rowHandle, "cspot2"); } if (gridView2.GetRowCellValue(rowHandle, "address") is DBNull || gridView2.GetRowCellValue(rowHandle, "address") == "") { address = null; } else { address = (string)gridView2.GetRowCellValue(rowHandle, "address"); } if (gridView2.GetRowCellValue(rowHandle, "ypeni") is DBNull || gridView2.GetRowCellValue(rowHandle, "ypeni") == "") { ypeni = 0; } else { ypeni = (double)gridView2.GetRowCellValue(rowHandle, "ypeni"); } if (gridView2.GetRowCellValue(rowHandle, "y0") is DBNull || gridView2.GetRowCellValue(rowHandle, "y0") == "") { y0 = 0; } else { y0 = (double)gridView2.GetRowCellValue(rowHandle, "y0"); } if (gridView2.GetRowCellValue(rowHandle, "yakt") is DBNull || gridView2.GetRowCellValue(rowHandle, "yakt") == "") { yakt = 0; } else { yakt = (double)gridView2.GetRowCellValue(rowHandle, "yakt"); } if (gridView2.GetRowCellValue(rowHandle, "y1") is DBNull || gridView2.GetRowCellValue(rowHandle, "y1") == "") { y1 = 0; } else { y1 = (double)gridView2.GetRowCellValue(rowHandle, "y1"); } if (gridView2.GetRowCellValue(rowHandle, "y2") is DBNull || gridView2.GetRowCellValue(rowHandle, "y2") == "") { y2 = 0; } else { y2 = (double)gridView2.GetRowCellValue(rowHandle, "y2"); } if (gridView2.GetRowCellValue(rowHandle, "y3") is DBNull || gridView2.GetRowCellValue(rowHandle, "y3") == "") { y3 = 0; } else { y3 = (double)gridView2.GetRowCellValue(rowHandle, "y3"); } if (gridView2.GetRowCellValue(rowHandle, "y4") is DBNull || gridView2.GetRowCellValue(rowHandle, "y4") == "") { y4 = 0; } else { y4 = (double)gridView2.GetRowCellValue(rowHandle, "y4"); } if (gridView2.GetRowCellValue(rowHandle, "y5") is DBNull || gridView2.GetRowCellValue(rowHandle, "y5") == "") { y5 = 0; } else { y5 = (double)gridView2.GetRowCellValue(rowHandle, "y5"); } if (gridView2.GetRowCellValue(rowHandle, "y6") is DBNull || gridView2.GetRowCellValue(rowHandle, "y6") == "") { y6 = 0; } else { y6 = (double)gridView2.GetRowCellValue(rowHandle, "y6"); } if (gridView2.GetRowCellValue(rowHandle, "y7") is DBNull || gridView2.GetRowCellValue(rowHandle, "y7") == "") { y7 = 0; } else { y7 = (double)gridView2.GetRowCellValue(rowHandle, "y7"); } if (gridView2.GetRowCellValue(rowHandle, "y8") is DBNull || gridView2.GetRowCellValue(rowHandle, "y8") == "") { y8 = 0; } else { y8 = (double)gridView2.GetRowCellValue(rowHandle, "y8"); } if (id < 0) { this.deb_promTableAdapter.InsertQuery(cspot, cspot2, address, ypeni, y0, yakt, y1, y2, y3, y4, y5, y6, y7, y8, Globals.prava_mod_spr_res.ToString()); if (Globals.id_res == 1) { this.deb_promTableAdapter.FillBySever(this.uristDataSet1.deb_prom); } else if (Globals.id_res == 14) { this.deb_promTableAdapter.FillByTalas(this.uristDataSet1.deb_prom); } else { if (Globals.id_zavis != 1 || Globals.id_zavis != 14) { if (Globals.id_res == 5 || Globals.id_res == 6 || Globals.id_res == 7 || Globals.id_res == 8 || Globals.id_res == 9 || Globals.id_res == 11 || Globals.id_res == 13 || Globals.id_res == 4 || Globals.id_res == 10 || Globals.id_res == 12 || Globals.id_res == 17 || Globals.id_res == 18 || Globals.id_res == 16 || Globals.id_res == 15 || Globals.id_res == 19) { this.deb_promTableAdapter.FillByRes1(this.uristDataSet1.deb_prom, Globals.id_res); } else { this.deb_promTableAdapter.FillByRes(this.uristDataSet1.deb_prom, Globals.id_res); } } else { this.deb_promTableAdapter.FillByUchastok(this.uristDataSet1.deb_prom, Globals.id_res.ToString()); } } } else { this.deb_promTableAdapter.UpdateQuery2(address, ypeni, y0, yakt, y1, y2, y3, y4, y5, y6, y7, y8, id); if (Globals.id_res == 1) { this.deb_promTableAdapter.FillBySever(this.uristDataSet1.deb_prom); } else if (Globals.id_res == 14) { this.deb_promTableAdapter.FillByTalas(this.uristDataSet1.deb_prom); } else { if (Globals.id_zavis != 1 || Globals.id_zavis != 14) { if (Globals.id_res == 5 || Globals.id_res == 6 || Globals.id_res == 7 || Globals.id_res == 8 || Globals.id_res == 9 || Globals.id_res == 11 || Globals.id_res == 13 || Globals.id_res == 4 || Globals.id_res == 10 || Globals.id_res == 12 || Globals.id_res == 17 || Globals.id_res == 18 || Globals.id_res == 16 || Globals.id_res == 15 || Globals.id_res == 19) { this.deb_promTableAdapter.FillByRes1(this.uristDataSet1.deb_prom, Globals.id_res); } else { this.deb_promTableAdapter.FillByRes(this.uristDataSet1.deb_prom, Globals.id_res); } } else { this.deb_promTableAdapter.FillByUchastok(this.uristDataSet1.deb_prom, Globals.id_res.ToString()); } } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void gridView2_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { btnSave.Enabled = true; }
private void layer_gw_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { cUS_LAYER_TBTableAdapter.Adapter.Update(layers_ds); }
private void Pasaporte_gridView_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { _GlobalDataContext.SubmitChanges(); }
private void gvComPur_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { daCommPurpose.Update(dsCommPurpose1); }
private void grdViewItems_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { RefreshAmounts(); }
//tự dộng cập nhật dữ liệu khi sửa trực tiếp trên Gridcontrol private void gv_mathang_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { MH.sua(this); }
private void gridView1_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { dbContext.SaveChanges(); }
private void DetailView_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { cUS_MAP_CHANNEL_TBTableAdapter.Adapter.Update(mapChannelDs); }
// delivery rates private void gridViewDeliveryRates_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { this.ExportToCSV(gridControlDeliveryRates, deliveryFile); }
private void gridView1_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { mySqlDataAdapter1.Update(mySqlDataTable1); }
private void grdvMethodStandards_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { SetEditorMode(true); }
private void gridView1_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { AGlobalDataContext.SubmitChanges(); bindingSource1.DataSource = AGlobalDataContext.Agrupacion; }
private void subchannel_gw_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { cUS_SUBCHANNEL_DIRECTORY_TBTableAdapter.Adapter.Update(subchannel_ds); }
private void grdvProductionPrograms_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { SetEditorMode(true); }
private void gvLevy_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { daLevySearch.Update(dsLevySearch1); }
private void mapBrc_gw_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { cUS_MAP_BRC_TBTableAdapter.Adapter.Update(mapBrcDs); }
private void gvDocMerge_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { daDocMergeLibraryItems.Update(dsDocMergeLibraryItems1); }
private void graphics_gw_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { cUS_GRAPHICS_COMPLEX_TBTableAdapter.Adapter.Update(graphics_ds); }
private void grdvInspectStandards_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { grdvInspectStandards.BestFitColumns(); SetEditorMode(true); }
private void grdViewAddGSM_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { paperStockManagementDB.SaveChanges(); }
private void gridView1_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { btn_Luu_Lai.Enabled = true; _listUpdate.Add(e.RowHandle); }
private void CuentasEmpresa_gridView_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { AGlobalDataContext.SubmitChanges(); }
private void layoutView_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { Save(); clientFactory.DataPageRefresh <StaffSchClass>(); }
private void layoutView_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { Save(); }
private void gridView1_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { //QuantityPerUnit.OptionsColumn.AllowEdit = false; }
private void gvDetail_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { DataRow dr = gvDetail.GetDataRow(gvDetail.FocusedRowHandle); if (dr != null) { object oPriID = dr["PRI_ID"]; if (oPriID == null || oPriID == DBNull.Value) { oPriID = "null"; } object olv1ID = dr["lv1ID"]; if (olv1ID == null || olv1ID == DBNull.Value) { olv1ID = "null"; } object olv2ID = dr["lv2ID"]; if (olv2ID == null || olv2ID == DBNull.Value) { olv2ID = "null"; } object olv3ID = dr["lv3ID"]; if (olv3ID == null || olv3ID == DBNull.Value) { olv3ID = "null"; } object olv4ID = dr["lv4ID"]; if (olv4ID == null || olv4ID == DBNull.Value) { olv4ID = "null"; } object oLem = dr["LEM_COMP"]; if (oLem == null || oLem == DBNull.Value) { oLem = "null"; } else { oLem = "'" + oLem + "'"; } object oExpense = dr["EXPENSE_TYPE"]; if (oExpense == null || oExpense == DBNull.Value) { oExpense = "null"; } else { oExpense = "'" + oExpense + "'"; } object oReference = dr["REFERENCE"]; if (oReference == null || oReference == DBNull.Value) { oReference = "null"; } else { oReference = "'" + oReference + "'"; } string sUpdate = "update ap_gl_alloc set " + "gl_account='" + dr["GL_ACCOUNT"] + "', " + "pri_id=" + oPriID + ", " + "lv1id=" + olv1ID + ", " + "lv2id=" + olv2ID + ", " + "lv3id=" + olv3ID + ", " + "lv4id=" + olv4ID + ", " + "lem_comp=" + oLem + ", " + "expense_type=" + oExpense + ", " + "reference=" + oReference + " " + "where ap_gl_alloc_id=" + dr["AP_GL_ALLOC_ID"]; Connection.SQLExecutor.ExecuteNonQuery(sUpdate, Connection.TRConnection); } }
private void gridView1_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { }
private void variable_gw_RowUpdated(object sender, DevExpress.XtraGrid.Views.Base.RowObjectEventArgs e) { cUS_VARIABLE_REFERENCE_TBTableAdapter.Adapter.Update(variable_ds); }