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;
}