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