public Proposta()
{
IdProposta = -1;
Desejo = null;
Usuario = null;
DataProposta = DateTime.MinValue;
TipoProposta = null;
ValorProposta = -1;
NumMensagens = 0;
IsDeleted = 0;//para setar a busca inicialmente para considerar somente propostas não deletadas
}
}//populateMensagem()
private static TipoProposta populateTipoProposta(SqlDataReader dr)
{
TipoProposta tipoPropostaReturn = new TipoProposta();
tipoPropostaReturn.IdTipoProposta = System.Convert.ToInt16(dr["id_tipo_proposta"]);
tipoPropostaReturn.Descricao = System.Convert.ToString(dr["descricao_tipo_proposta"]);
short iTemp = System.Convert.ToInt16(dr["notificar"]);
if (iTemp == 0)
{
tipoPropostaReturn.Notificar = false;
}
else
{
tipoPropostaReturn.Notificar = true;
}
return tipoPropostaReturn;
}//populateTipoProposta()
}//queryMensagens()
public static ArrayList queryTipoProposta(TipoProposta tipoPropostaBusca, LIqueryParameters paramsBusca)
{
ArrayList alReturn = null;
SqlDataReader dr = null;
SqlConnection conn = null;
SqlCommand cmd = null;
bool bWhere = false;
int iTemp;
String strSql = "SELECT";
String strSelect = " T.*";
if (paramsBusca != null)
{
if (paramsBusca.Top > 0)
{
strSql += " TOP " + paramsBusca.Top.ToString() + strSelect;
}
else
{
strSql += strSelect;
}
}
else
{
strSql += strSelect;
}
strSql += " FROM TipoProposta T";
if (tipoPropostaBusca.Descricao != "")
{
if (bWhere)
{
strSql += " AND ";
}
else
{
strSql += " WHERE ";
bWhere = true;
}
strSql += "T.descricao_tipo_proposta = '" + tipoPropostaBusca.Descricao + "'";
}//if
if (tipoPropostaBusca.IdTipoProposta >= 0)
{
if (bWhere)
{
strSql += " AND ";
}
else
{
strSql += " WHERE ";
bWhere = true;
}
strSql += "T.id_tipo_proposta = " + tipoPropostaBusca.IdTipoProposta.ToString();
}//if
if (paramsBusca != null)
{
if (paramsBusca.OrderBy.Count != 0)
{
strSql += " ORDER BY ";
iTemp = 0;
foreach (ColumnOrder col in paramsBusca.OrderBy)
{
if (iTemp != 0) strSql += ",";
strSql += "T." + col.ColumnName;
if (col.Order == ColumnOrder.OrderType.ASC)
{
strSql += " ASC";
}
else
{
strSql += " DESC";
}
iTemp++;
}
}
}
try
{
conn = new SqlConnection(ConnString);
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = strSql;
dr = cmd.ExecuteReader();
alReturn = new ArrayList();
while (dr.Read())
{
alReturn.Add(populateTipoProposta(dr));
}//while
return alReturn;
}
catch
{
return new ArrayList();
}
finally
{
if (dr != null)
{
dr.Close();
}
if (conn != null)
{
conn.Close();
}
}
}//queryUsuario()
