protected void btnDelete_Click(object sender, EventArgs e) { try { cls_DepartmentInformation dInfor = new cls_DepartmentInformation(); dInfor.Id = Convert.ToInt32(Request["D_Id"]); int result = dInfor.Delete(); ddlCompany.SelectedValue = ddlBelongCompany.SelectedValue; if (result > 0) { ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "MyScript", "alert('Xóa thông tin Phòng Ban thành công.');", true); if (Request.UrlReferrer != null) Response.Redirect(Request.UrlReferrer.ToString()); else Response.Redirect("Department.aspx"); } else ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "MyScript", "alert('Không xóa được thông tin Phòng Ban. Vui lòng thử lại !!!');", true); } catch (Exception ex) { ltlAnnouncement.Text = "Có lỗi khi xóa thông tin Phòng Ban: " + ex.ToString(); } }
private void LoadDataToDepartment() { if (trDepartment.Nodes.Count > 0) trDepartment.Nodes.Clear(); cls_DepartmentInformation objDe = new cls_DepartmentInformation(); dtDepartment = objDe.GetList(); ShowDSTreeview(trDepartment, dtDepartment, 0, "Id", "Name", "Belong_DepartmentId","Toàn bộ phòng ban"); trDepartment.ExpandAllNodes(); }
private void bindTreeView(RadTreeView rtrDepartment) { // ---- BIND DU LIEU VAO LISTVIEW -- cls_DepartmentInformation dInfor = new cls_DepartmentInformation(); dInfor.CompanyId = 1; DataTable dtDepart = dInfor.SelectForSalary(); ViewState["DT_DEPARTMENT"] = dtDepart; //int countDepartment = dtDepart.Rows.Count; //ShowDSTreeview(0, rtrDepartment); RadTreeNode node = new RadTreeNode(); node.Text = "--- Lựa chọn ---"; node.Value = "0"; rtrDepartment.Nodes.Add(node); addNodeTreeView("0", node, dtDepart); }
private void bindTreeView(RadTreeView rtrDepartment) { // ---- BIND DU LIEU VAO LISTVIEW -- cls_DepartmentInformation dInfor = new cls_DepartmentInformation(); dInfor.CompanyId = Convert.ToInt16(ddlBelongCompany.SelectedValue); DataTable dtDepart = dInfor.SelectByComId(); ViewState["DT_DEPARTMENT"] = dtDepart; RadTreeNode node = new RadTreeNode(); node.Text = "--- Lựa chọn ---"; node.Value = "0"; rtrDepartment.Nodes.Add(node); addNodeTreeView("0", node, dtDepart); }
private void bindListDepartment() { try { cls_DepartmentInformation dInfor = new cls_DepartmentInformation(); dInfor.CompanyId = Convert.ToInt16(ddlCompany.SelectedValue); DataTable dtDInfo = dInfor.SelectDTS(); StringBuilder sb = new StringBuilder(); for (int i = 0; i < dtDInfo.Rows.Count; i++) { sb.Append("<tr>"+ " <td nowrap=\"nowrap\" align=\"center\">"+ " "+(i+1).ToString()+ " </td><td nowrap=\"nowrap\" align=\"Left\">" + dtDInfo.Rows[i]["ExtendStr"].ToString() + " <a class=\"NormalBold\" href=\"Department.aspx?D_Id=" + dtDInfo.Rows[i]["Id"].ToString() + "&D_Action=1\">" + " <acronym title=''>" + dtDInfo.Rows[i]["DepartNameNature"].ToString() + " </acronym>"+ " </a>"+ " </td><td valign=\"Top\">" + dtDInfo.Rows[i]["Established_Number"].ToString() + " </td><td align=\"Center\" valign=\"Top\">" + dtDInfo.Rows[i]["Established_Date"].ToString() + " </td><td valign=\"Top\">" + dtDInfo.Rows[i]["Established_Signer"].ToString() + " </td><td valign=\"Top\">" + dtDInfo.Rows[i]["LeaderMember"].ToString() + " </td>"+ "</tr>"); } ltl_ListDepartment.Text = sb.ToString(); } catch (Exception ex) { } }
/* private void bindTreeView() { trDepartment.Nodes.Clear(); // ---- BIND DU LIEU VAO LISTVIEW -- cls_DepartmentInformation dInfor = new cls_DepartmentInformation(); dInfor.CompanyId = Convert.ToInt16(ddlCompany.SelectedValue); DataTable dtDepart = dInfor.SelectByComId(); ViewState["countDepartment"] = dtDepart.Rows.Count.ToString(); DataRow[] _Row = dtDepart.Select("DepartParentId=0"); if (_Row.Count() > 0) { for (int i = 0; i < _Row.Count(); i++) { TreeNode node = new TreeNode(); node.Text = _Row[i]["DepartName"].ToString(); node.Value = _Row[i]["Id"].ToString(); trDepartment.Nodes.Add(node); addNode(_Row[i]["Id"].ToString(), node, dtDepart); } } } private void addNode(string parentId, TreeNode parentNode, DataTable dtDepart) { try { DataRow[] _Row = dtDepart.Select("DepartParentId=" + parentId); if (_Row.Count() > 0) { for (int i = 0; i < _Row.Count(); i++) { TreeNode childNode = new TreeNode(); childNode.Text = _Row[i]["DepartName"].ToString(); childNode.Value = _Row[i]["Id"].ToString(); parentNode.ChildNodes.Add(childNode); addNode(_Row[i]["Id"].ToString(), childNode, dtDepart); } } } catch (Exception ex) { } } * */ private void bindData() { ckbActive.Checked = true; if (dAction != 2) { try { //LAY THONG TIN PHONG BAN cls_DepartmentInformation cDepart = new cls_DepartmentInformation(); cDepart.Id = Convert.ToInt32(Request["D_Id"]); cDepart = cDepart.Select(); if (cDepart != null) { txtDepartName.Text = cDepart.Name; rtxtOrder.Text = cDepart.Order.ToString(); ddlBelongCompany.SelectedValue = cDepart.CompanyId.ToString(); if(cDepart.Established_Date.CompareTo(new DateTime(1900, 1, 1)) > 0) dateEstablish.SelectedDate = cDepart.Established_Date; txtEstaNumber.Text = cDepart.Established_Number; txtSigner.Text = cDepart.Established_Signer; txtSeatPosition.Text = cDepart.SeatPosition; ckbActive.Checked = (cDepart.IsActive == 1) ? true : false; ckbCalSalary.Checked = (cDepart.CalculateSalary == 1) ? true : false; if (cDepart.CompanyId > 0) { rcbDepartment_Bind(); bindRadCombo(); } RadTreeView rTree = (RadTreeView)rcbDepartment.Items[0].FindControl("rtrDepartment"); RadTreeNode node = rTree.FindNodeByValue(cDepart.Belong_DepartmentId.ToString()); node.Selected = true; rcbDepartment.Items[0].Text = node.Text; cboLeader.SelectedValue = cDepart.LeaderId.ToString(); cboAdministrator.SelectedValue = cDepart.AdministratorId.ToString(); } bind_M_Grid_Data(-1); bind_Ls_HonourName(-1); } catch (Exception ex) { } } else //insert them department moi { bind_M_Grid_Data(-1); bind_Ls_HonourName(-1); if (ViewState["countHName"].ToString() == "0") lvHonourName.Items[0].Visible = false; if (ViewState["countDRoles"].ToString() == "0") m_grid.Rows[0].Visible = false; if ((ViewState["countDRoles"].ToString() == "0") && (ViewState["countHName"].ToString() == "0")) { //VIEW DU LIEU LEN txtDepartName.Text = ""; rtxtOrder.Text = ""; txtEstaNumber.Text = ""; txtSigner.Text = ""; } rcbDepartment_Bind(); bindRadCombo(); RadTreeView rTree = (RadTreeView)rcbDepartment.Items[0].FindControl("rtrDepartment"); rTree.Nodes[0].Selected = true; rcbDepartment.Items[0].Text = rTree.Nodes[0].Text; cboAdministrator.SelectedValue = cboLeader.SelectedValue = "0"; } }
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(); } }
private void bindRepeaterG(int gId) { try { //LAY DANH SACH CONG TY cls_Module_Authority_Employee aEmp = new cls_Module_Authority_Employee(); aEmp.EmployeeId = Convert.ToInt32(Session["UserId"]); DataTable dt = aEmp.GetCompanyByAuthorityCode(ConfigurationSettings.AppSettings["PermissionAuthority"]); ddlCompanySelect1.DataSource = dt; ddlCompanySelect1.DataBind(); ViewState["DT_COMPANY"] = dt; ViewState["DT_DEPARTMENT"] = new cls_DepartmentInformation().SelectList(0); bindGroupList(gId); short moduleId; isChange = true; dt = new cls_Module_Authority_Group().SelectByGId(Convert.ToInt32(Session["UserId"]), ConfigurationSettings.AppSettings["Emp_Module"], ConfigurationSettings.AppSettings["PermissionAuthority"], gId, out moduleId); List<cls_Module_Authority_Employee> list = getList(dt, moduleId); ViewState["DT_GAUTHORITY"] = dt; rptData1.DataSource = list; rptData1.DataBind(); } catch (Exception ex) { } }
private void bindRepeaterE(int empId) { try { //LAY DANH SACH CONG TY cls_Module_Authority_Employee aEmp = new cls_Module_Authority_Employee(); aEmp.EmployeeId = Convert.ToInt32(Session["UserId"]); DataTable dt = aEmp.GetCompanyByAuthorityCode(ConfigurationSettings.AppSettings["PermissionAuthority"]); ddlCompanySelect.DataSource = dt; ddlCompanySelect.DataBind(); ViewState["DT_COMPANY"] = dt; ViewState["DT_DEPARTMENT"] = new cls_DepartmentInformation().SelectList(0); bindCboEmployee(empId); short moduleId, isAdmin; dt = aEmp.SelectByEId(ConfigurationSettings.AppSettings["Emp_Module"], ConfigurationSettings.AppSettings["PermissionAuthority"], empId, out moduleId, out isAdmin); if (isAdmin > 0) btnESave.Enabled = isChange = false; else btnESave.Enabled = isChange = true; List<cls_Module_Authority_Employee> list = getList(dt, moduleId); ViewState["DT_EAUTHORITY"] = dt; rptData.DataSource = list; rptData.DataBind(); } catch (Exception ex) { } }