public override void Change() { if (!(MyRule.Get(MyLogin.RoleId, "bbiLanguage") != "OK")) { if (MyRule.AllowAccess) { DIC_LANGUAGE dICLANGUAGE = new DIC_LANGUAGE(); object cellValue = base.GetCellValue(m_RowClickEventArgs.RowIndex, "LanguageCode"); if (cellValue != null) { base.SetWaitDialogCaption("Đang kiểm tra dữ liệu...."); if (!(dICLANGUAGE.Get(cellValue.ToString()) != "OK")) { this.DoHide(); xfmLanguageAdd _xfmLanguageAdd = new xfmLanguageAdd(Actions.Update, dICLANGUAGE); _xfmLanguageAdd.Updated += new xfmLanguageAdd.UpdatedEventHander(this.frm_Updated); _xfmLanguageAdd.Added += new xfmLanguageAdd.AddedEventHander(this.frm_Added); _xfmLanguageAdd.ShowDialog(); } else { this.DoHide(); XtraMessageBox.Show("Dữ liệu không tồn tại", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } } else { MyRule.Notify(); } } }
public static ENT_RETURN Check_Data(DIC_LANGUAGE e) { ENT_RETURN ret = new ENT_RETURN(); string err_msg = string.Empty; // BEGIN CHECK if (Is_Empty_String(e.LanguageName)) { err_msg += GLOBAL.err_code["E008"]; } if (Is_Over_MaxLength(e.LanguageName, 100)) { err_msg += GLOBAL.err_code["E009"]; } if (Is_Over_MaxLength(e.Description, 200)) { err_msg += GLOBAL.err_code["E003"]; } // END CHECK if (err_msg != string.Empty) { ret.Message = err_msg; ret.Status = false; } return(ret); }
public void RaiseUpdatedEventHander(DIC_LANGUAGE Item) { if (this.Updated != null) { this.Updated(this, Item); } }
protected override string uc_Update() { string str; if (MyRule.Get(MyLogin.RoleId, "bbiLanguage") != "OK") { str = ""; } else if (MyRule.AllowEdit) { // SYS_LOG.Insert("Danh Mục Ngoại Ngữ", "Cập Nhật", this.txtID.Text); base.SetWaitDialogCaption("Đang cập nhật dữ liệu..."); DIC_LANGUAGE dICLANGUAGE = new DIC_LANGUAGE(this.txtID.Text, this.txtNAME.Text, this.txtDescription.Text, this.chxUse.Checked); string str1 = dICLANGUAGE.Update(); if (str1 == "OK") { this.RaiseSuccessEventHander(dICLANGUAGE); } if (str1 != "OK") { XtraMessageBox.Show(str1, "Cảnh Báo", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } this.DoHide(); str = str1; } else { MyRule.Notify(); str = ""; } return(str); }
private void RaiseSuccessEventHander(DIC_LANGUAGE item) { if (this.Success != null) { this.Success(this, item); } }
private void RaiseItemSelectedEventHander(DIC_LANGUAGE item) { if (this.ItemSelected != null) { this.ItemSelected(this, item); } }
private bool Insert() { new_entity = new DIC_LANGUAGE(); new_entity.LanguageCode = txt_LANGUAGE_CODE.Text; new_entity.LanguageName = txt_LANGUAGE_NAME.Text; new_entity.Description = txt_DESCRIPTION.Text; //new_entity.IsManager = chk_IS_MANAGER.Checked; new_entity.Active = true; ENT_RETURN validate = LOGIC_CHECK.Check_Data(new_entity); if (validate.Status) { DAO_DIC_LANGUAGE.Add(new_entity); if (parent != null) { parent.dg_DATA.DataSource = DAO_DIC_LANGUAGE.Get_Data(); } } else { XtraMessageBox.Show(validate.Message, "Lỗi.!!!"); return(false); } return(true); }
protected override void Add() { base.Add(); DIC_LANGUAGE dICLANGUAGE = new DIC_LANGUAGE(); txtID.Text = dICLANGUAGE.NewID(); this.txtNAME.Focus(); }
public xfmLanguageAdd(Actions Action) { this.InitializeComponent(); this.Init(); ucAdd.Status = Action; DIC_LANGUAGE dICLANGUAGE = new DIC_LANGUAGE(); ucAdd.SetData(dICLANGUAGE.NewID()); this.Text = "Thêm "; }
private void UpdateRow(DIC_LANGUAGE item, RowClickEventArgs e) { AdvBandedGridView advBandedGridView = this.gbList; int rowIndex = e.RowIndex; advBandedGridView.SetRowCellValue(rowIndex, "Active", item.Active); advBandedGridView.SetRowCellValue(rowIndex, "LanguageCode", item.LanguageCode); advBandedGridView.SetRowCellValue(rowIndex, "LanguageName", item.LanguageName); advBandedGridView.SetRowCellValue(rowIndex, "Description", item.Description); advBandedGridView.UpdateCurrentRow(); }
private void frm_EDIT_Load(object sender, EventArgs e) { old_entity = new DIC_LANGUAGE(); old_entity.LanguageCode = CODE; old_entity = DAO_DIC_LANGUAGE.Select_Record(old_entity); txt_LANGUAGE_CODE.Text = old_entity.LanguageCode; txt_LANGUAGE_NAME.Text = old_entity.LanguageName; txt_DESCRIPTION.Text = old_entity.Description; }
public void SetData(DIC_LANGUAGE item) { this.txtID.Text = item.LanguageCode; // SYS_LOG.Insert("Danh Mục Ngoại Ngữ", "Xem", this.txtID.Text); if (this.m_Status == Actions.Update) { this.txtID.Properties.ReadOnly = true; } this.txtNAME.Text = item.LanguageName; this.txtDescription.Text = item.Description; this.chxUse.Checked = item.Active; }
private void AddRow(DIC_LANGUAGE Item) { AdvBandedGridView advBandedGridView = this.gbList; int focusedRowHandle = advBandedGridView.FocusedRowHandle; advBandedGridView.AddNewRow(); focusedRowHandle = advBandedGridView.FocusedRowHandle; advBandedGridView.SetRowCellValue(focusedRowHandle, "Active", Item.Active); advBandedGridView.SetRowCellValue(focusedRowHandle, "LanguageCode", Item.LanguageCode); advBandedGridView.SetRowCellValue(focusedRowHandle, "LanguageName", Item.LanguageName); advBandedGridView.SetRowCellValue(focusedRowHandle, "Description", Item.Description); advBandedGridView.UpdateCurrentRow(); }
protected override string uc_Delete() { DIC_LANGUAGE dICLANGUAGE = new DIC_LANGUAGE() { LanguageCode = this.txtID.Text }; string str = dICLANGUAGE.Delete(); if (str == "OK") { this.RaiseSuccessEventHander(dICLANGUAGE); } return(str); }
public xfmLanguageAdd(Actions Action, DIC_LANGUAGE Item) { this.InitializeComponent(); this.Init(); this.ucAdd.Status = Action; if (Action == Actions.Update) { this.ucAdd.SetData(Item); this.Text = "Cập nhật"; } else if (Action == Actions.Delete) { this.ucAdd.SetData(Item.LanguageCode); } }
private void ucAdd_Success(object sender, DIC_LANGUAGE Item) { if (this.ucAdd.Status == Actions.Add) { this.RaiseAddedEventHander(Item); } else if (this.ucAdd.Status == Actions.Update) { this.RaiseUpdatedEventHander(Item); } if (this.ucAdd.IsClose == CloseOrNew.Close) { base.Close(); } this.ucAdd.Clear(); }
public static DIC_LANGUAGE Select_Record(DIC_LANGUAGE clsDIC_LANGUAGEPara) { DIC_LANGUAGE clsDIC_LANGUAGE = new DIC_LANGUAGE(); SqlConnection connection = DAO_BASE.Get_Connection(); string selectStatement = "SELECT " + " [LanguageCode] " + " ,[LanguageName] " + " ,[Description] " + " ,[Active] " + "FROM " + " [DIC_LANGUAGE] " + "WHERE " + " [LanguageCode] = @LanguageCode " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; selectCommand.Parameters.AddWithValue("@LanguageCode", clsDIC_LANGUAGEPara.LanguageCode); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsDIC_LANGUAGE.LanguageCode = System.Convert.ToString(reader["LanguageCode"]); clsDIC_LANGUAGE.LanguageName = reader["LanguageName"] is DBNull ? null : reader["LanguageName"].ToString(); clsDIC_LANGUAGE.Description = reader["Description"] is DBNull ? null : reader["Description"].ToString(); clsDIC_LANGUAGE.Active = reader["Active"] is DBNull ? null : (Boolean?)reader["Active"]; } else { clsDIC_LANGUAGE = null; } reader.Close(); } catch (SqlException ex) { throw ex; } finally { connection.Close(); } return(clsDIC_LANGUAGE); }
private void btn_SAVE_Click(object sender, EventArgs e) { new_entity = new DIC_LANGUAGE(); new_entity.LanguageCode = txt_LANGUAGE_CODE.Text; new_entity.LanguageName = txt_LANGUAGE_NAME.Text; new_entity.Description = txt_DESCRIPTION.Text; new_entity.Active = old_entity.Active; ENT_RETURN validate = LOGIC_CHECK.Check_Data(new_entity); if (validate.Status) { DAO_DIC_LANGUAGE.Update(old_entity, new_entity); this.DialogResult = DialogResult.OK; } else { XtraMessageBox.Show(validate.Message, "Lỗi.!!!"); } this.DialogResult = DialogResult.OK; }
protected override string uc_Save() { string str; if (MyRule.Get(MyLogin.RoleId, "bbiLanguage") != "OK") { str = ""; } else if (MyRule.AllowAdd) { // SYS_LOG.Insert("Danh Mục Ngoại Ngữ", "Thêm", this.txtID.Text); base.SetWaitDialogCaption("Đang lưu dữ liệu..."); Cursor.Current = Cursors.WaitCursor; if (txtID.Text == null) { MessageBox.Show("Kiểm tra lại dữ liệu"); } DIC_LANGUAGE dICLANGUAGE = new DIC_LANGUAGE(this.txtID.Text, this.txtNAME.Text, this.txtDescription.Text, this.chxUse.Checked); string str1 = dICLANGUAGE.Insert(); if (str1 == "OK") { this.RaiseSuccessEventHander(dICLANGUAGE); } Cursor.Current = Cursors.Default; this.DoHide(); if (str1 != "OK") { XtraMessageBox.Show(str1, "Cảnh Báo", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } str = str1; } else { MyRule.Notify(); str = ""; } return(str); }
public override void ReLoad() { base.SetWaitDialogCaption("Đang nạp dữ liệu..."); DIC_LANGUAGE dICLANGUAGE = new DIC_LANGUAGE(); this.gcList.DataSource = dICLANGUAGE.GetList(); base.SetWaitDialogCaption("Đang nạp cấu hình..."); this.List_Init(this.gbList); base.SetWaitDialogCaption("Nạp quyền sử dụng ..."); MyRule.Get(MyLogin.RoleId, "bbiLanguage"); if (!MyRule.AllowPrint) { this.ucToolBar.bbiPrint.Visibility = BarItemVisibility.Never; } MyRule.Get(MyLogin.RoleId, "bbiLanguage"); if (!MyRule.AllowExport) { this.ucToolBar.bbiExport.Visibility = BarItemVisibility.Never; } MyRule.Get(MyLogin.RoleId, "bbiLanguage"); if (!MyRule.AllowAdd) { this.ucToolBar.bbiAdd.Visibility = BarItemVisibility.Never; } MyRule.Get(MyLogin.RoleId, "bbiLanguage"); if (!MyRule.AllowDelete) { this.ucToolBar.bbiDelete.Visibility = BarItemVisibility.Never; } MyRule.Get(MyLogin.RoleId, "bbiLanguage"); if (!MyRule.AllowEdit) { this.ucToolBar.bbiEdit.Visibility = BarItemVisibility.Never; } base.SetWaitDialogCaption("Đã xong..."); this.DoHide(); }
private void frm_Updated(object sender, DIC_LANGUAGE Item) { this.UpdateRow(Item, this.m_RowClickEventArgs); }
private void frm_Added(object sender, DIC_LANGUAGE e) { this.AddRow(e); }
public override void Delete() { object cellValue; if (!(MyRule.Get(MyLogin.RoleId, "bbiLanguage") != "OK")) { if (MyRule.AllowDelete) { if (ClsOption.System2.IsQuestion) { if (XtraMessageBox.Show("Bạn có muốn xóa không?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } } base.SetWaitDialogCaption("Đang xóa..."); string str = ""; bool flag = false; AdvBandedGridView advBandedGridView = this.gbList; int[] selectedRows = advBandedGridView.GetSelectedRows(); DIC_LANGUAGE dICLANGUAGE = new DIC_LANGUAGE(); for (int i = (int)selectedRows.Length; i > 0; i--) { flag = true; cellValue = base.GetCellValue(selectedRows[i - 1], "LanguageCode"); if (cellValue != null) { //SYS_LOG.Insert("Danh Mục Ngoại Ngữ", "Xoá", cellValue.ToString()); str = dICLANGUAGE.Delete(cellValue.ToString()); if (str == "OK") { advBandedGridView.DeleteRow(selectedRows[i - 1]); } else if (str != "OK") { MessageBox.Show(string.Concat("Thông tin không được xóa\n", str), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Hand); } } } this.DoHide(); if (!flag) { if (advBandedGridView.DataSource != null) { RowClickEventArgs rowClickEventArg = new RowClickEventArgs((advBandedGridView == null ? -1 : advBandedGridView.FocusedRowHandle), (advBandedGridView.FocusedColumn == null ? -1 : advBandedGridView.FocusedColumn.ColumnHandle), (advBandedGridView.FocusedColumn == null ? "" : advBandedGridView.FocusedColumn.FieldName)); this.m_RowClickEventArgs = rowClickEventArg; cellValue = null; cellValue = base.GetCellValue(rowClickEventArg.RowIndex, "LanguageCode"); if (cellValue != null) { //SYS_LOG.Insert("Danh Mục Ngoại Ngữ", "Xoá", cellValue.ToString()); base.SetWaitDialogCaption("Đang xóa..."); str = dICLANGUAGE.Delete(cellValue.ToString()); if (str == "OK") { advBandedGridView.DeleteRow(rowClickEventArg.RowIndex); } else if (str != "OK") { MessageBox.Show(string.Concat("Thông tin không được xóa\n", str), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Hand); } this.DoHide(); } } } } else { MyRule.Notify(); } } }
public static bool Add(DIC_LANGUAGE clsDIC_LANGUAGE) { SqlConnection connection = DAO_BASE.Get_Connection(); string insertStatement = "INSERT " + " [DIC_LANGUAGE] " + " ( " + " [LanguageCode] " + " ,[LanguageName] " + " ,[Description] " + " ,[Active] " + " ) " + "VALUES " + " ( " + " @LanguageCode " + " ,@LanguageName " + " ,@Description " + " ,@Active " + " ) " + ""; SqlCommand insertCommand = new SqlCommand(insertStatement, connection); insertCommand.CommandType = CommandType.Text; insertCommand.Parameters.AddWithValue("@LanguageCode", clsDIC_LANGUAGE.LanguageCode); if (clsDIC_LANGUAGE.LanguageName != null) { insertCommand.Parameters.AddWithValue("@LanguageName", clsDIC_LANGUAGE.LanguageName); } else { insertCommand.Parameters.AddWithValue("@LanguageName", DBNull.Value); } if (clsDIC_LANGUAGE.Description != null) { insertCommand.Parameters.AddWithValue("@Description", clsDIC_LANGUAGE.Description); } else { insertCommand.Parameters.AddWithValue("@Description", DBNull.Value); } if (clsDIC_LANGUAGE.Active.HasValue == true) { insertCommand.Parameters.AddWithValue("@Active", clsDIC_LANGUAGE.Active); } else { insertCommand.Parameters.AddWithValue("@Active", DBNull.Value); } try { connection.Open(); int count = insertCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public static bool Delete(DIC_LANGUAGE clsDIC_LANGUAGE) { SqlConnection connection = DAO_BASE.Get_Connection(); string deleteStatement = "DELETE FROM " + " [DIC_LANGUAGE] " + "WHERE " + " [LanguageCode] = @OldLanguageCode " + " AND ((@OldLanguageName IS NULL AND [LanguageName] IS NULL) OR [LanguageName] = @OldLanguageName) " + " AND ((@OldDescription IS NULL AND [Description] IS NULL) OR [Description] = @OldDescription) " + " AND ((@OldActive IS NULL AND [Active] IS NULL) OR [Active] = @OldActive) " + ""; SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection); deleteCommand.CommandType = CommandType.Text; deleteCommand.Parameters.AddWithValue("@OldLanguageCode", clsDIC_LANGUAGE.LanguageCode); if (clsDIC_LANGUAGE.LanguageName != null) { deleteCommand.Parameters.AddWithValue("@OldLanguageName", clsDIC_LANGUAGE.LanguageName); } else { deleteCommand.Parameters.AddWithValue("@OldLanguageName", DBNull.Value); } if (clsDIC_LANGUAGE.Description != null) { deleteCommand.Parameters.AddWithValue("@OldDescription", clsDIC_LANGUAGE.Description); } else { deleteCommand.Parameters.AddWithValue("@OldDescription", DBNull.Value); } if (clsDIC_LANGUAGE.Active.HasValue == true) { deleteCommand.Parameters.AddWithValue("@OldActive", clsDIC_LANGUAGE.Active); } else { deleteCommand.Parameters.AddWithValue("@OldActive", DBNull.Value); } try { connection.Open(); int count = deleteCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }
public static bool Update(DIC_LANGUAGE oldDIC_LANGUAGE, DIC_LANGUAGE newDIC_LANGUAGE) { SqlConnection connection = DAO_BASE.Get_Connection(); string updateStatement = "UPDATE " + " [DIC_LANGUAGE] " + "SET " + " [LanguageCode] = @NewLanguageCode " + " ,[LanguageName] = @NewLanguageName " + " ,[Description] = @NewDescription " + " ,[Active] = @NewActive " + "WHERE " + " [LanguageCode] = @OldLanguageCode " + " AND ((@OldLanguageName IS NULL AND [LanguageName] IS NULL) OR [LanguageName] = @OldLanguageName) " + " AND ((@OldDescription IS NULL AND [Description] IS NULL) OR [Description] = @OldDescription) " + " AND ((@OldActive IS NULL AND [Active] IS NULL) OR [Active] = @OldActive) " + ""; SqlCommand updateCommand = new SqlCommand(updateStatement, connection); updateCommand.CommandType = CommandType.Text; updateCommand.Parameters.AddWithValue("@NewLanguageCode", newDIC_LANGUAGE.LanguageCode); if (newDIC_LANGUAGE.LanguageName != null) { updateCommand.Parameters.AddWithValue("@NewLanguageName", newDIC_LANGUAGE.LanguageName); } else { updateCommand.Parameters.AddWithValue("@NewLanguageName", DBNull.Value); } if (newDIC_LANGUAGE.Description != null) { updateCommand.Parameters.AddWithValue("@NewDescription", newDIC_LANGUAGE.Description); } else { updateCommand.Parameters.AddWithValue("@NewDescription", DBNull.Value); } if (newDIC_LANGUAGE.Active.HasValue == true) { updateCommand.Parameters.AddWithValue("@NewActive", newDIC_LANGUAGE.Active); } else { updateCommand.Parameters.AddWithValue("@NewActive", DBNull.Value); } updateCommand.Parameters.AddWithValue("@OldLanguageCode", oldDIC_LANGUAGE.LanguageCode); if (oldDIC_LANGUAGE.LanguageName != null) { updateCommand.Parameters.AddWithValue("@OldLanguageName", oldDIC_LANGUAGE.LanguageName); } else { updateCommand.Parameters.AddWithValue("@OldLanguageName", DBNull.Value); } if (oldDIC_LANGUAGE.Description != null) { updateCommand.Parameters.AddWithValue("@OldDescription", oldDIC_LANGUAGE.Description); } else { updateCommand.Parameters.AddWithValue("@OldDescription", DBNull.Value); } if (oldDIC_LANGUAGE.Active.HasValue == true) { updateCommand.Parameters.AddWithValue("@OldActive", oldDIC_LANGUAGE.Active); } else { updateCommand.Parameters.AddWithValue("@OldActive", DBNull.Value); } try { connection.Open(); int count = updateCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } }