private void gvPAYERelief_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
var Row = (EmployeePayslip_PAYEReliefeViewModel)gvPAYERelief.GetFocusedRow();
if (Row == null)
{
return;
}
//--
if (gvPAYERelief.FocusedColumn == colPAYEReliefAmt)
{
if (e.Value == null)
{
e.ErrorText = "Please enter valid numeric value.";
e.Valid = false;
}
else if ((decimal)e.Value == 0)
{
e.ErrorText = "Please enter value.";
e.Valid = false;
}
else if ((decimal)e.Value > Row.MonthlyLimit)
{
e.ErrorText = "Amt can not be greater than Monthly Limit Amount.";
e.Valid = false;
}
}
}
private void gridView2_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
if (gridView2.FocusedColumn.FieldName == "colSoLuong")
{
if (gridView2.GetSelectedRows().Contains(gridView2.FocusedRowHandle) && Convert.ToInt32(e.Value) <= 0)
{
e.ErrorText = "Giá trị không hợp lệ";
e.Valid = false;
}
else
{
listSelectedRow[(int)gridView2.GetFocusedRowCellValue(colMaDichVu)] = Convert.ToInt32(e.Value);
}
}
else if (gridView2.FocusedColumn.FieldName == "colSelect")
{
if ((bool)e.Value)
{
listSelectedRow.Add((int)gridView2.GetFocusedRowCellValue(colMaDichVu), 1);
gridView2.RefreshData();
}
else
{
listSelectedRow.Remove((int)gridView2.GetFocusedRowCellValue(colMaDichVu));
gridView2.RefreshData();
}
}
}
private void grvDiem_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
if (e.Value != null)
{
if (e.Value.ToString().Trim() == "")
{
if ("" + grvDiem.GetDataRow(grvDiem.FocusedRowHandle)[grvDiem.FocusedColumn.FieldName] != "")
{
e.Valid = false;
e.ErrorText = "Nếu muốn xóa bạn phải bấm phím Delete.";
}
}
else
{
float diem;
if (float.TryParse(e.Value.ToString(), out diem))
{
if (diem < 0 || diem > 10)
{
e.Valid = false;
e.ErrorText = "Dữ liệu điểm nhập vào phải từ 0 đến 10.";
}
}
else
{
e.Valid = false;
e.ErrorText = "Dữ liệu điểm nhập vào phải là kiểu số.";
}
}
}
}
private void gv_Detail_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
var view = sender as DevExpress.XtraGrid.Views.Grid.GridView;
if (Object.Equals(view.FocusedColumn.Tag, "NotNull"))
{
if (Object.Equals(string.Empty, e.Value) || Object.Equals(null, e.Value) || Object.Equals(DBNull.Value, e.Value))
{
e.Valid = false;
e.ErrorText = view.FocusedColumn.Caption + "不能为空！";
}
}
if (view.FocusedColumn.FieldName == tb_PODetail.Qty || view.FocusedColumn.FieldName == tb_PODetail.POPrice)
{
decimal price = 0; int qty = 0;
if (view.FocusedColumn.FieldName == tb_PODetail.Qty)
{
price = ConvertLib.ToDecimal(view.GetFocusedDataRow()[tb_PODetail.POPrice], 0);
qty = ConvertLib.ToInt(e.Value, 0);
}
else
{
price = ConvertLib.ToDecimal(e.Value, 0);
qty = ConvertLib.ToInt(view.GetFocusedDataRow()[tb_PODetail.Qty], 0);
}
decimal amount = price * qty;
view.SetFocusedRowCellValue(tb_PODetail.TotalPOAmount, amount);
RefreshSummary();
}
}
private void qsLayoutView_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
if (e.Value == null || string.IsNullOrWhiteSpace(e.Value.ToString()))
{
e.Value = DBNull.Value;
}
}
private void gvLabour_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
ColumnView view = sender as ColumnView;
GridColumn column = (e as EditFormValidateEditorEventArgs)?.Column ?? view.FocusedColumn;
if (column.FieldName.Contains(strEnterHours))
{
if (e.Value != null && Convert.ToInt32(e.Value) < 0)
{
e.ErrorText = "Invalid Work Hours.";
e.Valid = false;
return;
}
}
if (column.FieldName.Contains(strEnterAmount))
{
if (e.Value != null && Convert.ToInt32(e.Value) < 0)
{
e.ErrorText = "Invalid Amount.";
e.Valid = false;
return;
}
}
}
private void GridView_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
if (e.Value != null && e.Value.ToString() == "")
{
e.Value = DBNull.Value;
}
}
/// <summary>
/// Event which is fired when the cell of the <see cref="gridControl1"/> is changed. This event serves to only validate the typed values
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void BandedGridView1_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
int ColumnIndex = bandedGridView1.FocusedColumn.AbsoluteIndex;
if (ColumnIndex == 0 || ColumnIndex == 1)
{
if (!Double.TryParse(e.Value as string, out double checker))
{
e.Valid = false;
e.ErrorText = "Please Enter Numeric Values";
}
}
else if (ColumnIndex == 2)
{
if ((Color)e.Value == null)
{
e.Valid = false;
e.ErrorText = "Please Select Color";
}
}
else
{
e.Valid = true;
}
}
//验证修改数据是否有效
private void treeList1_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
var tree = treeList1.DataSource as List <ProjectTreeNode>;
var focusNode = treeList1.FocusedNode;
var pNode = getProjectNode(focusNode).GetParentNode();
if (pNode == null)
{
return;
}
int level = focusNode.Level;
foreach (var node in pNode.Children)
{
if (node.Name == e.Value.ToString() && node != tree[focusNode.Id] && level != 4)
{
e.ErrorText = "已经包含相同名字的节点";
e.Valid = false;
treeList1.EditingValue = tree[focusNode.Id].Name;
return;
}
else if (e.Value.ToString() == "")
{
e.ErrorText = "输入的名字不能为空";
e.Valid = false;
treeList1.EditingValue = tree[focusNode.Id].Name;
return;
}
}
treeList1.OptionsBehavior.Editable = false;
treeList1.CloseEditor();
}
private void UiVistaSolicitudTraslado_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
var view = sender as GridView;
if (view == null || view.FocusedColumn.FieldName != "QTY")
{
return;
}
var registro = (Sku)UiVistaSolicitudTraslado.GetRow(view.FocusedRowHandle);
try
{
var qty = double.Parse(e.Value.ToString());
registro.QTY = qty;
Materiales.Where(mt => mt.MATERIAL_ID == registro.MATERIAL_ID).ToList().ForEach(mt => mt.QTY = qty);
if (!(qty <= 0))
{
return;
}
e.Valid = false;
e.ErrorText = "La cantidad debe de ser mayor a 0";
}
catch (Exception)
{
e.Valid = false;
e.ErrorText = "Cantidad inválida.";
}
}
protected override void RaiseValidatingEditor(DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
try
{
switch (this.FocusedColumn.ColumnType.Name)
{
case "String":
break;
case "Decimal":
Convert.ToDecimal(e.Value);
break;
default:
break;
}
}
catch (Exception)
{
e.ErrorText = "格式错误,按Esc取消后重新输入！";
e.Valid = false;
}
finally
{
base.RaiseValidatingEditor(e);
}
}
void gridView1_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
//if (this.gridView1.FocusedRowHandle == DevExpress.XtraGrid.GridControl.AutoFilterRowHandle)
// return;
//DevExpress.XtraGrid.Views.Grid.GridView view = sender as DevExpress.XtraGrid.Views.Grid.GridView;
//DataView dataView = view.DataSource as DataView;
//System.Collections.IEnumerator en = dataView.GetEnumerator();
//en.Reset();
//string currentCode = e.Value.ToString();
//while (en.MoveNext())
//{
// DataRowView row = en.Current as DataRowView;
// object colValue = row["IDCentro"] + " " + row["IDCuenta"];
// if (colValue.ToString() == currentCode)
// {
// e.ErrorText = "El elemento ya existe.";
// e.Valid = false;
// break;
// }
//}
}
private void gridView2_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
GridView view = sender as GridView;
if (view.FocusedColumn == colDKUL)
{
decimal dKul = e.Value == DBNull.Value ? 0 : Convert.ToDecimal(e.Value);
decimal dKln = view.GetFocusedRowCellValue(colDKLN) == DBNull.Value ? 0 : Convert.ToDecimal(view.GetFocusedRowCellValue(colDKLN));
if (dKln < 0) // eksi
{
if (dKul < dKln || dKul > 0)
{
e.Value = dKln;
}
}
else
{
if (dKul > dKln || dKul < 0)
{
e.Value = dKln;
}
}
decimal gdKulTop = getGrupTop(1);
if (Math.Abs(Convert.ToDecimal(e.Value)) > Math.Abs(gdKulTop))
{
e.Value = -gdKulTop;
}
}
}
private void GVH_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
GridView view = sender as GridView;
switch (view.FocusedColumn.FieldName)
{
case "SoVeVN":
if (System.Text.RegularExpressions.Regex.IsMatch(e.Value as String, "[^0-9^-]"))
{
e.Valid = false;
e.ErrorText = "Chỉ nhập số";
}
break;
case "Fare":
case "GiaNet":
case "GiaHeThong":
case "GiaHoan":
case "HangHoan":
long a = 0;
if (!long.TryParse(e.Value as String, out a))
{
e.Valid = false;
e.ErrorText = "Chỉ nhập số";
}
break;
}
}
private void gvDetail_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
if (e.Value != null)
{
DataRowView dr = (DataRowView)gvDetail.GetFocusedRow();
if ((dr != null))
{
try
{
switch (gvDetail.FocusedColumn.Name)
{
case "colProductId":
if (string.IsNullOrEmpty(e.Value.ToString()))
{
e.Valid = false;
}
else if (decimal.Parse(e.Value.ToString()) <= 0)
{
e.Valid = false;
}
break;
}
}
catch (Exception ex)
{
}
}
}
else
{
gvDetail.CancelUpdateCurrentRow();
}
}
private void treeList1_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
if (e.Value == null)
{
return;
}
if (treeList1.FocusedColumn.Caption == "Pkt")
{
if (treeList1.FocusedNode.HasChildren)
{
e.Value = string.Empty;
return;
}
var result = int.TryParse(e.Value.ToString(), out int output);
if (!result)
{
e.ErrorText = " Podaj liczbę z zakresu od 0 do 100";
e.Valid = false;
}
if (output < 0 || output > 100)
{
e.ErrorText = " Podaj liczbę z zakresu od 0 do 100";
e.Valid = false;
return;
}
}
if (e.Value.ToString() == string.Empty)
{
e.ErrorText = "Pole nie może być puste";
e.Valid = false;
}
}
void gridView1_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
GridView view = sender as GridView;
string fieldName = view.FocusedColumn.FieldName;
switch (fieldName)
{
case "TenNhanVien":
if (e.Value.ToString().Trim().Equals(""))
{
e.Valid = false;
e.ErrorText = "Nhập vào tên Nhân Viên";
}
break;
case "SoDienThoai":
if (e.Value.ToString().Trim().Equals(""))
{
e.Valid = false;
e.ErrorText = "Nhập vào số điện thoại";
}
break;
default:
break;
}
}
private void gridViewDetalle_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
if (this.gridViewDetalle.FocusedRowHandle == DevExpress.XtraGrid.GridControl.AutoFilterRowHandle)
{
return;
}
DevExpress.XtraGrid.Views.Grid.GridView view = sender as DevExpress.XtraGrid.Views.Grid.GridView;
DataView dataView = view.DataSource as DataView;
System.Collections.IEnumerator en = dataView.GetEnumerator();
en.Reset();
string currentCode = e.Value.ToString();
while (en.MoveNext())
{
DataRowView row = en.Current as DataRowView;
object colValue = row["Articulo"];
if (colValue.ToString() == currentCode)
{
e.ErrorText = "El elemento ya existe.";
e.Valid = false;
break;
}
}
}
private void gridView2_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
Trace.WriteLine($@"");
int nJeffe = 0;
nJeffe++;
Trace.WriteLine($@"private void gridView2_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)");
Trace.WriteLine($@"{e.Value}");
Trace.WriteLine($@"{gridView2.FocusedColumn}");
Trace.WriteLine($@"{gridView2.FocusedRowHandle}");
Trace.WriteLine($@"{gridView2.FocusedValue}");
Trace.WriteLine($@"{_gWd[gridView2.FocusedRowHandle].GrossLbs}");
Trace.WriteLine($@"{_gWd[gridView2.FocusedRowHandle].TareLbs}");
Trace.WriteLine($@"{_gWd[gridView2.FocusedRowHandle].NetResultLbs}");
if (gridView2.FocusedColumn.Name.Contains("Tare"))
{
Trace.WriteLine($@"");
nJeffe = 0;
nJeffe++;
Trace.WriteLine($@"private void gridView2_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)");
//InitializeData();
gridView2.RefreshData();
gridControl2.RefreshDataSource();
}
}
private void gridViewMaterialList_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
ColumnView view = sender as ColumnView;
GridColumn column = (e as EditFormValidateEditorEventArgs)?.Column ?? view.FocusedColumn;
if (column == colCarriagePercent)
{
double carriagePercent = UICurrentManager.Instance.CurrentTender.MaterialList.Sum(p => p.CarriagePercent);
double currentCarriagePercent = SimpleApplicationBase.Toolkit.Helpers.GetValueFromObject <double>(e.Value);
if ((carriagePercent + currentCarriagePercent) > 100)
{
//gridViewMaterialList.SetColumnError(colCarriagePercent, "Ağırlık toplamları %100 ü geçmemelidir!", ErrorType.Critical);
MessageBox.Show("Ağırlık toplamları %100 ü geçmemelidir!");
e.Valid = false;
// gridViewMaterialList.SetRowCellValue(e.RowHandle, "CarriagePercent", 0);
}
else
{
int currenMaterialId = SimpleApplicationBase.Toolkit.Helpers.GetValueFromObject <int>(gridViewMaterialList.GetFocusedRowCellValue("Id"));
foreach (var item in UICurrentManager.Instance.CurrentTender.MaterialList)
{
if (item.Id.Equals(currenMaterialId))
{
item.CarriagePercent = currentCarriagePercent;
break;
}
}
}
}
}
private void bgvSinhVien_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
if (e.Value != null)
{
if (e.Value.ToString().Trim() == "")
{
e.Value = null;
e.Valid = true;
}
else
{
float diem;
if (float.TryParse(e.Value.ToString(), out diem))
{
if (diem < 0 || diem > 10)
{
e.Valid = false;
e.ErrorText = "Dữ liệu điểm nhập vào phải từ 0 đến 10.";
}
}
else
{
e.Valid = false;
e.ErrorText = "Dữ liệu điểm nhập vào phải là kiểu số.";
}
}
}
}
void dgv_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
if (e.Value == null || e.Value.Equals(string.Empty))
{
e.Value = DBNull.Value;
}
}
void gridView1_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
if (e.Value.ToString() == "")
{
gridView1.DeleteSelectedRows();
}
}
private void gridView4_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
if (validate == true)
{
for (int i = 0; i < gridView4.RowCount; i++)
{
if (gridView4.GetRowCellValue(gridView4.GetRowHandle(i), "IO PİNİ").ToString().Length > 0)
{
manager.manualpointing(true, Convert.ToInt32(gridView4.GetRowCellValue(gridView4.GetRowHandle(i), "IO PİNİ").ToString()));
}
}
if (e.Value.ToString().Length > 0)
{
if (!manager.checkIOpoint(e.Value.ToString()))
{
// XtraMessageBox.Show("Yazılan IO zaten kullanımda" + gridView4.GetRowCellValue(gridView6.GetSelectedRows()[0], "IO PİNİ").ToString(), "HATA", MessageBoxButtons.OK, MessageBoxIcon.Error);
e.Valid = false;
e.ErrorText = "Test noktası daha önce " + manager.checkIOpointWhoUse(e.Value.ToString(), edit_socket_name.Text) + " isimli soket tarafından kullanılmış!";
}
else
{
e.Valid = true;
}
}
else
{
e.Valid = true;
}
}
manager.manualpointing(false, 0);//IMPORTANT!
gridView4.CloseEditor();
gridView4.UpdateCurrentRow();
}
/// <summary>
/// 编辑校验
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView1_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
string colName = (sender as ColumnView).FocusedColumn.FieldName.ToUpper();
if (colName == "NUMS")
{
if (e.Value == null || e.Value is System.DBNull)
{
e.Valid = false;
e.ErrorText = "请输入数量!";
return;
}
else if (int.Parse(e.Value.ToString()) <= 0)
{
e.Valid = false;
e.ErrorText = "数量必须大于0！";
return;
}
}
else if (colName == "PRICE")
{
if (decimal.Parse(e.Value.ToString()) <= 0)
{
e.Valid = false;
e.ErrorText = "价格必须大于0！";
return;
}
}
}
/// <summary>
/// 编辑验证
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView1_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
string colName = (sender as ColumnView).FocusedColumn.FieldName.ToUpper();
if (colName.Equals("RO003"))
{
if (String.IsNullOrEmpty(e.Value.ToString()))
{
e.Valid = false;
e.ErrorText = "角色名称不能为空!";
}
else
{
for (int i = 0; i < gridView1.RowCount - 1; i++)
{
if (i == (sender as ColumnView).FocusedRowHandle)
{
continue;
}
if (gridView1.GetRowCellValue(i, "RO003") == null)
{
continue;
}
//如果角色名字相同,则校验不通过!
if (String.Equals(gridView1.GetRowCellValue(i, "RO003").ToString(), e.Value.ToString()))
{
e.Valid = false;
e.ErrorText = "角色名称已经存在!";
break;
}
}
}
}
}
private void gvGrid_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
e.Valid = true;
if (gvGrid.FocusedRowHandle == GridControl.AutoFilterRowHandle)
{
return;
}
if (gvGrid.FocusedRowHandle == GridControl.NewItemRowHandle &&
gvGrid.GetRow(GridControl.NewItemRowHandle) == null)
{
return;
}
if (gvGrid.FocusedColumn.FieldName == colHV_TEN.FieldName)
{
if (string.IsNullOrEmpty(e.Value.ToString().Trim()))
{
e.ErrorText = colHV_TEN.Caption + " không được phép rỗng.";
e.Valid = false;
}
else if (gvGrid._ValidationSame(colHV_TEN, e.Value + string.Empty))
{
e.ErrorText = colHV_TEN.Caption + " không được trùng.";
e.Valid = false;
}
}
}
private void gvFields_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
if (gvFields.FocusedColumn == gColName)
{
string strNewValue = e.Value as string;
// 空检查
if (string.IsNullOrWhiteSpace(strNewValue))
{
e.Valid = false;
e.ErrorText = "字段名不能为空";
return;
}
// 重复判断
strNewValue = strNewValue.ToUpper();
DataRow rowFocusd = gvFields.GetFocusedDataRow();
for (int i = 0; i < m_DataTable.Rows.Count; i++)
{
DataRow rowCurrent = m_DataTable.Rows[i];
if (rowCurrent == rowFocusd)
{
continue;
}
if ((rowCurrent[0] as string).ToUpper() == strNewValue)
{
e.Valid = false;
e.ErrorText = "字段名不能与已有字段重复";
return;
}
}
}
}
private void gridView1_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
GridView view = sender as GridView;
if (view.FocusedColumn.FieldName == "SDT")
{
double phone = 0;
if (!Double.TryParse(e.Value as String, out phone))
{
e.Valid = false;
e.ErrorText = "Hãy nhập số điện thoại của bạn ( 9-13 số ).";
}
}
if (view.FocusedColumn.FieldName == "BANGLAI")
{
double banglai = 0;
if (!Double.TryParse(e.Value as String, out banglai))
{
e.Valid = false;
e.ErrorText = "Hãy nhập số bằng lái của bạn ( 12 số ).";
}
}
if (view.FocusedColumn.FieldName == "CMND")
{
double cmnd = 0;
if (!Double.TryParse(e.Value as String, out cmnd))
{
e.Valid = false;
e.ErrorText = "Hãy nhập số chứng minh nhân dân của bạn ( 12 số ).";
}
}
}
// value validation
private void _target_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
if (ReferenceEquals(null, _validableFields) || _validableFields.Count == 0)
{
return;
}
string cn = "";
if (sender is GridView && Current is IValidableEntity)
{
cn = (sender as GridView).FocusedColumn.FieldName;
}
else if (sender is DevExpress.XtraTreeList.TreeList && Current is IValidableEntity)
{
cn = (sender as DevExpress.XtraTreeList.TreeList).FocusedColumn.FieldName;
}
if (cn != "" && _validableFields.Contains(cn))
{
Problem pr = (Current as IValidableEntity).ValidateProperty(cn, e.Value);
if (pr.Kind != ProblemKind.None)
{
e.Valid = false;
e.ErrorText = pr.ErrorMessage;
}
}
}
