private void LoadTextNull()
{
try
{
MS_NLTextEdit.EditValue = String.Empty;
TEN_NLTextEdit.EditValue = String.Empty;
TEN_NL_ATextEdit.EditValue = String.Empty;
TEN_NL_HTextEdit.EditValue = String.Empty;
MS_NLTextEdit.Focus();
}
catch { }
}
private bool bKiemTrung()
{
try
{
DataTable dtTmp = new DataTable();
Int16 iKiem = 0;
iKiem = Convert.ToInt16(SqlHelper.ExecuteScalar(Commons.IConnections.CNStr, "spCheckData", "ID_NL",
(AddEdit ? "-1" : Id.ToString()), "NGACH_LUONG", "MS_NL", MS_NLTextEdit.EditValue.ToString(),
"", "", "", ""));
if (iKiem > 0)
{
XtraMessageBox.Show(Commons.Modules.ObjLanguages.GetLanguage(this.Name, "msgMS_NLNayDaTonTai"));
MS_NLTextEdit.Focus();
return(true);
}
iKiem = 0;
if (!string.IsNullOrEmpty(TEN_NLTextEdit.Text.ToString()))
{
iKiem = Convert.ToInt16(SqlHelper.ExecuteScalar(Commons.IConnections.CNStr, "spCheckData", "ID_NL",
(AddEdit ? "-1" : Id.ToString()), "NGACH_LUONG", "TEN_NL", TEN_NLTextEdit.EditValue.ToString(),
"", "", "", ""));
if (iKiem > 0)
{
XtraMessageBox.Show(Commons.Modules.ObjLanguages.GetLanguage(this.Name, "msgTEN_NLNayDaTonTai"));
TEN_NLTextEdit.Focus();
return(true);
}
}
iKiem = 0;
if (!string.IsNullOrEmpty(TEN_NL_ATextEdit.Text.ToString()))
{
iKiem = Convert.ToInt16(SqlHelper.ExecuteScalar(Commons.IConnections.CNStr, "spCheckData", "ID_NL",
(AddEdit ? "-1" : Id.ToString()), "NGACH_LUONG", "TEN_NL_A", TEN_NL_ATextEdit.EditValue.ToString(),
"", "", "", ""));
if (iKiem > 0)
{
XtraMessageBox.Show(Commons.Modules.ObjLanguages.GetLanguage(this.Name, "msgTEN_NL_ANayDaTonTai"));
TEN_NL_ATextEdit.Focus();
return(true);
}
}
iKiem = 0;
if (!string.IsNullOrEmpty(TEN_NL_HTextEdit.Text.ToString()))
{
iKiem = Convert.ToInt16(SqlHelper.ExecuteScalar(Commons.IConnections.CNStr, "spCheckData", "ID_NL",
(AddEdit ? "-1" : Id.ToString()), "NGACH_LUONG", "TEN_NL_H", TEN_NL_HTextEdit.EditValue.ToString(),
"", "", "", ""));
if (iKiem > 0)
{
XtraMessageBox.Show(Commons.Modules.ObjLanguages.GetLanguage(this.Name, "msgTEN_NL_HNayDaTonTai"));
TEN_NL_HTextEdit.Focus();
return(true);
}
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message.ToString());
return(true);
}
return(false);
}
