protected void m_grid_RowCommand(object sender, GridViewCommandEventArgs e) { try { string commandName = e.CommandName; GridViewRow row = m_grid.FooterRow; if (commandName == "Insert") { cls_Groups objgroup = new cls_Groups(); string eName = ((TextBox)row.FindControl("txtIIndex")).Text; string eDetail = ((TextBox)row.FindControl("txtIEthnic")).Text; objgroup.GroupName = eName; objgroup.Detail = eDetail; objgroup.CreatedTime = DateTime.Now; objgroup.CompanyId = 0; int _result = objgroup.Insert(); if (_result >= 1) { ltlAnnouncement.Text = "Thêm mới nhóm người dùng '" + eName + "' thành công!"; } if (_result == -1) { ltlAnnouncement.Text = "nhóm người dùng '" + eName + "' đã tồn tại, bạn nên kiểm tra lại!"; } if (_result == 0) { ltlAnnouncement.Text = "Có lỗi trong quá trình thêm mới!"; } bindData(-1); } } catch (Exception ex) { ltlAnnouncement.Text = "Khong them moi duoc du lieu. Vui long lien he voi quan tri<br>" + ex.Message; } }
private void LoadDataGroupUser() { cls_Groups objGroup = new cls_Groups(); DataTable _dt = objGroup.GetData(); gridGroup.DataSource = _dt; gridGroup.DataBind(); if (gridGroup.Items.Count > 0) { gridGroup.Items[0].Selected = true; CheckAuThority(Convert.ToInt32(gridGroup.SelectedValue)); trFunction.ExpandAllNodes(); trFunction.Nodes[0].Selected = true; CheckDepartment(gridGroup.SelectedValue.ToString(), trFunction.SelectedValue.ToString()); } }
private void LoadGroupUser() { cls_Groups objGroup = new cls_Groups(); DataTable _dt = objGroup.GetData(); cboGroup.DataSource = _dt; cboGroup.DataValueField = "GroupID"; cboGroup.DataTextField = "GroupName"; cboGroup.DataBind(); if (cboGroup.Items.Count > 0) { cboGroup.Items[0].Selected = true; LoadListUser(cboGroup.SelectedValue); } }
private void LoadDataGroupUser() { cls_Groups objGroup = new cls_Groups(); DataTable _dt = objGroup.GetData( cboCompany.SelectedValue); gridGroup.DataSource = _dt; gridGroup.DataBind(); }
private void LoadGroupUser() { cls_Groups objGroup = new cls_Groups(); DataTable _dt = objGroup.GetData(); cboGroup.DataSource = _dt; cboGroup.DataValueField = "GroupID"; cboGroup.DataTextField = "GroupName"; cboGroup.DataBind(); if (cboGroup.Items.Count > 0) { cboGroup.SelectedIndex = 0; LoadUser(Convert.ToInt32(cboGroup.SelectedValue)); } }
protected void m_grid_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { int id = e.RowIndex; m_grid.EditIndex = id; int delId =Convert.ToInt32(m_grid.DataKeys[e.RowIndex].Value); if (delId != 0) { cls_Groups objgroup = new cls_Groups(); objgroup.GroupId = delId; int status_Delete = objgroup.Delete(); if (status_Delete == 1) { ltlAnnouncement.Text = "Xóa thành công nhóm người dùng!"; } if (status_Delete <= 0) { ltlAnnouncement.Text = "Không xóa được nhóm người dùng đã chọn."; } } } catch (Exception ex) { ltlAnnouncement.Text = "Lỗi trong quá trình xóa nhóm người dùng: " + ex.ToString(); } bindData(-1); }
private void bindData(int index) { try { //LAY DANH SACH CAC QUOC GIA RA cls_Groups objgroup = new cls_Groups(); dsGroup = objgroup.GetData(); objgroup.GroupId =0; m_grid.EditIndex = index; m_grid.DataSource = dsGroup; bool add = false; if (dsGroup.Rows.Count <= 0) { dsGroup.Rows.Add(dsGroup.NewRow()); add = true; } // m_grid.DataBind(); if(add) m_grid.Rows[0].Visible = false; 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]; LinkButton lbutton1 = (LinkButton)row.FindControl("cmdDelete"); if (lbutton1 != null) { lbutton1.Visible = D_Option; lbutton1.Attributes.Add("onclick", confirm); //lbutton1.Enabled = D_Option; } LinkButton lbutton2 = (LinkButton)row.FindControl("cmdEdit"); if (lbutton2 != null) lbutton2.Visible = U_Option; } } //XET QUYETN CHO CHUC NANG INSERT GridViewRow row1 = m_grid.FooterRow; if (row1 != null) { row1.Visible = I_Option; } } catch (Exception ex) { } }
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 eName = ((TextBox)row.FindControl("txtUIndex")).Text; string eDetail = ((TextBox)row.FindControl("txtUEthnic")).Text; short updateId = Int16.Parse(m_grid.DataKeys[id].Value.ToString()); if (updateId > 0) { cls_Groups objgroup = new cls_Groups(); objgroup.GroupId = updateId; objgroup.GroupName = eName; objgroup.Detail = eDetail; objgroup.CreatedTime = DateTime.Now; objgroup.CompanyId = 0; int _result = objgroup.Update(); if (_result == 1) { ltlAnnouncement.Text = "Sửa nhóm người dùng '" + eName + "' thành công!"; } if (_result < 0) { ltlAnnouncement.Text = "Có lỗi trong quá trình sửa dữ liệu!"; } } } catch (Exception ex) { ltlAnnouncement.Text = "Khong cap nhat duoc du lieu. Vui long lien he voi quan tri<br>" + ex.Message; } bindData(-1); }
private void LoadGroupUser() { DataTable _dt = new cls_Groups().SelectFollowCompanyByUserId(Convert.ToInt32(Session["UserId"])); cboGroup.DataSource = _dt; cboGroup.DataValueField = "GroupID"; cboGroup.DataTextField = "GroupName"; cboGroup.DataBind(); if (cboGroup.Items.Count > 0) { cboGroup.Items[0].Selected = true; LoadListUser(cboGroup.SelectedValue); } }
private void bindGroupList(int gId) { try { cls_Groups group = new cls_Groups(); group.CompanyId = Convert.ToInt16(ddlCompanySelect1.SelectedValue); DataTable dt = group.SelectByCompanyId(); if (gId > 0) { DataRow[] _row = dt.Select("GroupId=" + gId); if (_row.Count() > 0) { ddlCompanySelect1.SelectedValue = _row[0]["CompanyId"].ToString(); ddlGroup.DataSource = dt; ddlGroup.DataBind(); ddlGroup.SelectedValue = gId.ToString(); ddlCompanySelect1.Enabled = false; ddlGroup.Enabled = false; return; } } DataRow dtRow = dt.NewRow(); dtRow["GroupName"] = "-- Lựa chọn --"; dtRow["GroupId"] = "0"; dt.Rows.InsertAt(dtRow, 0); ddlGroup.DataSource = dt; ddlGroup.DataBind(); ddlGroup.SelectedValue = "0"; } catch (Exception ex) { } }
private void LoadGroupUser() { DataTable _dt = new cls_Groups().SelectFollowCompanyByUserId(Convert.ToInt32(Session["UserId"])); gridGroup.DataSource = _dt; gridGroup.DataBind(); }
private void LoadGroupUser() { cls_Groups objGroup = new cls_Groups(); DataTable _dt = objGroup.GetData(); gridGroup.DataSource = _dt; gridGroup.DataBind(); }