public static List <CL_Duprec> buscaReciboImprimir(List <CL_Duprec> objListDuprec, string con)
{
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
string sql = "SELECT dup_emis, dup_nota, dup_vcto, dup_vlpgto FROM duprec WHERE ";
CL_Duprec obj = null;
for (int x = 0; x < objListDuprec.Count; x++)
{
obj = new CL_Duprec();
obj = objListDuprec.ElementAt(x);
sql += "dup_cod=" + obj.dup_cod + " AND dup_parc=" + obj.dup_parc;
if (x < objListDuprec.Count - 1)
{
sql = " OR";
}
}
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn);
NpgsqlDataReader dr;
List <CL_Duprec> objList = new List <CL_Duprec>();
try
{
Conn.Open();
dr = comand.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
objList.Add(new CL_Duprec()
{
dup_nota = Convert.ToInt32(dr["dup_nota"]),
dup_emis = Convert.ToDateTime(dr["dup_emis"]),
dup_vcto = Convert.ToDateTime(dr["dup_vcto"]),
dup_vlpgto = Convert.ToDouble(dr["dup_vlpgto"]),
});
}
dr.Close();
return(objList);
}
else
{
return(objList);
}
}
catch (Exception ex)
{
ex.ToString();
return(null);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
public static bool excluiDuprec(CL_Duprec objDuprec, string email, string con)
{
if (objDuprec.dup_cod > 0 && objDuprec.dup_parc > 0)
{
return(DB_Duprec.excluiDuprec(objDuprec, email, con));
}
else
{
return(false);
}
}
public static bool cadDuprec(CL_Duprec objDuprec, string con)
{
if (objDuprec.dup_cod > 0 && objDuprec.dup_parc > 0)
{
return(DB_Duprec.cadDuprec(objDuprec, con));
}
else
{
return(false);
}
}
public static bool excluiDuprec(CL_Duprec objDuprec, string email, string con)
{
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
Conn.Open();
NpgsqlTransaction transaction = Conn.BeginTransaction();
try
{
string sql = "DELETE FROM duprec WHERE dup_cod=" + objDuprec.dup_cod + " and dup_parc= " + objDuprec.dup_parc;
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn, transaction);
comand.ExecuteScalar();
sql = "DELETE FROM movduprec where mr_duplic=" + objDuprec.dup_cod + " and mr_parc= " + objDuprec.dup_parc + " and mr_codcli= " + objDuprec.dup_codcli;
comand = new NpgsqlCommand(sql, Conn, transaction);
comand.ExecuteScalar();
sql = "INSERT INTO hist_usuario (h_usuario, h_tabela, h_hist1, h_hist2) VALUES (@email, 'duprec, movduprec', 'EXCLUSAO DO TITULO " + objDuprec.dup_cod + " - " + objDuprec.dup_parc + "', '')";
comand = new NpgsqlCommand(sql, Conn, transaction);
comand.Parameters.AddWithValue("email", email);
comand.ExecuteScalar();
transaction.Commit();
return(true);
}
catch (Exception ex)
{
ex.ToString();
transaction.Rollback();
return(false);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
public static bool cadDuprec(CL_Duprec objDuprec, string con)
{
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
Conn.Open();
NpgsqlTransaction transaction = Conn.BeginTransaction();
try
{
string sql = "INSERT INTO duprec (dup_cod, dup_parc, dup_codcli, dup_nome, dup_bco, dup_vend, dup_nomven, dup_comis, dup_emis, dup_vcto, " +
"dup_vlnota, dup_valor, dup_nota, dup_nrbco, dup_vcomis, dup_stit) VALUES (@dup_cod, @dup_parc, @dup_codcli, @dup_nome, @dup_bco, " +
"@dup_vend, @dup_nomven, @dup_comis, @dup_emis, @dup_vcto, @dup_vlnota, @dup_valor, @dup_nota, @dup_nrbco, @dup_vcomis, @dup_stit)";
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn, transaction);
comand.Parameters.AddWithValue("dup_cod", objDuprec.dup_cod);
comand.Parameters.AddWithValue("dup_parc", objDuprec.dup_parc);
comand.Parameters.AddWithValue("dup_codcli", objDuprec.dup_codcli);
comand.Parameters.AddWithValue("dup_nome", objDuprec.dup_nome);
comand.Parameters.AddWithValue("dup_bco", objDuprec.dup_bco);
comand.Parameters.AddWithValue("dup_vend", objDuprec.dup_vend);
comand.Parameters.AddWithValue("dup_nomven", objDuprec.dup_nomven);
comand.Parameters.AddWithValue("dup_comis", objDuprec.dup_comis);
comand.Parameters.AddWithValue("dup_emis", objDuprec.dup_emis);
comand.Parameters.AddWithValue("dup_vcto", objDuprec.dup_vcto);
comand.Parameters.AddWithValue("dup_vlnota", objDuprec.dup_vlnota);
comand.Parameters.AddWithValue("dup_valor", objDuprec.dup_valor);
comand.Parameters.AddWithValue("dup_nota", objDuprec.dup_nota);
comand.Parameters.AddWithValue("dup_nrbco", objDuprec.dup_nrbco);
comand.Parameters.AddWithValue("dup_vcomis", objDuprec.dup_vcomis);
comand.Parameters.AddWithValue("dup_stit", objDuprec.dup_stit);
comand.ExecuteScalar();
sql = "INSERT INTO movduprec (mr_duplic, mr_parc, mr_data, mr_tipo, mr_codcli, mr_cliente, mr_bco, mr_stit, mr_vend, mr_nomeven, mr_comis, " +
"mr_valor, mr_hist1, mr_acumul) VALUES (@mr_duplic, @mr_parc, @mr_data, @mr_tipo, @mr_codcli, @mr_cliente, @mr_bco, @mr_stit, @mr_vend, " +
"@mr_nomeven, @mr_comis, @mr_valor, @mr_hist1, @mr_acumul)";
comand = new NpgsqlCommand(sql, Conn, transaction);
comand.Parameters.AddWithValue("mr_duplic", objDuprec.dup_cod);
comand.Parameters.AddWithValue("mr_parc", objDuprec.dup_parc);
comand.Parameters.AddWithValue("mr_data", objDuprec.dup_emis);
comand.Parameters.AddWithValue("mr_tipo", 1);
comand.Parameters.AddWithValue("mr_codcli", objDuprec.dup_codcli);
comand.Parameters.AddWithValue("mr_cliente", objDuprec.dup_nome);
comand.Parameters.AddWithValue("mr_bco", objDuprec.dup_bco);
comand.Parameters.AddWithValue("mr_stit", objDuprec.dup_stit);
comand.Parameters.AddWithValue("mr_vend", objDuprec.dup_vend);
comand.Parameters.AddWithValue("mr_nomeven", objDuprec.dup_nomven);
comand.Parameters.AddWithValue("mr_comis", objDuprec.dup_comis);
comand.Parameters.AddWithValue("mr_valor", objDuprec.dup_valor);
comand.Parameters.AddWithValue("mr_hist1", "Valor do titulo");
comand.Parameters.AddWithValue("mr_acumul", "D");
comand.ExecuteScalar();
transaction.Commit();
return(true);
}
catch (Exception ex)
{
ex.ToString();
transaction.Rollback();
return(false);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
public static bool alteraDuprec(CL_Duprec objDuprec, string email, string con)
{
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn.Open();
NpgsqlTransaction transaction = Conn.BeginTransaction();
try
{
string sql = "UPDATE duprec SET dup_codcli=@dup_codcli, dup_nome=@dup_nome, dup_bco=@dup_bco, dup_vend=@dup_vend, dup_nomven=@dup_nomven," +
"dup_comis=@dup_comis, dup_emis=@dup_emis, dup_vcto=@dup_vcto, dup_vlnota=@dup_vlnota, dup_valor=@dup_valor, dup_nota=@dup_nota," +
"dup_nrbco=@dup_nrbco, dup_vcomis=@dup_vcomis, dup_stit=@dup_stit, dup_pgto=@dup_pgto WHERE dup_cod=@dup_cod and dup_parc=@dup_parc";
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn, transaction);
comand.Parameters.AddWithValue("dup_codcli", objDuprec.dup_codcli);
comand.Parameters.AddWithValue("dup_nome", objDuprec.dup_nome);
comand.Parameters.AddWithValue("dup_bco", objDuprec.dup_bco);
comand.Parameters.AddWithValue("dup_vend", objDuprec.dup_vend);
comand.Parameters.AddWithValue("dup_nomven", objDuprec.dup_nomven);
comand.Parameters.AddWithValue("dup_comis", objDuprec.dup_comis);
comand.Parameters.AddWithValue("dup_emis", objDuprec.dup_emis.ToShortDateString());
comand.Parameters.AddWithValue("dup_vcto", objDuprec.dup_vcto.ToShortDateString());
comand.Parameters.AddWithValue("dup_vlnota", objDuprec.dup_vlnota);
comand.Parameters.AddWithValue("dup_valor", objDuprec.dup_valor);
comand.Parameters.AddWithValue("dup_nota", objDuprec.dup_nota);
comand.Parameters.AddWithValue("dup_nrbco", objDuprec.dup_nrbco);
comand.Parameters.AddWithValue("dup_vcomis", objDuprec.dup_vcomis);
comand.Parameters.AddWithValue("dup_stit", objDuprec.dup_stit);
comand.Parameters.AddWithValue("dup_pgto", objDuprec.dup_pgto);
comand.Parameters.AddWithValue("dup_cod", objDuprec.dup_cod);
comand.Parameters.AddWithValue("dup_parc", objDuprec.dup_parc);
comand.ExecuteScalar();
sql = "UPDATE movduprec SET mr_data=@mr_data, mr_bco=@mr_bco, mr_stit=@mr_stit, mr_vend=@mr_vend, mr_nomeven=@mr_nomeven, " +
"mr_comis=@mr_comis, mr_valor=@mr_valor where mr_duplic=@mr_duplic and mr_parc=@mr_parc and mr_codcli=@mr_codcli and mr_tipo=1";
comand = new NpgsqlCommand(sql, Conn, transaction);
comand.Parameters.AddWithValue("mr_data", objDuprec.dup_emis);
comand.Parameters.AddWithValue("mr_bco", objDuprec.dup_bco);
comand.Parameters.AddWithValue("mr_stit", objDuprec.dup_stit);
comand.Parameters.AddWithValue("mr_vend", objDuprec.dup_vend);
comand.Parameters.AddWithValue("mr_nomeven", objDuprec.dup_nomven);
comand.Parameters.AddWithValue("mr_comis", objDuprec.dup_comis);
comand.Parameters.AddWithValue("mr_valor", objDuprec.dup_valor);
comand.Parameters.AddWithValue("mr_duplic", objDuprec.dup_cod);
comand.Parameters.AddWithValue("mr_parc", objDuprec.dup_parc);
comand.Parameters.AddWithValue("mr_codcli", objDuprec.dup_codcli);
comand.ExecuteScalar();
sql = "INSERT INTO hist_usuario (h_usuario, h_tabela, h_hist1, h_hist2) VALUES (@email, 'duprec, movduprec', 'ALTERACAO DO TITULO " + objDuprec.dup_cod + " - " + objDuprec.dup_parc + "', '')";
comand = new NpgsqlCommand(sql, Conn, transaction);
comand.Parameters.AddWithValue("email", email);
comand.ExecuteScalar();
transaction.Commit();
return(true);
}
catch (Exception ex)
{
ex.ToString();
transaction.Rollback();
return(false);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
public static CL_Duprec buscaTitulo(int dupcod, int dupparc, string con)
{
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
CL_Duprec objDuprec = new CL_Duprec();
string sql = "SELECT * FROM duprec WHERE dup_cod=@dup_cod AND dup_parc=@dup_parc";
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn);
comand.Parameters.AddWithValue("dup_cod", dupcod);
comand.Parameters.AddWithValue("dup_parc", dupparc);
NpgsqlDataReader dr;
try
{
Conn.Open();
dr = comand.ExecuteReader();
if (dr.HasRows)
{
if (dr.Read())
{
objDuprec.dup_cod = dupcod;
objDuprec.dup_parc = dupparc;
objDuprec.dup_codcli = dr["dup_codcli"] is DBNull ? 0 : Convert.ToInt32(dr["dup_codcli"]);
objDuprec.dup_nome = dr["dup_nome"].ToString().Trim();
objDuprec.dup_bco = dr["dup_bco"] is DBNull ? 0 : Convert.ToInt32(dr["dup_bco"]);
objDuprec.dup_vend = dr["dup_vend"] is DBNull ? 0 : Convert.ToInt32(dr["dup_vend"]);
objDuprec.dup_nomven = dr["dup_nomven"].ToString().Trim();
objDuprec.dup_comis = dr["dup_comis"] is DBNull ? 0 : Convert.ToDouble(dr["dup_comis"]);
objDuprec.dup_emis = Convert.ToDateTime(dr["dup_emis"]);
objDuprec.dup_vcto = Convert.ToDateTime(dr["dup_vcto"]);
objDuprec.dup_vlnota = dr["dup_vlnota"] is DBNull ? 0 : Convert.ToDouble(dr["dup_vlnota"]);
objDuprec.dup_valor = dr["dup_valor"] is DBNull ? 0 : Convert.ToDouble(dr["dup_valor"]);
objDuprec.dup_nota = dr["dup_nota"] is DBNull ? 0 : Convert.ToInt32(dr["dup_nota"]);
objDuprec.dup_nrbco = dr["dup_nrbco"].ToString().Trim();
objDuprec.dup_vcomis = dr["dup_vcomis"] is DBNull ? 0 : Convert.ToDouble(dr["dup_vcomis"]);
objDuprec.dup_stit = dr["dup_stit"] is DBNull ? 0 : Convert.ToInt32(dr["dup_stit"]);
return(objDuprec);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
catch (Exception ex)
{
ex.ToString();
return(null);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
public static CL_Duprec buscaTituloTotMov(int dupcod, int dupparc, string con)
{
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
string sql = "SELECT dup_cod, dup_parc, dup_nome, dup_nota, dup_bco, bco_nome, dup_vend, con_nome, dup_comis, dup_emis, dup_vcto, dup_valor, dup_vlnota, dup_nrbco, dup_stit, s_descri " +
"FROM duprec LEFT JOIN bancos ON dup_bco = bco_cod " +
"LEFT JOIN convenio ON dup_vend = con_cod " +
"JOIN sittitulo ON dup_stit = s_codigo " +
"WHERE dup_cod = @dupcod AND dup_parc = @dupparc";
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn);
comand.Parameters.AddWithValue("dupcod", dupcod);
comand.Parameters.AddWithValue("dupparc", dupparc);
NpgsqlDataReader dr;
CL_Duprec obj = new CL_Duprec();
try
{
Conn.Open();
dr = comand.ExecuteReader();
if (dr.HasRows)
{
if (dr.Read())
{
obj.dup_cod = dupcod;
obj.dup_parc = dupparc;
obj.dup_nota = Convert.ToInt32(dr["dup_nota"]);
obj.dup_emis = Convert.ToDateTime(dr["dup_emis"]);
obj.dup_vcto = Convert.ToDateTime(dr["dup_vcto"]);
obj.dup_valor = Convert.ToDouble(dr["dup_valor"]);
obj.dup_nome = dr["dup_nome"].ToString().Trim();
obj.dup_bco = Convert.ToInt32(dr["dup_bco"]);
obj.dup_banco = dr["bco_nome"].ToString().Trim();
obj.dup_vend = Convert.ToInt32(dr["dup_vend"]);
obj.dup_vendnome = dr["con_nome"].ToString().Trim();
obj.dup_comis = Convert.ToDouble(dr["dup_comis"]);
obj.dup_vlnota = Convert.ToDouble(dr["dup_vlnota"]);
obj.dup_nrbco = dr["dup_nrbco"].ToString().Trim();
obj.dup_stit = Convert.ToInt32(dr["dup_stit"]);
obj.dup_situac = dr["s_descri"].ToString().Trim();
return(obj);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
catch (Exception ex)
{
ex.ToString();
return(null);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
public static bool recebeTotalMov(CL_Duprec objDuprec, CL_Movduprec objMovDuprec, CL_Movduprec objMovDupJuros, CL_ReciboDupl objRecibo, string con)
{
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
Conn.Open();
NpgsqlTransaction transaction = Conn.BeginTransaction();
try
{
string sql = "UPDATE duprec SET dup_juros=dup_juros + @dup_juros, dup_vlpgto=dup_vlpgto + @dup_vlpgto, dup_vlrrec=dup_vlrrec + @dup_vlrrec, " +
"dup_pgto=@dup_pgto, dup_hist=@dup_hist, dup_hist1=@dup_hist1, dup_hist4=@dup_hist2, dup_hist5=@dup_hist3, dup_usupgt=@dup_usuario, dup_sit='S', dup_diapgt=@dup_diapgto " +
"WHERE dup_cod=@dup_cod AND dup_parc=@dup_parc";
NpgsqlCommand cmd = new NpgsqlCommand(sql, Conn, transaction);
cmd.Parameters.AddWithValue("dup_juros", objDuprec.dup_juros);
cmd.Parameters.AddWithValue("dup_vlpgto", objDuprec.dup_vlpgto);
cmd.Parameters.AddWithValue("dup_vlrrec", objDuprec.dup_vlrrec);
cmd.Parameters.AddWithValue("dup_pgto", objDuprec.dup_pgto);
cmd.Parameters.AddWithValue("dup_hist", objDuprec.dup_hist);
cmd.Parameters.AddWithValue("dup_hist1", objDuprec.dup_hist1);
cmd.Parameters.AddWithValue("dup_hist2", objDuprec.dup_hist4);
cmd.Parameters.AddWithValue("dup_hist3", objDuprec.dup_hist5);
cmd.Parameters.AddWithValue("dup_usuario", objDuprec.dup_usudac);
cmd.Parameters.AddWithValue("dup_diapgto", objDuprec.dup_diapgt.ToShortDateString());
cmd.Parameters.AddWithValue("dup_cod", objDuprec.dup_cod);
cmd.Parameters.AddWithValue("dup_parc", objDuprec.dup_parc);
cmd.ExecuteScalar();
sql = "INSERT INTO movduprec (mr_duplic, mr_parc, mr_data, mr_tipo, mr_codcli, mr_cliente, mr_bco, mr_stit, mr_vend, mr_nomeven, mr_comis, " +
"mr_valor, mr_hist1, mr_acumul, mr_hist, mr_hist2, mr_hist3, mr_usudac, mr_movdig) VALUES (@mr_duplic, @mr_parc, @mr_data, @mr_tipo, @mr_codcli, @mr_cliente, @mr_bco, @mr_stit, @mr_vend, " +
"@mr_nomeven, @mr_comis, @mr_valor, @mr_hist1, @mr_acumul, @mr_hist, @mr_hist2, @mr_hist3, @mr_usudac, @mr_movdig)";
cmd = new NpgsqlCommand(sql, Conn, transaction);
cmd.Parameters.AddWithValue("mr_duplic", objMovDuprec.mr_duplic);
cmd.Parameters.AddWithValue("mr_parc", objMovDuprec.mr_parc);
cmd.Parameters.AddWithValue("mr_data", objMovDuprec.mr_data.ToShortDateString());
cmd.Parameters.AddWithValue("mr_tipo", objMovDuprec.mr_tipo);
cmd.Parameters.AddWithValue("mr_codcli", objMovDuprec.mr_codcli);
cmd.Parameters.AddWithValue("mr_cliente", objMovDuprec.mr_cliente);
cmd.Parameters.AddWithValue("mr_bco", objMovDuprec.mr_bco);
cmd.Parameters.AddWithValue("mr_stit", objMovDuprec.mr_stit);
cmd.Parameters.AddWithValue("mr_vend", objMovDuprec.mr_vend);
cmd.Parameters.AddWithValue("mr_nomeven", objMovDuprec.mr_nomeven);
cmd.Parameters.AddWithValue("mr_comis", objMovDuprec.mr_comis);
cmd.Parameters.AddWithValue("mr_valor", objMovDuprec.mr_valor);
cmd.Parameters.AddWithValue("mr_hist1", objMovDuprec.mr_hist1);
cmd.Parameters.AddWithValue("mr_acumul", objMovDuprec.mr_acumul);
cmd.Parameters.AddWithValue("mr_hist", objMovDuprec.mr_hist);
cmd.Parameters.AddWithValue("mr_hist2", objMovDuprec.mr_hist2);
cmd.Parameters.AddWithValue("mr_hist3", objMovDuprec.mr_hist3);
cmd.Parameters.AddWithValue("mr_usudac", objMovDuprec.mr_usudac);
cmd.Parameters.AddWithValue("mr_movdig", objMovDuprec.mr_movdig.ToShortDateString());
cmd.ExecuteScalar();
sql = "INSERT INTO recibo_dupl (r_data, r_titulo, r_parc, r_cliente, r_vlrtot, r_vlrtit, r_vlrjur, r_vlrdesc, r_hist1, r_hist2, r_hist3) " +
"VALUES (@r_data, @r_titulo, @r_parc, @r_cliente, @r_vlrtot, @r_vlrtit, @r_vlrjur, @r_vlrdesc, @r_hist1, @r_hist2, @r_hist3)";
cmd = new NpgsqlCommand(sql, Conn, transaction);
cmd.Parameters.AddWithValue("r_data", objRecibo.r_data);
cmd.Parameters.AddWithValue("r_titulo", objRecibo.r_titulo);
cmd.Parameters.AddWithValue("r_parc", objRecibo.r_parc);
cmd.Parameters.AddWithValue("r_cliente", objRecibo.r_cliente);
cmd.Parameters.AddWithValue("r_vlrtot", objRecibo.r_vlrtot);
cmd.Parameters.AddWithValue("r_vlrtit", objRecibo.r_vlrtit);
cmd.Parameters.AddWithValue("r_vlrjur", objRecibo.r_vlrjur);
cmd.Parameters.AddWithValue("r_vlrdesc", objRecibo.r_vlrdesc);
cmd.Parameters.AddWithValue("r_hist1", objRecibo.r_hist1);
cmd.Parameters.AddWithValue("r_hist2", objRecibo.r_hist2);
cmd.Parameters.AddWithValue("r_hist3", objRecibo.r_hist3);
cmd.ExecuteScalar();
if (objMovDupJuros != null)
{
sql = "INSERT INTO movduprec (mr_duplic, mr_parc, mr_data, mr_tipo, mr_codcli, mr_cliente, mr_bco, mr_stit, mr_vend, mr_nomeven, mr_comis, " +
"mr_valor, mr_hist1, mr_acumul, mr_hist, mr_hist2, mr_hist3, mr_usudac, mr_movdig) VALUES (@mr_duplic, @mr_parc, @mr_data, @mr_tipo, @mr_codcli, @mr_cliente, @mr_bco, @mr_stit, @mr_vend, " +
"@mr_nomeven, @mr_comis, @mr_valor, @mr_hist1, @mr_acumul, @mr_hist, @mr_hist2, @mr_hist3, @mr_usudac, @mr_movdig)";
cmd = new NpgsqlCommand(sql, Conn, transaction);
cmd.Parameters.AddWithValue("mr_duplic", objMovDupJuros.mr_duplic);
cmd.Parameters.AddWithValue("mr_parc", objMovDupJuros.mr_parc);
cmd.Parameters.AddWithValue("mr_data", objMovDupJuros.mr_data.ToShortDateString());
cmd.Parameters.AddWithValue("mr_codcli", objMovDupJuros.mr_codcli);
cmd.Parameters.AddWithValue("mr_cliente", objMovDupJuros.mr_cliente);
cmd.Parameters.AddWithValue("mr_bco", objMovDupJuros.mr_bco);
cmd.Parameters.AddWithValue("mr_stit", objMovDupJuros.mr_stit);
cmd.Parameters.AddWithValue("mr_vend", objMovDupJuros.mr_vend);
cmd.Parameters.AddWithValue("mr_nomeven", objMovDupJuros.mr_nomeven);
cmd.Parameters.AddWithValue("mr_comis", objMovDupJuros.mr_comis);
cmd.Parameters.AddWithValue("mr_valor", objDuprec.dup_juros);
cmd.Parameters.AddWithValue("mr_hist", objMovDupJuros.mr_hist);
cmd.Parameters.AddWithValue("mr_hist1", objMovDupJuros.mr_hist1);
cmd.Parameters.AddWithValue("mr_hist2", objMovDupJuros.mr_hist2);
cmd.Parameters.AddWithValue("mr_hist3", objMovDupJuros.mr_hist3);
cmd.Parameters.AddWithValue("mr_usudac", objMovDupJuros.mr_usudac);
cmd.Parameters.AddWithValue("mr_movdig", objMovDupJuros.mr_movdig.ToShortDateString());
if (objDuprec.dup_juros > 0)
{
cmd.Parameters.AddWithValue("mr_tipo", 4);
cmd.Parameters.AddWithValue("mr_acumul", "C");
}
else if (objDuprec.dup_juros < 0)
{
cmd.Parameters.AddWithValue("mr_tipo", 5);
cmd.Parameters.AddWithValue("mr_acumul", "D");
}
cmd.ExecuteScalar();
}
transaction.Commit();
return(true);
}
catch (Exception ex)
{
ex.ToString();
transaction.Rollback();
return(false);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}