public void InseriRegistroInutilizado(string sNFini, string sNFfim, string sCdSerie, string sJust) { try { daoGenerator objGen = new daoGenerator(); string sPK = ""; if (!objGen.VerificaExistenciaGenerator("GEN_INUTILIZACAO")) { objGen.CreateGenerator("GEN_INUTILIZACAO", 0); } sPK = objGen.RetornaProximoValorGenerator("GEN_INUTILIZACAO").PadLeft(7, '0'); StringBuilder sQuery = new StringBuilder(); sQuery.Append("INSERT INTO nfinutilizada ("); sQuery.Append("CD_EMPRESA, "); sQuery.Append("CD_NFSEQINUT, "); sQuery.Append("CD_CODFISC, "); sQuery.Append("CD_NOTAFISFIM, "); sQuery.Append("CD_NOTAFISINI, "); sQuery.Append("CD_SERIENF, "); sQuery.Append("CD_STDOC, "); sQuery.Append("DT_CAD, "); sQuery.Append("TP_EMIT, "); sQuery.Append("TP_NOTA, "); sQuery.Append("DS_INUTILIZACAO"); sQuery.Append(")"); sQuery.Append("VALUES ( '{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}');"); string sInsert = string.Format(sQuery.ToString(), Acesso.CD_EMPRESA, sPK, "55", Convert.ToUInt32(sNFfim).ToString().PadLeft(6, '0'), Convert.ToUInt32(sNFini).ToString().PadLeft(6, '0'), sCdSerie, "5", DateTime.Now.ToString("dd.MM.yyyy"), "0", "0", sJust); if (HLP.GeraXml.dao.ADO.HlpDbFuncoes.fExisteCampo("DS_INUTILIZACAO", "nfinutilizada")) { HLP.GeraXml.dao.ADO.HlpDbFuncoes.qrySeekInsert(sInsert); } } catch (Exception ex) { throw ex; } }
public void InseriRegistroInutilizado(string sNFini, string sNFfim, string sCdSerie, string sJust) { try { daoGenerator objGen = new daoGenerator(); string sPK = ""; if (!objGen.VerificaExistenciaGenerator("GEN_INUTILIZACAO")) { objGen.CreateGenerator("GEN_INUTILIZACAO", 0); } sPK = objGen.RetornaProximoValorGenerator("GEN_INUTILIZACAO").PadLeft(7, '0'); StringBuilder sQuery = new StringBuilder(); sQuery.Append("INSERT INTO nfinutilizada ("); sQuery.Append("CD_EMPRESA, "); sQuery.Append("CD_NFSEQINUT, "); sQuery.Append("CD_CODFISC, "); sQuery.Append("CD_NOTAFISFIM, "); sQuery.Append("CD_NOTAFISINI, "); sQuery.Append("CD_SERIENF, "); sQuery.Append("CD_STDOC, "); sQuery.Append("DT_CAD, "); sQuery.Append("TP_EMIT, "); sQuery.Append("TP_NOTA, "); sQuery.Append("DS_INUTILIZACAO"); sQuery.Append(")"); sQuery.Append("VALUES ( '{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}');"); string sInsert = string.Format(sQuery.ToString(), Acesso.CD_EMPRESA, sPK, "55", Convert.ToUInt32(sNFfim).ToString().PadLeft(6, '0'), Convert.ToUInt32(sNFini).ToString().PadLeft(6, '0'), sCdSerie, "5", DateTime.Now.ToString("dd.MM.yyyy"), "0", "0", sJust); if (HLP.GeraXml.dao.ADO.HlpDbFuncoes.fExisteCampo("DS_INUTILIZACAO", "nfinutilizada")) { HLP.GeraXml.dao.ADO.HlpDbFuncoes.qrySeekInsert(sInsert); } } catch (Exception ex) { throw ex; } }