private bool bKiemTrung()
{
try
{
DataTable dtTmp = new DataTable();
Int16 iKiem = 0;
iKiem = Convert.ToInt16(SqlHelper.ExecuteScalar(Commons.IConnections.CNStr, "spCheckData", "ID_PX",
(AddEdit ? "-1" : Id.ToString()), "PHUONG_XA", "TEN_PX", TEN_PXTextEdit.EditValue.ToString(),
"", "", "", ""));
if (iKiem > 0)
{
XtraMessageBox.Show(Commons.Modules.ObjLanguages.GetLanguage(this.Name, "msgTEN_PXNayDaTonTai"));
TEN_PXTextEdit.Focus();
return(true);
}
iKiem = 0;
if (!string.IsNullOrEmpty(TEN_PX_ATextEdit.Text))
{
iKiem = Convert.ToInt16(SqlHelper.ExecuteScalar(Commons.IConnections.CNStr, "spCheckData", "ID_PX",
(AddEdit ? "-1" : Id.ToString()), "PHUONG_XA", "TEN_PX_A", TEN_PX_ATextEdit.EditValue.ToString(),
"", "", "", ""));
if (iKiem > 0)
{
XtraMessageBox.Show(Commons.Modules.ObjLanguages.GetLanguage(this.Name, "msgTEN_PX_ANayDaTonTai"));
TEN_PX_ATextEdit.Focus();
return(true);
}
}
iKiem = 0;
if (!string.IsNullOrEmpty(TEN_PX_HTextEdit.Text))
{
iKiem = Convert.ToInt16(SqlHelper.ExecuteScalar(Commons.IConnections.CNStr, "spCheckData", "ID_PX",
(AddEdit ? "-1" : Id.ToString()), "PHUONG_XA", "TEN_PX_H", TEN_PX_HTextEdit.EditValue.ToString(),
"", "", "", ""));
if (iKiem > 0)
{
XtraMessageBox.Show(Commons.Modules.ObjLanguages.GetLanguage(this.Name, "msgTEN_PX_HNayDaTonTai"));
TEN_PX_HTextEdit.Focus();
return(true);
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message.ToString());
return(true);
}
return(false);
}
private void LoadTextNull()
{
try
{
TEN_PXTextEdit.EditValue = String.Empty;
TEN_PX_ATextEdit.EditValue = String.Empty;
TEN_PX_HTextEdit.EditValue = String.Empty;
MS_XATextEdit.EditValue = String.Empty;
TEN_PXTextEdit.Focus();
}
catch { }
}
