protected void ASPxGridView1_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
//判断是否重复
if (ASPxGridView1.IsNewRowEditing)
{
string chSql = "SELECT SO FROM ATPUEPAINTPROCOLOR"
+ " WHERE SO='" + e.NewValues["SO"].ToString() + "'";
DataTable dt = dc.GetTable(chSql);
if (dt.Rows.Count > 0)
{
e.RowError = "已存在相同的SO！";
}
}
//判断是否存在SO
if (ASPxGridView1.IsNewRowEditing)
{
string chSql = "SELECT * FROM COPY_PT_MSTR WHERE UPPER(PT_PART)='" + e.NewValues["SO"].ToString().ToUpper() + "'";
DataTable dt = dc.GetTable(chSql);
if (dt.Rows.Count == 0)
{
e.RowError = "该SO不存在！";
}
}
if (e.NewValues["SO"].ToString().Length > 30)
{
e.RowError = "SO号字节长度不能超过30！";
}
}
//修改数据校验
protected void ASPxGridView1_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
//判断为空
if (e.NewValues["SO"].ToString() == "" || e.NewValues["SO"].ToString() == null)
{
e.RowError = "SO号不能为空！";
}
string strSO = e.NewValues["SO"].ToString().Trim();
string strJX = e.NewValues["JX"].ToString().Trim();
//判断超长
if (strSO.Length > 30)
{
e.RowError = "SO字节长度不能超过30！";
}
if (strJX.Length > 30)
{
e.RowError = "机型字节长度不能超过30！";
}
//判断是否重复
if (ASPxGridView1.IsNewRowEditing)
{
string chSql = "SELECT SO FROM JWTCMSO WHERE SO='" + strSO + "'";
DataTable dt = dc.GetTable(chSql);
if (dt.Rows.Count > 0)
{
e.RowError = "已存在相同的SO号！";
}
}
}
protected void gvCaThi_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
string strOldValues;
if (strMess != string.Empty)
{
AddError(e.Errors, gvCaThi.Columns["Error"], strMess);
e.RowError = strMess;
return;
}
foreach (GridViewColumn column in gvCaThi.Columns)
{
GridViewDataColumn dataColumn = column as GridViewDataColumn;
if (dataColumn == null || dataColumn.Caption == "Error" || dataColumn.Caption == "Mã Ca Thi")
{
continue;
}
if (e.NewValues[dataColumn.FieldName] == null || e.NewValues[dataColumn.FieldName].ToString().Trim() == string.Empty)
{
e.Errors[dataColumn] = "Vui lòng điền dữ liệu.";
}
}
if (e.Errors.Count > 0)
{
e.RowError = "Vui lòng điền đầy đủ thông tin trước khi lưu.";
return;
}
strOldValues = e.OldValues["MaCaThi"] == null ? string.Empty : e.OldValues["MaCaThi"].ToString();
}
protected void grdBalanceLine_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
GridViewDataColumn col = ((ASPxGridView)sender).Columns["TransactionId.Code"] as GridViewDataColumn;
if (e.NewValues["TransactionId.Code"] == null)
{
e.Errors.Add(col, "");
e.RowError = "Chưa nhập mã bút toán";
return;
}
ASPxSpinEdit c1 = (ASPxSpinEdit)grdBalanceLine.FindEditRowCellTemplateControl((GridViewDataColumn)grdBalanceLine.Columns["Debit"], "colBalanceInitDebit");
ASPxSpinEdit c2 = (ASPxSpinEdit)grdBalanceLine.FindEditRowCellTemplateControl((GridViewDataColumn)grdBalanceLine.Columns["Credit"], "colBalanceInitCredit");
if (c1.Value == null && c2.Value == null)
{
e.Errors.Add(col, "");
e.RowError = "Số dư Nợ(Có) phải lớn hơn 0 ";
return;
}
else
{
if (c1.Value != null && c2.Value != null)
{
if (double.Parse(c1.Value.ToString()) > 0 && double.Parse(c2.Value.ToString()) > 0)
{
e.Errors.Add(col, "");
e.RowError = "Số dư Nợ(Có) phải bằng 0 ";
return;
}
}
}
}
protected void grd_DSRole_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
Utils.notifierListClearGrid(grd_DSRole, Constant.NOTIFY_CLEAR);
List <Error_Obj> lstError = new List <Error_Obj>();
ASPxFormLayout pnLayData = grd_DSRole.FindEditFormTemplateControl("LayOutThemSua") as ASPxFormLayout;
ASPxTextBox txtName = pnLayData.FindControl("txtName") as ASPxTextBox;
if (String.IsNullOrEmpty(txtName.Text))
{
lstError.Add(new Error_Obj {
error = "[Tên role] không được để trống."
});
}
Role role = ctlRole.getRolesByName(txtName.Text.Trim());
if (role != null && grd_DSRole.IsNewRowEditing)
{
lstError.Add(new Error_Obj {
error = "[Tên role] đã tồn tại."
});
}
if (lstError.Count > 0)
{
e.Errors[grd_DSRole.Columns[0]] = "error";
Utils.notifierListErrorGrid(grd_DSRole, Constant.NOTIFY_FAILURE, lstError);
}
}
protected void gv_Symmetry_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
e.NewValues["value"] = (gv_Symmetry.FindEditFormTemplateControl("txtSymmetry") as ASPxTextBox).Value;
String Symmetry = (e.NewValues["value"] == null ? string.Empty : e.NewValues["value"].ToString());
if (Symmetry == String.Empty)
{
throw new Exception("Symmetry must not be empty!");
}
int ID = 0;
if (e.IsNewRow)
{
ID = 0;
}
else
{
ID = int.Parse(e.Keys["id"].ToString());
}
if (Stone.checkSymmetryExist(Symmetry, ID) == true)
{
throw new Exception("Symmetry: " + Symmetry + " already exist!");
}
}
protected void GridPlanning_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
double amount = 0;
if (e.NewValues["Amount"] != null)
{
amount = (double)e.NewValues["Amount"];
if (amount <= 0)
{
Utility.Helpers.AddErrorToGridViewColumn(
e.Errors,
GridPlanning.Columns["Amount"],
"Số tiền phải lớn hơn 0");
}
}
else
{
Utility.Helpers.AddErrorToGridViewColumn(
e.Errors,
GridPlanning.Columns["Amount"],
"*");
}
if (e.NewValues["IssueDate"] == null)
{
Utility.Helpers.AddErrorToGridViewColumn(
e.Errors,
GridPlanning.Columns["IssueDate"],
"*");
}
}
protected void gridBatchAES_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
List <string> RequiredFields = SetRequiredFields();
foreach (GridViewColumn column in gridBatchAES.Columns)
{
GridViewDataColumn dataColumn = column as GridViewDataColumn;
if (dataColumn == null)
{
continue;
}
for (int i = 0; i < RequiredFields.Count; i++)
{
if (RequiredFields[i] == dataColumn.FieldName)
{
if (e.NewValues[dataColumn.FieldName] == null)
{
e.Errors[dataColumn] = "Value can't be empty.";
}
}
}
}
if (string.IsNullOrEmpty(e.RowError) && e.Errors.Count > 0)
{
e.RowError = "Please, correct all errors.";
}
}
protected void gv_ProductCategory_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
e.NewValues["SubCategoryCode"] = (gv_ProductCategory.FindEditFormTemplateControl("txtSubCategoryCode") as ASPxTextBox).Value;
String SubCategoryCode = (e.NewValues["SubCategoryCode"] == null ? string.Empty : e.NewValues["SubCategoryCode"].ToString());
if (SubCategoryCode == String.Empty)
{
throw new Exception("Sub Category Code must not be empty!");
}
e.NewValues["SubCategoryName"] = (gv_ProductCategory.FindEditFormTemplateControl("txtSubCategoryName") as ASPxTextBox).Value;
String SubCategoryName = (e.NewValues["SubCategoryName"] == null ? string.Empty : e.NewValues["SubCategoryName"].ToString());
if (SubCategoryName == String.Empty)
{
throw new Exception("Sub Category Name must not be empty!");
}
int ID = 0;
if (e.IsNewRow)
{
ID = 0;
}
else
{
ID = int.Parse(e.Keys["id"].ToString());
}
if (Product.checkProductSubCategoryExist(SubCategoryCode, ID) == true)
{
throw new Exception("Sub Category already exists in Database!");
}
}
protected void grvSeguranca_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
//**************
//* Declarações
//**************
string SQL = string.Empty;
//*************************
//* Inserção ou alteração?
//*************************
if (e.IsNewRow)
{
//****************************************************
//* A permissão já foi cadastrada para o grupo atual?
//****************************************************
if (oSecurity.IsPermissionInGroup(oLogin, Convert.ToInt32(e.NewValues["codpermissao"]), Convert.ToInt32(cboGrupo.Value), 0))
{
e.Errors.Add(grvSeguranca.Columns["codpermissao"], "A permissão selecionada já foi existe no grupo atual.");
}
}
else
{
//****************************************************
//* A permissão já foi cadastrada para o grupo atual?
//****************************************************
if (oSecurity.IsPermissionInGroup(oLogin, Convert.ToInt32(e.NewValues["codpermissao"]), Convert.ToInt32(cboGrupo.Value), Convert.ToInt32(e.Keys["codagrupamento"])))
{
e.Errors.Add(grvSeguranca.Columns["codpermissao"], "A permissão selecionada já existe no grupo atual.");
}
}
}
protected void gridSku_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
if (Decimal.Parse(e.NewValues["COST"].ToString()) < 0)
{
AddError(e.Errors, gridSkuPriceList.Columns["COST"], "El costo tiene que ser mayor a 0.");
}
}
protected void gvAcreedores_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
//validar rut de acreedor
LogicaNegocio ln = new LogicaNegocio();
bool existe = false;
foreach (GridViewColumn column in gvAcreedores.Columns)
{
GridViewDataColumn dataColumn = column as GridViewDataColumn;
if (dataColumn == null)
{
continue;
}
if (dataColumn.FieldName == "Rut")
{
if (e.IsNewRow)
{
existe = ln.Acreedores(4, e.NewValues["Rut"].ToString(), 0, "", "", 0, 0, 0, 0, "");
if (existe)
{
e.Errors[dataColumn] = "El Rut Ingresado ya esta registrado como acreedor.";
}
}
}
}
}
protected void gridviewBanking_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
if (e.NewValues["Code"] == null)
{
throw new Exception("Mã số Ngân hàng không được để trống.");
}
else
{
XPCollection <Bank> b = new XPCollection <Bank>(session, CriteriaOperator.Parse("Code = '" + e.NewValues["Code"].ToString() + "'"));
if (e.IsNewRow)
{
if (b.Count > 0)
{
throw new Exception("Mã số Ngân hàng đã tồn tại.");
}
}
else
{
if (e.NewValues["Code"].ToString() != e.OldValues["Code"].ToString())
{
if (b.Count > 0)
{
throw new Exception("Mã số Ngân hàng đã tồn tại.");
}
}
}
}
}
//修改数据校验
protected void ASPxGridView1_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
//判断为空
if (e.NewValues["MATERIAL_CODE"].ToString() == "" || e.NewValues["MATERIAL_CODE"].ToString() == null)
{
e.RowError = "物料代码不能为空！";
}
if (e.NewValues["MATERIAL_NUM"].ToString() == "" || e.NewValues["MATERIAL_NUM"].ToString() == null)
{
e.RowError = "物料数量不能为空！";
}
//判断试装台数是否为整数
if (!IsInt(e.NewValues["MATERIAL_NUM"].ToString()))
{
e.RowError = "物料数量必须为正整数!";
}
//判断是否重复
if (ASPxGridView1.IsNewRowEditing)
{
string chSql = "select * from ms_inv_mat where material_code='" + e.NewValues["MATERIAL_CODE"].ToString().ToUpper() + "' "
+ "and gys_code='" + e.NewValues["GYS_CODE"].ToString().ToUpper() + "' and gzdd='" + e.NewValues["GZDD"].ToString() + "'";
DataTable dt = dc.GetTable(chSql);
if (dt.Rows.Count > 0)
{
e.RowError = "该物料该供应商数据已存在，请选择修改操作!";
}
}
}
protected void ASPxGridView1_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
//判断是否重复
if (ASPxGridView1.IsNewRowEditing)
{
string chSql = "SELECT SO,KHMC FROM ATPUKHTM"
+ " WHERE SO='" + e.NewValues["SO"].ToString() + "' and KHMC='" + e.NewValues["KHMC"].ToString() + "'";
DataTable dt = dc.GetTable(chSql);
if (dt.Rows.Count > 0)
{
e.RowError = "该客户这个SO的供应商代码已经维护!";
}
}
if (e.NewValues["SO"].ToString().Length > 20)
{
e.RowError = "SO号字节长度不能超过20！";
}
if (e.NewValues["KHMC"].ToString().Length > 30)
{
e.RowError = "客户名称字节长度不能超过30！";
}
if (e.NewValues["SO"].ToString() == "" || e.NewValues["SO"].ToString() == null)
{
e.RowError = "SO号 不能为空！";
}
}
//修改数据校验
protected void ASPxGridView1_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
string strPlanCode = e.NewValues["PLAN_CODE"].ToString().Trim();
string strPCode = "";
if (txtPCode.Text.Trim() != "")
{
strPCode = txtPCode.Value.ToString();
}
//判断是否重复
if (ASPxGridView1.IsNewRowEditing)
{
string chSql = "select * from ms_single_plan where plan_code='" + strPlanCode + "' and flag='N' and gzdd='" + strPCode + "'";
DataTable dt = dc.GetTable(chSql);
if (dt.Rows.Count > 0)
{
e.RowError = "已存在该计划且尚未要料！";
}
//已参与过计算的计划不能再次要料
string chSql2 = "select * from ms_sfjit_plan_log where plan_code='" + strPlanCode + "' and gzdd='" + strPCode + "'";
DataTable dt2 = dc.GetTable(chSql2);
if (dt2.Rows.Count > 0)
{
e.RowError = "已存在该计划且尚未要料！";
}
}
}
protected void grillaTandaItem_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
int cantidad = Convert.ToInt32(e.NewValues["cantidad"]);
if (cantidad == 0)
{
e.Errors[(sender as ASPxGridView).Columns["cantidad"]] = "La cantidad no puede ser 0";
}
int codigoTalle = Convert.ToInt32(e.NewValues["codigoTalle"]);
int codigoColor = Convert.ToInt32(e.NewValues["codigoColor"]);
ASPxGridView grillaTandaItems = sender as ASPxGridView;
int codigoTanda = Convert.ToInt32(grillaTandaItems.GetMasterRowKeyValue());
int codigoTandaItem;
if (e.Keys.Count != 0)
{
codigoTandaItem = Convert.ToInt32(e.Keys[0]);
}
else
{
codigoTandaItem = 0;
}
if (ControladorGeneral.ValidarTalleEnTanda(codigoTanda, codigoTandaItem, codigoTalle, codigoColor))
{
e.Errors[(sender as ASPxGridView).Columns["codigoTalle"]] = "Ya existe un item en la tanda con el mismo talle y color";
}
}
protected void ASPxGridView1_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
//判断是否重复
string strPCode = e.NewValues["PLINE_CODE"].ToString().Trim();
string strGS = e.NewValues["GS"].ToString().Trim();
string strXL = e.NewValues["XL"].ToString().Trim();
string strPL = e.NewValues["PL"].ToString().Trim();
string strRL = e.NewValues["RL"].ToString().Trim();
string strISDK = e.NewValues["ISDK"].ToString().Trim();
string strISEGR = e.NewValues["ISEGR"].ToString().Trim();
string strROUNT = strGS + strXL + strPL + strRL + strISDK + strISEGR;
if (ASPxGridView1.IsEditing)
{
string chSql = "SELECT ROUNTING_REMARK FROM DATA_ROUNTING_REMARK"
+ " WHERE ROUNTING_REMARK='" + strROUNT + "'";
DataTable dt = dc.GetTable(chSql);
if (dt.Rows.Count > 0)
{
e.RowError = "已存在相同的工艺路线！";
}
}
}
protected void gv_Girdle_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
e.NewValues["value"] = (gv_Girdle.FindEditFormTemplateControl("txtGirdle") as ASPxTextBox).Value;
String Girdle = (e.NewValues["value"] == null ? string.Empty : e.NewValues["value"].ToString());
if (Girdle == String.Empty)
{
throw new Exception("Girdle must not be empty!");
}
int ID = 0;
if (e.IsNewRow)
{
ID = 0;
}
else
{
ID = int.Parse(e.Keys["id"].ToString());
}
if (Stone.checkGirdleExist(Girdle, ID) == true)
{
throw new Exception("Girdle: " + Girdle + " already exist!");
}
}
protected void grdApplication_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
if (e.NewValues["Name"] == null)
{
e.Errors[grdApplication.Columns["Name"]] = "Chưa nhập tên ứng dụng !";
return;
}
bool checkName = false;
if (e.IsNewRow)
{
checkName = true;
}
else
{
if (e.NewValues["Name"].ToString() != e.OldValues["Name"].ToString())
{
checkName = true;
}
}
if (checkName)
{
CriteriaOperator filter = CriteriaOperator.And(new BinaryOperator("Name", e.NewValues["Name"].ToString(), BinaryOperatorType.Equal),
new BinaryOperator("RowStatus", Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.GreaterOrEqual));
XPCollection <App> ac = new XPCollection <App>(session, filter);
if (ac.Count >= 1)
{
e.Errors[grdApplication.Columns["Name"]] = "Tên ứng dụng đã tồn tại !";
return;
}
}
}
protected void ASPxGridView1_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
//判断超长
if (e.NewValues["PLINE_CODE"].ToString().Length > 30)
{
e.RowError = "生产线代码字节长度不能超过30！";
}
if (e.NewValues["BROADCAST_CONTENT"].ToString().Length > 200)
{
e.RowError = "公告字节长度不能超过30！";
}
if (e.NewValues["PLINE_CODE"].ToString() == "" || e.NewValues["PLINE_CODE"].ToString() == null)
{
e.RowError = "生产线代码不能为空！";
}
if (e.NewValues["BROADCAST_CONTENT"].ToString() == "" || e.NewValues["BROADCAST_CONTENT"].ToString() == null)
{
e.RowError = "公告字节不能为空！";
}
//判断是否重复
if (ASPxGridView1.IsNewRowEditing)
{
string chSql = "SELECT PLINE_CODE, BROADCAST_CONTENT FROM DATA_BROADCAST"
+ " WHERE COMPANY_CODE = '" + theCompanyCode + "' AND PLINE_CODE='" + e.NewValues["PLINE_CODE"].ToString() + "'";
DataTable dt = dc.GetTable(chSql);
if (dt.Rows.Count > 0)
{
e.RowError = "该生产线已存在公告！";
}
}
}
protected void grdSeviceSupplier_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
//Gridview new mode
if (grid.IsNewRowEditing)
{
//Validate ManufacturerCategoryId
if (e.NewValues["SupplierId"] == null ||
e.NewValues["SupplierId"].ToString().Trim().Length == 0)
{
Helpers.AddErrorToGridViewColumn(e.Errors,
grid.Columns["SupplierId"],
"Chưa chọn nhà cung cấp");
}
else
{
Guid supplierId = (Guid)e.NewValues["SupplierId"];
//int itemCount = PrivateSession.Instance.BuyingServiceSupplierEntities
// .Where(r => r.SupplierId == supplierId && !r.DeletedFlag).Count();
//if (itemCount > 0)
//{
// Helpers.AddErrorToGridViewColumn(e.Errors,
// grid.Columns["SupplierId"],
// "Nhà cung cấp này đã được chọn");
//}
}
}
}
protected void UiViewSkuTranferencia_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
if (Decimal.Parse(e.NewValues["QTY"].ToString()) < 0)
{
AddError(e.Errors, UiViewSkuTranferencia.Columns["QTY"], "La cantidad tiene que ser mayor a 0.");
}
}
protected void grdServiceEquivalence_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
//Gridview new mode
if (grid.IsNewRowEditing)
{
//Validate EquivalentBuyingServicetId
Guid equivalentBuyingServicetId = (Guid)e.NewValues["EquivalentBuyingServicetId"];
//int itemCount = PrivateSession.Instance.BuyingServiceEquivalenceEntities
// .Where(r => r.EquivalentBuyingServicetId == equivalentBuyingServicetId && !r.DeletedFlag).Count();
//if (itemCount > 0)
//{
// Helpers.AddErrorToGridViewColumn(e.Errors,
// grid.Columns["EquivalentBuyingServicetId"], "Dịch vụ này đã được chọn");
//}
}
//Gridview edit mode
else
{
Guid newEquivalentBuyingServicetId = (Guid)e.NewValues["EquivalentBuyingServicetId"];
Guid oldEquivalentBuyingServicetId = (Guid)e.NewValues["EquivalentBuyingServicetId"];
if (newEquivalentBuyingServicetId != oldEquivalentBuyingServicetId)
{
//int itemCount = PrivateSession.Instance.BuyingServiceEquivalenceEntities
// .Where(r => r.EquivalentBuyingServicetId == newEquivalentBuyingServicetId && !r.DeletedFlag).Count();
//if (itemCount > 0)
//{
// Helpers.AddErrorToGridViewColumn(e.Errors,
// grid.Columns["EquivalentBuyingServicetId"], "Dịch vụ này đã được chọn");
//}
}
}
}
protected void grdPartnerCategory_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
//XPCollection<ViewPartnerPartnerCategory> collection = (XPCollection<ViewPartnerPartnerCategory>)Session["PartnerCategory"];
//foreach (GridViewColumn column in grdPartnerPartnerCategory.Columns)
//{
// GridViewDataColumn dataColumn = column as GridViewDataColumn;
// if (e.NewValues["Code"] == null)
// {
// e.Errors[grdPartnerPartnerCategory.Columns["Code"]] = "Chưa chọn nhóm cộng tác viên !";
// return;
// }
//}
//foreach (ViewPartnerPartnerCategory x in collection)
//{
// if (e.OldValues["Code"] != null)
// {
// if (x.Code.Equals(e.NewValues["Code"].ToString()) && !e.NewValues["Code"].ToString().Equals(e.OldValues["Code"].ToString()))
// {
// e.Errors[grdPartnerPartnerCategory.Columns["Code"]] = "Nhóm cộng tác viên này đã tồn tại !";
// break;
// }
// }
// else
// {
// if (x.Code.Equals(e.NewValues["Code"].ToString()))
// {
// e.Errors[grdPartnerPartnerCategory.Columns["Code"]] = "Nhóm cộng tác viên này đã tồn tại !";
// break;
// }
// }
//}
}
protected void timeSheetGrid_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
if (e.NewValues[1] != null && e.NewValues[2] != null && e.NewValues[4] != null)
{
string toTime = e.NewValues[2].ToString();
DateTime tot = DateTime.Parse(toTime);
var totimeonly = tot - tot.Date;
string ftime = e.NewValues[1].ToString();
DateTime fromt = DateTime.Parse(ftime);
var fromtimeonly = fromt - fromt.Date;
if (totimeonly < fromtimeonly)
{
AddError(e.Errors, timeSheetGrid.Columns["ToTime"], "Enter correct time");
}
}
else
{
AddError(e.Errors, timeSheetGrid.Columns["Description"], "Fields cannot be blank ");
}
}
protected void POAddEditGrid_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
foreach (GridViewColumn column in POAddEditGrid.Columns)
{
GridViewDataColumn dataColumn = column as GridViewDataColumn;
if (dataColumn == null)
{
continue;
}
if (e.NewValues[dataColumn.FieldName] == null)
{
//MRPClass.PrintString(dataColumn.FieldName);
if (dataColumn.FieldName == "TaxGroup" || dataColumn.FieldName == "TaxItemGroup")
{
e.Errors[dataColumn] = "Value cannot be null.";
}
}
}
//Displays the error row if there is at least one error.
if (e.Errors.Count > 0)
{
e.RowError = "Please, fill all fields.";
}
}
protected void grdTransaction_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
string transactionCode = (string)e.NewValues["Code"];
//Insert mode
if (grid.IsNewRowEditing)
{
//Check dupplicate code
bool isExist = Util.isExistXpoObject <Transaction>("Code", transactionCode,
Constant.ROWSTATUS_ACTIVE, Constant.ROWSTATUS_DEFAULT,
Constant.ROWSTATUS_INACTIVE, Constant.ROWSTATUS_TEMP);
if (isExist)
{
Helpers.AddErrorToGridViewColumn(e.Errors, grid.Columns["Code"],
String.Format("Mã bút toán {0} đã tồn tại", transactionCode));
}
}
else
{
string oldTransactionCode = (string)e.OldValues["Code"];
if (!transactionCode.Equals(oldTransactionCode))
{
//Check dupplicate code
bool isExist = Util.isExistXpoObject <Transaction>("Code", transactionCode,
Constant.ROWSTATUS_ACTIVE, Constant.ROWSTATUS_DEFAULT,
Constant.ROWSTATUS_INACTIVE, Constant.ROWSTATUS_TEMP);
if (isExist)
{
Helpers.AddErrorToGridViewColumn(e.Errors, grid.Columns["Code"],
String.Format("Mã bút toán {0} đã tồn tại", transactionCode));
}
}
}
}
protected void gvPhanCongCT_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
string strOldValues;
if (strMess != string.Empty)
{
AddError(e.Errors, gvPhanCongCT.Columns["Error"], strMess);
e.RowError = strMess;
return;
}
foreach (GridViewColumn column in gvPhanCongCT.Columns)
{
GridViewDataColumn dataColumn = column as GridViewDataColumn;
if (dataColumn == null || dataColumn.Caption == "Error")
{
continue;
}
if (e.NewValues[dataColumn.FieldName] == null || e.NewValues[dataColumn.FieldName].ToString().Trim() == string.Empty)
{
e.Errors[dataColumn] = "Vui lòng điền dữ liệu.";
}
}
if (e.Errors.Count > 0)
{
e.RowError = "Vui lòng điền đầy đủ thông tin trước khi lưu.";
return;
}
strOldValues = e.OldValues["STT"] == null ? string.Empty : e.OldValues["STT"].ToString();
if (e.NewValues["STT"].ToString() != strOldValues && pcctDAL.Check_STT(e.NewValues["STT"].ToString()) == 1)
{
AddError(e.Errors, gvPhanCongCT.Columns["STT"], "Đã tồn tại Mã, không thể lưu");
e.RowError = "Trùng mã , vui lòng kiểm tra lại";
return;
}
}
//修改数据校验
protected void ASPxGridView1_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
string strLCode = e.NewValues["LOCATION_CODE"].ToString().Trim();
string strPCode = "";
if (txtPCode.Text.Trim() != "")
{
strPCode = txtPCode.Value.ToString();
}
else
{
e.RowError = "请先选择要维护的生产线！";
return;
}
//判断是否重复
if (ASPxGridView1.IsNewRowEditing)
{
string chSql = "select * from ms_location_time where location_code='" + strLCode + "' and gzdd='" + strPCode + "'";
DataTable dt = dc.GetTable(chSql);
if (dt.Rows.Count > 0)
{
e.RowError = "已存在相同记录！";
}
}
}
