private void BindData() { DatGrd.DataSource = conn.GetDataTable(Q_GROUP + " " + SQLCondition(), null, dbtimeout); try { DatGrd.DataBind(); } catch { DatGrd.CurrentPageIndex = 0; DatGrd.DataBind(); } LinkButton lnk; for (int i = 0; i < DatGrd.Items.Count; i++) { if (DatGrd.Items[i].Cells[6].Text == "0") //sg_active -- group deleted { lnk = (LinkButton)DatGrd.Items[i].Cells[7].FindControl("lnk_menu"); lnk.Visible = false; lnk = (LinkButton)DatGrd.Items[i].Cells[7].FindControl("lnk_delete"); lnk.Visible = false; lnk = (LinkButton)DatGrd.Items[i].Cells[7].FindControl("lnk_edit"); lnk.Visible = false; DatGrd.Items[i].Cells[0].ForeColor = Color.Gray; DatGrd.Items[i].Cells[1].ForeColor = Color.Gray; DatGrd.Items[i].Cells[2].ForeColor = Color.Gray; DatGrd.Items[i].Cells[3].ForeColor = Color.Gray; DatGrd.Items[i].Cells[4].ForeColor = Color.Gray; DatGrd.Items[i].Cells[5].ForeColor = Color.Gray; } } }
private void BindData() { DatGrd.DataSource = conn.GetDataTable(Q_MODULEUSER + " " + SQLCondition(), null, dbtimeout); try { DatGrd.DataBind(); } catch { DatGrd.CurrentPageIndex = 0; DatGrd.DataBind(); } LinkButton lnk; for (int i = 0; i < DatGrd.Items.Count; i++) { if (DatGrd.Items[i].Cells[10].Text == "0") //su_active -- user deleted { lnk = (LinkButton)DatGrd.Items[i].Cells[11].FindControl("lnkDelete"); lnk.Visible = false; lnk = (LinkButton)DatGrd.Items[i].Cells[11].FindControl("lnkEdit"); lnk.Visible = false; DatGrd.Items[i].Cells[2].ForeColor = Color.Gray; //userid DatGrd.Items[i].Cells[3].ForeColor = Color.Gray; //fullname } else if (DatGrd.Items[i].Cells[12].Text == "1") { lnk = (LinkButton)DatGrd.Items[i].Cells[11].FindControl("lnkEdit"); lnk.Visible = false; lnk = (LinkButton)DatGrd.Items[i].Cells[11].FindControl("lnkDelete"); lnk.Visible = false; lnk = (LinkButton)DatGrd.Items[i].Cells[11].FindControl("lnkUndelete"); lnk.Visible = false; DatGrd.Items[i].Cells[11].Text = "Waiting Approval!"; } else { lnk = (LinkButton)DatGrd.Items[i].Cells[11].FindControl("lnkUndelete"); lnk.Visible = false; } } }
protected void Page_Load(object sender, EventArgs e) { dbtimeout = int.Parse(ConfigurationSettings.AppSettings["dbTimeOut"]); ConnString = Session["ConnStringLogin"].ToString(); if (!IsPostBack) { string user = (string)Session["UserID"]; conn = new DbConnection(ConnString); uREF_BRANCH.fillRefList(Q_RFBRANCH, true); uREF_BRANCHID.fillRefList(Q_RFBRANCH, true); uREF_AREAID.fillRefList(Q_RFAREA, true); MyPage.fillRefList(DDL_RFMODULE, Q_RFMODULE + " and moduleid in (" + MaintainedModuleIDs + ")", null, dbtimeout, false, conn); ArrayList arrddl = new ArrayList(); arrddl.Add(DDL_RFGROUP); arrddl.Add(DDL_GROUPID); string cond = " where moduleid in (" + MaintainedModuleIDs + ") "; MyPage.fillRefList(arrddl, Q_MODULEGROUPDDL + cond, null, dbtimeout, false, conn); orderby = ""; ViewState["orderby"] = orderby; // dummy query to show the grid DatGrd.DataSource = conn.GetDataTable(Q_MODULEUSER + " WHERE 1 = 2 ", null, dbtimeout); try { DatGrd.DataBind(); } catch { } ClearEntries(); conn.Dispose(); } else { orderby = (string)ViewState["orderby"]; } BTN_SAVE.Attributes.Add("onclick", "if(!cek_mandatory(document.form1)){return false;} else {simpan();};"); //BTN_SAVE.Attributes.Add("onclick", "simpan();"); }