public static List <Vale_Historico> GetDebitosInterlojas(int cred_id, DateTime dataini, DateTime datafim)
{
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("cred_id", cred_id));
ps.Add(new Fields("dataini", dataini.ToString("dd/MM/yyyy") + " 00:00:00"));
ps.Add(new Fields("datafim", datafim.ToString("dd/MM/yyyy") + " 23:59:59"));
string sql = @"SELECT t.datahora AS databaixa, h.trans_id_baixa, tb.datahora AS datatrans, c.titular, h.debito
FROM Vale_Historico h
JOIN Transacoes t ON t.trans_id = h.trans_id
AND t.cred_id <> @cred_id
AND t.datahora BETWEEN @dataini AND @datafim
JOIN Transacoes tb ON tb.trans_id = h.trans_id_baixa
AND tb.cred_id = @cred_id
JOIN Conveniados c ON h.conv_id = c.conv_id
WHERE h.cancelado <> 'S'
AND h.debito > 0
ORDER BY t.datahora";
List <Vale_Historico> lista = new List <Vale_Historico>();
BD BD = new BD();
DataTable dt = BD.GetDataTable(sql, ps);
foreach (DataRow row in dt.Rows)
{
Vale_Historico v = new Vale_Historico();
v.Transacao.Datahora = Convert.ToDateTime(row["databaixa"]);
v.Trans_baixa.Trans_id = Convert.ToInt32(row["trans_id_baixa"]);
v.Trans_baixa.Datahora = Convert.ToDateTime(row["datatrans"]);
v.Transacao.Cartao.Conveniado.Titular = row["titular"].ToString();
v.Debito = float.Parse(row["debito"].ToString());
lista.Add(v);
}
return(lista);
}
public static List<Vale_Historico> GetDebitosInterlojas(int cred_id, DateTime dataini, DateTime datafim)
{
SqlParamsList ps = new SqlParamsList();
ps.Add(new Fields("cred_id", cred_id));
ps.Add(new Fields("dataini", dataini.ToString("dd/MM/yyyy") + " 00:00:00"));
ps.Add(new Fields("datafim", datafim.ToString("dd/MM/yyyy") + " 23:59:59"));
string sql = @"SELECT t.datahora AS databaixa, h.trans_id_baixa, tb.datahora AS datatrans, c.titular, h.debito
FROM Vale_Historico h
JOIN Transacoes t ON t.trans_id = h.trans_id
AND t.cred_id <> @cred_id
AND t.datahora BETWEEN @dataini AND @datafim
JOIN Transacoes tb ON tb.trans_id = h.trans_id_baixa
AND tb.cred_id = @cred_id
JOIN Conveniados c ON h.conv_id = c.conv_id
WHERE h.cancelado <> 'S'
AND h.debito > 0
ORDER BY t.datahora";
List<Vale_Historico> lista = new List<Vale_Historico>();
BD BD = new BD();
DataTable dt = BD.GetDataTable(sql, ps);
foreach (DataRow row in dt.Rows)
{
Vale_Historico v = new Vale_Historico();
v.Transacao.Datahora = Convert.ToDateTime(row["databaixa"]);
v.Trans_baixa.Trans_id = Convert.ToInt32(row["trans_id_baixa"]);
v.Trans_baixa.Datahora = Convert.ToDateTime(row["datatrans"]);
v.Transacao.Cartao.Conveniado.Titular = row["titular"].ToString();
v.Debito = float.Parse(row["debito"].ToString());
lista.Add(v);
}
return lista;
}
