Example #1
0
        public string ValidaLogin(string sLogin, string sSenha)
        {
            sql.AppendFormat("EXEC SP_AUTENTICA_USUARIO @login = '******', @dc_senha = '{1}' ", sLogin.Trim(), sSenha.Trim());

            return(cn.DataTableToJSON(cn.SelectAccessDBSqlServer(sql.ToString())));
        }
Example #2
0
        public string InserePedido(int idCliente, int idLogin)
        {
            sql.AppendFormat("exec SP_PEDIDO @IDCLIENTE = {0}, @IDUSUARIO = {1};", idCliente, idLogin);

            return(cn.DataTableToJSON(cn.SelectAccessDBSqlServer(sql.ToString())));
        }
Example #3
0
        public string ListaMaterial()
        {
            sql.Append("SELECT id_material, cod_material, dc_material FROM TB_MATERIAL");

            return(cn.DataTableToJSON(cn.SelectAccessDBSqlServer(sql.ToString())));
        }