public string GetAssuntoByNome(string assunto) { string assuntoID = ""; var conn = Persist.GetConn.getConn(); using (conn) { conn.Open(); string sql = "Select ID from WebAssunto where descricao = '" + assunto + "'"; var cmd = new FirebirdSql.Data.FirebirdClient.FbCommand(sql, conn); assuntoID = cmd.ExecuteScalar().ToString(); } return assuntoID; }
public bool ehFinalDeFluxo(string idSituacao) { bool retorno = false; string sql = "SELECT FIMFLUXO FROM WEBSITUACAOPROCESSO WHERE ID =" + idSituacao; var conn = Persist.GetConn.getConn(); using (conn) { conn.Open(); var cmd = new FirebirdSql.Data.FirebirdClient.FbCommand(sql, conn); if (!string.IsNullOrEmpty(cmd.ExecuteScalar().ToString())) { retorno = true; } } return retorno; }
public bool AssuntoTemFluxo(string assuntoID) { int ordenacao = 0; var conn = Persist.GetConn.getConn(); using (conn) { conn.Open(); string sql = "Select coalesce(exigeordenacao,0) from webassunto where id = " + assuntoID; var cmd = new FirebirdSql.Data.FirebirdClient.FbCommand(sql, conn); ordenacao = (int)cmd.ExecuteScalar(); } if (ordenacao == 1) { return true; } else { return false; } }
protected void ASPxGridView1_CustomColumnDisplayText1(object sender, ASPxGridViewColumnDisplayTextEventArgs e) { if (e.Column.FieldName == "NUMERO") { e.DisplayText = String.Format(@"{0:#\.0000}", Convert.ToInt64(e.Value)); } if (e.Column.FieldName == "CCCMESES") { var conn = Persist.GetConn.getConn(); using (conn) { conn.Open(); var query = "select cccdescricao from webcentrocustocontrole where cccmeses = " + e.Value; var cmd = new FirebirdSql.Data.FirebirdClient.FbCommand(query, conn); e.DisplayText = cmd.ExecuteScalar().ToString(); } } }