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