private void Bind()
{
DataTable rs;
string strSql;
rs = Db.Rs("SELECT DISTINCT YEAR(TglKontrak), MONTH(TglKontrak) FROM MS_KONTRAK WHERE Project = '" + project.SelectedValue + "' AND CaraBayar='KPR'"
+ " ORDER BY YEAR(TglKontrak), MONTH(TglKontrak)");
for (int i = 0; i < rs.Rows.Count; i++)
{
thnKontrak.Items.Add(new ListItem(
Cf.MonthnameEnglish((int)rs.Rows[i][1]) + " " + rs.Rows[i][0].ToString()
, rs.Rows[i][0] + "," + rs.Rows[i][1]
));
}
thnKontrak.SelectedIndex = thnKontrak.Items.Count - 1;
strSql = "SELECT * FROM REF_JENIS WHERE Project = '" + project.SelectedValue + "' ORDER BY SN";
rs = Db.Rs(strSql);
for (int i = 0; i < rs.Rows.Count; i++)
{
string v = rs.Rows[i]["Jenis"].ToString();
string t = v + " - " + rs.Rows[i]["Nama"].ToString();
jenis.Items.Add(new ListItem(t, v));
}
strSql = "SELECT DISTINCT Lokasi FROM MS_KONTRAK WHERE Project = '" + project.SelectedValue + "' ORDER BY Lokasi";
rs = Db.Rs(strSql);
for (int i = 0; i < rs.Rows.Count; i++)
{
lokasi.Items.Add(new ListItem(rs.Rows[i][0].ToString()));
}
}
