private void btnObrisi_Click(object sender, EventArgs e)
{
string sifra_os = string.Empty;
string broj_os = string.Empty;
int index = UltraGrid1.ActiveRow.Index;
sifra_os = UltraGrid1.Rows[index].Cells[0].Value.ToString();
broj_os = UltraGrid1.Rows[index].Cells[2].Value.ToString();
Mipsed7.DataAccessLayer.SqlClient client = new Mipsed7.DataAccessLayer.SqlClient();
client.ExecuteNonQuery("Delete From OSTEMELJNICA Where IDOSDOKUMENT = '" + sifra_os + "' And OSBROJDOKUMENTA = '" + broj_os + "'");
client.CloseConnection();
UltraGrid1.DeleteSelectedRows();
}
private void GetObracunJOPPD()
{
string sqlQuery = "SELECT dbo.JOPPDA.ID AS JoppdaID, OznakaIzvjesca, (CAST(dbo.JOPPDAVrstaIzvjesca.Sifra as nvarchar(3)) + ' - ' + dbo.JOPPDAVrstaIzvjesca.Naziv) as VrstaIzvjesca, " +
"OznakaIzvjescaDatum, (SELECT COUNT(DISTINCT OIBStjecatelja) FROM dbo.JOPPDB WHERE dbo.JOPPDB.JOPPDAID = dbo.JOPPDA.ID) AS BrojOsoba, " +
"(SELECT COUNT(1) FROM dbo.JOPPDB WHERE dbo.JOPPDB.JOPPDAID = dbo.JOPPDA.ID) AS BrojRedaka " +
"FROM dbo.JOPPDA " +
"INNER JOIN dbo.JOPPDAVrstaIzvjesca ON dbo.JOPPDA.VrstaIzvjescaID = dbo.JOPPDAVrstaIzvjesca.ID " +
"ORDER BY OznakaIzvjescaDatum DESC, dbo.JOPPDAVrstaIzvjesca.Sifra DESC, dbo.JOPPDA.ID DESC";
Mipsed7.DataAccessLayer.SqlClient sqlClient = new Mipsed7.DataAccessLayer.SqlClient();
this.UltraGrid1.DataSource = sqlClient.GetDataTable(sqlQuery);
this.UltraGrid1.DataBind();
sqlClient.CloseConnection();
if (this.UltraGrid1.Rows.Count > 0)
{
this.UltraGrid1.ActiveRow = this.UltraGrid1.Rows[0];
}
}