public void BuscaVenctoCancelado(string nfseq, string cdnotafis, string cd_nfse = "")
{
bool bExistCampo = HlpDbFuncoes.fExisteCampo("TP_DUPCANC", "EMPRESA");
if (bExistCampo)
{
string sTP_DUPCANC = HlpDbFuncoes.qrySeekValue("EMPRESA", "COALESCE(TP_DUPCANC,'P')", string.Format("CD_EMPRESA = '{0}'", Acesso.CD_EMPRESA));
if (sTP_DUPCANC.Equals("N"))
{
string ssGravarCdDupli = HlpDbFuncoes.qrySeekValue("control", "control.cd_conteud", "cd_nivel = '1355'");
string ssGravardteminf = HlpDbFuncoes.qrySeekValue("control", "control.cd_conteud", "cd_nivel = '1363'");
if (ssGravarCdDupli == "S")
{
//List<string> lPedidos = new List<string>();
//string sQuery = string.Format("select distinct m.cd_pedido from movitem m where m.cd_nfseq = '{0}' and m.cd_empresa = '{1}'", nfseq, Acesso.CD_EMPRESA);
//DataTable drPedidos = HlpDbFuncoes.qrySeekRet(sQuery);
//foreach (DataRow item in drPedidos.Rows)
//{
// lPedidos.Add(item["cd_pedido"].ToString());
//}
//if (lPedidos.Count > 0)
//{
//foreach (string CD_PEDIDO in lPedidos)
//{
StringBuilder sSqlDup = new StringBuilder();
//Campos do Select
sSqlDup.Append("Select ");
sSqlDup.Append("doc_ctr.nr_doc, ");
sSqlDup.Append("doc_ctr.cd_documento, ");
sSqlDup.Append("doc_ctr.cd_dupli, ");
sSqlDup.Append("'S' Nota ");
//Tabela
sSqlDup.Append("From Doc_ctr ");
//Where
sSqlDup.Append("Where ");
sSqlDup.Append("(doc_ctr.cd_empresa ='");
sSqlDup.Append(Acesso.CD_EMPRESA);
sSqlDup.Append("') ");
sSqlDup.Append("and ");
sSqlDup.Append("(doc_ctr.cd_nfseq_conversao = '");
sSqlDup.Append(nfseq);
sSqlDup.Append("') ");
#region MASTERFEW
if (Acesso.NM_EMPRESA == "MASTERFEW")
{
StringBuilder sPedseq = new StringBuilder();
sPedseq.Append("Select ");
sPedseq.Append("pedseq.cd_pedido, ");
sPedseq.Append("pedseq.cd_seqped ");
sPedseq.Append("from pedseq ");
sPedseq.Append("where ");
sPedseq.Append("(pedseq.cd_empresa = '");
sPedseq.Append(Acesso.CD_EMPRESA);
sPedseq.Append("') ");
sPedseq.Append("and ");
sPedseq.Append("(pedseq.cd_nfseq = '");
sPedseq.Append(nfseq);
sPedseq.Append("') ");
DataTable drPedseq = HlpDbFuncoes.qrySeekRet(sPedseq.ToString());
int iSeq = Convert.ToInt16(drPedseq.Rows[0]["cd_seqped"].ToString());
iSeq++;
//União
sSqlDup.Append("Union ");
//Campos do Select
sSqlDup.Append("Select ");
sSqlDup.Append("doc_ctr.nr_doc, ");
sSqlDup.Append("doc_ctr.cd_documento, ");
sSqlDup.Append("doc_ctr.cd_dupli, ");
sSqlDup.Append("'N' Nota ");
//Tabela
sSqlDup.Append("From Doc_ctr ");
//Where
sSqlDup.Append("Where ");
sSqlDup.Append("(doc_ctr.cd_empresa ='");
sSqlDup.Append(Acesso.CD_EMPRESA);
sSqlDup.Append("') ");
sSqlDup.Append("and ");
sSqlDup.Append("(doc_ctr.CD_PEDIDO = '");
sSqlDup.Append(drPedseq.Rows[0]["cd_pedido"].ToString());
sSqlDup.Append("') ");
sSqlDup.Append("and ");
sSqlDup.Append("(doc_ctr.CD_SEQPED = '");
sSqlDup.Append(iSeq.ToString().PadLeft(2, '0'));
sSqlDup.Append("') ");
}
#endregion
sSqlDup.Append("order by 1 ");
DataTable dtEmit = HlpDbFuncoes.qrySeekRet(sSqlDup.ToString());
int iParcela = 0;
int iSemNota = 0;
List<NotasDuplicatas> objListNfs = new List<NotasDuplicatas>();
NotasDuplicatas objNFs = new NotasDuplicatas();
string sNumGerador = (cd_nfse != "" ? cd_nfse : cdnotafis).Trim();
foreach (DataRow drEmit in dtEmit.Rows)
{
objNFs = new NotasDuplicatas();
if (!(Acesso.NM_EMPRESA.Equals("LORENZON")))
{
if (drEmit["NOTA"].ToString() == "S")
{
iParcela++;
objNFs.sNF = string.Format("{0}-{1}",
sNumGerador,
iParcela + 10);
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
else
{
iSemNota++;
objNFs.sNF = string.Format("{0}/{1}",
Convert.ToInt64(sNumGerador).ToString().PadLeft(5, '0'),
iSemNota.ToString().Trim());
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
objListNfs.Add(objNFs);
}
else
{
if (drEmit["cd_dupli"].ToString().Contains("/NUM"))
{
if (drEmit["NOTA"].ToString() == "S")
{
iParcela++;
objNFs.sNF = string.Format("{0}-{1}",
cdnotafis.Trim(),
iParcela);
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
else
{
iSemNota++;
objNFs.sNF = string.Format("{0}/{1}",
Convert.ToInt64(cdnotafis).ToString().PadLeft(5, '0'),
iSemNota.ToString().Trim());
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
objListNfs.Add(objNFs);
}
}
}
if (objListNfs.Count == 1)
{
objNFs = objListNfs[0];
objNFs.sNF = objListNfs[0].sNF.Replace("A", "").PadLeft(7, '0'); //Claudinei - o.s. 24103 - 05/02/2010
objListNfs = new List<NotasDuplicatas>();
objListNfs.Add(objNFs);
}
for (int i = 0; i < objListNfs.Count; i++)
{
StringBuilder sSql = new StringBuilder();
string sNumDup = "";
if (objListNfs[i].sNF.Count() > 7)
sNumDup = objListNfs[i].sNF.Substring((objListNfs[i].sNF.Count() - 7), 7);
else
sNumDup = objListNfs[i].sNF.PadLeft(7, '0');
sSql.Append("update ");
sSql.Append("doc_ctr ");
sSql.Append("set cd_dupli = '");
sSql.Append(sNumDup);
sSql.Append("' Where ");
sSql.Append("(cd_empresa = '");
sSql.Append(Acesso.CD_EMPRESA);
sSql.Append("')");
sSql.Append(" and ");
sSql.Append("(nr_doc = '");
sSql.Append(objListNfs[i].sNrDoc);
sSql.Append("')");
HlpDbFuncoes.qrySeekUpdate(sSql.ToString());
}
//}
//}
}
}
}
}
public void BuscaVencto(string nfseq, string cdnotafis, string cd_nfse = "")
{
string ssGravarCdDupli = HlpDbFuncoes.qrySeekValue("control", "control.cd_conteud", "cd_nivel = '1355'");
string ssGravardteminf = HlpDbFuncoes.qrySeekValue("control", "control.cd_conteud", "cd_nivel = '1363'");
if (ssGravarCdDupli == "S")
{
StringBuilder sSqlDup = new StringBuilder();
//Campos do Select
sSqlDup.Append("Select ");
sSqlDup.Append("doc_ctr.nr_doc, ");
sSqlDup.Append("doc_ctr.cd_documento, ");
sSqlDup.Append("doc_ctr.cd_dupli, doc_ctr.cd_seqped, ");
sSqlDup.Append("'S' Nota ");
//Tabela
sSqlDup.Append("From Doc_ctr ");
//Where
sSqlDup.Append("Where ");
sSqlDup.Append("(doc_ctr.cd_empresa ='");
sSqlDup.Append(Acesso.CD_EMPRESA);
sSqlDup.Append("') ");
sSqlDup.Append("and ");
sSqlDup.Append("(doc_ctr.cd_nfseq = '");
sSqlDup.Append(nfseq);
sSqlDup.Append("') ");
#region MASTERFEW
if (Acesso.NM_EMPRESA == "MASTERFEW")
{
StringBuilder sPedseq = new StringBuilder();
sPedseq.Append("Select ");
sPedseq.Append("pedseq.cd_pedido, ");
sPedseq.Append("pedseq.cd_seqped ");
sPedseq.Append("from pedseq ");
sPedseq.Append("where ");
sPedseq.Append("(pedseq.cd_empresa = '");
sPedseq.Append(Acesso.CD_EMPRESA);
sPedseq.Append("') ");
sPedseq.Append("and ");
sPedseq.Append("(pedseq.cd_nfseq = '");
sPedseq.Append(nfseq);
sPedseq.Append("') ");
DataTable drPedseq = HlpDbFuncoes.qrySeekRet(sPedseq.ToString());
if (drPedseq.Rows.Count > 0)
{
int iSeq = Convert.ToInt16(drPedseq.Rows[0]["cd_seqped"].ToString());
iSeq++;
//União
sSqlDup.Append("Union ");
//Campos do Select
sSqlDup.Append("Select ");
sSqlDup.Append("doc_ctr.nr_doc, ");
sSqlDup.Append("doc_ctr.cd_documento, ");
sSqlDup.Append("doc_ctr.cd_dupli, ");
sSqlDup.Append("'N' Nota ");
//Tabela
sSqlDup.Append("From Doc_ctr ");
//Where
sSqlDup.Append("Where ");
sSqlDup.Append("(doc_ctr.cd_empresa ='");
sSqlDup.Append(Acesso.CD_EMPRESA);
sSqlDup.Append("') ");
sSqlDup.Append("and ");
sSqlDup.Append("(doc_ctr.CD_PEDIDO = '");
sSqlDup.Append(drPedseq.Rows[0]["cd_pedido"].ToString());
sSqlDup.Append("') ");
sSqlDup.Append("and ");
sSqlDup.Append("(doc_ctr.CD_SEQPED = '");
sSqlDup.Append(iSeq.ToString().PadLeft(2, '0'));
sSqlDup.Append("') ");
}
}
#endregion
sSqlDup.Append("order by 1 ");
DataTable dtEmit = HlpDbFuncoes.qrySeekRet(sSqlDup.ToString());
int iParcela = 0;
int iSemNota = 0;
List<NotasDuplicatas> objListNfs = new List<NotasDuplicatas>();
NotasDuplicatas objNFs = new NotasDuplicatas();
string sNumGerador = (cd_nfse != "" ? cd_nfse : cdnotafis).Trim();
foreach (DataRow drEmit in dtEmit.Rows)
{
objNFs = new NotasDuplicatas();
if (!(Acesso.NM_EMPRESA.Equals("LORENZON")))
{
if (drEmit["NOTA"].ToString() == "S")
{
iParcela++;
objNFs.sNF = string.Format("{0}-{1}",
sNumGerador,
iParcela);
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
else
{
iSemNota++;
objNFs.sNF = string.Format("{0}/{1}",
Convert.ToInt64(sNumGerador).ToString().PadLeft(5, '0'),
iSemNota.ToString().Trim());
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
objListNfs.Add(objNFs);
}
else
{
if (drEmit["cd_dupli"].ToString().Contains("/NUM"))
{
if (drEmit["NOTA"].ToString() == "S")
{
iParcela++;
objNFs.sNF = string.Format("{0}{1}",
cdnotafis.Trim(),
dtEmit.Rows.Count > 1 ? Convert.ToChar((64 + iParcela)).ToString() : "");
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
else
{
iSemNota++;
objNFs.sNF = string.Format("{0}/{1}",
Convert.ToInt64(cdnotafis).ToString().PadLeft(5, '0'),
iSemNota.ToString().Trim());
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
objListNfs.Add(objNFs);
}
}
}
if (Acesso.NM_EMPRESA != "DARONYL")
if (objListNfs.Count == 1)
{
objNFs = objListNfs[0];
objNFs.sNF = objListNfs[0].sNF.Replace("-1", "").PadLeft(7, '0'); //Claudinei - o.s. 24103 - 05/02/2010
objListNfs = new List<NotasDuplicatas>();
objListNfs.Add(objNFs);
}
for (int i = 0; i < objListNfs.Count; i++)
{
StringBuilder sSql = new StringBuilder();
string sNumDup = "";
if (objListNfs[i].sNF.Count() > 7)
sNumDup = objListNfs[i].sNF.Substring((objListNfs[i].sNF.Count() - 7), 7);
else
sNumDup = objListNfs[i].sNF.PadLeft(7, '0');
sSql.Append("update ");
sSql.Append("doc_ctr ");
sSql.Append("set cd_dupli = '");
sSql.Append(sNumDup);
sSql.Append("' Where ");
sSql.Append("(cd_empresa = '");
sSql.Append(Acesso.CD_EMPRESA);
sSql.Append("')");
sSql.Append(" and ");
sSql.Append("(nr_doc = '");
sSql.Append(objListNfs[i].sNrDoc);
sSql.Append("')");
HlpDbFuncoes.qrySeekUpdate(sSql.ToString());
}
}
if (Acesso.NM_RAMO == Acesso.BancoDados.INDUSTRIA)
this.BuscaVenctoCancelado(nfseq, cdnotafis, cd_nfse);
}
public void BuscaVencto(string nfseq, string cdnotafis, string cd_nfse = "")
{
string ssGravarCdDupli = HlpDbFuncoes.qrySeekValue("control", "control.cd_conteud", "cd_nivel = '1355'");
string ssGravardteminf = HlpDbFuncoes.qrySeekValue("control", "control.cd_conteud", "cd_nivel = '1363'");
if (ssGravarCdDupli == "S")
{
StringBuilder sSqlDup = new StringBuilder();
//Campos do Select
sSqlDup.Append("Select ");
sSqlDup.Append("doc_ctr.nr_doc, ");
sSqlDup.Append("doc_ctr.cd_documento, ");
sSqlDup.Append("doc_ctr.cd_dupli, doc_ctr.cd_seqped, ");
sSqlDup.Append("'S' Nota ");
//Tabela
sSqlDup.Append("From Doc_ctr ");
//Where
sSqlDup.Append("Where ");
sSqlDup.Append("(doc_ctr.cd_empresa ='");
sSqlDup.Append(Acesso.CD_EMPRESA);
sSqlDup.Append("') ");
sSqlDup.Append("and ");
sSqlDup.Append("(doc_ctr.cd_nfseq = '");
sSqlDup.Append(nfseq);
sSqlDup.Append("') ");
#region MASTERFEW
if (Acesso.NM_EMPRESA == "MASTERFEW")
{
StringBuilder sPedseq = new StringBuilder();
sPedseq.Append("Select ");
sPedseq.Append("pedseq.cd_pedido, ");
sPedseq.Append("pedseq.cd_seqped ");
sPedseq.Append("from pedseq ");
sPedseq.Append("where ");
sPedseq.Append("(pedseq.cd_empresa = '");
sPedseq.Append(Acesso.CD_EMPRESA);
sPedseq.Append("') ");
sPedseq.Append("and ");
sPedseq.Append("(pedseq.cd_nfseq = '");
sPedseq.Append(nfseq);
sPedseq.Append("') ");
DataTable drPedseq = HlpDbFuncoes.qrySeekRet(sPedseq.ToString());
if (drPedseq.Rows.Count > 0)
{
int iSeq = Convert.ToInt16(drPedseq.Rows[0]["cd_seqped"].ToString());
iSeq++;
//União
sSqlDup.Append("Union ");
//Campos do Select
sSqlDup.Append("Select ");
sSqlDup.Append("doc_ctr.nr_doc, ");
sSqlDup.Append("doc_ctr.cd_documento, ");
sSqlDup.Append("doc_ctr.cd_dupli, ");
sSqlDup.Append("'N' Nota ");
//Tabela
sSqlDup.Append("From Doc_ctr ");
//Where
sSqlDup.Append("Where ");
sSqlDup.Append("(doc_ctr.cd_empresa ='");
sSqlDup.Append(Acesso.CD_EMPRESA);
sSqlDup.Append("') ");
sSqlDup.Append("and ");
sSqlDup.Append("(doc_ctr.CD_PEDIDO = '");
sSqlDup.Append(drPedseq.Rows[0]["cd_pedido"].ToString());
sSqlDup.Append("') ");
sSqlDup.Append("and ");
sSqlDup.Append("(doc_ctr.CD_SEQPED = '");
sSqlDup.Append(iSeq.ToString().PadLeft(2, '0'));
sSqlDup.Append("') ");
}
}
#endregion
sSqlDup.Append("order by 1 ");
DataTable dtEmit = HlpDbFuncoes.qrySeekRet(sSqlDup.ToString());
int iParcela = 0;
int iSemNota = 0;
List <NotasDuplicatas> objListNfs = new List <NotasDuplicatas>();
NotasDuplicatas objNFs = new NotasDuplicatas();
string sNumGerador = (cd_nfse != "" ? cd_nfse : cdnotafis).Trim();
foreach (DataRow drEmit in dtEmit.Rows)
{
objNFs = new NotasDuplicatas();
if (!(Acesso.NM_EMPRESA.Equals("LORENZON")))
{
if (drEmit["NOTA"].ToString() == "S")
{
iParcela++;
objNFs.sNF = string.Format("{0}-{1}",
sNumGerador,
iParcela);
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
else
{
iSemNota++;
objNFs.sNF = string.Format("{0}/{1}",
Convert.ToInt64(sNumGerador).ToString().PadLeft(5, '0'),
iSemNota.ToString().Trim());
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
objListNfs.Add(objNFs);
}
else
{
if (drEmit["cd_dupli"].ToString().Contains("/NUM"))
{
if (drEmit["NOTA"].ToString() == "S")
{
iParcela++;
objNFs.sNF = string.Format("{0}{1}",
cdnotafis.Trim(),
dtEmit.Rows.Count > 1 ? Convert.ToChar((64 + iParcela)).ToString() : "");
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
else
{
iSemNota++;
objNFs.sNF = string.Format("{0}/{1}",
Convert.ToInt64(cdnotafis).ToString().PadLeft(5, '0'),
iSemNota.ToString().Trim());
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
objListNfs.Add(objNFs);
}
}
}
if (Acesso.NM_EMPRESA != "DARONYL")
{
if (objListNfs.Count == 1)
{
objNFs = objListNfs[0];
objNFs.sNF = objListNfs[0].sNF.Replace("-1", "").PadLeft(7, '0'); //Claudinei - o.s. 24103 - 05/02/2010
objListNfs = new List <NotasDuplicatas>();
objListNfs.Add(objNFs);
}
}
for (int i = 0; i < objListNfs.Count; i++)
{
StringBuilder sSql = new StringBuilder();
string sNumDup = "";
if (objListNfs[i].sNF.Count() > 7)
{
sNumDup = objListNfs[i].sNF.Substring((objListNfs[i].sNF.Count() - 7), 7);
}
else
{
sNumDup = objListNfs[i].sNF.PadLeft(7, '0');
}
sSql.Append("update ");
sSql.Append("doc_ctr ");
sSql.Append("set cd_dupli = '");
sSql.Append(sNumDup);
sSql.Append("' Where ");
sSql.Append("(cd_empresa = '");
sSql.Append(Acesso.CD_EMPRESA);
sSql.Append("')");
sSql.Append(" and ");
sSql.Append("(nr_doc = '");
sSql.Append(objListNfs[i].sNrDoc);
sSql.Append("')");
HlpDbFuncoes.qrySeekUpdate(sSql.ToString());
}
}
if (Acesso.NM_RAMO == Acesso.BancoDados.INDUSTRIA)
{
this.BuscaVenctoCancelado(nfseq, cdnotafis, cd_nfse);
}
}
public void BuscaVencto()
{
string ssGravarCdDupli = string.Empty;
using (FbCommand cmd = new FbCommand("Select control.cd_conteud from control where cd_nivel = '1355'", Conn))
{
if (ConnectionState.Open != Conn.State)
{
Conn.Open();
}
ssGravarCdDupli = cmd.ExecuteScalar().ToString();
Conn.Close();
}
string ssGravardteminf = string.Empty;
using (FbCommand cmd = new FbCommand("Select control.cd_conteud from control where cd_nivel = '1363'", Conn))
{
if (ConnectionState.Open != Conn.State)
{
Conn.Open();
}
ssGravardteminf = cmd.ExecuteScalar().ToString();
Conn.Close();
}
string sNMCliente = belStatic.sNomeEmpresa;
if (ssGravarCdDupli == "S")
{
StringBuilder sSqlTeste = new StringBuilder();
//Campos do Select
sSqlTeste.Append("Select ");
sSqlTeste.Append("doc_ctr.nr_doc, ");
sSqlTeste.Append("doc_ctr.cd_documento, ");
sSqlTeste.Append("doc_ctr.cd_dupli, ");
sSqlTeste.Append("'S' Nota ");
//Tabela
sSqlTeste.Append("From Doc_ctr ");
//Where
sSqlTeste.Append("Where ");
sSqlTeste.Append("(doc_ctr.cd_empresa ='");
sSqlTeste.Append(_empresa);
sSqlTeste.Append("') ");
sSqlTeste.Append("and ");
sSqlTeste.Append("(doc_ctr.cd_nfseq = '");
sSqlTeste.Append(_nrseq);
sSqlTeste.Append("') ");
#region MASTERFEW
if (sNMCliente == "MASTERFEW")
{
StringBuilder sPedseq = new StringBuilder();
sPedseq.Append("Select ");
sPedseq.Append("pedseq.cd_pedido, ");
sPedseq.Append("pedseq.cd_seqped ");
sPedseq.Append("from pedseq ");
sPedseq.Append("where ");
sPedseq.Append("(pedseq.cd_empresa = '");
sPedseq.Append(_empresa);
sPedseq.Append("') ");
sPedseq.Append("and ");
sPedseq.Append("(pedseq.cd_nfseq = '");
sPedseq.Append(_nrseq);
sPedseq.Append("') ");
//Claudinei - o.s. sem - 15/03/2010
if (ConnectionState.Open != Conn.State)
{
Conn.Open();
}
//Fim - Claudinei - o.s. sem - 15/03/2010
FbCommand cmdPedseq = new FbCommand(sPedseq.ToString(), Conn);
cmdPedseq.ExecuteNonQuery();
FbDataReader drPedseq = cmdPedseq.ExecuteReader();
drPedseq.Read();
int iSeq = Convert.ToInt16(drPedseq["cd_seqped"]);
iSeq++;
//União
sSqlTeste.Append("Union ");
//Campos do Select
sSqlTeste.Append("Select ");
sSqlTeste.Append("doc_ctr.nr_doc, ");
sSqlTeste.Append("doc_ctr.cd_documento, ");
sSqlTeste.Append("doc_ctr.cd_dupli, ");
sSqlTeste.Append("'N' Nota ");
//Tabela
sSqlTeste.Append("From Doc_ctr ");
//Where
sSqlTeste.Append("Where ");
sSqlTeste.Append("(doc_ctr.cd_empresa ='");
sSqlTeste.Append(_empresa);
sSqlTeste.Append("') ");
sSqlTeste.Append("and ");
sSqlTeste.Append("(doc_ctr.CD_PEDIDO = '");
sSqlTeste.Append(drPedseq["cd_pedido"].ToString());
sSqlTeste.Append("') ");
sSqlTeste.Append("and ");
sSqlTeste.Append("(doc_ctr.CD_SEQPED = '");
sSqlTeste.Append(iSeq.ToString().PadLeft(2, '0'));
sSqlTeste.Append("') ");
}
#endregion
sSqlTeste.Append("order by 1 ");
//Clauidnei - o.s. 23801 - 04/11/2009
if (ConnectionState.Open != Conn.State)
{
Conn.Open();
}
FbCommand cmdEmit = new FbCommand(sSqlTeste.ToString(), Conn);
cmdEmit.ExecuteNonQuery();
FbDataReader drEmit = cmdEmit.ExecuteReader();
int iParcela = 0;
int iSemNota = 0;
List<NotasDuplicatas> objListNfs = new List<NotasDuplicatas>();
NotasDuplicatas objNFs = new NotasDuplicatas();
while (drEmit.Read())
{
objNFs = new NotasDuplicatas();
if (!(belStatic.sNomeEmpresa.Equals("LORENZON")))
{
if (drEmit["NOTA"].ToString() == "S")
{
iParcela++;
objNFs.sNF = string.Format("{0}{1}",
_cdnotafis.Trim(),
Convert.ToChar((64 + iParcela)));
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
else
{
iSemNota++;
objNFs.sNF = string.Format("{0}/{1}",
Convert.ToInt64(_cdnotafis).ToString().PadLeft(5, '0'),
iSemNota.ToString().Trim());
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
objListNfs.Add(objNFs);
}
else
{
if (drEmit["cd_dupli"].ToString().Contains("/NUM"))
{
if (drEmit["NOTA"].ToString() == "S")
{
iParcela++;
objNFs.sNF = string.Format("{0}{1}",
_cdnotafis.Trim(),
Convert.ToChar((64 + iParcela)));
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
else
{
iSemNota++;
objNFs.sNF = string.Format("{0}/{1}",
Convert.ToInt64(_cdnotafis).ToString().PadLeft(5, '0'),
iSemNota.ToString().Trim());
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
objListNfs.Add(objNFs);
}
}
}
if (objListNfs.Count == 1)
{
objNFs = objListNfs[0];
objNFs.sNF = objListNfs[0].sNF.Replace("A", "").PadLeft(7, '0'); //Claudinei - o.s. 24103 - 05/02/2010
objListNfs = new List<NotasDuplicatas>();
objListNfs.Add(objNFs);
}
for (int i = 0; i < objListNfs.Count; i++)
{
StringBuilder sSql = new StringBuilder();
sSql.Append("update ");
sSql.Append("doc_ctr ");
sSql.Append("set cd_dupli = '");
sSql.Append(objListNfs[i].sNF);
sSql.Append("' Where ");
sSql.Append("(cd_empresa = '");
sSql.Append(_empresa);
sSql.Append("')");
sSql.Append(" and ");
sSql.Append("(nr_doc = '");
sSql.Append(objListNfs[i].sNrDoc);
sSql.Append("')");
using (FbCommand cmd = new FbCommand(sSql.ToString(), Conn))
{
if (Conn.State != ConnectionState.Open)
{
Conn.Open();
}
cmd.ExecuteNonQuery();
}
}
}
}
public void BuscaVenctoCancelado(string nfseq, string cdnotafis, string cd_nfse = "")
{
bool bExistCampo = HlpDbFuncoes.fExisteCampo("TP_DUPCANC", "EMPRESA");
if (bExistCampo)
{
string sTP_DUPCANC = HlpDbFuncoes.qrySeekValue("EMPRESA", "COALESCE(TP_DUPCANC,'P')", string.Format("CD_EMPRESA = '{0}'", Acesso.CD_EMPRESA));
if (sTP_DUPCANC.Equals("N"))
{
string ssGravarCdDupli = HlpDbFuncoes.qrySeekValue("control", "control.cd_conteud", "cd_nivel = '1355'");
string ssGravardteminf = HlpDbFuncoes.qrySeekValue("control", "control.cd_conteud", "cd_nivel = '1363'");
if (ssGravarCdDupli == "S")
{
//List<string> lPedidos = new List<string>();
//string sQuery = string.Format("select distinct m.cd_pedido from movitem m where m.cd_nfseq = '{0}' and m.cd_empresa = '{1}'", nfseq, Acesso.CD_EMPRESA);
//DataTable drPedidos = HlpDbFuncoes.qrySeekRet(sQuery);
//foreach (DataRow item in drPedidos.Rows)
//{
// lPedidos.Add(item["cd_pedido"].ToString());
//}
//if (lPedidos.Count > 0)
//{
//foreach (string CD_PEDIDO in lPedidos)
//{
StringBuilder sSqlDup = new StringBuilder();
//Campos do Select
sSqlDup.Append("Select ");
sSqlDup.Append("doc_ctr.nr_doc, ");
sSqlDup.Append("doc_ctr.cd_documento, ");
sSqlDup.Append("doc_ctr.cd_dupli, ");
sSqlDup.Append("'S' Nota ");
//Tabela
sSqlDup.Append("From Doc_ctr ");
//Where
sSqlDup.Append("Where ");
sSqlDup.Append("(doc_ctr.cd_empresa ='");
sSqlDup.Append(Acesso.CD_EMPRESA);
sSqlDup.Append("') ");
sSqlDup.Append("and ");
sSqlDup.Append("(doc_ctr.cd_nfseq_conversao = '");
sSqlDup.Append(nfseq);
sSqlDup.Append("') ");
#region MASTERFEW
if (Acesso.NM_EMPRESA == "MASTERFEW")
{
StringBuilder sPedseq = new StringBuilder();
sPedseq.Append("Select ");
sPedseq.Append("pedseq.cd_pedido, ");
sPedseq.Append("pedseq.cd_seqped ");
sPedseq.Append("from pedseq ");
sPedseq.Append("where ");
sPedseq.Append("(pedseq.cd_empresa = '");
sPedseq.Append(Acesso.CD_EMPRESA);
sPedseq.Append("') ");
sPedseq.Append("and ");
sPedseq.Append("(pedseq.cd_nfseq = '");
sPedseq.Append(nfseq);
sPedseq.Append("') ");
DataTable drPedseq = HlpDbFuncoes.qrySeekRet(sPedseq.ToString());
int iSeq = Convert.ToInt16(drPedseq.Rows[0]["cd_seqped"].ToString());
iSeq++;
//União
sSqlDup.Append("Union ");
//Campos do Select
sSqlDup.Append("Select ");
sSqlDup.Append("doc_ctr.nr_doc, ");
sSqlDup.Append("doc_ctr.cd_documento, ");
sSqlDup.Append("doc_ctr.cd_dupli, ");
sSqlDup.Append("'N' Nota ");
//Tabela
sSqlDup.Append("From Doc_ctr ");
//Where
sSqlDup.Append("Where ");
sSqlDup.Append("(doc_ctr.cd_empresa ='");
sSqlDup.Append(Acesso.CD_EMPRESA);
sSqlDup.Append("') ");
sSqlDup.Append("and ");
sSqlDup.Append("(doc_ctr.CD_PEDIDO = '");
sSqlDup.Append(drPedseq.Rows[0]["cd_pedido"].ToString());
sSqlDup.Append("') ");
sSqlDup.Append("and ");
sSqlDup.Append("(doc_ctr.CD_SEQPED = '");
sSqlDup.Append(iSeq.ToString().PadLeft(2, '0'));
sSqlDup.Append("') ");
}
#endregion
sSqlDup.Append("order by 1 ");
DataTable dtEmit = HlpDbFuncoes.qrySeekRet(sSqlDup.ToString());
int iParcela = 0;
int iSemNota = 0;
List <NotasDuplicatas> objListNfs = new List <NotasDuplicatas>();
NotasDuplicatas objNFs = new NotasDuplicatas();
string sNumGerador = (cd_nfse != "" ? cd_nfse : cdnotafis).Trim();
foreach (DataRow drEmit in dtEmit.Rows)
{
objNFs = new NotasDuplicatas();
if (!(Acesso.NM_EMPRESA.Equals("LORENZON")))
{
if (drEmit["NOTA"].ToString() == "S")
{
iParcela++;
objNFs.sNF = string.Format("{0}-{1}",
sNumGerador,
iParcela + 10);
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
else
{
iSemNota++;
objNFs.sNF = string.Format("{0}/{1}",
Convert.ToInt64(sNumGerador).ToString().PadLeft(5, '0'),
iSemNota.ToString().Trim());
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
objListNfs.Add(objNFs);
}
else
{
if (drEmit["cd_dupli"].ToString().Contains("/NUM"))
{
if (drEmit["NOTA"].ToString() == "S")
{
iParcela++;
objNFs.sNF = string.Format("{0}-{1}",
cdnotafis.Trim(),
iParcela);
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
else
{
iSemNota++;
objNFs.sNF = string.Format("{0}/{1}",
Convert.ToInt64(cdnotafis).ToString().PadLeft(5, '0'),
iSemNota.ToString().Trim());
objNFs.sNrDoc = drEmit["NR_DOC"].ToString();
}
objListNfs.Add(objNFs);
}
}
}
if (objListNfs.Count == 1)
{
objNFs = objListNfs[0];
objNFs.sNF = objListNfs[0].sNF.Replace("A", "").PadLeft(7, '0'); //Claudinei - o.s. 24103 - 05/02/2010
objListNfs = new List <NotasDuplicatas>();
objListNfs.Add(objNFs);
}
for (int i = 0; i < objListNfs.Count; i++)
{
StringBuilder sSql = new StringBuilder();
string sNumDup = "";
if (objListNfs[i].sNF.Count() > 7)
{
sNumDup = objListNfs[i].sNF.Substring((objListNfs[i].sNF.Count() - 7), 7);
}
else
{
sNumDup = objListNfs[i].sNF.PadLeft(7, '0');
}
sSql.Append("update ");
sSql.Append("doc_ctr ");
sSql.Append("set cd_dupli = '");
sSql.Append(sNumDup);
sSql.Append("' Where ");
sSql.Append("(cd_empresa = '");
sSql.Append(Acesso.CD_EMPRESA);
sSql.Append("')");
sSql.Append(" and ");
sSql.Append("(nr_doc = '");
sSql.Append(objListNfs[i].sNrDoc);
sSql.Append("')");
HlpDbFuncoes.qrySeekUpdate(sSql.ToString());
}
//}
//}
}
}
}
}
