private void bind_M_Grid_Data(int index) { if (dAction==1) { try { //LAY DANH SACH NHIEM VU CUA PHONG BAN cls_Department_Roles dRoles = new cls_Department_Roles(); dRoles.DepartmentId = Convert.ToInt32(ViewState["DeparmentId"]); DataTable dtRoles = dRoles.Select(); m_grid.EditIndex = index; if ((dtRoles == null) || (dtRoles.Rows.Count <= 0)) { DataRow dRow = dtRoles.NewRow(); dRow["Id"] = "0"; dRow["Order"] = "0"; dRow["Note"] = ""; dRow["Describle"] = ""; dtRoles.Rows.Add(dRow); m_grid.DataSource = dtRoles; m_grid.DataBind(); m_grid.Rows[0].Visible = false; } else { m_grid.DataSource = dtRoles; m_grid.DataBind(); } if (m_grid.Rows.Count > 0) { string confirm = "return confirm('Bạn thật sự muốn xóa row này?')"; for (int i = 0; i < m_grid.Rows.Count; i++) { GridViewRow row = m_grid.Rows[i]; ImageButton imgB = (ImageButton)row.FindControl("iBDelete"); if (imgB != null) { imgB.Attributes.Add("onclick", confirm); } } } } catch (Exception ex) { } } else { DataTable dtDRoles = (DataTable)ViewState["dtDRoles"]; if (dtDRoles == null) { dtDRoles = new DataTable(); dtDRoles.Columns.Add("Id", typeof(int)); dtDRoles.Columns.Add("Order", typeof(int)); dtDRoles.Columns.Add("Note", typeof(string)); dtDRoles.Columns.Add("Describle", typeof(string)); } if (dtDRoles.Rows.Count <= 0) { DataRow dRow = dtDRoles.NewRow(); dRow["Id"] = "0"; dRow["Order"] = "0"; dRow["Note"] = ""; dRow["Describle"] = ""; dtDRoles.Rows.Add(dRow); m_grid.DataSource = dtDRoles; m_grid.DataBind(); m_grid.Rows[0].Visible = false; } else { m_grid.EditIndex = index; m_grid.DataSource = dtDRoles; m_grid.DataBind(); } ViewState["dtDRoles"] = dtDRoles; } }
protected void btnUpdate_Click(object sender, EventArgs e) { ltlAnnouncement.Text = ""; try { if (checkInputData()) { cls_DepartmentInformation dInfor = new cls_DepartmentInformation(); dInfor.Id = Convert.ToInt32(Request["D_Id"]); dInfor.CreatedTime = DateTime.Now; dInfor.AdministratorId = Convert.ToInt32(cboAdministrator.SelectedValue); dInfor.Belong_DepartmentId = findDepartmentId(rcbDepartment.Items[0].Text); //Convert.ToInt32(rTree.SelectedValue); dInfor.Established_Date = (dateEstablish.SelectedDate == null) ? new DateTime(1900, 1, 1) : (DateTime)dateEstablish.SelectedDate; dInfor.Established_Number = txtEstaNumber.Text; dInfor.Established_Signer = txtSigner.Text; dInfor.IsActive = Convert.ToInt16(ckbActive.Checked); dInfor.CalculateSalary = Convert.ToInt16(ckbCalSalary.Checked); dInfor.LeaderId = Convert.ToInt32(cboLeader.SelectedValue); dInfor.Name = txtDepartName.Text; dInfor.Order = Convert.ToInt32(rtxtOrder.Text); dInfor.CompanyId = Convert.ToInt16(ddlBelongCompany.SelectedValue); dInfor.SeatPosition = txtSeatPosition.Text; int result; if (dAction==1) result = dInfor.Update(); else { result = dInfor.Insert(); //THEM THONG TIN VE CAC VAI TRO CUA Phong Ban DataTable dtDRoles = (DataTable)ViewState["dtDRoles"]; if (dtDRoles.Rows[0]["Id"].ToString() != "0") { int index = 0; cls_Department_Roles dRoles; while (index < dtDRoles.Rows.Count) { DataRow row = dtDRoles.Rows[index]; dRoles = new cls_Department_Roles(); dRoles.DepartmentId = result; dRoles.Describle = row["Describle"].ToString(); dRoles.Note = row["Note"].ToString(); dRoles.Order = (int)row["Order"]; dRoles.CreatedTime = DateTime.Now; dRoles.Insert(); index++; } } //THEM THONG TIN VE CAC DANH HIEU CUA PHONG BAN DataTable dtHName = (DataTable)ViewState["dtHName"]; if (dtHName.Rows[0]["Id"].ToString() != "0") { int index1 = 0; cls_Department_HonourableName dHName; while (index1 < dtHName.Rows.Count) { DataRow row = dtHName.Rows[index1]; dHName = new cls_Department_HonourableName(); dHName.DepartmentId = result; dHName.Content = row["Content"].ToString(); dHName.CreatedTime = DateTime.Now; dHName.Insert(); index1++; } } ViewState["countDRoles"] = "0"; ViewState["dtDRoles"] = null; ViewState["countHName"] = 0; ViewState["dtHName"] = null; Label13.Text = "Cập nhật thông tin"; ddlCompany.SelectedValue = dInfor.CompanyId.ToString(); btnDelete.Visible = true; } if (result > 0) { ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "MyScript", "alert('Cập nhật thông tin Phòng Ban " + txtDepartName.Text + " thành công.');", true); Response.Redirect("Department.aspx?C_Id="+ddlBelongCompany.SelectedValue); //bindTreeView(); } else if (result == 0) ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "MyScript", "alert('Không cập nhật được thông tin Phòng Ban " + txtDepartName.Text + ".');", true); else ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "MyScript", "alert('Trùng tên Phòng Ban " + txtDepartName.Text + ", không thể cập nhật.');", true); } } catch (Exception ex) { ltlAnnouncement.Text = "Có lỗi trong quá trình cập nhật thông tin Phòng Ban " + txtDepartName.Text + ": " + ex.ToString(); } }
protected void m_grid_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { int id = e.RowIndex; m_grid.EditIndex = id; int delId = (int)m_grid.DataKeys[e.RowIndex].Value; if (delId != 0) { if (dAction==1) { cls_Department_Roles dRoles = new cls_Department_Roles(); dRoles.Id = delId; int status_Delete = dRoles.Delete(); } else { DataTable dtDRoles = (DataTable)ViewState["dtDRoles"]; dtDRoles.Rows[id].Delete(); dtDRoles.AcceptChanges(); ViewState["dtDRoles"] = dtDRoles; } } } catch (Exception ex) { if (dAction==1) ltlAnnouncement.Text = "Lỗi trong quá trình xóa nhiệm vụ Phòng Ban: " + ex.ToString(); } bind_M_Grid_Data(-1); }
protected void m_grid_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { int id = e.RowIndex; m_grid.EditIndex = id; GridViewRow row = m_grid.Rows[id]; string rDes = ((TextBox)row.FindControl("txtUDescrible")).Text; string rNote = ((TextBox)row.FindControl("txtUNote")).Text; string orderStr = ((TextBox)row.FindControl("txtUOrder")).Text; if (!checkMgridData(rDes, orderStr)) return; int updateId = Int32.Parse(m_grid.DataKeys[id].Value.ToString()); if (updateId > 0) { if (dAction==1) { cls_Department_Roles dRoles = new cls_Department_Roles(); dRoles.Id = updateId; dRoles.DepartmentId = Convert.ToInt32(ViewState["DeparmentId"]); dRoles.Note = rNote; dRoles.Describle = rDes; dRoles.Order = int.Parse(orderStr); dRoles.CreatedTime = DateTime.Now; int _result = dRoles.Update(); } else { DataTable dtDRoles = (DataTable)ViewState["dtDRoles"]; dtDRoles.Rows[id]["Describle"] = rDes; dtDRoles.Rows[id]["Order"] = orderStr; dtDRoles.Rows[id]["Note"] = rNote; ViewState["dtDRoles"] = dtDRoles; } } } catch (Exception ex) { if (dAction==1) ltlAnnouncement.Text = "Không cập nhật được dữ liệu. Vui lòng liên hệ quản trị: <br>" + ex.Message; } bind_M_Grid_Data(-1); }
protected void m_grid_RowCommand(object sender, GridViewCommandEventArgs e) { try { string commandName = e.CommandName; GridViewRow row = m_grid.FooterRow; if (commandName == "Insert") { string rDes = ((TextBox)row.FindControl("txtIDescrible")).Text; string rNote = ((TextBox)row.FindControl("txtINote")).Text; string orderStr = ((TextBox)row.FindControl("txtIOrder")).Text; int order = -1; if (!checkMgridData(rDes, orderStr)) return; if (dAction==1) { cls_Department_Roles dRoles = new cls_Department_Roles(); dRoles.DepartmentId = Convert.ToInt32(ViewState["DeparmentId"]); dRoles.Note = rNote; dRoles.Describle = rDes; dRoles.CreatedTime = DateTime.Now; int _result = dRoles.Insert(); } else { ViewState["countDRoles"] = (Convert.ToInt32(ViewState["countDRoles"]) + 1).ToString(); DataTable dtDRoles = (DataTable)ViewState["dtDRoles"]; if (Convert.ToInt32(ViewState["countDRoles"]) == 1) dtDRoles.Rows[0].Delete(); DataRow rowDT = dtDRoles.NewRow(); rowDT["Id"] = ViewState["countDRoles"]; rowDT["Describle"] = rDes; rowDT["Order"] = orderStr; rowDT["Note"] = rNote; dtDRoles.Rows.Add(rowDT); ViewState["dtDRoles"] = dtDRoles; } bind_M_Grid_Data(-1); } } catch (Exception ex) { if (dAction==1) ltlAnnouncement.Text = "Khong them moi duoc du lieu. Vui long lien he voi quan tri<br>" + ex.Message; } }