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