public static bool Add(DIC_SALARY_RANK clsDIC_SALARY_RANK) { SqlConnection connection = DAO_BASE.Get_Connection(); string insertStatement = "INSERT " + " [DIC_SALARY_RANK] " + " ( " + " [RankCode] " + " ,[RankName] " + " ,[Description] " + " ) " + "VALUES " + " ( " + " @RankCode " + " ,@RankName " + " ,@Description " + " ) " + ""; SqlCommand insertCommand = new SqlCommand(insertStatement, connection); insertCommand.CommandType = CommandType.Text; insertCommand.Parameters.AddWithValue("@RankCode", clsDIC_SALARY_RANK.RankCode); if (clsDIC_SALARY_RANK.RankName != null) { insertCommand.Parameters.AddWithValue("@RankName", clsDIC_SALARY_RANK.RankName); } else { insertCommand.Parameters.AddWithValue("@RankName", DBNull.Value); } if (clsDIC_SALARY_RANK.Description != null) { insertCommand.Parameters.AddWithValue("@Description", clsDIC_SALARY_RANK.Description); } else { insertCommand.Parameters.AddWithValue("@Description", 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(); } }
private void RaiseItemSelectedEventHander(DIC_SALARY_RANK item) { if (this.ItemSelected != null) { this.ItemSelected(this, item); } }
public override void Change() { if (!(MyRule.Get(MyLogin.RoleId, "bbiRank") != "OK")) { if (MyRule.AllowAccess) { DIC_SALARY_RANK dICSALARYRANK = new DIC_SALARY_RANK(); object cellValue = base.GetCellValue(this.m_RowClickEventArgs.RowIndex, "RankCode"); if (cellValue != null) { base.SetWaitDialogCaption("Đang kiểm tra dữ liệu...."); if (!(dICSALARYRANK.Get(cellValue.ToString()) != "OK")) { this.DoHide(); xfmRankAdd _xfmRankAdd = new xfmRankAdd(Actions.Update, dICSALARYRANK); _xfmRankAdd.Updated += new xfmRankAdd.UpdatedEventHander(this.frm_Updated); _xfmRankAdd.Added += new xfmRankAdd.AddedEventHander(this.frm_Added); _xfmRankAdd.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 void RaiseUpdatedEventHander(DIC_SALARY_RANK Item) { if (this.Updated != null) { this.Updated(this, Item); } }
protected override string uc_Update() { string str; if (MyRule.Get(MyLogin.RoleId, "bbiRank") != "OK") { str = ""; } else if (MyRule.AllowEdit) { // SYS_LOG.Insert("Danh Mục Ngạch Lương", "Cập Nhật", this.txtID.Text); base.SetWaitDialogCaption("Đang cập nhật dữ liệu..."); DIC_SALARY_RANK dICSALARYRANK = new DIC_SALARY_RANK(this.txtID.Text, this.txtNAME.Text, this.txtDescription.Text); string str1 = dICSALARYRANK.Update(); if (str1 == "OK") { this.RaiseSuccessEventHander(dICSALARYRANK); } 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_SALARY_RANK item) { if (this.Success != null) { this.Success(this, item); } }
protected override string uc_Save() { string str; if (MyRule.Get(MyLogin.RoleId, "bbiRank") != "OK") { str = ""; } else if (MyRule.AllowAdd) { // SYS_LOG.Insert("Danh Mục Ngạch Lương", "Thêm", this.txtID.Text); base.SetWaitDialogCaption("Đang lưu dữ liệu..."); Cursor.Current = Cursors.WaitCursor; DIC_SALARY_RANK dICSALARYRANK = new DIC_SALARY_RANK(this.txtID.Text, this.txtNAME.Text, this.txtDescription.Text); string str1 = dICSALARYRANK.Insert(); if (str1 == "OK") { this.RaiseSuccessEventHander(dICSALARYRANK); } 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); }
protected override void Add() { base.Add(); DIC_SALARY_RANK dICSALARYRANK = new DIC_SALARY_RANK(); this.txtID.Text = dICSALARYRANK.NewID(); this.txtNAME.Focus(); }
public xfmRankAdd(Actions Action) { this.InitializeComponent(); this.Init(); this.ucAdd.Status = Action; DIC_SALARY_RANK dICSALARYRANK = new DIC_SALARY_RANK(); this.ucAdd.SetData(dICSALARYRANK.NewID()); this.Text = "Thêm"; }
private void UpdateRow(DIC_SALARY_RANK item, RowClickEventArgs e) { AdvBandedGridView advBandedGridView = this.gbList; int rowIndex = e.RowIndex; advBandedGridView.SetRowCellValue(rowIndex, "RankCode", item.RankCode); advBandedGridView.SetRowCellValue(rowIndex, "RankName", item.RankName); advBandedGridView.SetRowCellValue(rowIndex, "Description", item.Description); advBandedGridView.UpdateCurrentRow(); }
public void SetData(DIC_SALARY_RANK item) { this.txtID.Text = item.RankCode; // SYS_LOG.Insert("Danh Mục Ngạch Lương", "Xem", this.txtID.Text); if (this.m_Status == Actions.Update) { this.txtID.Properties.ReadOnly = true; } this.txtNAME.Text = item.RankName; this.txtDescription.Text = item.Description; }
private void AddRow(DIC_SALARY_RANK Item) { AdvBandedGridView advBandedGridView = this.gbList; int focusedRowHandle = advBandedGridView.FocusedRowHandle; advBandedGridView.AddNewRow(); focusedRowHandle = advBandedGridView.FocusedRowHandle; advBandedGridView.SetRowCellValue(focusedRowHandle, "RankCode", Item.RankCode); advBandedGridView.SetRowCellValue(focusedRowHandle, "RankName", Item.RankName); advBandedGridView.SetRowCellValue(focusedRowHandle, "Description", Item.Description); advBandedGridView.UpdateCurrentRow(); }
public static bool Delete(DIC_SALARY_RANK clsDIC_SALARY_RANK) { SqlConnection connection = DAO_BASE.Get_Connection(); string deleteStatement = "DELETE FROM " + " [DIC_SALARY_RANK] " + "WHERE " + " [RankCode] = @OldRankCode " + " AND ((@OldRankName IS NULL AND [RankName] IS NULL) OR [RankName] = @OldRankName) " + " AND ((@OldDescription IS NULL AND [Description] IS NULL) OR [Description] = @OldDescription) " + ""; SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection); deleteCommand.CommandType = CommandType.Text; deleteCommand.Parameters.AddWithValue("@OldRankCode", clsDIC_SALARY_RANK.RankCode); if (clsDIC_SALARY_RANK.RankName != null) { deleteCommand.Parameters.AddWithValue("@OldRankName", clsDIC_SALARY_RANK.RankName); } else { deleteCommand.Parameters.AddWithValue("@OldRankName", DBNull.Value); } if (clsDIC_SALARY_RANK.Description != null) { deleteCommand.Parameters.AddWithValue("@OldDescription", clsDIC_SALARY_RANK.Description); } else { deleteCommand.Parameters.AddWithValue("@OldDescription", 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(); } }
protected override string uc_Delete() { DIC_SALARY_RANK dICSALARYRANK = new DIC_SALARY_RANK() { RankCode = this.txtID.Text }; string str = dICSALARYRANK.Delete(); if (str == "OK") { this.RaiseSuccessEventHander(dICSALARYRANK); } return(str); }
public xfmRankAdd(Actions Action, DIC_SALARY_RANK 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.RankCode); } }
private void ucAdd_Success(object sender, DIC_SALARY_RANK 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(); }
protected override void txtID_KeyDown(object sender, KeyEventArgs e) { TextEdit textEdit = (TextEdit)sender; if (e.KeyCode == Keys.Return | e.KeyCode == Keys.Tab) { DIC_SALARY_RANK dICSALARYRANK = new DIC_SALARY_RANK(); if (this.m_Status == Actions.Add) { if (dICSALARYRANK.Exist(textEdit.Text)) { this.Err.SetError(textEdit, "Mã đã tồn tại."); textEdit.Focus(); } } } }
public static DIC_SALARY_RANK Select_Record(DIC_SALARY_RANK clsDIC_SALARY_RANKPara) { DIC_SALARY_RANK clsDIC_SALARY_RANK = new DIC_SALARY_RANK(); SqlConnection connection = DAO_BASE.Get_Connection(); string selectStatement = "SELECT " + " [RankCode] " + " ,[RankName] " + " ,[Description] " + "FROM " + " [DIC_SALARY_RANK] " + "WHERE " + " [RankCode] = @RankCode " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; selectCommand.Parameters.AddWithValue("@RankCode", clsDIC_SALARY_RANKPara.RankCode); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsDIC_SALARY_RANK.RankCode = System.Convert.ToString(reader["RankCode"]); clsDIC_SALARY_RANK.RankName = reader["RankName"] is DBNull ? null : reader["RankName"].ToString(); clsDIC_SALARY_RANK.Description = reader["Description"] is DBNull ? null : reader["Description"].ToString(); } else { clsDIC_SALARY_RANK = null; } reader.Close(); } catch (SqlException ex) { throw ex; } finally { connection.Close(); } return(clsDIC_SALARY_RANK); }
public override void ReLoad() { base.SetWaitDialogCaption("Đang nạp dữ liệu..."); DIC_SALARY_RANK dICSALARYRANK = new DIC_SALARY_RANK(); this.gcList.DataSource = dICSALARYRANK.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, "bbiRank"); if (!MyRule.AllowPrint) { this.ucToolBar.bbiPrint.Visibility = BarItemVisibility.Never; } MyRule.Get(MyLogin.RoleId, "bbiRank"); if (!MyRule.AllowExport) { this.ucToolBar.bbiExport.Visibility = BarItemVisibility.Never; } MyRule.Get(MyLogin.RoleId, "bbiRank"); if (!MyRule.AllowAdd) { this.ucToolBar.bbiAdd.Visibility = BarItemVisibility.Never; } MyRule.Get(MyLogin.RoleId, "bbiRank"); if (!MyRule.AllowDelete) { this.ucToolBar.bbiDelete.Visibility = BarItemVisibility.Never; } MyRule.Get(MyLogin.RoleId, "bbiRank"); if (!MyRule.AllowEdit) { this.ucToolBar.bbiEdit.Visibility = BarItemVisibility.Never; } base.SetWaitDialogCaption("Đã xong..."); this.DoHide(); }
private void frm_Added(object sender, DIC_SALARY_RANK e) { this.AddRow(e); }
public static bool Update(DIC_SALARY_RANK oldDIC_SALARY_RANK, DIC_SALARY_RANK newDIC_SALARY_RANK) { SqlConnection connection = DAO_BASE.Get_Connection(); string updateStatement = "UPDATE " + " [DIC_SALARY_RANK] " + "SET " + " [RankCode] = @NewRankCode " + " ,[RankName] = @NewRankName " + " ,[Description] = @NewDescription " + "WHERE " + " [RankCode] = @OldRankCode " + " AND ((@OldRankName IS NULL AND [RankName] IS NULL) OR [RankName] = @OldRankName) " + " AND ((@OldDescription IS NULL AND [Description] IS NULL) OR [Description] = @OldDescription) " + ""; SqlCommand updateCommand = new SqlCommand(updateStatement, connection); updateCommand.CommandType = CommandType.Text; updateCommand.Parameters.AddWithValue("@NewRankCode", newDIC_SALARY_RANK.RankCode); if (newDIC_SALARY_RANK.RankName != null) { updateCommand.Parameters.AddWithValue("@NewRankName", newDIC_SALARY_RANK.RankName); } else { updateCommand.Parameters.AddWithValue("@NewRankName", DBNull.Value); } if (newDIC_SALARY_RANK.Description != null) { updateCommand.Parameters.AddWithValue("@NewDescription", newDIC_SALARY_RANK.Description); } else { updateCommand.Parameters.AddWithValue("@NewDescription", DBNull.Value); } updateCommand.Parameters.AddWithValue("@OldRankCode", oldDIC_SALARY_RANK.RankCode); if (oldDIC_SALARY_RANK.RankName != null) { updateCommand.Parameters.AddWithValue("@OldRankName", oldDIC_SALARY_RANK.RankName); } else { updateCommand.Parameters.AddWithValue("@OldRankName", DBNull.Value); } if (oldDIC_SALARY_RANK.Description != null) { updateCommand.Parameters.AddWithValue("@OldDescription", oldDIC_SALARY_RANK.Description); } else { updateCommand.Parameters.AddWithValue("@OldDescription", 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(); } }
public override void Delete() { object cellValue; if (!(MyRule.Get(MyLogin.RoleId, "bbiRank") != "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_SALARY_RANK dICSALARYRANK = new DIC_SALARY_RANK(); for (int i = (int)selectedRows.Length; i > 0; i--) { flag = true; cellValue = base.GetCellValue(selectedRows[i - 1], "RankCode"); if (cellValue != null) { SYS_LOG.Insert("Danh Mục Ngạch Lương", "Xoá", cellValue.ToString()); str = dICSALARYRANK.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, "RankCode"); if (cellValue != null) { SYS_LOG.Insert("Danh Mục Ngạch Lương", "Xoá", cellValue.ToString()); base.SetWaitDialogCaption("Đang xóa..."); str = dICSALARYRANK.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(); } } }
private void frm_Updated(object sender, DIC_SALARY_RANK Item) { this.UpdateRow(Item, this.m_RowClickEventArgs); }