private void DropDownKategori() { if (T8UserLoginInfo.HakAkses.ToLower().Contains(("Administrator").ToLower())) { dtKategori = TemplateQuery.GetTemplateAktif("kategori_surat"); } else { dtKategori = TemplateQuery.GetTemplateAktifKategori(T8UserLoginInfo.Username, "kategori_surat"); } for (int i = 0; i < dtKategori.Rows.Count; i++) { dropDownTipe.Items.Add(dtKategori.Rows[i][0].ToString()); } }
private void FrmHistoryEditSuratMasuk_Load(object sender, EventArgs e) { if (!T8UserLoginInfo.HakAkses.ToLower().Contains(("Administrator").ToLower())) { DataTable dt = new DataTable(); dt = TemplateQuery.GetTemplateAktifKategori(T8UserLoginInfo.Username, "kategori_surat"); string tmp = ""; for (int i = 0; i < dt.Rows.Count; i++) { if (tmp == "") { tmp = tmp + "'" + dt.Rows[i][0].ToString() + "'"; } else { tmp = tmp + ",'" + dt.Rows[i][0].ToString() + "'"; } } if (dt.Rows.Count != 0) { this.patent_filter = " where nomor_agenda in( select nomor_agenda from surat_masuk where kategori in(" + tmp + ")) "; } dt = new DataTable(); dt = TemplateQuery.GetTemplateAktifTKKeamanan(T8UserLoginInfo.Username, "tingkat_keamanan"); tmp = ""; for (int i = 0; i < dt.Rows.Count; i++) { if (tmp == "") { tmp = tmp + "'" + dt.Rows[i][0].ToString() + "'"; } else { tmp = tmp + ",'" + dt.Rows[i][0].ToString() + "'"; } } if (dt.Rows.Count != 0) { if (this.temp_filter != "") { this.patent_filter = this.patent_filter + " and nomor_agenda in( select nomor_agenda from surat_masuk where tk_keamanan in(" + tmp + ")) "; } else { this.patent_filter = " where nomor_agenda in( select nomor_agenda from surat_masuk where tk_keamanan in(" + tmp + ")) "; } } } else { this.patent_filter = ""; } this.filter = this.patent_filter; this.temp_filter = this.patent_filter; lblUsername.Text = T8UserLoginInfo.Username; GridHeaderGenerate(); if (GeneralSettings.OtomatisSimpanHistoriLocal) { radCheckBox1.Checked = LocalSettings.AutoSizeHistoryEditSuratMasuk; radCheckBox2.Checked = LocalSettings.AdministratorTableHistoryEditSuratMasuk; } this.page = 0; this.count_no_limit = 0; dropDownLimit.SelectedIndex = 0; }