//Alterado para SqlServer private bool ConfigIncrementoCartao(TipoCartao cartao) { BD BD = new BD(); bool config = (BD.ExecuteScalar("select config.INCREMENTCODCARTIMP from config", null).ToString().ToUpper() == "S"); if (config) { if (cartao == 0) { IncrementoTitular(); } else { string cartaoDep; cartaoDep = BD.ExecuteScalar("select codigocartaoimpdep from config", null).ToString(); if (cartaoDep != "") { ConfigCodigoIncremento = (Convert.ToInt32(cartaoDep) + 1).ToString(); BD.ExecuteNoQuery(" update config set codigocartaoimpdep = " + ConfigCodigoIncremento + "", null); } else { IncrementoTitular(); } } } return(config); }
public static bool insereCupomUltimosCupons(string cupom, string serialNumber) { SqlParamsList ps = new SqlParamsList(); ps.Add(new Fields("@serialNumber", serialNumber)); BD BD = new BD(); //deletando possível cupom existente BD.ExecuteScalar("delete from webpos_ultimos_cupons where serial_number = @serialNumber", ps); ps.Add(new Fields("@cupom", cupom)); //inserindo o novo cupom BD.ExecuteScalar("insert into webpos_ultimos_cupons values(@cupom,@serialNumber)", ps); return(Convert.ToInt32(BD.ExecuteScalar("select count(*) from webpos_ultimos_cupons where cupom = @cupom and serial_number = @serialNumber", ps)) > 0); }
private static bool codCardTimpExiste(string codCardTimp) { BD BD = new BD(); string s = (BD.ExecuteScalar("select coalesce(codcartimp,'') as codcartimp from cartoes where codcartimp = '" + codCardTimp.ToString() + "'", null) == null ? "" : codCardTimp); return(s.Equals(codCardTimp)); }
//Alterado para SqlServer public static Double GetCupom(int conv_id, int ano, int mes) { SqlParamsList ps = new SqlParamsList(); ps.Add(new Fields("conv_id", conv_id)); BD BD = new BD(); int empresId = BD.ExecuteScalar(-1, "select top 1 empres_id from conveniados where apagado <> 'S' and conv_id = @conv_id", ps); ps.Add(new Fields("fechamento", DALEmpresa.getDataFechamento(empresId, mes, ano))); ps.Add(new Fields("cod_limite", "N")); DataTable dt = new DataTable(); dt = BD.GetDataTable("exec SALDO_PROXFECHA_CONV " + conv_id + ",N,'" + DALEmpresa.getDataFechamento(empresId, mes, ano) + "'", null); if (dt.Rows.Count != 0) { return(Convert.ToDouble(dt.Rows[0]["TOTAL"])); } else { return(0); } //return Convert.ToDouble(BD.ExecuteScalar("select coalesce(sum(total),0.00) total_saldo from saldo_conv(@conv_id) where fechamento = @fechamento", ps)); }
private void IncrementoTitular() { BD BD = new BD(); ConfigCodigoIncremento = (Int64.Parse(BD.ExecuteScalar("select codigocartaoimp from config", null).ToString()) + 1).ToString(); BD.ExecuteNoQuery(" update config set codigocartaoimp = " + ConfigCodigoIncremento + "", null); }
public static Boolean CredenciadoAceitaParcelamento(int cred_id) { string sql = "SELECT ACEITA_PARC from CREDENCIADOS where cred_id = " + cred_id + ""; BD bd = new BD(); return(bd.ExecuteScalar(sql, null).Equals("S") ? true : false); }
//Alterado para SqlServer public static DateTime ProximoFechamento(int empres_id) { //Pega a proxima data de fechamento menos um dia depois da data atual BD BD = new BD(); return((DateTime)BD.ExecuteScalar("SELECT MIN(data_fecha) FROM dia_fecha WHERE data_fecha >= current_timestamp AND empres_id = " + empres_id, null)); }
public static string EmpresIdPorCartao(string codcartimp) { BD BD = new BD(); SqlParamsList param = new SqlParamsList(); param.Add(new Fields("codcartimp", codcartimp)); return(BD.ExecuteScalar("", "SELECT FIRST 1 CONV.EMPRES_ID FROM CONVENIADOS CONV WHERE CONV.APAGADO <> 'S' and CONV.CONV_ID = (SELECT CARD.CONV_ID FROM CARTOES CARD WHERE CARD.APAGADO <> 'S' AND CARD.CODCARTIMP = @codcartimp)", param)); }
//Alterado para SqlServer public static int CredID(int pos_serial_number) { string sql = " SELECT CRED_ID FROM POS WHERE POS_SERIAL_NUMBER = '" + pos_serial_number + "'"; BD BD = new BD(); int cred_id = (int)BD.ExecuteScalar(sql, null); return(cred_id); }
public static bool getAlteraLimiteSite(int empres_id) { bool status = false; BD bd = new BD(); String sql = "select coalesce(altera_limite_site,'N') from empresas where EMPRES_ID = " + empres_id; if ("S".Equals(bd.ExecuteScalar(sql, null))) { status = true; } else if ("N".Equals(bd.ExecuteScalar(sql, null)) || "".Equals(bd.ExecuteScalar(sql, null))) { status = false; } return(status); }
/// <summary> /// Método que verifica se o credenciado(estabelecimento) /// está liberado para realizar vendas parceladas para uma determinada empresa do /// tipo credito DROGABELLA /// </summary> /// <param name="cred_id"></param> /// <param name="empres_id"></param> /// <returns>bool</returns> public static bool GetVerificaCredLiberadoParcelamentoEspecifico(int cred_id, int empres_id) { bool status = false; BD bd = new BD(); String sql = "select coalesce ((select case cred_id when " + cred_id + " then 'S' else 'N' end from EMP_CRED_DESCONTO_ESPECIFICO WHERE EMPRES_ID = " + empres_id + "),'N')"; if ("S".Equals(bd.ExecuteScalar(sql, null))) { status = true; } else if ("N".Equals(bd.ExecuteScalar(sql, null)) || "".Equals(bd.ExecuteScalar(sql, null))) { status = false; } return(status); }
//Alterado para SqlServer public static int PagaCred(int cred_id) { SqlParamsList ps = new SqlParamsList(); ps.Add(new Fields("@cred_id", cred_id)); BD BD = new BD(); return(BD.ExecuteScalar(-1, "select paga_cred_por_id from credenciados where cred_id = @cred_id", ps)); }
public static int PagamentoCredPor(int cred_id) { string sql; sql = "Select paga_cred_por_id FROM credenciados WHERE cred_id = " + cred_id; BD bd = new BD(); return(Convert.ToInt32(bd.ExecuteScalar(sql, null))); }
public DateTime GetSegundoDiaUtilDoMes(DateTime PrimeiroDiaUtil) { string sql; sql = "SELECT FORMAT(dbo.workday('" + PrimeiroDiaUtil + "'),'dd,MM,yyyy')"; BD BD = new BD(); return(Convert.ToDateTime(BD.ExecuteScalar(sql, null))); }
public static int getCredIdFromCodAcesso(int codAcesso) { SqlParamsList ps = new SqlParamsList(); ps.Add(new Fields("@codAcesso", codAcesso)); BD BD = new BD(); return(BD.ExecuteScalar(-1, "select cred_id from credenciados where codacesso = @codAcesso", ps)); }
public static int getSegmentoID(int cred_id) { SqlParamsList pl = new SqlParamsList(); pl.Add(new Fields("@cred_id", cred_id)); BD bd = new BD(); return(bd.ExecuteScalar(-1, "select seg_id from credenciados where cred_id = @cred_id", pl)); }
//Alterado para SqlServer public static String getEmail(int empres_id) { SqlParamsList ps = new SqlParamsList(); ps.Add(new Fields("@empres_id", empres_id)); BD BD = new BD(); return(BD.ExecuteScalar("", "select email from empresas where empres_id = @empres_id", ps).ToString()); }
//Alterado para SqlServer public static int getCodAcessoPorCredId(int id) { SqlParamsList ps = new SqlParamsList(); ps.Add(new Fields("@id", id)); BD BD = new BD(); return(BD.ExecuteScalar(-1, "select codacesso from credenciados where cred_id = @id", ps)); }
//Alterado para SqlServer public static int GetTipoCredito(int empres_id) { string sql = "select top 1 tipo_credito from empresas where empres_id = @empres_id"; BD BD = new BD(); SqlParamsList ps = new SqlParamsList(); ps.Add(new Fields("empres_id", empres_id)); return(BD.ExecuteScalar(-1, sql, ps)); }
public static string SNumAutorizacao(string transID) { SqlParamsList ps = new SqlParamsList(); ps.Add(new Fields("@transID", transID)); BD BD = new BD(); return(BD.ExecuteScalar("select top 1 autor_id from autor_transacoes where trans_id = @transID", ps).ToString()); }
//Alterado para SqlServer public static DateTime getDataVenda(string trans_id) { SqlParamsList ps = new SqlParamsList(); ps.Add(new Fields("@trans_id", trans_id)); BD BD = new BD(); return(Convert.ToDateTime(BD.ExecuteScalar("select top 1 datavenda from contacorrente where trans_id = @trans_id", ps))); }
public static string GetUsaLimiteDeCredito(int empres_id) { string sql = "select usa_limite_max from empresas where empres_id = @empres_id"; BD BD = new BD(); SqlParamsList pl = new SqlParamsList(); pl.Add(new Fields("empres_id", empres_id)); return(BD.ExecuteScalar(sql, pl).ToString()); }
public static decimal GetValorMaximoDoLimiteConv(int empres_id) { string sql = "select limite_max_por_conv from empresas where empres_id = @empres_id"; BD BD = new BD(); SqlParamsList pl = new SqlParamsList(); pl.Add(new Fields("empres_id", empres_id)); return(Convert.ToDecimal(BD.ExecuteScalar(sql, pl))); }
//Alterado para Sqlserver public static int GetModCartao(int empres_id) { string sql = "select top 1 mod_cart_id from empresas where empres_id = @empres_id"; BD BD = new BD(); SqlParamsList ps = new SqlParamsList(); ps.Add(new Fields("empres_id", empres_id)); return(BD.ExecuteScalar(-1, sql, ps)); }
public static String getCNPJ(int credID) { SqlParamsList ps = new SqlParamsList(); ps.Add(new Fields("@cred_id", credID)); BD BD = new BD(); return(BD.ExecuteScalar("", "select CGC from credenciados where cred_id = @cred_id", ps).ToString()); }
/// <summary> /// Retorna se estabelecimento utiliza recarga a vista, convenio ou os dois /// </summary> /// <param name="numSerie"></param> /// <returns>V - a vista, C - Convenio, T - os dois</returns> //Alterado para SqlServer public static string TipoRecarga(string numSerie) { SqlParamsList ps = new SqlParamsList(); ps.Add(new Fields("@serial_number", numSerie)); BD BD = new BD(); return(BD.ExecuteScalar("select tipo_recarga from pos where pos_serial_number = @serial_number", ps).ToString()); }
public static string NumDigito(string transID) { SqlParamsList ps = new SqlParamsList(); ps.Add(new Fields("@transID", transID)); BD BD = new BD(); return(BD.ExecuteScalar("select top 1 digito from contacorrente where trans_id = @transID", ps).ToString()); }
/// <summary> /// /// </summary> /// <param name="serial_number"></param> /// <param name="cred_id"></param> /// <returns></returns> public static string getUltimoCupom(string numSerie) { SqlParamsList ps = new SqlParamsList(); ps.Add(new Fields("@serial_number", numSerie)); BD BD = new BD(); string cupom = Convert.ToString(BD.ExecuteScalar("select top 1 cupom from webpos_ultimos_cupons where serial_number = @serial_number", ps)); return(cupom); }
public static string GetVersaoNavs(string numSerie) { SqlParamsList ps = new SqlParamsList(); ps.Add(new Fields("@serial_number", numSerie)); BD BD = new BD(); string s = Convert.ToString(BD.ExecuteScalar("", "select p.versao_navs from pos p where p.pos_serial_number = @serial_number", ps)); return(s); }
//Alterado para SqlServer public static string GetExibiDIRF(int cred_id) { string sql = "SELECT coalesce(exibir_dirf,'N') FROM credenciados WHERE apagado <> 'S' AND cred_id = @credID"; SqlParamsList ps = new SqlParamsList(); ps.Add(new Fields("@credID", cred_id)); BD BD = new BD(); return(BD.ExecuteScalar(sql, ps).ToString()); }