/// <summary> /// Called when a colum has changed. /// </summary> /// <param name="e">The event args.</param> protected override void OnColumnChanged(DataColumnChangeEventArgs e) { base.OnColumnChanged(e); if (IsColumnEligible(e.Column, DataColumnPropertyKey.ExcludeFromUpdate)) { if (!changedEligibleColumns.ContainsKey(e.Row)) { changedEligibleColumns.Add(e.Row, new List <DataColumn>()); } if (!changedEligibleColumns[e.Row].Contains(e.Column)) { changedEligibleColumns[e.Row].Add(e.Column); } } }
private void OnColumnChanged_Handler(Object sender, DataColumnChangeEventArgs e) { DataTable dt = (DataTable)sender; if ((e.Column.Equals(dt.Columns["Value"])) && (e.Row.Equals(dt.Rows[0])) && (e.ProposedValue.Equals("NewValue"))) { EventValues = true; } else { EventValues = false; } EventRaised = true; }
private void Acp25_ColumnChanged(object sender, DataColumnChangeEventArgs e) { var dr = e.Row as klonsDataSet.Acp25Row; if (e.Column != MyData.DataSetKlons.Acp25.idxColumn) { return; } var drp = MyData.DataSetKlons.AcPVN.FindByid(dr.idx); if (drp == null) { return; } dr.Name = drp.NM.LeftMax(150); }
void fMain0_ColumnChanged(object sender, DataColumnChangeEventArgs e) { switch (e.Column.ColumnName) { case "DT": foreach (DataRow dr in dsData.Tables[1].Rows) { dr["DT"] = drMain["DT"]; } break; case "isNo": break; } e.Row.EndEdit(); }
private void UD100_AfterFieldChange(object sender, DataColumnChangeEventArgs args) { // ** Argument Properties and Uses ** // args.Row["FieldName"] // args.Column, args.ProposedValue, args.Row // Add Event Handler Code switch (args.Column.ColumnName) { case "CheckBox01": if (!(bool)args.ProposedValue) { args.Row["Character02"] = string.Empty; } break; } }
/// <summary> /// Eventhandler for the datatable of strings /// </summary> private void stringsTable_ColumnChanging(object sender, DataColumnChangeEventArgs e) { var colNameKey = Properties.Resources.ColNameKey; if (e.Column == e.Column.Table.Columns[colNameKey]) { var foundRows = e.Column.Table.Select("Key='" + e.ProposedValue + "'"); if (foundRows.Length > 1 || (foundRows.Length == 1 && foundRows[0] != e.Row)) { e.Row[Properties.Resources.ColNameError] = true; throw new DuplicateNameException(e.Row[colNameKey].ToString()); } Dirty = true; } }
void FileContact_ColumnChanged(object sender, DataColumnChangeEventArgs e) { try { if (fileContactGridEX.CurrentRow != null) { fileContactGridEX.CurrentRow.BeginEdit(); fileContactGridEX.CurrentRow.Cells["Modified"].Value = true; fileContactGridEX.CurrentRow.EndEdit(); } } catch (Exception x) { UIHelper.HandleUIException(x); } }
/// <summary> /// 数据源列值改变 /// </summary> /// <param name="sender"></param> /// <param name="args"></param> protected void UCDataSourceOnColumnChanged(Object sender, DataColumnChangeEventArgs args) { if (args.Column.ColumnName == "SelectFlag")//选择列值改变的情况下绑定选择项 { UCFabBaseSelectCtl ucfbsc = UCFindSelectCtl(); if (ucfbsc != null) { m_UCDataSource.AcceptChanges(); DataTable dt = UCSelectDataSource;//实际是重新执行已选数据 if (radgViewType.SelectedIndex == 0) { ucfbsc.UCAct();//后续如果选择项是多模式的情况下将重新处理调用 } } } }
private void LayLoaiFile_ColumnChanged(object sender, DataColumnChangeEventArgs e) { if (e.Column.ColumnName.ToUpper() == "TenTLFile".ToUpper()) { if (string.IsNullOrEmpty(e.Row["TenTLFile"].ToString())) { return; } string[] fileType = e.Row["TenTLFile"].ToString().Split('.'); if (fileType.Length > 1) { e.Row["LoaiFile"] = fileType[fileType.Length - 1]; } } }
private void DtDepartment_ColumnChanged(object sender, DataColumnChangeEventArgs e) { try { adapterDepartment.Update(dtDepartment); if (!listDepart.Contains(e.Row.ItemArray[1].ToString())) { listDepart.Add(e.Row.ItemArray[1].ToString()); } Console.WriteLine("DtDepartment_ColumnChanged"); } catch (Exception z) { Console.WriteLine(z.ToString()); } }
void dt_ColumnChanged(object sender, DataColumnChangeEventArgs e) { try { if (e.Column.ColumnName.ToUpper() == "RECIPTYPE") return; if (e.Column.ColumnName.ToUpper() == "CLOSESTSCCID") return; if (FM.IsFieldChanged(e.Column, e.Row)) ApplyBR(false); } catch (Exception x) { UIHelper.HandleUIException(x); } }
private void myDataTable_ColumnChanged(object sender, DataColumnChangeEventArgs e) { if (System.String.Compare(e.Column.ColumnName, "dtStartTime", true) == 0) { try { DateTime startTime = ACMS.Convert.ToDateTime(e.Row["dtStartTime"]); e.Row["dtEndTime"] = startTime.AddMinutes(15); e.Row.EndEdit(); } catch (InvalidCastException) { MessageBox.Show("Invalid Start Time"); } } }
void TaoMaLopCT_ColumnChanged(object sender, DataColumnChangeEventArgs e) { if (e.Row.RowState == DataRowState.Deleted) { return; } if (e.Column.ColumnName.ToUpper().Equals("MANLOP") && e.Row["MaNLop"].ToString() != "") { string malop = CreateMaLop(e.Row["MaNLop"].ToString()); if (malop != "") { e.Row["MaLop"] = malop; e.Row.EndEdit(); } } }
void CheckThuPhi_ColumnChanged(object sender, DataColumnChangeEventArgs e) { if (e.Row.RowState == DataRowState.Deleted || drMaster.RowState == DataRowState.Deleted) { return; } if (e.Column.ColumnName.ToUpper().Equals("NGAYTHU")) { e.Row["TongTien"] = DBNull.Value; e.Row.EndEdit(); } if (e.Column.ColumnName.ToUpper().Equals("HOVAY")) { e.Row.EndEdit(); } }
/// <summary> /// Handler for when the field value actually changes. The application has now /// had a chance to set the proposed value, so we can record it as the new value. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void OnColumnChanged(object sender, DataColumnChangeEventArgs e) { if (m_doLogging) { for (int i = 0; i < waitingForChangedEventList.Count; i++) { UndoRedoFieldOperation r = (UndoRedoFieldOperation)waitingForChangedEventList[i]; if ((r.Row == e.Row) && (r.ColumnName == e.Column.ColumnName)) { r.NewValue = e.ProposedValue; waitingForChangedEventList.RemoveAt(i); break; } } } }
void LayCNKH_ColumnChanged(object sender, DataColumnChangeEventArgs e) { if (e.Column.ColumnName.Equals("HinhThucTT")) { if (e.Row["HinhThucTT"].ToString().Equals("Tiền mặt")) { gvMain.Columns.ColumnByFieldName("TaiKhoan").Visible = false; gvMain.Columns.ColumnByFieldName("SoTaiKhoan").Visible = false; } else { gvMain.Columns.ColumnByFieldName("TaiKhoan").Visible = true; gvMain.Columns.ColumnByFieldName("SoTaiKhoan").Visible = true; } } }
private void PASTDATA_ColumnChanged(object sender, DataColumnChangeEventArgs e) { if (e.Column != MyData.DataSetKlons.PASTDATA.IDPColumn && e.Column != MyData.DataSetKlons.PASTDATA.YRColumn) { return; } var dr = e.Row as KlonsADataSet.PASTDATARow; if (dr.RowState == DataRowState.Detached) { return; } LastIDP = dr.IDP; LastYR = dr.YR; }
private static void Part_BeforeFieldChange(object sender, DataColumnChangeEventArgs args) { // ** Argument Properties and Uses ** // args.Row["FieldName"] // args.Column, args.ProposedValue, args.Row // Add Event Handler Code switch (args.Column.ColumnName) { case "Character06": // if (args.Row["Character06"].ToString() == "Lee") // MessageBox.Show("1"); // else // MessageBox.Show("2"); break; } }
void _data_MT61_changed(object sender, DataColumnChangeEventArgs e) { //Lay so phong da dat DataRow dr = (grPDP.Properties.DataSource as DataTable).Rows.Find(e.Row["MT61ID"]); cNgaydat.EditValue = DateTime.Parse(dr["NgayCT"].ToString()); bsDSPhong.DataSource = _data.tDSPhong; bsDSPhong.CurrentChanged += new EventHandler(bsDSPhong_CurrentChanged); gridControl1.DataSource = bsDSPhong; if (bsDSPhong.Count > 0) { bsDSPhong.MoveFirst(); } }
// private void EPDataGrid_RowChanged(object sender, DataRowChangeEventArgs e) // { // // if( e.Action == System.Data.DataRowAction.Add ) // // { // // for(int i=0;i<fields.Count;i++) // // { // // if( fields[i].OleDbType == System.Data.OleDb.OleDbType.DBTimeStamp ) // // { // // e.Row[i] = System.DateTime.Now; // // } // // } // // } // } private void EPDataGrid_ColumnChanged(object sender, DataColumnChangeEventArgs e) { if (_query != null) { if (_query.Fields[e.Column.Ordinal].OleDbType != System.Data.OleDb.OleDbType.DBTimeStamp) { for (int i = 0; i < _query.Fields.Count; i++) { if (_query.Fields[i].OleDbType == System.Data.OleDb.OleDbType.DBTimeStamp) { e.Row[i] = System.DateTime.Now; } } } } }
private void ValidationDataTable_ColumnChanging ( object sender, DataColumnChangeEventArgs e ) { try { ValidateProposedValue(e); } catch (Exception exception) { System.Diagnostics.Debug.Assert(false); throw exception; } }
/// <summary> /// Provide access to changes for the current DataRow after in this /// case leaving a cell in a DataGridView. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void ColumnChanged(object sender, DataColumnChangeEventArgs e) { if (e.Row.RowState == DataRowState.Deleted || e.Row.RowState == DataRowState.Detached || e.Row.RowState == DataRowState.Added) { return; } if (e.Row.Table.Columns.Contains("id")) { Console.WriteLine($" Id {e.Row.Field<int>("id")}"); } Console.WriteLine($" Column name {e.Column.ColumnName}"); Console.WriteLine($" Original value [{e.Row[e.Column.ColumnName, DataRowVersion.Original]}]"); Console.WriteLine($" Propose value [{e.ProposedValue}]"); Console.WriteLine(new string('-', 20)); }
private void ColumnsDataTable_ColumnChanged(object sender, DataColumnChangeEventArgs e) { var currentRowData = new ColumnDetails() { id = e.Row.Field <int>("Id"), TableId = e.Row.Field <int>("TableId"), Name = e.Row.Field <string>("ColumnName"), Title = e.Row.Field <string>("ColumnHeaderText"), Visible = e.Row.Field <bool>("Visible"), OrdinalPosition = e.Row.Field <int>("OrdinalPosition") }; if (!_columnOperations.UpdateColumn(currentRowData)) { MessageBox.Show($"Update failed{Environment.NewLine}{_columnOperations.LastExceptionMessage}"); } }
private void Updatedt2ANgayCan(DataColumnChangeEventArgs e)//Piriou { if (e.Column.Table.TableName == "MT2A") { DevExpress.XtraGrid.Views.Grid.GridView gvMain = gc.MainView as DevExpress.XtraGrid.Views.Grid.GridView; int[] id = gvMain.GetSelectedRows(); foreach (int i in id) { DataRow dr = gvMain.GetDataRow(i); if (dr["NgayCan"].ToString() != e.Row["NgayCan"].ToString()) { dr["NgayCan"] = e.Row["NgayCan"]; dr.EndEdit(); } } } }
void NhapBangLuong_ColumnChanged(object sender, DataColumnChangeEventArgs e) { //Tinh lại bảo hiểm, và thuế TNCN, Thực lĩnh khi Tổng lương thay đổi //if (e.Column.ColumnName.ToString().ToUpper() == "LUONGCB") //{ // dvNhanVien.RowFilter = "MaNV='" + e.Row["MaNV"].ToString() + "'"; // foreach (DataRowView drv in dvNhanVien) // { // if (Convert.ToBoolean(drv.Row["TinhBH"].ToString())) // { // e.Row["BHYT"] = Convert.ToDouble(e.Row["LuongCB"].ToString()) * 1.5 / 100; // e.Row["BHXH"] = Convert.ToDouble(e.Row["LuongCB"].ToString()) * 8 / 100; // e.Row["BHTN"] = Convert.ToDouble(e.Row["LuongCB"].ToString()) * 1 / 100; // } // if (Convert.ToBoolean(drv.Row["TinhThue"].ToString())) // { // double TNTinhThue = Convert.ToDouble(e.Row["TNTinhThue"].ToString()); // double ThueTNCN = TinhThue(TNTinhThue); // e.Row["ThueTNCN"] = Math.Round(ThueTNCN, 0); // } // //Thực lĩnh // e.Row["ThucLinh"] = Convert.ToDouble("0" + e.Row["TongLuong"].ToString()) - Convert.ToDouble("0" + e.Row["TamUng"].ToString()) - Convert.ToDouble("0" + e.Row["BHYT"].ToString()) - Convert.ToDouble("0" + e.Row["BHTN"].ToString()) - Convert.ToDouble("0" + e.Row["BHXH"].ToString()) - Convert.ToDouble("0" + e.Row["ThueTNCN"].ToString()); // } //} ////Tạm ứng thay đổi -> tính lại thực lãnh //if (e.Column.ColumnName.ToString().ToUpper() == "TAMUNG") // e.Row["ThucLinh"] = Convert.ToDouble("0" + e.Row["TongLuong"].ToString()) - Convert.ToDouble("0" + e.Row["TamUng"].ToString()) - Convert.ToDouble("0" + e.Row["BHYT"].ToString()) - Convert.ToDouble("0" + e.Row["BHTN"].ToString()) - Convert.ToDouble("0" + e.Row["BHXH"].ToString()) - Convert.ToDouble("0" + e.Row["ThueTNCN"].ToString()); //Thu nhập tính thuế thay đổi -> tính lại thuế TNCN và Thực Lĩnh if (e.Column.ColumnName.ToString().ToUpper() == "TNTINHTHUE") { dvNhanVien.RowFilter = "MaNV='" + e.Row["MaNV"].ToString() + "'"; foreach (DataRowView drv in dvNhanVien) { if (Convert.ToBoolean(drv.Row["TinhThue"].ToString())) { double TNTinhThue = Convert.ToDouble(e.Row["TNTinhThue"].ToString()); double ThueTNCN = TinhThue(TNTinhThue); e.Row["ThueTNCN"] = Math.Round(ThueTNCN, 0); //e.Row["ThucLinh"] = Convert.ToDouble("0" + e.Row["TongLuong"].ToString()) - Convert.ToDouble("0" + e.Row["TamUng"].ToString()) - Convert.ToDouble("0" + e.Row["BHYT"].ToString()) - Convert.ToDouble("0" + e.Row["BHTN"].ToString()) - Convert.ToDouble("0" + e.Row["BHXH"].ToString()) - Convert.ToDouble("0" + e.Row["ThueTNCN"].ToString()); } } } }
// User changed existing PathsRow. private void Paths_ColumnChanged(object sender, DataColumnChangeEventArgs e) { // This row not added now, it's adding now. // Check TestStaticCore.AddPath_SendCommandDEL_ShouldNotBeCalled if (e.Row.RowState == DataRowState.Detached) { return; } var row = (Ruleset.PathsRow)e.Row; _Driver.SendCommand(COMMAND_TYPE.DEL, null, row.ID); // Delete protected path from driver. foreach (var path in row.ExpandedPaths) { _Driver.SendCommand(COMMAND_TYPE.ADD, path, row.ID); // And add it again. } }
private void table_ColumnChanged(object sender, DataColumnChangeEventArgs e) { if (this.suppressColumnChanged) { return; } this.Row.EndEdit(); this.FillColumnsBasedOnLambdaExpression(e.Column.ColumnName); try { this.UpdateObject(e.Column); } catch (TargetInvocationException ex) { throw (ex.InnerException != null) ? ex.InnerException : ex; } }
void dt_ColumnChanged(object sender, DataColumnChangeEventArgs e) { try { if (e.Column.ColumnName != "EndDateLocal" && e.Column.ColumnName != "StartDateLocal") { if (FM.IsFieldChanged(e.Column, e.Row)) { ApplyBR(false); } } } catch (Exception x) { UIHelper.HandleUIException(x); } }
/// <summary> /// todoComment /// </summary> /// <param name="e"></param> /// <param name="AVerificationResultCollection"></param> /// <param name="AVerificationResult"></param> /// <param name="FDataColumnComparedTo"></param> /// <returns></returns> public static Boolean VerifySubscriptionData(DataColumnChangeEventArgs e, TVerificationResultCollection AVerificationResultCollection, out TVerificationResult AVerificationResult, out DataColumn FDataColumnComparedTo) { Boolean ReturnValue; AVerificationResult = null; DataColumn FDataColumnComparedTo2 = null; if ((e.Column.ColumnName == PSubscriptionTable.GetDateCancelledDBName()) || (e.Column.ColumnName == PSubscriptionTable.GetExpiryDateDBName()) || (e.Column.ColumnName == PSubscriptionTable.GetDateNoticeSentDBName()) || (e.Column.ColumnName == PSubscriptionTable.GetStartDateDBName()) || (e.Column.ColumnName == PSubscriptionTable.GetSubscriptionRenewalDateDBName()) || (e.Column.ColumnName == PSubscriptionTable.GetFirstIssueDBName()) || (e.Column.ColumnName == PSubscriptionTable.GetLastIssueDBName())) { VerifySubscriptionDates(e, AVerificationResultCollection, out AVerificationResult, out FDataColumnComparedTo2); } FDataColumnComparedTo = FDataColumnComparedTo2; // if (e.Column.Ordinal = (e.Column.Table as PPartnerLocationTable).ColumnEmailAddress.Ordinal) then // begin // VerifyEMailAddress(e, AVerificationResult); // end; if ((e.Column.ColumnName == PSubscriptionTable.GetPublicationCopiesDBName()) || (e.Column.ColumnName == PSubscriptionTable.GetNumberIssuesReceivedDBName()) || (e.Column.ColumnName == PSubscriptionTable.GetNumberComplimentaryDBName())) { VerifyInteger(e, out AVerificationResult); } // any verification errors? if (AVerificationResult == null) { ReturnValue = true; } else { ReturnValue = false; } return(ReturnValue); }
void parents_ColumnChanged(object sender, DataColumnChangeEventArgs e) { if (filling) { return; } // going to blow away this row anyway. if (moving) { return; } if (e.Column.ColumnName == parents.NameColumn) { filling = true; DataRow[] groups = e.Row.GetChildRows(relation.ChildrenOfParent); foreach (DataRow group in groups) { DataRow[] currents = group.GetChildRows(relation.TableName); foreach (DataRow current in currents) { current[NameColumn] = GetDisplayMember(group); } } filling = false; } else if (e.Column.ColumnName == relation.NumberColumn) { filling = true; Log.log("Need to do something here.."); DataRow[] groups = e.Row.GetChildRows(relation.ChildrenOfParent); foreach (DataRow group in groups) { DataRow[] currents = group.GetChildRows(relation.TableName); foreach (DataRow current in currents) { current[NameColumn] = GetDisplayMember(group); } } filling = false; } }
private void ColumnChanging(object sender, DataColumnChangeEventArgs e) { _eventsFired.Add(new EventInfo("ColumnChanging", e)); }